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 |