WebSphere Commerce database table: ORDCALCD

Each row of this table indicates to the CalculationCodeCombineMethod that a CalculationCode is directly attached to all OrderItems in an Order whose directCalculationCodeAttachment flag in ORDERITEMS.PREPAREFLAGS is 1.


Column Description(s):
Column NameColumn TypeDescription
ORDCALCD_ID BIGINT NOT NULL Generated unique key.
ORDERS_ID BIGINT NOT NULL The Order.
CALCODE_ID INTEGER NOT NULL The CalculationCode.
CALFLAGS INTEGER NOT NULL DEFAULT 0 Contains the following bit flag value:
1 = overrideIndirectAttachments - CalculationCodes indirectly attached to the OrderItem are not effective.
(CalculationCodes can be indirectly attached in the CATENCALCD and CATGPCALCD tables.)
CALPARMTYPE INTEGER NOT NULL DEFAULT 0 Indicates how CALPARMAMT is used:
0 = not used.
1 = fixed adjustment.
2 = percentage adjustment.
3 = fixed replacement.
CALPARMAMT DECIMAL (20,5) NOT NULL DEFAULT 0 The amount of a fixed or percentage adjustment that can be applied to adjust or replace the results of the CalculationScales associated with the attached CalculationCode.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031243570 ORDCALCD_ID Primary Key
I0000637 CALCODE_ID Non-Unique Index
I0000638 ORDERS_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_495 CALCODE_ID CALCODE CALCODE_ID Cascade
F_494 ORDERS_ID ORDERS ORDERS_ID Cascade

Feedback