Data Types Reference

Several data tables are available in BOS Enterprise. These can be used to:

  • Create lookup lists.
  • Link to Items.
  • Used for Estimating when the product is a single component.

Every Data Type has a matching input screen which is replicated wherever it gets used.

The general setting General > Enable Data Types enables or disables Data Types in the Data Editor, Item Categories and Estimate Types. Click Edit... in the Value column and move the Data Types you use from the Available list to the Selected list.

Data Types Available

Info

These Data Types can be selected in the Enable Data Types setting:

Data Type Explained on
Flexo - ToolingFlexo Engineering
Material TypesMaterials
MaterialsMaterials
Flexo - MachinesFlexo Machines
Eng - MachiningEngineering
Pumps - ProductsPumps
Pumps - SeriesPumps
Pumps - SitesPumps
Pumps - InstallationsPumps
FastenersEngineering Data Types
CompoundsCompounds
AssetsAssets
WeighbridgeWeighbridge
RingrollersRingrollers

Data Editor

The Data Editor is a fixed module that can be used to view and edit the Data tables. It can be added to the Menu using Setup > Menus.

User access to the module is controlled by the user setting Setups > Data Editor – Access Allowed (unchecked by default).

Buttons Explained

Button Description
ViewDisplays the records of the selected Type.
NewCreates a record of the selected Type.
MenuOpens a menu with these options:
  • Edit: Opens the selected record.
  • Delete: Deletes the selected record.
  • Save: Saves your grid layout.
  • Restore: Restores your saved grid layout.
  • Restore Default (All Users): Restores the default grid layout for all users.
  • Save (All Users): Saves the grid layout for all users.

Filters Explained

Filter Description
TypeThe Data table to view:
  • Material Types
  • Flexo - Machine
  • Pumps - Series
  • Pumps - Sites

Material Types Fields Explained

Field Description
DescriptionThe material type.
DensityThe density of the material type.
Other StandardsOther standards that match the material type.

Flexo Machine Fields Explained

Field Description
DescriptionGenerated from the machine's Make, Model and Serial No.
Print WidthThe machine's print width.
Print Repeat MinThe machine's minimum print repeat.
Print Repeat MaxThe machine's maximum print repeat.
Made byThe supplier who manufactures the machine.

Pumps Series Fields Explained

Field Description
DescriptionThe pump series.
CategoryThe category of the series.
TypeThe type of product:
  • Pump
  • Motor
  • Pump Unit
  • Accessory
IndustrialCheckbox. If checked, the series is used in industrial applications.
MiningCheckbox. If checked, the series is used in mining applications.
AgriculturalCheckbox. If checked, the series is used in agricultural applications.
DomesticCheckbox. If checked, the series is used in domestic applications.

Pumps Sites Fields Explained

Field Description
DescriptionThe name of the site.

Items

Data tables can be linked to Item Classes using the Data Type field.

Estimating

Data tables can be linked to Estimate Types by setting Input Type = Data table and selecting the applicable Data table. A field is provided to add the name of the Stored Procedure that calculates the estimate and inserts or updates the Description, Materials and Services.

Technical

Data tables all have the following fields in common:

  • MATUNITID: Links to an Item (for raw materials and products).
  • VATITEMID: Links to a transaction item (for products that need to be estimated).
  • LOOKUPID: Links to the data record from which the Item or Estimate was copied.
  • DESCRIPTION: A trigger can be used to populate this field from the specification fields.

Report an issue with this page

For more useful feedback, select the text on the page you're reporting about, then click Feedback again — or continue without selecting anything.