Income & Expense accounting tables and columns structure

Documentation •
In this article

In Banana Accounting javascript extensions, when referring to tables and columns you must always use the correct nameXml.

Each table and each column has its own nameXml. With the nameXml, tables and columns can be accessed to read the data they contain.

All tables and columns are shown below with their nameXml.

Income & Expense accounting tables

These are the nameXml of all the tables for an Income & Expense accounting file:

  • Accounts.
    The nameXml for the Accounts table that is used to set up the balance sheet accounts of the accounting.

  • Categories.
    The nameXml for the Categories table that is used to set up the Income and Expenses categories of the accounting.

  • Transactions.
    The nameXml for the Transactions table that is used to enter all the accounting movements.
  • Budget.
    The nameXml for the Budget table that is used to enter the financial planning transactions in order to have a comprehensive vision of the future of the company.
  • VatCodes.
    The nameXml for the VatCodes table that is used to define all the parameters that allow to manage the procedures for registering with VAT.
  • Items.
    The nameXml for the Items table that is used to enter all the inventory items which need to be managed.
  • Documents.
    The nameXml for the Documents table that is used to include attachments like images, logos, text documents, HTML texts, Markdown codes, CSS stylesheet codes and Javascript codes.
  • Extract.
    The nameXml for the Extract table that is used to extract rows from a table and display them in a separate table. The rows of the main table are not changed.
  • FileInfo.
    The nameXml for the FileInfo table that is used by the program to store all the information about the currently open file.

In case of accounting without VAT, the VatCodes table is not present.

Each table is used for a specific purpose and has dedicated columns. The structure for each table with the related columns are shown below.

Accounts table

The Accounts table is used to set up the balance sheet accounts of the accounting. There are several types of accounts:

All nameXml of the table columns are listed below:

  • SysCod
  • Links
    This column is used to add a link to an external document.
  • Section
    This column is used to subdivide the chart of accounts into sections (assets and liabilities for balance sheet).
  • Group
    This column is used to define the group rows. The group code is then used in the Gr column to indicate the grouping for each account or group row, specifying which totalization group it belongs to.
  • Account
    This column is used to define the accounts of the for the balance sheet (assets and  liabilities).
  • Description
    This column is used to indicate the name or a description of the account, group or section.
  • Notes
    This column is used to add personal notes.
  • Disable
    This column is used to disable the accounts.
    By entering 1, the account does not appear in the auto-complete list, but can be used in the Transactions table.
    By entering 2, the account is disabled and can not be used.
  • VatCode
    This column is used to enter a VAT code that needs to be applied automatically, when this account is being entered in the Income or Expenses column of the Transactions.
    This column is linked to the VatCodes table where all the VAT codes with VAT rates are defined.
  • GrVat
  • VatNumber
    This column is used to enter the VAT number in case this account is linked to a client or a supplier.
  • FiscalNumber
    This column is used to enter the Fiscal number in case this account is linked to a client or a supplier.
  • Gr
    This column is used to indicate the grouping for each account or group row, specifying which totalization group it belongs to.
  • Gr1
    This column is used to indicate additional grouping codes.
  • Opening
    This column is used to indicate the account and group balance at the beginning of the year. The opening balance can be positive and negative.
  • Income
    This column is used to indicate the balance of incoming transactions included in the Transactions table.
  • Expenses
    This column is used to indicate the balance of expenses transactions included in the Transactions table.
  • Balance
    This column is used to indicate the balance of the account which includes the opening balance and the movements in income and expenses. The balance can be positive and negative.
  • Budget
    This column is used to enter the budget amount for the current period.
    The budgeted amount for income must be entered in positive, for expenses in negative.
    If the Budget table has been activated, the Budget column in the Accounts table is linked with the Budget table and the amounts are calculated on the basis of the budget postings.
  • BudgetDifference
    This column is used to indicate the difference between Balance and Budget amount.
  • Prior
    This column is used to indicate the balance of the account at the end of the preceding year.
  • PriorDifference
    This colum is used to indicate the difference between the Balance and the balance of preceding year.
  • BudgetPrior
    This column is used to indicate the previous year's budget.
  • PeriodBegin
    This column is used to indicate the balance at the start of the period.
  • PeriodIncome
    This column is used to indicate the total income in the period.
  • PeriodExpenses
    This column is used to indicate the total expenses in the period.
  • PeriodTotal
    This column is used to indicate the total movements in the period.
  • PeriodEnd
    This column is used to indicate the balance at end of the period.
  • NamePrefix
    This column is used to indicate the contact prefix. Used for customers and suppliers address information.
  • FirstName
    This column is used to indicate the contact name. Used for customers and suppliers address information.
  • FamilyName
    This column is used to indicate the contact last name. Used for customers and suppliers address information.
  • OrganisationName
    This column is used to indicate the contact organisation name. Used for customers and suppliers address information.
  • Street
    This column is used to indicate the contact street address. Used for customers and suppliers address information.
  • AddressExtra
    This column is used to indicate the contact extra street address. Used for customers and suppliers address information.
  • POBox
    This column is used to indicate the contact postal office box. Used for customers and suppliers address information.
  • PostalCode
    This column is used to indicate the contact postal code. Used for customers and suppliers address information.
  • Locality
    This column is used to indicate the contact locality. Used for customers and suppliers address information.
  • Region
    This column is used to indicate the contact region. Used for customers and suppliers address information.
  • Country
    This column is used to indicate the contact country. Used for customers and suppliers address information.
  • CountryCode
    This column is used to indicate the contact country code. Used for customers and suppliers address information.
  • LanguageCode
    This column is used to indicate the contact language code. Used for customers and suppliers address information.
  • PhoneMain
    This column is used to indicate the contact phone number. Used for customers and suppliers address information.
  • PhoneMobile
    This column is used to indicate the contact mobile phone number. Used for customers and suppliers address information.
  • Fax
    This column is used to indicate the contact fax number. Used for customers and suppliers address information.
  • EmailWork
    This column is used to indicate the contact email. Used for customers and suppliers address information.
  • Website
    This column is used to indicate the contact website. Used for customers and suppliers address information.
  • DateOfBirth
    This column is used to indicate the contact date of birth. Used for customers and suppliers information.
  • PaymentTermInDays
    This column is used to indicate the contact payment term in days. Used for customers and suppliers information.
  • CreditLimit
    This column is used to indicate the contact credit limit. Used for customers and suppliers information.
  • MemberFee
    This column is used to indicate the contact member fee. Used for customers and suppliers information.
  • BankName
    This column is used to indicate the contact bank name.
  • BankIban
    This column is used to indicate the contact bank IBAN code.
  • BankAccount
    This column is used to indicate the contact bank account code.
  • BankClearing
    This column is used to indicate the contact bank clearing code.
  • Code1
  • Description_En

Accounts columns structure

The list of columns is shown below in JSON format, with also additional information for each column.

{
  "nameXml": "Accounts",
  "columns": [
    {
      "nameXml": "SysCod",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "SysCod",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 100
    },
    {
      "nameXml": "Links",
      "alignment": "left",
      "dataType": "links",
      "decimal": "",
      "description": "Links to external documents",
      "excludeFromPrinting": "",
      "header": "Links",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 600
    },
    {
      "nameXml": "Section",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "Section",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 120
    },
    {
      "nameXml": "Group",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Group name",
      "excludeFromPrinting": "",
      "header": "Group",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 130
    },
    {
      "nameXml": "Account",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Account number",
      "excludeFromPrinting": "",
      "header": "Account",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 130
    },
    {
      "nameXml": "Description",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "Description",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 600
    },
    {
      "nameXml": "Notes",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Notes",
      "excludeFromPrinting": "",
      "header": "Notes",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 600
    },
    {
      "nameXml": "Disable",
      "alignment": "right",
      "dataType": "number",
      "decimal": "",
      "description": "Disable account or group",
      "excludeFromPrinting": "",
      "header": "Disable",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 100
    },
    {
      "nameXml": "VatCode",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "VAT/Sales tax code",
      "excludeFromPrinting": "",
      "header": "VAT code",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 125
    },
    {
      "nameXml": "GrVat",
      "alignment": "center",
      "dataType": "text",
      "decimal": "",
      "description": "VAT Group",
      "excludeFromPrinting": "",
      "header": "GrVAT",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 150
    },
    {
      "nameXml": "VatNumber",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "VAT/Sales tax number",
      "excludeFromPrinting": "",
      "header": "VAT number",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 250
    },
    {
      "nameXml": "FiscalNumber",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "Fiscal number",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 250
    },
    {
      "nameXml": "Gr",
      "alignment": "center",
      "dataType": "text",
      "decimal": "",
      "description": "Sum in the indicated Group",
      "excludeFromPrinting": "",
      "header": "Sum In",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 290
    },
    {
      "nameXml": "Gr1",
      "alignment": "center",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "Gr1",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 120
    },
    {
      "nameXml": "Opening",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "Opening balance",
      "excludeFromPrinting": "",
      "header": "Opening",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 250
    },
    {
      "nameXml": "Income",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "",
      "excludeFromPrinting": "",
      "header": "Income",
      "header2": "CHF",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": "",
      "width": 200
    },
    {
      "nameXml": "Expenses",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "",
      "excludeFromPrinting": "",
      "header": "Expenses",
      "header2": "CHF",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": "",
      "width": 200
    },
    {
      "nameXml": "Balance",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "Balance",
      "excludeFromPrinting": "",
      "header": "Balance",
      "header2": "CHF",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": "",
      "width": 200
    },
    {
      "nameXml": "Budget",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "Budget amount",
      "excludeFromPrinting": "",
      "header": "Budget",
      "header2": "CHF",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": "",
      "width": 200
    },
    {
      "nameXml": "BudgetDifference",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "Difference between budget and balance",
      "excludeFromPrinting": "",
      "header": "Diff.Budget",
      "header2": "CHF",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 200
    },
    {
      "nameXml": "Prior",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "Balance from previous year",
      "excludeFromPrinting": "",
      "header": "Prev. Year",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 250
    },
    {
      "nameXml": "PriorDifference",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "Difference between previous year and balance",
      "excludeFromPrinting": "",
      "header": "Diff. Prev. Year",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 250
    },
    {
      "nameXml": "BudgetPrior",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "Previous Year's Budget",
      "excludeFromPrinting": "",
      "header": "Prev.Year Budget",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 250
    },
    {
      "nameXml": "PeriodBegin",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "Balance at start of period",
      "excludeFromPrinting": "",
      "header": "Period Begin",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 250
    },
    {
      "nameXml": "PeriodIncome",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "Period Income",
      "excludeFromPrinting": "",
      "header": "Income Per.",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 250
    },
    {
      "nameXml": "PeriodExpenses",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "Period Expenses",
      "excludeFromPrinting": "",
      "header": "Expenses Per.",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 250
    },
    {
      "nameXml": "PeriodTotal",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "Total movements in the period",
      "excludeFromPrinting": "",
      "header": "Total Per.",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 250
    },
    {
      "nameXml": "PeriodEnd",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "Balance at end of period",
      "excludeFromPrinting": "",
      "header": "Period End",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 250
    },
    {
      "nameXml": "NamePrefix",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Contact prefix",
      "excludeFromPrinting": "",
      "header": "Prefix",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 250
    },
    {
      "nameXml": "FirstName",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Contact first name",
      "excludeFromPrinting": "",
      "header": "First name",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 400
    },
    {
      "nameXml": "FamilyName",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Contact family name",
      "excludeFromPrinting": "",
      "header": "Family name",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 400
    },
    {
      "nameXml": "OrganisationName",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Organisation/Company",
      "excludeFromPrinting": "",
      "header": "Organisation",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 400
    },
    {
      "nameXml": "Street",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Address street",
      "excludeFromPrinting": "",
      "header": "Street",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 400
    },
    {
      "nameXml": "AddressExtra",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Address Extra information",
      "excludeFromPrinting": "",
      "header": "Address extra",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 400
    },
    {
      "nameXml": "POBox",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Address P.O.Box",
      "excludeFromPrinting": "",
      "header": "P.O.Box",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 400
    },
    {
      "nameXml": "PostalCode",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Address Postal code",
      "excludeFromPrinting": "",
      "header": "Zip",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 150
    },
    {
      "nameXml": "Locality",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Address locality / city",
      "excludeFromPrinting": "",
      "header": "Locality",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 250
    },
    {
      "nameXml": "Region",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Address State/Province",
      "excludeFromPrinting": "",
      "header": "Region",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 100
    },
    {
      "nameXml": "Country",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Address country",
      "excludeFromPrinting": "",
      "header": "Country",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 250
    },
    {
      "nameXml": "CountryCode",
      "alignment": "center",
      "dataType": "text",
      "decimal": "",
      "description": "Address country code",
      "excludeFromPrinting": "",
      "header": "Country Code",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 100
    },
    {
      "nameXml": "LanguageCode",
      "alignment": "center",
      "dataType": "text",
      "decimal": "",
      "description": "Language code",
      "excludeFromPrinting": "",
      "header": "Language code",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 100
    },
    {
      "nameXml": "PhoneMain",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Phone main",
      "excludeFromPrinting": "",
      "header": "Main phone",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 400
    },
    {
      "nameXml": "PhoneMobile",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Mobile phone",
      "excludeFromPrinting": "",
      "header": "Mobile",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 400
    },
    {
      "nameXml": "Fax",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Contact fax",
      "excludeFromPrinting": "",
      "header": "Fax",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 400
    },
    {
      "nameXml": "EmailWork",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Email work",
      "excludeFromPrinting": "",
      "header": "Email work",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 400
    },
    {
      "nameXml": "Website",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Contact Web site",
      "excludeFromPrinting": "",
      "header": "WWW",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 400
    },
    {
      "nameXml": "DateOfBirth",
      "alignment": "right",
      "dataType": "date",
      "decimal": "",
      "description": "Contact date of birth",
      "excludeFromPrinting": "",
      "header": "Birth",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 200
    },
    {
      "nameXml": "PaymentTermInDays",
      "alignment": "right",
      "dataType": "number",
      "decimal": "",
      "description": "Payment term in days",
      "excludeFromPrinting": "",
      "header": "Days",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 250
    },
    {
      "nameXml": "CreditLimit",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Credit limit",
      "excludeFromPrinting": "",
      "header": "Limit",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 400
    },
    {
      "nameXml": "MemberFee",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "Member fee",
      "excludeFromPrinting": "",
      "header": "Fee",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 250
    },
    {
      "nameXml": "BankName",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Bank name",
      "excludeFromPrinting": "",
      "header": "Bank name",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 400
    },
    {
      "nameXml": "BankIban",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "IBAN Account",
      "excludeFromPrinting": "",
      "header": "IBAN",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 400
    },
    {
      "nameXml": "BankAccount",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Bank account",
      "excludeFromPrinting": "",
      "header": "Bank account",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 400
    },
    {
      "nameXml": "BankClearing",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "Bank clearing",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 400
    },
    {
      "nameXml": "Code1",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Code 1",
      "excludeFromPrinting": "",
      "header": "Code 1",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 250
    },
    {
      "nameXml": "Description_En",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Description_en",
      "excludeFromPrinting": "",
      "header": "Description_en",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 1518
    }
  ]
}

Categories table

The Categories table that is used to set up the Income and Expenses categories of the accounting. There are several types of categories:

  • Normal categories.
  • Segments (categories that begin with ":").
  • Cost Centers (categories that begin with "." or "," or ";").

All nameXml of the table columns are listed below:

  • SysCod
  • Links
    This column is used to add a link to an external document.
  • Section
    This column is used to subdivide the chart of accounts into sections (income and expenses for income statement).
  • Group
    This column is used to define the group rows. The group code is then used in the Gr column to indicate the grouping for each account or group row, specifying which totalization group it belongs to.
  • Category
    This column is used to define the categories, cost centers and segments.
    Categories can be numbers or text.
    Cost centers begin with "." or "," or ";". There are three levels of cost centers: "." is for cost centers 1, "," is for cost centers 2, ";" is for cost centers 3.
    Segments begin with ":". There can be multiple levels of segments: a single ":" is level 1, double "::" is level 2, three ":::" is level 3, etc. The maximun level allowed is 10.
  • Description
    This column is used to indicate the name or a description of the category, group or section.
  • Notes
    This column is used to add personal notes.
  • Disable
    This column is used to disable the categories.
    By entering 1, the category does not appear in the auto-complete list, but can be used in the Transactions table.
    By entering 2, the category is disabled and can not be used.
  • VatCode
    This column is used to enter a VAT code that needs to be applied automatically, when this category is being entered in the Income or Expenses column of the Transactions.
    This column is linked to the VatCodes table where all the VAT codes with VAT rates are defined.
  • GrVat
  • VatNumber
    This column is used to enter the VAT number in case this category is linked to a client or a supplier.
  • FiscalNumber
    This column is used to enter the Fiscal number in case this category is linked to a client or a supplier.
  • Gr
    This column is used to indicate the grouping for each category or group row, specifying which totalization group it belongs to.
  • Gr1
    This column is used to indicate additional grouping codes.
  • Income
    This column is used to indicate the balance of incoming transactions included in the Transactions table.
  • Expenses
    This column is used to indicate the balance of expenses transactions included in the Transactions table.
  • Balance
    This column is used to indicate the balance of the category which includes the opening balance and the movements in income and expenses. The balance can be positive and negative.
  • Budget
    This column is used to enter the budget amount for the current period.
    The budgeted amount for income must be entered in positive, for expenses in negative.
    If the Budget table has been activated, the Budget column in the Categories table is linked with the Budget table and the amounts are calculated on the basis of the budget postings.
  • BudgetDifference
    This column is used to indicate the difference between Balance and Budget amount.
  • Prior
    This column is used to indicate the balance of the account at the end of the preceding year.
  • PriorDifference
    This colum is used to indicate the difference between the Balance and the balance of preceding year.
  • BudgetPrior
    This column is used to indicate the previous year's budget.
  • PeriodBegin
    This column is used to indicate the balance at the start of the period.
  • PeriodIncome
    This column is used to indicate the total income in the period.
  • PeriodExpenses
    This column is used to indicate the total expenses in the period.
  • PeriodTotal
    This column is used to indicate the total movements in the period.
  • PeriodEnd
    This column is used to indicate the balance at end of the period.
  • Description_En

Categories columns structure

The list of columns is shown below in JSON format, with also additional information for each column.

{
  "nameXml": "Categories",
  "columns": [
    {
      "nameXml": "SysCod",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "SysCod",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 100
    },
    {
      "nameXml": "Links",
      "alignment": "left",
      "dataType": "links",
      "decimal": "",
      "description": "Links to external documents",
      "excludeFromPrinting": "",
      "header": "Links",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 600
    },
    {
      "nameXml": "Section",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "Section",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 120
    },
    {
      "nameXml": "Group",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Group name",
      "excludeFromPrinting": "",
      "header": "Group",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 130
    },
    {
      "nameXml": "Category",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "Category",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 130
    },
    {
      "nameXml": "Description",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "Description",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 600
    },
    {
      "nameXml": "Notes",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Notes",
      "excludeFromPrinting": "",
      "header": "Notes",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 600
    },
    {
      "nameXml": "Disable",
      "alignment": "right",
      "dataType": "number",
      "decimal": "",
      "description": "Disable account or group",
      "excludeFromPrinting": "",
      "header": "Disable",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 100
    },
    {
      "nameXml": "VatCode",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "VAT/Sales tax code",
      "excludeFromPrinting": "",
      "header": "VAT code",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 125
    },
    {
      "nameXml": "GrVat",
      "alignment": "center",
      "dataType": "text",
      "decimal": "",
      "description": "VAT Group",
      "excludeFromPrinting": "",
      "header": "GrVAT",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 150
    },
    {
      "nameXml": "VatNumber",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "VAT/Sales tax number",
      "excludeFromPrinting": "",
      "header": "VAT number",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 250
    },
    {
      "nameXml": "FiscalNumber",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "Fiscal number",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 250
    },
    {
      "nameXml": "Gr",
      "alignment": "center",
      "dataType": "text",
      "decimal": "",
      "description": "Sum in the indicated Group",
      "excludeFromPrinting": "",
      "header": "Sum In",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 120
    },
    {
      "nameXml": "Gr1",
      "alignment": "center",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "Gr1",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 120
    },
    {
      "nameXml": "Income",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "",
      "excludeFromPrinting": "",
      "header": "Income",
      "header2": "CHF",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": "",
      "width": 200
    },
    {
      "nameXml": "Expenses",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "",
      "excludeFromPrinting": "",
      "header": "Expenses",
      "header2": "CHF",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": "",
      "width": 200
    },
    {
      "nameXml": "Balance",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "Balance",
      "excludeFromPrinting": "",
      "header": "Balance",
      "header2": "CHF",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": "",
      "width": 200
    },
    {
      "nameXml": "Budget",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "Budget amount",
      "excludeFromPrinting": "",
      "header": "Budget",
      "header2": "CHF",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": "",
      "width": 200
    },
    {
      "nameXml": "BudgetDifference",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "Difference between budget and balance",
      "excludeFromPrinting": "",
      "header": "Diff.Budget",
      "header2": "CHF",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 200
    },
    {
      "nameXml": "Prior",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "Balance from previous year",
      "excludeFromPrinting": "",
      "header": "Prev. Year",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 250
    },
    {
      "nameXml": "PriorDifference",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "Difference between previous year and balance",
      "excludeFromPrinting": "",
      "header": "Diff. Prev. Year",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 250
    },
    {
      "nameXml": "BudgetPrior",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "Previous Year's Budget",
      "excludeFromPrinting": "",
      "header": "Prev.Year Budget",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 250
    },
    {
      "nameXml": "PeriodBegin",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "Balance at start of period",
      "excludeFromPrinting": "",
      "header": "Period Begin",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 250
    },
    {
      "nameXml": "PeriodIncome",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "Period Income",
      "excludeFromPrinting": "",
      "header": "Income Per.",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 250
    },
    {
      "nameXml": "PeriodExpenses",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "Period Expenses",
      "excludeFromPrinting": "",
      "header": "Expenses Per.",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 250
    },
    {
      "nameXml": "PeriodTotal",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "Total movements in the period",
      "excludeFromPrinting": "",
      "header": "Total Per.",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 250
    },
    {
      "nameXml": "PeriodEnd",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "Balance at end of period",
      "excludeFromPrinting": "",
      "header": "Period End",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 250
    },
    {
      "nameXml": "Description_En",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Description_en",
      "excludeFromPrinting": "",
      "header": "Description_en",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 1518
    }
  ]
}

Transactions table

The Transactions table is used to enter all the accounting movements. 

All nameXml of the table columns are listed below:

  • SysCod
  • Section
  • Date
    This column is used to indicate the date of the transaction.
  • DateDocument
    This column is used to indicate the date of a document.
  • DateValue
    This column is used to indicate the value date of the bank operation.
  • Doc
    This column is used to indicate the number of the document voucher of the transaction.
  • DocProtocol
    This column is used to indicate an extra alternative numbering for the transactions.
  • DocType
    This column is used to indicate a code that the program uses to identify a type of transaction.
    • 01=opening transaction.
    • 02=closing transaction.
    • from 10 to 19: codes for customers' invoices (10=invoice to client; 11=payment by client; 12=credit note to client).
    • from 20 to 29: codes for suppliers' invoices (20=invoice supplier; 21=payment to suppier; 22=credit note from supplier).
    • from 30 to 1000: codes reserved for future purposes.
  • DocOriginal
    This column is used to indicate the reference number present on a document.
  • DocInvoice
    This column is used to indicate the number of an issued or paid invoice.
  • InvoicePrinted
    This column is used to indicate when an invoice has already been printed (1=invoice printed).
  • DocLink
    This column is used to indicate a link to an external file.
  • ExternalReference
    This column is used to indicate the reference number that was allocated by the program that has generated the transaction. This value can be used to check whether a given operation is imported twice.
  • ItemsId
    This column is linked with the Items table. It is used to indicate the item identifier present in the Items table.
  • Description
    This column is used to indicate the text of the transaction.
  • Notes
    This column is used to indicate a personal note.
  • Quantity
    This column is used to indicate the quantity. For example when creating an invoice transaction. The Quantity multiplied by UnitPrice will produce the total amount.
  • ReferenceUnit
    This column is linked with the ReferenceUnit column of Items table. It is used to indicate a description referring to the quantity. For example when creating an invoice transaction it is referred to the item (pieces, hours, etc.).
  • UnitPrice
    This column is linked with the SellingPrice column of Items table. It is used to indicate the unit price. For example when creating an invoice transaction. The UnitPrice multiplied by the Quantity, will produce the total amount.
  • Income
    This column is used to indicate the incoming amount.
  • Expenses
    This column is used to indicate the outgoing amount.
  • Account
    This column is linked with the Account column of Accounts table. It is used to indicate the account present in the Accounts table.
  • AccountDes
    This column is linked with the Description column of Accounts table. It is used to indicate the account's description present in the Accounts table.
  • Category
    This column is linked with the Category column of Categories table. It is used to indicate the category present in the Categories table.
  • CategoryDes
    This column is linked with the Description column of Categories table. It is used to indicate the category's description present in the Categories table.
  • Balance
    This column is used to indicate the sum of income and expenses.
  • VatCode
    This column is linked with the VatCode column of the VatCodes table. It is used for transactions with VAT to indicate the VAT code to use (the VAT code must be present in the VatCodes table).
  • VatAmountType
    This column is linked with the AmountType column of VatCodes table. It is used to indicate how the program consider the transaction amount:
    • 0 (or empty cell) = with VAT/sales tax; the transaction amount is VAT included.
    • 1 = without VAT/Sales tax; the transaction amount is VAT excluded.
    • 2 = VAT amount; the transaction amount is considered the VAT amount at 100%.
  • VatExtraInfo
    This column is linked with the VatCodes table. It is used to indicate a code related to extra info about the VAT, to be used only in very exceptional cases. It is possible to enter a symbol to identify specific VAT cases.
  • VatRate
    This column is linked with the VatRate column of VatCodes table. It is used to indicate the VAT percentage associated with the VAT code.
  • VatRateEffective
    This column is used to indicate the VAT percentage referred to the net amount (taxable amount).
  • VatTaxable
    This column is used to indicate the taxable amount (without VAT). 
  • VatAmount
    This column is used to indicate the VAT amount.
  • VatAccount
    This column is linked with the VatAccount column of VatCodes table. It is used to indicate the account where the VAT is registered.
  • VatAccountDes
    This column is linked with the Description column of the Accounts table. It is used to indicate the VAT account description.
  • VatPercentNonDeductible
    This column is linked with the VatPercentNonDeductible of VatCodes table. It is used to indicate the non deductible percentage.
  • VatNonDeductible
    This column is used to indicate the VAT non deductible amount.
  • VatPosted
    This column is used to indicate the VAT amount registered in the VAT account (the difference "VatAmount - VatNonDeductible").
  • VatNumber
    This column is linked with the VatNumber column of Accounts/Categories table. It is used to indicate the code or VAT number of a client/supplier.
  • Cc1
    This column is linked with the Category column of Categories table. It is used to indicate the cost center that in Categories table is preceded by "." In Cc1 column of Transactions table the cost center is entered without "."
  • Cc1Des
    This column is linked with the Description column of Categories table. It used to indicate the description of the cost center preceded by "."
  • Cc2
    This column is linked with the Category column of Categories table. It is used to indicate the cost center that in Categories table is preceded by "," In Cc2 column of Transactions table the cost center is entered without ","
  • Cc2Des
    This column is linked with the Description column of Categories table. It used to indicate the description of the cost center preceded by ","
  • Cc3
    This column is linked with the Category column of Categories table. It is used to indicate the cost center that in Categories table is preceded by ";" In Cc3 column of Transactions table the cost center is entered without ";"
  • Cc3Des
    This column is linked with the Description column of Categories table. It used to indicate the description of the cost center preceded by ";"
  • Segment
    This column is not used.
  • DateExpiration
    This column is used to indicate the date before which an invoice has to be paid.
  • DateExpected
  • DatePayment
    This column is used to indicate the payment date.
  • LockNumber
  • LockAmount
  • LockProgressive
  • LockLine

Transactions columns structure

The list of columns is shown below in JSON format, with also additional information for each column.

{
  "nameXml": "Transactions",
  "columns": [
    {
      "nameXml": "SysCod",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "SysCod",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 100
    },
    {
      "nameXml": "Section",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "Section",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 120
    },
    {
      "nameXml": "Date",
      "alignment": "left",
      "dataType": "date",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "Date",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 200
    },
    {
      "nameXml": "DateDocument",
      "alignment": "left",
      "dataType": "date",
      "decimal": "",
      "description": "Document date",
      "excludeFromPrinting": "",
      "header": "Doc Date",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 200
    },
    {
      "nameXml": "DateValue",
      "alignment": "left",
      "dataType": "date",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "Date value",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 200
    },
    {
      "nameXml": "Doc",
      "alignment": "center",
      "dataType": "text",
      "decimal": "",
      "description": "Document number",
      "excludeFromPrinting": "",
      "header": "Doc",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 100
    },
    {
      "nameXml": "DocProtocol",
      "alignment": "center",
      "dataType": "text",
      "decimal": "",
      "description": "Protocol number",
      "excludeFromPrinting": "",
      "header": "Doc.Prot.",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 100
    },
    {
      "nameXml": "DocType",
      "alignment": "center",
      "dataType": "text",
      "decimal": "",
      "description": "Document type",
      "excludeFromPrinting": "",
      "header": "Type",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 100
    },
    {
      "nameXml": "DocOriginal",
      "alignment": "center",
      "dataType": "text",
      "decimal": "",
      "description": "Original document number",
      "excludeFromPrinting": "",
      "header": "Doc.Original",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 100
    },
    {
      "nameXml": "DocInvoice",
      "alignment": "center",
      "dataType": "text",
      "decimal": "",
      "description": "Invoice number",
      "excludeFromPrinting": "",
      "header": "Invoice",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 150
    },
    {
      "nameXml": "InvoicePrinted",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Invoice printed",
      "excludeFromPrinting": "",
      "header": "Printed",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 100
    },
    {
      "nameXml": "DocLink",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Link to external file",
      "excludeFromPrinting": "",
      "header": "Link",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 300
    },
    {
      "nameXml": "ExternalReference",
      "alignment": "center",
      "dataType": "text",
      "decimal": "",
      "description": "External reference",
      "excludeFromPrinting": "",
      "header": "ExtRef",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 100
    },
    {
      "nameXml": "ItemsId",
      "alignment": "right",
      "dataType": "text",
      "decimal": "",
      "description": "Items Id",
      "excludeFromPrinting": "",
      "header": "Item",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 150
    },
    {
      "nameXml": "Description",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "Description",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 600
    },
    {
      "nameXml": "Notes",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Annotations",
      "excludeFromPrinting": "",
      "header": "Notes",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 500
    },
    {
      "nameXml": "Quantity",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 4,
      "description": "Quantity",
      "excludeFromPrinting": "",
      "header": "Qt.",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 125
    },
    {
      "nameXml": "ReferenceUnit",
      "alignment": "center",
      "dataType": "text",
      "decimal": "",
      "description": "Reference unit",
      "excludeFromPrinting": "",
      "header": "Unit",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 100
    },
    {
      "nameXml": "UnitPrice",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 4,
      "description": "Unit price",
      "excludeFromPrinting": "",
      "header": "Unit/Price",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 125
    },
    {
      "nameXml": "Income",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "",
      "excludeFromPrinting": "",
      "header": "Income",
      "header2": "CHF",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 220
    },
    {
      "nameXml": "Expenses",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "",
      "excludeFromPrinting": "",
      "header": "Expenses",
      "header2": "CHF",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 220
    },
    {
      "nameXml": "Account",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "Account",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 170
    },
    {
      "nameXml": "AccountDes",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Account Description",
      "excludeFromPrinting": "",
      "header": "Account Des.",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 300
    },
    {
      "nameXml": "Category",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "Category",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 170
    },
    {
      "nameXml": "CategoryDes",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Category Description",
      "excludeFromPrinting": "",
      "header": "Category Des.",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 300
    },
    {
      "nameXml": "Balance",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "",
      "excludeFromPrinting": "",
      "header": "Balance",
      "header2": "CHF",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 200
    },
    {
      "nameXml": "VatCode",
      "alignment": "center",
      "dataType": "text",
      "decimal": "",
      "description": "VAT/Sales tax code",
      "excludeFromPrinting": "",
      "header": "VAT Code",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 100
    },
    {
      "nameXml": "VatAmountType",
      "alignment": "center",
      "dataType": "number",
      "decimal": "",
      "description": "Vat Amount Type",
      "excludeFromPrinting": "",
      "header": "Amount Type",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 150
    },
    {
      "nameXml": "VatExtraInfo",
      "alignment": "center",
      "dataType": "text",
      "decimal": "",
      "description": "VAT Extra Info",
      "excludeFromPrinting": "",
      "header": "Extra info",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 200
    },
    {
      "nameXml": "VatRate",
      "alignment": "right",
      "dataType": "number",
      "decimal": 2,
      "description": "VAT/Sales tax percentage",
      "excludeFromPrinting": "",
      "header": "%VAT",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": "",
      "width": 100
    },
    {
      "nameXml": "VatRateEffective",
      "alignment": "right",
      "dataType": "number",
      "decimal": 2,
      "description": "Effective VAT/Sales tax rate",
      "excludeFromPrinting": "",
      "header": "%Eff.",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 100
    },
    {
      "nameXml": "VatTaxable",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "Sales tax/VAT taxable amount",
      "excludeFromPrinting": "",
      "header": "Taxable",
      "header2": "CHF",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 200
    },
    {
      "nameXml": "VatAmount",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "VAT/Sales tax amount",
      "excludeFromPrinting": "",
      "header": "Amt.VAT",
      "header2": "CHF",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 200
    },
    {
      "nameXml": "VatAccount",
      "alignment": "center",
      "dataType": "text",
      "decimal": "",
      "description": "VAT/Sales tax account",
      "excludeFromPrinting": "",
      "header": "VAT A/C",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 150
    },
    {
      "nameXml": "VatAccountDes",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "VAT/Sales tax account description",
      "excludeFromPrinting": "",
      "header": "VAT A/C Des.",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 300
    },
    {
      "nameXml": "VatPercentNonDeductible",
      "alignment": "right",
      "dataType": "number",
      "decimal": 2,
      "description": "Percent non deductible",
      "excludeFromPrinting": "",
      "header": "%NonDed.",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 120
    },
    {
      "nameXml": "VatNonDeductible",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "Amount non deductible",
      "excludeFromPrinting": "",
      "header": "NonDed",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 200
    },
    {
      "nameXml": "VatPosted",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "VAT/Sales tax accountable",
      "excludeFromPrinting": "",
      "header": "VAT Acc",
      "header2": "CHF",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": "",
      "width": 200
    },
    {
      "nameXml": "VatNumber",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "VAT/Sales tax number",
      "excludeFromPrinting": "",
      "header": "VAT Number",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 200
    },
    {
      "nameXml": "Cc1",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Cost center 1",
      "excludeFromPrinting": "",
      "header": "CC1",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 150
    },
    {
      "nameXml": "Cc1Des",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Description of cost center 1",
      "excludeFromPrinting": "",
      "header": "CC1 Description",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 300
    },
    {
      "nameXml": "Cc2",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Cost center 2",
      "excludeFromPrinting": "",
      "header": "CC2",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 150
    },
    {
      "nameXml": "Cc2Des",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Description of cost center 2",
      "excludeFromPrinting": "",
      "header": "CC2 Description",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 300
    },
    {
      "nameXml": "Cc3",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Cost center 3",
      "excludeFromPrinting": "",
      "header": "CC3",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 150
    },
    {
      "nameXml": "Cc3Des",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Description of cost center 3",
      "excludeFromPrinting": "",
      "header": "CC3 Description",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 300
    },
    {
      "nameXml": "Segment",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Segment",
      "excludeFromPrinting": "",
      "header": "Segment",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 150
    },
    {
      "nameXml": "DateExpiration",
      "alignment": "left",
      "dataType": "date",
      "decimal": "",
      "description": "Expiration date",
      "excludeFromPrinting": "",
      "header": "Date Exp.",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 200
    },
    {
      "nameXml": "DateExpected",
      "alignment": "right",
      "dataType": "date",
      "decimal": "",
      "description": "Date expected",
      "excludeFromPrinting": "",
      "header": "Expected",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 200
    },
    {
      "nameXml": "DatePayment",
      "alignment": "left",
      "dataType": "date",
      "decimal": "",
      "description": "Payment date",
      "excludeFromPrinting": "",
      "header": "Date Pay.",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 200
    },
    {
      "nameXml": "LockNumber",
      "alignment": "center",
      "dataType": "text",
      "decimal": "",
      "description": "Lock number",
      "excludeFromPrinting": "",
      "header": "LockNum",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 100
    },
    {
      "nameXml": "LockAmount",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "Lock amount",
      "excludeFromPrinting": "",
      "header": "LockAmt",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 200
    },
    {
      "nameXml": "LockProgressive",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Lock progressive",
      "excludeFromPrinting": "",
      "header": "LockProgr",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 380
    },
    {
      "nameXml": "LockLine",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "LockLine",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 150
    }
  ]
}

Budget table

The Budget table is very similar to the Transactions table, but with some specific columns.

The Budget table is used to enter the financial planning transactions in order to have a comprehensive vision of the future of the company.

All nameXml of the table columns are listed below:

  • SysCod
  • Section
  • Date
    This column is used to indicate the future date when you expect the operation to take place.
  • DateEnd
  • Repeat
    This column is used to indicate a repetition code for recurring income or expenses.
  • Variant
    This column is used to indicate a possible variant relating to the budget, in combination with the Extensions.
  • ForNewYear
    This column is used to indicate how the transfer should take place when a new year is created (no value=date incremented by one year; 1=date remains the same; 2=transaction not transferred to new year).
  • DateDocument
  • DateValue
  • Doc
  • DocProtocol
  • DocType
  • DocOriginal
  • DocInvoice
  • InvoicePrinted
  • DocLink
  • ExternalReference
  • ItemsId
  • Description
  • Notes
  • Quantity
  • ReferenceUnit
  • UnitPrice
  • FormulaBegin
    This column is used to enter a text that will be inserted before the text used in the Formula and then used for calculation.
  • Formula
    This column is used to enter calculation formulas in javascript, or programming functions of the Banana Accounting Extensions.
  • Income
  • Expenses
  • Account
  • AccountDes
  • Category
  • CategoryDes
  • AmountTotal
  • VatCode
  • VatAmountType
  • VatExtraInfo
  • VatRate
  • VatRateEffective
  • VatTaxable
  • VatAmount
  • VatAccount
  • VatAccountDes
  • VatPercentNonDeductible
  • VatNonDeductible
  • VatPosted
  • VatNumber
  • Cc1
  • Cc1Des
  • Cc2
  • Cc2Des
  • Cc3
  • Cc3Des
  • Segment
  • DateExpiration
  • DateExpected
  • DatePayment

Budget columns structure

The list of columns is shown below in JSON format, with also additional information for each column.

{
  "nameXml": "Budget",
  "columns": [
    {
      "nameXml": "SysCod",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "SysCod",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 100
    },
    {
      "nameXml": "Section",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "Section",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 120
    },
    {
      "nameXml": "Date",
      "alignment": "left",
      "dataType": "date",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "Date",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 200
    },
    {
      "nameXml": "DateEnd",
      "alignment": "right",
      "dataType": "date",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "End",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 200
    },
    {
      "nameXml": "Repeat",
      "alignment": "center",
      "dataType": "text",
      "decimal": "",
      "description": "Repeat",
      "excludeFromPrinting": "",
      "header": "Repeat",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 100
    },
    {
      "nameXml": "Variant",
      "alignment": "center",
      "dataType": "text",
      "decimal": "",
      "description": "Variant",
      "excludeFromPrinting": "",
      "header": "Variant",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 100
    },
    {
      "nameXml": "ForNewYear",
      "alignment": "center",
      "dataType": "text",
      "decimal": "",
      "description": "How to handle transaction for new year creation",
      "excludeFromPrinting": "",
      "header": "New Year",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 100
    },
    {
      "nameXml": "DateDocument",
      "alignment": "left",
      "dataType": "date",
      "decimal": "",
      "description": "Document date",
      "excludeFromPrinting": "",
      "header": "Doc Date",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 200
    },
    {
      "nameXml": "DateValue",
      "alignment": "left",
      "dataType": "date",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "Date value",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 200
    },
    {
      "nameXml": "Doc",
      "alignment": "center",
      "dataType": "text",
      "decimal": "",
      "description": "Document number",
      "excludeFromPrinting": "",
      "header": "Doc",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 100
    },
    {
      "nameXml": "DocProtocol",
      "alignment": "center",
      "dataType": "text",
      "decimal": "",
      "description": "Protocol number",
      "excludeFromPrinting": "",
      "header": "Doc.Prot.",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 100
    },
    {
      "nameXml": "DocType",
      "alignment": "center",
      "dataType": "text",
      "decimal": "",
      "description": "Document type",
      "excludeFromPrinting": "",
      "header": "Type",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 100
    },
    {
      "nameXml": "DocOriginal",
      "alignment": "center",
      "dataType": "text",
      "decimal": "",
      "description": "Original document number",
      "excludeFromPrinting": "",
      "header": "Doc.Original",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 100
    },
    {
      "nameXml": "DocInvoice",
      "alignment": "center",
      "dataType": "text",
      "decimal": "",
      "description": "Invoice number",
      "excludeFromPrinting": "",
      "header": "Invoice",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 150
    },
    {
      "nameXml": "InvoicePrinted",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Invoice printed",
      "excludeFromPrinting": "",
      "header": "Printed",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 100
    },
    {
      "nameXml": "DocLink",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Link to external file",
      "excludeFromPrinting": "",
      "header": "Link",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 300
    },
    {
      "nameXml": "ExternalReference",
      "alignment": "center",
      "dataType": "text",
      "decimal": "",
      "description": "External reference",
      "excludeFromPrinting": "",
      "header": "ExtRef",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 100
    },
    {
      "nameXml": "ItemsId",
      "alignment": "right",
      "dataType": "text",
      "decimal": "",
      "description": "Items Id",
      "excludeFromPrinting": "",
      "header": "Item",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 150
    },
    {
      "nameXml": "Description",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "Description",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 600
    },
    {
      "nameXml": "Notes",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Annotations",
      "excludeFromPrinting": "",
      "header": "Notes",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 500
    },
    {
      "nameXml": "Quantity",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 4,
      "description": "Quantity",
      "excludeFromPrinting": "",
      "header": "Qt.",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 125
    },
    {
      "nameXml": "ReferenceUnit",
      "alignment": "center",
      "dataType": "text",
      "decimal": "",
      "description": "Reference unit",
      "excludeFromPrinting": "",
      "header": "Unit",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 100
    },
    {
      "nameXml": "UnitPrice",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 4,
      "description": "Unit price",
      "excludeFromPrinting": "",
      "header": "Unit/Price",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 125
    },
    {
      "nameXml": "FormulaBegin",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Formula begin",
      "excludeFromPrinting": "",
      "header": "Formula Begin",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 200
    },
    {
      "nameXml": "Formula",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Formula amount basic currency",
      "excludeFromPrinting": "",
      "header": "Formula",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 300
    },
    {
      "nameXml": "Income",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "",
      "excludeFromPrinting": "",
      "header": "Income",
      "header2": "CHF",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 220
    },
    {
      "nameXml": "Expenses",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "",
      "excludeFromPrinting": "",
      "header": "Expenses",
      "header2": "CHF",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 220
    },
    {
      "nameXml": "Account",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "Account",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 170
    },
    {
      "nameXml": "AccountDes",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Account Description",
      "excludeFromPrinting": "",
      "header": "Account Des.",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 300
    },
    {
      "nameXml": "Category",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "Category",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 170
    },
    {
      "nameXml": "CategoryDes",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Category Description",
      "excludeFromPrinting": "",
      "header": "Category Des.",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 300
    },
    {
      "nameXml": "AmountTotal",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "Total Amount",
      "excludeFromPrinting": "",
      "header": "Total",
      "header2": "CHF",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": "",
      "width": 250
    },
    {
      "nameXml": "VatCode",
      "alignment": "center",
      "dataType": "text",
      "decimal": "",
      "description": "VAT/Sales tax code",
      "excludeFromPrinting": "",
      "header": "VAT Code",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 100
    },
    {
      "nameXml": "VatAmountType",
      "alignment": "center",
      "dataType": "number",
      "decimal": "",
      "description": "Vat Amount Type",
      "excludeFromPrinting": "",
      "header": "Amount Type",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 150
    },
    {
      "nameXml": "VatExtraInfo",
      "alignment": "center",
      "dataType": "text",
      "decimal": "",
      "description": "VAT Extra Info",
      "excludeFromPrinting": "",
      "header": "Extra info",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 200
    },
    {
      "nameXml": "VatRate",
      "alignment": "right",
      "dataType": "number",
      "decimal": 2,
      "description": "VAT/Sales tax percentage",
      "excludeFromPrinting": "",
      "header": "%VAT",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": "",
      "width": 100
    },
    {
      "nameXml": "VatRateEffective",
      "alignment": "right",
      "dataType": "number",
      "decimal": 2,
      "description": "Effective VAT/Sales tax rate",
      "excludeFromPrinting": "",
      "header": "%Eff.",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 100
    },
    {
      "nameXml": "VatTaxable",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "Sales tax/VAT taxable amount",
      "excludeFromPrinting": "",
      "header": "Taxable",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 200
    },
    {
      "nameXml": "VatAmount",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "VAT/Sales tax amount",
      "excludeFromPrinting": "",
      "header": "Amt.VAT",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 200
    },
    {
      "nameXml": "VatAccount",
      "alignment": "center",
      "dataType": "text",
      "decimal": "",
      "description": "VAT/Sales tax account",
      "excludeFromPrinting": "",
      "header": "VAT A/C",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 150
    },
    {
      "nameXml": "VatAccountDes",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "VAT/Sales tax account description",
      "excludeFromPrinting": "",
      "header": "VAT A/C Des.",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 300
    },
    {
      "nameXml": "VatPercentNonDeductible",
      "alignment": "right",
      "dataType": "number",
      "decimal": 2,
      "description": "Percent non deductible",
      "excludeFromPrinting": "",
      "header": "%NonDed.",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 120
    },
    {
      "nameXml": "VatNonDeductible",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "Amount non deductible",
      "excludeFromPrinting": "",
      "header": "NonDed",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 200
    },
    {
      "nameXml": "VatPosted",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "VAT/Sales tax accountable",
      "excludeFromPrinting": "",
      "header": "VAT Acc",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": "",
      "width": 200
    },
    {
      "nameXml": "VatNumber",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "VAT/Sales tax number",
      "excludeFromPrinting": "",
      "header": "VAT Number",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 200
    },
    {
      "nameXml": "Cc1",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Cost center 1",
      "excludeFromPrinting": "",
      "header": "CC1",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 150
    },
    {
      "nameXml": "Cc1Des",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Description of cost center 1",
      "excludeFromPrinting": "",
      "header": "CC1 Description",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 300
    },
    {
      "nameXml": "Cc2",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Cost center 2",
      "excludeFromPrinting": "",
      "header": "CC2",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 150
    },
    {
      "nameXml": "Cc2Des",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Description of cost center 2",
      "excludeFromPrinting": "",
      "header": "CC2 Description",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 300
    },
    {
      "nameXml": "Cc3",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Cost center 3",
      "excludeFromPrinting": "",
      "header": "CC3",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 150
    },
    {
      "nameXml": "Cc3Des",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Description of cost center 3",
      "excludeFromPrinting": "",
      "header": "CC3 Description",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 300
    },
    {
      "nameXml": "Segment",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Segment",
      "excludeFromPrinting": "",
      "header": "Segment",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 150
    },
    {
      "nameXml": "DateExpiration",
      "alignment": "left",
      "dataType": "date",
      "decimal": "",
      "description": "Expiration date",
      "excludeFromPrinting": "",
      "header": "Date Exp.",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 200
    },
    {
      "nameXml": "DateExpected",
      "alignment": "right",
      "dataType": "date",
      "decimal": "",
      "description": "Date expected",
      "excludeFromPrinting": "",
      "header": "Expected",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 200
    },
    {
      "nameXml": "DatePayment",
      "alignment": "left",
      "dataType": "date",
      "decimal": "",
      "description": "Payment date",
      "excludeFromPrinting": "",
      "header": "Date Pay.",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 200
    }
  ]
}

VatCodes table

The VatCodes table is used to define all the parameters that allow to manage the procedures for registering with VAT.

All nameXml of the table columns are listed below:

  • SysCod
  • Links
    This column is used to indicate a link to an external file.
  • Section
  • Group
    This column is used to indicate the group to which the codes belong.
  • VatCode
    This column is used to indicate the VAT code.
  • Description
    This column is used to indicate the description of the VAT code or group.
  • Disable
    This column is used to disable VAT codes that are not used (1=VAT code is not visible in Transactions table but can be used; 2=VAT code is not visible in Transactions table and must not be used).
  • Gr
    This column is used to indicate the abbreviation or number of the Group in which the row of a code must be totaled.
  • Gr1
    This column is used to indicate specific groupings.
  • Gr2
    This column is used to indicate additional groupings.
  • IsDue
    This column is used to indicate when a VAT is a debit or a credit; Yes=VAT is debit (due to the State); empty=VAT is credit (recoverable).
  • AmountType
    This column is used to indicate how the program consider the transaction amount:
    • 0 (or empty cell) = with VAT/sales tax; the transaction amount is VAT included.
    • 1 = without VAT/Sales tax; the transaction amount is VAT excluded.
    • 2 = VAT amount; the transaction amount is considered the VAT amount at 100%.
  • VatRate
    This column is used to indicate the VAT percentage associated with the VAT code.
  • VatRateOnGross
    This column is used to indicate "Yes" if the VAT percentage has to be applied on the gross amount (VAT included) and not on the taxable amount.
  • VatPercentNonDeductible
    This column is used to indicate the non deductible percentage, in case it is not possible to deduct the full 100%.
  • VatAccount
    This column is used to indicate the account to which the broken down VAT automatically is posted.
  • RoundMin
    This column is used to indicate the minimum rounding value. When empty the basic accounting rounding is used.
  • NoWarning
    There are particular entries that the program might interpret as wrong, but which are in fact correct. To prevent the program from reporting error warnings, enter Yes to the code of interest.

VatCodes columns structure

The list of columns is shown below in JSON format, with also additional information for each column.

{
  "nameXml": "VatCodes",
  "columns": [
    {
      "nameXml": "SysCod",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "SysCod",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 100
    },
    {
      "nameXml": "Links",
      "alignment": "left",
      "dataType": "links",
      "decimal": "",
      "description": "Links to external documents",
      "excludeFromPrinting": "",
      "header": "Links",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 600
    },
    {
      "nameXml": "Section",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "Section",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 120
    },
    {
      "nameXml": "Group",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Group name",
      "excludeFromPrinting": "",
      "header": "Group",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 125
    },
    {
      "nameXml": "VatCode",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "VAT/Sales tax code",
      "excludeFromPrinting": "",
      "header": "VAT Code",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 125
    },
    {
      "nameXml": "Description",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "Description",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 700
    },
    {
      "nameXml": "Disable",
      "alignment": "right",
      "dataType": "number",
      "decimal": "",
      "description": "Disable vat code",
      "excludeFromPrinting": "",
      "header": "Disable",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 100
    },
    {
      "nameXml": "Gr",
      "alignment": "center",
      "dataType": "text",
      "decimal": "",
      "description": "Sum in the indicated Group",
      "excludeFromPrinting": "",
      "header": "Sum In",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 125
    },
    {
      "nameXml": "Gr1",
      "alignment": "center",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "Gr1",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 125
    },
    {
      "nameXml": "Gr2",
      "alignment": "center",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "Gr2",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 125
    },
    {
      "nameXml": "IsDue",
      "alignment": "center",
      "dataType": "bool",
      "decimal": "",
      "description": " Due VAT/Sales tax",
      "excludeFromPrinting": "",
      "header": "Due VAT",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 150
    },
    {
      "nameXml": "AmountType",
      "alignment": "center",
      "dataType": "number",
      "decimal": "",
      "description": "Vat Amount Type",
      "excludeFromPrinting": "",
      "header": "Amount type",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 150
    },
    {
      "nameXml": "VatRate",
      "alignment": "right",
      "dataType": "number",
      "decimal": 2,
      "description": "% VAT/Sales tax",
      "excludeFromPrinting": "",
      "header": "%VAT",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 150
    },
    {
      "nameXml": "VatRateOnGross",
      "alignment": "center",
      "dataType": "bool",
      "decimal": "",
      "description": " VAT/Sales tax percentage on gross amount",
      "excludeFromPrinting": "",
      "header": "VAT% on Gross",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 150
    },
    {
      "nameXml": "VatPercentNonDeductible",
      "alignment": "right",
      "dataType": "number",
      "decimal": 2,
      "description": "Percent non deductible",
      "excludeFromPrinting": "",
      "header": "%NonDed.",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 120
    },
    {
      "nameXml": "VatAccount",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "VAT/Sales tax account",
      "excludeFromPrinting": "",
      "header": "VAT account",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 200
    },
    {
      "nameXml": "RoundMin",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "Minimal amount rounding",
      "excludeFromPrinting": "",
      "header": "Round Min",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 200
    },
    {
      "nameXml": "NoWarning",
      "alignment": "center",
      "dataType": "bool",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "Don't warn",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 200
    }
  ]
}

Items table

The Items table is used to enter all the inventory items which need to be managed.

All nameXml of the table columns are listed below:

  • SysCod
  • Links
    This column is used to indicate the link to an external file. 
  • Section
  • Group
    This column is used to create a total row using the grouping system.
  • ItemsId
    This column is used to indicate the item identifier.
  • Description
    This column is used to indicate a text description of the item. 
  • Notes
    This column is used to indicate a personal note.
  • Gr
    This column is used to indicate the grouping for each item, specifying which totalization group it belongs to.
  • Disable
  • Account
    This column is linked with the Account/Category column of Accounts/Categories table. It is used to indicate the account used in the Transactions table.
  • VatCode
    This column is linked with the VatCode column of VatCodes table. It is used to indicate the VAT code to use.
  • ReferenceUnit
    This column is used to indicate an abbreviation to define the type to which the quantity refers.
  • SellingPrice
    This column is used to indicate the unit sale price.
  • Cost
    This column is used to indicate the unit cost price.
  • QuantityBegin
    This column is used to indicate the initial quantity amount of the item.
  • UnitPriceBegin
    This column is used to indicate the initial unit price of the item.
  • ValueBegin
    This column is used to indicate the initial quantity multiplied by Price Begin.
  • QuantityCurrent
    This column is used to indicate the current quantity.
  • UnitPriceCurrent
    This column is used to indicate the current price of the item.
  • ValueCurrent
    This column is used to indicate the current quantity multiplied by current price.

Items columns structure

The list of columns is shown below in JSON format, with also additional information for each column.

{
  "nameXml": "Items",
  "columns": [
    {
      "nameXml": "SysCod",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "SysCod",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 100
    },
    {
      "nameXml": "Links",
      "alignment": "left",
      "dataType": "links",
      "decimal": "",
      "description": "Links to external documents",
      "excludeFromPrinting": "",
      "header": "Links",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 600
    },
    {
      "nameXml": "Section",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "Section",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 120
    },
    {
      "nameXml": "Group",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": " Group name",
      "excludeFromPrinting": "",
      "header": " Group",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 100
    },
    {
      "nameXml": "ItemsId",
      "alignment": "right",
      "dataType": "text",
      "decimal": "",
      "description": "Items Id",
      "excludeFromPrinting": "",
      "header": "Item",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 150
    },
    {
      "nameXml": "Description",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "Description",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 600
    },
    {
      "nameXml": "Notes",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Notes",
      "excludeFromPrinting": "",
      "header": "Notes",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 600
    },
    {
      "nameXml": "Gr",
      "alignment": "center",
      "dataType": "text",
      "decimal": "",
      "description": "Sum in the indicated Group",
      "excludeFromPrinting": "",
      "header": "Sum In",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 125
    },
    {
      "nameXml": "Disable",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Disable account or group",
      "excludeFromPrinting": "",
      "header": "Disable",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 100
    },
    {
      "nameXml": "Account",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Account number",
      "excludeFromPrinting": "",
      "header": "Account",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 125
    },
    {
      "nameXml": "VatCode",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "VAT/Sales tax code",
      "excludeFromPrinting": "",
      "header": "VAT code",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 125
    },
    {
      "nameXml": "ReferenceUnit",
      "alignment": "center",
      "dataType": "text",
      "decimal": "",
      "description": "Reference unit",
      "excludeFromPrinting": "",
      "header": "Unit",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 100
    },
    {
      "nameXml": "SellingPrice",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 4,
      "description": "Selling price",
      "excludeFromPrinting": "",
      "header": "Selling",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 125
    },
    {
      "nameXml": "Cost",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 4,
      "description": "Product cost",
      "excludeFromPrinting": "",
      "header": "Cost",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 125
    },
    {
      "nameXml": "QuantityBegin",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 4,
      "description": "Begin quantity",
      "excludeFromPrinting": "",
      "header": "Begin Qt.",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 125
    },
    {
      "nameXml": "UnitPriceBegin",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 4,
      "description": "Begin unit price",
      "excludeFromPrinting": "",
      "header": "Price Begin",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 125
    },
    {
      "nameXml": "ValueBegin",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "Value begin",
      "excludeFromPrinting": "",
      "header": "Value Begin",
      "header2": "CHF",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 250
    },
    {
      "nameXml": "QuantityCurrent",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 4,
      "description": "Current quantity",
      "excludeFromPrinting": "",
      "header": "Current Qt.",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 125
    },
    {
      "nameXml": "UnitPriceCurrent",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 4,
      "description": "Current unit price",
      "excludeFromPrinting": "",
      "header": "Price Current",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 125
    },
    {
      "nameXml": "ValueCurrent",
      "alignment": "right",
      "dataType": "amount",
      "decimal": 2,
      "description": "Value current",
      "excludeFromPrinting": "",
      "header": "Value Current",
      "header2": "CHF",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 250
    }
  ]
}

Documents table

The Documents table is used to include attachments like images, logos, text documents, HTML texts, Markdown codes, CSS stylesheet codes and Javascript codes.

All nameXml of the table columns are listed below:

  • SysCod
  • Links
  • Section
  • RowId
    This column is used to indicate the identification of the row.
  • Description
    This column is used to indicate a description for the row.
  • Attachments
    This column is used to include an attachment.
  • ArchivedDate
  • ArchivedNotes

Documents columns structure

The list of columns is shown below in JSON format, with also additional information for each column.

{
  "nameXml": "Documents",
  "columns": [
    {
      "nameXml": "SysCod",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "SysCod",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 100
    },
    {
      "nameXml": "Links",
      "alignment": "left",
      "dataType": "links",
      "decimal": "",
      "description": "Links to external documents",
      "excludeFromPrinting": "",
      "header": "Links",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 600
    },
    {
      "nameXml": "Section",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "Section",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 120
    },
    {
      "nameXml": "RowId",
      "alignment": "center",
      "dataType": "text",
      "decimal": "",
      "description": "Row Id",
      "excludeFromPrinting": "",
      "header": "Id",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 400
    },
    {
      "nameXml": "Description",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "Description",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 600
    },
    {
      "nameXml": "Attachments",
      "alignment": "left",
      "dataType": "mime",
      "decimal": "",
      "description": "Attachments",
      "excludeFromPrinting": "",
      "header": "Attachments",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": true,
      "width": 600
    },
    {
      "nameXml": "ArchivedDate",
      "alignment": "right",
      "dataType": "date",
      "decimal": "",
      "description": "Archived date",
      "excludeFromPrinting": "",
      "header": "Arch.Date",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 200
    },
    {
      "nameXml": "ArchivedNotes",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "Archived notes",
      "excludeFromPrinting": "",
      "header": "Archived Notes",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 600
    }
  ]
}

FileInfo table

The FileInfo table is used by the program to store all the information about the currently open file.

All nameXml of the table columns are listed below:

  • SysCod
  • Links
  • Section
    This column is used to indicate the Group name of the values.
  • SectionText
  • Id
    This column is used to indicate the specific and explicit identification of the value.
  • Description
    This column is used to indicate explanation of the value.
  • Value
    This column is used to indicate the formatted value.
  • SectionXml
    This column is used to indicate the name of the section in English.
  • IdXml
    This column is used to indicate the identification in English.
  • ValueXml
    This column is used to indicate the field contents in Xml format.

The SectionXml and the IdXml identify the value unambiguously.

With Javascript extensions you can retrieve the ValueXml using the "Banana.document.info(SectionXml,IdXml)" API function.

FileInfo columns structure

The list of columns is shown below in JSON format, with also additional information for each column.

{
  "nameXml": "FileInfo",
  "columns": [
    {
      "nameXml": "SysCod",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "SysCod",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 100
    },
    {
      "nameXml": "Links",
      "alignment": "left",
      "dataType": "links",
      "decimal": "",
      "description": "Links to external documents",
      "excludeFromPrinting": "",
      "header": "Links",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 600
    },
    {
      "nameXml": "Section",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "Section",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": true,
      "width": 120
    },
    {
      "nameXml": "SectionText",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "Section",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 400
    },
    {
      "nameXml": "Id",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "Id",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 400
    },
    {
      "nameXml": "Description",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "Description",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": "",
      "width": 800
    },
    {
      "nameXml": "Value",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "Value",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": true,
      "editable": "",
      "width": 900
    },
    {
      "nameXml": "SectionXml",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "Section Xml",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 400
    },
    {
      "nameXml": "IdXml",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "ID Xml",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 400
    },
    {
      "nameXml": "ValueXml",
      "alignment": "left",
      "dataType": "text",
      "decimal": "",
      "description": "",
      "excludeFromPrinting": "",
      "header": "Value Xml",
      "header2": "",
      "style": {
        "objectName": "",
        "backgroundColor": "",
        "color": "",
        "fontSize": 10,
        "bold": false,
        "italic": false
      },
      "visible": "",
      "editable": "",
      "width": 400
    }
  ]
}

 

 

 

 

Help us improve the documentation

We welcome feedback on how to improve this page.

Tell us what theme needs a better explanation or how to clarify a topic.

Share this article: Twitter | Facebook | LinkedIn | Email