42. Customer Delivery Points

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.

Template Download

Some files contain example data in them, you should remove this before submitting back to us for loading.

Template / Example File

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.

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

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.

Data Field Definition

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
UnderbondType	varchar(1)			P - GB Duty Paid K - NI Duty Paid Underbond orders generally do not require a delivery address stored, as the main customer address becomes the consignee, the underbond delivery point is required which is stored seperately to customers and this is used as the delivery point for the goods and paperwork before it is exported from the UK.

If you are setting up an Type T order then you need to adjust the fields above as follows :

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