Stores information about the extended DFF Attributes. This table Contains all the Extended DFF tables and its corresponding attributes and labels.
Module:
DW_TABLE_NAME, DW_COLUMN_NAME, DATASOURCE_CODE
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
DATASOURCE_CODE | VARCHAR2 | 32 | True | Datasource code. | |||
DW_TABLE_NAME | VARCHAR2 | 128 | True | DFF Target table name | |||
DW_COLUMN_NAME | VARCHAR2 | 128 | True | DFF Attribute Name | |||
DW_DATA_TYPE | VARCHAR2 | 32 | DFF Data Type | ||||
DW_DATA_LENGTH | VARCHAR2 | 16 | DFF Data Length | ||||
DW_DATA_SCALE | VARCHAR2 | 16 | DFF Data scale | ||||
DW_IS_PRIMARY | VARCHAR2 | 16 | DFF IS Primary Column | ||||
DISPLAY_LABEL | VARCHAR2 | 999 | DFF Prompt Value | ||||
COLUMN_ORDER | VARCHAR2 | 16 | DFF column position | ||||
SOURCE_TYPE_CODE | VARCHAR2 | 64 | Source type code for example fusion or netsuite | ||||
TABLE_TYPE | VARCHAR2 | 32 | Table type either DFF or DE | ||||
FUNCTIONAL_AREA_CODE | VARCHAR2 | 256 | Functional area code | ||||
CLASS_CODE | VARCHAR2 | 256 | Represents the custom object generation source application. | ||||
IS_HIDDEN | VARCHAR2 | 16 | If column need to be hidden. |
Copyright © 2019, 2023, Oracle and/or its affiliates.