CALADJUST

A row in this table represents a calculation adjustment. A calculation adjustment is an adjustment created by a service representative to be applied to the calculation usage specified. Currently only shipping adjustments are supported.

Column Descriptions:

NameTypeDescription
CALADJUST_IDBIGINT NOT NULLGenerated unique key.
ORDERS_IDBIGINT NOT NULLThe order that this adjustment applies to.
CALUSAGE_IDINTEGER NOT NULLIdentifies which calculation usage this adjustment applies to. Currently only shipping adjustments are supported.
SHIPMODE_IDINTEGERThe shipping mode that the discount is applied to.
SERVICEREP_IDBIGINT NOT NULLThe user ID of the service representative that created this adjustment.
PARMTYPEINTEGER NOT NULL DEFAULT 0Indicates how PARMAMT is used. 0 = not used. 1 = fixed adjustment. 2 = percentage adjustment. 3 = fixed replacement.
PARMAMTDECIMAL (20,5) NOT NULL DEFAULT 0The amount of a fixed or percentage adjustment that can be applied to adjust or replace the calculated charge.
FIELD1INTEGERReserved for IBM internal use.
FIELD2VARCHAR (128)Reserved for IBM internal use.
BASECOSTDECIMAL (20,5) NOT NULL DEFAULT 0.00000Indicates the base cost charge at the time the service representative created/updated the adjustment.
OPTCOUNTERSMALLINTThe 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>CALADJUST_IDPrimary Key
I0000958ORDERS_ID+CALUSAGE_ID+SHIPMODE_IDNon-Unique Index
I0000959SHIPMODE_IDNon-Unique Index
I0000960SERVICEREP_IDNon-Unique Index
I0000961CALUSAGE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1224ORDERS_IDORDERSORDERS_IDCascade
F_1225CALUSAGE_IDCALUSAGECALUSAGE_IDCascade
F_1226SHIPMODE_IDSHIPMODESHIPMODE_IDCascade
F_1227SERVICEREP_IDMEMBERMEMBER_IDCascade