Data Types
Overview
A number of 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 > Default: Use Data Types is used to enable/disable data types in the Data Editor, Item Categories and Estimate Types.
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 using the User Settings > Setups > Data Editor - Access Allowed setting. (Default = No)
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 which will be used to calculate the Estimate and insert/update the Description, Materials and Services.
Technical
Data tables all have the following fields in common:
MATUNITID - Links to an Item (For Raw Materials / Products)
VATITEMID - Links to a Transaction item (For Products that need to be estimated)
LOOKUPID - Links to the data record from which the Item/Estimate was copied
DESCRIPTION - A trigger can be used to populate this field from the specification fields