APPEASEMENT

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