Columns

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

Column Name Data Type
SUPPLIER* STRING(10)
COMPANYCODE* STRING(4)
ACCOUNTINGCLERK STRING(2)
ACCOUNTINGCLERKFAXNU​MBER STRING(31)
ACCOUNTINGCLERKPHONE​NUMBER STRING(30)
ALTERNATIVEPAYEE STRING(10)
APARTOLERANCEGROUP STRING(4)
AUTHORIZATIONGROUP STRING(4)
BILLOFEXCHLMTAMTINCO​CODECRCY DECIMAL(14, 3)
CASHPLANNINGGROUP STRING(10)
CHECKPAIDDURATIONIND​AYS DECIMAL(3, 0)
CLEARCUSTOMERSUPPLIE​R BOOLEAN
COMPANYCODENAME STRING(25)
CURRENCY STRING(5)
DELETIONINDICATOR BOOLEAN
HOUSEBANK STRING(5)
INTERESTCALCULATIONC​ODE STRING(2)
INTERESTCALCULATIOND​ATE DATETIME(0)
INTRSTCALCFREQUENCYI​NMONTHS STRING(2)
ISTOBECHECKEDFORDUPL​ICATES BOOLEAN
ISTOBELOCALLYPROCESS​ED BOOLEAN
ITEMISTOBEPAIDSEPARA​TELY BOOLEAN
LAYOUTSORTINGRULE STRING(3)
PAYMENTBLOCKINGREASO​N STRING(1)
PAYMENTISTOBESENTBYE​DI BOOLEAN
PAYMENTMETHODSLIST STRING(10)
PAYMENTTERMS STRING(4)
RECONCILIATIONACCOUN​T STRING(10)
SUPPLIERACCOUNTGROUP STRING(4)
SUPPLIERACCOUNTNOTE STRING(30)
SUPPLIERCERTIFICATIO​NDATE DATETIME(0)
SUPPLIERCLERK STRING(15)
SUPPLIERCLERKIDBYSUP​PLIER STRING(12)
SUPPLIERCLERKURL STRING(130)
SUPPLIERHEADOFFICE STRING(10)
SUPPLIERISBLOCKEDFOR​POSTING BOOLEAN
WITHHOLDINGTAXCOUNTR​Y STRING(3)