| id |
int(10)
|
|
|
|
| nomor_transaksi |
varchar(60)
|
latin1_swedish_ci
|
|
|
| tanggal |
date
|
|
|
|
| customer_id |
int(10)
|
|
|
|
| barang_id |
int(10)
|
|
|
|
| berat_jual |
decimal(14,2)
|
|
|
|
| harga_jual_per_kg |
decimal(16,2)
|
|
|
|
| total_penjualan |
decimal(16,2)
|
|
|
|
| harga_beli_dari_cabang |
decimal(16,2)
|
|
|
|
| ongkos_kirim |
decimal(16,2)
|
|
|
|
| biaya_operasional |
decimal(16,2)
|
|
|
|
| laba_bersih |
decimal(16,2)
|
|
|
|
| kendaraan_id |
int(10)
|
|
|
|
| sopir |
varchar(120)
|
latin1_swedish_ci
|
|
|
| metode_pembayaran |
enum('tunai', 'transfer', 'tempo')
|
latin1_swedish_ci
|
|
|
| status_pembayaran |
enum('lunas', 'belum_lunas')
|
latin1_swedish_ci
|
|
|
| jatuh_tempo |
date
|
|
|
|
| bukti_pembayaran |
varchar(255)
|
latin1_swedish_ci
|
|
|
| catatan |
text
|
latin1_swedish_ci
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
| deleted_at |
datetime
|
|
|
|
