BudgetaryControlResultsBudgetImpacts
BudgetaryControlResultsBudgetImpacts
Columns
| Name | Type | Description |
| BudgetCcid [KEY] | Long | The budget account identifier for the transaction. |
| ControlBudgetId [KEY] | Long | The control budget identifier. |
| PeriodName [KEY] | String | The name of the budget period. |
| TransactionNumber | String | The transaction number. |
| Amount | Double | The transaction amount in the budget currency. |
| EnteredAmount | Double | The entered transaction amount in the transaction currency. |
| ResultCode | String | The budgetary control validation status code for the transactions. |
| CurrencyCode | String | The currency of the control budget. |
| Name | String | The control budget name. |
| AccountedProjectAmount | Double | Reserved project expenditure amount. |
| AccountedPayablesAmount | Double | Reserved payables expenditure amount. |
| AccountedReceiptsAmount | Double | Reserved receipt expenditure amount. |
| ActualAmount | Double | Consumption amount spent and classified as an expenditure. |
| ApprovedAuthorizationAmount | Double | Reserved spend authorization amount. |
| ApprovedCommitmentAmount | Double | Reserved requisition amount. |
| ApprovedObligationAmount | Double | Reserved purchase order amount. |
| BudgetAdjustmentAmount | Double | Changes made to the initial budget amount. |
| BudgetAmount | Double | The total budget balance amount. |
| CommitmentAmount | Double | Consumption amount expected to be spent without a legal obligation. |
| DetailOtherAmount | Double | Reserved encumbrance amount excluding commitments or obligations. |
| FundsAvailableAmount | Double | Funds available amount for consumption. |
| MiscExpendituresAmount | Double | Reserved expenditure amount excluding payables, receipts and projects. |
| ObligationAmount | Double | Consumption amount with a legal obligation to pay in the future. |
| OtherAmount | Double | Consumption amount for encumbrances excluding commitments or obligations. |
| UnreleasedBudgetAmount | Double | Budget amount that's not released for consumption. |
| TotalConsumption | Double | Total budget consumption amount consisting of expenditure amounts incurred and amounts at different degrees of committed stages. |
| BudgetAccount | String | The budget account for the transaction. |
| FundsConsumed | Double | The amount consumed from the control budget. |
| Status | String | The budgetary control validation status for the transactions. |
| BudgetManager | String | The budget manager who manages the control budget. |
| AdditionalRequired | Double | Amount needed beyond the remaining budget funds available to cover the cost of a specific transaction. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| DataSetId | Long | DataSetId |
| DraftFlag | String | DraftFlag |
| SourceHeaderId1 | String | SourceHeaderId1 |
| SourceHeaderId2 | String | SourceHeaderId2 |
| SourceLineId1 | String | SourceLineId1 |
| SourceLineId2 | String | SourceLineId2 |
| SourceLineId3 | String | SourceLineId3 |
| SourceLineId4 | String | SourceLineId4 |
| SourceLineId5 | String | SourceLineId5 |
| TransactionTypeCode | String | TransactionTypeCode |
| Finder | String | finder |