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. |
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 |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_428 | ORDERS_ID+ORDRELEASENUM | MANIFEST | ORDERS_ID+ORDRELEASENUM | Cascade |