| id | bigint(20) unsigned |
|
|
|
| period_id | bigint(20) unsigned |
|
|
|
| employee_profile_id | bigint(20) unsigned |
|
|
Menjelajahi nilai luar |
| legacy_gaji_id | bigint(20) unsigned |
|
|
|
| employee_code | varchar(40) |
|
|
|
| employee_name | varchar(180) |
|
|
|
| position_name | varchar(160) |
|
|
|
| bank_account | varchar(80) |
|
|
|
| gross_amount | decimal(20,2) |
|
|
0.00
|
| deduction_amount | decimal(20,2) |
|
|
0.00
|
| net_amount | decimal(20,2) |
|
|
0.00
|
| component_json | longtext |
|
|
|
| payment_status | varchar(20) |
|
|
pending
|
| source | varchar(60) |
|
|
manual
|
| created_at | datetime |
|
|
2026-10-06 18:36:43.000000
|