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 Description(s):
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. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031205620 |
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 |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | 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 |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.