public.assets
iduuidtenant_iduuidasset_codecharacter varyingnamecharacter varyingcategory_iduuid?warehouse_iduuid?manufacturercharacter varying?model_numbercharacter varying?serial_numbercharacter varying?purchase_datedate?purchase_costnumericwarranty_expirydate?running_hoursnumericstatuscharacter varyingcriticalitycharacter varyingnotestext?is_activebooleancreated_attimestamp with time zoneupdated_attimestamp with time zonedepreciation_methodcharacter varyinguseful_life_yearsnumericsalvage_valuenumericdepreciation_ratenumericdepreciation_start_datedate?accumulated_depreciationnumericdisposed_ondate?disposal_proceedsnumericdepreciation_category_codecharacter varying?locationcharacter varying?companies_act_ratenumeric?it_act_ratenumeric?gl_account_iduuid?vendor_iduuid?vendor_namecharacter varying?invoice_nocharacter varying?gst_ratenumericgst_amountnumericitc_claimednumericlast_depreciation_datedate?meter_typetext?current_meter_readingnumeric?categorytext?asset_classtext?departmenttext?capacitytext?commissioning_datedate?linked_fixed_asset_iduuid?
| id | tenant_id | asset_code | name | category_id | warehouse_id | manufacturer | model_number | serial_number | purchase_date | purchase_cost | warranty_expiry | running_hours | status | criticality | notes | is_active | created_at | updated_at | depreciation_method | useful_life_years | salvage_value | depreciation_rate | depreciation_start_date | accumulated_depreciation | disposed_on | disposal_proceeds | depreciation_category_code | location | companies_act_rate | it_act_rate | gl_account_id | vendor_id | vendor_name | invoice_no | gst_rate | gst_amount | itc_claimed | last_depreciation_date | meter_type | current_meter_reading | category | asset_class | department | capacity | commissioning_date | linked_fixed_asset_id |
|---|