General > Import data > Import balance code tables

The following fields can be allocated:

1.Table no. *

2.Code *

3.Description *

4.Type (H, S, B) *

5.From Acc. positive

6.Until Acc. positive

7.From Acc. negative

8.Until Acc. negative

9.Level

10.Lux debit/this year

11.Lux credit/ prev year

12.XBRL Label 2020 Coc NL

13.XBRL Label 2021 CoC NL

14.Sequence number

* Required

Table no.

Enter the number of the balance code table in which you would like to import. If this is an existing table, the imported data will be added to the current data in the table.

Note: If the table already exist there is a risk of an overlap within the ranges of general ledger accounts.

Tables can be created and maintained via Maintenance> Financial> Balance codes.

If the table does not exist, it will be created.

Type (H, S, B)

Define each entry as a header (H), a subheader (S) or a balance code (B).

Balance codes can be linked to a range of general ledger accounts.

Level

This field allows for subheaders to be subdivided in a treelike manner (parent-child relations). Enter the level numbers (1-9).

Sequence number

The sequence number is used to determine the presentation order of items in the table.

This field is not required. When the field is not linked the line numbers of the import file will be used for the sequence numbers.