46.2 Chart of Accounts import

This function allows bulk import of an entire chart of accounts using a single CSV file.

The first line of the file contains the headers of the columns. The import routine expects the columns as presented in (table name).

accno

Number of the account or header

desc

Description for the account or header

charttype

“H” for heading record
“A” for account record

category

“I” for Income
“E” for Expense
“A” for Asset
“L” for Liability

contra

“0” not a contra account
“1” is a contra account

tax

“0” not a tax account
“1” is a tax account.

link

A colon (’:’) separated list of account check-mark values (links) as described in Section 18.3.3 on page 18.3.3, or “AR”, “AP” or “IC” for the specified summary accounts

heading

“accno” of the heading to group the account (or heading) under

gifi

GIFI account number

All lines after the first one are considered to be data lines.