This table holds the details of the order appeasements.
Column Descriptions:
Name |
Type |
Description |
APPEASEMENT_ID |
BIGINT NOT NULL |
The unique identifier of the appeasement. |
DESCRIPTION |
VARCHAR(254) |
The short description of the appeasement. |
ORDERS_ID |
BIGINT NOT NULL |
The unique identifier of the order which the appeasement is filed
against. |
CSR_ID |
BIGINT |
The unique identifier of the CSR User who submitted the
appeasement. |
ORDERPRICE |
DECIMAL(20,5) |
The amount discounted at the order level. |
ORDERTAX |
DECIMAL(20,5) |
The tax for amount discounted at the order level. |
SHIPPINGCHARGES |
DECIMAL(20,5) |
The amount discounted at the shipping level. |
SHIPPINGTAX |
DECIMAL(20,5) |
The tax for amount discounted at the shipping level. |
TOTALPRODUCT |
DECIMAL(20,5) |
The total amount discounted for item level. |
TOTALTAX |
DECIMAL(20,5) |
The tax for total amount discounted for item level. |
TIMECREATED |
TIMESTAMP NOT NULL |
Creation date and time. |
LASTUPDATED |
TIMESTAMP NOT NULL |
Last updated date and time. |
STATUS |
VARCHAR(3) NOT NULL |
The status of the appeasement.
- PND – Pending
- APR – Approved
- MAN – Manual Approved
- 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 appeasement. |
OTHER_REASON |
VARCHAR(254) |
The custom justification message for OTHER type of the
justification. |
NOTIFICATIONID |
BIGINT |
Message notification id. Reserved for internal use. |
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_APPEASEMENT |
APPEASEMENT_ID |
Primary Key |
I_APPEASEMENT_1 |
ORDERS_ID |
Non-Unique Index |
I_APPEASEMENT_2 |
CSR_ID |
Non-Unique Index |
Constrained By Parent Tables:
Constraint |
Columns |
Parent Table |
Parent Columns |
Type |
F_APPEASEMENT_ORDERS_ID |
ORDERS_ID |
ORDERS |
ORDERS_ID |
Cascade |
F_APPEASEMENT_CSR_ID |
CSR_ID |
USERS |
USERS_ID |
SET NULL |