The Tencia import file can be modified to suit, however the default format is based on the ArrowLink format as follows
CSV Format
SOR_MASTER.ORDER_DATE – Date of the order
SOR_MASTER.CUSTOMER_CODE – the customer code
SOR_MASTER.CUSTOMER_ORDER – Order number
SOR_MASTER.DELIVERY_DATE – expected delivery date as per order
SOR_MASTER.ADDRESS_CODE – this would be the store code
SOR_MASTER.DELIVERY_NAME – Store Name as per order in ShipTo Location
SOR_MASTER.DELIVERY_NOTE_1 – 1st address line – store or customer
SOR_MASTER.DELIVERY_NOTE_2 – 2nd address line – store or customer
SOR_MASTER.DELIVERY_NOTE_3 – 3rd address line – store or customer
SOR_MASTER.DELIVERY_NOTE_4 – 4th address line – store or customer
SOR_MASTER.DELIVERY_POSTCODE – postal code – store or customer
SOR_MASTER.CONTACT_NAME – Contact Name
SOR_MASTER.PHONE_NUMBER – Phone Number
SOR_MASTER.DESCRIPTION_1 – can be 50 characters of special instructions
SOR_MASTER.DESCRIPTION_2 – can be 50 characters of special instructions
SOR_MASTER.DESCRIPTION_3 – can be 50 characters of special instructions
TRANS_LINES.CODE – Stock code for the item being ordered. This is generally the barcode, which translates to the Stock Code when imported into Tencia or we can send the Tencia item code
TRANS_LINES.ENTERED_QTY – quantity of product orders
TRANS_LINES.SELL_PRICE – per unit sell price
TRANS_LINES.ITEM_DESCRIPTION? - Stock Description