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 a proper nameXml. With the nameXml, tables and columns can be accessed to read the data they contain.
All columns of VatReport table are shown below with their nameXml.
VatReport table
The VatReport table is used by the program to display all transactions with VAT codes and calculate totals grouped by VAT code and rate.
- SysCod
- Links
- Section
- Date
- DateDocument
- DateValue
- Doc
- DocProtocol
- DocType
- DocOriginal
- DocInvoice
- InvoicePrinted
- DocLink
- ExternalReference
- ItemsId
- Description
- Notes
- AccountDebit
- AccountDebitDes
- AccountCredit
- AccountCreditDes
- Quantity
- ReferenceUnit
- UnitPrice
- Amount
- VatCode
- VatAmountType
- VatExtraInfo
- VatRate
- VatRateEffective
- VatTaxable
- VatAmount
- VatAccount
- VatAccountDes
- VatPercentNonDeductible
- VatNonDeductible
- VatPosted
- VatNumber
- Cc1
- Cc1Des
- Cc2
- Cc2Des
- Cc3
- Cc3Des
- Segment
- DateExpiration
- DateExpected
- DatePayment
- LockNumber
- LockAmount
- LockProgressive
- LockLine
- Group
- Gr
- VatRecoverable
- VatDue
- VatBalance
- Balance
VatReport columns structure
The list of columns is shown below in JSON format, with also additional information for each column.
{
"nameXml": "VatReport",
"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": "Collegamenti a documenti esterni",
"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": "Sezione",
"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": "Data",
"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": "Data del documento",
"excludeFromPrinting": "",
"header": "Data Doc",
"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": "Data valuta",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": true,
"width": 200
},
{
"nameXml": "Doc",
"alignment": "center",
"dataType": "text",
"decimal": "",
"description": "Documento",
"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": "Documento protocollo",
"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": "Tipo Documento",
"excludeFromPrinting": "",
"header": "Tipo",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": true,
"width": 100
},
{
"nameXml": "DocOriginal",
"alignment": "center",
"dataType": "text",
"decimal": "",
"description": "Documento originale",
"excludeFromPrinting": "",
"header": "Doc.Originale",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": true,
"width": 100
},
{
"nameXml": "DocInvoice",
"alignment": "center",
"dataType": "text",
"decimal": "",
"description": "Numero fattura",
"excludeFromPrinting": "",
"header": "Fattura",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": true,
"width": 150
},
{
"nameXml": "InvoicePrinted",
"alignment": "left",
"dataType": "text",
"decimal": "",
"description": "Fattura stampata",
"excludeFromPrinting": "",
"header": "Stampata",
"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 a file esterno",
"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": "Riferimento esterno",
"excludeFromPrinting": "",
"header": "Rif.Esterno",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": true,
"width": 100
},
{
"nameXml": "ItemsId",
"alignment": "right",
"dataType": "text",
"decimal": "",
"description": "Id Articolo",
"excludeFromPrinting": "",
"header": "Articolo",
"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": "Descrizione",
"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": "Annotazioni",
"excludeFromPrinting": "",
"header": "Note",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": true,
"width": 500
},
{
"nameXml": "AccountDebit",
"alignment": "left",
"dataType": "text",
"decimal": "",
"description": "Conto dare",
"excludeFromPrinting": "",
"header": "CtDare",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": true,
"width": 140
},
{
"nameXml": "AccountDebitDes",
"alignment": "left",
"dataType": "text",
"decimal": "",
"description": "",
"excludeFromPrinting": "",
"header": "CtDare Des.",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": "",
"width": 300
},
{
"nameXml": "AccountCredit",
"alignment": "left",
"dataType": "text",
"decimal": "",
"description": "Conto avere",
"excludeFromPrinting": "",
"header": "CtAvere",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": true,
"width": 140
},
{
"nameXml": "AccountCreditDes",
"alignment": "left",
"dataType": "text",
"decimal": "",
"description": "",
"excludeFromPrinting": "",
"header": "CtAvere Des.",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": "",
"width": 300
},
{
"nameXml": "Quantity",
"alignment": "right",
"dataType": "amount",
"decimal": 4,
"description": "Quantità",
"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": "Unità di riferimento",
"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": "Prezzo unitario",
"excludeFromPrinting": "",
"header": "Prezzo/Unità",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": true,
"width": 125
},
{
"nameXml": "Amount",
"alignment": "right",
"dataType": "amount",
"decimal": 2,
"description": "",
"excludeFromPrinting": "",
"header": "Importo",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": true,
"width": 220
},
{
"nameXml": "VatCode",
"alignment": "center",
"dataType": "text",
"decimal": "",
"description": "Codice IVA",
"excludeFromPrinting": "",
"header": "Cod. IVA",
"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": "Tipo importo IVA",
"excludeFromPrinting": "",
"header": "Tipo imp.",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": "",
"width": 150
},
{
"nameXml": "VatExtraInfo",
"alignment": "center",
"dataType": "text",
"decimal": "",
"description": "IVA informazioni supplementari",
"excludeFromPrinting": "",
"header": "Extra IVA",
"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": "Percentuale IVA",
"excludeFromPrinting": "",
"header": "%IVA",
"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": "Percentuale IVA effettiva",
"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": "Importo imponibile IVA",
"excludeFromPrinting": "",
"header": "Imponibile",
"header2": "CHF",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": true,
"editable": "",
"width": 200
},
{
"nameXml": "VatAmount",
"alignment": "right",
"dataType": "amount",
"decimal": 2,
"description": "Importo IVA",
"excludeFromPrinting": "",
"header": "Imp.IVA",
"header2": "CHF",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": "",
"width": 200
},
{
"nameXml": "VatAccount",
"alignment": "center",
"dataType": "text",
"decimal": "",
"description": "Conto IVA",
"excludeFromPrinting": "",
"header": "Cto.IVA",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": "",
"width": 150
},
{
"nameXml": "VatAccountDes",
"alignment": "left",
"dataType": "text",
"decimal": "",
"description": "Descrizione conto IVA",
"excludeFromPrinting": "",
"header": "Cto.IVA 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": "Percentuale non deducibile",
"excludeFromPrinting": "",
"header": "%Non.Ded.",
"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": "Importo non deducibile",
"excludeFromPrinting": "",
"header": "Non.Ded.",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": "",
"width": 200
},
{
"nameXml": "VatPosted",
"alignment": "right",
"dataType": "amount",
"decimal": 2,
"description": "IVA Contabile",
"excludeFromPrinting": "",
"header": "IVA Contab.",
"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": "",
"excludeFromPrinting": "",
"header": "Partita IVA",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": true,
"width": 200
},
{
"nameXml": "Cc1",
"alignment": "left",
"dataType": "text",
"decimal": "",
"description": "Centro di costo 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": "Descrizione del centro di costo 1",
"excludeFromPrinting": "",
"header": "CC1 descrizione",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": "",
"width": 300
},
{
"nameXml": "Cc2",
"alignment": "left",
"dataType": "text",
"decimal": "",
"description": "Centro di costo 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": "Descrizione del centro di costo 2",
"excludeFromPrinting": "",
"header": "CC2 descrizione",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": "",
"width": 300
},
{
"nameXml": "Cc3",
"alignment": "left",
"dataType": "text",
"decimal": "",
"description": "Centro di Costo 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": "Descrizione del centro di costo 3",
"excludeFromPrinting": "",
"header": "CC3 descrizione",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": "",
"width": 300
},
{
"nameXml": "Segment",
"alignment": "left",
"dataType": "text",
"decimal": "",
"description": "Segmento",
"excludeFromPrinting": "",
"header": "Segmento",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": true,
"width": 150
},
{
"nameXml": "DateExpiration",
"alignment": "left",
"dataType": "date",
"decimal": "",
"description": "Data scadenza",
"excludeFromPrinting": "",
"header": "Scadenza",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": true,
"width": 200
},
{
"nameXml": "DateExpected",
"alignment": "right",
"dataType": "date",
"decimal": "",
"description": "Data prevista",
"excludeFromPrinting": "",
"header": "Prevista",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": true,
"width": 200
},
{
"nameXml": "DatePayment",
"alignment": "left",
"dataType": "date",
"decimal": "",
"description": "Data pagamento",
"excludeFromPrinting": "",
"header": "Pagamento",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": true,
"width": 200
},
{
"nameXml": "LockNumber",
"alignment": "center",
"dataType": "text",
"decimal": "",
"description": "Numero blocco",
"excludeFromPrinting": "",
"header": "BloccoNum",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": "",
"width": 100
},
{
"nameXml": "LockAmount",
"alignment": "right",
"dataType": "amount",
"decimal": 2,
"description": "Importo blocco",
"excludeFromPrinting": "",
"header": "BloccoImp",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": "",
"width": 200
},
{
"nameXml": "LockProgressive",
"alignment": "left",
"dataType": "text",
"decimal": "",
"description": "Progressivo blocco",
"excludeFromPrinting": "",
"header": "BloccoProgr",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": "",
"width": 380
},
{
"nameXml": "LockLine",
"alignment": "left",
"dataType": "text",
"decimal": "",
"description": "Blocco linea",
"excludeFromPrinting": "",
"header": "BloccoLinea",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": "",
"width": 150
},
{
"nameXml": "Group",
"alignment": "left",
"dataType": "text",
"decimal": "",
"description": "Nome gruppo",
"excludeFromPrinting": "",
"header": "Gruppo",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": true,
"editable": "",
"width": 244
},
{
"nameXml": "Gr",
"alignment": "left",
"dataType": "text",
"decimal": "",
"description": "Somma nel Gruppo indicato",
"excludeFromPrinting": "",
"header": "Somma in",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": true,
"editable": "",
"width": 267
},
{
"nameXml": "VatRecoverable",
"alignment": "right",
"dataType": "amount",
"decimal": 2,
"description": "Importo IVA recuperabile",
"excludeFromPrinting": "",
"header": "Recupero",
"header2": "CHF",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": true,
"editable": "",
"width": 220
},
{
"nameXml": "VatDue",
"alignment": "right",
"dataType": "amount",
"decimal": 2,
"description": "Importo IVA dovuto",
"excludeFromPrinting": "",
"header": "Dovuto",
"header2": "CHF",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": true,
"editable": "",
"width": 220
},
{
"nameXml": "VatBalance",
"alignment": "right",
"dataType": "amount",
"decimal": 2,
"description": "",
"excludeFromPrinting": "",
"header": "Saldo",
"header2": "CHF",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": true,
"editable": "",
"width": 220
},
{
"nameXml": "Balance",
"alignment": "right",
"dataType": "amount",
"decimal": 2,
"description": "",
"excludeFromPrinting": "",
"header": "Saldo",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": "",
"width": 220
}
]
}