Chart of Accounts Fields
The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.
Filename: CHART.DAT
CHART.DAT is the chart of accounts file. It lists all account records listed in your company's chart of accounts and general ledger. Most of the information below is entered or displayed in Sage 50's Maintain Chart of Accounts window. Account debit and credit totals are used in many business reports and financial statements.
- To add Sage 50 chart of account fields to your Crystal reports, select CHART.DAT.
Indexes and Their Uses
CHART.DAT has six keys, as follows:
0 = By AccountID. This index is most useful for sorting records by account ID.
1 = By Account Type and then by Description.
2 = By Description.
3 = By AccountRecordNumber. Use this key to link accounts with other tables.
4 = AccountIsInactive and then by AccountID.
5 = By GUID.
Fields
The following table shows the fields available in the CHART.DAT file and includes the type and size in number of bytes of each field.
Field Name |
Type |
Size |
Comment |
---|---|---|---|
GLAcntNumber |
Integer |
4 |
Account number entered in the Maintain Chart of Accounts window. This field is an index and used to link other tables to the Chart of Accounts table. The field is unique and cannot change. |
AccountID |
ZString |
15 |
Account ID entered in the Maintain Chart of Accounts window. Account IDs are listed in the company's chart of accounts and general Ledger and referenced in many Sage 50 records and transactions. The Account ID data field is unique and cannot change. |
AccountType |
UBinary |
Account type selected for each account ID entered in the Maintain Chart of Accounts window. This field is used for two main purposes:
Also, financial statements are usually designed to depend on account types to format properly. Valid account types include: 0 => Cash 1 => Receivable (Accounts Receivable) 2 => Inventory 3 => Unused1 (Do not select) OR 3 => Receivables Retainage (Sage 50 Quantum Accounting) 4 => OthCurAsset (Other Current Assets) 5 => FixedAsset (Fixed Assets) 6 => AccumDepr (Accumulated Depreciation) 7 => Unused2 (Do not select) 8 => OtherAssets (Other Assets) 9 => Unused4 (Do not select) 10 => Payable (Accounts Payable) 11 => Unused5 (Do not select) OR 11 => Payables Retainage (Sage 50 Quantum Accounting) 12 => OthCurLiability (Other Current Liabilities) 13 => Unused6 (Do not select) 14 => OthLiability (Long Term Liabilities) 15 => Unused7 (Do not select) 16 => EquityNoClose (Equity - Doesn't Close), 17 => Unused8 (Do not select) 18 => RetEarn (Equity - Retained Earnings 19 => EquityClose (Equity - Gets Closed)) 20 => Unused9 (Do not select) 21 => Income 22 => Unused10 (Do not select) 23 => CostSales (Cost of Sales) 24 => Expense |
|
AccountDescription |
ZString |
30 |
Account description entered in the Maintain Chart of Accounts window. |
AccountIsActive |
Logical |
The Inactive check box in the Maintain Chart of Accounts window. Valid choices include: True = if the account record is inactive. False = if the account record is active. |
|
GUID |
UBinary |
16 |
GUID (Globally Unique Identifier) used for linking the Chart table. |
Balance0Dr [0-41] |
Decimal |
12 |
G/L balance debit total for the selected period. Period 0 = Beginning Balances; Period 1=Last Year, first period; Period 14 = Last Year's balances; Period 15 = This year, period 1;Period 29 = Next Year, Period 1. About Last Year (Closed) Period Debit/Credit Totals: Closed periods have amounts in them for income statement accounts and the one and only retained earnings account. |
Balance0Cr [0-41] |
Float |
G/L credit balance for the selected period. Period 0 = Beginning Balances; Period 1=Last Year, first period; Period 13 = for companies with 13 fiscal periods; Period 14 = Last Year's balances; Period 15 = This year, period 1; Period 29 = Next Year, Period 1. |
|
Balance0Net [0-41] |
Float |
G/L net total for the selected period. Period 0 = Beginning Balance; Period 1=Last Year, first period; Period 14 = Last Year's balances; Period 15 = This year, period 1; Period 29 = Next Year, Period 1. |
|
TaxCode |
Zstring |
12 |
Do not select or use this field. It is used by Sage 50 for internal reasons. |
NextCheckNumber |
Zstring |
20 |
The next check number to be used in a print cycle for the selected G/L account ID. This field is usually only relevant for cash accounts. |
GL1099Index |
UBinary |
Tells which types of 1099 payment types are set up to draw cash payments for the current account. These payment types are reflected on the 1099 Settings tab of Vendor Defaults. |
|
ReceiptNum |
ZString |
20 |
Next cash receipt number for this cash account. |
LastDepositTicket |
ZString |
8 |
Last deposit ticket ID used for a deposit made in the Select for Deposit window. |
NextEmailReceipt |
ZString |
20 |
Number of the next receipt emailed to a customer from the Sage 50 Receipts window. |
LastUpdateCounter |
UBinary |
This increases incrementally when the record is changed. |