Budgetary Control Validation Transaction Lines
The budgetary control validation transaction lines view object contains transaction line information for each budgetary control validation request.
Data Store Key : FscmTopModelAM.FinExtractAM.XccBiccExtractAM.TransactionLineExtractPVO
Primary Keys : HeaderNum, LineNum
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| AccountingDate | The accounting date of the source transaction line. |
| BackedOutFlag | Indicates whether this line has been undone or reversed by a later budgetary control validation attempt. |
| BudgetCcid | The budget account identifier for the budgetary control validation transaction. |
| BudgetDate | The budget date of the source transaction line for the budgetary control validation attempt. |
| BurdenFailureFlag | Indicates whether the transaction line failed to generate burdening information. |
| BusinessUnitId | The unique identifier of the business unit of the budgetary control validation transaction line. |
| CashCodeCombinationId | The cash account code combination of the bank account for the Receivables receipt transaction line. |
| CodeCombinationId | The unique identifier of the account of the budgetary control validation transaction line. |
| ControlBudgetId | The unique identifier of the control budget. |
| ConversionDate | The date on which a conversion rate is used to convert the transaction entered amount into the budget currency. |
| ConversionTypeCode | The source of a currency conversion rate, such as, user defined or corporate, that's used to convert the transactions. |
| CreatedBy | The user who created the budgetary control validation transaction line. |
| CreationDate | The date and time when the budgetary control validation transaction line was created. |
| DataPurgedFlag | Indicates whether the activity related to the budgetary control validation transaction line has been purged from the budgetary control balances. |
| DataSetId | The unique identifier of the budgetary control validation attempt. |
| DraftFlag | Indicates whether the budgetary control validation transaction was attempted in draft or final mode. The draft mode only validates the transaction. The final mode reserves funds if the transaction passes the validation. |
| EncumbranceTypeCode | The code of the encumbrance type of the budgetary control validation transaction line. |
| EnteredAmount | The entered transaction amount in the transaction currency. |
| EnteredCurrency | The transaction currency. |
| FailureReasonCode | The code that indicates the reason the transaction line failed budgetary control validation when it isn't due to a control budget failure. A list of accepted values is defined in the lookup type ORA_XCC_BC_SC_FAIL_REASONS. |
| HeaderNum | Number assigned to a source transaction within a budgetary control validation attempt. |
| InventoryItemId | The identifier of the Inventory item on the transaction line. |
| JeCashAccountLineFlag | Indicates whether a GL or SLA journal line includes a cash account enabled for cash control. |
| JeCategoryCode | The journal category for transactions from general ledger and subledger accounting journals. |
| JeSourceCode | The journal source for transactions from general ledger and subledger accounting journals. |
| LastUpdateDate | The date and time when the budgetary control validation transaction line was last updated. |
| LastUpdateLogin | The session login associated with the user who last updated the budgetary control validation transaction line. |
| LastUpdatedBy | The user who last updated the budgetary control validation transaction line. |
| LedgerAmount | The transaction amount in the ledger currency. |
| LedgerId | The unique identifier of the ledger. |
| LineGroupCode | Identifier for grouping multiple transaction lines that are submitted as a group for budgetary control validation. |
| LineNum | Number assigned to a source transaction line within a budgetary control validation attempt. |
| LiquidationAmount | The transaction currency amount liquidated by the budgetary control validation process. |
| LiquidationDate | The date when the reserved funds for a previous related transaction is liquidated. |
| LiquidationDateCode | The code for determining the date to use when liquidating, reversing or reinstating the related predecessor or backing transaction. Valid values are SYSTEM_DATE, CURRENT_BUDGET, and PREDECESSOR_BUDGET. |
| LiquidationLineId1 | Identifier for the transaction line liquidated by the source transaction. |
| LiquidationLineId2 | Identifier for the transaction line liquidated by the source transaction. |
| LiquidationLineId3 | Identifier for the transaction line liquidated by the source transaction. |
| LiquidationLineId4 | Identifier for the transaction line liquidated by the source transaction. |
| LiquidationLineId5 | Identifier for the transaction line liquidated by the source transaction. |
| LiquidationLineId6 | Identifier for the transaction line liquidated by the source transaction. |
| LiquidationQuantity | The quantity liquidated by the budgetary control validation process. |
| LiquidationTransTypeCode | The code for the type of transaction being liquidated by the budgetary control validation process. A list of accepted values are defined in the lookup type XCC_TRANSACTION_TYPES. |
| OrderTypeInfo | The code representing the order type. Valid values are FIXED PRICE and QUANTITY, which indicate whether the monetary amount of the transaction line is the same as the entered transaction amount or calculated by multiplying the quantity and unit price of the item, respectively. |
| OverridableCode | The code for the type of override that's available when the budgetary control validation is processed in override or override check mode with partial reservation enabled. Valid values are NONE, OTHER, and UNOVERRIDABLE. |
| OverrideFlag | Indicates whether the budgetary control validation transaction line is overridden. |
| PartialReservationFlag | Indicates whether partial reservation is allowed. |
| PjcBillableFlag | Indicates whether the transaction line is subject to billing functions in Project Management. |
| PjcCapitalizableFlag | Indicates whether the transaction line is subject to capitalization functions in Project Management. |
| PjcContractId | The identifier of the contract of the Project Management transaction line. |
| PjcExpenditureItemDate | The expenditure item date of the Project Management transaction line. |
| PjcExpenditureTypeId | The identifier of the expenditure type of the Project Management transaction line. |
| PjcFundingSourceId | The identifier of the funding source of the Project Management transaction line. |
| PjcOrganizationId | The identifier of the organization of the Project Management transaction line. |
| PjcProjectId | The identifier of the project of the Project Management transaction line. |
| PjcResourceId | The identifier of the resource of the Project Management transaction line. |
| PjcTaskId | The identifier of the task of the Project Management transaction line. |
| PjcWorkTypeId | The identifier of the work type of the Project Management transaction line. |
| Price | The unit price of the item on the transaction line. |
| Quantity | The quantity of a good or service stated on the source transaction line. |
| ResultCode | Header Result Code |
| RevenueCodeCombinationId | The revenue account code combination for a receivables miscellaneous receipt transaction line or the receivables invoice of a receipt application transaction line. |
| SourceLineId1 | The source transaction line identifier 1. |
| SourceLineId2 | The source transaction line identifier 2. |
| SourceLineId3 | The source transaction line identifier 3. |
| SourceLineId4 | The source transaction line identifier 4. |
| SourceLineId5 | The source transaction line identifier 5. |
| SourceLineId6 | The source transaction line identifier 6. |
| SourceTransactionTypeCode | The source transaction type code. A list of accepted values are defined in the lookup type XCC_TRANSACTION_TYPES. |
| StatisticalAmount | The transaction amount of the transaction in a nonmonetary measure. |
| SuccessReasonCode | The code that indicates the acceptable reason the transaction line didn't impact any control budget. The transaction line could fail budgetary control validation if another line in the transaction fails or the transaction belongs to a group and a related transaction within the group fails. A list of accepted values is defined in the lookup type ORA_XCC_BC_SC_FAIL_REASONS. |
| TransactionSubtypeCode | Identifies the subtype of the transaction. A list of accepted values are defined in the lookup type XCC_TRANSACTION_SUBTYPES. |
| UomCode | The code of the unit of measure. |
| VendorId | The identifier of the supplier of the transaction line. |