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