WebSphere Commerce database table: ORDRELEASE

Each row in this table represents an order release, which is a grouping of all order items in an order that are to be shipped on the same date to the same address, using the same shipping mode from the same fulfillment center.


Column Description(s):
Column NameColumn TypeDescription
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 as follows:
SHIP = the release is ready to be shipped (this is the default initial status).
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 that 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 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 shipmode 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's id.
STOREENT_ID INTEGER The store associated with the release.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031249320 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
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)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 NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_428 ORDERS_ID ORDRELEASENUM MANIFEST ORDERS_ID Cascade
F_1087 ORDERS_ID ORDRELEASENUM ORDRLSTTLS ORDERS_ID Cascade

Feedback