Reference > Database > WebSphere Commerce database tables > O
WebSphere Commerce database table: ORDRLSTTLS
Store release level charges.
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 SQL100520030404840 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 _vcc_freeselect_bottom_