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 |