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_AR.DAT is the accounts receivable (customer) defaults (Module 1) view of Sage 50's GENERAL.DAT file. Most of the field information for GENERAL_AR.DAT view is entered or displayed in Sage 50's Customer Defaults and Statement/InvoicesDefaults window.
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_AR.DAT file and includes the type and size in number of bytes of each field.
|
Field Name |
Type |
Size |
Comment |
|---|---|---|---|
|
AcctgModule |
Integer |
For customer defaults, you must specify that Module == 1. |
|
|
GUID |
UBinary |
GUID (Globally Unique Identifier) used for linking the General_AR table. |
|
|
LastUpdateCounter |
Integer |
This increases incrementally when the record is changed. |
|
|
GL_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. |
|
|
ARAcctRecordNumber |
Integer |
Current default A/R account that is used in the Quotes, Sales Orders, Sales/Invoicing, and Receive Money window. |
|
|
CashAcntRecordNumber |
Integer |
Current default cash account that is used in the Receive Money window. |
|
|
DiscAcntRecordNumber |
Integer |
Discount G/L account set up in Customer Defaults window and used in the Receive Money window when applying receipts to invoices and taking discounts. |
|
|
TaxAcntRecordNumber |
Integer |
Current default sales tax G/L account. These accounts are established in the Maintain Sales Tax Authorities window. |
|
|
NumDaysInBracket0 |
Integer |
Number of days for first aging bracket (column) in aged receivable views and reports. Note: Aging brackets (categories) for accounts receivable are entered on the Account Aging tab of the Customer Defaults window. |
|
|
LabelForBracket0 |
ZString |
15 |
Label for first bracket (column) in aged receivable views and reports. |
|
NumDaysInBracket1 |
Integer |
Number of days for second aging bracket (column) in aged receivable views and reports. |
|
|
LabelForBracket1 |
ZString |
15 |
Label for second bracket (column) in aged receivable views and reports. |
|
NumDaysInBracket2 |
Integer |
Number of days for third aging bracket (column) in aged receivable views and reports. |
|
|
LabelForBracket2 |
ZString |
15 |
Label for third bracket (column) in aged receivable views and reports. |
|
NumDaysInBracket3 |
Integer |
Number of days for last aging bracket (column) in aged receivable views and reports. |
|
|
LabelForBracket3 |
ZString |
15 |
Label for last bracket (column) in aged receivable views and reports. |
|
AgeByDueDate |
Integer |
1 |
Aging Invoices By option set up on the Aging tab of the Customer Defaults window 1 (TRUE) => all aging based on invoice due date 0 (FALSE) => all aging based on invoice date. |
|
NextInvoice |
ZString |
20 |
The currently next available sales invoice number in the print sequence. |
|
Unused |
ZString |
Do not select or use this field. It is used by Sage 50 for internal reasons. |
|
|
DunnForBracket0 |
Integer |
Dunning message text for first aging bracket (column) of past due sales balances that prints on customer statements. Note: Dunning text messages and number of days (brackets) are entered in the Statements/Invoices Defaults window. |
|
|
DunnAgeBracket0 |
ZString |
79 |
Number of days for first dunning message bracket of past due sales balances that prints on customer statements. |
|
DunnForBracket1 |
Integer |
Dunning message text for second aging bracket (column) of past due sales balances that prints on customer statements. |
|
|
DunnAgeBracket1 |
ZString |
79 |
Number of days for second dunning message bracket of past due sales balances that prints on customer statements. |
|
DunnForBracket2 |
Integer |
Dunning message text for third aging bracket (column) of past due sales balances that prints on customer statements. |
|
|
DunnAgeBracket2 |
ZString |
79 |
Number of days for third dunning message bracket of past due sales balances that prints on customer statements. |
|
DunnForBracket3 |
Integer |
Dunning message text for last aging bracket (column) of past due sales balances that prints on customer statements. |
|
|
DunnAgeBracket3 |
ZString |
79 |
Number of days for last dunning message bracket of past due sales balances that prints on customer statements. |
|
PrintStmntZero |
UBinary |
Zero statement balance and print options set up in the Statement/Invoices Defaults window. 78 (ASCII “N”) – Never print zero balance customers. 79 (ASCII “O”) - Only print if other options allow. 65 (ASCII “A”) - Always print zero balance customers. |
|
|
StmntMinus |
UBinary |
Negative statement balance and print options set up in the Statement/Invoices Defaults window. 78 (ASCII “N”) – Never print negative balance customers. 79 (ASCII “O”) – Only print if other options allow. 65 (ASCII “A”) - Always print negative balance customers. |
|
|
StmntPlus |
Integer |
Positive statement balance and print option set up in the Statement/Invoices Defaults window. TRUE => Print statements for customers with a balance of at least StmntMin. |
|
|
StmntOld |
Integer |
TRUE => Print Statements for customers with invoices at least StmntAge days old. |
|
|
StmntMin |
Float |
The minimum balance needed for printing if StmntPlus is TRUE. |
|
|
StmntAge |
Integer |
Statement aging requirement for printing for Stmntold |
|
|
StmntForAnyAct |
Integer |
Activity option set up in the Statement/Invoices Defaults window. 1 (TRUE) => Print statements for customers with ANY activity. |
|
|
PrtCompName |
Integer |
Print option set up in the Statement/Invoices Defaults window. 1 (TRUE) => Print company name and address on invoices and statements. |
|
|
Terms_DueDays |
Integer |
Number of days before the invoice becomes past due. This is set up on the Terms and Credit tab of Customer Defaults. |
|
|
Terms_DiscDays |
Integer |
Number of days beyond invoice date when discount is still good. This is set up on the Terms and Credit tab of Customer Defaults. |
|
|
Terms_DiscountPcnt |
Float |
Percent of total invoice allowed as discount. This is set up on the Terms and Credit tab of Customer Defaults. |
|
|
Terms_CreditLimit |
Float |
Total amount of credit extended to customer. This is set up on the Terms and Credit tab of Customer Defaults. |
|
|
Terms_ChgInterest |
Integer |
Setting of Charge Finance Charges checkbox on the Terms and Credit tab of Customer Defaults. True => finance charges can be calculated for customer. |
|
|
Terms_COD |
Integer |
Setting of COD option on the Terms and Credit tab of Customer Defaults. True => COD allowed for customer. |
|
|
Terms_Prepay |
Integer |
Setting of Prepaid option on the Terms and Credit tab of Customer Defaults. True => customer must prepay invoice. |
|
|
TermDaysAreActual |
Integer |
||
|
TermsDueAtMonthEnd |
Integer |
Setting of due at end of month option on the Terms and Credit tab of Customer Defaults. True => customer payment due at month's end. |
|
|
Terms_Unused |
ZString |
6 |
|
|
IntRevenuePostAcnt |
Integer |
4 |
|
|
IntOverdueDays |
Integer |
2 |
|
|
IntonInt |
Integer |
1 |
|
|
BracketInterestRate1 |
Decimal |
12 |
|
|
BalanceInterestRate1 |
Decimal |
12 |
|
|
IntMinimumCharge |
Decimal |
12 |
|
|
PrtIntWarn |
Integer |
1 |
|
|
DontUse1 |
UBinary |
Do not select or use this field. It is used by Sage 50 for internal reasons. |
|
|
FinChargeMessage |
ZString |
79 |
Finance charge warning message entered in the Customer Defaults window and printed on sales invoices, if the option is selected. |
|
DefTaxCode |
ZString |
8 |
|
|
SalesTypeName1[1-27] |
ZString |
20 |
|
|
Taxable1 [1-27] |
Integer |
1 |
|
|
TaxableIn1 [1-27] |
Integer |
1 |
|
|
CustomField_Label1 [1-5] |
ZString |
16 |
Text label for customer custom fields. Note: Labels for customer custom fields are set up on the Custom Fields tab of the Customer Defaults window. To get the custom field names, you must use a custom formula. Tell me more about this. |
|
CustomField_Enabled1 [1-5] |
Integer |
1 |
1=True, 0=False |
|
NextQuote |
ZString |
20 |
Do not select or use this field. It is used by Sage 50 for internal reasons. |
|
DefSalesAcctRecNum |
Integer |
4 |
Default sales account record number entered in Maintain Employees/Prospects, the Sales Defaults tab. |
|
PayMethodDesc1 [1-10] |
ZString |
20 |
Payment Method Description, entered on Pay Methods tab of Customer Defaults. |
|
RecentMethodDesc |
ZString |
20 |
|
|
NextSO |
ZString |
20 |
Next Sales Order |
|
szFInChrgShowAs |
ZString |
20 |
|
|
MerchantKmsKeyId |
Integer |
4 |
Do not select or use this field. It is used by Sage 50 for internal reasons. |
|
MerchantIdLength |
UTinyInt |
1 |
Do not select or use this field. It is used by Sage 50 for internal reasons. |
|
MerchantId |
Binary |
32 |
Do not select or use this field. It is used by Sage 50 for internal reasons. |
|
MerchantKeyLength |
UTinyInt |
1 |
Do not select or use this field. It is used by Sage 50 for internal reasons. |
|
MerchantKey |
Binary |
32 |
Do not select or use this field. It is used by Sage 50 for internal reasons. |
|
DepositDateOptions |
Integer |
4 |
|
|
LastAccountUsed |
Integer |
4 |
|
|
NextCCM |
ZString |
20 |
|
|
NextEmailInvoice |
ZString |
20 |
|
|
NextEmailCCM |
ZString |
20 |
|
|
NextEmailQuote |
ZString |
20 |
|
|
CreditStatus |
Integer |
Setting of the Credit Status option on the Terms and Credit tab of Maintain Customers/Prospects. |
|
|
DefPrtStatementType |
Integer |
4 |
|
|
NextProposal |
ZString |
20 |
|
|
CreditStatusMsg |
ZString |
250 |
Credit Status Message entered in the Message field on the Payment/Credit tab of the Maintain Customers/Prospects window. |
|
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. |