DW_TRADING_PARTNER_ITEMS_D (Preview)
This table requires activation of Item Management functional area. This table Stores the information of Trading Partner Items.
Details
Module: Product Hub
Key Columns
TRADING_PARTNER_ITEM_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| TRADING_PARTNER_ITEM_ID | NUMBER | 38 | 0 | True | Trading Partner Item Identifier | ||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. Source Record Identifier | ||||
| TRADING_PARTNER_ID | NUMBER | 38 | 0 | Trading Partner Item Identifier | DW_PARTY_D | PARTY_ID | |
| TRADING_PARTNER_TYPE_CODE | VARCHAR2 | 32 | Trading Partner Type Code | DW_EGP_TP_TYPES_LKP_TL | EGP_TP_TYPES_CODE | ||
| TRADING_PARTNER_ITEM_NUMBER | VARCHAR2 | 256 | Trading Partner Item Number | ||||
| TRADING_PARTNER_ITEM_DESC | VARCHAR2 | 512 | Trading Partner Item Description | ||||
| TRADING_PARTNER_PART_STATUS_CODE | VARCHAR2 | 32 | Trading Partner Part Status Code | DW_ORA_ACA_MFR_PART_STATUS_LKP_TL | ORA_ACA_MFR_PART_STATUS_CODE | ||
| TRADING_PARTNER_ITEMS_START_DATE | DATE | Trading Partner Items Start Date | |||||
| TRADING_PARTNER_ITEMS_END_DATE | DATE | Trading Partner Items End Date | |||||
| TRADING_PARTNER_ITEMS_CREATION_TIMESTAMP | TIMESTAMP | Trading Partner Items Creation Timestamp | |||||
| TRADING_PARTNER_ITEMS_LAST_UPDATE_TIMESTAMP | TIMESTAMP | Trading Partner Items Last Update Timestamp |