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 tables and columns are shown below with their nameXml.
Double-entry accounting tables
These are the nameXml of all the tables for a double-entry accounting file:
- Accounts.
The nameXml for the Accounts table that is used to set up the chart of accounts 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. - Totals.
The nameXml for the Totals table that presents the totals by Group and is used to check the accounting balance. - 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 chart of accounts of the accounting. There are several types of accounts:
- Normal accounts.
- Segments (accounts that begin with ":").
- Cost Centers (accounts 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 (assets and liabilities for balance sheet, expenses and revenues for income statement).
This subdivision into sections allows to choose whether to print the entire balance sheet and income statement, or choose which sections to print (e.g. only the balance sheet, or just a group, excluding the other components from printing).
The coding used in Section column is the following:* Title1 the asterisk separates the sections and indicates the main headers ** Title 2 to be entered for the secondary headers 1 Assets to be entered in the row of the Assets title 2 Liabilities to be entered in the row of the Liabilities title 3 Expenses to be entered in the row of the Expenses title 4 Revenue to be entered in the row of the Revenue title 01 Customers register to be entered in the row of the Customers Register title 02 Suppliers register to be entered in the row of the Suppliers Register title 03 Cost Centers to be entered in the row of the Cost Centers title 04 Profit Centers to be entered in the row of the Profit Centers title # Notes to be entered in the row of the Notes title #X Hidden data to be entered in the row from whereon the data have to be hidden - 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, cost centers and segments.
Can be numbers or texts.
So within the Account column there are different account type:- Debit and Credit Accounts
Are used in AccountDebit and AccountCredit columns of the Transactions table. - CC1 Cost centers begin with ".", example ".P1" .
Used in the Cc1 column of the Transactions table. - CC2 Cost centers begin with ",", example ",P1".
Used in the Cc2 column of the Transactions table. - CC3 Cost centers begin with ";", example ";P1".
Used in the column Cc3 of the Transactions table. - Segments begin with ":".
There can be 10 levels of segments.
Level 1 begin with ":" , example ":S1".
Level 2 begin with "::" , example "::S1".
Level 3 begin with ":::" , example ":::S1".
Level 4 begin with "::::" , example "::::S1".
Level 5 begin with ":::::" , example ":::::S1".
Level 6 begin with "::::::" , example "::::::S1".
Level 7 begin with ":::::::" , example ":::::::S1".
Level 8 begin with "::::::::" , example "::::::::S1".
Level 9 begin with ":::::::::" , example ":::::::::S1".
Level 10 begin with"::::::::::" , example "::::::::::S1".
- Debit and Credit Accounts
- 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 debit A/c or credit A/c 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. - BClass
This column is used to indicate the type of account: 1=assets; 2=liabilities; 3=expenses; 4=income.
Only accounts have a BClass. Groups and subgroups do not have BClass. - Gr
This column is used to indicate the grouping for each account or group row, specifying which totalization group it belongs to.
The content must be a value defined in the column Group. See below Grouping. - Gr1
This column is used to indicate additional grouping codes. - Gr2
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.
Credit amounts are entered with negative sign. - Debit
This column is used by the program to sum debit movements using the entries in the Transactions table.
The column is read only. - Credit
This column is used to indicate the credit movements included in the Transactions table.
The column is read only. - Balance
This column is used to indicate the balance of the account which includes the opening balance and the movements in debit and credit.
The balance in debit is positive, while a credit balance is negative.
The column is read only. - Budget
This column is used to enter the budget amount for the current period.
The budgeted amount for costs (debit) must be entered in positive, for revenue in negative (credit).
If the Budget table has been activated, the Budget column in the Accounts table is read only and 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.
The column is read only. - 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.
The column is read only. - 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.
The column is read only. - PeriodDebit
This column is used to indicate the total debit in the period.
The column is read only. - PeriodCredit
This column is used to indicate the total debit in the period.
The column is read only. - PeriodTotal
This column is used to indicate the total movements in the period.
The column is read only. - PeriodEnd
This column is used to indicate the balance at end of the period.
The column is read only. - 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": 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": 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": "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": "left",
"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": "BClass",
"alignment": "center",
"dataType": "text",
"decimal": "",
"description": "Base class",
"excludeFromPrinting": "",
"header": "BClass",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": true,
"editable": true,
"width": 120
},
{
"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": "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": 120
},
{
"nameXml": "Opening",
"alignment": "right",
"dataType": "amount",
"decimal": 2,
"description": "Opening balance",
"excludeFromPrinting": "",
"header": "Opening",
"header2": "CHF",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": true,
"editable": true,
"width": 250
},
{
"nameXml": "Debit",
"alignment": "right",
"dataType": "amount",
"decimal": 2,
"description": "Total debit transactions",
"excludeFromPrinting": "",
"header": "Debit",
"header2": "CHF",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": "",
"width": 250
},
{
"nameXml": "Credit",
"alignment": "right",
"dataType": "amount",
"decimal": 2,
"description": "Total credit transactions",
"excludeFromPrinting": "",
"header": "Credit",
"header2": "CHF",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": "",
"width": 250
},
{
"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": 250
},
{
"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": "",
"editable": "",
"width": 250
},
{
"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": 250
},
{
"nameXml": "Prior",
"alignment": "right",
"dataType": "amount",
"decimal": 2,
"description": "Balance from previous year",
"excludeFromPrinting": "",
"header": "Prev. Year",
"header2": "CHF",
"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": "CHF",
"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": "CHF",
"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": "PeriodDebit",
"alignment": "right",
"dataType": "amount",
"decimal": 2,
"description": "Total debit for period",
"excludeFromPrinting": "",
"header": "Debit Per.",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": "",
"width": 250
},
{
"nameXml": "PeriodCredit",
"alignment": "right",
"dataType": "amount",
"decimal": 2,
"description": "Total credit for period",
"excludeFromPrinting": "",
"header": "Credit 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
}
]
}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. - AccountDebit
This column is linked with the Account column of the Accounts table.
This column is used to indicate the account present in the Accounts table that will be charged.
Segments can be entered after the account using the ":" or "-" separator. - AccountDebitDes
This column is linked with the Description column of the Accounts table.
This column is used to indicate the description of the debit account present in the Accounts table. - AccountCredit
This column is linked with the Account column of the Accounts table.
This column is used to indicate the account present in the Accounts table that will be credited. - AccountCreditDes
This column is linked with the Description column of the Accounts table.
This column is used to indicate the description of the credit account present in the Accounts table. - 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. - Amount
This column is used to indicate the amount of the transaction. - Balance
This column is used to indicate the sum of debit and credit. - 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 table. It is used to indicate the code or VAT number of a client/supplier. - Cc1
This column is linked with the Account column of Accounts table. It is used to indicate the cost center account that in Accounts table is preceded by "." In Cc1 column of Transactions table the cost center account is entered without "." - Cc1Des
This column is linked with the Description column of Accounts table. It used to indicate the description of the cost center account preceded by "." - Cc2
This column is linked with the Account column of Accounts table. It is used to indicate the cost center account that in Accounts table is preceded by "," In Cc2 column of Transactions table the cost center account is entered without "," - Cc2Des
This column is linked with the Description column of Accounts table. It used to indicate the description of the cost center account preceded by "," - Cc3
This column is linked with the Account column of Accounts table. It is used to indicate the cost center account that in Accounts table is preceded by ";" In Cc3 column of Transactions table the cost center account is entered without ";" - Cc3Des
This column is linked with the Description column of Accounts table. It used to indicate the description of the cost center account 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": "AccountDebit",
"alignment": "left",
"dataType": "text",
"decimal": "",
"description": "Debit account",
"excludeFromPrinting": "",
"header": "Debit A/C ",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": true,
"editable": true,
"width": 140
},
{
"nameXml": "AccountDebitDes",
"alignment": "left",
"dataType": "text",
"decimal": "",
"description": "",
"excludeFromPrinting": "",
"header": "Debit A/C Des.",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": "",
"width": 300
},
{
"nameXml": "AccountCredit",
"alignment": "left",
"dataType": "text",
"decimal": "",
"description": "Credit account",
"excludeFromPrinting": "",
"header": "Credit A/C ",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": true,
"editable": true,
"width": 140
},
{
"nameXml": "AccountCreditDes",
"alignment": "left",
"dataType": "text",
"decimal": "",
"description": "",
"excludeFromPrinting": "",
"header": "Credit A/C 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": "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": "Amount",
"alignment": "right",
"dataType": "amount",
"decimal": 2,
"description": "",
"excludeFromPrinting": "",
"header": "Amount",
"header2": "CHF",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": true,
"editable": true,
"width": 220
},
{
"nameXml": "Balance",
"alignment": "right",
"dataType": "amount",
"decimal": 2,
"description": "",
"excludeFromPrinting": "",
"header": "Balance",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": "",
"width": 220
},
{
"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
- AccountDebit
- AccountDebitDes
- AccountCredit
- AccountCreditDes
- Quantity
- ReferenceUnit
- UnitPrice
- Formula
This column is used to enter calculation formulas in javascript, or programming functions of the Banana Accounting Extensions. - Amount
- 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": "AccountDebit",
"alignment": "left",
"dataType": "text",
"decimal": "",
"description": "Debit account",
"excludeFromPrinting": "",
"header": "Debit A/C ",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": true,
"editable": true,
"width": 140
},
{
"nameXml": "AccountDebitDes",
"alignment": "left",
"dataType": "text",
"decimal": "",
"description": "",
"excludeFromPrinting": "",
"header": "Debit A/C Des.",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": "",
"width": 300
},
{
"nameXml": "AccountCredit",
"alignment": "left",
"dataType": "text",
"decimal": "",
"description": "Credit account",
"excludeFromPrinting": "",
"header": "Credit A/C ",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": true,
"editable": true,
"width": 140
},
{
"nameXml": "AccountCreditDes",
"alignment": "left",
"dataType": "text",
"decimal": "",
"description": "",
"excludeFromPrinting": "",
"header": "Credit A/C 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": "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": "Formula",
"alignment": "left",
"dataType": "text",
"decimal": "",
"description": "Formula amount basic currency",
"excludeFromPrinting": "",
"header": "Formula",
"header2": "CHF",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": true,
"width": 300
},
{
"nameXml": "Amount",
"alignment": "right",
"dataType": "amount",
"decimal": 2,
"description": "",
"excludeFromPrinting": "",
"header": "Amount",
"header2": "CHF",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": true,
"editable": true,
"width": 220
},
{
"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
}
]
}Totals table
The Totals table presents the totals by Group and is used to check the accounting balance. It is processed automatically by the program and it is read only, cannot be modified.
All nameXml of the table columns are listed below:
- SysCod
- Links
- Section
- Group
This column is used to indicate the main groups of Accounts table. - Description
This column is used to indicate the main groups description of Accounts table. - Gr
This column is used to indicate the grouping for each group, specifying which totalization group it belongs to. - Opening
This column is used to indicate the total opening amount of the group. - Balance
This column is used to indicate the total balance amount of the group. - ReportTotalsOnly
- ReportKeepRows
- ReportWithMovements
Totals columns structure
The list of columns is shown below in JSON format, with also additional information for each column.
{
"nameXml": "Totals",
"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": "",
"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": 800
},
{
"nameXml": "Gr",
"alignment": "center",
"dataType": "text",
"decimal": "",
"description": "",
"excludeFromPrinting": "",
"header": "Gr",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": true,
"editable": "",
"width": 100
},
{
"nameXml": "Opening",
"alignment": "right",
"dataType": "amount",
"decimal": 2,
"description": "Opening balance",
"excludeFromPrinting": "",
"header": "Opening",
"header2": "CHF",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": true,
"editable": "",
"width": 250
},
{
"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": true,
"editable": "",
"width": 250
},
{
"nameXml": "ReportTotalsOnly",
"alignment": "center",
"dataType": "bool",
"decimal": "",
"description": "Only print totals",
"excludeFromPrinting": "",
"header": "Tot",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": true,
"width": 200
},
{
"nameXml": "ReportKeepRows",
"alignment": "center",
"dataType": "bool",
"decimal": "",
"description": "Keep rows",
"excludeFromPrinting": "",
"header": "Keep",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": true,
"width": 200
},
{
"nameXml": "ReportWithMovements",
"alignment": "center",
"dataType": "bool",
"decimal": "",
"description": "with movements",
"excludeFromPrinting": "",
"header": "With mov.",
"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 a common table used for all accounting file types. This table is used to enter all the inventory items which need to be managed.
Documents table
The Documents table is a common table used for all accounting file types. This table is used to include attachments like images, logos, text documents, HTML codes, Markdown codes, CSS stylesheet codes and Javascript Extensions codes.
FileInfo table
The FileInfo table is a common table used for all accounting file types. In this table the program stores all the information about the currently open file.