invantive documentation
Invantive Support ForumsLog In / Sign Up

Visual FoxPro Data Model

Text comparisons on this platform are case sensitive.

Platform

  • Used from: the Invantive products on your own computer or server.
  • Kind: files.
  • Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.

Figures

Figure Count
Tables 12
Columns 453

Data Model Poster

This data model declares no keys yet; the dotted relations are derived from column names.

PDF, 1 A0 sheet

On a table of the poster: plus and minus zoom, the arrow keys move, 0 fits.

Visual FoxPro data model, Sheet 1 of 1Visual FoxPro data modelfor use with Invantive UniversalSQLRelease 25.0.17-PROD+5535 · 17-09-2025Tables without relationsSheet 1 of 1 · documentation.invantive.eu[XBase - dBase sample data]XBase - dBase sample dataav_art_hdrav_art_hdrav_art_lineav_art_linecp1251cp1251dbase_03dbase_03dbase_30dbase_30dbase_31dbase_31dbase_83dbase_83dbase_83_missing_memodbase_83_missing_memodbase_8bdbase_8bdbase_f5dbase_f5foxprotypesfoxprotypesVisual FoxProNotesThis data model declares no keys yet; the dotted relations are derived from column names.Data dictionaryEvery table and column of this data model is described with its documentation ondocumentation.invantive.eu, where the poster is also available in other languages.NotesThe boxes are grouped by topic and coloured by category. A relation is drawn in the topic of thetable holding the key; a box in pale grey is defined in another topic.TopicsTables without relations1LegendTransactionalSetupTechnicalHard-coded valuesDefined in another topicDeclared keyRelation described in wordsCandidate derived from column namesBold: a popular table+Bulk, +Read: the table also exists as these variants×n: n keys between the same tablesGenerated from the metadata of Invantive UniversalSQL 25.0.17-PROD+5535 on 17-09-2025. Every table links toits page with columns, keys and sample queries.documentation.invantive.eu/en/datamodels/foxpro
The poster as text: tables per topic and their relations

(without relations)

[XBase - dBase sample data], av_art_hdr, av_art_line, cp1251, dbase_03, dbase_30, dbase_31, dbase_83, dbase_83_missing_memo, dbase_8b, dbase_f5, foxprotypes

Tables

.

Attributes

The attributes of this platform are on the page Attributes.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: