| 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.
|