Master data: Import specification for Buyer table

Use these fields when you import master data for buyers. The master data import formats are described here.

Field

Description

Format

Required?

BuyerNumber

The internal organization number of the buyer.

1 to 100 characters

Yes

CorporateGroupID

The corporate group ID that the buyer is associated with.

1 to 100 characters (changed from integer in INVOICES 5-6)

Yes

Name1

The primary name of the buyer.

1 to 400 characters

Yes

Name2

The secondary name of the buyer.

1 to 350 characters

No

NameSupplement1

Additional name(s) of the buyer.

1 to 250 characters

No

NameSupplement2

Additional name(s) of the buyer.

1 to 250 characters

No

Description

A short description of the buyer.

1 to 400 characters

No

POBox

The PO Box number of the buyer's mailing address.

1 to 50 characters

No

Street

The street name of the buyer.

1 to 400 characters

No

StreetSupplement

Additional street details of the buyer.

1 to 400 characters

No

PostalCode

The post/ZIP code of the buyer.

1 to 100 characters

No

City

The city of the buyer.

1 to 200 characters

No

CountryCoded

The country code of the buyer.

2 to 3 alphabetic characters (A-Z)

Yes

CountryName

The country name of the buyer.

1 to 200 characters

No

TelephoneNumber

The telephone number of the buyer.

1 to 100 characters

No

FaxNumber

The fax number of the buyer.

1 to 100 characters

No

VATRegistrationNumber

The tax registration number of the buyer.

1 to 100 characters

No

Blocked

Indicates whether the buyer is blocked in INVOICES and cannot be used.

"x" or "X"

No