ORDJUST

This table holds the details of the order justifications.

Column Descriptions:

Name Type Description
ORDJUST_ID INTEGER NOT NULL The unique identifier of the justification.
CODE VARCHAR(30) The code of the justification.
STOREENT_ID INTEGER NOT NULL The unique identifier of the store in which the justification can be applied.
SEQUENCE DOUBLE NOT NULL Sequence to control the relative display order.
USAGE SMALLINT NOT NULL Usage in Order Management.
  1. Appeasement.
  2. Order Returns.
  3. Both Appeasement and Order Returns.
MARKFORDELETE INTEGER NOT NULL The flag to indicate if justification is deleted.
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_ORDJUST ORDJUST_ID Primary Key
UI_ORDJUST CODE + STOREENT_ID Unique Index

Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_ORDJUST_STOREENT_ID STOREENT_ID STOREENT STOREENT_ID Cascade