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:

Name	Type	Description
CALADJUST_ID	BIGINT NOT NULL	Generated unique key.
ORDERS_ID	BIGINT NOT NULL	The order that this adjustment applies to.
CALUSAGE_ID	INTEGER NOT NULL	Identifies which calculation usage this adjustment applies to. Currently only shipping adjustments are supported.
SHIPMODE_ID	INTEGER	The shipping mode that the discount is applied to.
SERVICEREP_ID	BIGINT NOT NULL	The user ID of the service representative that created this adjustment.
PARMTYPE	INTEGER NOT NULL DEFAULT 0	Indicates how PARMAMT is used. 0 = not used. 1 = fixed adjustment. 2 = percentage adjustment. 3 = fixed replacement.
PARMAMT	DECIMAL (20,5) NOT NULL DEFAULT 0	The amount of a fixed or percentage adjustment that can be applied to adjust or replace the calculated charge.
FIELD1	INTEGER	Reserved for IBM internal use.
FIELD2	VARCHAR (128)	Reserved for IBM internal use.
BASECOST	DECIMAL (20,5) NOT NULL DEFAULT 0.00000	Indicates the base cost charge at the time the service representative created/updated the adjustment.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	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
<SYSTEM-GENERATED>	CALADJUST_ID	Primary Key
I0000958	ORDERS_ID+CALUSAGE_ID+SHIPMODE_ID	Non-Unique Index
I0000959	SHIPMODE_ID	Non-Unique Index
I0000960	SERVICEREP_ID	Non-Unique Index
I0000961	CALUSAGE_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_1224	ORDERS_ID	ORDERS	ORDERS_ID	Cascade
F_1225	CALUSAGE_ID	CALUSAGE	CALUSAGE_ID	Cascade
F_1226	SHIPMODE_ID	SHIPMODE	SHIPMODE_ID	Cascade
F_1227	SERVICEREP_ID	MEMBER	MEMBER_ID	Cascade