AccountView Data Model
Connector for AccountView.
Platform
- Used from: Invantive Cloud and the Invantive products on your own computer or server.
- Kind: files.
- One query can read several companies at once.
- Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
Figures
| Figure | Count |
|---|---|
| Tables | 462 |
| Columns | 10,049 |
| Tables with insert | 0 |
| Tables with update | 0 |
| Tables with delete | 0 |
| Tables documented | 0 |
Tables
AccountView.
- ACTION: Activities
- ACT_SARE: Activity sub-areas
- ACT_SUBS: Activity priorities
- ACT_TMPL: Activity import templates
- ADM_BANK: Bank account numbers per administration
- ADM_GRP: Administration user groups
- ADM_LIST: Administrations
- ADM_LOCK: Administration locks
- ADM_LOG: Audit trail (administration)
- ADM_MON: Administration monitor
- ADM_PER: Periods
- ADM_PRF: Administration settings
- ADM_PRF2: Administration settings table 2
- ADM_PRF3: Administration settings table 3
- ADM_RNG: Partner administrations
- ADM_USR: Administration users
- AG_SPL: Sales splits
- ANR_GRP: Administration number groups
- ANR_POOL: Administration numbers
- API_REG: API Registry
- ARTICLE: Articles
- ART_BM: Item compositions
- ART_GRP: Item groups
- ART_HDR: Item pages
- ART_INFO: Extended item lines
- ART_LINE: Item lines
- ART_MOD: Module/functionality code links
- ART_PACK: Packaging
- ART_SELL: Item relations
- ART_SUP: Suppliers per item
- ASS_HDR: Licences
- ASS_LINE: Licence lines
- AUTH_PRO: Approval profiles
- AV_APP: AccountView.Net apps
- AV_MQ: Messages
- AV_SMQ: System messages
- BANK: Banks
- BANK_ASS: Bank account numbers per licence
- BNK_CODE: DNB codes
- BOS_AMSG: Asynchronous messages
- BOS_LOC: AccountView Server locations
- BUD_DCOD: Budget allocation codes
- BUD_DLIN: Budget allocation lines
- BUD_PER: Budget lines per period
- BUD_SCEN: Budget lines
- BUD_SCOD: Budgets
- BUS_RULE: Business rules
- CERT_LST: Certificates
- CHK_DESC: Reconciliation descriptions
- CHK_SETS: Checks per check set
- CLI_LOG: Audit trail (client data)
- CLT_ADM: Client administrations
- CLT_CHCK: Client administration checks
- CLT_CHG: Client changes
- CLT_CHKS: Client administration check sets
- CLT_LIC: Client licences
- CLT_LOG: Client logins
- CLT_MSGS: Client messages
- CNG_LINE: Key field series lines
- CNG_SETS: Key field series
- CNV_DAIL: Journal conversions
- CNV_PD: Payment discount conversions
- CODE_SNP: Code snippets
- COMB_DFS: Entry checks
- COMP_DOC: Enterprise documents
- COMP_DR: Enterprise reports
- COMP_HDR: Enterprises
- COMP_LN: Enterprise financial years
- COMP_REP: Enterprise report definitions
- CONTACT: Companies (basic data)
- CON_CON: Company roles at companies
- CON_EMP: Employee roles at companies
- CON_LINK: Bookmarks
- CON_PP: Contact person roles at companies
- COR_GRP: Text element groups
- COR_LET: Standard text layouts
- COR_REG: Text elements
- COST: Cost centres
- CRS_AKP: Inventory revaluation
- CRS_ALIC: Order additional modules
- CRS_AMOD: Item/module links
- CRS_ANET: AccountView.Net
- CRS_AOT: Object trace events
- CRS_APRU: Approval approvers
- CRS_CMSG: Client messages
- CRS_COMP: Checks status overview
- CRS_DJLS: Sales journal lines (import)
- CRS_DJPS: Sales journal pages (import)
- CRS_DRL: Drill around
- CRS_EMP: Relationship management employees
- CRS_FSL2: Count categories
- CRS_INFO: Infoline
- CRS_LAY: Layout design
- CRS_MLNK: Email attachments
- CRS_MODS: Modules
- CRS_OI3: Open items (journals)
- CRS_PAYT: Payt
- CRS_POH: Processed receipts
- CRS_PRVW: Print preview
- CRS_REL: Companies
- CRS_SCAN: Scan journals
- CRS_SL1: Cash register closings
- CRS_SOH: Processed deliveries
- CRS_SOT: Backorder/order analysis
- CRS_TASK: Current user notifications
- CRS_TRLB: Reporting
- CRS_VSET: Visma.net
- CRS_WEB: Web page viewer
- CRS_XBTV: XBRL specification lines
- CUR_CODE: Currency codes
- CUR_RATE: Exchange rates
- CVG_LINE: ITF Coverage lines
- CVG_METH: ITF Coverage per method
- CVG_PRG: ITF Coverage programs
- DAILY: Journals
- DASH_ITM: Dashboard
- DCT_ASP: Web catalogues
- DCT_DRL: Drill around object links
- DCT_FILE: Data Dictionary
- DCT_FLD: Field dictionary
- DCT_LNG: Dynamic Translation Dictionary
- DCT_OLAP: OLAP dictionary
- DCT_SQL: SQL Dictionary
- DCT_STGY: Connector components
- DCT_TAG: Index dictionary
- DEL_ADDR: Delivery addresses
- DEPT: Departments
- DEP_HDR: Depreciation methods
- DEP_LINE: Depreciation method lines
- DJB_HDR: Quick entries
- DJB_LINE: Quick entry lines
- DJIP_MAP: Posting proposal links
- DJI_MAPL: Journal message links
- DJ_IMP: Journal messages
- DJ_IMPS: Journal messages (system)
- DJ_LINE: Journal lines
- DJ_PAGE: Journal pages
- DOCK_FRM: Combination windows
- DOC_HDR: Mail merge letters
- DST_CODE: Allocation keys
- DST_LINE: Allocation lines
- EA_AT: eAccounting account type templates
- EA_ATLN: Account type template lines
- EA_CORR: eAccounting adjustments
- EA_LEAD: eAccounting accounts
- EA_TMP: eAccounting standard account templates
- EA_TMPLN: Standard account template lines
- EBNK_BNK: Client bank accounts
- EBNK_CLT: Clients with direct bank link
- EFS_CHK: Taxonomy checks
- EFS_HDR: Reporting taxonomies
- EFS_LINE: Taxonomy elements
- EFS_RPTD: Reporting segments
- EFS_RPTH: Reports
- EFS_RPTL: Reporting segment lines
- EFS_STAT: Partners' comparative figures
- EMAIL: Email addresses
- EMPLOYEE: Employees
- EMP_STAT: Employee statistics
- ERR_LOG: Event Log
- EXP_CANC: Billing cancellation reasons
- EXP_FORM: Billing formulas
- EXP_HDR: Billing proposals
- EXP_HIST: Billing history
- EXP_LINE: Billing proposal lines
- EXP_SPEC: Billing proposal specification
- FA_GRP: Fixed asset groups
- FA_HDR: Fixed assets
- FA_LINE: Asset card
- FLD_LOG: Field history
- FRM_TBR: Toolbars
- FS_HDR: Report models
- FS_LINE: Report model lines
- FTBR_LN: Buttons
- FUNC_HDR: Program functions
- FUNC_LN: Program function lines
- FVW_GRID: Column views
- FVW_HDR: Views
- GL_LEAD: Category accounts
- GL_STAT: Comparative annual figures
- GO_DISC: Go promotional prices
- GO_PER: AccountView Go periods
- GRP_APP: AccountView.Net apps
- GRP_FVW: User group views
- GRP_ROLE: User group roles
- HOST_LIC: ASP host licences
- HST_AH: Item history pages multiple years
- HST_AL: Item history multiple years
- HST_EXP: Billing history multiple years
- HST_FAL: Asset card multiple years
- HST_GJH: Journal history pages multiple years
- HST_GJL: Journal history multiple years
- HST_PJT: Project transfer history multiple years
- HST_TL: Hours history multiple years
- ICL_BASE: ICP return specification
- ICL_HDR: ICP returns
- ICL_LINE: ICP return lines
- IMP_1: Import
- IMP_2: Import lines
- IMP_GLF: Import filters
- IMP_TEMP: Import staging files
- INO_HDR: Stocktake orders
- INO_HIST: Stocktake history
- INO_LINE: Stocktake order lines
- INP_LIST: Free lists
- INT_PERC: Statutory interest rates
- IN_HDR: Inventory pages
- IN_LINE: Inventory page lines
- IN_TRN: Transaction codes
- ISO_CNT: ISO country codes
- ISO_CUR: ISO currency codes
- IS_CATEG: Intrastat goods flows
- IS_CNT: Intrastat countries
- IS_COMOD: Intrastat commodity codes
- IS_FACT: Intrastat statistical factors
- IS_SHIP: Intrastat modes of transport
- IS_SYS: Intrastat regimes
- IS_TYPE: Intrastat transactions
- IS_UNIT: Intrastat supplementary units
- ITFS_BAT: ITFserver batch
- ITFS_TST: ITFserver tests
- LANGUAGE: Language codes
- LBL_DEF: Labels
- LDG_STAT: Account status
- LEAD: Categories
- LEAD_EA: eAccounting account types
- LEDGER: General ledger
- LONGDESC: Extended item descriptions
- LVE: Leave requests
- LVE_APP: Reviewers
- LVE_DAY: Leave days
- LVE_PRT: Time periods
- LVE_TYPE: Leave types
- MAIL_ACT: Email activity templates
- MAIL_PRF: Email profiles
- MAIL_TMP: Email templates
- MAP_BASE: Base keys
- MAP_CC1: Cost centre keys
- MAP_CM1: Company keys
- MAP_CMP1: Enterprise keys
- MAP_CU1: Currency code keys
- MAP_DJ1: Journal keys
- MAP_EM1: Employee keys
- MAP_GL1: General ledger account keys
- MAP_HDR: Field Mapper
- MAP_LINE: Field Mapper Lines
- MAP_PA2: Partner keys
- MAP_PC1: Cost type keys
- MAP_PJ1: Project keys
- MAP_RPY: Reporting year keys
- MAP_TKN: DOS layout conversions
- MAP_UMU: User keys
- MAP_VA1: VAT code keys
- MAP_WT1: Work type keys
- MCTB_HDR: Multi-client e-banking pages
- MCTB_LNE: Multi-client e-banking lines
- MFG_HDR: Production orders
- MFG_LINE: Production order lines
- MOD_LST: Functionality codes
- MSCN_DOC: Visma Scanner documents
- NAVP_GRP: Navigation pane
- NAVP_ITM: Navigation pane items
- NAVP_SUB: Navigation pane subgroups
- NFD_GRP: Non-financial data
- NFD_PER: Non-financial data per period
- NMB_HDR: Nmbrs invoices
- NMB_LINE: Nmbrs invoice lines
- NPS_REG: NPS measurements
- OPENITEM: Open items
- OPEN_BB: Open items opening balance
- OPP_CHN: Opportunity stages
- OPP_COMP: Competing products
- OPP_CON: Company functions on opportunities
- OPP_EMP: Employee functions on opportunities
- OPP_REC: Opportunities
- OPP_RSN: Rejection reasons
- OPP_SRC: Opportunity sources
- OPP_TYPE: Product groups
- OW_HDR: Object Wizard headers
- OW_LINE: Object Wizard lines
- OW_LINK: Object Wizard links
- OW_SETUP: Object Wizard link master data
- OZB_GRP: Property tax (OZB) groups
- PAGE_WF: Workflow log page
- PAY_COND: Payment terms
- PC_LNG: Extended payment terms
- PC_TYPE: Cost types
- PEOPLE: Contacts
- PJB_LINE: Project budgeting lines
- PJTH_HDR: Project transfer history
- PJTH_LIN: Project transfer history lines
- PJT_HDR: Project transfers
- PJT_LINE: Project transfer lines
- PJT_TRN: Project transfer types
- PJ_CALC: Project calculation lines
- PJ_CARD: Project card
- PJ_LINE: Project journal
- PJ_LINEB: Project transactions opening balance
- PJ_RATE: Calculation units
- PJ_SET: Project billing methods
- PJ_SETL: Billing summarisation rules
- PJ_TYPE: Project types
- PKG_DICT: Source Data Structures
- PKG_INFO: Import definitions
- POI_HDR: Purchase invoices
- POI_LINE: Purchase invoice lines
- POL_SOL: Receipts to be allocated
- POQ_TIME: Inventory quantities over time
- POR_HDR: Receipts
- POR_LINE: Receipt lines
- POS_ID: Cash registers
- PO_BUFF: Draft orders
- PO_EXPN: Formulas
- PO_HDR: Purchase orders
- PO_LINE: Purchase order lines
- PROF_DST: Profit/loss allocations
- PROJECTS: Projects
- PROJ_CON: Company functions on projects
- PROJ_EMP: Employee functions on projects
- PROJ_GRP: Project groups
- PROJ_KPI: Project scorecard KPIs
- PROJ_NRM: Optimal KPI values
- PRO_ADV: Instalment billings
- PRO_INVM: Billing methods per dimension
- PXLIST: Price lists
- QD_QTY: Price tiers
- QRY_OPR: Query Operators
- QTH_HDR: Quotation history
- QTH_LINE: Quotation history lines
- QTY_DISC: Tiers
- QT_GRP: Quotation group footer
- QT_HDR: Quotations
- QT_H_GRP: Quotation group header
- QT_LINE: Quotation lines
- REC_TMPL: Entry templates
- REP_YEAR: Reporting years
- ROLEITEM: Role definitions
- RPL_GRP: Relation groups
- RPT_HDR: Report history
- RPT_LINE: Report lines
- SBS_CANC: Cancellation reasons
- SBS_GRP: Subscription groups
- SBS_HDR: Subscriptions
- SBS_LINE: Subscription lines
- SBS_PER: Subscription invoicing periods
- SCAN_TP: Scanboeken templates
- SCAN_USE: Scanboeken usage
- SCHEDULE: Alerts
- SEC_DJ1: Journal users
- SEC_DJ1G: Journal user groups
- SEC_GRP: User groups
- SEC_MEN: Menu options
- SEC_OBJ: Access security objects
- SEC_ROLE: Access security roles
- SEC_TMPG: Template user groups
- SEC_TMPL: Template users
- SEC_USR: Users
- SELL_GRP: Versions
- SHP_MTH: Transport methods
- SIC_GRP: Industry groups
- SIC_NR: Industry codes
- SIH_DEL: Overdue sales invoices
- SL_ATTR: Sub-administration attributes
- SL_HDR: Sub-administrations
- SL_LINE: Sub-administration lines
- SM_LNG: Extended transport methods
- SOC_LOG: Cash register log
- SOC_METH: Counter invoicing payment methods
- SOC_PAY: Counter invoicing payments
- SOI_HDR: Sales invoices
- SOI_LINE: Sales invoice lines
- SOP_DET: Packing list lines
- SOP_HDR: Issue orders
- SOP_LINE: Issue order lines
- SO_HDR: Sales orders
- SO_LINE: Sales order lines
- SRC_GRP: Field Groups
- STMT_HDR: Bank statements
- SUB_INST: Sub-installations
- SUB_PART: Partners
- SYS_EXPN: General expressions
- SYS_LOCK: System locks
- SYS_LOG: Audit Trail (system)
- SYS_MSG: Notifications
- SYS_PRF: User preferences
- SYS_TASK: System task results
- SYS_TREE: AccountView Explorer
- SYS_URLS: System bookmarks
- SYS_WORK: System tasks
- TAG_LINE: Marked lines
- TAX_MSG: Return messages
- TAX_PROF: Return profiles
- TBL_LTYP: Relationship management functions
- TB_SRC: Auto-coding
- TIM_COMB: Entry check values
- TIM_GRP: Hours statistics groups
- TIM_HDR: Time registration weeks
- TIM_HISD: Deleted hours history
- TIM_HIST: Hours history
- TIM_INP: Time registration lines per week
- TIM_LINE: Time registration lines
- TIM_RATE: Hourly rates
- TIM_TG: Hour type groups
- TIM_TYPE: Hour types
- TLB_HDR: Bank statements
- TLB_LINE: E-banking lines
- TMT: Tree template
- TRANSACT: Journal
- TRANSIT: Prepayments and accruals
- TRG_CHK: Signals per check
- TRN_CHK: Reconciliation transaction lines
- TRN_HDR: Journal pages
- TRN_TRG: Transaction signals
- TST_BEN: Network Tests
- TST_FILE: Recordsets used during test
- TST_HST: ITF History
- TST_OBJ: Objects started during test
- TST_SET: Test Scenarios
- UNT_ART: Units
- UNT_DESC: Extended unit descriptions
- UNT_RATE: Units per item
- UPD_RULE: Licence update lines
- USR_ACT: User activities
- USR_APP: AccountView.Net apps
- USR_GRP: User group links
- USR_LINK: Document links
- USR_LIST: User lists
- USR_LOG: Logged-in users
- USR_MEN: User menus
- USR_POP: Query lists per user
- USR_ROLE: User roles
- USR_RPT: User reports
- USR_VAL: User values
- VAT: VAT codes
- VAT_BASE: VAT return specification lines
- VAT_FORM: VAT return sections
- VAT_HDR: VAT returns
- VAT_LINE: VAT return lines
- VEND_CLS: Application Class Registry
- VSS_PROJ: Visual SourceSafe Projects
- WAREHS: Warehouses
- WEB_CANC: AccountView web cancellations
- WEB_EDIT: Web entry windows
- WEB_GRP: Web catalogue designs
- WEB_LINE: AccountView web order lines
- WEB_ORD: AccountView web orders
- WFEX_EMP: Excluded IFA addressees
- WF_INV: IFA documents
- WHS_LOC: Warehouse locations
- WHS_QTY: Inventory quantities warehouses
- WIZ_TAGS: Index usage
- WL_QTY: Inventory quantities warehouse locations
- WRK_FLW: IFA workflow
- WRK_ITEM: Work types
- XBRL_DIL: XBRL-dimension values
- XBRL_DIM: XBRL-dimensions
- XBRL_ELE: XBRL elements
- XBRL_EXT: External XBRL data
- XBRL_SP: XBRL specification definitions
- XBRL_SPV: XBRL specifications
- XBRL_TEX: XBRL default texts
- XBRL_VL: XBRL values
Attributes
The attributes of this platform are on the page Attributes.