WebSphere Commerce database table: ORDRLSTTLS

WebSphere Commerce database table: ORDRLSTTLS

Store release level charges.
Column Descriptions
Column Name Column Type Description
ORDERS_ID BIGINT NOT NULL Order ID
ORDRELEASENUM INTEGER NOT NULL The number of the order release
CHARGETYPE CHAR(70) NOT NULL The type of charge
AMOUNT DECIMAL (20,5) The total of the charges for the order release
LASTCREATED TIMESTAMP The date and time when the release was created
FIELD1 INTEGER Customizable.
FIELD2 VARCHAR(250) Customizable.
FIELD3 VARCHAR(250) Customizable.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235223390 ORDERS_ID+ORDRELEASENUM+CHARGETYPE Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_1087 ORDERS_ID ORDRELEASENUM ORDRELEASE ORDERS_ID Cascade

Column Name	Column Type	Description
ORDERS_ID	BIGINT NOT NULL	Order ID
ORDRELEASENUM	INTEGER NOT NULL	The number of the order release
CHARGETYPE	CHAR(70) NOT NULL	The type of charge
AMOUNT	DECIMAL (20,5)	The total of the charges for the order release
LASTCREATED	TIMESTAMP	The date and time when the release was created
FIELD1	INTEGER	Customizable.
FIELD2	VARCHAR(250)	Customizable.
FIELD3	VARCHAR(250)	Customizable.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.