TDATASEG Table Definition Reference
Table B-2 TDATASEG Table Reference
TDATASEG Column Name | TDATASEG Definition | TDATASEG Description |
---|---|---|
DATAKEY | NUMBER(31,0) NOT NULL ENABLE | System generated unique key for each row of data |
PARTIONNKEY | NUMBER(10,0) NOT NULL ENABLE | Location key. Join to TPOVPARTITION to retrieve location information. |
CATKEY | NUMBER(10,0) NOT NULL ENABLE | Category Key. Join to TPOVCATEGORY to retrieve category information. |
PERIODKEY | DATE NOT NULL ENABLE | Period Key. Join to TPOVPERIOD to retrieve Data Management to EPM period mapping details. |
DATAVIEW | VARCHAR2(20 CHAR) DEFAULT 'YTD' NOT NULL ENABLE | Hard coded to YTD for file, and set to YTD for balance sheet and PTD for income statement when pulling data from an Enterprise Resource Planning (ERP) system. |
CURKEY | VARCHAR2(25 CHAR) DEFAULT | Currency code of the data. |
CALCACCTTYPE | NUMBER(6,0) DEFAULT 9 NOT NULL ENABLE | Indicates if row was imported from source or computed by Logic
Group:
|
CHANGESIGN | NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE | Indicates that the sign of the imported amount should be
reversed:
|
JOURNALID | VARCHAR2(80 CHAR) DEFAULT | ID for the Journal. User provided value |
AMOUNT | NUMBER(38,12) DEFAULT 0 NOT NULL ENABLE | Amount loaded from source |
AMOUNTX | NUMBER(38, 12) DEFAULT 0 NOT NULL ENABLE | Amount after any transformation rules. This value is loaded to the target application. |
DESC1 | VARCHAR2(300 CHAR) DEFAULT | Description can be imported from file |
DESC2 | VARCHAR2(300 CHAR) DEFAULT | Description can be imported from file |
ACCOUNT | VARCHAR2(300 CHAR) NOT NULL ENABLE | Account member from source |
ACCOUNTX | VARCHAR2(2000 CHAR) DEFAULT | Account member after mapping rules processed |
ACCOUNTR | NUMBER(10,0) DEFAULT 0 NOT NULL ENABLE | Key to Mapping used for this dimension. Refers to DATAKEY in TDATAMAPSEG. |
ACCOUNTF | NUMBER(6,0) DEFAULT 0 NOT NULL ENABLE | Map types:
|
ENTITY | VARCHAR2(300 CHAR) DEFAULT | Entity member from source |
ENTITYX | VARCHAR2(300 CHAR) DEFAULT | Entity member after mapping rules processed. This value is exported. |
ENTITYR | NUMBER(10,0) DEFAULT 0 NOT NULL ENABLE | Key to Mapping used for this dimension. Refers to DATAKEY in TDATAMAPSEG |
ENTITYF | NUMBER(6,0) DEFAULT 0 NOT NULL ENABLE | Map types:
|
ICP | VARCHAR2(300 CHAR) DEFAULT | ICP from source |
ICPX | VARCHAR2(300 CHAR) DEFAULT | ICP after mapping rules processed. This value is exported. |
ICPR | NUMBER(10,0) DEFAULT 0 NOT NULL ENABLE | Key to mapping used for this dimension. Refers to DATAKEY in TDATAMAPSEG. |
ICPF | NUMBER(6,0) DEFAULT 0 NOT NULL ENABLE | Map type:
|
UD1 | VARCHAR2(280 CHAR) DEFAULT | UD1 from source |
UD1X | VARCHAR2(280 CHAR) DEFAULT | UD1 after mapping rules processed. This value is exported. |
UD1R | VARCHAR2(10, 0 CHAR) DEFAULT | Key to mapping used for this dimension. Refers to DATAKEY in TDATAMAPSEG |
UD1F | VARCHAR2(6, 0 CHAR) DEFAULT 0 NOT NULL ENABLE | Map type:
|
UD2 | VARCHAR2(300 CHAR) DEFAULT | UD2 from source |
UD2X | VARCHAR2(300 CHAR) DEFAULT | UD2X from source |
UD2R | VARCHAR2(10, 0 CHAR) DEFAULT | UD2R from source |
UD2F | VARCHAR2(6, 0 CHAR) DEFAULT 0 NOT NULL ENABLE | UD2F from source |
UD3 | VARCHAR2(300 CHAR) DEFAULT | UD3 from source |
UD3X | VARCHAR2(300 CHAR) DEFAULT | UD3X from source |
UD3R | VARCHAR2(10, 0 CHAR) DEFAULT | UD3R from source |
UD3F | VARCHAR2(6, 0 CHAR) DEFAULT 0 NOT NULL ENABLE | UD3F from source |
UD4 | VARCHAR2(300 CHAR) DEFAULT | UD4 from source |
UD4X | VARCHAR2(300 CHAR) DEFAULT | UD4X from source |
UD4R | VARCHAR2(10, 0 CHAR) DEFAULT | UD4R from source |
UD4F | VARCHAR2(6, 0 CHAR) DEFAULT 0 NOT NULL ENABLE | UD4F from source |
UD5 | VARCHAR2(300 CHAR) DEFAULT | UD5 from source |
UD5X | VARCHAR2(300 CHAR) DEFAULT | UD5X from source |
UD5R | VARCHAR2(10, 0 CHAR) DEFAULT | UD5R from source |
UD5F | VARCHAR2(6, 0 CHAR) DEFAULT 0 NOT NULL ENABLE | UD5F from source |
UD6 | VARCHAR2(300 CHAR) DEFAULT | UD6 from source |
UD6X | VARCHAR2(300 CHAR) DEFAULT | UD6X from source |
UD6R | VARCHAR2(10, 0 CHAR) DEFAULT | UD6R from source |
UD6F | VARCHAR2(6, 0 CHAR) DEFAULT 0 NOT NULL ENABLE | UD6F from source |
UD7 | VARCHAR2(300 CHAR) DEFAULT | UD7 from source |
UD7X | VARCHAR2(300 CHAR) DEFAULT | UD7X from source |
UD7R | VARCHAR2(10, 0 CHAR) DEFAULT | UD7R from source |
UD7F | VARCHAR2(6, 0 CHAR) DEFAULT 0 NOT NULL ENABLE | UD7F from source |
UD8 | VARCHAR2(300 CHAR) DEFAULT | UD8 from source |
UD8X | VARCHAR2(300 CHAR) DEFAULT | UD8X from source |
UD8R | VARCHAR2(10, 0 CHAR) DEFAULT | UD8R from source |
UD8F | VARCHAR2(6, 0 CHAR) DEFAULT 0 NOT NULL ENABLE | UD8F from source |
ARCHIVEID | NUMBER(31,0) DEFAULT 0 NOT NULL ENABLE | Future use |
HASMEMOITEM | NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE | Future use |
STATICDATAKEY | NUMBER(31,0) DEFAULT 0 NOT NULL ENABLE | Future use |
UD9 | VARCHAR2(300 CHAR) DEFAULT | UD9 from source |
UD9X | VARCHAR2(300 CHAR) DEFAULT | UD9X from source |
UD9R | VARCHAR2(10, 0 CHAR) DEFAULT | UD9R from source |
UD9F | VARCHAR2(6, 0 CHAR) DEFAULT 0 NOT NULL ENABLE | UD9F from source |
UD10 | VARCHAR2(300 CHAR) DEFAULT | UD10 from source |
UD10X | VARCHAR2(300 CHAR) DEFAULT | UD10X from source |
UD10R | VARCHAR2(10, 0 CHAR) DEFAULT | UD10R from source |
UD10F | VARCHAR2(6, 0 CHAR) DEFAULT 0 NOT NULL ENABLE | UD10F from source |
UD11 | VARCHAR2(300 CHAR) DEFAULT | UD11 from source |
UD11X | VARCHAR2(300 CHAR) DEFAULT | UD11X from source |
UD11R | VARCHAR2(10, 0 CHAR) DEFAULT | UD11R from source |
UD11F | VARCHAR2(6, 0 CHAR) DEFAULT 0 NOT NULL ENABLE | UD11F from source |
UD12 | VARCHAR2(300 CHAR) DEFAULT | UD12 from source |
UD12X | VARCHAR2(300 CHAR) DEFAULT | UD12X from source |
UD12R | VARCHAR2(10, 0 CHAR) DEFAULT | UD12R from source |
UD12F | VARCHAR2(6, 0 CHAR) DEFAULT 0 NOT NULL ENABLE | UD12F from source |
UD13 | VARCHAR2(300 CHAR) DEFAULT | UD13 from source |
UD13X | VARCHAR2(300 CHAR) DEFAULT | UD13X from source |
UD13R | VARCHAR2(10, 0 CHAR) DEFAULT | UD13R from source |
UD13F | VARCHAR2(6, 0 CHAR) DEFAULT 0 NOT NULL ENABLE | UD13F from source |
UD14 | VARCHAR2(300 CHAR) DEFAULT | UD14 from source |
UD14X | VARCHAR2(300 CHAR) DEFAULT | UD14X from source |
UD14R | VARCHAR2(10, 0 CHAR) DEFAULT | UD14R from source |
UD14F | VARCHAR2(6, 0 CHAR) DEFAULT 0 NOT NULL ENABLE | UD14F from source |
UD15 | VARCHAR2(80 CHAR) DEFAULT | UD15 from source |
UD15X | VARCHAR2(300 CHAR) DEFAULT | UD15X from source |
UD15R | VARCHAR2(10, 0 CHAR) DEFAULT | UD15R from source |
UD15F | VARCHAR2(6, 0 CHAR) DEFAULT 0 NOT NULL ENABLE | UD15F from source |
UD16 | VARCHAR2(300 CHAR) DEFAULT | UD16 from source |
UD16X | VARCHAR2(300 CHAR) DEFAULT | UD16X from source |
UD16R | VARCHAR2(10, 0 CHAR) DEFAULT | UD16R from source |
UD16F | VARCHAR2(6, 0 CHAR) DEFAULT 0 NOT NULL ENABLE | UD16F from source |
UD17 | VARCHAR2(300 CHAR) DEFAULT | UD17 from source |
UD17X | VARCHAR2(300 CHAR) DEFAULT | UD1X from source |
UD17R | VARCHAR2(10, 0 CHAR) DEFAULT | UD17R from source |
UD17F | VARCHAR2(6, 0 CHAR) DEFAULT 0 NOT NULL ENABLE | UD17F from source |
UD18 | VARCHAR2(300 CHAR) DEFAULT | UD18 from source |
UD18X | VARCHAR2(300 CHAR) DEFAULT | UD18X from source |
UD18R | VARCHAR2(10, 0 CHAR) DEFAULT | UD18R from source |
UD18F | VARCHAR2(6, 0 CHAR) DEFAULT 0 NOT NULL ENABLE | UD18F from source |
UD19 | VARCHAR2(300 CHAR) DEFAULT | UD19 from source |
UD19X | VARCHAR2(300 CHAR) DEFAULT | UD19X from source |
UD19R | VARCHAR2(10, 0 CHAR) DEFAULT | UD19R from source |
UD19F | VARCHAR2(6, 0 CHAR) DEFAULT 0 NOT NULL ENABLE | UD19F from source |
UD20 | VARCHAR2(300 CHAR) DEFAULT | UD20 from source |
UD20X | VARCHAR2(300 CHAR) DEFAULT | UD20X from source |
UD20R | VARCHAR2(10, 0 CHAR) DEFAULT | UD20R from source |
UD20F | VARCHAR2(6, 0 CHAR) DEFAULT 0 NOT NULL ENABLE | UD20F from source |
ATTR1 | VARCHAR2(300 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
ATTR2 | VARCHAR2(300 CHAR) DEFAULT |
User defined attribute - used as needed for mapping or drill-through Note: When importing data from Financial Consolidation and Close, attribute columns ATTR2 and ATTR3 should not be used for any other dimension mappings. |
ATTR3 | VARCHAR2(300 CHAR) DEFAULT |
User defined attribute - used as needed for mapping or drill-through Note: When importing data from Financial Consolidation and Close, attribute columns ATTR2 and ATTR3 should not be used for any other dimension mappings. |
ATTR4 | VARCHAR2(300 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
ATTR5 | VARCHAR2(300 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
ATTR6 | VARCHAR2(300 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
ATTR7 | VARCHAR2(300 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
ATTR8 | VARCHAR2(300 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
ATTR9 | VARCHAR2(300 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
ATTR10 | VARCHAR2(300 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
ATTR11 | VARCHAR2(300 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
ATTR12 | VARCHAR2(300 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
ATTR13 | VARCHAR2(300 CHAR) DEFAULT | Restricted. Used to store the "Logic Item" if a logic group is assigned to a location. |
ATTR14 | VARCHAR2(300 CHAR) DEFAULT | User defined attribute - used as needed for mapping or drill-through |
ATTR15 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR16 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR17 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR18 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR19 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR20 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR21 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR22 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR23 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR24 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR25 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR26 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR27 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR28 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR29 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR30 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR31 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR32 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR33 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR34 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR35 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR36 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR37 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR38 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR39 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
ATTR40 | VARCHAR2(300 CHAR) | User defined attribute - used as needed for mapping or drill-through |
DATA | VARCHAR2(2000 CHAR) | |
DATAX | VARCHAR2(2000 CHAR) | |
DATAR | NUMBER(10,0) DEFAULT 0 NOT NULL ENABLE | |
DATAF | NUMBER(6,0) DEFAULT 0 NOT NULL ENABLE | |
CODE_COMBINATION_ID | VARCHAR2(500 CHAR) | Used for integration with Oracle E-Business Suite. |
AMOUNT_YTD | NUMBER(29,12) | YTD Amount. Used for E-Business Suite, Peoplesoft, Fusion data sources |
AMOUNT_PTD | NUMBER(29,12) | PTD Amount. Used for E-Business Suite, Peoplesoft, Fusion data sources |
LOADID | NUMBER(15,0) | Process ID that created or updated this row. |
RULE_ID | NUMBER(15,0) | Data Rule ID used to create this row. Join to AIF_BALANCE_RULES for details. |
STAT_BALANCE_FLAG | VARCHAR2(1 CHAR) | Indicates if balance is a statistic:
|
VALID_FLAG | VARCHAR2(1 CHAR) | Indicates if row has valid mappings:
|