| org_id | varchar(36) |
|
|
|
| created_date | datetime |
|
|
current_timestamp()
|
| last_update_date | datetime |
|
|
current_timestamp()
|
| trans_id | varchar(36) |
|
|
|
| no_assets | varchar(100) |
|
|
|
| no_laporan_penilaian_assets | varchar(1000) |
|
|
|
| name | varchar(1000) |
|
|
|
| noiventaris | varchar(1000) |
|
|
|
| spesifikasi | varchar(1000) |
|
|
|
| serialnumber | varchar(100) |
|
|
|
| volume | double |
|
|
0
|
| tahun_perolehan | varchar(4) |
|
|
|
| estimasi_penggunaan_day | float |
|
|
0
|
| jenis_id | varchar(1) |
|
|
|
| status_id | varchar(100) |
|
|
|
| sumber_id | varchar(36) |
|
|
|
| location_id | varchar(36) |
|
|
|
| air | varchar(1) |
|
|
N
|
| listrik | varchar(1) |
|
|
N
|
| internet | varchar(1) |
|
|
N
|
| vollistrik | double |
|
|
|
| operasional | varchar(1) |
|
|
N
|
| tgldibuat | varchar(24) |
|
|
|
| lastupdatedate | varchar(24) |
|
|
|
| tglbeli | varchar(10) |
|
|
|
| nilai_perolehan | double |
|
|
0
|
| nilai_bunga_pinjaman | double |
|
|
0
|
| nilai_pemeliharaan | double |
|
|
0
|
| nilaibangunanpermeter | double(17,0) |
|
|
|
| waktu_depresiasi | float |
|
|
0
|
| waktu_bunga | float |
|
|
0
|
| perolehantahunan | double(17,0) |
|
|
0
|
| perolehanbulanan | double(17,0) |
|
|
0
|
| perolehanharian | double(17,0) |
|
|
0
|
| perolehanpasien | double(17,0) |
|
|
0
|
| pinjamantahunan | double(17,0) |
|
|
0
|
| pinjamanbulanan | double(17,0) |
|
|
0
|
| pinjamanharian | double(17,0) |
|
|
0
|
| pinjamanpasien | double(17,0) |
|
|
0
|
| pemeliharaantahunan | double(17,0) |
|
|
0
|
| pemeliharaanbulanan | double(17,0) |
|
|
0
|
| pemeliharaanharian | double(17,0) |
|
|
0
|
| pemeliharaanpasien | double(17,0) |
|
|
0
|
| costperpasien | double(17,0) |
|
|
0
|
| kategori | varchar(1000) |
|
|
|
| statusassets | varchar(1000) |
|
|
|
| sumber | varchar(1000) |
|
|
|
| dibuatoleh | varchar(1000) |
|
|
|
| rincianasset | mediumtext |
|
|
|
