Customer Address Import Format

A

1

Customer Code

12

Character

Yes

Enter the customer code. You must enter a customer code for an existing customer.

B

2

Bill-To/Ship-To ID

8

Integer

No

If the Customer option is selected when running the import, this field is ignored. In this case the customer information is updated for ship-to and bill-to address 0.

If the Customer ShipTo option is selected, then the information is updated for the entered ship-to address ID. If this field is left blank, then a new ship-to address is created.

If the Customer BillTo option is selected, then the information is updated for the entered bill-to address ID. If this field is left blank, then a new bill-to address is created.

C

3

Primary Address

3

Yes/No

No

Enter Yes if the address is the primary address.

If this field is blank, it defaults to No.

D

4

Name

40

Character

Yes

Enter the name of the customer, ship-to address, or bill-to address.

E

5

Address 1

60

Character

Yes

Enter the first line of the customer's address.

F

6

Address 2

60

Character

No

Enter the second line of the customer's address.

G

7

Address 3

60

Character

No

Enter the third line of the customer's address.

H

8

City

40

Character

Yes

Enter the city of the customer's address.

I

9

State/Province

3

Character

Yes, only if a state or province is required for the country of the address

Enter the state or province of the customer's address. This field is validated. States/provinces must be loaded into the system before importing.

J

10

Postal Code

10

Character

Yes, only if a postal code is required for the country of the address

Enter the postal code of the customer's address without formatting (no hyphens or spaces). The format of the postal code is set up for the country in Country Maintenance, and can optionally be set up to be validated. For information on setting up postal codes, see Postal Code Maintenance.

K

11

Country

10

Character

Yes

Enter a valid country for the customer's address. Countries must be loaded into the system before importing.

L

12

Phone Number

16

Character

No

Enter the customer's phone number. The format of the telephone number is set up in Country Maintenance.

M

13

Fax Number

16

Character

No

Enter the customer's fax number. The format of the telephone number is set up in Country Maintenance.

N

14

Email Address

40

Character

No

Enter the customer's email address. This field is informational only.

O

15

State Tax Exempt Number

20

Character

Conditional; see the Tax Exempt field

If the customer's ship-to address is always tax-exempt for all products shipped to it, enter the customer's state tax exempt number for the address.

P

16

Tax Exempt

3

Yes/No

No

Enter Yes if the customer ship-to address is tax exempt.

If you enter Yes and the internal tax functionality is used, then State Tax Exempt Number and Country Tax Exempt Number are required.

If you enter Yes and the AvaTax interface is used, either State Tax Exempt Number or Entity Use Code is required.

Q

17

Tax Jurisdiction

12

Character

No

Enter a valid tax jurisdiction for the customer’s ship-to address. This is the sales tax jurisdiction for tax purposes (e.g. NYC).

If this field is blank, it defaults to None.

NOTE If the system is integrated with AvaTax, leave this field blank.

R

18

Trade Class

8

Character

No

Enter the trade class for the address.

S

19

EDI Address Code

30

Character

No

Enter the EDI address code. This field is used during EDI imports and exports (850 import, 856 and 810 export). It is used for customer ship-to and customer bill-to addresses only.

T

20

Store ID

10

Character

No

Enter the store ID for the ship-to address. This field is used for customer ship-to addresses only.

U

21

Region ID

20

Character

No

Enter the forecast region ID to which this customer ship-to address belongs for DRP product forecasting. For information on setting up regions, see Point of Sale Region Maintenance.

V

22

Freight Collection

20

Character

No

Enter the default freight collection terms code for the customer ship-to address. This overrides the default freight collection terms code for the customer. For information on setting up freight collection terms codes, see Freight Collection Terms Maintenance.

W

23

Shipper ID

12

Character

No

Enter the preferred shipper ID.

X

24

Shipping Mode

8

Character

No

Enter the preferred shipping mode.

Y

25

Shipping Account ID

20

Character

No

Enter the ship-to address account number to charge for delivery if you are using an external shipping interface. This is primarily used for UPS.

Z

26

Latitude

14

->>>>>>>9.9999

No

Enter the latitude of the ship-to address if you are using an external delivery logistics interface.

AA

27

Longitude

14

->>>>>>>9.9999

No

Enter the longitude of the ship-to address if you are using an external delivery logistics interface.

AB

28

FOB

12

Character

No

Enter the default Freight On Board (FOB) used during sales order entry.

AC

29

Website

60

Character

No

Enter the address of the customer's Website.

AD

30

Language

8

Character

No

Enter the primary language spoken by the customer.

AE

31

Shared Ship-To Invoice Format

10

Character

No

Enter one of the following invoice print formats to use when printing in Invoice Copy Print for a shared ship-to address.

• None - Do not reprint invoices for this main customer.

• Invoice - Print the standard invoice format.

• No-Price - Print invoices in a pack list format with no prices.

• List-Price - Print invoices in a pack list format with list prices only.

AF

32

Emergency Phone Number

16

Character

No

Enter the customer's emergency phone number. The format of the telephone number is set up in Country Maintenance.

AG

33

Related Bill-To

8

Character

No

Enter the related bill-to address for the ship-to address. Use this field if a ship-to address needs to be associated with a specific bill-to address.

AH

34

Attention

36

Character

No

Enter the main contact of the customer who should receive invoices.

AI

35

Attention (Ship-To)

36

Character

No

Enter the main contact of the customer who should receive invoices for the ship-to address.

AJ

36

Attention (Bill-To)

36

Character

No

Enter the main contact of the customer who should receive invoices for the bill-to address.

AK

37

County

36

Character

No

Enter the county for the address.

AL

38

Country Tax Exempt Number

20

Character

Yes, only if Yes is entered for the Tax Exempt field and the internal tax functionality is used.

If the customer's ship-to address is always tax-exempt for all products shipped to it, enter the federal tax exemption number for the address. This field is informational only and does not apply to AvaTax interface.

AM

39

C-TPAT Importer of Record Number

20

Character

No

Enter the C-TPAT importer of record number for the bill-to address.

AN

40

Customer VAT ID (Ship-To)

20

Character

No

Enter a VAT identification number for the customer's ship-to address.

AO

41

VAT Exempt

3

Yes/No

No

Enter Yes or Y if you are importing a ship-to address that is VAT exempt.

Enter No or N if you are importing a ship-to address that is not VAT exempt.

AP

42

VAT Exempt Reason Code

20

Character

Yes, only if you enter Yes or Y for the VAT Exempt field

If you are importing a ship-to address that is exempt from VAT, enter a VAT exempt reason code to explain why it is exempt from VAT. For information on setting up VAT exempt reason codes, see VAT Exempt Reason Maintenance.

AQ

43

Shipping Location Prefix

3

Character

No

Enter a valid default shipping location prefix for the customer's orders for the ship-to address. This default shipping location overrides the default shipping location for the customer.

Note This default is only used if the Shipping or Both radio button is selected for the Use Customer Location for option in Accounts Receivable Control Maintenance.

For information on setting up shipping locations, see Location Maintenance.

AR

44

Sales Location Prefix

3

Character

No

Enter a valid default sales location prefix for the customer's orders for the ship-to address. This default sales location overrides the default sales location for the customer.

Note This default is only used if the Sales or Both radio button is selected for the Use Customer Location for option in Accounts Receivable Control Maintenance.

For information on setting up sales locations, see Location Maintenance.

AS

45

Sales Representative 1

12

Character

No

Enter a valid default primary sales representative for the customer's orders for the ship-to address. This default sales representative overrides the default primary sales representative for the customer. For information on setting up sales representatives, see Sales Representative Maintenance.

AT

46

Sales Representative 2

12

Character

No

Enter a valid default secondary sales representative for the customer's orders for the ship-to address. This default sales representative overrides the default secondary sales representative for the customer. For information on setting up sales representatives, see Sales Representative Maintenance.

AU

47

VAT Group Code

20

Character

No

Enter a VAT group code for the customer's ship-to address. For information on setting up VAT groups, see VAT Group Maintenance.

AV

48

Excise ID

30

Character

No

Enter the excise tax ID for the customer's ship-to address if the address is a tax warehouse.

AW

49

No Delivery Days

49

Character

No

Enter the days of the week the customer does not accept deliveries at the ship-to address. Separate each day of the week with the following delimiter character: |

EXAMPLE Saturday|Sunday

AX

50

Consent Provided

3

Yes/No

No

Enter Yes if the data subjects, that is, the customers, have provided consents to use their personal data such as addresses.

AY

51

Consent Attached

3

Yes/No

No

Enter Yes if the data subjects' consents to use their personal data, that is, addresses, are attached using the standard attachment function in Customer Maintenance.

AZ

52

Consent Date

10

99/99/9999

No

Enter the date on which the data subjects, that is, the customers, provided the consents to use their personal data such as addresses.

BA

53

Do Not Send EDI ASN

3

Yes/No

No

Enter Yes if you do not want to send EDI ASN's for the customer even if the trading partner associated with the customer is set up to send EDI ASN's.

BB

54

Do Not Send EDI Invoice

3

Yes/No

No

Enter Yes if you do not want to send EDI invoices for the customer even if the trading partner associated with the customer is set up to send EDI invoices.

BC

55

Do Not Send EDI Order Acknowledgment

3

Yes/No

No

Enter Yes if you do not want to send EDI order acknowledgments for the customer even if the trading partner associated with the customer is set up to send EDI order acknowledgments.

BD

56

Do Not Send EDI Order Status

3

Yes/No

No

Enter Yes if you do not want to send EDI order statuses for the customer even if the trading partner associated with the customer is set up to send EDI order statuses.

BE

57

Entity Use Code

25

Character

If AvaTax is used, and the value for the Tax Exempt field is Yes, then one of the following fields becomes a required field:

• State Tax Exempt Number

• Entity Use Code

If AvaTax is not used, this field is not required.

If AvaTax is used, enter an entity use code for the customer.

If AvaTax is not used, leave this field blank.