Commerce Service Center uses the following database tables to store agent approval information.
These tables are installed by the <ATG10dir>/CSC10.2/DCS-CSR/sql/
db_components/database-vendor
/DCS-CSR_profile_ddl.sql
script.
csr_agent_app_limit
This table stores the approval limits for agents.
Column | Data Type | Constraint | Description |
---|---|---|---|
agent_id | varchar(40) | not null | The ID of the agent. |
currency | varchar(3) | not null | The ID of the order. |
app_limit | numeric(19) | null | The limit that an agent can approve. |