Commerce Service Center uses the following database tables to store customer service information. These tables are installed when you run the CIM script.
The csr_order_cmts
table is used by the Commerce order repository. The Nucleus component for this repository is /atg/commerce/order/OrderRepository
. The rest of the tables described in this section are used by the Commerce Service Center returns and exchanges repository (/atg/commerce/custsvc/
).
CsrRepository
csr_order_cmts
This table stores agent comments associated with orders.
Column | Data Type | Constraint | Description |
---|---|---|---|
comment_id (primary key) | varchar(40) | not null | The unique ID associated with the comment. |
order_id (primary key) | varchar(40) | not null | The ID of the order the comment is associated with. References |
agent_id | varchar(40) | null | The profile ID of the agent who submitted the comment. |
comment_data | varchar | not null | The text of the comment. |
creation_date | timestamp | null | The date and time when the comment was submitted. |
version | integer | not null | The GSA version of the repository item. |