Open sales orders

Date when the sales order is/was open. The open sales 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 '2018-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 sales orders.

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

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

type is marked as Must have in the RELEX interface definition. This value is carried on the RELEX Transactions interface and must remain semantically intact during migration.

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, so open sales order is sent as negative quantity. See more detailed instructions in "Definitions"- tab.

Requested/confirmed outbound delivery date. The date must reflect the time when the stock must be available for fulfilling an order. It does not reflect the actual date when the goods are delivered to the customer.

Original requested picking date of the order.

Estimated picking time of the order (hh:mm). Note: This time is used in stock replenishment, therefore the time must reflect the time when the stock must be available for fulfilling the order. It does not reflect the actual time when the goods are delivered to the customer.

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. Negative values are automatically converted to the positive absolute value of the inserted value. Value suggestion: Sales value excluding tax. If the sales order is internal sale, the value should be the internal sales value used for the transaction

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

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.

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

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