| id | bigint(20) unsigned |
|
|
|
| nomor | varchar(80) |
|
|
|
| tanggal | date |
|
|
|
| jenis | varchar(30) |
|
|
|
| supplier_id | bigint(20) unsigned |
|
|
|
| supplier_nama | varchar(180) |
|
|
|
| nomor_faktur | varchar(100) |
|
|
|
| tanggal_faktur | date |
|
|
|
| nominal | decimal(18,2) |
|
|
|
| uraian | varchar(500) |
|
|
|
| status | varchar(30) |
|
|
draft
|
| request_token | char(64) |
|
|
|
| ledger_id | bigint(20) unsigned |
|
|
|
| created_by | varchar(100) |
|
|
|
| created_at | datetime |
|
|
2026-10-06 03:59:49.000000
|
| verified_by | varchar(100) |
|
|
|
| verified_at | datetime |
|
|
2026-10-06 03:59:49.000000
|
| approved_by | varchar(100) |
|
|
|
| approved_at | datetime |
|
|
2026-10-06 03:59:49.000000
|
| rejected_reason | varchar(500) |
|
|
|
| cancelled_reason | varchar(500) |
|
|
|
| reversed_expense_id | bigint(20) unsigned |
|
|
|
| items_json | longtext |
|
|
|