REPCUSTREL

This table defines the relationship between a customer service representative or team of representatives, and the customer or customer group that they are assigned to.

Column Descriptions:

Name	Type	Description
REP_ID	BIGINT NOT NULL	The member id of the customer service representative or service representative group that the relationship is for.
CUST_ID	BIGINT NOT NULL	The member id of the customer or customer group that the service representative is related to.
SEQUENCE	DOUBLE NOT NULL DEFAULT 0	This determines the lookup sequence for relationships.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	REP_ID+CUST_ID	Primary Key
I0000965	CUST_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_1230	CUST_ID	MEMBER	MEMBER_ID	Cascade
F_1231	REP_ID	MEMBER	MEMBER_ID	Cascade