Commerce Service Center uses the following database tables to store order approval information. These are stored in the approvals repository located in /atg/commerce/custsvc/approvals/approvals-repository
.
csr_approval
This table stores information about the approval process.
Column | Data Type | Constraint | Description |
---|---|---|---|
approval_id | varchar (40) | not null | The unique ID of the approval. |
ticket_id | varchar (40) | not null | The ID of the ticket. |
agent_id | varchar (40) | not null | The ID of the agent. |
approver_id | varchar (40) | not null | The unique ID of the approver. |
type | int | not null | The type of approval. The value is |
approval_state | int | not null | The state of the approval. Values can be identified by code with the
|
site_id | varchar (40) | null | The unique ID of the site. |
customer_id | varchar (40) | null | The unique ID of the customer. |
creation_date | timestamp | not null | The date the approval was created. |
completion_date | timestamp | null | The date the approval was completed. |
csr_order_approval
This table stores information specific to an order approval.
Column | Data Type | Constraint | Description |
---|---|---|---|
approval_id | varchar (40) | not null | The ID of the approval. |
order_id | varchar (40) | not null | The ID of the order. |
customer_email | varchar (40) | null | The e-mail of the customer. |
appeasement_total | double-precision | not null | The total appeasements. |
order_total | double-precision | not null | The total of the order. |