release 12.5;
datawindow(units=0 color=1073741824 processing=0 print.canusedefaultprinter=yes print.margin.left=110 print.margin.right=110 print.margin.top=96 print.margin.bottom=96 )
header(height=0 )
detail(height=4224 )
summary(height=0 )
footer(height=0 )
table(column=(name=slip_tdate dbname="slip_tdate" type=char(8) update=yes updatewhereclause=yes )
column=(name=operate_tdate dbname="operate_tdate" type=char(8) update=yes updatewhereclause=yes )
column=(name=payinslip_no dbname="SLSLIPPAYIN.PAYINSLIP_NO" type=char(10) key=yes update=yes updatewhereclause=yes )
column=(name=member_no dbname="SLSLIPPAYIN.MEMBER_NO" type=char(8) update=yes updatewhereclause=yes )
column=(name=document_no dbname="SLSLIPPAYIN.DOCUMENT_NO" type=char(15) update=yes updatewhereclause=yes )
column=(name=sliptype_code dbname="SLSLIPPAYIN.SLIPTYPE_CODE" type=char(3) update=yes updatewhereclause=yes )
column=(name=slip_date dbname="SLSLIPPAYIN.SLIP_DATE" type=datetime update=yes updatewhereclause=yes )
column=(name=operate_date dbname="SLSLIPPAYIN.OPERATE_DATE" type=datetime update=yes updatewhereclause=yes )
column=(name=sharestkbf_value dbname="SLSLIPPAYIN.SHARESTKBF_VALUE" type=decimal(2) update=yes updatewhereclause=yes )
column=(name=sharestk_value dbname="SLSLIPPAYIN.SHARESTK_VALUE" type=decimal(2) update=yes updatewhereclause=yes )
column=(name=intaccum_amt dbname="SLSLIPPAYIN.INTACCUM_AMT" type=decimal(2) update=yes updatewhereclause=yes )
column=(name=moneytype_code dbname="SLSLIPPAYIN.MONEYTYPE_CODE" type=char(3) update=yes updatewhereclause=yes )
column=(name=expense_bank dbname="SLSLIPPAYIN.EXPENSE_BANK" type=char(3) update=yes updatewhereclause=yes )
column=(name=expense_branch dbname="SLSLIPPAYIN.EXPENSE_BRANCH" type=char(4) update=yes updatewhereclause=yes )
column=(name=expense_accid dbname="SLSLIPPAYIN.EXPENSE_ACCID" type=char(15) update=yes updatewhereclause=yes )
column=(name=accid_flag dbname="SLSLIPPAYIN.ACCID_FLAG" type=decimal(0) update=yes updatewhereclause=yes )
column=(name=tofrom_accid dbname="SLSLIPPAYIN.TOFROM_ACCID" type=char(15) update=yes updatewhereclause=yes )
column=(name=ref_system dbname="SLSLIPPAYIN.REF_SYSTEM" type=char(15) update=yes updatewhereclause=yes )
column=(name=ref_slipno dbname="SLSLIPPAYIN.REF_SLIPNO" type=char(15) update=yes updatewhereclause=yes )
column=(name=ref_slipamt dbname="SLSLIPPAYIN.REF_SLIPAMT" type=decimal(2) update=yes updatewhereclause=yes )
column=(name=slip_amt dbname="SLSLIPPAYIN.SLIP_AMT" type=decimal(2) update=yes updatewhereclause=yes )
column=(name=slip_status dbname="SLSLIPPAYIN.SLIP_STATUS" type=decimal(0) update=yes updatewhereclause=yes )
column=(name=entry_id dbname="SLSLIPPAYIN.ENTRY_ID" type=char(32) update=yes updatewhereclause=yes )
column=(name=entry_date dbname="SLSLIPPAYIN.ENTRY_DATE" type=datetime update=yes updatewhereclause=yes )
column=(name=coop_id dbname="SLSLIPPAYIN.COOP_ID" type=char(6) key=yes update=yes updatewhereclause=yes )
column=(name=cancel_id dbname="SLSLIPPAYIN.CANCEL_ID" type=char(32) update=yes updatewhereclause=yes )
column=(name=cancel_date dbname="SLSLIPPAYIN.CANCEL_DATE" type=datetime update=yes updatewhereclause=yes )
column=(name=memcoop_id dbname="SLSLIPPAYIN.MEMCOOP_ID" type=char(6) update=yes updatewhereclause=yes )
retrieve="  SELECT '        ' as slip_tdate,   
         '        ' as operate_tdate,   
         ~"SLSLIPPAYIN~".~"PAYINSLIP_NO~",   
         ~"SLSLIPPAYIN~".~"MEMBER_NO~",   
         ~"SLSLIPPAYIN~".~"DOCUMENT_NO~",   
         ~"SLSLIPPAYIN~".~"SLIPTYPE_CODE~",   
         ~"SLSLIPPAYIN~".~"SLIP_DATE~",   
         ~"SLSLIPPAYIN~".~"OPERATE_DATE~",   
         ~"SLSLIPPAYIN~".~"SHARESTKBF_VALUE~",   
         ~"SLSLIPPAYIN~".~"SHARESTK_VALUE~",   
         ~"SLSLIPPAYIN~".~"INTACCUM_AMT~",   
         ~"SLSLIPPAYIN~".~"MONEYTYPE_CODE~",   
         ~"SLSLIPPAYIN~".~"EXPENSE_BANK~",   
         ~"SLSLIPPAYIN~".~"EXPENSE_BRANCH~",   
         ~"SLSLIPPAYIN~".~"EXPENSE_ACCID~",   
         ~"SLSLIPPAYIN~".~"ACCID_FLAG~",   
         ~"SLSLIPPAYIN~".~"TOFROM_ACCID~",   
         ~"SLSLIPPAYIN~".~"REF_SYSTEM~",   
         ~"SLSLIPPAYIN~".~"REF_SLIPNO~",   
         ~"SLSLIPPAYIN~".~"REF_SLIPAMT~",   
         ~"SLSLIPPAYIN~".~"SLIP_AMT~",   
         ~"SLSLIPPAYIN~".~"SLIP_STATUS~",   
         ~"SLSLIPPAYIN~".~"ENTRY_ID~",   
         ~"SLSLIPPAYIN~".~"ENTRY_DATE~",   
         ~"SLSLIPPAYIN~".~"COOP_ID~",   
         ~"SLSLIPPAYIN~".~"CANCEL_ID~",   
         ~"SLSLIPPAYIN~".~"CANCEL_DATE~",   
         ~"SLSLIPPAYIN~".~"MEMCOOP_ID~"  
    FROM ~"SLSLIPPAYIN~"  
   WHERE ( SLSLIPPAYIN.SLIP_DATE = :adtm_date ) AND  
   //      ( SLSLIPPAYIN.SLIPTYPE_CODE not in ( 'CLC' ,'TSL' )  ) AND  
   ( SLSLIPPAYIN.SLIPTYPE_CODE not in ( 'TSL' )  ) AND  
         ( SLSLIPPAYIN.COOP_ID = :as_coopid ) AND  
         ( SLSLIPPAYIN.MONEYTYPE_CODE = :as_money )   and  
( ( ~"SLSLIPPAYIN~".~"SLIP_STATUS~" > 0  )   and (  SLSLIPPAYIN.post_tofin <> 1 )   or
  		( ~"SLSLIPPAYIN~".~"SLIP_STATUS~" < 0 )     and (  SLSLIPPAYIN.post_tofin = 1) )
" update="SLSLIPPAYIN" updatewhere=0 arguments=(("as_coopid",string), ("as_money",string), ("adtm_date",datetime))
)
text(name=payinslip_no_t band=detail x="37" y="4" height="64" width="466" alignment="1" border="2" text="Payinslip No:" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="15780518" background.mode="2" )
text(name=member_no_t band=detail x="37" y="140" height="64" width="466" alignment="1" border="2" text="Member No:" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="15780518" background.mode="2" )
text(name=document_no_t band=detail x="37" y="276" height="64" width="466" alignment="1" border="2" text="Document No:" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="15780518" background.mode="2" )
text(name=sliptype_code_t band=detail x="37" y="412" height="64" width="466" alignment="1" border="2" text="Sliptype Code:" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="15780518" background.mode="2" )
text(name=slip_date_t band=detail x="37" y="548" height="64" width="466" alignment="1" border="2" text="Slip Date:" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="15780518" background.mode="2" )
text(name=operate_date_t band=detail x="37" y="684" height="64" width="466" alignment="1" border="2" text="Operate Date:" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="15780518" background.mode="2" )
text(name=sharestkbf_value_t band=detail x="37" y="820" height="64" width="466" alignment="1" border="2" text="Sharestkbf Value:" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="15780518" background.mode="2" )
text(name=sharestk_value_t band=detail x="37" y="956" height="64" width="466" alignment="1" border="2" text="Sharestk Value:" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="15780518" background.mode="2" )
text(name=intaccum_amt_t band=detail x="37" y="1092" height="64" width="466" alignment="1" border="2" text="Intaccum Amt:" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="15780518" background.mode="2" )
text(name=moneytype_code_t band=detail x="37" y="1228" height="64" width="466" alignment="1" border="2" text="Moneytype Code:" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="15780518" background.mode="2" )
text(name=expense_bank_t band=detail x="37" y="1364" height="64" width="466" alignment="1" border="2" text="Expense Bank:" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="15780518" background.mode="2" )
text(name=expense_branch_t band=detail x="37" y="1500" height="64" width="466" alignment="1" border="2" text="Expense Branch:" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="15780518" background.mode="2" )
text(name=expense_accid_t band=detail x="37" y="1636" height="64" width="466" alignment="1" border="2" text="Expense Accid:" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="15780518" background.mode="2" )
text(name=accid_flag_t band=detail x="37" y="1772" height="64" width="466" alignment="1" border="2" text="Accid Flag:" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="15780518" background.mode="2" )
text(name=tofrom_accid_t band=detail x="37" y="1908" height="64" width="466" alignment="1" border="2" text="Tofrom Accid:" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="15780518" background.mode="2" )
text(name=ref_opedocno_t band=detail x="37" y="2044" height="64" width="466" alignment="1" border="2" text="Ref Opedocno:" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="15780518" background.mode="2" )
text(name=ref_newcontno_t band=detail x="37" y="2180" height="64" width="466" alignment="1" border="2" text="Ref Newcontno:" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="15780518" background.mode="2" )
text(name=ref_sharetype_t band=detail x="37" y="2316" height="64" width="466" alignment="1" border="2" text="Ref Sharetype:" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="15780518" background.mode="2" )
text(name=ref_system_t band=detail x="37" y="2452" height="64" width="466" alignment="1" border="2" text="Ref System:" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="15780518" background.mode="2" )
text(name=ref_slipno_t band=detail x="37" y="2588" height="64" width="466" alignment="1" border="2" text="Ref Slipno:" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="15780518" background.mode="2" )
text(name=ref_slipamt_t band=detail x="37" y="2724" height="64" width="466" alignment="1" border="2" text="Ref Slipamt:" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="15780518" background.mode="2" )
text(name=slip_amt_t band=detail x="37" y="2860" height="64" width="466" alignment="1" border="2" text="Slip Amt:" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="15780518" background.mode="2" )
text(name=slip_status_t band=detail x="37" y="2996" height="64" width="466" alignment="1" border="2" text="Slip Status:" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="15780518" background.mode="2" )
text(name=entry_id_t band=detail x="37" y="3132" height="64" width="466" alignment="1" border="2" text="Entry Id:" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="15780518" background.mode="2" )
text(name=entry_date_t band=detail x="37" y="3268" height="64" width="466" alignment="1" border="2" text="Entry Date:" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="15780518" background.mode="2" )
text(name=cancel_id_t band=detail x="37" y="3404" height="64" width="466" alignment="1" border="2" text="Cancel Id:" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="15780518" background.mode="2" )
text(name=cancel_date_t band=detail x="37" y="3540" height="64" width="466" alignment="1" border="2" text="Cancel Date:" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="15780518" background.mode="2" )
text(name=posttovc_flag_t band=detail x="37" y="3676" height="64" width="466" alignment="1" border="2" text="Posttovc Flag:" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="15780518" background.mode="2" )
text(name=voucher_no_t band=detail x="37" y="3812" height="64" width="466" alignment="1" border="2" text="Voucher No:" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="15780518" background.mode="2" )
text(name=canceltovc_flag_t band=detail x="37" y="3948" height="64" width="466" alignment="1" border="2" text="Canceltovc Flag:" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="15780518" background.mode="2" )
text(name=cancelvc_no_t band=detail x="37" y="4084" height="64" width="466" alignment="1" border="2" text="Cancelvc No:" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="15780518" background.mode="2" )
column(name=payinslip_no band=detail x="521" y="4" height="76" width="603" id=3 border="2" alignment="0" format="[general]" tabsequence=10 font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="536870912" background.mode="1" edit.autohscroll=yes edit.focusrectangle=no edit.limit=10 )
column(name=operate_date band=detail x="521" y="684" height="76" width="603" id=8 border="2" alignment="0" format="[shortdate] [time]" tabsequence=60 font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="536870912" background.mode="1" edit.autohscroll=yes edit.focusrectangle=no )
column(name=sharestkbf_value band=detail x="521" y="820" height="76" width="603" id=9 border="2" alignment="1" format="[general]" tabsequence=70 font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="536870912" background.mode="1" edit.autohscroll=yes edit.focusrectangle=no )
column(name=sharestk_value band=detail x="521" y="956" height="76" width="603" id=10 border="2" alignment="1" format="[general]" tabsequence=80 font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="536870912" background.mode="1" edit.autohscroll=yes edit.focusrectangle=no )
column(name=intaccum_amt band=detail x="521" y="1092" height="76" width="603" id=11 border="2" alignment="1" format="[general]" tabsequence=90 font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="536870912" background.mode="1" edit.autohscroll=yes edit.focusrectangle=no )
column(name=moneytype_code band=detail x="521" y="1228" height="76" width="603" id=12 border="2" alignment="0" format="[general]" tabsequence=100 font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="536870912" background.mode="1" edit.autohscroll=yes edit.focusrectangle=no edit.limit=3 )
column(name=expense_bank band=detail x="521" y="1364" height="76" width="603" id=13 border="2" alignment="0" format="[general]" tabsequence=110 font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="536870912" background.mode="1" edit.autohscroll=yes edit.focusrectangle=no edit.limit=3 )
column(name=expense_branch band=detail x="521" y="1500" height="76" width="603" id=14 border="2" alignment="0" format="[general]" tabsequence=120 font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="536870912" background.mode="1" edit.autohscroll=yes edit.focusrectangle=no edit.limit=4 )
column(name=expense_accid band=detail x="521" y="1636" height="76" width="603" id=15 border="2" alignment="0" format="[general]" tabsequence=130 font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="536870912" background.mode="1" edit.autohscroll=yes edit.focusrectangle=no edit.limit=15 )
column(name=accid_flag band=detail x="521" y="1772" height="76" width="603" id=16 border="2" alignment="1" format="[general]" tabsequence=140 font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="536870912" background.mode="1" edit.autohscroll=yes edit.focusrectangle=no )
column(name=tofrom_accid band=detail x="521" y="1908" height="76" width="603" id=17 border="2" alignment="0" format="[general]" tabsequence=150 font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="536870912" background.mode="1" edit.autohscroll=yes edit.focusrectangle=no edit.limit=15 )
column(name=ref_system band=detail x="521" y="2452" height="76" width="603" id=18 border="2" alignment="0" format="[general]" tabsequence=190 font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="536870912" background.mode="1" edit.autohscroll=yes edit.focusrectangle=no edit.limit=15 )
column(name=ref_slipno band=detail x="521" y="2588" height="76" width="603" id=19 border="2" alignment="0" format="[general]" tabsequence=200 font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="536870912" background.mode="1" edit.autohscroll=yes edit.focusrectangle=no edit.limit=15 )
column(name=ref_slipamt band=detail x="521" y="2724" height="76" width="603" id=20 border="2" alignment="1" format="[general]" tabsequence=210 font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="536870912" background.mode="1" edit.autohscroll=yes edit.focusrectangle=no )
column(name=slip_amt band=detail x="521" y="2860" height="76" width="603" id=21 border="2" alignment="1" format="[general]" tabsequence=220 font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="536870912" background.mode="1" edit.autohscroll=yes edit.focusrectangle=no )
column(name=slip_status band=detail x="521" y="2996" height="76" width="603" id=22 border="2" alignment="1" format="[general]" tabsequence=230 font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="536870912" background.mode="1" edit.autohscroll=yes edit.focusrectangle=no )
column(name=entry_id band=detail x="521" y="3132" height="76" width="603" id=23 border="2" alignment="0" format="[general]" tabsequence=240 font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="536870912" background.mode="1" edit.autohscroll=yes edit.focusrectangle=no edit.limit=32 )
column(name=entry_date band=detail x="521" y="3268" height="76" width="603" id=24 border="2" alignment="0" format="[shortdate] [time]" tabsequence=250 font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="536870912" background.mode="1" edit.autohscroll=yes edit.focusrectangle=no )
column(name=cancel_id band=detail x="521" y="3404" height="76" width="603" id=26 border="2" alignment="0" format="[general]" tabsequence=260 font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="536870912" background.mode="1" edit.autohscroll=yes edit.focusrectangle=no edit.limit=32 )
column(name=cancel_date band=detail x="521" y="3540" height="76" width="603" id=27 border="2" alignment="0" format="[shortdate] [time]" tabsequence=270 font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="536870912" background.mode="1" edit.autohscroll=yes edit.focusrectangle=no )
column(name=slip_date band=detail x="521" y="548" height="76" width="603" id=7 border="2" alignment="0" format="[shortdate] [time]" tabsequence=50 font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="536870912" background.mode="1" edit.autohscroll=yes edit.focusrectangle=no )
column(name=member_no band=detail x="521" y="140" height="76" width="603" id=4 border="2" alignment="0" format="[general]" tabsequence=20 font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="536870912" background.mode="1" edit.autohscroll=yes edit.focusrectangle=no edit.limit=6 )
column(name=document_no band=detail x="521" y="276" height="76" width="603" id=5 border="2" alignment="0" format="[general]" tabsequence=30 font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="536870912" background.mode="1" edit.autohscroll=yes edit.focusrectangle=no edit.limit=15 )
column(name=sliptype_code band=detail x="521" y="412" height="76" width="603" id=6 border="2" alignment="0" format="[general]" tabsequence=40 font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="536870912" background.mode="1" edit.autohscroll=yes edit.focusrectangle=no edit.limit=3 )
column(name=slip_tdate band=detail x="1422" y="188" height="64" width="850" id=1 border="2" alignment="0" format="[general]" tabsequence=370 font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="536870912" background.mode="1" edit.autoselect=no edit.focusrectangle=no )
column(name=operate_tdate band=detail x="1422" y="280" height="64" width="850" id=2 border="2" alignment="0" format="[general]" tabsequence=380 font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="536870912" background.mode="1" edit.autoselect=no edit.focusrectangle=no )
column(name=coop_id band=detail x="1422" y="372" height="64" width="850" id=25 border="2" alignment="0" format="[general]" tabsequence=420 font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="536870912" background.mode="1" edit.autoselect=no edit.focusrectangle=no )
column(name=memcoop_id band=detail x="1417" y="452" height="64" width="850" id=28 border="2" alignment="0" format="[general]" tabsequence=430 font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="536870912" background.mode="1" edit.autoselect=no edit.focusrectangle=no )