|
Column Name
|
Data Type
|
|
RELATIONSHIPNUMBER*
|
STRING(12)
|
|
BUSINESSPARTNERCOMPANY*
|
STRING(10)
|
|
BUSINESSPARTNERPERSON*
|
STRING(10)
|
|
VALIDITYENDDATE*
|
DATETIME(0)
|
|
ADDRESSID*
|
STRING(10)
|
|
ADDITIONALSTREETPREFIXNAME
|
STRING(40)
|
|
ADDITIONALSTREETSUFFIXNAME
|
STRING(40)
|
|
ADDRESSNUMBER
|
STRING(10)
|
|
ADDRESSTIMEZONE
|
STRING(6)
|
|
CAREOFNAME
|
STRING(40)
|
|
CITYCODE
|
STRING(12)
|
|
CITYNAME
|
STRING(40)
|
|
COMPANYPOSTALCODE
|
STRING(10)
|
|
COUNTRY
|
STRING(3)
|
|
COUNTY
|
STRING(40)
|
|
DELIVERYSERVICENUMBER
|
STRING(10)
|
|
DELIVERYSERVICETYPECODE
|
STRING(4)
|
|
DISTRICT
|
STRING(40)
|
|
FORMOFADDRESS
|
STRING(4)
|
|
FULLNAME
|
STRING(80)
|
|
HOMECITYNAME
|
STRING(40)
|
|
HOUSENUMBER
|
STRING(10)
|
|
HOUSENUMBERSUPPLEMENTTEXT
|
STRING(10)
|
|
LANGUAGE
|
STRING(2)
|
|
PERSON
|
STRING(10)
|
|
POBOX
|
STRING(10)
|
|
POBOXDEVIATINGCITYNAME
|
STRING(40)
|
|
POBOXDEVIATINGCOUNTRY
|
STRING(3)
|
|
POBOXDEVIATINGREGION
|
STRING(3)
|
|
POBOXISWITHOUTNUMBER
|
BOOLEAN
|
|
POBOXLOBBYNAME
|
STRING(40)
|
|
POBOXPOSTALCODE
|
STRING(10)
|
|
POSTALCODE
|
STRING(10)
|
|
PRFRDCOMMMEDIUMTYPE
|
STRING(3)
|
|
REGION
|
STRING(3)
|
|
STREETNAME
|
STRING(60)
|
|
STREETPREFIXNAME
|
STRING(40)
|
|
STREETSUFFIXNAME
|
STRING(40)
|
|
TAXJURISDICTION
|
STRING(15)
|
|
TRANSPORTZONE
|
STRING(10)
|