40.2 Data imports back port from 1.4

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” if not a contra-account, “1” if it is.

tax

“0” if it is not a tax-account, “1” if it is.

link

A colon (’:’) separated list of acccount checkmark values (links) as described in Section 22.2.3 on page 22.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.