invantive documentation
Forum di supporto InvantiveAccedi / Registrati

CONTACT: AccountView Companies (basic data)

read only per partition

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

È possibile solo recuperare i dati.

Colonne della tabella

Di seguito sono riportate le colonne della tabella CONTACT. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

Name Tipo di dati Label Required Marks Documentation
ACCT_BAL int64 Balance
ACCT_BAL2 int64 Balance payable
ACCT_LINK int32 Control account type
ACCT_NAME varchar2(40) Nome della ditta
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) Modificato da
CNT_CODE varchar2(2) ISO country code
COC_CODE varchar2(15) Numero di registrazione presso la Camera di Commercio
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) Persona di contatto
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) Nome della via
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) Codice IVA
VAT_DATE datetime Verification date
VAT_NR varchar2(14) Numero di partita IVA
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