ATG Commerce Service Center uses the following database tables to store ticketing information.
These tables are installed by the <ATG9dir>/CSC9.3/DCS-CSR/sql/db_components/
database-vendor
/DCS-CSR_ticketing_ddl.sql
script.
The tables described in this section are all used by the ticketing repository. The Nucleus component for this repository is /atg/ticketing/TicketingRepository
.
csrt_grant_appease
This table stores ticketing records about the granting of appeasements (store credits).
Column | Data Type | Constraint |
---|---|---|
id | varchar(40) | not null |
(primary key) | The unique ID of the record. | |
appeasement_id | varchar(40) | null |
The ID of the store credit. | ||
amount | double precision | null |
The amount of the store credit. |
csrt_price_overrde
This table stores ticketing records of manual price overrides.
Column | Data Type | Constraint |
---|---|---|
id | varchar(40) | not null |
(primary key) | The unique ID of the record. | |
order_id | varchar(40) | null |
The ID of the order containing the price override. | ||
component_id | varchar(40) | null |
The ID of the order component (item or shipping group) whose price was overridden. | ||
component_type | varchar(40) | null |
The type of the order component whose price was overridden. Possible values: commerceItem, shippingGroup. | ||
old_price | double precision | null |
The calculated price of the item or shipping group. | ||
new_price | double precision | null |
The actual price charged to the customer for the item or shipping group. |
csrt_order_event
This table stores ticketing records about orders that have been modified.
Column | Data Type | Constraint |
---|---|---|
id | varchar(40) | not null |
(primary key) | The unique ID of the record. | |
order_id | varchar(40) | null |
The ID of the modified order. | ||
amount | double precision | null |
The total cost of the order. |
csrt_return_order
This table stores ticketing records of returned orders.
Column | Data Type | Constraint |
---|---|---|
id | varchar(40) | not null |
(primary key) | The unique ID of the record. | |
ret_req_id | varchar(40) | null |
The ID of the return request. | ||
repl_order_id | varchar(40) | null |
The ID of the replacement order (for an exchange). |
csrt_recv_rtrn_itm
This table stores ticketing records of receipt of returned items.
Column | Data Type | Constraint |
---|---|---|
id | varchar(40) | not null |
(primary key) | The unique ID of the record. | |
item_id | varchar(40) | null |
The commerce item ID of the returned item. | ||
quantity | integer | null |
The quantity of the item that was returned. |
csrt_claim_item
This table stores ticketing records of the claiming of coupons, gift certificates, and store credits.
Column | Data Type | Constraint |
---|---|---|
id | varchar(40) | not null |
(primary key) | The unique ID of the record. | |
claimable_id | varchar(40) | null |
The ID of the coupon, gift certificate, or store credit. | ||
claimable_type | varchar(40) | null |
Type of item claimed (coupon, gift certificate, or store credit). |
csrt_ci_event
This table stores ticketing records about changes to the quantities of items in orders.
Column | Data Type | Constraint |
---|---|---|
id | varchar(40) | not null |
(primary key) | The unique ID of the record. | |
item_id | varchar(40) | null |
The ID of the commerce item whose quantity was changed. | ||
old_quantity | integer | null |
The previous quantity of the item. | ||
new_quantity | integer | null |
The new quantity of the item. |
csrt_pg_event
This table stores ticketing records about changes to payment groups in orders.
Column | Data Type | Constraint |
---|---|---|
id | varchar(40) | not null |
(primary key) | The unique ID of the record. | |
pay_group_id | varchar(40) | null |
The ID of the payment group that was changed. | ||
update_type | tinyint | not null |
The type of update performed. 0=modify; 1=remove; 2=add. |
csrt_split_sg
This table stores ticketing records about splitting up items in orders among multiple shipping groups.
Column | Data Type | Constraint |
---|---|---|
id | varchar(40) | not null |
(primary key) | The unique ID of the record. | |
src_ship_group_id | varchar(40) | null |
The shipping group the item was moved from. | ||
dest_ship_group_id | varchar(40) | null |
The shipping group the item was moved to. | ||
commerce_item_id | varchar(40) | null |
The ID of the commerce item that was moved. | ||
quantity | integer | not null |
The quantity of the item that was moved. |
csrt_split_cc
This table stores ticketing records about splitting up item costs among multiple cost centers.
Column | Data Type | Constraint |
---|---|---|
id | varchar(40) | not null |
(primary key) | The unique ID of the record. | |
src_cost_ctr_id | varchar(40) | null |
The cost center that the item’s costs were moved from. | ||
dest_cost_ctr_id | varchar(40) | null |
The cost center that the item’s costs were moved into. | ||
commerce_ident_id | varchar(40) | null |
The ID of the commerce item whose costs were moved. | ||
quantity | integer | not null |
The quantity of the item whose costs were moved. |
csrt_sg_event
This table stores ticketing records about changes to shipping groups in orders.
Column | Data Type | Constraint |
---|---|---|
id | varchar(40) | not null |
(primary key) | The unique ID of the record. | |
ship_group_id | varchar(40) | null |
The ID of the shipping group that was changed. | ||
update_type | integer | not null |
The type of update performed. 0=modify; 1=remove; 2=add. |
csrt_order_comment
This table stores ticketing records about order comments submitted by agents.
Column | Data Type | Constraint |
---|---|---|
id | varchar(40) | not null |
(primary key) | The unique ID of the record. | |
comment_id | varchar(40) | null |
The ID of the comment. |
csrt_update_org
This table stores ticketing information about changes made to organization profiles.
Column | Data Type | Constraint |
---|---|---|
id | varchar(40) | not null |
(primary key) | The unique ID of the record. | |
updated_item_id | varchar(40) | Null |
The ID of the organization profile that was modified. |
csrt_orders
This table associates orders with tickets.
Column | Data Type | Constraint |
---|---|---|
order_id | varchar(40) | not null |
(primary key) | The ID of the order. | |
ticket_id | varchar(40) | not null |
(primary key) | The ID of the associated ticket. |
csrt_oma_event
This table stores ticketing information about changes made to adjustment updates.
Column | Data Type | Constraint |
---|---|---|
id | varchar(40) | not null |
(primary key) | The unique ID of the record. | |
man_adj_id | varchar(40) | not null |
The unique ID of the manual adjustment. | ||
adjustment_type | varchar(40) | null |
The type of adjustment. | ||
update_type | integer | not null |
The type of update. | ||
reason | integer | not null |
The number of the reason for the adjustment |
csrt_schd_event
This table associates scheduled events with tickets.
Column | Data Type | Constraint |
---|---|---|
id | varchar(40) | not null |
(primary key) | The ID of the order. | |
schd_order_id | varchar(40) | not null |
The ID of the scheduled order. | ||
update_type | integer | not null |
The type of update. |