Pricing features in ForceField

Pricing Features (as of V3.4.9)
  - All pricing records can have optional start and/or end dates

  - Option to specify prices by unit of measure, or only for base unit

  - Unlimited alternate units of measure (with price conversion factors)

  - List of valid units for sales

  - List of valid units for returns

  - Catchweight pricing ("Price per LB" but sold by case or other unit)
    Invoice uses actual shipping weight, order uses average (standard) weight.

  - Promotional pricing

  - "Best-of" pricing option ("most specific" pricing is the alternative)

  - "Contract price" option (fixed price regardless of other pricing options)

  - "Floor price" option to set a minimum price that can be used on an order.

  - Customers may be assigned to a "Customer Price Group" (PriceClass).
    Each customer may belong to only one PriceClass.
    Each customer may also have a "Special Price Customer Code" (SPCC).
    Customer may only have one SPCC assigned to them.
    The SPCC can be used in special cases where one customer has special pricing
    that is offered to certain other customers, regardless of their PriceClass.

  - Items may be assigned to an "Item Price Group" (PriceCat).
    Each item may belong to only one PriceCat.
    Items have a field called "Market Cost" on which pricing can be based, along
    with retail and base prices.

  - Pricing records may be set up for any of the following combinations, which
    are listed in the order they are checked for in order entry pricing, from the
    "most specific" to "most general" prices that apply to a customer and item.
    - Promo             + Item #
    - Cust#/Shipto#     + Item #
    - Cust #            + Item #
    - SPCC              + Item #
    - PriceClass        + Item #
    - "All Customers"   + Item #
    - Cust#/Shipto#     + PriceCat
    - Cust#             + PriceCat
    - SPPC              + PriceCat
    - PriceClass        + PriceCat
    - "All Customers"   + PriceCat
    - "All Customers"   + "All Items"

  - Each pricing record specifies a Price Factor and a Price Basis:

  - Price Factor can be:
    - 'AMT+': Dollar amount added to basis
    - 'AMT-': Dollar amount subtracted from basis
    - 'MULT': Multiplier times basis
    - 'PCT':  Percentage of basis
    - 'PCT+': Percentage of basis added to basis
    - 'PCT-': Percentage of basis subtracted from basis
    - 'MARG': Margin percentage to be obtained (using basis as cost)
    - 'NET':  Net price (flat amount, no basis used)

  - Price Basis can be:
    - 'BASE': Base Price
    - 'RTL':  Retail Price
    - 'COST': Market (standard) Cost
    - 'NET':  Net Price (no basis used)

Pricing table

  CREATE TABLE PRICES (
   CUSTKEY     VARCHAR (40)    NOT NULL,
   PRODKEY     VARCHAR (40)    NOT NULL,
   UOM         VARCHAR (8)     DEFAULT 'BASE',
   START_DATE  VARCHAR (10)    DEFAULT '2000-01-01',
   END_DATE    VARCHAR (10)    DEFAULT '2999-12-31',
   PRICE_TYPE  VARCHAR (10)    DEFAULT 'LIST',
   CALC_TYPE   VARCHAR (10)    DEFAULT 'NET/NET',
   BASE        DECIMAL (12, 5) DEFAULT 0,
   PRICE1      DECIMAL (12, 5) DEFAULT 0,
   PRICE2      DECIMAL (12, 5) DEFAULT 0,
   PRICE3      DECIMAL (12, 5) DEFAULT 0,
   PRICE4      DECIMAL (12, 5) DEFAULT 0,
   PRICE5      DECIMAL (12, 5) DEFAULT 0,
   PRICE6      DECIMAL (12, 5) DEFAULT 0,
   QTYBREAK1   DECIMAL (12, 5) DEFAULT 0,
   QTYBREAK2   DECIMAL (12, 5) DEFAULT 0,
   QTYBREAK3   DECIMAL (12, 5) DEFAULT 0,
   QTYBREAK4   DECIMAL (12, 5) DEFAULT 0,
   QTYBREAK5   DECIMAL (12, 5) DEFAULT 0,
   QTYBREAK6   DECIMAL (12, 5) DEFAULT 0,
   DISC_VALUE  DECIMAL (12, 5) DEFAULT 0,
   DISC_TYPE   VARCHAR (3)     DEFAULT 'Pct',
   UDF1        VARCHAR (20),
   UDF2        VARCHAR (10),
   CONSTRAINT PRICES_IDX PRIMARY KEY (CUSTKEY, PRODKEY, UOM, START_DATE)
   );