Address - Spreadsheets

Address

Column heading

Description

Mandatory field

Example value

Data type (length)

Import

Export

SupplierNr

Unique supplier number (NrIntern) of the supplier at organization level to which the optional address refers.

yes

ONV000001

varchar(35)

yes

yes

AddressNr

Unique address number within a supplier

yes

000001

varchar(35)

yes

yes

Street

Street of the main address

depending on the configuration of the organizational settings within the Onventis Buyer organization

Gropiusplatz 10

nvarchar(100)

yes

yes

Street2

Street 2 of the main address

no

STEP Area

nvarchar(100)

yes

yes

Building

main address building

no

House 1

nvarchar(50)

yes

yes

Floor

Floor of the main address

no

5

nvarchar(50)

yes

yes

Room

Room of the main address

no

05 Oct

nvarchar(50)

yes

yes

ZIPCity

Postcode of the main address

yes

70563

varchar(20)

yes

yes

City

Place of the main address

yes

Stuttgart

nvarchar(50)

yes

yes

Country

Country of the main address as ISO code – examples:

DE = Germany
AT = Austria
EN = England
…

If this column is not specified, the value DE is used by default when creating new data.

yes (if not specified, the value DE is automatically used for new creation)

EN

ISO code

yes

yes

Region

Region of the main address as ISO code – examples:

BW = Baden Württemberg
BY = Bavaria
BE = Berlin
…

Only available for Germany, Austria and USA

no

BW

ISO code

yes

yes

PBox

P.O. Box of the main address

no

P.O. Box

varchar(20)

yes

yes

ZIPPBox

Postcode of the P.O. Box of the main address

no

70563

varchar(20)

yes

yes

CityPBox

Location of the post office box of the main address

no

Stuttgart

nvarchar(50)

yes

yes

NrAtSupplier

Customer number at the supplier

no

CUS123456

varchar(35)

yes

yes

SalesTaxID

VAT number of the main address

no

DE12345678

varchar(35)

yes

yes

SalesTaxIDCheck

Result of the EU VIES VAT ID validation (only for linked suppliers from the portal)

0 = NA -> (Not applicable, as no EU VAT ID was provided and cannot be checked)
1 = NoVAT (no VAT ID applied)
2 = Confirmed (VAT ID is validated against EU VIES webservice)
3 = NotConfirmed (VAT ID could not be validated against EU VIES webservice)

no

2

int

no

yes

Phone

Phone number

no

+49 711 686875-0

varchar(50)

yes

yes

Fax

Fax number

no

+49 711 686875-10

varchar(50)

yes

yes

Email

E-mail for general system notifications

yes

info@onventis.de

varchar(50)

yes

yes