| id | bigint(20) unsigned |
|
|
|
| nomor_invoice | varchar(255) |
|
|
|
| tgl_datang | date |
|
|
|
| tgl_faktur | date |
|
|
|
| tgl_jatuh_tempo | date |
|
|
|
| pegawai_id | bigint(20) unsigned |
|
|
|
| jenis_po_id | bigint(20) unsigned |
|
|
|
| nomor_po | varchar(255) |
|
|
|
| supplier | varchar(255) |
|
|
|
| deskripsi | text |
|
|
|
| total_nilai | decimal(15,2) |
|
|
|
| diskon_persen | decimal(5,2) |
|
|
0.00
|
| diskon_rupiah | decimal(15,2) |
|
|
0.00
|
| ppn_persen | decimal(5,2) |
|
|
0.00
|
| ppn_rupiah | decimal(15,2) |
|
|
0.00
|
| total_akhir | decimal(15,2) |
|
|
0.00
|
| file_invoice | varchar(255) |
|
|
|
| catatan | text |
|
|
|
| kdgudang | varchar(255) |
|
|
|
| status | enum | -- |
|
draft
|
| level_approval | int(11) |
|
|
0
|
| status_approval_invoice | int(11) |
|
|
0
|
| created_at | timestamp |
|
|
|
| updated_at | timestamp |
|
|
|
