Note The account export function exports accounts, GL actual balances, and budgets. This file format is for the chart of accounts.
Note
It is also possible to perform a chart of accounts export using the eFinancials Fixed Length file format.
Accounts.BCL Version 1
The first line of the file, which is VERSION 1, is used to identify the format. The basic format is fixed length (SDF).
|
Field |
Field Name |
Type |
Length |
Description |
|---|---|---|---|---|
|
1 |
Company |
Character |
2 |
The first 2 characters of EntityCompany ID |
|
2 |
Project |
Character |
3 |
Characters 3, 4, and 5 of the EntityCompany ID |
|
3 |
Account # |
Character |
15 |
Account number |
|
4 |
Cat.Account |
Character |
15 |
Blank |
|
5 |
Cat.Type |
Character |
1 |
Blank |
|
6 |
Desc |
Character |
30 |
Account description |
|
7 |
Type |
Character |
1 |
A = Asset |
|
8 |
Level |
Character |
1 |
0 for header |
|
9 |
|
Character |
1 |
A |
|
10 |
SpaceBefore |
Character |
1 |
Blank |
|
11 |
SpaceAfter |
Character |
1 |
Blank |
|
12 |
Underline |
Character |
1 |
Blank |
|
13 |
Active |
Character |
1 |
Blank |
|
14 |
Not used |
Character |
1 |
Blank |
See Also
Data Transfer File Formats Introduction
Account Export File Format: eFinancials Fixed Length
Budgets File Format: Budgets.BCL
Account Export Balances File Format: Actuals.BCL
Copyright © 2018 Infor. All rights reserved. www.infor.com.