Stock & Services

essential product and services tables these tables are required to determine the setup of products and services and the relationship between these tables are required to determine the setup of products and services and the relationship between products and the relationship between the purchasing batches requires products table and reception notes products table products and the relationship between the purchasing batches requires products table and reception notes products table the products stocks table can be used to determine existing stock on hand quantities the products stocks table can be used to determine existing stock on hand quantities reception notes > purchase order information reception notes products > products purchased id = nir product id on other tables product id = products id reception notes products stock > stock quantities received product categories > digitail product categories id = product categories id on other tables products > general product information category = product categories id includes package size as unit (receiving size) subunit (selling size) formula (number of subunits in a unit) e g 50 (formula) tablets (subunit) in a bottle (unit) excludes quantity of stock on hand products stocks > stock quantity product id = products id stock = unit sub stock = subunit service categories service packages > general service information service id = available services id service pacakages products > products bundled with a service package id = service package id product id = products id