JDBC Driver for Oracle Financials Cloud

Build 22.0.8462

BudgetaryControlResultsBudgetTransactions

BudgetaryControlResultsBudgetTransactions

Columns

Name Type Description
TransactionNumber [KEY] String The transaction number.
LineNumber String The budget entry line number.
ControlBudget String The control budget name.
ControlBudgetPeriod String The name of the budget period of the control budget.
BudgetAccount String The combination of budget segment values.
TransactionAmount String The transaction amount in the budget currency.
ControlBudgetAmount String The budget entry transaction amount in the control budget currency.
ReservedBudgetAmount String The amount that was updated to the budget balance of the control budget.
BudgetTransactionType String Indicates whether the budget entry transaction is an initial budget or a budget adjustment.
FundsAction String Indicates whether funds check or funds reservation is performed for the budget entry transaction. Funds check doesn't update budget balances. Funds reservation updates budget balances when budgetary control validation doesn't fail.
BatchResult String The budgetary control status code for the batch, such as success or failed.
BatchFatalErrorMessage String The message of an unexpected error.
HeaderStatus String The budgetary control status for a budget entry transaction, such as passed, warning, or failed.
HeaderResult String The budgetary control result for the budget entry transaction.
LineStatus String The budgetary control status for a budget entry transaction line, such as passed, warning, or failed.
LineResult String The budgetary control result for a budget entry transaction line.
ActivityStatus String The budgetary control status for the control budget activity of the budget entry transaction line such as passed, warning, or failed.
ActivityResult String The budgetary control result for the control budget activity of the budget entry transaction line.
InitialBudgetBalance String Initial budget balance of the control budget.
BudgetAdjustmentBalance String All changes made to the initial budget balance of the control budget.
TotalBudgetBalance String Total budget balance of the control budget.
TotalConsumptionBalance String Total budget consumption amount consisting of expenditure amounts incurred and amounts at different degrees of committed stages.
FundsAvailableBalance String Funds available amount for consumption.
BudgetManager String The budget manager who manages the control budget.
ControlBudgetCurrency String The currency of the control budget.
TransactionCurrency String The transaction currency.
ConversionDate Date The date when a conversion rate is used to convert the entered budget amount into the control budget currency.
ConversionRate String The currency conversion rate used to convert the entered transaction amount to the control budget currency amount.
UserConversionType String The source of a currency conversion rate, such as, user defined or corporate, that is used to convert the transactions.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462