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_INV.DAT is the inventory item defaults (Module 7) view of Sage 50's GENERAL.DAT file. Most of the field information for GENERAL_INV.DAT view is entered or displayed in Sage 50's Inventory Item 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_INV.DAT file and includes the type and size in number of bytes of each field.
|
Field Name |
Type |
Size |
Comment |
|---|---|---|---|
|
AcctgModule |
Integer |
For inventory item defaults, you must specify that Module == 7. |
|
|
GUID |
UBinary |
GUID (Globally Unique Identifier) used for linking the General_INV 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. |
|
|
Jobs_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 first inventory item custom field. Note: Labels for inventory item custom fields are set up on the Custom Fields tab of the Inventory Items Defaults window. To get the custom field names, you must use a custom formula. |
|
CustomField_Enabled1 [1-5] |
Integer |
1 |
1=True, 0=False |
|
ShipViaDesc1 [1-10] |
ZString |
20 |
|
|
AllowDupUpcSkuVal |
Logical |
Setting of the Allow duplicate values in the UPC/SKU field checkbox on the General tab of Inventory defaults. |
|
|
IncPOOnQtyAvail |
Logical |
Setting of the Include purchase orders when calculating quantity available checkbox on the Ordering tab of Inventory defaults. |
|
|
IncWkTkOnQtyAvail |
Logical |
Setting of the Include work tickets when calculating quantity available checkbox on the Ordering tab of Inventory defaults (Sage 50 Quantum Accounting). |
|
|
fOutStkWarnSalOrder |
Integer |
Setting of the Sales Invoice / Receipt Out of Stock Warning options on the Ordering tab of Inventory defaults. |
|
|
fOutStkWarnSalInv |
Integer |
Setting of the Sales Order / Proposal Out of Stock Warning options on the Ordering tab of Inventory defaults. |
|
|
bUserDoesNotWantUM |
Logical |
Setting of the Enable Multi-Packs and buying and selling in different units / measures checkbox on the Ordering tab of Inventory defaults (Sage 50 Quantum Accounting). |
|
|
InternalUsed |
Do not select or use this field. It is used by Sage 50 for internal reasons. |
||
|
ATCrtPODropShip |
Logical |
Auto-creation of purchase orders based on drop-ship orders. |
|
|
ATCrtPONonDropShip |
Logical |
Auto-creation of purchase orders based on non-drop-ship orders. |
|
|
ATCrtPOWorkTickets |
Logical |
Auto-creation of purchase orders based on work tickets (Sage 50 Quantum Accounting). |
|
|
AlwDupPtNoForVend |
Logical |
Indicates whether or not duplicate part numbers ares allowed for items with the same preferred vendor. |
|
|
DefaultClass |
Integer |
-1=None 0=Non-stock item 1=Stock item 2=Description only 3=Assembly 4=Service 5=Labor 6=Activity item 7=Charge item 8=Master Stock item 9=Substock item 10=Serialized Stock item 11=Serialized Assembly |