GL_DAILY_POST_INT1
This table is used for internal processing only
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: Default
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
LEDGER_ID | NUMBER | 18 | Yes | This column is used for internal processing only | |
CODE_COMBINATION_ID | NUMBER | 18 | Yes | This column is used for internal processing only | |
EFFECTIVE_PERIOD_NUM | NUMBER | 18 | Yes | This column is used for internal processing only | |
ACCOUNTING_DATE | DATE | Yes | This column is used for internal processing only | ||
ACTUAL_FLAG | VARCHAR2 | 1 | Yes | This column is used for internal processing only | |
CURRENCY_CODE | VARCHAR2 | 15 | Yes | This column is used for internal processing only | |
CURRENCY_TYPE | VARCHAR2 | 1 | Yes | This column is used for internal processing only | |
PERIOD_NAME | VARCHAR2 | 15 | Yes | This column is used for internal processing only | |
PERIOD_YEAR | NUMBER | 18 | Yes | This column is used for internal processing only | |
PERIOD_NUM | NUMBER | 18 | Yes | This column is used for internal processing only | |
QUARTER_NUM | NUMBER | 18 | Yes | This column is used for internal processing only | |
NET_INCOME_ACCOUNT_FLAG | VARCHAR2 | 1 | Yes | This column is used for internal processing only | |
BAL_SEG_VALUE_1 | VARCHAR2 | 25 | Yes | This column is used for internal processing only | |
BAL_SEG_VALUE_2 | VARCHAR2 | 25 | This column is used for internal processing only | ||
BAL_SEG_VALUE_3 | VARCHAR2 | 25 | This column is used for internal processing only | ||
CONVERTED_FROM_CURRENCY | VARCHAR2 | 15 | This column is used for internal processing only | ||
ENTERED_AMOUNT | NUMBER | This column is used for internal processing only | |||
ACCOUNTED_AMOUNT | NUMBER | This column is used for internal processing only | |||
ACCOUNT_TYPE | VARCHAR2 | 1 | Key flexfield combination type (Asset, Liability, etc). |
Indexes
Index | Uniqueness | Columns |
---|---|---|
GL_DAILY_POST_INT1_N1 | Non Unique | CODE_COMBINATION_ID, CURRENCY_CODE, ACCOUNTING_DATE |