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. |