Page Comparison

The people you sell your products to

This contains places other than the account holders main address where you will deliver to.

Enter a line for each different delivery point, which is different to the main customer address.

Key Field Information

Further Reading about field types and notes are contained in the expand sections below, expand if you need to know more details.

Expand

title	Field Type Information

Name	Description
BIT	0 is NO / 1 is YES BIT fields must have an entry and can not be blank
Varchar(50)	Is an alpha numeric field of length 50, this can accept letters, number and symbols
INT	Is a single number field (no decimals) e.g. 1,2,3,4,5 Fields marked as INT must have an entry
DECIMAL (8,5)	Is a decimal field which can contain 8 before and 5 after the .dot separator

Expand

title	Field Notes

Default will be used unless you enter something in a field marked as DEFAULT
The CL column indicates the code list that this list can be found in within the document.
Mandatory fields are marked on the excel spreadsheets and in RED below
The field names in the import document can not be changed as these are used for matching.

Name	Type and Limitations	Mandatory	CL	Notes
CustomerCode	varchar(8)	Yes		This is the “Account” code from the customer. You can have this multiple times in this file, each line is a separate delivery point for the main customer account.
DPAccount	varchar(12)	Yes		unique code for this delivery point e.g. HOME / OFFICE / UB
AddressLine1	[varchar](50)	Yes		mandatory field Street and Number
AddressLine2	[varchar](50)			Building Name / Floor / Department
AddressLine3	[varchar](50)			Locality
Town	[varchar](50)	Yes		Town
Postcode	[varchar](10]	Conditional		depending on country may be mandatory
Country	[varchar][2]		2	ISO 2 digit code for country
Contact	[varchar](50)			Delivery point contact name.
Telephone1	[varchar](30)			Delivery point contact telephone number
DeliveryTimeFrom	time hh:mm
DeliveryTimeTo	time hh:mm
DeliveryTimeFrom2	time hh:mm
DeliveryTimeTo2	time hh:mm
ExciseDutyDefermentAccount	[varchar][7]		LU	only complete if you intend to use an alternative code
CustomsDutyDefermentAccount	[varchar][7]		LU	only complete if you intend to use an alternative code
Notes	[ntext]
DeliveryInstructions	[varchar][120]
PickInstructions	[varchar][120]
LegalType	Option		11	Individual or Business

If you are setting up an underbond delivery points then the following information should be entered

Name	Type and Limitations	Mandatory	CL	Notes
AddressLine1	[varchar](50)	Yes		Receiving Account Code
AddressLine2	[varchar](50)	YES		Receiving Account Site Code
AddressLine3	[varchar](50)			Receiving Account RESERVE customer code ONLY IF KNOWN OR LEAVE BLANK
Town	[varchar](50)	Yes		Receiving Warehouse TOWN
Postcode	[varchar](10]	YES		Receiving Warehouse Postcode
Country	[varchar][2]	YES	2	ISO 2 digit code for country