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.

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.