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 128     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.    
LEDGER_ID NUMBER 38 0   Primary ledgers defined in GL and enabled for budgetary control. Default value is -98.    
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.    
BALANCES_UPDATED_FLAG VARCHAR2 16     Indicates whether control budget balance is impacted. Valid values are Y, N and NULL.    
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_CONTRACT_LINE_ID NUMBER 38 0   Project accounting contract line unique identifier    
TRX_LINE_PJC_FUNDING_ALLOCATION_ID NUMBER 38 0   Project accounting funding allocation 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_NEEDS_RESOURCE_FLAG VARCHAR2 16     Indicates if burdening activities generated for this line must provide resource information.    
TRX_LINE_NEEDS_ACCOUNT_FLAG VARCHAR2 16     Indicates if burdening activities generated for this line must provide account information.    
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_FV_SUMMARY_ACCOUNT_VALUE VARCHAR2 32     Summary natural account value used for the budget account. This is populated only for federal budget transactions.    
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          

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