XCC_ARCHIVE_PURGE_GT
This temporary table is used by the archive and purge process to copy budget entries and activities from the original table to the history table.
Details
-
Schema: FUSION
-
Object owner: XCC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
XCC_ARCHIVE_PURGE_GT_PK |
HEADER_NUM, LINE_NUM, BALANCE_LINE_ORDER, CONTROL_BUDGET_ID, BUDGET_CCID, PERIOD_NAME, BUDGET_ACTION, MASTER_PERIOD_NAME |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
HEADER_NUM | VARCHAR2 | 100 | Yes | Transaction that is archived and purged. | |
LINE_NUM | NUMBER | 18 | Yes | Line number that is archived and purged. | |
BALANCE_LINE_ORDER | VARCHAR2 | 100 | Yes | Activity that is archived and purged. For budget data, the default value is -9. | |
CONTROL_BUDGET_ID | NUMBER | 18 | Yes | Control budget that is archived and purged. | |
PERIOD_NAME | VARCHAR2 | 15 | Yes | Period that is archived and purged. | |
BUDGET_CCID | NUMBER | 18 | Yes | Budget account that is archived and purged. | |
BUDGET_ACTION | VARCHAR2 | 30 | Yes | Indicates whether the distribution account row is for balance initialization or adjustment. | |
MASTER_PERIOD_NAME | VARCHAR2 | 15 | Yes | Period name of source control budget. |
Indexes
Index | Uniqueness | Columns |
---|---|---|
XCC_ARCHIVE_PURGE_GT_U1 | Unique | HEADER_NUM, LINE_NUM, BALANCE_LINE_ORDER, CONTROL_BUDGET_ID, BUDGET_CCID, PERIOD_NAME, BUDGET_ACTION, MASTER_PERIOD_NAME |