ORCOMMENT

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

Column Descriptions:

NameTypeDescription
ORCOMMENT_IDBIGINT NOT NULLGenerated unique key.
ORDERS_IDBIGINT NOT NULLThe Order.
LASTUPDATETIMESTAMPThe time this comment is created.
COMMENTSVARCHAR (3000)The content of the comment.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
ORDCHGRSN_IDINTEGERReference to the order change reason code table.
SERVICEREP_IDBIGINTThe user ID of the service representative that created this order change comment.
BUSCHN_IDINTEGERIndicate the channel the order was changed.
ORDERVERSIONSMALLINTThe order version
FIELD1INTEGERCustomizable field.
FIELD2VARCHAR (254)Customizable field.
FIELD3 TIMESTAMP Customizable field.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ORCOMMENT_IDPrimary Key
I0000632ORDERS_IDNon-Unique Index
I0001264ORDCHGRSN_IDNon-Unique Index
I0001265SERVICEREP_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_483ORDERS_IDORDERSORDERS_IDCascade
R_3456ORDCHGRSN_IDORDCHGRSNORDCHGRSN_IDCascade
R_3462SERVICEREP_IDUSERSUSERS_IDCascade
R_3463 BUSCHN_ID BUSCHN BUSCHN_ID Cascade