DOCUMENT TYPE Table
View exposing financial document type reference data, including document type identifiers and descriptions used to classify general ledger and subledger transactions for reporting and analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DOCUMENT_TYPE_DESCRIPTION |
Short descriptive name of the document type associated with the document type identifier. |
VARCHAR2 |
25 |
DOCUMENT_TYPE_ID |
Business identifier code representing the document type as defined by the source system. |
VARCHAR2 |
3 |
DOCUMENT_TYPE_KEY |
Primary key uniquely identifying the document type record within the warehouse. |
VARCHAR2 |
3 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse for auditing and data lineage purposes. |
DATE |