46.2 Data imports back port from 1.4

46.2.1 Chart of Accounts import

This function allows bulk import of an entire chart of accounts using a single Comma Separated Values (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 26.2.3 on page 26.2.3, or “AR”, “AP” or “IC” for the specified summary accounts
heading: Id 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.