Columns

The A_BUSINESSPARTNER table contains the following columns. Columns marked with an asterisk comprise the primary key.

Column Name Data Type
BUSINESSPARTNER* STRING(10)
ACADEMICTITLE STRING(4)
ADDITIONALLASTNAME STRING(40)
AUTHORIZATIONGROUP STRING(4)
BIRTHDATE DATETIME(0)
BUSINESSPARTNERCATEG​ORY STRING(1)
BUSINESSPARTNERFULLN​AME STRING(81)
BUSINESSPARTNERGROUP​ING STRING(4)
BUSINESSPARTNERIDBYE​XTSYSTEM STRING(20)
BUSINESSPARTNERISBLO​CKED BOOLEAN
BUSINESSPARTNERNAME STRING(81)
BUSINESSPARTNERTYPE STRING(4)
BUSINESSPARTNERUUID GUID(36)
CORRESPONDENCELANGUA​GE STRING(2)
CREATEDBYUSER STRING(12)
CREATIONDATE DATETIME(0)
CREATIONTIME TIMEOFDAY(0)
CUSTOMER STRING(10)
ETAG STRING(26)
FIRSTNAME STRING(40)
FORMOFADDRESS STRING(4)
GROUPBUSINESSPARTNER​NAME1 STRING(40)
GROUPBUSINESSPARTNER​NAME2 STRING(40)
INDEPENDENTADDRESSID STRING(10)
INDUSTRY STRING(10)
INTERNATIONALLOCATIO​NNUMBER1 STRING(7)
INTERNATIONALLOCATIO​NNUMBER2 STRING(5)
INTERNATIONALLOCATIO​NNUMBER3 STRING(1)
ISFEMALE BOOLEAN
ISMALE BOOLEAN
ISMARKEDFORARCHIVING BOOLEAN
ISNATURALPERSON STRING(1)
ISSEXUNKNOWN BOOLEAN
LANGUAGE STRING(2)
LASTCHANGEDATE DATETIME(0)
LASTCHANGEDBYUSER STRING(12)
LASTCHANGETIME TIMEOFDAY(0)
LASTNAME STRING(40)
LEGALFORM STRING(2)
MIDDLENAME STRING(40)
NAMECOUNTRY STRING(3)
NAMEFORMAT STRING(2)
ORGANIZATIONBPNAME1 STRING(40)
ORGANIZATIONBPNAME2 STRING(40)
ORGANIZATIONBPNAME3 STRING(40)
ORGANIZATIONBPNAME4 STRING(40)
ORGANIZATIONFOUNDATI​ONDATE DATETIME(0)
ORGANIZATIONLIQUIDAT​IONDATE DATETIME(0)
PERSONFULLNAME STRING(80)
PERSONNUMBER STRING(10)
SEARCHTERM1 STRING(20)
SUPPLIER STRING(10)
TRADINGPARTNER STRING(6)