Accounts Payable Default Information Fields

The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.

Filename: GENERAL_AP.DAT

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_AP.DAT is the accounts payable (vendor) defaults (Module 2) view of Sage 50's GENERAL.DAT file. Most of the field information for GENERAL_AP.DAT view is entered or displayed in Sage 50's Vendor Defaults window.

To add Sage 50 accounts payble (vendor) default fields to your Crystal reports, select GENERAL_AP.DAT.

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.

Indexes and Their Uses

This file has only two keys:

0 = ByModule

1 = By GUID

Fields

The following table shows the fields available in the GENERAL_AP.DAT file and includes the type and size in number of bytes of each field.

Field Name	Type	Size	Comment
AcctgModule	Integer		For vendor defaults, you must specify that Module == 2.
GUID	UBinary		GUID (Globally Unique Identifier) used for linking the General_AP 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.
APAcctRecordNumber	Integer	4	Current default A/P account that is used in the Purchase Orders, Purchases, and Payments window.
CashAcntRecordNumber	Integer	4	Current default cash account that is used in the Payments window.
WCCashAcctRecNum	Integer	4	Current default cash account that is used in the Write Checks window.
DiscAcntRecordNumber	Integer	4	Current default discount account entered in Vendor Defaults, the Payment Terms tab.
NumDaysInBracket0	Integer		Number of days for first aging bracket (column) in aged payable views and reports. Note: Aging brackets (categories) for accounts payable are entered on the Account Aging tab of the Vendor Defaults window.
LabelForBracket0	ZString	15	Label for first bracket (column) in aged payable views and reports.
NumDaysInBracket1	Integer		Number of days for second aging bracket (column) in aged payable views and reports.
LabelForBracket1	ZString	15	Label for second bracket (column) in aged payable views and reports.
NumDaysInBracket2	Integer		Number of days for third aging bracket (column) in aged payable views and reports.
LabelForBracket2	ZString	15	Label for third bracket (column) in aged payable views and reports.
NumDaysInBracket3	Integer		Number of days for last aging bracket (column) in aged payable views and reports.
LabelForBracket3	ZString	15	Label for last bracket (column) in aged payable views and reports.
AgeByDueDate	Logical	1	Aging Invoices By option set up on the Aging tab of the Vendors Defaults window TRUE => all aging based on invoice due date FALSE => all aging based on invoice date.
NextCheck	ZString	20	Do not select or use this field. It is used by Sage 50 for internal reasons.
Unused	ZString	19	Do not select or use this field. It is used by Sage 50 for internal reasons.
TermsDueDays	Integer		Number of days before the invoice becomes past due. This is set up on the Payment Terms tab of Vendor Defaults.
TermsDiscDays	Integer		Number of days beyond invoice date when discount is still good. This is set up on the Payment Terms tab of Vendor Defaults.
TermsDiscPercent	Float		Percent of total invoice allowed as discount. This is set up on the Payment Terms tab of Vendor Defaults.
TermsCreditLimit	Float		Total amount of credit extended by vendor. This is set up on the Payment Terms tab of Vendor Defaults.
TermsChargeInterest	Integer
TermsCOD	Integer		Setting of COD checkbox on the Payment Terms tab of Vendor Defaults. True => COD allowed by vendor.
TermsPrepay	Integer		Setting of Prepaid checkbox on the Payment Terms tab of Vendor Defaults. True => vendor requires prepayment.
TermsDayIsActual	Integer
TermsDueMontEnd	Integer		Setting of due at end of month on the Payment Terms tab of Vendor Defaults. True => payment due at month's end.
TermsUnused	ZString	6
Internal2	ZString	8	Do not select or use this field. It is used by Sage 50 for internal reasons.
Internal2			Do not select or use this field. It is used by Sage 50 for internal reasons.
NextPONumber	ZString	20	The currently next available purchase order number in the print sequence.
NextEmailPO	ZString	20
NextTicket	ZString	20
CustomFieldLabel1	ZString	16	Text label for first vendor custom field. Note: Labels for vendor custom fields are set up on the Custom Fields tab of the Vendor Defaults window. The Enabled field To get the custom field names, you must use a custom formula. Tell me more about this.
CustomField_Enabled1	Integer	1	1=True, 0=False
CustomFieldName2	ZString	16	Text label for second vendor custom field.
CustomField_Enabled2	Integer	1	1=True, 0=False
CustomFieldName3	ZString	16	Text label for third vendor custom field.
CustomField_Enabled3	Integer	1	1=True, 0=False
CustomFieldName4	ZString	16	Text label for fourth vendor custom field.
CustomField_Enabled4	Integer	1	1=True, 0=False
CustomFieldName5	ZString	16	Text label for fifth vendor custom field.
CustomField_Enabled5	Integer	1	1=True, 0=False
DefPurcAcctRecNum	Integer		The record number of the default purchase account for the vendor.
RecentMethod	UInteger		Stores the record number for the most recent payment method used on Payments and Write Checks
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.

What do you want to do next?

See a list of Crystal Reports data (.DAT) files