# DW_BC_TRANSACTIONS_CF (Preview)

This table requires activation of Budgetary Control functional area. This fact table reflects how transactions affect the budgetary control balances.

## Details

Module: Budgetary Control

## Key Columns

LINE_NUM, HEADER_NUM, BALANCE_LINE_ORDER

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
HEADER_NUM | VARCHAR2 | 128 |  | True | Unique identifier for this transaction. |  |
LINE_NUM | NUMBER | 38 | 0 | True | Internal line number for budgetary control engine processing |  |
BALANCE_LINE_ORDER | VARCHAR2 | 128 |  | True | Balance line number, it is part of the primary key. |  |
SOURCE_RECORD_ID | VARCHAR2 | 512 |  |  | This column is for Oracle Internal use only. Source record identifier. Value is derived from a combination of Asset adjustment identifiers. |  |
STRIPE_CODE | VARCHAR2 | 128 |  |  |  |  |
CONTROL_BUDGET_ID | NUMBER | 38 | 0 |  | Identifier of the impacted Control Budget for this balance activity entry. | DW_BC_CONTROL_BUDGET_D | CONTROL_BUDGET_ID
CONTROL_LEVEL_CODE | VARCHAR2 | 32 |  |  | The control level code indicates how the entry is treated, it is either ABSOLUTE, ADVISORY, TRACKING or NONE. |  |
PROJECT_ID | NUMBER | 38 | 0 |  | Project accounting project unique identifier. Default value is -98. | DW_PROJECT_D | PROJECT_ID
PJC_CONTRACT_ID | NUMBER | 38 | 0 |  | Project accounting contract unique identifier for the award associated with the budget amount. Default value is -98. | DW_AWARD_D | AWARD_ID
PROJECT_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Project Organization identifier | DW_INTERNAL_ORG_D | ORGANIZATION_ID
EXPENDITURE_CATEGORY_ID | NUMBER | 38 | 0 |  | Expenditure Category Identifier | DW_PROJECT_EXP_CATEGORY_D | EXPENDITURE_CATEGORY_ID
LEDGER_ID | NUMBER | 38 | 0 |  | Primary ledgers defined in GL and enabled for budgetary control. Default value is -98. | DW_LEDGER_D | LEDGER_ID
PERIOD_SET_NAME | VARCHAR2 | 32 |  |  | Budget calendar period set name |  |
PERIOD_TYPE | VARCHAR2 | 32 |  |  | Control budget calendar period type |  |
BUDGET_CURRENCY_CODE | VARCHAR2 | 32 |  |  | Currency assigned to the control budget |  |
LEDGER_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Ledger Currency Code |  |
BC_TOLERANCE_AMOUNT | NUMBER |  |  |  | Tolerance used in funds checking expressed by an amount. |  |
BC_TOLERANCE_PERCENT | NUMBER |  |  |  | Tolerance used in funds checking expressed by a percentage. |  |
ENTERED_CURRENCY_CODE | VARCHAR2 | 32 |  |  | Represents the transaction currency. |  |
ENTERED_AMOUNT | NUMBER |  |  |  | Amount entered on the transaction line. |  |
CONVERSION_TYPE_CODE | VARCHAR2 | 32 |  |  | Conversion type used to obtain the budget currency. |  |
CONVERSION_RATE | NUMBER |  |  |  | Conversion rate used to calculate the amount in budget currency. |  |
BC_AMOUNT | NUMBER |  |  |  | Amount expressed in budget currency. |  |
BUDGET_DATE | DATE |  |  |  | Date used to perform the budget checking. |  |
PERIOD_NAME | VARCHAR2 | 32 |  |  | Budget period in which falls the budget checking. |  |
BUDGET_CODE_COMBINATION_ID | NUMBER | 38 | 0 |  | Key flexfield combination defining column that indentifies the budget account |  |
XCC_SEGMENT1 | VARCHAR2 | 512 |  |  | Accounting segment 1. | DW_XCC_SEGMENT1_D | XCC_SEGMENT_CODE
XCC_SEGMENT1_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 1 value set code. | DW_XCC_SEGMENT1_D | XCC_SEGMENT_VALUESET_CODE
XCC_SEGMENT2 | VARCHAR2 | 512 |  |  | Accounting segment 2. | DW_XCC_SEGMENT2_D | XCC_SEGMENT_CODE
XCC_SEGMENT2_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 2 value set code. | DW_XCC_SEGMENT2_D | XCC_SEGMENT_VALUESET_CODE
XCC_SEGMENT3 | VARCHAR2 | 512 |  |  | Accounting segment 3. | DW_XCC_SEGMENT3_D | XCC_SEGMENT_CODE
XCC_SEGMENT3_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 3 value set code. | DW_XCC_SEGMENT3_D | XCC_SEGMENT_VALUESET_CODE
XCC_SEGMENT4 | VARCHAR2 | 512 |  |  | Accounting segment 4. | DW_XCC_SEGMENT4_D | XCC_SEGMENT_CODE
XCC_SEGMENT4_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 4 value set code. | DW_XCC_SEGMENT4_D | XCC_SEGMENT_VALUESET_CODE
XCC_SEGMENT5 | VARCHAR2 | 512 |  |  | Accounting segment 5. | DW_XCC_SEGMENT5_D | XCC_SEGMENT_CODE
XCC_SEGMENT5_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 5 value set code. | DW_XCC_SEGMENT5_D | XCC_SEGMENT_VALUESET_CODE
XCC_SEGMENT6 | VARCHAR2 | 512 |  |  | Accounting segment 6. | DW_XCC_SEGMENT6_D | XCC_SEGMENT_CODE
XCC_SEGMENT6_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 6 value set code. | DW_XCC_SEGMENT6_D | XCC_SEGMENT_VALUESET_CODE
XCC_SEGMENT7 | VARCHAR2 | 512 |  |  | Accounting segment 7. | DW_XCC_SEGMENT7_D | XCC_SEGMENT_CODE
XCC_SEGMENT7_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 7 value set code. | DW_XCC_SEGMENT7_D | XCC_SEGMENT_VALUESET_CODE
XCC_SEGMENT8 | VARCHAR2 | 512 |  |  | Accounting segment 8. | DW_XCC_SEGMENT8_D | XCC_SEGMENT_CODE
XCC_SEGMENT8_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 8 value set code. | DW_XCC_SEGMENT8_D | XCC_SEGMENT_VALUESET_CODE
XCC_SEGMENT9 | VARCHAR2 | 512 |  |  | Accounting segment 9. | DW_XCC_SEGMENT9_D | XCC_SEGMENT_CODE
XCC_SEGMENT9_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 9 value set code. | DW_XCC_SEGMENT9_D | XCC_SEGMENT_VALUESET_CODE
XCC_SEGMENT10 | VARCHAR2 | 512 |  |  | Accounting segment 10. | DW_XCC_SEGMENT10_D | XCC_SEGMENT_CODE
XCC_SEGMENT10_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 10 value set code. | DW_XCC_SEGMENT10_D | XCC_SEGMENT_VALUESET_CODE
RESULT_CODE | VARCHAR2 | 32 |  |  | Status of funds check or reservation for this particular balance activity |  |
ACTIVITY_TYPE_CODE | VARCHAR2 | 32 |  |  | Activity type can be Original, Liquidation, Rounding Plug or Backout. |  |
ALLOC_HEADER_NUM | VARCHAR2 | 128 |  |  | For liquidations, it identifies the original header. |  |
ALLOC_LINE_NUM | NUMBER | 38 | 0 |  | For liquidations, it identifies the original line number. |  |
BACKOUT_HEADER_NUM | VARCHAR2 | 128 |  |  | For backouts, it identifies the backed out header. |  |
BACKOUT_LINE_NUM | NUMBER | 38 | 0 |  | For backouts, it corresponds to the backed out line number. |  |
BALANCE_TYPE_CODE | VARCHAR2 | 32 |  |  | Identifes the type of balance, it can be Obligation, Commitment, Other, Actual or Budget. |  |
SUB_BALANCE_TYPE_CODE | VARCHAR2 | 32 |  |  | This code represents the detail balance type. |  |
BC_BUDGET_AMOUNT | NUMBER |  |  |  | Initial amount budgeted to this control budget, account, and period at the time of funds reservation. Add the budget adjustment amount to get the total budget. |  |
BC_BUDGET_ADJUSTMENT_AMOUNT | NUMBER |  |  |  | Amount by which the budgeted amount had been increased or decreased for this control budget, account, and period at the time of funds reservation. |  |
BC_COMMITMENT_AMOUNT | NUMBER |  |  |  | Funds committed for this control budget, account, and period at the time of funds reservation. |  |
BC_OBLIGATION_AMOUNT | NUMBER |  |  |  | Funds obligated for this control budget, account, and period at the time of funds reservation. |  |
BC_OTHER_AMOUNT | NUMBER |  |  |  | Funds in the bucket called other, for this control budget, account, and period at the time of funds reservation. |  |
BC_ACTUAL_AMOUNT | NUMBER |  |  |  | Funds spent for this control budget, account, and period at the time of funds reservation. |  |
BC_FUNDS_AVAILABLE_AMOUNT | NUMBER |  |  |  | Total funds available for this control budget, account, and period at the time of funds reservation. |  |
BC_PENDING_AMOUNT | NUMBER |  |  |  | Total pending reservations for earlier transactions for this control budget, account, and period at the time of funds reservation. |  |
BC_OTHER_LINES_AMOUNT | NUMBER |  |  |  | Total pending reservations for earlier lines in this transaction for this control budget, account, and period at the time of funds reservation. |  |
BC_NET_TOLERANCE_AMOUNT | NUMBER |  |  |  | Tolerance allowed at the time of funds reservation. It does not indicate what has been used, just records what was allowed. |  |
BC_PENDING_HEADER_GROUP_AMOUNT | NUMBER |  |  |  | Total pending reservation amount for earlier transactions with same header group in current budgetary control request for this control budget, account, and period at time of funds reservation. |  |
PJC_EXPENDITURE_TYPE_ID | NUMBER | 38 | 0 |  | Project Portfolio Managment expenditure type. This is only populated for burdening activities. | DW_PROJECT_EXPENDITURE_TYPE_D | EXPENDITURE_TYPE_ID
PJC_RESOURCE_ID | NUMBER | 38 | 0 |  | Project Portfolio Management resource being burdened against. This is only populated for burdening activities. |  |
CODE_COMBINATION_ID_BURDEN | NUMBER | 38 | 0 |  | Account impacted by this activity. This is only populated for burdening activities. |  |
LEDGER_AMOUNT_BURDEN | NUMBER |  |  |  | Amount in the primary ledger's currency. This is only populated for burdening activities. |  |
BURDEN_LINE_FLAG | VARCHAR2 | 16 |  |  | A Yes or No flag indicating whether this line is a burdening line. |  |
OVERRIDE_CLOSED_PERIOD_FLAG | VARCHAR2 | 16 |  |  | Indicates whether an activity has closed period override considered. |  |
OVERRIDE_FUNDS_FLAG | VARCHAR2 | 16 |  |  | Indicates whether an activity has insufficient funds override considered. |  |
BC_ESTIMATED_TOLERANCE_AMOUNT | NUMBER |  |  |  | Estimated tolerance amount needed for funds reservation. |  |
BC_ESTIMATED_OVERRIDE_AMOUNT | NUMBER |  |  |  | Estimated override amount needed for funds reservation. |  |
PERIOD_CHANGE_FOR_UNDO_FLAG | VARCHAR2 | 16 |  |  | Indicates that the data is reversed into a different period. | DW_YN_LKP_TL | YN_LKP_CODE
PROCESSED_FOR_ESSBASE_FLAG | VARCHAR2 | 16 |  |  | Indicates that balances have been transferred to the budget cube for this control budget and period name combination.Valid values are Y and N. | DW_YN_LKP_TL | YN_LKP_CODE
CREATED_BY_USER_ID | VARCHAR2 | 64 |  |  | Who column: indicates the user who created the row. | DW_USER_D | USERNAME
UPDATED_BY_USER_ID | VARCHAR2 | 64 |  |  | Who column: indicates the user who last updated the row. | DW_USER_D | USERNAME
CREATION_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the creation of the row. |  |
LAST_UPDATE_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the last update of the row. |  |
TRANSACTION_TYPE_CODE | VARCHAR2 | 32 |  |  | Identifies the type of transaction. |  |
TRANSACTION_NUMBER | VARCHAR2 | 256 |  |  | This columns contains the transaction number. |  |
SOURCE_HEADER_ID_1 | VARCHAR2 | 32 |  |  | Subledger or General Ledger transaction primary key. |  |
SOURCE_HEADER_ID_2 | VARCHAR2 | 32 |  |  | Subledger or General Ledger transaction primary key. |  |
TRX_HEADER_SOURCE_ACTION_CODE | VARCHAR2 | 32 |  |  | Subledger commitment control action. Valid values depend upon the subledger and transaction type involved. |  |
TRX_HEADER_DATA_SET_ID | NUMBER | 38 | 0 |  | Identifies the budgetary control transaction or group of transactions processed in a run. | DW_BC_DATA_SET_D | DATA_SET_ID
TRX_HEADER_RESULT_CODE | VARCHAR2 | 32 |  |  | Status of the budgetary control transaction. |  |
TRX_HEADER_ARRIVAL_ORDER | NUMBER | 38 | 0 |  | If multiple transactions are being processed at once, order in which they should be considered. |  |
TRX_HEADER_DRAFT_FLAG | VARCHAR2 | 16 |  |  | 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. | DW_YN_LKP_TL | YN_LKP_CODE
TRX_HEADER_BUDGET_FLAG | VARCHAR2 | 16 |  |  | Indicates whether or not this is a budget transaction. | DW_YN_LKP_TL | YN_LKP_CODE
TRX_HEADER_OVERRIDE_FLAG | VARCHAR2 | 16 |  |  | Indicates if this transaction was overridden. |  |
TRX_HEADER_LEDGER_ID | NUMBER | 38 | 0 |  | Ledger associated with this transaction, it is NULL for GL and XLA, as the ledger is a line level attribute there. It is also NULL for budgets. | DW_LEDGER_D | LEDGER_ID
TRX_HEADER_BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Business unit of this transaction, it is only populated here when the transaction type or action does not support distribution level BUs. | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
TRX_HEADER_DESTINATION_TYPE_CODE | VARCHAR2 | 32 |  |  | Destination type is either Expense or Inventory. |  |
TRX_HEADER_TRANSACTION_SOURCE_CODE | VARCHAR2 | 32 |  |  | Transaction source code is populated for projects only. |  |
TRX_HEADER_DOCUMENT_TYPE_CODE | VARCHAR2 | 32 |  |  | Document type code is populated for projects only. |  |
TRX_HEADER_JE_SOURCE_CODE | VARCHAR2 | 32 |  |  | General ledger journal source is populated for GL and XLA data only. |  |
TRX_HEADER_LIQUIDATION_DATE_CODE | VARCHAR2 | 32 |  |  | Method via which the liquidation date should be obtained, it is used for PPM. |  |
TRX_HEADER_PARTIAL_RESERVATION_FLAG | VARCHAR2 | 16 |  |  | Indicates if partial reservations are allowed. | DW_YN_LKP_TL | YN_LKP_CODE
TRX_HEADER_DATA_PURGED_FLAG | VARCHAR2 | 16 |  |  | Indicates that one or more lines have been purged for this transaction. Valid values are Y and N. | DW_YN_LKP_TL | YN_LKP_CODE
TRX_HEADER_OVERRIDABLE_CODE | VARCHAR2 | 32 |  |  | Indicates what type of override is available when running in override or override check mode. |  |
TRX_HEADER_GROUP_CODE | VARCHAR2 | 32 |  |  | Used to control whether multiple transactions should be grouped together for purposes of budegtary control. If provided, any transactions with the same value for this column will pass or fail budgetary control as a unit. |  |
TRX_HEADER_FAILURE_REASON_CODE | VARCHAR2 | 32 |  |  | Reason for failure when budgetary control failed for some reason other than a failed budgetary control activity. Some potential reasons are: failure of related transactions, or a burdening failure. |  |
TRX_HEADER_SUCCESS_REASON_CODE | VARCHAR2 | 32 |  |  | 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. A transaction may still fail budgetary control, if a related transaction fails. |  |
TRX_HEADER_CREATED_BY_USER_ID | VARCHAR2 | 64 |  |  | Who column: indicates the user who created the row. | DW_USER_D | USERNAME
TRX_HEADER_UPDATED_BY_USER_ID | VARCHAR2 | 64 |  |  | Who column: indicates the user who last updated the row. | DW_USER_D | USERNAME
TRX_HEADER_CREATION_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the creation of the row. |  |
TRX_HEADER_LAST_UPDATE_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the last update of the row. |  |
TRX_LINE_LEDGER_ID | NUMBER | 38 | 0 |  | Ledger associated with this transaction line, it is NULL for budgets. | DW_LEDGER_D | LEDGER_ID
TRX_LINE_BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Business unit of this transaction line, it is NULL for GL and budgets. | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
TRX_LINE_GROUP_CODE | VARCHAR2 | 32 |  |  | Line group corresponds to the group containing this line. |  |
TRANSACTION_SUBTYPE_CODE | VARCHAR2 | 32 |  |  | Identifies the subtype of the transaction. |  |
SOURCE_TRANSACTION_TYPE_CODE | VARCHAR2 | 32 |  |  | Identifies the type of transaction. |  |
TRX_LINE_DATA_SET_ID | NUMBER | 38 | 0 |  | Identifies the budgetary transaction or group of transactions processed in a run. | DW_BC_DATA_SET_D | DATA_SET_ID
TRX_LINE_DRAFT_FLAG | VARCHAR2 | 16 |  |  | 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. | DW_YN_LKP_TL | YN_LKP_CODE
TRX_LINE_RESULT_CODE | VARCHAR2 | 32 |  |  | Status of budgetary control transaction. |  |
TRX_LINE_BACKED_OUT_FLAG | VARCHAR2 | 16 |  |  | Indicates whether this line has been undone or reversed. | DW_YN_LKP_TL | YN_LKP_CODE
TRX_LINE_BUDGET_DATE | DATE |  |  |  | Budget date used for this transaction line. |  |
TRX_LINE_ACCOUNTING_DATE | DATE |  |  |  | Accounting date used for this transaction line. |  |
TRX_LINE_ENCUMBRANCE_TYPE_CODE | VARCHAR2 | 32 |  |  | Encumbrance type of the distribution line. |  |
TRX_LINE_ENTERED_CURRENCY_CODE | VARCHAR2 | 32 |  |  | The currency in which the transaction is denominated |  |
TRX_LINE_UOM_CODE | VARCHAR2 | 16 |  |  | 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. |  |
TRX_LINE_QUANTITY | NUMBER |  |  |  | It corresponds to the quantity sold. |  |
TRX_LINE_PRICE | NUMBER |  |  |  | Unit price of the transaction line |  |
TRX_LINE_ENTERED_AMOUNT | NUMBER |  |  |  | Amount entered on the transaction line. |  |
TRX_LINE_CONVERSION_TYPE_CODE | VARCHAR2 | 32 |  |  | Conversion type for budget currency. |  |
TRX_LINE_CONVERSION_DATE | DATE |  |  |  | Conversion date for budget currency. |  |
TRX_LINE_LEDGER_AMOUNT | NUMBER |  |  |  | The ledger currency equivalent of the transaction amount |  |
TRX_LINE_STATISTICAL_AMOUNT | NUMBER |  |  |  | Associated statistical amount, it must be NULL if the entered currency is STAT. |  |
TRX_LINE_LIQUIDATION_QUANTITY | NUMBER |  |  |  | The quantity to move from one transaction to another |  |
TRX_LINE_LIQUIDATION_AMOUNT | NUMBER |  |  |  | The amount in transaction currency to move from one transaction to another |  |
TRX_LINE_LIQUIDATION_TRANS_TYPE_CODE | VARCHAR2 | 32 |  |  | Identifies the type of transaction being liquidated. |  |
TRX_LINE_LIQUIDATION_DATE | DATE |  |  |  | The date to determine which period to move balances from one transaction to another |  |
TRX_LINE_CODE_COMBINATION_ID_GL | NUMBER | 38 | 0 |  | Key flexfield combination defining column that indentifies the general ledger account | DW_GL_CODE_COMBINATION_D | CODE_COMBINATION_ID
TRX_LINE_BUDGET_CCID_BUDADJ | NUMBER | 38 | 0 |  | Budget account, it is only populated for budget adjustments. |  |
TRX_LINE_JE_CATEGORY_CODE | VARCHAR2 | 32 |  |  | General ledger journal category, it is populated for GL and SLA only. |  |
TRX_LINE_PJC_PROJECT_ID | NUMBER | 38 | 0 |  | Project accounting project unique identifier. | DW_PROJECT_D | PROJECT_ID
TRX_LINE_PJC_TASK_ID | NUMBER | 38 | 0 |  | Project accounting task unique identifier. | DW_PROJECT_ELEMENT_D | PROJ_ELEMENT_ID
TRX_LINE_PJC_RESOURCE_ID | NUMBER | 38 | 0 |  | PPM resource element identifier. |  |
TRX_LINE_PJC_CONTRACT_ID | NUMBER | 38 | 0 |  | Project accounting contract unique identifier | DW_AWARD_D | AWARD_ID
TRX_LINE_PJC_BILLABLE_FLAG | VARCHAR2 | 16 |  |  | Project accounting to indicate if this line is subject to billing functions | DW_YN_LKP_TL | YN_LKP_CODE
TRX_LINE_PJC_CAPITALIZABLE_FLAG | VARCHAR2 | 16 |  |  | Project accounting to indicate if this line is subject to capitalization functions | DW_YN_LKP_TL | YN_LKP_CODE
TRX_LINE_PJC_EXPENDITURE_TYPE_ID | NUMBER | 38 | 0 |  | Project accounting expenditure type | DW_PROJECT_EXPENDITURE_TYPE_D | EXPENDITURE_TYPE_ID
TRX_LINE_PJC_EXPENDITURE_ITEM_DATE | DATE |  |  |  | Project accounting expenditure item date |  |
TRX_LINE_PJC_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Project accounting project organization unique identifier | DW_INTERNAL_ORG_D | ORGANIZATION_ID
TRX_LINE_PJC_WORK_TYPE_ID | NUMBER | 38 | 0 |  | Project accounting work type unique identifier | DW_PROJECT_WORK_TYPE_TL | WORK_TYPE_ID
TRX_LINE_PJC_FUNDING_SOURCE_ID | NUMBER | 38 | 0 |  | Project accounting funding source unique identifier. | DW_AWARD_FUNDING_SOURCE_D | FUNDING_SOURCE_ID
TRX_LINE_CONTROL_BUDGET_ID | NUMBER | 38 | 0 |  | Control budget id, in cases where one is explicitly specified. | DW_BC_CONTROL_BUDGET_D | CONTROL_BUDGET_ID
TRX_LINE_LIQUIDATION_DATE_CODE | VARCHAR2 | 32 |  |  | Method via which the liquidation date should be obtained, it is used for procure to pay flow. |  |
TRX_LINE_PARTIAL_RESERVATION_FLAG | VARCHAR2 | 16 |  |  | All transaction lines must pass/fail budgetary control together. | DW_YN_LKP_TL | YN_LKP_CODE
TRX_LINE_SUPPLIER_ID | NUMBER | 38 | 0 |  | Vendor associated with this transaction line. | DW_PARTY_D | SUPPLIER_ID
TRX_LINE_INVENTORY_ITEM_ID | NUMBER | 38 | 0 |  | Inventory item associated with this transaction line. | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID
TRX_LINE_ORDER_TYPE_INFO | VARCHAR2 | 32 |  |  | Order type information associated with this transaction line. |  |
TRX_LINE_JE_SOURCE_CODE | VARCHAR2 | 32 |  |  | General ledger journal source (populated for general ledger and subledger accounting data only). |  |
TRX_LINE_OVERRIDE_FLAG | VARCHAR2 | 16 |  |  | Indicates if this line was overridden when performing overrides with partial reservation turned on. In all other cases, it will be left as blank. | DW_YN_LKP_TL | YN_LKP_CODE
TRX_LINE_OVERRIDABLE_CODE | VARCHAR2 | 32 |  |  | Indicates what type of override is available when running in override or override check mode with partial reservation turned on. |  |
TRX_LINE_DATA_PURGED_FLAG | VARCHAR2 | 16 |  |  | Indicates that one or more activities have been purged for this line. Valid values are Y and N. | DW_YN_LKP_TL | YN_LKP_CODE
TRX_LINE_FAILURE_REASON_CODE | VARCHAR2 | 32 |  |  | 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. |  |
TRX_LINE_SUCCESS_REASON_CODE | VARCHAR2 | 32 |  |  | 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. |  |
TRX_LINE_BURDEN_FAILURE_FLAG | VARCHAR2 | 16 |  |  | Indicates whether generation of burdening information has failed for this line. | DW_YN_LKP_TL | YN_LKP_CODE
TRX_LINE_JE_CASH_ACCOUNT_LINE_FLAG | VARCHAR2 | 16 |  |  | Indicates if a GL or SLA journal line is a cash account line. | DW_YN_LKP_TL | YN_LKP_CODE
TRX_LINE_CASH_CODE_COMBINATION_ID | NUMBER | 38 | 0 |  | Cash code combination of the bank account for Receivables receipt. |  |
TRX_LINE_REVENUE_CODE_COMBINATION_ID | NUMBER | 38 | 0 |  | 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. |  |
TRX_LINE_CREATED_BY_USER_ID | VARCHAR2 | 64 |  |  | Who column: indicates the user who created the row. | DW_USER_D | USERNAME
TRX_LINE_UPDATED_BY_USER_ID | VARCHAR2 | 64 |  |  | Who column: indicates the user who last updated the row. | DW_USER_D | USERNAME
TRX_LINE_CREATION_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the creation of the row. |  |
TRX_LINE_LAST_UPDATE_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the last update of the row. |  |
SOURCE_LINE_ID_1 | VARCHAR2 | 32 |  |  | Subledger or General Ledger distribution line primary key. |  |
SOURCE_LINE_ID_2 | VARCHAR2 | 32 |  |  | Subledger or General Ledger distribution line primary key. |  |
SOURCE_LINE_ID_3 | VARCHAR2 | 32 |  |  | Subledger or General Ledger distribution line primary key. |  |
SOURCE_LINE_ID_4 | VARCHAR2 | 32 |  |  | Subledger or General Ledger distribution line primary key. |  |
SOURCE_LINE_ID_5 | VARCHAR2 | 32 |  |  | Subledger or General Ledger distribution line primary key. |  |
SOURCE_LINE_ID_6 | VARCHAR2 | 32 |  |  | Subledger or General Ledger distribution line primary key. |  |
LIQUIDATION_LINE_ID_1 | VARCHAR2 | 32 |  |  | Primary key of the distribution line to liquidate. |  |
LIQUIDATION_LINE_ID_2 | VARCHAR2 | 32 |  |  | Primary key of the distribution line to liquidate. |  |
LIQUIDATION_LINE_ID_3 | VARCHAR2 | 32 |  |  | Primary key of the distribution line to liquidate. |  |
LIQUIDATION_LINE_ID_4 | VARCHAR2 | 32 |  |  | Primary key of the distribution line to liquidate. |  |
LIQUIDATION_LINE_ID_5 | VARCHAR2 | 32 |  |  | Primary key of the distribution line to liquidate. |  |
LIQUIDATION_LINE_ID_6 | VARCHAR2 | 32 |  |  | Primary key of the distribution line to liquidate. |  |
EXPENDITURE_ITEM_ID | NUMBER | 38 | 0 |  |  | DW_EXPENDITURE_ITEM_D | EXPENDITURE_ITEM_ID
REQUISITION_HEADER_ID | NUMBER | 38 | 0 |  |  |  |
REQUISITION_NUMBER | VARCHAR2 | 256 |  |  |  |  |
PO_HEADER_ID | NUMBER | 38 | 0 |  |  |  |
PO_NUMBER | VARCHAR2 | 256 |  |  |  |  |
INVOICE_ID | NUMBER | 38 | 0 |  |  |  |
INVOICE_NUMBER | VARCHAR2 | 256 |  |  |  |  |
LIQUIDATED_TRANSACTION_NUMBER | VARCHAR2 | 256 |  |  | Liquidated Transaction Number |  |

Copyright © 2019, 2026, Oracle and/or its affiliates.