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
| 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.
|