The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.
The GENERAL.DAT file contains default information about your Sage 50 company. It contains rows, but each row is very different in layout from the other rows. GENERAL_GL.DAT is the general ledger (G/L) defaults (Module 4) view of Sage 50's GENERAL.DAT file. Most of the field information for GENERAL_GL.DAT view is recorded behind the scenes for all G/L transactions, including account period and fiscal year setup, journal totals, and various other G/L defaults established by Sage 50.
Note: GENERAL.DAT tables cannot be linked to other Sage 50 data tables, but they can be used individually to extract various default information in your Crystal reports.
This file has only two keys:
0 = ByModule
1 = By GUID
The following table shows the fields available in the GENERAL_GL.DAT file and includes the type and size in number of bytes of each field.
|
Field Name |
Type |
Size |
Comment |
|---|---|---|---|
|
AcctgModule |
Integer |
For general ledger defaults, you must specify that Module == 4. |
|
|
GUID |
UBinary |
GUID (Globally Unique Identifier) used for linking the General_GL table. |
|
|
LastUpdateCounter |
Integer |
This increases incrementally when the record is changed. |
|
|
Version |
Integer |
Identifies the current version format of your company database. For Release 8.1, this should be in the range of “15.00” to “11.12." |
|
|
CurrentPeriod |
Integer |
Identifies your company's current (internal) accounting period number. Valid values include 15 to 41, where 15 is the first period of this fiscal year, while 29 is the first period of next fiscal year. Note: Sage 50 internal accounting period numbers differ from what is visible to the user in the application. Also, Sage 50's internal accounting periods include a thirteenth period, which many companies may not use. |
|
|
NumMonthInYr |
Integer |
Indentifies the number of accounting periods in a single fiscal year. This is usually 12 or 13. |
|
|
LastActRecAcctRecNum |
Integer |
Tells the account number that was used most recently in the Account Reconciliation window. |
|
|
Unposted_Jrnl1 |
Integer |
Identifies how many unposted transactions are in Journal 1 (Cash Receipts Journal). |
|
|
Unposted_Jrnl2 |
Integer |
Identifies how many unposted transactions are in Journal 2 (Cash Disbursements Journal). |
|
|
Unposted_Jrnl3 |
Integer |
Identifies how many unposted transactions are in Journal 3 (Sales Journal). |
|
|
Unposted_Jrnl4 |
Integer |
Identifies how many unposted transactions are in Journal 4 (Purchase Journal). |
|
|
Unposted_Jrnl5 |
Integer |
Identifies how many unposted transactions are in Journal 5 (Payroll Journal). |
|
|
Unposted_Jrnl6 |
Integer |
Identifies how many unposted transactions are in Journal 6 (Cost of Goods Sold Journal). |
|
|
Unposted_Jrnl7 |
Integer |
Identifies how many unposted transactions are in Journal 7 (Inventory Adjustments Journal). |
|
|
Unposted_Jrnl8 |
Integer |
Identifies how many unposted transactions are in Journal 8 (Assemblies Journal). |
|
|
Unposted_Jrnl9 |
Integer |
Identifies how many unposted transactions are in Journal 9 (TempBelowInvAdj Journal). This is a system-generated inventory costing journal that is not seen by the Sage 50 user. |
|
|
Unposted_Jrnl10 |
Integer |
Identifies how many unposted transactions are in Journal 10 (Purchase Orders Journal). |
|
|
Unposted_Jrnl11 |
Integer |
Identifies how many unposted transactions are in Journal 11 (Sales Orders Journal). |
|
|
Unposted_Jrnl12 |
Integer |
Identifies how many unposted transactions are in Journal 12 (Quotes Journal). |
|
|
Unposted_Jrnl13 |
Integer |
Identifies how many unposted transactions are in Journal 13. |
|
|
Unposted_Jrnl14 |
Integer |
Identifies how many unposted transactions are in Journal 14. |
|
|
Unposted_Jrnl15 |
Integer |
Identifies how many unposted transactions are in Journal 15. |
|
|
YrlyGLPrintedThsYr |
Logical |
Do not select or use this field. |
|
|
YrlyGLPrintedNxtYr |
Logical |
Do not select or use this field. |
|
|
Unused31 [1-15] |
Binary |
2 |
Do not select or use this field. It is used by Sage 50 for internal reasons. |
|
Unused_BalPeriod |
Integer |
2 |
Do not select or use this field. It is used by Sage 50 for internal reasons. |
|
UnusedPriorPeriod |
Integer |
Do not select or use this field. It is used by Sage 50 for internal reasons. |
|
|
CalendarYear |
Integer |
Tells the current calendar (payroll) year as in four-digit (YYYY) format. |
|
|
W2UnprintedThsYr |
Logical |
TRUE if employee W-2 forms have NOT been printed for the current calendar (payroll) year yet. |
|
|
W2UnprintedNxtYr |
Logical |
TRUE if employee W-2 forms have NOT been printed for second open calendar (payroll) year yet. |
|
|
Ten99UnprntedThsYr |
Logical |
TRUE if vendor 1099 forms have NOT been printed for the current calendar (payroll) year yet. |
|
|
Ten99UnprntedNxtYr |
Logical |
TRUE if vendor 1099 forms have NOT been printed for second open calendar (payroll) year yet. |
|
|
JournalNeedPost |
UBinary |
Indicates that journal has not yet been posted. |
|
|
JrnlsPreserved |
Logical |
Do not select or use this field. |
|
|
Periods0FrmDate |
Date |
4 |
Beginning date covered by the journal. |
|
Periods0ToDate |
Date |
4 |
End date covered by the journal. |
|
Periods1FrmDate [1-41] |
Date |
4 |
Start date of Accounting Period [1-41] of the last closed
fiscal year. |
|
Periods1ToDate [1-41] |
Date |
End date of Accounting Period [1-41] of the last closed
fiscal year. |
|
|
JrnlNeedsPrint1...15 |
UBinary |
Journal (1-15) needs to be printed. |
|
|
GLNeedsPrint1 |
UBinary |
||
|
RoundAcctRecNum |
Integer |
The G/L rounding account set up the General Ledger Defaults window. This account is used when rounding financial statements to whole dollars to collect rounding errors. |
|
|
LastRecurNum |
Integer |
||
|
OldestUnPostedTrx |
Date |
Oldest unposted transaction reference. This is called during Sage 50's purge process. |
|
|
OldestQuote |
Date |
Oldest quote date. |
|
|
OldestPO |
Date |
Oldest open purchase order date. |
|
|
LastPostOrderNumber |
Integer |
Last purchase order number used in the print sequence (currently unused). |
|
|
RunBatchCosting |
Logical |
Do not select or use this field. It is used by Sage 50 for internal reasons. |
|
|
BankRecAcntRecNum |
Integer |
Current default account reconciliation account. |
|
|
RunBatchCosting |
Integer |
1 |
|
|
BankRecAcntRecNum |
Integer |
Current default account reconciliation account. |
|
|
ContainsInvCostItems |
Integer |
1 |
|
|
DateLastPurge |
Date |
Date of the last purge process. |
|
|
BBEquityAcctRecNum |
Integer |
The account used to plug general ledger beginning balance entries. |
|
|
CashAcnt |
Integer |
||
|
RegisterFilter |
Integer |
||
|
SortType |
Integer |
||
|
LastAcntCashAcntReg |
|||
|
SegLength1 |
Integer |
Length of account segment No. 1 set up General Ledger Defaults (Sage 50 Premium Accounting and higher). |
|
|
SegmentName1 |
ZString |
10 |
Name (description) of account segment No. 1 set up General Ledger Defaults (Sage 50 Premium Accounting and higher). |
|
SegmentSeparator1 |
ZString |
1 |
Separator used in account segment No. 1 set up General Ledger Defaults (Sage 50 Premium Accounting and higher). |
|
SegLength1 |
Integer |
Length of account segment No. 2 set up General Ledger Defaults (Sage 50 Premium Accounting and higher). |
|
|
SegmentName2 |
ZString |
10 |
Name (description) of account segment No. 2 set up General Ledger Defaults (Sage 50 Premium Accounting and higher). |
|
SegmentSeparator2 |
ZString |
1 |
Separator used in account segment No. 2 set up General Ledger Defaults (Sage 50 Premium Accounting and higher). |
|
SegLength3 |
Integer |
Length of account segment No. 3 set up General Ledger Defaults (Sage 50 Premium Accounting and higher). |
|
|
SegmentName3 |
ZString |
10 |
Name (description) of account segment No. 3 set up General Ledger Defaults (Sage 50 Premium Accounting and higher). |
|
SegmentSeparator3 |
ZString |
1 |
Separator used in account segment No. 3 set up General Ledger Defaults (Sage 50 Premium Accounting and higher). |
|
SegLength4 |
Integer |
Length of account segment No. 4 set up General Ledger Defaults (Sage 50 Premium Accounting and higher). |
|
|
SegmentName4 |
ZString |
10 |
Name (description) of account segment No. 4 set up General Ledger Defaults (Sage 50 Premium Accounting and higher). |
|
SegmentSeparator4 |
ZString |
1 |
Separator used in account segment No. 4 set up General Ledger Defaults (Sage 50 Premium Accounting and higher). |
|
SegLength5 |
Integer |
Length of account segment No. 5 set up General Ledger Defaults (Sage 50 Premium Accounting and higher). |
|
|
SegmentName5 |
ZString |
10 |
Name (description) of account segment No. 5 set up General Ledger Defaults (Sage 50 Premium Accounting and higher). |
|
SegmentSeparator5 |
ZString |
1 |
Separator used in account segment No. 5 set up General Ledger Defaults (Sage 50 Premium Accounting and higher). |
|
HasPurgedTrx |
Ubinary |
Indicates if transactions have been purged for each period in the last year |
|
|
ArchDateLastPurge |
Date |
Archives the last purge date |
|
|
Filler |
Binary |
Do not select or use this field. It is used by Sage 50 for internal reasons. |
|
|
PR_Filler |
Binary |
Do not select or use this field. It is used by Sage 50 for internal reasons. |
|
|
W2_Filler |
Binary |
Do not select or use this field. It is used by Sage 50 for internal reasons. |
|
|
AP_Filler |
Binary |
Do not select or use this field. It is used by Sage 50 for internal reasons. |
|
|
AR_Filler |
Binary |
Do not select or use this field. It is used by Sage 50 for internal reasons. |
|
|
Jobs_Filler |
Binary |
Do not select or use this field. It is used by Sage 50 for internal reasons. |
|
|
Inv_Filler |
Binary |
Do not select or use this field. It is used by Sage 50 for internal reasons. |