Rekap Pendapatan Untuk Kasir

Berikut Script Untuk Rekap Pendaptan Kasir Per-Periode tertentu untuk pengecekan di divisi keuangan :

--Realisasi Validasi Nota Type 1
SELECT i.no_invoice, i.no_reg, i.total_tagihan,
(i.payment_tunai+i.payment_transfer+i.payment_cek+i.payment_bg+i.payment_utip+i.payment_bank) as TotalBayar,
i.payment_date, i.kasir, i.verification_code, i.payment_tunai, i.payment_transfer, i.payment_utip, i.payment_cek, i.payment_bank, i.payment_bg, r.no_ppkb, v.name as vessel_name, c.name as cust_name
FROM invoice i, registration r, m_customer c, m_vessel v, planning_vessel p
WHERE i.payment_status = 'PAYMENT' AND r.no_reg = i.no_reg
AND p.no_ppkb = r.no_ppkb
AND p.vessel_code = v.vessel_code
AND r.cust_code = c.cust_code
AND i.payment_date BETWEEN '2013-04-01 00:01' AND '2013-04-17 23:59'


--Realisasi Validasi Nota Type 2
SELECT i.no_invoice, i.no_reg, i.total_tagihan,
(i.payment_tunai+i.payment_transfer+i.payment_cek+i.payment_bg+i.payment_utip+i.payment_bank) as TotalBayar,
i.payment_date, i.kasir, i.verification_code, i.payment_tunai, i.payment_transfer, i.payment_cek, i.payment_utip, i.payment_bg, r.no_ppkb, v.name as vessel_name, c.name as cust_name, i.no_faktur_pajak, i.jumlah_tagihan, i.materai, i.ppn, r.pengurus_do, i.payment_bank
FROM invoice i, registration r, m_customer c, m_vessel v, planning_vessel p
WHERE i.payment_status = 'PAYMENT' AND r.no_reg = i.no_reg
AND p.no_ppkb = r.no_ppkb
AND p.vessel_code = v.vessel_code
AND r.cust_code = c.cust_code
AND i.payment_date BETWEEN '2013-04-01 00:01' AND '2013-04-17 23:59'