Commerce Service Center uses the following database tables to store ticketing information. For a complete list of tables used by Commerce Service Center, refer to the ATG Commerce Service Center Installation and Programming Guide.
These tables are installed by the <ATG10dir>/CSC10.2/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 | Description |
|---|---|---|---|
id (primary key) | varchar(40) | not null | 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 | Description |
|---|---|---|---|
id (primary key) | varchar(40) | not null | 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 | Description |
|---|---|---|---|
id | varchar(40) | not null | 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 | Description |
|---|---|---|---|
id | varchar(40) | not null | 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 | Description |
|---|---|---|---|
id | varchar(40) | not null | 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 | Description |
|---|---|---|---|
id | varchar(40) | not null | 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 | Description |
|---|---|---|---|
id | varchar(40) | not null | 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 | Description |
|---|---|---|---|
id | varchar(40) | not null | 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. |
csrt_split_sg
This table stores ticketing records about splitting up items in orders among multiple shipping groups.
Column | Data Type | Constraint | Description |
|---|---|---|---|
id | varchar(40) | not null | 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 | Description |
|---|---|---|---|
id (primary key) | varchar(40) | not null | 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 | Description |
|---|---|---|---|
id (primary key) | varchar(40) | not null | 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 | Description |
|---|---|---|---|
id | varchar(40) | not null | 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 | Description |
|---|---|---|---|
id (primary key) | varchar(40) | not null | 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 | Description |
|---|---|---|---|
order_id | varchar(40) | not null | The ID of the order. |
ticket_id | varchar(40) | not null | The ID of the associated ticket. |
csrt_oma_event
This table stores ticketing information about changes made to adjustment updates.
Column | Data Type | Constraint | Description |
|---|---|---|---|
id (primary key) | varchar(40) | not null | 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 | Description |
|---|---|---|---|
id (primary key) | varchar(40) | not null | 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. |
csrt_appr_event
This table associates approval events with tickets.
Column | Data Type | Constraint | Description |
|---|---|---|---|
id (primary key) | varchar(40) | not null | The ID of the order. |
approval_id | varchar(40) | not null | The ID of the approval. |
update_type | integer | not null | The type of update. |
csrt_order_appr_event
This table associates order approval events with tickets.
Column | Data Type | Constraint | Description |
|---|---|---|---|
id (primary key) | varchar(40) | not null | The ID of the order. |
order_id | varchar(40) | not null | The ID of the order. |
csrt_grt_prom_event
This table associates promotion events with tickets.
Column | Data Type | Constraint | Description |
|---|---|---|---|
id (primary key) | varchar(40) | not null | The ID of the order. |
promo_id | varchar(40) | not null | The ID of the promotion. |
csrt_ign_prom_event
This table associates promotion events with tickets.
Column | Data Type | Constraint | Description |
|---|---|---|---|
id (primary key) | varchar(40) | not null | The ID of the order. |
promo_id | varchar(40) | not null | The ID of the promotion. |
order_id | varchar(40) | not null | The ID of the order. |
csrt_gl_event
This table associates gift list events with tickets.
Column | Data Type | Constraint | Description |
|---|---|---|---|
id (primary key) | varchar(40) | not null | The ID of the order. |
giftlist_id | varchar(40) | not null | The ID of the gift list. |
event_name | varchar(40) | not null | The name of the event. |
csrt_gi_event
This table associates updated gift list events with tickets.
Column | Data Type | Constraint | Description |
|---|---|---|---|
id (primary key) | varchar(40) | not null | The ID of the order. |
catalog_ref_id | integer | null | The ID of the catalog. |
old_quantity | integer | null | The previous quantity of items within the list. |
new_quantity | integer | null | The new quantity of items within the list. |
