Import - Customer Delivery Addresses
- Alan Gilchrist
Use
Initial Import of customers addresses, rarely used as postal lookup is used.  This is NOT for underbond delivery points those are stored seperately
Limitations
The customer code must exist in the first place otherwise this will not import
Notes
This import originated from an older system so some of the fields are not relevant but remain as part of the standard import tables.              Â
Â
Fields
Â
Field Name | Field Type | Nulls | Notes |
SiteCode | char(2) | NULL | Needs to be the same as the customer table |
CustomerCode | varchar(20) | NULL | Needs to be the same as the customer table. |
FKCountry | int | NULL | ISO 3166 alpha-2 code required |
EarliestDeliveryTime | varchar(5) | NULL | Format is hh:mm |
LatestDeliveryTime | varchar(5) | NULL | Format is hh:mm |
DPAccountRef | dbo.TextDPAccountRef | NULL | Needs to be UNIQUE for each customer code. |
DeliveryName | dbo.TextDeliveryName | NULL | Â |
ContactName | varchar(30) | NULL | Â |
Address1 | varchar(50) | NULL | Â |
Address2 | varchar(50) | NULL | Â |
Address3 | varchar(50) | NULL | Â |
Town | varchar(50) | NULL | Â |
PostCode | varchar(15) | NULL | Â |
Telephone | varchar(20) | NULL | Â |
Fax | varchar(20) | NULL | Â |
varchar(50) | NULL | Â | |
DeliveryInst1 | varchar(120) | NULL | Â |
ExciseDutyAccount | varchar(8) | NULL | Only specify if different to the main account |
CustomsDutyAccount | varchar(8) | NULL | Only specify if different to the main account |
ANALocation | varchar(15) | NULL | Used for EDI only – EDIFACT format |
InvoicePoint | int | NULL | Used for EDI only - EDIFACT format |
Â
Â
Copyright Ontech Solutions 2017-2024. All rights reserved, no part may be replicated or distributed without the express permission of the owner.