DW_SPEND_REQUISITION_CLASSIFICATION_MAP_G
Spend Requisition classification.
Details
Module: Purchasing
Key Columns
TAXONOMY_ID, REQUISITION_DISTRIBUTION_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| REQUISITION_DISTRIBUTION_ID | NUMBER | 38 | 0 | True | Requisition distribution identifier. | ||
| TAXONOMY_ID | NUMBER | 38 | 0 | True | Unique identifier of the taxonomy. | ||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. System Column | ||||
| CATEGORY_ID | NUMBER | 38 | 0 | Uniquely identifies the category. #1 | DW_PURCHASING_CATEGORIES_DH | CATEGORY_ID |
Notes
#1 In addition to CATEGORY_ID, TAXONOMY_ID need to be joined for category dimensions.
Category reference dimensions depend on taxonomy.
When Purchasing taxonomy, use DW_PURCHASING_CATEGORIES_DH dimension.
When Unspsc taxonomy, use DW_UNSPSC_CATEGORIES_DH dimension.
When Custom 1 taxonomy, use DW_CUSTOM1_CATEGORIES_DH dimension.
When Custom 2 taxonomy, use DW_CUSTOM2_CATEGORIES_DH dimension.
When Custom 3 taxonomy, use DW_CUSTOM3_CATEGORIES_DH dimension.