ORDADJUST

Each row of this table represents an OrderAdjustment.

Column Descriptions:

NameTypeDescription
ORDADJUST_IDBIGINT NOT NULLGenerated unique key.
ORDERS_IDBIGINT NOT NULLThe Order the OrderAdjustment is part of.
CALCODE_IDINTEGERThe CalculationCode, if any, and if it still exists, that was used to create the OrderAdjustment.
CALUSAGE_IDINTEGERThe CalculationUsage, if any, and if it still exists, of the CalculationCode that was used to create the OrderAdjustment.
AMOUNTDECIMAL (20,5) DEFAULT 0The amount of the OrderAdjustment, in the currency of the order (ORDERS.CURRENCY). This is the sum of its related OrderItemAdjustments.
DISPLAYLEVELINTEGER NOT NULL DEFAULT 0The values for this OrderAdjustment should be displayed with each: 0 = OrderItem 1 = Order 2 = product 3 = item 4 = contract This value is usually copied from CALCODE.DISPLAYLEVEL.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ORDADJUST_IDPrimary Key
I0000171ORDERS_IDNon-Unique Index
I0000634CALUSAGE_IDNon-Unique Index
I0000635CALCODE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_490ORDERS_IDORDERSORDERS_IDCascade
F_491CALCODE_IDCALCODECALCODE_IDCascade
F_492CALUSAGE_IDCALUSAGECALUSAGE_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_486ORDADJUST_IDORDADJDSCORDADJUST_IDCascade
F_488ORDADJUST_IDORDADJTXEXORDADJUST_IDCascade
F_521ORDADJUST_IDORDIADJUSTORDADJUST_IDCascade
F_704ORDADJUST_IDRMAIADJCRDORDADJUST_IDCascade
F_810ORDADJUST_IDSUBORDADJORDADJUST_IDCascade