public.material_types
iduuidtenant_iduuidcodetextnametextdescriptiontext?is_stockedbooleanis_purchasablebooleanis_sellablebooleanis_produciblebooleanneeds_qcbooleandefault_valuationtextdefault_is_batch_trackedbooleandefault_is_expiry_trackedbooleangl_inventory_accounttext?gl_cogs_accounttext?is_systembooleansort_orderintegeris_activebooleancreated_attimestamp with time zoneupdated_attimestamp with time zone
| id | tenant_id | code | name | description | is_stocked | is_purchasable | is_sellable | is_producible | needs_qc | default_valuation | default_is_batch_tracked | default_is_expiry_tracked | gl_inventory_account | gl_cogs_account | is_system | sort_order | is_active | created_at | updated_at |