Please find the BIAPPS columns and their standard datatypes in below table.
COLUMN | DATATYPE |
_WID | NUMBER(10) |
_.AMT/_QTY | NUMBER(28,10) |
_ID | VARCHAR2(80 CHAR) |
CODE | VARCHAR2(30 CHAR) |
_FLAG | CHAR(1) |
INTEGRATION_ID | VARCHAR2(80 CHAR) -- Dimension VARCHAR2(400 CHAR) -- Fact |
DATASOURCE_NUM_ID | NUMBER(10) |
ETL_PROC_WID | NUMBER(10) |
X_CUSTOM | VARCHAR2(10 CHAR) |
TENANT_ID | VARCHAR2(80 CHAR) |
No comments:
Post a Comment