ORDRELEASE

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:

NameTypeDescription
ORDRELEASENUMINTEGER NOT NULLUniquely identifies this release for the order.
ORDERS_IDBIGINT NOT NULLThe order of which this release is a part.
FFMACKNOWLEDGEMENTTIMESTAMPThe time of fulfillment acknowledgement.
STATUSCHAR (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).
CUSTOMERCONFIRMTIMESTAMPThe time when the customer was sent a shipping confirmation message.
FIELD1INTEGERCustomizable.
FIELD2VARCHAR (254)Customizable.
FIELD3VARCHAR (254)Customizable.
PICKBATCH_IDBIGINTForeign key to the PICKBATCH table. Groups together ORDRELEASE rows that are on the same pick batch.
TIMEPLACEDTIMESTAMPThe time the order was released for fulfillment.
LASTUPDATETIMESTAMPThe time the order release was last updated.
PACKSLIPXMLCLOB (1000000000)The name of the XML file for the packing slip.
CAPTUREDATETIMESTAMPThe time that payment was captured for this release.
EXTORDNUMVARCHAR (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.
EXTREFVARCHAR (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_IDINTEGERThe fulfillment center this release is associated with.
ISEXPEDITEDCHAR (1) NOT NULL DEFAULT 'N'Indicates that the release contains one or more expedited orderitems. See ISEXPEDITED in the ORDERITEMS table.
SHIPMODE_IDINTEGERThe ship mode associated with the release.
ADDRESS_IDBIGINTThe shipping address associated with the release.
MEMBER_IDBIGINTThe owner of the release. The is the same as the creator of the order, for example, the shopper or buyer id.
STOREENT_IDINTEGERThe store associated with the release.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ORDERS_ID+ORDRELEASENUMPrimary Key
I0000180STATUS+ORDERS_ID+ORDRELEASENUM+PICKBATCH_IDNon-Unique Index
I0000836FFMCENTER_IDNon-Unique Index
I0000837SHIPMODE_IDNon-Unique Index
I0000838ADDRESS_IDNon-Unique Index
I0000839MEMBER_IDNon-Unique Index
I0000840STOREENT_IDNon-Unique Index
I803140PICKBATCH_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1088STOREENT_IDSTOREENTSTOREENT_IDCascade
F_1089MEMBER_IDMEMBERMEMBER_IDCascade
F_1090ADDRESS_IDADDRESSADDRESS_IDCascade
F_1091SHIPMODE_IDSHIPMODESHIPMODE_IDCascade
F_1092FFMCENTER_IDFFMCENTERFFMCENTER_IDCascade
F_546PICKBATCH_IDPICKBATCHPICKBATCH_IDCascade
F_547ORDERS_IDORDERSORDERS_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1087ORDERS_ID+ORDRELEASENUMORDRLSTTLSORDERS_ID+ORDRELEASENUMCascade
F_428ORDERS_ID+ORDRELEASENUMMANIFESTORDERS_ID+ORDRELEASENUMCascade