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 code

13.Sequence number

* Required

With this import function new balance code tables can be created
At existing tables new codes can be added.

Only lines with status OK are processed.

See also the help topic Maintenance > Balance codes.

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.

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

Note: If the table already exists, 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.

Type (H, S, B)

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

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

General ledger ranges entered at Type H and S will be ignored.

Level

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

XBRL code

Use the current XBRL codes. The XBRL codes are not checked for validity during import, but they are checked for validity in the maintenance screen for balance code tables.

Sequence number

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

When the field is not linked the line numbers of the import file will be used for the sequence numbers.
If the field is linked, it must be filled.

When adding new lines to a table enter the sequence number in the import file.