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