Open purchase orders

Snapshot's date. The open purchase order row has to be received every day the order remains open. Once it's delivered, the open order row is not sent anymore. For example, if an order is created on Jan 3rd and the snapshot date is Jan 8th, then the date field will contain '2020-01-08' assuming the order is still open Jan 8th. Snapshot's date is usually previous day's date except if reading in historical open orders.

Inventory location code (i.e. for affected store, warehouse etc.)

Item code (code for finished product or stock keeping unit)

ORDER = Open purchase order (can be linked to DELIVERY with a reference number)

Open order quantity in base unit of measure (e.g. SKU, stock unit, piece, smallest possible unit). Quantity sign defines the transaction direction as seen by the warehouse, e.g. incoming purchase order is sent as positive quantity. See more detailed instructions in "Definitions"- tab.

Estimated delivery (goods receival) date of the order

Stores the RELEX transactions.order_requested_date value used by the interface workbook for downstream planning, validation, and migration load execution.

Value of the whole transaction in the location's currency (e.g. €, £, $). Value should always be positive as transaction quantity determines the direction of the transaction. Usually based on purchase price. Negative values are automatically converted to the positive absolute value of the inserted value.

Stores the RELEX transactions.reference value used by the interface workbook for downstream planning, validation, and migration load execution.

Stores the RELEX transactions.order_row value used by the interface workbook for downstream planning, validation, and migration load execution.

The order proposal number sent by RELEX to track open purchase orders

Stores the RELEX transactions.transaction_uid value used by the interface workbook for downstream planning, validation, and migration load execution.

Additional order type that can be used to distinct different orders e.g. open orders from special open orders.

Stores the RELEX transactions.partner_code value used by the interface workbook for downstream planning, validation, and migration load execution.

Stores the RELEX transactions.estimated_delivery_time value used by the interface workbook for downstream planning, validation, and migration load execution.

Expiration date of the goods to be received.