Tables are made up of pricing information for standard items that are available for a number of choices. Tables are particularly useful for calculating prices for non-standard selections, based on the quantity and the standard item on which it is based.
A Table Item is structured so that from the Rows Tab, Intersection Items can be launched that reflect the different components of the item.
In this example, a Brick upgrades for House Types are displayed, with one combination selected and launched.
An Intersection Item has the same layout as a Standard Item.
Table Item (Base Prices) Dialog - General Tab
...
Column headings are visible on the Rows tab.
...
| Warning | ||
|---|---|---|
| ||
A maximum of ten (10) column headings can be entered. |
...
| Info | ||
|---|---|---|
| ||
If the table item relates to air conditioners for single storey houses, then the column headings may be all of the air conditioners that apply to the house types: |
Table Columns List
Column | Description |
|---|---|
# | Order in which the column heading will appear across the top of Table Rows list on the Rows tab. To update the number, click the directional buttons in the toolbar. |
Ref | Table column reference. To update the reference, click the directional buttons in the toolbar. |
Name | Full name of the table column heading. |
Column Ref | Reference name of the table column heading. |
Ref. | VPB item reference number. |
...
- Click the New toolbar icon. The Table Row dialog will be displayed.
- Enter the details.
- Click OK. The dialog will close and a new table row will be created.
| Panel | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
|
Table Item (Base Prices) Dialog - Validity Tab
The Validity tab is used to manage the availability of a table item for a region/division or house type.
| Info | ||
|---|---|---|
|
...
...
A brick upgrade may not be available for the Metro - North region/division as the supplier used in that particular region/division doesn't handle those brick types. |
Region/Division Validity Group
...
Displays the image recorded against the table item.
Buttons
...
Button
...
Description
...
Click to clear the image.
...
Click to search for an image. Opens a dialog box that allows users to choose a file from the file system.
...
| Info |
|---|
| Images are stored in the Framework ECM database. Moving or removing the image from the location on the network will not |
...
| affect Framework ECM. |
Table Item (Base Prices) Dialog - BOQ Links Tab
| Warning | ||
|---|---|---|
|
...
BOQ links are ONLY required if information is integrated between Framework ECM and an external estimating system. |
The BOQ Links tab is used to manage the Bill Of Quantities (BOQ) links for a table item.
...
Example: A single wall oven may be connected to a BOQ that contains: -
- Required materials (in this case, the wall oven itself, gas piping, etc.)
...
- Labour
...
- Delivery
Multiple BOQ links can be created so that a single item can be tied to multiple BOQs.
Example: A house may be connected to multiple BOQs such as: -
- Bathroom BOQ
...
- Garage BOQ
...
- Kitchen BOQ, etc.
BOQ Links List
The details in this list can be edited using the BOQ Link dialog.
Column | Description |
|---|---|
# | Order of the BOQ link in the BOQ Links list. BOQ links may be moved to a different position in the list by using the directional buttons in the toolbar.Primary |
| Indicates the primary BOQ link. The primary BOQ link is indicated with a icon. |
QTY | BOQ link quantity. |
Qty Method | Selected quantity method for BOQ links. |
BOQ Reference | BOQ reference item in an estimating system for the table item. |
Export | Export method for the BOQ link from Framework ECM to an external estimating system. |
Pricing | Sales pricing import method for the BOQ link from an external estimating system to Framework ECM. |
Notes | Free text area for notes regarding the BOQ link. |
...
- Click the New toolbar button. The BOQ Link dialog will be displayed.
- Enter the details.
- Click OK. The dialog will close and a new BOQ link will be created.
...
| Info | ||
|---|---|---|
| ||
| Multiple BOQ links can be created. |