Store Order

The unique identifier for store order generated by system when a new record is created.

The store order external identifier.

The store order reference identifier.

The store identifier where the store order was created.

The description added by user for the transaction event.

The status code of the store order. 1-New, 2-In Progress, 3-Approved, 4-Canceled, 5-Submitted

The context identifier of the store order.

The origin code of the store order. 1-External, 2-Manual, 3-System

The date when the store order is requested by.

Y/N whether new items can be added to the store order.

The identifier of the supplier which items are restricted to on the store order.

The identifier of the warehouse which items are restricted to on the store order.

The identifier of the item hierarchy which items are restricted to on the store order.

The identifier of the store sequence area which items are restricted to on the store order.

The date the store order was created.

The user that created the store order.

The date the store order was last updated.

The user that last updated the store order.

The date the store order was approved.

The date that the store order was automatically approved.

The user that approved the store order.

Y/N Whether or not only Store Order replenishment items can be added.

Date store order was created in an external system.

Oracle Retail target column DELIVERY_SLOT_ID on STORE_ORDER.

The unique identifier of the product group that this store order is related to.

The description for the product group.

Transfer identifier of external system transfer

Purchase order identifier of external system purchase order

Indicate quantities must to rounded to whole case size increments