The table stores the comments for an order entered
by a customer service representative.
Column Descriptions:
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 | 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:
<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:
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 |