Company Fields

The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.

Filename: COMPANY.DAT

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.

  • To add Sage 50 company fields to your Crystal reports, select COMPANY.DAT.

Indexes and Their Uses

The COMPANY.DAT file has only one record (row).

COMPANY.DAT has two keys, as follows:

0 = By version.

1 = By GUID

Fields

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

Email

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.

What do you want to do next?