PRODUCTPARTYROLE

The PRODUCTPARTYROLE table represents an association that links contacts to the various roles they can have on a product.

This table is used by the following domain.
Name Comment Datatype Null Option Is PK
PRODUCT_PARTY_ROLE_ID A unique, system-generated key that identifies a product party role in the system. BIGINT Not Null Yes
PRODUCT_ID A unique, system-generated key that identifies a product instance in the system. BIGINT Null No
CONT_ID A unique, system-generated key that identifies a party in the system. BIGINT Null No
ADMIN_CLIENT_ID Uniquely identifies the primary key for a party in the administrative source system. VARCHAR(250) Null No
ADMIN_PRODUCT_ID Uniquely identifies the primary key for a product in the administrative source system. VARCHAR(250) Null No
ADDITIONAL_DETAILS Any additional details to be captured about the role. VARCHAR(250) Null No
START_DT The date when this record becomes active. TIMESTAMP Not Null No
END_DT The date when this record becomes inactive. TIMESTAMP Null No
END_REASON_TP_CD Identifies the cause for why a role was ended. BIGINT Null No
PRODUCT_PARTY_ROLE_TP_CD Identifies the type of role that a party can have on a product. For example "Supplier", "Vendor", "Retailer", "Item Analyst", or "Consumer". BIGINT Not Null No
ADMIN_SYS_TP_CD Uniquely identifies the administrative source system for a party or product. BIGINT Null No
LAST_UPDATE_DT When a record is added or updated, this field is updated with the date and time. On subsequent updates, the system uses this information to ensure that the update request includes a matching date and time on this field; if it does not, the update fails. TIMESTAMP Not Null No
LAST_UPDATE_TX_ID A unique, system-generated key that identifies the specific transaction within the log system that either created, updated, or deleted the data row. BIGINT Null No
LAST_UPDATE_USER The ID of the user who last updated the data. VARCHAR(20) Null No