public.items
iduuidtenant_iduuidcodecharacter varyingnamecharacter varyingdescriptiontext?item_typecharacter varyingcategory_iduuid?uom_iduuidhas_variantsbooleanattributesjsonbhsn_sac_codecharacter varying?gst_ratenumericstandard_costnumericvaluation_methodcharacter varyingbatch_trackedbooleanserial_trackedbooleanshelf_life_daysinteger?is_activebooleancreated_attimestamp with time zoneupdated_attimestamp with time zonelist_pricenumericlead_time_daysintegersafety_stocknumericreorder_levelnumericmin_order_qtynumericorder_multiplenumericprocurement_typecharacter varyinghome_bin_iduuid?putaway_zonecharacter varying?barcodetext?qr_codetext?image_urltext?category_nametext?sub_categorytext?secondary_uom_iduuid?max_stocknumericlast_purchase_pricenumericweightnumeric?volumenumeric?lengthnumeric?widthnumeric?heightnumeric?colourtext?sizetext?brandtext?brand_iduuid?manufacturertext?country_of_origintext?tax_typetext?is_piece_trackedbooleantrack_inventorybooleanmrpnumericwspnumericdefault_supplier_iduuid?supplier_item_codetext?default_warehouse_iduuid?default_bin_iduuid?stock_uom_iduuid?purchase_uom_iduuid?sales_uom_iduuid?sub_category_iduuid?material_type_iduuid?lifecycle_state_iduuid?is_expiry_trackedbooleaninspection_requiredbooleanwarranty_monthsintegereffective_datedate?expiry_datedate?collectiontext?contenttext?tech_sheet_urltext?quality_cert_urltext?gst_classification_iduuid?preferred_vendor_iduuid?
| id | tenant_id | code | name | description | item_type | category_id | uom_id | has_variants | attributes | hsn_sac_code | gst_rate | standard_cost | valuation_method | batch_tracked | serial_tracked | shelf_life_days | is_active | created_at | updated_at | list_price | lead_time_days | safety_stock | reorder_level | min_order_qty | order_multiple | procurement_type | home_bin_id | putaway_zone | barcode | qr_code | image_url | category_name | sub_category | secondary_uom_id | max_stock | last_purchase_price | weight | volume | length | width | height | colour | size | brand | brand_id | manufacturer | country_of_origin | tax_type | is_piece_tracked | track_inventory | mrp | wsp | default_supplier_id | supplier_item_code | default_warehouse_id | default_bin_id | stock_uom_id | purchase_uom_id | sales_uom_id | sub_category_id | material_type_id | lifecycle_state_id | is_expiry_tracked | inspection_required | warranty_months | effective_date | expiry_date | collection | content | tech_sheet_url | quality_cert_url | gst_classification_id | preferred_vendor_id |
|---|