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

## Key Columns

TRADING_PARTNER_ITEM_ID

## Columns

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

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