Data type on Oracle DB for currency, boolean and phone property inside Pega7.2
I'm creating tables on Oracle DB for inserting PageList data inside Pega7.2.
The PageList has a currency, boolean and phone type property.
What type should I use inside Oracle for creating a table?
Pega Oracle
Text(Single line) Varchar2(100 byte)
Integer NUMBER(15,0)
Date only Date
Currency ?????
Boolean ?????
Phone ?????
ex)
CREATE TABLE "YAKUJO_MOTO"
("YAKUJOYMD" DATE,
"TORIATSUKAITSUKA" VARCHAR2(100 BYTE),
"YAKUJONO" NUMBER(15,0),
"HAKKOTAIKYOJUKBN" VARCHAR2(100 BYTE),
"TORIHIKISYURUI" VARCHAR2(100 BYTE),
"HAKKOTAIKOKUSEKI" VARCHAR2(100 BYTE),
"SYOKENSYURUI" VARCHAR2(100 BYTE),
"MEIGARAMEI" VARCHAR2(100 BYTE),
"SYOKENCHOTANKBN" VARCHAR2(100 BYTE),
"YAKUJOTORIHIKIKBN" VARCHAR2(100 BYTE),
"SHOKENTSUKA" VARCHAR2(100 BYTE),
Thank you for your help in advance,
Teruyuki