invantive documentation
Invantive Support ForumsLog In / Sign Up

CONTACT: AccountView Companies (basic data)

read only per partition

  • Catalog: AccountView
  • Label: Companies (basic data)

Can only retrieve data.

Table Columns

The columns of the table CONTACT are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

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