| id | bigint(20) unsigned |
|
|
|
| bulan | int(11) |
|
|
|
| tahun | int(11) |
|
|
|
| nik | varchar(30) |
|
|
|
| nama | varchar(100) |
|
|
|
| jabatan | varchar(100) |
|
|
|
| bank | varchar(50) |
|
|
|
| rekening | varchar(50) |
|
|
|
| upah_pokok | decimal(15,2) |
|
|
0.00
|
| tunjangan | decimal(15,2) |
|
|
0.00
|
| fooding | decimal(15,2) |
|
|
0.00
|
| lembur | decimal(15,2) |
|
|
0.00
|
| komite | decimal(15,2) |
|
|
0.00
|
| insentif_lainnya | decimal(15,2) |
|
|
0.00
|
| total_gaji_kotor | decimal(15,2) |
|
|
0.00
|
| bpjs_tk | decimal(15,2) |
|
|
0.00
|
| bpjs_kes | decimal(15,2) |
|
|
0.00
|
| dana_sosial | decimal(15,2) |
|
|
0.00
|
| obat | decimal(15,2) |
|
|
0.00
|
| potongan_ketidakhadiran | decimal(15,2) |
|
|
0.00
|
| potongan_keterlambatan | decimal(15,2) |
|
|
0.00
|
| pinjaman_rs | decimal(15,2) |
|
|
0.00
|
| pinjaman_rpl | decimal(15,2) |
|
|
0.00
|
| pph_21 | decimal(15,2) |
|
|
0.00
|
| total_gaji_bersih | decimal(15,2) |
|
|
0.00
|
| keterangan | text |
|
|
|
| created_at | timestamp |
|
|
|
| updated_at | timestamp |
|
|
|
