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.
Multi-currency accounting tables
These are the nameXml of all the tables for a Multi-currency 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. - ExchangeRates.
The nameXml for the ExchangeRates table that is used to enter the exchange rates referred to the basic currency (accounting currency) for the foreign currencies. - 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. - AccountExchangeDifference
- 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. - Gr1
This column is used to indicate additional grouping codes. - Gr2
This column is used to indicate additional grouping codes. - Currency
- OpeningCurrency
- 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 to indicate the debit movements included 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. - DebitCurrency
- CreditCurrency
- BalanceCurrency
- 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. - BalanceCalculated
- ExchangeDifference
- OpeningCurrency2
- DebitCurrency2
- CreditCurrency2
- BalanceCurrency2
- BalanceCalculatedCurrency2
- 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 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": 270
},
{
"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": 625
},
{
"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": 569
},
{
"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": "AccountExchangeDifference",
"alignment": "left",
"dataType": "text",
"decimal": "",
"description": "Exchange rate difference account",
"excludeFromPrinting": "",
"header": "Exch. rate Diff. Acct.",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": true,
"width": 250
},
{
"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": 250
},
{
"nameXml": "Gr",
"alignment": "center",
"dataType": "text",
"decimal": "",
"description": "Sum in the indicated Group",
"excludeFromPrinting": "",
"header": "Sum In",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": true,
"editable": true,
"width": 279
},
{
"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": "Currency",
"alignment": "center",
"dataType": "text",
"decimal": "",
"description": "",
"excludeFromPrinting": "",
"header": "Currency",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": true,
"editable": true,
"width": 268
},
{
"nameXml": "OpeningCurrency",
"alignment": "right",
"dataType": "amount",
"decimal": 2,
"description": "",
"excludeFromPrinting": "",
"header": "Opening currency",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": true,
"editable": true,
"width": 250
},
{
"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": "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": "DebitCurrency",
"alignment": "right",
"dataType": "amount",
"decimal": 2,
"description": "",
"excludeFromPrinting": "",
"header": "Debit currency",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": "",
"width": 250
},
{
"nameXml": "CreditCurrency",
"alignment": "right",
"dataType": "amount",
"decimal": 2,
"description": "",
"excludeFromPrinting": "",
"header": "Credit currency",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": "",
"width": 250
},
{
"nameXml": "BalanceCurrency",
"alignment": "right",
"dataType": "amount",
"decimal": 2,
"description": "",
"excludeFromPrinting": "",
"header": "Balance currency",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": true,
"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": "BalanceCalculated",
"alignment": "right",
"dataType": "amount",
"decimal": 2,
"description": "",
"excludeFromPrinting": "",
"header": "Calculated balance",
"header2": "CHF",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": "",
"width": 250
},
{
"nameXml": "ExchangeDifference",
"alignment": "right",
"dataType": "amount",
"decimal": 2,
"description": "",
"excludeFromPrinting": "",
"header": "Exchange rate difference",
"header2": "CHF",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": "",
"width": 250
},
{
"nameXml": "OpeningCurrency2",
"alignment": "right",
"dataType": "amount",
"decimal": 2,
"description": "",
"excludeFromPrinting": "",
"header": "Opening",
"header2": "Currency 2",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": "",
"width": 250
},
{
"nameXml": "DebitCurrency2",
"alignment": "right",
"dataType": "amount",
"decimal": 2,
"description": "",
"excludeFromPrinting": "",
"header": "Debit",
"header2": "Currency 2",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": "",
"width": 250
},
{
"nameXml": "CreditCurrency2",
"alignment": "right",
"dataType": "amount",
"decimal": 2,
"description": "",
"excludeFromPrinting": "",
"header": "Credit",
"header2": "Currency 2",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": "",
"width": 250
},
{
"nameXml": "BalanceCurrency2",
"alignment": "right",
"dataType": "amount",
"decimal": 2,
"description": "",
"excludeFromPrinting": "",
"header": "Balance",
"header2": "Currency 2",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": "",
"width": 250
},
{
"nameXml": "BalanceCalculatedCurrency2",
"alignment": "right",
"dataType": "amount",
"decimal": 2,
"description": "",
"excludeFromPrinting": "",
"header": "Calclulated balance",
"header2": "Currency 2",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"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 or Company 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": "Language",
"alignment": "center",
"dataType": "text",
"decimal": "",
"description": "Language",
"excludeFromPrinting": "",
"header": "Language",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": true,
"width": 250
},
{
"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
- DateDocument
- DateValue
- Doc
- DocProtocol
- DocType
- DocOriginal
- DocInvoice
- InvoicePrinted
- DocLink
- ExternalReference
- ItemsId
- Description
- Notes
- AccountDebit
- AccountDebitDes
- AccountCredit
- AccountCreditDes
- Quantity
- ReferenceUnit
- UnitPrice
- AmountCurrency
- ExchangeCurrency
- ExchangeRate
- ExchangeMultiplier
- Amount
- Balance
- 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
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": 100
},
{
"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": "left",
"dataType": "text",
"decimal": "",
"description": "Items Id",
"excludeFromPrinting": "",
"header": "Item",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": true,
"editable": true,
"width": 308
},
{
"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": 880
},
{
"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": 441
},
{
"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": 526
},
{
"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": 178
},
{
"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": true,
"editable": true,
"width": 174
},
{
"nameXml": "AmountCurrency",
"alignment": "right",
"dataType": "amount",
"decimal": 2,
"description": "Amount in currency",
"excludeFromPrinting": "",
"header": "Currency Amount",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": true,
"editable": true,
"width": 311
},
{
"nameXml": "ExchangeCurrency",
"alignment": "center",
"dataType": "text",
"decimal": "",
"description": "",
"excludeFromPrinting": "",
"header": "Currency",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": true,
"editable": true,
"width": 276
},
{
"nameXml": "ExchangeRate",
"alignment": "right",
"dataType": "number",
"decimal": 12,
"description": "",
"excludeFromPrinting": "",
"header": "Exchange Rate",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": true,
"editable": true,
"width": 220
},
{
"nameXml": "ExchangeMultiplier",
"alignment": "right",
"dataType": "number",
"decimal": 12,
"description": "Multiplier",
"excludeFromPrinting": "",
"header": "Mult.",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": "",
"width": 200
},
{
"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": true,
"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": 152
},
{
"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": "",
"editable": true,
"width": 242
},
{
"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": 194
},
{
"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": "",
"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 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
- DateEnd
- Repeat
- Variant
- ForNewYear
- DateDocument
- DateValue
- Doc
- DocProtocol
- DocType
- DocOriginal
- DocInvoice
- InvoicePrinted
- DocLink
- ExternalReference
- ItemsId
- Description
- Notes
- AccountDebit
- AccountDebitDes
- AccountCredit
- AccountCreditDes
- Quantity
- ReferenceUnit
- UnitPrice
- FormulaBegin
- FormulaCurrency
- AmountCurrency
- ExchangeCurrency
- ExchangeRate
- ExchangeMultiplier
- Formula
- Amount
- AmountTotalCurrency
- 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": "FormulaBegin",
"alignment": "left",
"dataType": "text",
"decimal": "",
"description": "Formula begin",
"excludeFromPrinting": "",
"header": "Formula Begin",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": true,
"width": 150
},
{
"nameXml": "FormulaCurrency",
"alignment": "left",
"dataType": "text",
"decimal": "",
"description": "Formula amount transaction's currency",
"excludeFromPrinting": "",
"header": "Formula Currency",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": true,
"width": 300
},
{
"nameXml": "AmountCurrency",
"alignment": "right",
"dataType": "amount",
"decimal": 2,
"description": "Amount in Currency",
"excludeFromPrinting": "",
"header": "Currency Amount",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": true,
"editable": true,
"width": 220
},
{
"nameXml": "ExchangeCurrency",
"alignment": "center",
"dataType": "text",
"decimal": "",
"description": "",
"excludeFromPrinting": "",
"header": "Currency",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": true,
"editable": true,
"width": 100
},
{
"nameXml": "ExchangeRate",
"alignment": "right",
"dataType": "number",
"decimal": 12,
"description": "",
"excludeFromPrinting": "",
"header": "Exchange Rate",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": true,
"editable": true,
"width": 220
},
{
"nameXml": "ExchangeMultiplier",
"alignment": "right",
"dataType": "number",
"decimal": 12,
"description": "Multiplier",
"excludeFromPrinting": "",
"header": "Mult.",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": "",
"width": 200
},
{
"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": "AmountTotalCurrency",
"alignment": "right",
"dataType": "amount",
"decimal": 2,
"description": "Total Currency Amount",
"excludeFromPrinting": "",
"header": "Currency Total",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": true,
"editable": "",
"width": 250
},
{
"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": "Sum in the indicated Group",
"excludeFromPrinting": "",
"header": "Sum In",
"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
- Section
- Group
- VatCode
- Description
- Disable
- Gr
- Gr1
- Gr2
- IsDue
- AmountType
- VatRate
- VatRateOnGross
- VatPercentNonDeductible
- VatAccount
- RoundMin
- NoWarning
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": "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
}
]
}ExchangeRates table
The ExchangeRates table is used to enter the exchange rates referred to the basic currency (accounting currency) for the foreign currencies.
All nameXml of the table columns are listed below:
- SysCod
- Links
- Section
- Date
- CurrencyReference
- Currency
- Description
- IsFixed
- Rounding
- Multiplier
- Rate
- RateOpening
- RateMin
- RateMax
- DecimalPoints
- Country
ExchangeRates column structure
The list of columns is shown below in JSON format, with also additional information for each column.
{
"nameXml": "ExchangeRates",
"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": "Date",
"alignment": "left",
"dataType": "date",
"decimal": "",
"description": "",
"excludeFromPrinting": "",
"header": "Date",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": true,
"width": 200
},
{
"nameXml": "CurrencyReference",
"alignment": "center",
"dataType": "text",
"decimal": "",
"description": "Reference Currency",
"excludeFromPrinting": "",
"header": "Ref.Currency",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": true,
"editable": true,
"width": 200
},
{
"nameXml": "Currency",
"alignment": "center",
"dataType": "text",
"decimal": "",
"description": "",
"excludeFromPrinting": "",
"header": "Currency",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": true,
"editable": true,
"width": 200
},
{
"nameXml": "Description",
"alignment": "left",
"dataType": "text",
"decimal": "",
"description": "",
"excludeFromPrinting": "",
"header": "Text",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": true,
"editable": true,
"width": 500
},
{
"nameXml": "IsFixed",
"alignment": "center",
"dataType": "bool",
"decimal": "",
"description": "Is fixed",
"excludeFromPrinting": "",
"header": "Fixed",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": true,
"width": 100
},
{
"nameXml": "Rounding",
"alignment": "right",
"dataType": "number",
"decimal": 12,
"description": "",
"excludeFromPrinting": "",
"header": "Rounding",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": true,
"width": 200
},
{
"nameXml": "Multiplier",
"alignment": "right",
"dataType": "number",
"decimal": 12,
"description": "Multiplier",
"excludeFromPrinting": "",
"header": "Mult.",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": true,
"editable": true,
"width": 200
},
{
"nameXml": "Rate",
"alignment": "right",
"dataType": "number",
"decimal": 12,
"description": "",
"excludeFromPrinting": "",
"header": "Exchange rate",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": true,
"editable": true,
"width": 200
},
{
"nameXml": "RateOpening",
"alignment": "right",
"dataType": "number",
"decimal": 12,
"description": "Opening exchange rate",
"excludeFromPrinting": "",
"header": "Rate Opening",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": true,
"editable": true,
"width": 200
},
{
"nameXml": "RateMin",
"alignment": "right",
"dataType": "number",
"decimal": 12,
"description": "",
"excludeFromPrinting": "",
"header": "Min",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": true,
"width": 200
},
{
"nameXml": "RateMax",
"alignment": "right",
"dataType": "number",
"decimal": 12,
"description": "",
"excludeFromPrinting": "",
"header": "Max",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": true,
"width": 200
},
{
"nameXml": "DecimalPoints",
"alignment": "right",
"dataType": "number",
"decimal": "",
"description": "",
"excludeFromPrinting": "",
"header": "Decimal points",
"header2": "",
"style": {
"objectName": "",
"backgroundColor": "",
"color": "",
"fontSize": 10,
"bold": false,
"italic": false
},
"visible": "",
"editable": true,
"width": 200
},
{
"nameXml": "Country",
"alignment": "right",
"dataType": "number",
"decimal": "",
"description": "",
"excludeFromPrinting": "",
"header": "Country",
"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.