Columns

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

Column Name Data Type
SUPPLIER* STRING(10)
ALTERNATIVEPAYEEACCO​UNTNUMBER STRING(10)
AUTHORIZATIONGROUP STRING(4)
BIRTHDATE DATETIME(0)
CONCATENATEDINTERNAT​IONALLOCNO STRING(20)
CREATEDBYUSER STRING(12)
CREATIONDATE DATETIME(0)
CUSTOMER STRING(10)
DELETIONINDICATOR BOOLEAN
FISCALADDRESS STRING(10)
INDUSTRY STRING(4)
INTERNATIONALLOCATIO​NNUMBER1 STRING(7)
INTERNATIONALLOCATIO​NNUMBER2 STRING(5)
INTERNATIONALLOCATIO​NNUMBER3 STRING(1)
ISNATURALPERSON STRING(1)
PAYMENTISBLOCKEDFORS​UPPLIER BOOLEAN
POSTINGISBLOCKED BOOLEAN
PURCHASINGISBLOCKED BOOLEAN
RESPONSIBLETYPE STRING(2)
SUPLRPROOFOFDELIVRLV​TCODE STRING(1)
SUPLRQLTYINPROCMTCER​TFNVALIDTO DATETIME(0)
SUPLRQUALITYMANAGEME​NTSYSTEM STRING(4)
SUPPLIERACCOUNTGROUP STRING(4)
SUPPLIERCORPORATEGRO​UP STRING(10)
SUPPLIERFULLNAME STRING(220)
SUPPLIERNAME STRING(80)
SUPPLIERPROCUREMENTB​LOCK STRING(2)
TAXNUMBER1 STRING(16)
TAXNUMBER2 STRING(11)
TAXNUMBER3 STRING(18)
TAXNUMBER4 STRING(18)
TAXNUMBER5 STRING(60)
TAXNUMBERRESPONSIBLE STRING(18)
TAXNUMBERTYPE STRING(2)
VATREGISTRATION STRING(20)