public.items
| 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 | 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 | 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 | allow_negative_stock |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 53bdade7-7b9d-472e-a99b-6768fc3ecd28 | 0bf6bf27-4200-4180-9bfb-d1ed77d98be0 | abc | Jeans | null | RAW | 233016dc-24a5-4590-815f-43fd3a35314c | bbfa1854-0ba6-4bac-b718-208b81ccc566 | True | {} | 5208 | 18.00 | 5000.0000 | WEIGHTED_AVG | False | False | null | True | 2026-11-15 09:36:51.839958+00:00 | 2026-11-15 09:51:15.883549+00:00 | 0.0000 | 0 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | BUY | null | null | null | Jeans | Denim | null | 0.0000 | 0.0000 | 0.0000 | 0.0000 | null | null | null | null | null | null | c124e11b-b04b-441e-98e3-9f0f71ca9152 | null | null | exclusive | True | 25000.0000 | 0.0000 | null | null | null | null | null | null | null | 02d39197-4fb8-495c-b199-e118081c48b5 | null | null | False | False | 0 | null | null | null | null | null | null | null | null | False |
| 6b4bc3e1-1249-4cb6-ab4e-23b6646c5206 | 0bf6bf27-4200-4180-9bfb-d1ed77d98be0 | Noore Summer | Ready Jeans | null | FINISHED | 233016dc-24a5-4590-815f-43fd3a35314c | bbfa1854-0ba6-4bac-b718-208b81ccc566 | True | {} | 5208 | 18.00 | 5000.0000 | WEIGHTED_AVG | True | True | null | True | 2026-11-15 09:53:15.764882+00:00 | 2026-11-15 09:53:15.764882+00:00 | 0.0000 | 0 | 0.0000 | 0.0000 | 0.0000 | 0.0000 | BUY | null | null | null | Jeans | Denim | null | 0.0000 | 0.0000 | 0.0000 | 0.0000 | null | null | null | null | null | null | c124e11b-b04b-441e-98e3-9f0f71ca9152 | null | null | exclusive | True | 25000.0000 | 0.0000 | null | null | null | null | null | null | null | 02d39197-4fb8-495c-b199-e118081c48b5 | null | null | False | False | 0 | null | null | null | null | null | null | null | null | False |
Page 1