# CONTACT: Companies (basic data) - Name: `CONTACT` - Catalog: `AccountView` - Label: Companies (basic data) - Partition-specific: true - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `CONTACT` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ACCT_BAL` | `int64` | Balance | ☐ | | | `ACCT_BAL2` | `int64` | Balance payable | ☐ | | | `ACCT_LINK` | `int32` | Control account type | ☐ | | | `ACCT_NAME` | `string(40)` | Company name | ☐ | | | `ACCT_NR` | `string(10)` | Control account | ☐ | | | `ACCT_SND` | `string(10)` | Phonetic company name | ☐ | | | `ADDR_LINE1` | `string(40)` | Address line 1 | ☐ | | | `ADDR_LINE2` | `string(40)` | Address line 2 | ☐ | | | `ADDRESS1` | `string(80)` | Address | ☐ | | | `ADM_DEAR` | `string(40)` | Administration contact person salutation | ☐ | | | `ADMIN_CONT` | `string(40)` | Administration contact person | ☐ | | | `ADMIN_NAME` | `string(40)` | Administration contact person | ☐ | | | `ADMIN_PP` | `string(10)` | Contact person code | ☐ | | | `AI_NOWF` | `boolean` | Post purchase invoices in journal 'Purchase invoices, no workflow' | ☐ | | | `AIEI_MAND` | `boolean` | Always system-to-system | ☐ | | | `AIEM_MAND` | `boolean` | Always via email AutoInvoice | ☐ | | | `AIPR_MAND` | `boolean` | Always print service AutoInvoice | ☐ | | | `AMT_DD` | `int64` | Selected amount to be received | ☐ | | | `AMT_DDMAX` | `int64` | Maximum direct debit amount | ☐ | | | `AMT_PAY` | `int64` | Selected amount to be paid | ☐ | | | `AMT_REC` | `int64` | To be received | ☐ | | | `AMT_REST` | `int64` | Remaining amount | ☐ | | | `AMT_REST2` | `int64` | Remaining amount payable | ☐ | | | `APX_LIST` | `string(5)` | Price list item prices | ☐ | | | `AUTH_EMP` | `string(10)` | Approving employee | ☐ | | | `AUTO_INV` | `boolean` | Invoicing via AutoInvoice | ☐ | | | `BANK_AC_N1` | `string(34)` | Relation bank account 1 | ☐ | | | `BANK_AC_N2` | `string(34)` | Relation bank account 2 | ☐ | | | `BANK_ACC2` | `string(34)` | Bank account 2 | ☐ | | | `BANK_ACCT` | `string(34)` | Bank account 1 | ☐ | | | `BLK_ACCT` | `string(34)` | G-account number | ☐ | | | `BLK_BNK` | `string(10)` | G-account bank code | ☐ | | | `BLK_DATE` | `datetime` | Date of subcontractor payment behaviour proof | ☐ | | | `BLK_EINV` | `boolean` | Allow G-account information in electronic invoices | ☐ | | | `BLK_IBAN` | `string(34)` | G-account IBAN | ☐ | | | `BLK_PCT` | `decimal` | G-account percentage | ☐ | | | `BLK_SP` | `boolean` | Blocked for orders | ☐ | | | `BNK_CLEAR` | `boolean` | Postbank account pure | ☐ | | | `BNK_CODE1` | `string(10)` | Bank code, bank account 1 | ☐ | | | `BNK_CODE2` | `string(10)` | Bank code, bank account 2 | ☐ | | | `BOS_CODE` | `string(10)` | AccountView Server code | ☐ | | | `BOX_CITY` | `string(35)` | City or postal address city | ☐ | | | `BV_NR` | `string(25)` | UWV connection number | ☐ | | | `BV_PCT` | `decimal` | UWV percentage | ☐ | | | `BV_SUB` | `string(10)` | UWV supplier | ☐ | | | `C_CRIT_01` | `string(10)` | Company list field 1 | ☐ | | | `C_CRIT_02` | `string(10)` | Company list field 2 | ☐ | | | `C_CRIT_03` | `string(10)` | Company list field 3 | ☐ | | | `C_CRIT_04` | `string(10)` | Company list field 4 | ☐ | | | `C_CRIT_05` | `string(10)` | Company list field 5 | ☐ | | | `C_CRIT_06` | `string(10)` | Company list field 6 | ☐ | | | `C_CRIT_07` | `string(10)` | Company list field 7 | ☐ | | | `C_CRIT_08` | `string(10)` | Company list field 8 | ☐ | | | `C_CRIT_09` | `string(10)` | Company list field 9 | ☐ | | | `C_CRIT_10` | `string(10)` | Company list field 10 | ☐ | | | `C_YN_01` | `boolean` | Company checkbox field 1 | ☐ | | | `C_YN_02` | `boolean` | Company checkbox field 2 | ☐ | | | `C_YN_03` | `boolean` | Company checkbox field 3 | ☐ | | | `C_YN_04` | `boolean` | Company checkbox field 4 | ☐ | | | `C_YN_05` | `boolean` | Company checkbox field 5 | ☐ | | | `C_YN_06` | `boolean` | Company checkbox field 6 | ☐ | | | `C_YN_07` | `boolean` | Company checkbox field 7 | ☐ | | | `C_YN_08` | `boolean` | Company checkbox field 8 | ☐ | | | `C_YN_09` | `boolean` | Company checkbox field 9 | ☐ | | | `C_YN_10` | `boolean` | Company checkbox field 10 | ☐ | | | `CHN_ADRESS` | `string(4)` | Dealer postal address | ☐ | | | `CHN_CITY` | `string(35)` | Dealer city | ☐ | | | `CHN_CMAIL` | `string(50)` | Dealer main contact person email | ☐ | | | `CHN_CONT` | `string(50)` | Dealer main contact person | ☐ | | | `CHN_FAX` | `string(20)` | Dealer fax | ☐ | | | `CHN_MAIL` | `string(50)` | Dealer email | ☐ | | | `CHN_MEMB` | `boolean` | Relation is dealer | ☐ | | | `CHN_NAME` | `string(40)` | Dealer company name | ☐ | | | `CHN_TEL` | `string(20)` | Dealer telephone | ☐ | | | `CHN_TYPE` | `string(10)` | Dealer channel | ☐ | | | `CITY` | `string(35)` | City | ☐ | | | `CNG_DATE` | `datetime` | Date last modified | ☐ | | | `CNG_NR` | `int32` | Change number | ☐ | | | `CNG_USR` | `string(20)` | Modified by | ☐ | | | `CNT_CODE` | `string(2)` | ISO country code | ☐ | | | `COC_CODE` | `string(15)` | Chamber of Commerce number | ☐ | | | `COMMENT1` | `string(4)` | Customer/supplier note | ☐ | | | `COUNTRY` | `string(30)` | Country | ☐ | | | `CPA_CODE` | `string(10)` | Accountant | ☐ | | | `CR_AMT` | `int64` | Credit amount | ☐ | | | `CRED_BAL` | `int64` | Credit availability | ☐ | | | `CRED_LIM` | `int32` | Credit limit | ☐ | | | `CRED_SHOW` | `boolean` | Also show as supplier | ☐ | | | `CUR_CODE` | `string(3)` | Currency code | ☐ | | | `CUR_SIGN` | `string(1)` | Currency symbol | ☐ | | | `DD_ACT` | `boolean` | Direct debit allowed | ☐ | | | `DEB_NR` | `string(10)` | External customer number | ☐ | | | `DEB_NRV` | `string(10)` | External customer/supplier number | ☐ | | | `DEB_SHOW` | `boolean` | Also show as customer | ☐ | | | `DISC_CODE` | `string(2)` | Payment term code | ☐ | | | `DISC_PCT` | `decimal` | Invoice discount | ☐ | | | `DJIP_TO_PI` | `boolean` | Process posting proposals as purchase invoices | ☐ | | | `DR_AMT` | `int64` | Debit amount | ☐ | | | `EIA` | `string(50)` | Electronic Invoice Address | ☐ | | | `EL_CI` | `boolean` | Send counter invoices by email | ☐ | | | `EL_DP` | `boolean` | Send prepayments by email | ☐ | | | `EL_PO` | `boolean` | Send purchase orders by email | ☐ | | | `EL_PS` | `boolean` | Send delivery notes by email | ☐ | | | `EL_RE` | `boolean` | Send reminders by email | ☐ | | | `EL_SBS` | `boolean` | Send subscriptions by email | ☐ | | | `EL_SI` | `boolean` | Send invoices by email | ☐ | | | `EL_SO` | `boolean` | Send order confirmations by email | ☐ | | | `EMP_CAT` | `string(10)` | Employee class | ☐ | | | `EMP_NR` | `string(10)` | Salesperson/buyer | ☐ | | | `FAX_BUS` | `string(20)` | Business fax | ☐ | | | `FIRST_WF` | `string(10)` | First approver in the workflow | ☐ | | | `GIRO` | `string(20)` | Postbank account | ☐ | | | `GRAY_DATE` | `datetime` | Graydon import date | ☐ | | | `GRAY_INFO` | `string(4)` | Graydon credit information | ☐ | | | `GRAY_LIM` | `int32` | Graydon credit limit | ☐ | | | `GRAY_SCORE` | `decimal` | Graydon score | ☐ | | | `HDQ_CODE` | `string(10)` | Head office | ☐ | | | `HDQ_MEMB` | `boolean` | Branch office | ☐ | | | `IBAN_NR` | `string(34)` | IBAN 1 | ☐ | | | `IBAN_NR2` | `string(34)` | IBAN 2 | ☐ | | | `ICAT_CODE` | `string(1)` | IS goods flow category | ☐ | | | `ICNT_CODE` | `string(2)` | IS country code | ☐ | | | `IMM_WF` | `boolean` | Send invoices directly to workflow | ☐ | | | `INP_DATE` | `datetime` | Entry date | ☐ | | | `INP_USR` | `string(20)` | Entered by employee | ☐ | | | `INV_ADDRES` | `string(4)` | Address in country-dependent format (memo) | ☐ | | | `IS_COMP` | `boolean` | Relation is my competitor | ☐ | | | `ISHP_CODE` | `string(1)` | IS mode of transport | ☐ | | | `ISXF_CODE` | `string(3)` | IS statistical factor code | ☐ | | | `ISYS_CODE` | `string(2)` | IS regime | ☐ | | | `ITYP_CODE` | `string(1)` | IS transaction code | ☐ | | | `K_VAL_DATE` | `datetime` | Chamber of Commerce number verification date | ☐ | | | `LB_NR` | `string(25)` | Payroll tax number | ☐ | | | `LB_PCT` | `decimal` | Payroll tax percentage | ☐ | | | `LB_SUB` | `string(10)` | Payroll tax supplier | ☐ | | | `LNG_CODE` | `string(5)` | Language code | ☐ | | | `LNK_ACCT` | `string(10)` | Default account | ☐ | | | `MAIL_BUS` | `string(50)` | Business email | ☐ | | | `MAIL_OPT` | `int32` | Mailing | ☐ | | | `MAIN_CONT` | `string(40)` | Contact Person | ☐ | | | `MAIN_PP` | `string(10)` | Main contact person | ☐ | | | `MAND_B2B` | `boolean` | Direct debit type: business | ☐ | | | `MAND_DATE` | `datetime` | Signature date | ☐ | | | `MAND_ID` | `string(35)` | Direct debit mandate reference | ☐ | | | `MC_DEAR` | `string(40)` | Main contact person salutation | ☐ | | | `MC_MAILB` | `string(50)` | Main contact person email | ☐ | | | `MRN_LIST` | `string(5)` | Partner discount price list | ☐ | | | `NO_APPR` | `boolean` | Exclude from workflow | ☐ | | | `OPP_CURSOL` | `string(15)` | Package choice | ☐ | | | `OPP_SRC` | `string(10)` | Source | ☐ | | | `partition_code` | `string` | Partition code | ☑ | | | `partition_name` | `string` | Partition name | ☑ | | | `PAY_NAME` | `string(24)` | Short company name | ☐ | | | `PCT_LIST` | `string(5)` | Discount percentages price list | ☐ | | | `PD_PFX` | `string(15)` | Payment reference | ☐ | | | `PG_BLK` | `boolean` | Blocked for automatic payment | ☐ | | | `PO_BOX` | `string(80)` | Postal address | ☐ | | | `PO_CITY` | `string(35)` | Postal address city | ☐ | | | `PO_CODE` | `string(10)` | Postal address postcode | ☐ | | | `POL_PRIO` | `decimal` | Delivery priority | ☐ | | | `POST_CODE` | `string(10)` | Postcode | ☐ | | | `PROJ_CRED` | `boolean` | Project supplier | ☐ | | | `QD_CODE` | `string(5)` | Price list code | ☐ | | | `REC_BLK` | `boolean` | Blocked | ☐ | | | `REM_ADDR` | `string(4)` | Suppliers administration address in country-dependent format | ☐ | | | `REM_BLK` | `boolean` | Blocked for reminders | ☐ | | | `REV_CAT` | `string(10)` | Revenue category | ☐ | | | `RPL_CHN` | `string(10)` | Dealer of relation | ☐ | | | `RPL_GRP` | `string(10)` | Relation group | ☐ | | | `RPL_INV` | `string(10)` | Invoice customer/supplier | ☐ | | | `RPL_TYPE` | `string(10)` | Relation type | ☐ | | | `RPL_USER` | `boolean` | Relation is customer | ☐ | | | `SALE_AMT` | `int64` | Revenue current year | ☐ | | | `SALE_PY` | `int64` | Revenue previous year | ☐ | | | `SCAN_ID` | `string(10)` | Scanbooks relation no. | ☐ | | | `SG_CODE` | `string(10)` | Version | ☐ | | | `SHIP_COMP` | `boolean` | No partial deliveries allowed | ☐ | | | `SHIP_MTH` | `string(10)` | Transport method | ☐ | | | `SHOW_MEMPO` | `boolean` | Show note when adding purchase order | ☐ | | | `SHOW_MEMSO` | `boolean` | Show note when adding sales order | ☐ | | | `SIC_CODE` | `string(10)` | Industry code | ☐ | | | `SP_POSTADR` | `int32` | Address for delivery | ☐ | | | `SRC_CODE` | `string(10)` | Company search code | ☐ | | | `SRC_PC` | `string(10)` | Postcode (quick search) | ☐ | | | `ST_EXTRA` | `string(10)` | Address addition | ☐ | | | `ST_NR` | `string(10)` | House number | ☐ | | | `ST_PROP` | `string(40)` | Building | ☐ | | | `ST_REGION` | `string(40)` | Address region | ☐ | | | `ST_STREET` | `string(60)` | Street Name | ☐ | | | `SUB_NR` | `string(10)` | Customer/supplier number | ☐ | | | `SYNC_STATE` | `int32` | Synchronisation status | ☐ | | | `TEL_BUS` | `string(20)` | Business telephone | ☐ | | | `TEL_MOB` | `string(20)` | Mobile telephone | ☐ | | | `TRANS_NR` | `int32` | Number of transactions | ☐ | | | `VAT_CODE` | `string(2)` | VAT Code | ☐ | | | `VAT_DATE` | `datetime` | Verification date | ☐ | | | `VAT_NR` | `string(14)` | VAT number | ☐ | | | `VIS_ADDRES` | `string(4)` | Visiting address in country-dependent format (memo) | ☐ | | | `WF_AUTHEMP` | `string(10)` | IFA employee | ☐ | | | `WF_DIRECT` | `boolean` | Direct posting to cost accounts (IFA) | ☐ | | | `WWW_URL` | `string(60)` | Website | ☐ | |