The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.
COMPANY.DAT is the company file, which holds the company name, address, and other information specific to the business. Most of this information is entered or available in Sage 50's Maintain Company Information window.
The COMPANY.DAT file has only one record (row).
COMPANY.DAT has two keys, as follows:
0 = By version.
1 = By GUID
The following table shows the fields available in the COMPANY.DAT file and includes the type and size in number of bytes of each field.
|
Field Name |
Type |
Size |
Comment |
|---|---|---|---|
|
Company Name |
ZString |
39 |
Company name entered in the Maintain Company Information window. |
|
CompanyUnused1 |
ZString |
30 |
Do not select or use this field. It is used by Sage 50 for internal reasons. |
|
Address1 |
ZString |
30 |
Business address line 1 entered in the Maintain Company Information window. |
|
Address2 |
ZString |
30 |
Business address line 2 entered in the Maintain Company Information window. |
|
City |
ZString |
20 |
City address field entered in the Maintain Company Information window. |
|
State |
ZString |
2 |
2-character State address field entered in the Maintain Company Information window. |
|
ZIP |
ZString |
12 |
ZIP address field entered in the Maintain Company Information window. |
|
Country |
ZString |
15 |
Country address field entered in the Maintain Company Information window. |
|
ArchiveDate |
Date |
8 |
Date on which this company was archived. If = 0, not an archive company. |
|
FederalEIN |
ZString |
12 |
Federal Employer ID entered in the Maintain Company Information window. |
|
CompanyUnused2 |
ZString |
11 |
Do not select or use this field. It is used by Sage 50 for internal reasons. |
|
CompanyUnused3 |
ZString |
11 |
Do not select or use this field. It is used by Sage 50 for internal reasons. |
|
IsCashBasis |
Integer |
1 |
Accounting method established during New Company Setup and displayed in the Maintain Company Information window. 0 => Accrual 1 => Cash Basis |
|
PostingType |
Integer |
1 |
Posting Method selected in the Maintain Company Information window. 0 => Batch posting 1 => Real time posting 2=> SmartPosting (Sage 50 Quantum Accounting) |
|
CompanyType |
Integer |
Form of Business selected in the Maintain Company Information window. Valid values are: 0 = Straight “C” Corporation 1 = S Corporation 2 = Partnership 3 = Sole Proprietor 4 = Individual – (currently not supported in Sage 50) 5 = Fiduciary – (currently not supported in the Sage 50) 6 = Limited Liability Corporation Sage 50 currently supports only 0,1,2,3, and 6. |
|
|
ModulesSetUp |
ZString |
Lists all modules that are currently checked (set up) in Sage 50's Setup Checklist window. Think of this as an array of one byte logical flags where the elements are as follows: 0 = Maintain Chart of Accounts 1 = G/L Defaults 2 = G/L Beginning Balances 3 = Vendor Defaults 4 = Maintain Vendors 5 = Vendor Beginning Balances 6 = Customer Defaults 7 = Statement/Invoice defaults 8 = Maintain Customers 9 = Customer Beginning Balances 10 = Employee Defaults 11 = Maintain Employees 12 = Employee Beginning Balances 13 = Inventory Defaults 14 = Maintain Inventory 15 = Inventory Beginning Balances 16 = Jobs Defaults 17 = Maintain Jobs 18 = Jobs Beginning Balances 19 = Not currently used |
|
|
CompanyUnused4 |
ZString |
Do not select or use this field. It is used by Sage 50 for internal reasons. |
|
|
DBN |
ZString |
20 |
DBN name of the company |
|
DBNServer |
ZString |
63 |
DBN server of the company |
|
|
ZString |
64 |
Email address for the company. |
|
WebSite |
ZString |
251 |
Web site address (URL) for the company. Note: About the Web Address fields:Sage 50 allows Web address URLs to be up to 254 characters. If the URL entered in Sage 50 is longer than 251 characters (Crystal Reports' maximum field length), the remaining characters will be truncated. |
|
PhoneNumber |
ZString |
20 |
Business phone number entered in the Maintain Company Information window. |
|
FAXNumber |
ZString |
20 |
Business FAX number entered in the Maintain Company Information window. |
|
CompanyUnused6 |
ZString |
Do not select or use this field. It is used by Sage 50 for internal reasons. |
|
|
Contact |
ZString |
20 |
Name of company contact person. |
|
UseE_Time |
Integer |
Do not select or use this field. It is used by Sage 50 for internal reasons. |
|
|
CompanyEBPStatus |
Ubinary |
||
|
ETImeIndex |
ZString |
6 |
Do not select or use this field. It is used by Sage 50 for internal reasons. |
|
DBNGUIDKey |
UBinary |
Do not select or use this field. It is used by Sage 50 for internal reasons. |
|
|
MasterKeyAsmVer |
ZString |
17 |
Master key assembly version used by this company |
|
UseAuditTrail |
Integer |
1 |
The Use Audit Trail option selected in the Maintain Company Information window. (Sage 50 Premium Accounting and higher) TRUE => Audit trail feature is activated. False => Audit trail feature is turned off. |
|
SEIN |
ZString |
20 |
State Employer ID entered in the Maintain Company Information window. |
|
SUIN |
ZString |
20 |
State Unemployement ID entered in the Maintain Company Information window. |
|
DateLastDataAccessTest |
Date |
8 |
The date on which the last data verification access test has been run in Sage 50. |
|
CompanyUnused10 |
ZString |
37 |
Do not select or use this field. It is used by Sage 50 for internal reasons. |
|
ExtendedType |
Integer |
Consolidate company feature (Sage 50 Premium Accounting and higher): 1 => Basic 2 => Consolidated |
|
|
FPPSEnabled |
UBinary |
||
|
CompanySpecial1a |
UBinary |
4 |
First 4 bytes of GUID. |
|
CompanySpecial1b |
UBinary |
4 |
Second 4 bytes of GUID. |
|
CompanySpecial1c |
UBinary |
4 |
Third 4 bytes of GUID. |
|
CompanySpecial1d |
UBinary |
4 |
Fourth 4 bytes of GUID. |
|
DirDepActive |
Integer |
1 |
Indicates whether direct deposit has been turned on in Maintain Company window. Valid choices include: True = direct deposit turned on (inactive) for the company False = direct deposit not turned on for the company. |
|
DirDepAccountType |
Integer |
This is the type of account the company uses for payments to direct-deposit employees. |
|
|
DirDepAccountNumber |
ZString |
17 |
Account number of the account the company uses for payments to direct-deposit employees. |
|
DirDepRoutingNumber |
ZString |
9 |
Routing number of account the company uses for payments to direct-deposit employees. |
|
DirDepPreNtStat |
Integer |
Pre-note status of the account the company uses for payments to direct-deposit employees. |
|
|
DirDepPreNtStatDate |
Date |
Pre-note status date of the account the company uses for payments to direct-deposit employees. |
|
|
DirDepCashAccount |
Integer |
Cash account used by the company for direct-deposit disbursements. |
|
|
DirDepFeeExpAccount |
Integer |
Expense account used by the company to cover the direct-deposit processing fee. |
|
|
DirDepPayRFrequency |
Integer |
Frequency of direct deposit payments by the company |
|
|
DirDepPayRDay |
Integer |
Direct-deposit payday for the company |
|
|
DirDepNextPayRDate |
Date |
Next pay date for direct-deposit payments by the company. |
|
|
OldDirDepCreditLimit |
UBinary |
Do not select or use this field. It is used by Sage 50 for internal reasons. |
|
|
DirDepAuthorized |
Logical |
TRUE => Authorized for direct deposit FALSE => not bank authorized for direct deposit |
|
|
ArchiveDescription |
ZString |
30 |
Description entered when the company is archived. Currently used for the archived company's directory name. |
|
LastArchiveDate |
Date |
Date of the most recent archiving of the company. |
|
|
dDirDepCreditLimit |
Float |
||
|
LastUpdateCounter |
UBinary |
This increases incrementally when the company record is changed. |
|
|
ExpirationInterval |
Integer |
The number of days the password should expire by from the last expiration date of the user. 0 turns off the policy and passwords never expire. |
|
|
IntervalType |
Integer |
Indicates whether the interval should be displayed in days or weeks. (The value in the ExpirationInterval field is ALWAYS in days.) 0=Weeks 1=Days |
|
|
LoginLockoutEnabled |
Integer |
Indicates if users will get locked out from failed login attempts 0=No 1=Yes |
|
|
LoginAdminResetOnly |
Integer |
Indicates if only administrators are allowed to unlock locked out users and not allow lockout duration to release the locked user. 0=No 1=Yes |
|
|
LoginAttempts |
Integer |
The number of unsuccessful login attempts that will lock out a user |
|
|
LoginLockoutDuration |
Integer |
How long a user is locked out |
|
|
LoginIsLockoutInHrs |
Integer |
Indicates whether the LoginLockoutDuration value is in minutes or hours 0=Minutes 1=Hours |
|
|
SageDriveActive |
Integer |
Indicates whether Sage Drive is active for the company. |
|
|
SageDriveDataSetID |
Zstring |
36 |
Determines which company database is currently in use locally. |
|
SageDriveKey |
Zstring |
36 |
Used to open the Sage Drive company. |