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 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 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 Name | Indexed Column Names | Index 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 Name | Column Name(s) | Foreign Table Name | Foreign 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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_428 | ORDERS_ID ORDRELEASENUM | MANIFEST | ORDERS_ID | Cascade |
F_1087 | ORDERS_ID ORDRELEASENUM | ORDRLSTTLS | ORDERS_ID | Cascade |