Row 1: Each column of row 1 is the Key Word for that option item. Key Words must only appear once for each product (worksheet) and must not contain $. Below is a table of Key Words with special significance. Key Words are used to fill in the Job Sheet and for pricing. If 2 columns are to apply to the same field add # and a unique number on the end of the Key Word e.g. DESCN and DESCN#2 where DESCN is a list of locations and DESCN#2 is a typing field if "Other" is selected.
Key Word | Function | Details |
|---|---|---|
DESCN | Description for Order Line usually Room/Location | List of options listed underneath. |
ITEMWIDTH | Width required, used for price calculations | If omitted is set to one (1). |
ITEMHEIGHT | Height/Drop required, used for price calculations. | If omitted is set to one (1). |
ITEMDEPTH | If depth is required or can be used for price levels. | If omitted is set to one (1). The Depth Answer can not start with a number after the Depth IE: |
QTY | Quantity of this item. | If omitted is set to one (1). |
RRP | Price before any discounts. | |
| UNITCOST | Cost Price | |
AMT | Price after standard discounts. | |
| CODEPART1 | Get Code of Material selected | Mostly used for Options that depend on the Material chosen e.g. Rail Road Y/N option only available for some fabrics. |
| CODEPART2 | Get Code of Material Type selected | Restrict Options available based on the Material Type selected in the same way as Options that depend on a previous option selected. |
| CODEPART3 | Get Code of Colour selected | As with CODEPART1 and CODEPART2 used for Options that depend on the Colour selected. Note not everyone uses Colour for colour, it might be Hinged or Sliding. |
| DESCNPART1 | Get description of Material selected | Functions the same as CODEPART except use the full Material Description. |
| DESCNPART2 | Get description of Material Type selected | Functions the same as CODEPART except use the full Material Type Description. |
| DESCNPART3 | Get description of Colour selected | Functions the same as CODEPART except use the full Colour Description. |
| INSTALLATIONJOB#NOTES | Dispatch Notes | Only active in "Product" Groups - Dispatch notes to appear per line item. |
| INSTALLATION#DESCN | Installation Note | Only active in "Extra" Group - Notes will show in dispatch and on the Work Sheet that can be printed in the Dispatch area. |
