public.serial_numbers
iduuidtenant_iduuiditem_iduuidserial_numbercharacter varyingbatch_iduuid?warehouse_iduuid?bin_iduuid?statuscharacter varyingreceived_ondate?issued_ondate?reference_typecharacter varying?reference_iduuid?warranty_expirydate?notestext?is_activebooleancreated_attimestamp with time zoneupdated_attimestamp with time zonewo_iduuid?current_operation_iduuid?variant_iduuid?is_rejectedbooleandefect_reasontext?defect_operation_iduuid?defect_attimestamp with time zone?allocated_so_iduuid?warranty_start_datedate?issued_reference_nocharacter varying?received_reference_nocharacter varying?jobber_iduuid?
| id | tenant_id | item_id | serial_number | batch_id | warehouse_id | bin_id | status | received_on | issued_on | reference_type | reference_id | warranty_expiry | notes | is_active | created_at | updated_at | wo_id | current_operation_id | variant_id | is_rejected | defect_reason | defect_operation_id | defect_at | allocated_so_id | warranty_start_date | issued_reference_no | received_reference_no | jobber_id |