BUDGET DOCUMENT TYPE Table
View exposing budget document type reference data including transaction type and document type codes, descriptions, and sort sequences.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
BUDGET_DOCUMENT_TYPE |
Budget document type as provided by the source. |
VARCHAR2 |
60 |
BUDGET_DOCUMENT_TYPE_CODE |
Code identifying budget document type. |
VARCHAR2 |
2 |
BUDGET_DOCUMENT_TYPE_KEY |
Surrogate key identifying the budget document type. |
VARCHAR2 |
3 |
BUDGET_DOCUMENT_TYPE_SEQ |
Budget document type seq as provided by the source. |
NUMBER |
5 |
BUDGET_TRANSACTION_TYPE |
Budget transaction type as provided by the source. |
VARCHAR2 |
40 |
BUDGET_TRANSACTION_TYPE_CODE |
Code identifying budget transaction type. |
VARCHAR2 |
1 |
BUDGET_TRANSACTION_TYPE_SEQ |
Budget transaction type seq as provided by the source. |
NUMBER |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |