XCC_TR_LINES
This table stores the transaction lines associated with each commitment control transaction. It stores the detailed information used in determining whether each line should pass or fail funds check or reservation. In the case of partial funds reservation, it also stores the commitment control status of that line. Each transaction line is associated with a single subledger or GL transaction line. Within a subledger transaction, each transaction line is associated with a different subledger or GL transaction line. The results from old funds check requests may be purged from this table.
Details
-
Schema: FUSION
-
Object owner: XCC
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
Name | Columns |
---|---|
XCC_TR_LINES_PK |
HEADER_NUM, LINE_NUM |
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Status |
---|---|---|---|---|---|---|
HEADER_NUM | VARCHAR2 | 100 | Yes | Unique identifier for this transaction. | ||
LINE_NUM | NUMBER | 18 | Yes | Line number to uniquely identify the transaction line. | ||
LINE_GROUP_CODE | VARCHAR2 | 30 | Line group corresponds to the group containing this line. | |||
TRANSACTION_SUBTYPE_CODE | VARCHAR2 | 30 | Identifies the subtype of the transaction. | |||
SOURCE_TRANSACTION_TYPE_CODE | VARCHAR2 | 30 | Yes | Identifies the type of transaction. | ||
SOURCE_LINE_ID_1 | VARCHAR2 | 30 | Yes | Subledger or General Ledger distribution line primary key. | ||
SOURCE_LINE_ID_2 | VARCHAR2 | 30 | Yes | Subledger or General Ledger distribution line primary key. | ||
SOURCE_LINE_ID_3 | VARCHAR2 | 30 | Yes | Subledger or General Ledger distribution line primary key. | ||
SOURCE_LINE_ID_4 | VARCHAR2 | 30 | Yes | Subledger or General Ledger distribution line primary key. | ||
SOURCE_LINE_ID_5 | VARCHAR2 | 30 | Yes | Subledger or General Ledger distribution line primary key. | ||
SOURCE_LINE_ID_6 | VARCHAR2 | 30 | Yes | Subledger or General Ledger distribution line primary key. | ||
DATA_SET_ID | NUMBER | 18 | Yes | Identifies the budgetary 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 to see whether the funds activity would have passed. | ||
RESULT_CODE | VARCHAR2 | 30 | Yes | Status of budgetary control transaction. | ||
LEDGER_ID | NUMBER | 18 | Ledger associated with this transaction line, it is NULL for budgets. | |||
BUSINESS_UNIT_ID | NUMBER | 18 | Business unit of this transaction line, it is NULL for GL and budgets. | |||
BACKED_OUT_FLAG | VARCHAR2 | 1 | Yes | Indicates whether this line has been undone or reversed. | ||
BUDGET_DATE | DATE | Yes | Budget date used for this transaction line. | |||
ACCOUNTING_DATE | DATE | Yes | Accounting date used for this transaction line. | |||
ENCUMBRANCE_TYPE_CODE | VARCHAR2 | 30 | Encumbrance type of the distribution line. | |||
ENTERED_CURRENCY | VARCHAR2 | 15 | Yes | The currency in which the transaction 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 product is not GL or SLA. | |||
QUANTITY | NUMBER | It corresponds to the quantity sold. | ||||
PRICE | NUMBER | Unit price of the transaction line | ||||
ENTERED_AMOUNT | NUMBER | Yes | Amount entered on the transaction line. | |||
CONVERSION_TYPE_CODE | VARCHAR2 | 30 | Conversion type for budget currency. | |||
CONVERSION_DATE | DATE | Conversion date for budget currency. | ||||
LEDGER_AMOUNT | NUMBER | The ledger currency equivalent of the transaction amount | ||||
STATISTICAL_AMOUNT | NUMBER | Associated statistical amount, it must be NULL if the entered currency is STAT. | ||||
LIQUIDATION_QUANTITY | NUMBER | The quantity to move from one transaction to another | ||||
LIQUIDATION_AMOUNT | NUMBER | The amount in transaction currency to move from one transaction to another | ||||
LIQUIDATION_TRANS_TYPE_CODE | VARCHAR2 | 30 | Identifies the type of transaction being liquidated. | |||
LIQUIDATION_LINE_ID_1 | VARCHAR2 | 30 | Primary key of the distribution line to liquidate. | |||
LIQUIDATION_LINE_ID_2 | VARCHAR2 | 30 | Primary key of the distribution line to liquidate. | |||
LIQUIDATION_LINE_ID_3 | VARCHAR2 | 30 | Primary key of the distribution line to liquidate. | |||
LIQUIDATION_LINE_ID_4 | VARCHAR2 | 30 | Primary key of the distribution line to liquidate. | |||
LIQUIDATION_LINE_ID_5 | VARCHAR2 | 30 | Primary key of the distribution line to liquidate. | |||
LIQUIDATION_LINE_ID_6 | VARCHAR2 | 30 | Primary key of the distribution line to liquidate. | |||
LIQUIDATION_DATE | DATE | The date to determine which period to move balances from one transaction to another | ||||
CODE_COMBINATION_ID | NUMBER | 18 | Key flexfield combination defining column that indentifies the general ledger account | |||
BUDGET_CCID | NUMBER | 18 | Budget account, it is only populated for budget adjustments. | |||
JE_CATEGORY_CODE | VARCHAR2 | 25 | General ledger journal category, it is populated for GL and SLA 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 id, in cases where one is explicitly specified. | |||
LIQUIDATION_DATE_CODE | VARCHAR2 | 30 | Method via which the liquidation date should be obtained, it is used for procure to pay flow. | |||
PARTIAL_RESERVATION_FLAG | VARCHAR2 | 1 | All transaction lines must pass/fail budgetary control together. | |||
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 general ledger and subledger accounting data only). | |||
OVERRIDE_FLAG | VARCHAR2 | 1 | Indicates if this line was overridden when performing overrides with partial reservation turned on. In all other cases, it will be left as blank. | |||
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 that one or more activities have been purged for this line. Valid values are Y and N. | |||
FAILURE_REASON_CODE | VARCHAR2 | 30 | Reason for failure when budgetary control failed due to a reason other than a failed budgetary control activity. Some potential reasons are: failure of related transactions, failure of related lines, or a burdening failure. | |||
SUCCESS_REASON_CODE | VARCHAR2 | 30 | Reason for success when no budgetary control activity was generated. Potential success reasons are: budgetary control not being applicable, or no control budgets being applicable for this 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. | Active | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | Active | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | Active | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | Active | ||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active |
Indexes
Index | Uniqueness | Tablespace | Columns | Status |
---|---|---|---|---|
XCC_TR_LINES_N1 | Non Unique | FUSION_TS_TX_DATA | DATA_SET_ID | Active |
XCC_TR_LINES_N2 | Non Unique | FUSION_TS_TX_DATA | SOURCE_TRANSACTION_TYPE_CODE, SOURCE_LINE_ID_1, SOURCE_LINE_ID_2, SOURCE_LINE_ID_3, SOURCE_LINE_ID_4, SOURCE_LINE_ID_5, SOURCE_LINE_ID_6 | Active |
XCC_TR_LINES_N3 | Non Unique | FUSION_TS_TX_DATA | LIQUIDATION_TRANS_TYPE_CODE, LIQUIDATION_LINE_ID_1, LIQUIDATION_LINE_ID_2, LIQUIDATION_LINE_ID_3, LIQUIDATION_LINE_ID_4, LIQUIDATION_LINE_ID_5, LIQUIDATION_LINE_ID_6 | |
XCC_TR_LINES_N4 | Non Unique | FUSION_TS_TX_DATA | BUDGET_DATE | |
XCC_TR_LINES_U1 | Unique | FUSION_TS_TX_DATA | HEADER_NUM, LINE_NUM | Active |