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_JOBS.DAT is the job defaults (Module 8) view of Sage 50's GENERAL.DAT file. Most of the field information for GENERAL_JOBS.DAT view is entered or displayed in Sage 50's Jobs 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.
This file has two keys:
0 = ByModule
1 = By GUID
The following table shows the fields available in the GENERAL_JOBS.DAT file and includes the type and size in number of bytes of each field.
|
Field Name |
Type |
Size |
Comment |
|
AcctgModule |
Integer |
For job defaults, you must specify that Module == 8. |
|
|
GUID |
UBinary |
GUID (Globally Unique Identifier) used for linking the General_JOBS 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. |
|
|
AR_Filler |
Binary |
Do not select or use this field. It is used by Sage 50 for internal reasons. |
|
|
CustomField_Label1 [1-5] |
ZString |
16 |
Text label for job custom fields. Note: About Job Custom Fields: Labels for job custom fields are set up on the Custom Fields tab of the Job 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 |
|
PayRetainageAccnt |
Integer |
Tells the account number for the payables retainage account (Sage 50 Quantum Accounting). |
|
|
RecRetainageAccnt |
Integer |
Tells the account number for the receivables retainage account (Sage 50 Quantum Accounting). |
|
|
RetainagePercent |
Float |
The default retainage percent (Sage 50 Quantum Accounting). |
|
|
LaborBurdenAccnt |
Integer |
Tells the account record number for the default labor burden account (Sage 50 Quantum Accounting). |
|
|
AppLaborBurdenAccnt |
Integer |
Tells the account record number for the default applied labor burden account (Sage 50 Quantum Accounting). |
|
|
LaborBurdenPercent |
Float |
The default labor burden percent (Sage 50 Quantum Accounting). |
|
|
ARJobWarning |
Logical |
Indicator for warning on AR screens if rows do not contain jobs; True=Warn False=Don't warn |
|
|
APJobWarning |
Logical |
Indicator for warning on AP screens if rows do not contain jobs; True=Warn False=Don't warn |
|
|
Inv_Filler |
Binary |
Do not select or use this field. It is used by Sage 50 for internal reasons. |