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