GL_ENC_CARRY_FORWARD_ACCTS_
GL_ENC_CARRY_FORWARD_ACCTS contains the accounts to be processed for a General Ledger encumbrance balances carry forward. Each row includes the carry forward rule identifier and the account filter. Each account filter stored in this table should be related to one and only one General Ledger encumbrance balances carry forward rule defined in GL_ENC_CARRY_FORWARD_RULES.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
GL_ENC_CARRY_FORWARD_ACCT_PK_ |
LAST_UPDATE_DATE, LAST_UPDATED_BY, ENC_CARRY_FORWARD_ACCTS_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
ENC_CARRY_FORWARD_ACCTS_ID | NUMBER | 18 | Yes | Encumbrance carry forward account filter defining column. | |
ENC_CARRY_FORWARD_RULE_ID | NUMBER | 18 | Encumbrance carry forward rule defining column. | ||
FLEX_FILTER | XMLTYPE | Key flexfield filter defining column. | |||
SEGMENT1_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | ||
SEGMENT1_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | ||
SEGMENT1_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | ||
SEGMENT2_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | ||
SEGMENT2_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | ||
SEGMENT2_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | ||
SEGMENT3_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | ||
SEGMENT3_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | ||
SEGMENT3_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | ||
SEGMENT4_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | ||
SEGMENT4_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | ||
SEGMENT4_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | ||
SEGMENT5_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | ||
SEGMENT5_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | ||
SEGMENT5_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | ||
SEGMENT6_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | ||
SEGMENT6_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | ||
SEGMENT6_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | ||
SEGMENT7_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | ||
SEGMENT7_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | ||
SEGMENT7_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | ||
SEGMENT8_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | ||
SEGMENT8_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | ||
SEGMENT8_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | ||
SEGMENT9_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | ||
SEGMENT9_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | ||
SEGMENT9_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | ||
SEGMENT10_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | ||
SEGMENT10_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | ||
SEGMENT10_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | ||
SEGMENT11_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | ||
SEGMENT11_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | ||
SEGMENT11_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | ||
SEGMENT12_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | ||
SEGMENT12_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | ||
SEGMENT12_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | ||
SEGMENT13_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | ||
SEGMENT13_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | ||
SEGMENT13_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | ||
SEGMENT14_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | ||
SEGMENT14_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | ||
SEGMENT14_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | ||
SEGMENT15_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | ||
SEGMENT15_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | ||
SEGMENT15_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | ||
SEGMENT16_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | ||
SEGMENT16_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | ||
SEGMENT16_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | ||
SEGMENT17_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | ||
SEGMENT17_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | ||
SEGMENT17_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | ||
SEGMENT18_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | ||
SEGMENT18_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | ||
SEGMENT18_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | ||
SEGMENT19_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | ||
SEGMENT19_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | ||
SEGMENT19_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | ||
SEGMENT20_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | ||
SEGMENT20_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | ||
SEGMENT20_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | ||
SEGMENT21_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | ||
SEGMENT21_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | ||
SEGMENT21_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | ||
SEGMENT22_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | ||
SEGMENT22_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | ||
SEGMENT22_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | ||
SEGMENT23_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | ||
SEGMENT23_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | ||
SEGMENT23_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | ||
SEGMENT24_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | ||
SEGMENT24_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | ||
SEGMENT24_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | ||
SEGMENT25_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | ||
SEGMENT25_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | ||
SEGMENT25_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | ||
SEGMENT26_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | ||
SEGMENT26_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | ||
SEGMENT26_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | ||
SEGMENT27_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | ||
SEGMENT27_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | ||
SEGMENT27_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | ||
SEGMENT28_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | ||
SEGMENT28_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | ||
SEGMENT28_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | ||
SEGMENT29_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | ||
SEGMENT29_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | ||
SEGMENT29_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | ||
SEGMENT30_LOW | VARCHAR2 | 25 | Key flexfield segment low range column. | ||
SEGMENT30_HIGH | VARCHAR2 | 25 | Key flexfield segment high range column. | ||
SEGMENT30_TREE_CODE | VARCHAR2 | 30 | Key flexfield segment tree code column. | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
OBJECT_VERSION_NUMBER | NUMBER | 9 | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
AUDIT_ACTION_TYPE_ | VARCHAR2 | 10 | Action Type - have values like INSERT, UPDATE and DELETE. | ||
AUDIT_CHANGE_BIT_MAP_ | VARCHAR2 | 1000 | Used to store a bit map of 1s and 0s for each column in the table. | ||
AUDIT_IMPERSONATOR_ | VARCHAR2 | 64 | Original Impersonator User. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
GL_ENC_CARRY_FORWARD_ACCTS_U1_ | Unique | FUSION_TS_TX_DATA | LAST_UPDATE_DATE, LAST_UPDATED_BY, ENC_CARRY_FORWARD_ACCTS_ID |
GL_ENC_CARRY_FWD_ACCTS_N1_ | Non Unique | Default | ENC_CARRY_FORWARD_ACCTS_ID |