Masterlink Sales Outbound Requests

Create Masterlink-formatted outbound requests for sales orders.

The details below display the source of the details within the Masterlink csv file. The csv mapping is based on details held in Masterlink Bonded Warehouse Integration document. (Rev 1a).

The file only exports sales order item lines.

Duty Free Orders

• Standard Duty Free orders are set by applying a Duty Free Ship-to to the order.
• Embassy Duty Free orders are as above with Duty Free Movement Type set to Diplomatic Privilege.

CSV file fields

Header

Column No.	Data Item	Explanation
01	Line Type	Set to H
02	Tenant Code	Customer Code from the Masterlink Setup page (Warehouse Supplier Setup).
03	Ord Type Code	DP: all duty paid orders DF: all non-embassy duty free orders DE: duty Free embassy orders UX: If Country/region code on the ship to address = NI (Northern Ireland) and the duty status of the order = duty free
04	Del Date	Order Requested Delivery Date
05	Spec Inst	'Work Description', up to 100 characters. Work description can be populated manually or automatically using Bevica Sales Comments and Notes functionality.
06	Spec Inst2	Blank
07	Dummy2	Blank
08	Dummy3	Blank
09	Spec Inst3	Blank
10	Cust Ref	Order No.
11	Dummy4	Blank
12	Tenant_Outlet	Concatenation of Customer No & Ship-to Code, i.e. 'Customer-Ship-to'
13	Outlet Name	Order Ship-to Name
14	Delivery Address 1	Blank
15	Delivery Address 2	Blank
16	Dummy5	Blank
17	Delivery Address 3	Blank
18	Dummy6	Blank
19	Delivery Town	Blank
20	Delivery Address 5	Blank
21	Tenant Cust Ref	The Order's External Document Ref.
22	Spec Inst4	Blank

Product line details

Only Inventory Item lines are exported.

Column No.	Data Item	Explanation
01	Line Type	Set to D
02	Cust Ref	Order No.
03	Dummy1	Blank
04	Product Code	Item No.
05	Dummy2	Blank
06	Dummy3	Blank
07	Unit of Sale	Blank
08	Dummy4	Blank
09	Dummy5	Blank
10	Dummy6	Blank
11	Line Description	Blank
12	Dummy7	Blank
13	Dummy8	Blank
14	Dummy9	Blank
15	Dummy10	Blank
16	Case Qty	Where the sales line Unit of Measure is the item's Sales Unit of Measure, quantity is added here.
17	Dummy11	Blank
18	Singles Qty	Where the sales line Unit of Measure is the item's Base Unit of Measure or where the item's Sales Unit of Measure is the same as its Base Unit of Measure, quantity is added here.
19	Dummy12	Blank
20	Dummy13	Blank

Footer line

Column No.	Data Item	Explanation
01	Line Type	Set to F
02	Cust Ref	Order No.