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 Descriptions:
| Name | 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 acknowledgment. |
| STATUS | CHAR (4) | The status of the release as follows:
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 pick batch.
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 (1000000000) | 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 NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | 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 |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_1088 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
| F_1089 | MEMBER_ID | MEMBER | MEMBER_ID | Cascade |
| F_1090 | ADDRESS_ID | ADDRESS | ADDRESS_ID | Cascade |
| F_1091 | SHIPMODE_ID | SHIPMODE | SHIPMODE_ID | Cascade |
| F_1092 | FFMCENTER_ID | FFMCENTER | FFMCENTER_ID | Cascade |
| F_546 | PICKBATCH_ID | PICKBATCH | PICKBATCH_ID | Cascade |
| F_547 | ORDERS_ID | ORDERS | ORDERS_ID | Cascade |
Referenced By Child Tables:
| Constraint | Columns | Child Table | Child Columns | Type |
| F_1087 | ORDERS_ID+ORDRELEASENUM | ORDRLSTTLS | ORDERS_ID+ORDRELEASENUM | Cascade |
| F_428 | ORDERS_ID+ORDRELEASENUM | MANIFEST | ORDERS_ID+ORDRELEASENUM | Cascade |