3 ) union SELECT 0 as cash_begin, sum( FINSLIPDET.ITEMPAY_AMT + FINSLIPDET.VAT_AMT ) as pay_amt , 0 as recv_amt, 0 as chq_begin, 0 as chq_fwd , 'จ่ายการเงิน' FROM FINSLIP ,FINSLIPDET ,finucfitemtype , cmcoopmaster WHERE ( FINSLIP.SLIP_NO = FINSLIPDET.SLIP_NO ) AND ( FINSLIP.coop_id = FINSLIPDET.coop_id ) AND ( FINSLIPDET.slipitemtype_code = finucfitemtype.slipitemtype_code ) and ( cmcoopmaster.coop_control = finucfitemtype.coop_id ) and ( FINSLIP.PAYMENT_STATUS = 1 ) AND ( FINSLIP.RECEIVE_STATUS = 1 ) AND (cmcoopmaster.coop_id = finslip.coop_id) AND ( FINSLIP.COOP_ID like $P{coop_id}) AND ( FINSLIP.ENTRY_DATE = $P{adtm_date} ) AND ( FINSLIP.FROM_SYSTEM IN ($P{as_type} ) ) AND ( FINSLIP.PAY_RECV_STATUS = 0 ) AND ( FINSLIP.RETAIL_FLAG <> 3 ) AND ( FINSLIPDET.account_id is null ) union SELECT 0 as cash_begin, sum( FINSLIPDET.ITEMPAY_AMT ) as pay_amt , 0 as recv_amt, 0 as chq_begin, 0 as chq_fwd , 'จ่ายการเงิน' FROM FINSLIP ,FINSLIPDET ,finucfitemtype , accmaster , cmcoopmaster WHERE (cmcoopmaster.coop_id = finslip.coop_id) AND (accmaster.account_id = FINSLIPDET.account_id ) AND (accmaster.coop_id = cmcoopmaster.coop_id ) AND ( FINSLIP.SLIP_NO = FINSLIPDET.SLIP_NO ) AND ( FINSLIP.coop_id = FINSLIPDET.coop_id ) AND ( FINSLIP.PAYMENT_STATUS = 1 ) AND ( FINSLIP.RECEIVE_STATUS = 1 ) AND ( FINSLIP.ENTRY_DATE = $P{adtm_date} ) AND ( FINSLIP.COOP_ID like $P{coop_id}) AND ( FINSLIP.FROM_SYSTEM IN ($P{as_type} ) ) AND ( FINSLIP.PAY_RECV_STATUS = 0 ) AND ( FINSLIP.RETAIL_FLAG = 3 ) AND ( FINSLIPDET.slipitemtype_code = finucfitemtype.slipitemtype_code ) and ( cmcoopmaster.coop_id = finucfitemtype.coop_id ) union SELECT 0 as cash_begin, sum( DPDEPTSLIP.DEPTSLIP_NETAMT) as pay_amt , 0 as recv_amt, 0 as chq_begin, 0 as chq_fwd ,' จ่ายถอน/ปิดบัญชีเงินฝาก' FROM FINSLIP, DPDEPTSLIP, DPDEPTTYPE , cmcoopmaster WHERE ( DPDEPTSLIP.DEPTTYPE_CODE = DPDEPTTYPE.DEPTTYPE_CODE ) and (cmcoopmaster.coop_control = DPDEPTTYPE.COOP_ID ) AND ( FINSLIP.REF_SLIPNO = DPDEPTSLIP.DEPTSLIP_NO ) and ( FINSLIP.coop_id = DPDEPTSLIP.coop_id ) and ( ( FINSLIP.ENTRY_DATE = $P{adtm_date} ) AND (dpdeptslip.deptitemtype_code not in ('WIE','WII','WIM' ) ) and ( FINSLIP.PAYMENT_STATUS = 1 ) AND ( FINSLIP.RECEIVE_STATUS = 1 ) AND (cmcoopmaster.coop_id = finslip.coop_id) AND ( FINSLIP.COOP_ID like $P{coop_id}) AND ( FINSLIP.FROM_SYSTEM = $P{as_type} ) AND ( FINSLIP.PAY_RECV_STATUS = 0 ) ) union SELECT 0 as cash_begin, sum(slslippayout.payout_amt) as pay_amt , 0 as recv_amt, 0 as chq_begin, 0 as chq_fwd ,' จ่ายเงินกู้' FROM FINSLIP, slslippayout, LNLOANTYPE , cmcoopmaster WHERE ( FINSLIP.REF_SLIPNO = slslippayout.payoutslip_no ) and ( FINSLIP.coop_id = slslippayout.coop_id ) and ( slslippayout.shrlontype_code = LNLOANTYPE.LOANTYPE_CODE ) and ( cmcoopmaster.coop_control = LNLOANTYPE.COOP_ID ) and ( ( FINSLIP.ENTRY_DATE = $P{adtm_date} ) AND ( FINSLIP.PAYMENT_STATUS = 1 ) AND ( FINSLIP.RECEIVE_STATUS = 1 ) AND ( slslippayout.slip_status = 1) and (cmcoopmaster.coop_id = finslip.coop_id) AND ( FINSLIP.COOP_ID like $P{coop_id}) AND ( FINSLIP.FROM_SYSTEM = $P{as_type} ) AND ( FINSLIP.PAY_RECV_STATUS = 0 )) union SELECT 0 as cash_begin, sum( slslippayout.payout_amt ) as pay_amt , 0 as recv_amt, 0 as chq_begin, 0 as chq_fwd , 'จ่ายคืนค่าหุ้น' FROM FINSLIP, slslippayout, SHSHARETYPE , cmcoopmaster WHERE ( FINSLIP.REF_SLIPNO = slslippayout.payoutslip_no ) and ( FINSLIP.coop_id = slslippayout.coop_id ) and ( slslippayout.shrlontype_code = SHSHARETYPE.SHARETYPE_CODE ) and ( cmcoopmaster.coop_control = SHSHARETYPE.coop_id) AND ( slslippayout.slip_status = 1 ) AND ( ( trunc(FINSLIP.ENTRY_DATE) = $P{adtm_date} ) AND ( FINSLIP.PAYMENT_STATUS = 1 ) AND ( cmcoopmaster.coop_id = finslip.coop_id) AND ( FINSLIP.COOP_ID like $P{coop_id}) AND ( FINSLIP.FROM_SYSTEM in ($P{as_type} ) ) AND ( FINSLIP.PAY_RECV_STATUS = 0 ) ) union SELECT 0 as cash_begin, sum( yrslippayout.payout_payment ) as pay_amt , 0 as recv_amt, 0 as chq_begin, 0 as chq_fwd , 'จ่ายปันผล - เฉลี่ยคืน ' FROM FINSLIP, yrslippayout, cmcoopmaster WHERE ( trim( FINSLIP.REF_SLIPNO ) = trim( yrslippayout.payoutslip_no ) ) and ( FINSLIP.ENTRY_DATE = $P{adtm_date} ) AND ( FINSLIP.PAYMENT_STATUS = 1 ) AND (cmcoopmaster.coop_id = finslip.coop_id) AND ( FINSLIP.COOP_ID like $P{coop_id}) AND ( FINSLIP.FROM_SYSTEM = $P{as_type} ) AND ( FINSLIP.PAY_RECV_STATUS = 0 ) union SELECT 0 as cash_begin, 0 as pay_amt , sum( slslippayindet.ITEM_PAYAMT ) as recv_amt, 0 as chq_begin, 0 as chq_fwd ,'ค่าธรรมเนียมแรกเข้า' FROM FINSLIP, slslippayin, slslippayindet, cmcoopmaster WHERE ( FINSLIP.ITEMPAYTYPE_CODE = slslippayin.SLIPTYPE_CODE ) and ( FINSLIP.REF_SLIPNO = slslippayin.payinslip_no ) and ( FINSLIP.coop_id = slslippayin.coop_id ) and ( slslippayin.payinslip_no = slslippayindet.payinslip_no ) and ( slslippayin.coop_id = slslippayindet.coop_id ) and ( slslippayindet.slipitemtype_code = 'FEE') AND ( ( FINSLIP.ENTRY_DATE = $P{adtm_date} ) AND ( FINSLIP.PAYMENT_STATUS = 1 ) AND ( FINSLIP.RECEIVE_STATUS = 1 ) AND ( slslippayin.SLIP_STATUS = 1 ) AND (slslippayindet.item_payamt > 0 ) and (cmcoopmaster.coop_id = finslip.coop_id) AND ( FINSLIP.COOP_ID = $P{coop_id} ) AND ( FINSLIP.FROM_SYSTEM in ( $P{as_type}) ) AND ( FINSLIP.PAY_RECV_STATUS = 1 ) ) and FINSLIP.itempaytype_code = 'PX' union SELECT 0 as cash_begin,0 as pay_amt , sum( FINSLIPDET.ITEMPAY_AMT ) as recv_amt, 0 as chq_begin, 0 as chq_fwd ,'รับการเงิน' FROM FINSLIP ,FINSLIPDET , finucfitemtype , accmaster , cmcoopmaster WHERE ( FINSLIP.SLIP_NO = FINSLIPDET.SLIP_NO ) AND ( FINSLIP.coop_id = FINSLIPDET.coop_id ) AND ( FINSLIPDET.account_id = accmaster.account_id ) and ( cmcoopmaster.coop_control = accmaster.coop_id ) and ( FINSLIPDET.slipitemtype_code = finucfitemtype.slipitemtype_code ) and ( cmcoopmaster.coop_control = finucfitemtype.coop_id ) and ( FINSLIP.PAYMENT_STATUS = 1 ) AND ( FINSLIP.RECEIVE_STATUS = 1 ) AND ( FINSLIP.ENTRY_DATE = $P{adtm_date} ) AND (cmcoopmaster.coop_id = finslip.coop_id) AND ( FINSLIP.COOP_ID like $P{coop_id}) AND ( FINSLIP.FROM_SYSTEM IN ($P{as_type} ) ) AND ( FINSLIP.PAY_RECV_STATUS = 1 ) AND ( FINSLIP.RETAIL_FLAG <> 3 ) union SELECT 0 as cash_begin, 0 as pay_amt , sum( FINSLIPDET.ITEMPAY_AMT ) as recv_amt, 0 as chq_begin, 0 as chq_fwd , 'จ่ายการเงิน' FROM FINSLIP ,FINSLIPDET ,finucfitemtype , cmcoopmaster WHERE ( FINSLIP.SLIP_NO = FINSLIPDET.SLIP_NO ) AND ( FINSLIP.coop_id = FINSLIPDET.coop_id ) AND ( FINSLIPDET.slipitemtype_code = finucfitemtype.slipitemtype_code ) and ( cmcoopmaster.coop_control = finucfitemtype.coop_id ) and ( FINSLIP.PAYMENT_STATUS = 1 ) AND ( FINSLIP.RECEIVE_STATUS = 1 ) AND (cmcoopmaster.coop_id = finslip.coop_id) AND ( FINSLIP.COOP_ID like $P{coop_id}) AND ( FINSLIP.ENTRY_DATE = $P{adtm_date} ) AND ( FINSLIP.FROM_SYSTEM IN ($P{as_type} ) ) AND ( FINSLIP.PAY_RECV_STATUS = 1 ) AND ( FINSLIP.RETAIL_FLAG <> 3 ) AND ( FINSLIPDET.account_id is null ) union SELECT 0 as cash_begin,0 as pay_amt , sum( FINSLIPDET.ITEMPAY_AMT ) as recv_amt, 0 as chq_begin, 0 as chq_fwd , 'รับการเงิน' FROM FINSLIP ,FINSLIPDET , finucfitemtype , accmaster , cmcoopmaster WHERE (cmcoopmaster.coop_id = finslip.coop_id) AND (accmaster.account_id = FINSLIPDET.account_id ) AND (accmaster.coop_id = cmcoopmaster.coop_id ) AND ( FINSLIP.SLIP_NO = FINSLIPDET.SLIP_NO ) AND ( FINSLIP.coop_id = FINSLIPDET.coop_id ) AND ( FINSLIP.PAYMENT_STATUS = 1 ) AND ( FINSLIP.RECEIVE_STATUS = 1 ) AND ( FINSLIP.ENTRY_DATE = $P{adtm_date} ) AND ( FINSLIP.COOP_ID like $P{coop_id}) AND ( FINSLIP.FROM_SYSTEM IN ($P{as_type} ) ) AND ( FINSLIP.PAY_RECV_STATUS = 1 ) AND ( FINSLIP.RETAIL_FLAG = 3 ) AND ( FINSLIPDET.slipitemtype_code = finucfitemtype.slipitemtype_code ) and ( cmcoopmaster.coop_id = finucfitemtype.coop_id ) union SELECT 0 as cash_begin,0 as pay_amt , sum( DPDEPTSLIP.DEPTSLIP_NETAMT ) as recv_amt, 0 as chq_begin, 0 as chq_fwd , 'รับเงินฝาก' FROM FINSLIP, DPDEPTSLIP, DPDEPTTYPE , cmcoopmaster WHERE ( DPDEPTSLIP.DEPTTYPE_CODE = DPDEPTTYPE.DEPTTYPE_CODE ) and (cmcoopmaster.coop_control = DPDEPTTYPE.coop_id) AND ( FINSLIP.REF_SLIPNO = DPDEPTSLIP.DEPTSLIP_NO ) and ( FINSLIP.coop_id = DPDEPTSLIP.coop_id ) and ( ( FINSLIP.ENTRY_DATE = $P{adtm_date} ) AND ( FINSLIP.PAYMENT_STATUS = 1 ) AND ( FINSLIP.RECEIVE_STATUS = 1 ) AND (cmcoopmaster.coop_id = finslip.coop_id) AND ( FINSLIP.COOP_ID like $P{coop_id}) AND ( FINSLIP.FROM_SYSTEM = $P{as_type} ) AND ( FINSLIP.PAY_RECV_STATUS = 1 ) ) union SELECT 0 as cash_begin, 0 as pay_amt , sum(slslippayindet.item_payamt ) as recv_amt, 0 as chq_begin, 0 as chq_fwd , 'รับชำระต้นเงินกู้/รับชำระดอกเบี้ยเงินกู้' FROM FINSLIP, slslippayin, slslippayindet, LNLOANTYPE , cmcoopmaster WHERE ( FINSLIP.ITEMPAYTYPE_CODE = slslippayin.SLIPTYPE_CODE ) and ( FINSLIP.REF_SLIPNO = slslippayin.payinslip_no ) and ( FINSLIP.coop_id = slslippayin.coop_id ) and ( slslippayin.payinslip_no = slslippayindet.payinslip_no ) and ( slslippayin.coop_id = slslippayindet.coop_id ) and ( slslippayindet.SHRLONTYPE_CODE = LNLOANTYPE.LOANTYPE_CODE ) and (cmcoopmaster.coop_control = LNLOANTYPE.coop_id) AND ( slslippayindet.slipitemtype_code = 'LON') AND ( ( FINSLIP.ENTRY_DATE = $P{adtm_date} ) AND ( FINSLIP.PAYMENT_STATUS = 1 ) AND ( slslippayin.slip_STATUS = 1 ) AND ( FINSLIP.RECEIVE_STATUS = 1 ) AND (slslippayindet.item_payamt > 0 ) and (cmcoopmaster.coop_id = finslip.coop_id) AND ( FINSLIP.COOP_ID like $P{coop_id}) AND ( FINSLIP.FROM_SYSTEM in ( $P{as_type} ) ) AND ( FINSLIP.PAY_RECV_STATUS = 1 ) ) and FINSLIP.itempaytype_code = 'PX' union select 0 as cash_begin, 0 as pay_amt , sum(d.item_payamt ) as recv_amt, 0 as chq_begin, 0 as chq_fwd , 'หักกลบต้น / ดอกเบี้ย' from finslip a, slslippayout b, slslippayin c, slslippayindet d, lncontmaster e, lnloantype f where a.ref_slipno = b.payoutslip_no and b.slipclear_no = c.payinslip_no and c.payinslip_no = d.payinslip_no and d.loancontract_no = e.loancontract_no and e.loantype_code = f.loantype_code and trunc(a.operate_date) = $P{adtm_date} and a.payment_status = 1 and a.itempaytype_code in ('LWD','SWD') group by f.loantype_desc union select 0 as cash_begin, 0 as pay_amt , sum(d.item_payamt ) as recv_amt, 0 as chq_begin, 0 as chq_fwd , 'หักซื้อหุ้น' from finslip a, slslippayout b, slslippayin c, slslippayindet d, SHSHARETYPE f where a.ref_slipno = b.payoutslip_no and b.slipclear_no = c.payinslip_no and c.payinslip_no = d.payinslip_no and f.sharetype_code = d.shrlontype_code and d.shrlontype_code = '01' and d.slipitemtype_code = 'SHR' and a.operate_date = $P{adtm_date} and a.payment_status = 1 and a.itempaytype_code = 'LWD' group by f.SHARETYPE_CODE, f.SHARETYPE_DESC union SELECT 0 as cash_begin,0 as pay_amt , sum(slslippayindet.item_payamt ) as recv_amt, 0 as chq_begin, 0 as chq_fwd , 'รับชำระต้นเงินกู้/รับชำระดอกเบี้ยเงินกู้' FROM FINSLIP, slslippayin, slslippayindet , cmcoopmaster WHERE ( FINSLIP.ITEMPAYTYPE_CODE = slslippayin.SLIPTYPE_CODE ) and ( FINSLIP.REF_SLIPNO = slslippayin.payinslip_no ) and ( FINSLIP.coop_id = slslippayin.coop_id ) and ( slslippayin.payinslip_no = slslippayindet.payinslip_no ) and ( slslippayin.coop_id = slslippayindet.coop_id ) and ( slslippayindet.slipitemtype_code = 'MOV') AND ( ( FINSLIP.ENTRY_DATE = $P{adtm_date} ) AND ( FINSLIP.PAYMENT_STATUS = 1 ) AND ( slslippayin.slip_STATUS = 1 ) AND ( FINSLIP.RECEIVE_STATUS = 1 ) AND (slslippayindet.item_payamt > 0 ) and (cmcoopmaster.coop_id = finslip.coop_id) AND ( FINSLIP.COOP_ID like $P{coop_id}) AND ( FINSLIP.FROM_SYSTEM in ( $P{as_type} ) ) AND ( FINSLIP.PAY_RECV_STATUS = 1 ) ) union SELECT 0 as cash_begin,0 as pay_amt , sum( slslippayindet.ITEM_PAYAMT ) as recv_amt, 0 as chq_begin, 0 as chq_fwd , 'รับชำระค่าหุ้น' FROM FINSLIP, slslippayin, slslippayindet, SHSHARETYPE , cmcoopmaster WHERE ( FINSLIP.ITEMPAYTYPE_CODE = slslippayin.SLIPTYPE_CODE ) and ( FINSLIP.REF_SLIPNO = slslippayin.payinslip_no ) and ( FINSLIP.coop_id = slslippayin.coop_id ) and ( slslippayin.payinslip_no = slslippayindet.payinslip_no ) and ( slslippayin.coop_id = slslippayindet.coop_id ) and ( slslippayindet.SHRLONTYPE_CODE = SHSHARETYPE.SHARETYPE_CODE ) and ( cmcoopmaster.coop_control = SHSHARETYPE.coop_id ) and ( slslippayindet.slipitemtype_code = 'SHR') AND ( ( FINSLIP.ENTRY_DATE = $P{adtm_date} ) AND ( FINSLIP.PAYMENT_STATUS = 1 ) AND ( FINSLIP.RECEIVE_STATUS = 1 ) AND ( slslippayin.SLIP_STATUS = 1 ) AND (slslippayindet.item_payamt > 0 ) and (cmcoopmaster.coop_id = finslip.coop_id) AND ( FINSLIP.COOP_ID like $P{coop_id}) AND ( FINSLIP.FROM_SYSTEM in ( $P{as_type}) ) AND ( FINSLIP.PAY_RECV_STATUS = 1 ) ) union SELECT 0 as cash_begin, 0 as pay_amt , sum( FINSLIPDET.TAX_AMT ) as recv_amt, 0 as chq_begin, 0 as chq_fwd , 'จ่ายการเงิน' FROM FINSLIP ,FINSLIPDET , cmcoopmaster WHERE ( FINSLIP.ENTRY_DATE = $P{adtm_date} ) AND ( FINSLIP.SLIP_NO = FINSLIPDET.SLIP_NO ) AND ( FINSLIP.coop_id = FINSLIPDET.coop_id ) AND ( FINSLIP.PAYMENT_STATUS = 1 ) AND ( FINSLIP.RECEIVE_STATUS = 1 ) AND (cmcoopmaster.coop_id = finslip.coop_id) AND ( FINSLIP.COOP_ID like $P{coop_id}) AND ( FINSLIP.FROM_SYSTEM IN ($P{as_type}) ) AND ( FINSLIP.PAY_RECV_STATUS = 0 ) AND ( FINSLIP.RETAIL_FLAG <> 3 )]]>