Reference > Database > WebSphere Commerce database tables > O
WebSphere Commerce database table: ORDRELEASE
Each row in this table represents an order release. The release is a grouping of all order items in an order that are to be shipped on the same date to the same address. The order items also use the same shipping mode from the same fulfillment center.
Column Name Column Type Description ORDRELEASENUM INTEGER NOT NULL Uniquely identifies this release for the order. ORDERS_ID BIGINT NOT NULL The order of which this release is a part. FFMACKNOWLEDGEMENT TIMESTAMP The time of fulfillment acknowledgement. STATUS CHAR(4) The status of the release...
NEW = the initial status of the order release.
RDY = the release is ready to be released to fulfillment.
SHIP = the release is ready to be shipped
PRN = the release was included in a generated pickbatch.
MNF = the release shipment confirmation was received (manifested).
CUSTOMERCONFIRM TIMESTAMP The time when the customer was sent a shipping confirmation message. FIELD1 INTEGER Customizable. FIELD2 VARCHAR(254) Customizable. FIELD3 VARCHAR(254) Customizable. PICKBATCH_ID BIGINT Foreign key to the PICKBATCH table. Groups together ORDRELEASE rows that are on the same pick batch. TIMEPLACED TIMESTAMP The time the order was released for fulfillment. LASTUPDATE TIMESTAMP The time the order release was last updated. PACKSLIPXML CLOB The name of the XML file for the packing slip. CAPTUREDATE TIMESTAMP The time that payment was captured for this release. EXTORDNUM VARCHAR(64) A reference number that can be used to locate the shopping cart or order. The order was created in a separate fulfillment store or external fulfillment system to fulfill the items in this release. EXTREF VARCHAR(2048) An external reference string that can be used in a URL to re-direct a browser to a separate fulfillment store or external fulfillment system. It is to locate information about the transferred shopping cart or order created to fulfill the items in this release. FFMCENTER_ID INTEGER The fulfillment center this release is associated with. ISEXPEDITED CHAR(1) NOT NULL DEFAULT 'N' Indicates that the release contains one or more expedited orderitems. See ISEXPEDITED in the ORDERITEMS table. SHIPMODE_ID INTEGER The ship mode associated with the release. ADDRESS_ID BIGINT The shipping address associated with the release. MEMBER_ID BIGINT The owner of the release. The is the same as the creator of the order, for example, the shopper or buyer id. STOREENT_ID INTEGER The store associated with the release. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030404690 ORDERS_ID+ORDRELEASENUM Primary Key I0000180 STATUS+ORDERS_ID+ORDRELEASENUM+PICKBATCH_ID Non-Unique Index I0000836 FFMCENTER_ID Non-Unique Index I0000837 SHIPMODE_ID Non-Unique Index I0000838 ADDRESS_ID Non-Unique Index I0000839 MEMBER_ID Non-Unique Index I0000840 STOREENT_ID Non-Unique Index I803140 PICKBATCH_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_1090 ADDRESS_ID ADDRESS ADDRESS_ID Cascade F_1092 FFMCENTER_ID FFMCENTER FFMCENTER_ID Cascade F_1089 MEMBER_ID MEMBER MEMBER_ID Cascade F_547 ORDERS_ID ORDERS ORDERS_ID Cascade F_546 PICKBATCH_ID PICKBATCH PICKBATCH_ID Cascade F_1091 SHIPMODE_ID SHIPMODE SHIPMODE_ID Cascade F_1088 STOREENT_ID STOREENT STOREENT_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_428 ORDERS_ID ORDRELEASENUM MANIFEST ORDERS_ID Cascade F_1087 ORDERS_ID ORDRELEASENUM ORDRLSTTLS ORDERS_ID Cascade
Related reference
_vcc_freeselect_bottom_