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.
HCL Commerce Version 9.1.12.0 or laterSELLERORG_ID BIGINT The Seller Organization ID.
HCL Commerce Version 9.1.13.0 or laterAUTO SMALLINT This flag indicates if the comment is automatically generated (1), or manually provided (0).
HCL Commerce Version 9.1.13.0 or laterOBJECT_NAME VARCHAR(4) The related object comment is associated with the following:
  • APP - appeasement
  • APPI – appeasement item
  • RTN – order return
  • RTNI – order return item
  • ORD – order
  • ORDI – order item
HCL Commerce Version 9.1.13.0 or laterOBJECT_ID BIGINT The unique id of the related object.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ORCOMMENT_IDPrimary Key
I0000632ORDERS_IDNon-Unique Index
I0001264ORDCHGRSN_IDNon-Unique Index
I0001265SERVICEREP_IDNon-Unique Index
HCL Commerce Version 9.1.13.0 or laterI_ORCOMMENT_AUTO AUTO Non-Unique Index
HCL Commerce Version 9.1.13.0 or laterI_ORCOMMENT_OBJECT_NAME OBJECT_NAME Non-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
HCL Commerce Version 9.1.12.0 or laterF_ORC_SELLER SELLERORG_ID ORGENTITY ORGENTITY_ID Cascade