These tables are installed using /templates/DCS/sql/order_returns_ddl.xml. They are configured using the /config/atg/commerce/custsvc/CsrRepository.xml file:
csr_exch
This table stores information about order exchanges and returns.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The unique ID of the return. |
| varchar(40) | not null | The ID of the order the return is associated with. References |
| timestamp | not null | The date and time the return was submitted. |
| varchar(40) | not null | The current status of the return. Possible values: |
| varchar(40) | null | The RMA number associated with the return. (This value is the same as the ID of the return.) |
| varchar(40) | null | The ID of the order containing the replacement items for the return. |
| varchar(40) | null | Tracks the system generated store credit to adjust original and replacement order payments. |
| double precision | not null | The suggested tax refund calculated by return processing. |
| double precision | not null | The actual tax refund given by the agent. |
| double precision | not null | The suggested shipping refund calculated by return processing. |
| double precision | not null | The actual shipping refund given by the agent. |
| double precision | not null | Other refund types. |
| Boolean | not null | Boolean indicating whether the return should be processed immediately (i.e., before the return shipment is received). Checks |
| Boolean | not null | Boolean indicating whether the return has been processed. Check s processed in (0,1). |
| enum | null | The numeric code for the origin of the return. |
| varchar(40) | null | The unique ID of the agent. |
csr_exch_cmts
This table stores agent comments associated with exchanges or returns.
Column | Data Type | Constraint | Description |
---|---|---|---|
comment_id (primary key) | varchar(40) | not null | The unique ID of this comment. |
| varchar(40) | not null | The ID of the return the comment is associated with. References |
| varchar(40) | null | The profile ID of the agent who submitted the comment. |
| varchar(254) | not null | The text of the comment. |
| timestamp | null | The date and time when the comment was submitted. |
| integer | not null | The GSA version number of the repository item. |
csr_exch_reasons
This table stores the return reason codes available to agents.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The unique ID of the return reason. |
| varchar(254) | not null | The description of the return reason. |
csr_exch_item_disp
This table stores the returned item dispositions available to agents.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The unique ID of the disposition. |
| varchar(254) | not null | The description of the disposition. |
| Boolean | not null | Boolean indicating whether the inventory should be updated when an item is returned with this disposition. Checks |
csr_return_fee
This table stores the processing fees associated with returns or exchanges.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The unique ID of the return or exchange. References |
| double precision | not null | The amount of the return fee. |
csr_exch_item
This table stores information about items that have been marked for return or exchange.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The unique ID of the item being returned. |
| varchar(40) | not null | The ID in the order repository of the commerce item being returned. |
| varchar(40) | not null | The ID in the order repository of the shipping group that the item was shipped in. References |
| long(19,0) | not null | The quantity of the item being returned. |
| long(19,0) | not null | The quantity of the item to replace. |
| varchar(40) | not null | The ID of the return reason code for the item. References |
| Boolean | not null | Boolean indicating whether return shipment of the item is required before processing the refund or exchange. Checks |
| long(19,0) | not null | The quantity of the item that has been received through return shipment. |
| varchar(40) | null | The ID of the disposition code for the item. References |
| double precision | not null | The amount to be refunded for this item. |
| varchar(40) | not null | The return status of the item. Possible values: |
| varchar(40) | not null | The ID of the return that the item is associated with. |
| double precision | not null | Suggested shipping refund amount. |
| double precision | not null | The actual shipping refund amount. |
| double precision | not null | Suggested tax refund amount. |
| double precision | not null | The actual tax refund amount. |
csr_exch_items
This table associates returned items with their returns.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The ID of the return. References |
| set | not null | The ID of the replacement item. References |
csr_exch_method
This table stores information about the refund associated with a return.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The unique ID of the refund. |
| enum | not null | The type of refund. 1=credit card; 2=store credit. |
| double precision | null | The amount of the refund. |
csr_exch_methods
This table associates refunds with their returns.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The ID of the return. References |
| set | not null | The ID of the refund. References |
csr_exch_ipromos
This table stores information about the item promotion IDs used to determine refund values.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The unique ID of the exchange. |
| string | not null | The name of the promotion. |
csr_exch_opromos
This table stores information about the order promotion IDs used to determine refund values.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The unique ID of the exchange. |
| string | not null | The name of the promotion. |
csr_cc_exch_method
This table stores information about credits applied to credit cards.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The ID of the refund. References |
| varchar(40) | not null | The ID of the payment group the refund is being credited to. |
csr_sc_exch_method
This table stores information specific to store credits.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The ID of the refund. References |
| varchar(40) | null | This field is not used. |
| varchar(40) | null | The unique ID of the store credit. |
csr_promo_adjust
This table stores information about the change in promotion values for a return.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The unique ID of the exchange |
| map | null | The value of the change |
csr_nonreturn_adj
This table stores information specific to non-Return Item Adjustments.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The ID of the exchange. |
| set | not null | The ItemCostAdjustment ID. |
csr_item_adj
This table stores information specific to item adjustments.
Column | Data Type | Constraint | Description |
---|---|---|---|
| varchar(40) | not null | The ID of the |
| varchar(40) | not null | The ID of the commerce item. |
| varchar(40) | not null | The ID of the shipping group. |
| long | null | The quantity of adjusted items |
| double-precision | null | The amount of the adjusted item. |
| double-precision | null | The amount of the order discount share adjustment. |
| double-precision | null | The amount of the manual adjustment share adjustment. |
| double-precision | null | The tax adjustment. |
| double-precision | null | The shipping adjustment. |