Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: 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 Name Column 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. OPTCOUNTER SMALLINT 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.
Indexes Index Name Indexed Column Names Index Type SQL100520030307170 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
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_1225 CALUSAGE_ID CALUSAGE CALUSAGE_ID Cascade F_1227 SERVICEREP_ID MEMBER MEMBER_ID Cascade F_1224 ORDERS_ID ORDERS ORDERS_ID Cascade F_1226 SHIPMODE_ID SHIPMODE SHIPMODE_ID Cascade _vcc_freeselect_bottom_