# DW_SPEND_PURCHASE_ORDER_CLASSIFICATION_MAP_G

Spend Purchase Order classification.

## Details

Module: Purchasing

## Key Columns

PO_DISTRIBUTION_ID, TAXONOMY_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
PO_DISTRIBUTION_ID | NUMBER | 38 | 0 | True | Purchase Order 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.

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