# DW_ITEM_SUPPLIER_ASSOCIATIONS_D (Preview)

This table requires activation of Item Management functional area. This table stores Item Supplier Associations details.

## Details

Module: Product Hub

## Key Columns

SUPPLIER_PARTY_ID, INVENTORY_ITEM_ID, VERSION_ID, ACD_TYPE, SUPPLIER_PARTY_SITE_ID, CHANGE_LINE_ID, ORGANIZATION_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
INVENTORY_ITEM_ID | NUMBER | 38 | 0 | True | Inventory Item Identifier | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID
ORGANIZATION_ID | NUMBER | 38 | 0 | True | Organization Identifier | DW_INVENTORY_ITEM_D | ORGANIZATION_ID
ACD_TYPE | VARCHAR2 | 32 |  | True | Indicates the type of change performed on Item Supplier Site Organization Association. |  |
CHANGE_LINE_ID | NUMBER | 38 | 0 | True | Supplier Association Change line Identifier |  |
VERSION_ID | NUMBER | 38 | 0 | True | Version number to identify a version uniquely within a revision. |  |
SUPPLIER_PARTY_ID | NUMBER | 38 | 0 | True | Supplier Identifier | DW_PARTY_D | PARTY_ID
SUPPLIER_PARTY_SITE_ID | NUMBER | 38 | 0 | True | Supplier Site Identifier |  |
SOURCE_RECORD_ID | VARCHAR2 | 999 |  |  | This column is for Oracle Internal use only. Source Record Identifier |  |
SUPPLIER_PARTY_SITE_NAME | VARCHAR2 | 256 |  |  | Supplier site name. |  |
SUPPLIER_PARTY_SITE_NUMBER | VARCHAR2 | 32 |  |  | Supplier site number. |  |
SUPPLIER_PARTY_SITE_LOCATION_ID | NUMBER | 38 | 0 |  | Supplier site location identifier | DW_CUSTOMER_LOCATION_D | CUSTOMER_LOCATION_ID
PRIMARY_FLAG | VARCHAR2 | 16 |  |  | Primary Association Flag | DW_EGP_COMMON_YES_NO_CHAR_LKP_TL | EGP_COMMON_YES_NO_CHAR_CODE
STATUS_CODE | NUMBER |  |  |  | Association Status Code | DW_EGO_ITEM_ASSOC_STATUS_LKP_TL | EGO_ITEM_ASSOC_STATUS_CODE
CREATION_DATE | TIMESTAMP |  |  |  | Supplier Association Creation Timestamp |  |
LAST_UPDATE_DATE | TIMESTAMP |  |  |  | Supplier Association Last Update Timestamp |  |

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