ORCOMMENT

The table stores the comments for an order entered by a customer service representative.

Column Descriptions:

Name	Type	Description
ORCOMMENT_ID	BIGINT NOT NULL	Generated unique key.
ORDERS_ID	BIGINT NOT NULL	The Order.
LASTUPDATE	TIMESTAMP	The time this comment is created.
COMMENTS	VARCHAR (3000)	The content of the comment.
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.
ORDCHGRSN_ID	INTEGER	Reference to the order change reason code table.
SERVICEREP_ID	BIGINT	The user ID of the service representative that created this order change comment.
BUSCHN_ID	INTEGER	Indicate the channel the order was changed.
ORDERVERSION	SMALLINT	The order version
FIELD1	INTEGER	Customizable field.
FIELD2	VARCHAR (254)	Customizable field.
FIELD3	TIMESTAMP	Customizable field.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	ORCOMMENT_ID	Primary Key
I0000632	ORDERS_ID	Non-Unique Index
I0001264	ORDCHGRSN_ID	Non-Unique Index
I0001265	SERVICEREP_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_483	ORDERS_ID	ORDERS	ORDERS_ID	Cascade
R_3456	ORDCHGRSN_ID	ORDCHGRSN	ORDCHGRSN_ID	Cascade
R_3462	SERVICEREP_ID	USERS	USERS_ID	Cascade
R_3463	BUSCHN_ID	BUSCHN	BUSCHN_ID	Cascade

Related reference
Order data model