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
| 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:
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 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. 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
| Reserved for IBM internal use.
|