DW_SPEND_REQUISITION_CLASSIFICATION_MAP_G (Preview)

This table requires activation of Spend Classification functional area. Spend Requisition classification.

Details

Module: Purchasing

Key Columns

TAXONOMY_ID, REQUISITION_DISTRIBUTION_ID

Columns

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     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.

Copyright © 2019, 2023, Oracle and/or its affiliates.