JDBC Driver for Oracle Financials Cloud

Build 22.0.8462

BudgetaryControlResults

BudgetaryControlResults

Columns

Name Type Description
TransactionNumber String The transaction number.
EnteredAmount String The entered transaction amount in the transaction currency.
EnteredCurrency String The transaction currency.
Amount String The transaction amount in the budget currency.
CurrencyCode String The currency of the control budget.
ControlBudgetId String The control budget identifier.
Name String The control budget name.
PeriodName String The name of the budget period.
BudgetCcid String The budget account identifier for the transaction.
ConversionDate Date The date on which a conversion rate is used to convert the transaction entered amount into the budget currency.
ConversionRate String The currency conversion rate used to convert the entered transaction amount to the 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.
SourceHeaderId1 String The source transaction identifier 1.
SourceHeaderId2 String The source transaction identifier 2.
SourceLineId1 String The source transaction line identifier 1.
SourceLineId2 String The source transaction line identifier 2.
SourceLineId3 String The source transaction line identifier 3.
SourceLineId4 String The source transaction line identifier 4.
SourceLineId5 String The source transaction line identifier 5.
DataSetId String The budgetary control validation processing data set identifier.
TransactionTypeCode String The source transaction type code.
DraftFlag Bool The funds check versus funds reservation indicator.
ResultCode String The budgetary control validation status code for the transactions.
BudgetAccount String The budget account for the transaction.
FundsConsumed String The amount consumed from the control budget.
Status String The budgetary control validation status for the transactions.
BalanceType String The balance type of various amounts, such as obligation, commitment, other, and actual amounts.
ProjectBurden String Indicates whether a line item listed in the budgetary control results represents a project overhead cost, such as fringe, overhead, and materials handling.
BudgetManager String The budget manager who manages the control budget.

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