This table holds the details of the order returns.
Column Descriptions:
| Name |
Type |
Description |
| ORDRETURN_ID |
BIGINT NOT NULL |
The unique identifier of the order return. |
| ORDERS_ID |
BIGINT NOT NULL |
The unique identifier of the order which the return is associated
with. |
| CSR_ID |
BIGINT |
The unique identifier of the CSR User who submitted the
return. |
| DESCRIPTION |
VARCHAR(254) |
The short description of the return. |
| TOTALCREDIT |
DECIMAL(20,5) NOT NULL |
The total amount to credit to shopper. |
| TOTALTAXCREDIT |
DECIMAL(20,5) NOT NULL |
The tax of the total amount to credit to shopper. |
| TIMECREATED |
TIMESTAMP NOT NULL |
Creation date and time. |
| LASTUPDATED |
TIMESTAMP NOT NULL |
Last updated date and time. |
| TIMEAPPROVED |
TIMESTAMP |
Approved date and time. |
| STATUS |
VARCHAR(3) NOT NULL |
The status of the order return.
- PND – Pending
- APR – Approved
- MAN – Manual Approved
- RCV – All items are received
- CLO – Closed
- CAN - Cancelled
|
| FIELD1 |
INTEGER |
An integer field for customization. |
| FIELD2 |
DECIMAL(20,5) |
A decimal field for customization. |
| FIELD3 |
VARCHAR(254) |
A text field for customization. |
| COMMENTS |
VARCHAR(254) |
The comments of the return. |
| OPTCOUNTER |
SMALLINT |
The optimistic concurrency control counter for the table. Every time
there is an update to the table, the counter is incremented. |
Indexes:
| Name |
Column Names |
Type |
| P_ORDRETURN |
ORDRETURN_ID |
Primary Key |
| I_ORDRETURN_1 |
ORDERS_ID |
Non-Unique Index |
| I_ORDRETURN_2 |
CSR_ID |
Non-Unique Index |
Constrained By Parent Tables:
| Constraint |
Columns |
Parent Table |
Parent Columns |
Type |
| F_ORDRETURN_ORDERS_ID |
ORDERS_ID |
ORDERS |
ORDERS_ID |
Cascade |
| F_ORDRETURN_CSR_ID |
CSR_ID |
USERS |
USERS_ID |
SET NULL |