Columns

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

Column Name Data Type
CUSTOMER* STRING(10)
AUTHORIZATIONGROUP STRING(4)
BILLINGISBLOCKEDFORC​USTOMER STRING(2)
CREATEDBYUSER STRING(12)
CREATIONDATE DATETIME(0)
CUSTOMERACCOUNTGROUP STRING(4)
CUSTOMERCLASSIFICATI​ON STRING(2)
CUSTOMERCORPORATEGRO​UP STRING(10)
CUSTOMERFULLNAME STRING(220)
CUSTOMERNAME STRING(80)
DELETIONINDICATOR BOOLEAN
DELIVERYISBLOCKED STRING(2)
FISCALADDRESS STRING(10)
INDUSTRY STRING(4)
INDUSTRYCODE1 STRING(10)
INDUSTRYCODE2 STRING(10)
INDUSTRYCODE3 STRING(10)
INDUSTRYCODE4 STRING(10)
INDUSTRYCODE5 STRING(10)
INTERNATIONALLOCATIO​NNUMBER1 STRING(7)
NFPARTNERISNATURALPE​RSON STRING(1)
NIELSENREGION STRING(2)
ORDERISBLOCKEDFORCUS​TOMER STRING(2)
POSTINGISBLOCKED BOOLEAN
RESPONSIBLETYPE STRING(2)
SUPPLIER STRING(10)
TAXNUMBER1 STRING(16)
TAXNUMBER2 STRING(11)
TAXNUMBER3 STRING(18)
TAXNUMBER4 STRING(18)
TAXNUMBER5 STRING(60)
TAXNUMBERTYPE STRING(2)
VATREGISTRATION STRING(20)