Contract Estimator Item Data Table

  • itemName, varchar(150)
    The internal name for the item
  • itemReference, varchar(50)
    The internal reference for the item
  • height, decimal(9,4)
    The height or length of the item in millimetres normally
  • width, decimal(9,4)
    The width or breadth of the item in millimetres normally
  • depth, decimal(9,4)
    The depth ot thickness of the item in millimetres normally
  • weight, decimal(9,4)
    The weight of the item in kilograms normally
  • colour, varchar(50)
    The colour of the item. This is a free description. This is added to the item name in some circumstances.
  • material, varchar(50)
    The material of the item. Generally only applies to sheet materials or machined/moulded items.
  • finish, varchar(50)
    The finish of the item. This is a free description. This is added to the item name in some circumstances.
  • buyQty, decimal(5,2)
    The quantity that you have to buy. This may be a single unit.
  • buyUnit, varchar(20)
    The buy unit.
  • buyPrice, smallmoney
    The buy price. This should be the price of the buy quantity.
  • sellQty, decimal(5,2)
    This is the sell quantity of the item regardless of buy criteria.
  • sellPrice, smallmoney
    This is the sell price of the item regardless of buy criteria.
  • stocked, bit
    Indicates if this is an item that is normally stocked.
  • splitStock, bit
    If false issues must be in complete item units regardless of whether this leaves a large waste element.
  • leadTimeDays, smallint
    The normal lead time from your supplier. Generally set to the longest lead but optional.
  • boughtInFP, bit
    The bought in finished product flag. If true this indicates that the item is a whole unit. Generally only applies to furniture items.
  • buyerNote, varchar(250)
    A field of 250 characters used by buyers if required.
  • iProcFlag01, bit
    Internal processing flag.
  • iProcFlag02, bit
    Internal processing flag.

Additional fields that are added when incorporated in a contract if the bought in finished product flag is set.

  • identityNumber, varchar(50)
    A number that identifies the product such as a serial number on a television
  • assetNumber, varchar(50)
    A number that is assigned to the product for the purpose of asset tracking.
  • installDate, smalldatetime
    The installation or purchase date of the product depending on who is providing the warranty.
Advertisements

Feel free to leave a reply (All moderated)

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.