FileInfo table columns structure

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");