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 | Double | The transaction amount in the budget currency. |
| ControlBudgetAmount | Double | The budget entry transaction amount in the control budget currency. |
| ReservedBudgetAmount | Double | 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 | Double | Initial budget balance of the control budget. |
| BudgetAdjustmentBalance | Double | All changes made to the initial budget balance of the control budget. |
| TotalBudgetBalance | Double | Total budget balance of the control budget. |
| TotalConsumptionBalance | Double | Total budget consumption amount consisting of expenditure amounts incurred and amounts at different degrees of committed stages. |
| FundsAvailableBalance | Double | 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 | Double | 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's used to convert the transactions. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| SourceBudget | String | SourceBudget |
| Finder | String | finder |