# 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

HEADER_NUM, LINE_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 | 128 |  |  | 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. |  |
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. |  |
PJC_CONTRACT_ID | NUMBER | 38 | 0 |  | Project accounting contract unique identifier for the award associated with the budget amount. Default value is -98. |  |
PROJECT_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Project Organization identifier |  |
EXPENDITURE_CATEGORY_ID | NUMBER | 38 | 0 |  | Expenditure Category Identifier |  |
LEDGER_ID | NUMBER | 38 | 0 |  | Primary ledgers defined in GL and enabled for budgetary control. Default value is -98. |  |
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 | 32 |  |  | Accounting segment 1. |  |
XCC_SEGMENT1_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 1 value set code. |  |
XCC_SEGMENT2 | VARCHAR2 | 32 |  |  | Accounting segment 2. |  |
XCC_SEGMENT2_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 2 value set code. |  |
XCC_SEGMENT3 | VARCHAR2 | 32 |  |  | Accounting segment 3. |  |
XCC_SEGMENT3_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 3 value set code. |  |
XCC_SEGMENT4 | VARCHAR2 | 32 |  |  | Accounting segment 4. |  |
XCC_SEGMENT4_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 4 value set code. |  |
XCC_SEGMENT5 | VARCHAR2 | 32 |  |  | Accounting segment 5. |  |
XCC_SEGMENT5_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 5 value set code. |  |
XCC_SEGMENT6 | VARCHAR2 | 32 |  |  | Accounting segment 6. |  |
XCC_SEGMENT6_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 6 value set code. |  |
XCC_SEGMENT7 | VARCHAR2 | 32 |  |  | Accounting segment 7. |  |
XCC_SEGMENT7_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 7 value set code. |  |
XCC_SEGMENT8 | VARCHAR2 | 32 |  |  | Accounting segment 8. |  |
XCC_SEGMENT8_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 8 value set code. |  |
XCC_SEGMENT9 | VARCHAR2 | 32 |  |  | Accounting segment 9. |  |
XCC_SEGMENT9_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 9 value set code. |  |
XCC_SEGMENT10 | VARCHAR2 | 32 |  |  | Accounting segment 10. |  |
XCC_SEGMENT10_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 10 value set 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. |  |
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. |  |
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. |  |
CREATED_BY_USER_ID | VARCHAR2 | 64 |  |  | Who column: indicates the user who created the row. |  |
UPDATED_BY_USER_ID | VARCHAR2 | 64 |  |  | Who column: indicates the user who last updated the row. |  |
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. |  |
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. |  |
TRX_HEADER_BUDGET_FLAG | VARCHAR2 | 16 |  |  | Indicates whether or not this is a budget transaction. |  |
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. |  |
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. |  |
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. |  |
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. |  |
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. |  |
TRX_HEADER_UPDATED_BY_USER_ID | VARCHAR2 | 64 |  |  | Who column: indicates the user who last updated the row. |  |
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. |  |
TRX_LINE_BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Business unit of this transaction line, it is NULL for GL and budgets. |  |
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. |  |
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. |  |
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. |  |
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 |  |
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. |  |
TRX_LINE_PJC_TASK_ID | NUMBER | 38 | 0 |  | Project accounting task unique identifier. |  |
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 |  |
TRX_LINE_PJC_BILLABLE_FLAG | VARCHAR2 | 16 |  |  | Project accounting to indicate if this line is subject to billing functions |  |
TRX_LINE_PJC_CAPITALIZABLE_FLAG | VARCHAR2 | 16 |  |  | Project accounting to indicate if this line is subject to capitalization functions |  |
TRX_LINE_PJC_EXPENDITURE_TYPE_ID | NUMBER | 38 | 0 |  | Project accounting expenditure type |  |
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 |  |
TRX_LINE_PJC_WORK_TYPE_ID | NUMBER | 38 | 0 |  | Project accounting work type unique identifier |  |
TRX_LINE_PJC_FUNDING_SOURCE_ID | NUMBER | 38 | 0 |  | Project accounting funding source unique identifier. |  |
TRX_LINE_CONTROL_BUDGET_ID | NUMBER | 38 | 0 |  | Control budget id, in cases where one is explicitly specified. |  |
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. |  |
TRX_LINE_SUPPLIER_ID | NUMBER | 38 | 0 |  | Vendor associated with this transaction line. |  |
TRX_LINE_INVENTORY_ITEM_ID | NUMBER | 38 | 0 |  | Inventory item associated with this transaction line. |  |
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. |  |
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. |  |
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. |  |
TRX_LINE_JE_CASH_ACCOUNT_LINE_FLAG | VARCHAR2 | 16 |  |  | Indicates if a GL or SLA journal line is a cash account line. |  |
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. |  |
TRX_LINE_UPDATED_BY_USER_ID | VARCHAR2 | 64 |  |  | Who column: indicates the user who last updated the row. |  |
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 |  |  |  |
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, 2025, Oracle and/or its affiliates.