Skip to main content
Skip table of contents

Contact

Contact

Column heading

Description

Mandatory field

Example value

Data type (length)

Import

Export

SupplierNr

Unique supplier number (NrIntern) of the supplier on organization level to which the optional contact refers.

yes

ONV000001

varchar(35)

yes

yes

ContactNr

Unique number for optional contact within a supplier

yes

000001

varchar(35)

yes

yes

Salutation

Salutation of the optional contact person

1 = Mr
2 = woman

no

1

tinyint

yes

yes

FirstName

First name of the optional contact person

no

Max

nvarchar(50)

yes

yes

LastName

Last name of the optional contact person

yes

Sample

nvarchar(50)

yes

yes

Position

Position of the optional contact person

no

Purchasing

nvarchar(50)

yes

yes

Department

Department of the optional contact person

no

Purchasing

tbd

yes

yes

Phone

Phone number of the optional contact person

no

+49 711 686875-0

varchar(50)

yes

yes

Fax

Fax number of the optional contact person

no

+49 711 686875-10

varchar(50)

yes

yes

MobilePhone

Mobile phone number of the optional contact person

no

+49 173 12345678

varchar(50)

yes

yes

Email

E-mail of the optional contact person

no

info@onventis.de

varchar(50)

yes

yes

Remark

Comment

no

Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua.

ntext

yes

yes

Standard

Standard contact

0 = not activated
1 = activated (standard contact)

no

1

tinyint

yes

yes

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.