|
Column Name
|
Data Type
|
|
BUSINESSPARTNER*
|
STRING(10)
|
|
ADDRESSID*
|
STRING(10)
|
|
ADDITIONALSTREETPREFIXNAME
|
STRING(40)
|
|
ADDITIONALSTREETSUFFIXNAME
|
STRING(40)
|
|
ADDRESSIDBYEXTERNALSYSTEM
|
STRING(20)
|
|
ADDRESSTIMEZONE
|
STRING(6)
|
|
ADDRESSUUID
|
GUID(36)
|
|
AUTHORIZATIONGROUP
|
STRING(4)
|
|
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)
|
|
VALIDITYENDDATE
|
DATETIME(0)
|
|
VALIDITYSTARTDATE
|
DATETIME(0)
|