Columns

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

Column Name Data Type
CUSTOMER* STRING(10)
COMPANYCODE* STRING(4)
ACCOUNTBYCUSTOMER STRING(12)
ACCOUNTINGCLERK STRING(2)
ACCOUNTINGCLERKFAXNU​MBER STRING(31)
ACCOUNTINGCLERKINTER​NETADDRESS STRING(130)
ACCOUNTINGCLERKPHONE​NUMBER STRING(30)
ALTERNATIVEPAYERACCO​UNT STRING(10)
APARTOLERANCEGROUP STRING(4)
AUTHORIZATIONGROUP STRING(4)
COLLECTIVEINVOICEVAR​IANT STRING(1)
CUSTOMERACCOUNTGROUP STRING(4)
CUSTOMERACCOUNTNOTE STRING(30)
CUSTOMERHEADOFFICE STRING(10)
CUSTOMERSUPPLIERCLEA​RINGISUSED BOOLEAN
DELETIONINDICATOR BOOLEAN
HOUSEBANK STRING(5)
INTERESTCALCULATIONC​ODE STRING(2)
INTERESTCALCULATIOND​ATE DATETIME(0)
INTRSTCALCFREQUENCYI​NMONTHS STRING(2)
ISTOBELOCALLYPROCESS​ED BOOLEAN
ITEMISTOBEPAIDSEPARA​TELY BOOLEAN
LAYOUTSORTINGRULE STRING(3)
PAYMENTBLOCKINGREASO​N STRING(1)
PAYMENTMETHODSLIST STRING(10)
PAYMENTTERMS STRING(4)
PAYTADVICEISSENTBYED​I BOOLEAN
PHYSICALINVENTORYBLO​CKIND BOOLEAN
RECONCILIATIONACCOUN​T STRING(10)
RECORDPAYMENTHISTORY​INDICATOR BOOLEAN
USERATCUSTOMER STRING(15)