Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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: Image Added Image Added

QTY

Quantity of this item.

 If omitted is set to one (1).

RRP

Price before any discounts.


UNITCOSTCost Price

AMT

Price after standard discounts.


CODEPART1Get Code of Material selectedMostly used for Options that depend on the Material chosen e.g. Rail Road Y/N option only available for some fabrics.
CODEPART2Get Code of Material Type selectedRestrict Options available based on the Material Type selected in the same way as Options that depend on a previous option selected.
CODEPART3Get Code of Colour selectedAs 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.
DESCNPART1Get description of Material selectedFunctions the same as CODEPART except use the full Material Description.
DESCNPART2Get description of Material Type selectedFunctions the same as CODEPART except use the full Material Type Description.
DESCNPART3Get description of Colour selectedFunctions the same as CODEPART except use the full Colour Description.
INSTALLATIONJOB#NOTEDispatch NotesDispatch notes to appear per line item

Rows



1

This is the Key Word (Name) for this column (Option).

So KEYWORD (not case sensitive) is the Key Word (Name) for this option and must be unique for this tab (Product Type/Inventory Group)

2

This is the Inventory Code for pricing. It can be omitted.

To indicate the inventory code to be used to look up pricing add the pipe character "|" followed by the inventory code in capitals that is to be looked up for price.  This is not validated so if price does not appear check the code is correct and exists in Inventory Maintenance. Typical usage is Freight Product Code here, AMT as Field and the response is the price.

3

The column Key Word that which provides the product code for pricing which can be this column.

So if this is the quantity for a previously selected option this tells the system which option it applies to.

4

The field on the previous option’s charge record where answer is to be saved.

Format is pipe character “|” then the Type Word which can be QTY, ITEMWIDTH, ITEMHEIGHT, ITEMDEPTH, RRP, AMT. are Key Words.

5

Add value to Saved Field (Y) else Clear and then add (N or blank).

This applies to text as well as numbers.

6

The Look Back column that the option relates to.

The column that restricts the options available are dependent on (restricted by).

7The question to display to the user.e.g. Location

...