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 | 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 |
E-mail of the optional contact person | no | 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 | no | 1 | tinyint | yes | yes |