WebSphere Commerce database table: ORDRLSTTLS

Store release level charges.


Column Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031249610 ORDERS_ID+ORDRELEASENUM+CHARGETYPE Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_1087 ORDERS_ID ORDRELEASENUM ORDRELEASE ORDERS_ID Cascade

Feedback