CREATE TABLE nonstock_master (
    "company_id" int
        NOT NULL                 -- References company_master.company_id
        REFERENCES company_master (company_id),
    "vendor_code" varchar(25)
        NOT NULL,                -- References vendor_master.vendor_code
    "item_code" varchar(32)
        NOT NULL,                -- Non-stock item code
    "item_type" char(1)
        NOT NULL,                -- Item type
                                             -- L: Labor, M: Comment, N: Item, S: Special Charge
    "description" varchar(75),                -- Description
    "product_class" int,                                    -- Product Class Code
    "unit_of_measure" varchar(16),            -- Unit of measure
    "unit_weight" numeric(8,2),               -- Unit weight
    "retail_price" numeric(15,5)              -- Full retail/MSRP
        DEFAULT 0,
    "list_price" numeric(15,5)                -- Customer price prior to discounts
        DEFAULT 0,
    "last_cost" numeric(15,5)                 -- Last cost
        DEFAULT 0,
    "item_matrix" numeric(3,0)
        NOT NULL                          -- Non-stock item matrix
        DEFAULT 0,
    "taxable_flag" BOOLEAN                    -- Whether item should have tax applied in taxable jurisdiction.
        DEFAULT true,
    "date_added" timestamp                    -- Date record was added
        without time zone,
    "added_by" varchar(16),                   -- Employee code of who added item; reference employee_master.employee_code
FOREIGN KEY (company_id,vendor_code)
REFERENCES vendor_master (company_id,vendor_code)
ON UPDATE cascade
);