FV_BE_EXTRACT_GT
This temportary table will be populated with budget transactions that needs to be Fund checked or approved.
Details
-
Schema: FUSION
-
Object owner: FV
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DATA_SET_ID | NUMBER | 18 | Yes | Budgetary control data set identifier stamped during approval. | |
| DOCUMENT_ID | NUMBER | 18 | Yes | Identifier for the budget transaction document | |
| REVISION_NUMBER | NUMBER | 18 | Yes | Revision number of the budget document | |
| TRANSACTION_NUMBER | VARCHAR2 | 50 | Yes | Transaction number of the budget document | |
| TRANSACTION_LINE_ID | NUMBER | 18 | Yes | Identifier for the budget transaction line | |
| CONTROL_BUDGET_ID | NUMBER | 18 | Yes | Control budget associated to this extract line | |
| GL_CODE_COMBINATION_ID | NUMBER | 18 | Yes | GL code combination identifier associated with this extract line | |
| BUDGET_LEVEL_ID | NUMBER | 18 | Yes | Budget level identifier for the budget document | |
| TRANSACTION_SUBTYPE_CODE | VARCHAR2 | 100 | Yes | Transaction sub type associated with this budget transaction line | |
| LEDGER_ID | NUMBER | 18 | Yes | Identifier for the ledger | |
| ACCOUNTING_DATE | DATE | Yes | Accounting date of the transaction | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Yes | Currency code associated with this transaction line | |
| AMOUNT | NUMBER | Yes | Budget transaction line amount | ||
| FUND_STATUS_CODE | VARCHAR2 | 30 | To identify funds check status stamped by budgetary control package |