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

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

All columns of Documents table are shown below with their nameXml.

Documents table

The Documents table is used to include attachments like images, logos, text documents, HTML codes, Markdown codes, CSS stylesheet codes and Javascript Extensions 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
    }
  ]
}

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

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

All columns of FileInfo table are shown below with their nameXml.

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
    }
  ]
}

FileInfo table for a double-entry accounting

The following is an example of the FileInfo table for a double-entry accounting data with some values in it.

• In the first row there are the names Xml of the columns.
• In the next rows there are all the data saved in the table.

The same table exists for all the accounting file types. What changes from one type of accounting to another is the data the table contains.

The SectionXml and the IdXml columns identify the value unambiguously.

With Javascript extensions you can retrieve the value of ValueXml column using the JavaScript API function "Banana.document.info(SectionXml,IdXml)". The function returns the info value of the document referenced by SectionXml and IdXml.

Some examples:

// Get some value of the accounting file 
var FileName = Banana.document.info("Base","FileName");
var DecimalsAmounts = Banana.document.info("Base","DecimalsAmounts");
var HeaderLeft = Banana.document.info("Base","HeaderLeft");
var HeaderRight = Banana.document.info("Base","HeaderRight");
var BasicCurrency = Banana.document.info("AccountingDataBase","BasicCurrency");

// For openingDate and closureDate use instead startDate and endDate
var openingDate = Banana.document.info("AccountingDataBase","OpeningDate");
var closureDate = Banana.document.info("AccountingDataBase","ClosureDate");

// For file accounting type
var FileType = Banana.document.info("Base","FileType");
var FileGroup = Banana.document.info("Base","FileTypeGroup");
var FileNumber = Banana.document.info("Base","FileTypeNumber");

// For customer settings
var customersGroup = Banana.document.info("AccountingDataBase","CustomersGroup");
var suppliersGroup = Banana.document.info("AccountingDataBase","SuppliersGroup");

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

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

All columns of Items table are shown below with their nameXml.

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 column of Accounts 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.

For the multy-currency accounting file type, there are additional columns for the Items table. The nameXml of the additional columns are listed below:

• Currency
• ValueBeginCurrency
• ExchangeBegin
• CurrencyCurrentValue
• ExchangeCurrent

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
    }
  ]
}

For the multy-currency accounting file type, there are additional columns.

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

{
  "nameXml": "Currency",
  "alignment": "left",
  "dataType": "text",
  "decimal": "",
  "description": "Currency",
  "excludeFromPrinting": "",
  "header": "Currency",
  "header2": "",
  "style": {
    "objectName": "",
    "backgroundColor": "",
    "color": "",
    "fontSize": 10,
    "bold": false,
    "italic": false
  },
  "visible": true,
  "editable": true,
  "width": 268
},
{
  "nameXml": "ValueBeginCurrency",
  "alignment": "right",
  "dataType": "amount",
  "decimal": 2,
  "description": "Value begin currecy",
  "excludeFromPrinting": "",
  "header": "V. begin currency",
  "header2": "",
  "style": {
    "objectName": "",
    "backgroundColor": "",
    "color": "",
    "fontSize": 10,
    "bold": false,
    "italic": false
  },
  "visible": "",
  "editable": "",
  "width": 250
},
{
  "nameXml": "ExchangeBegin",
  "alignment": "right",
  "dataType": "number",
  "decimal": 12,
  "description": "Exchange begin",
  "excludeFromPrinting": "",
  "header": "Exch. begin",
  "header2": "",
  "style": {
    "objectName": "",
    "backgroundColor": "",
    "color": "",
    "fontSize": 10,
    "bold": false,
    "italic": false
  },
  "visible": "",
  "editable": true,
  "width": 250
},
{
  "nameXml": "CurrencyCurrentValue",
  "alignment": "right",
  "dataType": "amount",
  "decimal": 2,
  "description": "Currency current value",
  "excludeFromPrinting": "",
  "header": "Currency V.",
  "header2": "",
  "style": {
    "objectName": "",
    "backgroundColor": "",
    "color": "",
    "fontSize": 10,
    "bold": false,
    "italic": false
  },
  "visible": true,
  "editable": "",
  "width": 250
},
{
  "nameXml": "ExchangeCurrent",
  "alignment": "right",
  "dataType": "number",
  "decimal": 12,
  "description": "Exchange current",
  "excludeFromPrinting": "",
  "header": "Exchange",
  "header2": "",
  "style": {
    "objectName": "",
    "backgroundColor": "",
    "color": "",
    "fontSize": 10,
    "bold": false,
    "italic": false
  },
  "visible": "",
  "editable": true,
  "width": 250
}