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
These Data Types can be selected in the Enable Data Types setting:
| Data Type | Explained on |
|---|---|
| Flexo - Tooling | Flexo Engineering |
| Material Types | Materials |
| Materials | Materials |
| Flexo - Machines | Flexo Machines |
| Eng - Machining | Engineering |
| Pumps - Products | Pumps |
| Pumps - Series | Pumps |
| Pumps - Sites | Pumps |
| Pumps - Installations | Pumps |
| Fasteners | Engineering Data Types |
| Compounds | Compounds |
| Assets | Assets |
| Weighbridge | Weighbridge |
| Ringrollers | Ringrollers |
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 |
|---|---|
| View | Displays the records of the selected Type. |
| New | Creates a record of the selected Type. |
| Menu | Opens a menu with these options:
|
Filters Explained
| Filter | Description |
|---|---|
| Type | The Data table to view:
|
Material Types Fields Explained
| Field | Description |
|---|---|
| Description | The material type. |
| Density | The density of the material type. |
| Other Standards | Other standards that match the material type. |
Flexo Machine Fields Explained
| Field | Description |
|---|---|
| Description | Generated from the machine's Make, Model and Serial No. |
| Print Width | The machine's print width. |
| Print Repeat Min | The machine's minimum print repeat. |
| Print Repeat Max | The machine's maximum print repeat. |
| Made by | The supplier who manufactures the machine. |
Pumps Series Fields Explained
| Field | Description |
|---|---|
| Description | The pump series. |
| Category | The category of the series. |
| Type | The type of product:
|
| Industrial | Checkbox. If checked, the series is used in industrial applications. |
| Mining | Checkbox. If checked, the series is used in mining applications. |
| Agricultural | Checkbox. If checked, the series is used in agricultural applications. |
| Domestic | Checkbox. If checked, the series is used in domestic applications. |
Pumps Sites Fields Explained
| Field | Description |
|---|---|
| Description | The 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.