Database Table: ORDRELEASE

Each row in this table represents an OrderRelease. An OrderRelease is a grouping of all OrderItems in an Order that are to be shipped to the same address using the same shipping mode from the same FulfillmentCenter at the same time.

Column Name Column Type Column Description
CAPTUREDATE TIMESTAMP
NULL
The time payment was captured for this release.
CUSTOMERCONFIRM TIMESTAMP
NULL
The time when the customer was sent a shipping confirmation message.
EXTORDNUM VARCHAR (64)
NULL
A reference number that can be used to locate the shopcart or order that was created, in a separate fulfillment Store or external fulfillment system, to fulfill the items in this release.
EXTREF VARCHAR (2048)
NULL
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 shopcart or order created to fulfill the items in this release.
FFMACKNOWLEDGEMENT TIMESTAMP
NULL
The time of fulfillment acknowledgement.
FIELD1 INTEGER
NULL
Customizable.
FIELD2 VARCHAR (254)
NULL
Customizable.
FIELD3 VARCHAR (254)
NULL
Customizable.
LASTUPDATE TIMESTAMP
NULL
The time the OrderRelease was last updated.
ORDERS_ID BIGINT
NOT NULL
The order of which this release is a part.
ORDRELEASENUM INTEGER
NOT NULL
Uniquely identifies this release for the order.
PACKSLIPXML CLOB (1000000000)
NULL
The packing slip XML.
PICKBATCH_ID BIGINT
NULL
Foreign key to the PICKBATCH table. Groups together ORDRELEASE rows that are on the same pick batch.
STATUS CHARACTER (4)
NULL
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).
TIMEPLACED TIMESTAMP
NULL
The time the order was released for fulfillment.
Indexes:
Index Name Indexed Column Names Index Type
I0000180 STATUS, ORDERS_ID, ORDRELEASENUM, PICKBATCH_ID Non-Unique Index
I803140 PICKBATCH_ID Non-Unique Index
SQL030416035023700 ORDERS_ID, ORDRELEASENUM Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_546 PICKBATCH_ID PICKBATCH PICKBATCH_ID Cascade
F_547 ORDERS_ID ORDERS ORDERS_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+ORDRELEASENUM Cascade