XCC_TR_LINES_HISTORY
This table contains budgetary control transaction lines that have been purged from the regular XCC_TR_LINES table. You must save the contents of this table for audit purposes. You can also archive them to some other storage location.
Details
-
Schema: FUSION
-
Object owner: XCC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
XCC_TR_LINES_HISTORY_PK |
HEADER_NUM, LINE_NUM |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| HEADER_NUM | VARCHAR2 | 100 | Yes | Budgetary control transaction identifier. | |
| LINE_NUM | NUMBER | 18 | Yes | Line number to uniquely identify the transaction line within the transaction. | |
| LINE_GROUP_CODE | VARCHAR2 | 30 | Group of lines with which this line must be associated. | ||
| TRANSACTION_SUBTYPE_CODE | VARCHAR2 | 30 | Transaction subtype associated with this line. | ||
| SOURCE_TRANSACTION_TYPE_CODE | VARCHAR2 | 30 | Yes | Identifies the type of transaction. | |
| SOURCE_LINE_ID_1 | VARCHAR2 | 30 | Yes | Primary key for subledger or general ledger distribution or line. | |
| SOURCE_LINE_ID_2 | VARCHAR2 | 30 | Yes | Primary key for subledger or general ledger distribution or line. | |
| SOURCE_LINE_ID_3 | VARCHAR2 | 30 | Yes | Primary key for subledger or general ledger distribution or line. | |
| SOURCE_LINE_ID_4 | VARCHAR2 | 30 | Yes | Primary key for subledger or general ledger distribution or line. | |
| SOURCE_LINE_ID_5 | VARCHAR2 | 30 | Yes | Primary key for subledger or general ledger distribution or line. | |
| SOURCE_LINE_ID_6 | VARCHAR2 | 30 | Yes | Primary key for subledger or general ledger distribution or line. | |
| DATA_SET_ID | NUMBER | 18 | Yes | Identifies the budgetary control transaction or group of transactions processed in a run. | |
| DRAFT_FLAG | VARCHAR2 | 1 | Yes | Indicates whether this funds activity was attempted in draft mode or final mode. Funds activities attempted in draft mode do not reserve funds. They just check whether the funds activity would have passed. Valid values are Y and N. | |
| RESULT_CODE | VARCHAR2 | 30 | Yes | Status of the budgetary control transaction line. | |
| LEDGER_ID | NUMBER | 18 | Ledger associated with this transaction line. It is NULL for budget adjustment data. | ||
| BUSINESS_UNIT_ID | NUMBER | 18 | Business unit of this transaction line. It is NULL for Oracle Fusion General Ledger data, Oracle Fusion Subledger Accounting data, and budget adjustment data. | ||
| BACKED_OUT_FLAG | VARCHAR2 | 1 | Yes | Indicates whether this line has been undone or reversed. | |
| BUDGET_DATE | DATE | Yes | Date on which to consume funds for this transaction line. | ||
| ACCOUNTING_DATE | DATE | Yes | Accounting date used for this transaction line. | ||
| ENCUMBRANCE_TYPE_CODE | VARCHAR2 | 30 | Encumbrance type of this transaction line. Only populated for Oracle Fusion General Ledger and Oracle Fusion Subledger Accounting data. | ||
| ENTERED_CURRENCY | VARCHAR2 | 15 | Yes | Currency in which the transaction line is denominated. | |
| UOM_CODE | VARCHAR2 | 3 | Unit of measure of the amount if the entered currency is STAT. Unit of measure of the statistical amount if the entered currency is not STAT. Required if the entered currency is STAT or the statistical amount is not null and the data is not from Oracle Fusion General Ledger or Oracle Fusion Subledger Accounting. | ||
| QUANTITY | NUMBER | Quantity to be consumed by this transaction line. | |||
| PRICE | NUMBER | Unit price of the units consumed by this transaction line. | |||
| ENTERED_AMOUNT | NUMBER | Yes | Amount to be consumed by the transaction line, in the transaction line currency. | ||
| CONVERSION_TYPE_CODE | VARCHAR2 | 30 | Conversion type to use for converting from the transaction line currency to the budget currency. | ||
| CONVERSION_DATE | DATE | Conversion date to use for converting from the transaction line currency to the budget currency. | |||
| LEDGER_AMOUNT | NUMBER | Amount to be consumed by the transaction line, in the ledger currency. | |||
| STATISTICAL_AMOUNT | NUMBER | Associated statistical amount. It must be NULL if the entered currency is STAT. | |||
| LIQUIDATION_QUANTITY | NUMBER | Quantity to move from one transaction to another. | |||
| LIQUIDATION_AMOUNT | NUMBER | Amount to move from one transaction to another, in the transaction line currency. | |||
| LIQUIDATION_TRANS_TYPE_CODE | VARCHAR2 | 30 | Identifies the type of transaction being liquidated. | ||
| LIQUIDATION_LINE_ID_1 | VARCHAR2 | 30 | Primary key of the distribution or line to liquidate. | ||
| LIQUIDATION_LINE_ID_2 | VARCHAR2 | 30 | Primary key of the distribution or line to liquidate. | ||
| LIQUIDATION_LINE_ID_3 | VARCHAR2 | 30 | Primary key of the distribution or line to liquidate. | ||
| LIQUIDATION_LINE_ID_4 | VARCHAR2 | 30 | Primary key of the distribution or line to liquidate. | ||
| LIQUIDATION_LINE_ID_5 | VARCHAR2 | 30 | Primary key of the distribution or line to liquidate. | ||
| LIQUIDATION_LINE_ID_6 | VARCHAR2 | 30 | Primary key of the distribution or line to liquidate. | ||
| LIQUIDATION_DATE | DATE | Date on which to move balances from one transaction to another. | |||
| CODE_COMBINATION_ID | NUMBER | 18 | General ledger account associated with this transaction line. | ||
| BUDGET_CCID | NUMBER | 18 | Budgetary control account associated with this transaction line. It is only populated for budget adjustment data. | ||
| JE_CATEGORY_CODE | VARCHAR2 | 25 | General ledger journal category. It is populated for Oracle Fusion General Ledger and Oracle Fusion Subledger Accounting data only. | ||
| PJC_PROJECT_ID | NUMBER | 18 | Project Management project identifier associated with this transaction line. | ||
| PJC_TOP_TASK_ID | NUMBER | 18 | Project Management top task identifier associated with this transaction line. | ||
| PJC_TASK_ID | NUMBER | 18 | Project Management lowest task identifier associated with this transaction line. | ||
| PJC_TOP_RESOURCE_ID | NUMBER | 18 | Project Management top resource identifier associated with this transaction line. | ||
| PJC_RESOURCE_ID | NUMBER | 18 | Project Management lowest resource identifier associated with this transaction line. | ||
| PJC_CONTRACT_ID | NUMBER | 18 | Project Management contract identifier associated with this transaction line. | ||
| PJC_CONTRACT_LINE_ID | NUMBER | 18 | Project Management contract line identifier associated with this transaction line. | ||
| PJC_FUNDING_ALLOCATION_ID | NUMBER | 18 | Project Management funding allocation identifier associated with this transaction line. | ||
| PJC_BILLABLE_FLAG | VARCHAR2 | 1 | Yes | Indicates if this line is subject to billing functions in Project Management. | |
| PJC_CAPITALIZABLE_FLAG | VARCHAR2 | 1 | Yes | Indicates if this line is subject to capitalization functions in Project Management. | |
| PJC_EXPENDITURE_TYPE_ID | NUMBER | 18 | Project Management expenditure type identifier associated with this transaction line. | ||
| PJC_EXPENDITURE_ITEM_DATE | DATE | Project Management expenditure item date associated with this transaction line. | |||
| PJC_ORGANIZATION_ID | NUMBER | 18 | Project Management organization identifier associated with this transaction line. | ||
| PJC_WORK_TYPE_ID | NUMBER | 18 | Project Management work type identifier associated with this transaction line. | ||
| PJC_FUNDING_SOURCE_ID | NUMBER | 18 | Project Management funding source identifier associated with this transaction line. | ||
| CONTROL_BUDGET_ID | NUMBER | 18 | Control budget for which this transaction line is applicable. It is only populated for budget adjustment data. | ||
| LIQUIDATION_DATE_CODE | VARCHAR2 | 30 | Method by which the liquidation date must be obtained. | ||
| PARTIAL_RESERVATION_FLAG | VARCHAR2 | 1 | Indicates if partial reservations are allowed. Valid values are Y and N. | ||
| VENDOR_ID | NUMBER | 18 | Vendor associated with this transaction line. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Inventory item associated with this transaction line. | ||
| ORDER_TYPE_INFO | VARCHAR2 | 25 | Order type information associated with this transaction line. | ||
| NEEDS_RESOURCE_FLAG | VARCHAR2 | 1 | Indicates if burdening activities generated for this line must provide resource information. | ||
| NEEDS_ACCOUNT_FLAG | VARCHAR2 | 1 | Indicates if burdening activities generated for this line must provide account information. | ||
| JE_SOURCE_CODE | VARCHAR2 | 25 | General ledger journal source. Populated for Oracle Fusion General Ledger and Oracle Fusion Subledger Accounting data only. | ||
| OVERRIDE_FLAG | VARCHAR2 | 1 | Indicates if this line used an override when performing overrides with partial reservation turned on. In all other cases, it will be left NULL. | ||
| OVERRIDABLE_CODE | VARCHAR2 | 30 | Indicates what type of override is available when running in override or override check mode with partial reservation turned on. | ||
| DATA_PURGED_FLAG | VARCHAR2 | 1 | Indicates whether one or more activities have been purged for this line. | ||
| FAILURE_REASON_CODE | VARCHAR2 | 30 | Reason code when budgetary control fails due to reason other than failed budgetary control activity. Possible reasons include failure of related transactions, failure of related lines, or burdening failure. | ||
| SUCCESS_REASON_CODE | VARCHAR2 | 30 | Reason code when budgetary control activity is not generated. Possible reasons include budgetary control is not applicable, or control budgets are not applicable to the transaction line. The transaction line may still fail budgetary control if a related transaction or a related transaction line fails. | ||
| BURDEN_FAILURE_FLAG | VARCHAR2 | 1 | Indicates whether generation of burdening information has failed for this line. | ||
| JE_CASH_ACCOUNT_LINE_FLAG | VARCHAR2 | 1 | Indicates if a GL or SLA journal line is a cash account line. | ||
| CASH_CODE_COMBINATION_ID | NUMBER | 18 | Cash code combination of the bank account for Receivables receipt. | ||
| REVENUE_CODE_COMBINATION_ID | NUMBER | 18 | Code combination for one of these: 1) revenue code combination for Receivables miscellaneous receipt, 2) revenue code combination derived from Receivables invoice for receipt application. | ||
| FV_SUMMARY_ACCOUNT_VALUE | VARCHAR2 | 25 | Summary natural account value used for the budget account. This is populated only for federal budget transactions. | ||
| SOURCE_LINE_TYPE_CODE | VARCHAR2 | 30 | Identifies the type of transaction line. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| XCC_TR_LINES_HISTORY_U1 | Unique | Default | HEADER_NUM, LINE_NUM |