The conversion_ratios Data Model
The conversion_ratios data model creates a relationship between the production plan ID of a site and the product ID. The product ID is associated with products per bag, bags per case, and cases per pallet.
The conversion_ratios data model uses the following primary key: ((tenant_id, enterprise_id, site_id), pp_id)
The conversion_ratios data model contains the following columns:
- tenant_id
- enterprise_id
- site_id
- pp_id
- bags_per_case
- cases_per_pallet
- ins_ts
- prod_id
- prod_per_bag
- upd_ts