Available in Sage 50 Quantum Accounting.

Units/Measures Fields

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

Filename: UNITMEAS.DAT

UNITMEAS.DAT is the Units/Measures file. The information below is entered or displayed in the Maintain Units/Measures window.

  • To add Sage 50 Units/Measures fields to your Crystal reports, select UNITMEAS.DAT.

Indexes and Their Uses

The file has the following keys:

0 = uacckeyByUniqueKey. Keyed by fields: U/M Guid.

1 = uacckeyById. Keyed by fields: U/M ID.

2 = uacckeyByDesc. Keyed by fields: U/M Description.

3 = uacckeyByInact_Id. Keyed by fields: Inactive, U/M ID.

4 = uacckeyByInact_Desc. Keyed by fields: Inactive, U/M Description.

Fields

The following table shows the fields available in the UNITMEAS.DAT file and includes the type and size in number of bytes of each field.

Field Name

Type

Size

Comment

UMGUID

UBinary

GUID (Globally Unique Identifier) used for linking the UnitMeas table.

UMID

ZString

20

U/M ID entered on the Maintain Units/Measures window.

Inactive

Integer

1

The Inactive check box on the Maintain Units/Measures window.

0 = the Unit/Measure record is active (unchecked).

1 = the Unit/Measure record is inactive (checked).

UMDescription

ZString

30

U/M Description entered in the Description field on the Maintain Units/Measures window.

NoStockingUnits

Float

Number of Stocking Units that make up this Unit/Measure as entered in the Maintain Units/Measures window.

LastUpdateCounter

Integer

This increases incrementally when the record is changed.

What do you want to do next?