Address

Address data coming from a third party system to be imported into Sertica

Name	Type	Additional information
AddressNo	string	Max length: 20
VendorNo	string	Required Max length: 20
Name	string	Max length: 80
LineOfBusiness	AddressType	None.
AddressLines	string	Max length: 2000
City	string	Max length: 80
Zipcode	string	Max length: 20
CountryCode	string	Max length: 6
Phone	string	Max length: 80
Email	string	Max length: 255
Homepage	string	Max length: 255
CurrencyCode	string	Max length: 3
LanguageCode	string	Max length: 10
VATNo	string	Max length: 30
PaymentConditionNo	string	Max length: 20
PaymentConditionText	string	Max length: 2000
Inactive	boolean	None.
DeliveryConditionNo	string	Max length: 20
DeliveryConditionText	string	Max length: 2000
CSRNo	string	Max length: 80
CSRProductGroupNo	string	Max length: 80