$PBExportHeader$dw_outware_pos_hisbill.srd release 9; datawindow(units=0 timer_interval=0 color=1073741824 processing=1 HTMLDW=no print.printername="" print.documentname="" print.orientation = 0 print.margin.left = 110 print.margin.right = 110 print.margin.top = 96 print.margin.bottom = 96 print.paper.source = 0 print.paper.size = 0 print.canusedefaultprinter=yes print.prompt=no print.buttons=no print.preview.buttons=no print.cliptext=no print.overrideprintjob=no print.collate=yes hidegrayline=no grid.lines=0 ) header(height=80 color="536870912" ) summary(height=0 color="536870912" ) footer(height=0 color="536870912" ) detail(height=80 color="536870912" ) table(column=(type=long update=yes updatewhereclause=yes key=yes name=scid dbname="u_outware.scid" ) column=(type=long update=yes updatewhereclause=yes key=yes name=outwareid dbname="u_outware.outwareid" ) column=(type=char(20) update=yes updatewhereclause=yes name=outwarecode dbname="u_outware.outwarecode" ) column=(type=long update=yes updatewhereclause=yes name=billtype dbname="u_outware.billtype" ) column=(type=long update=yes updatewhereclause=yes name=relid dbname="u_outware.relid" ) column=(type=long update=yes updatewhereclause=yes name=storageid dbname="u_outware.StorageID" ) column=(type=datetime update=yes updatewhereclause=yes name=opdate dbname="u_outware.opdate" ) column=(type=char(10) update=yes updatewhereclause=yes name=opemp dbname="u_outware.opemp" ) column=(type=char(10) update=yes updatewhereclause=yes name=modemp dbname="u_outware.Modemp" ) column=(type=datetime update=yes updatewhereclause=yes name=moddate dbname="u_outware.moddate" ) column=(type=long update=yes updatewhereclause=yes name=flag dbname="u_outware.flag" ) column=(type=datetime update=yes updatewhereclause=yes name=auditingdate dbname="u_outware.auditingdate" ) column=(type=char(10) update=yes updatewhereclause=yes name=auditingrep dbname="u_outware.auditingrep" ) column=(type=datetime update=yes updatewhereclause=yes name=outdate dbname="u_outware.outdate" ) column=(type=char(10) update=yes updatewhereclause=yes name=outrep dbname="u_outware.outrep" ) column=(type=char(50) update=yes updatewhereclause=yes name=part dbname="u_outware.part" ) column=(type=char(255) update=yes updatewhereclause=yes name=dscrp dbname="u_outware.dscrp" ) column=(type=long update=yes updatewhereclause=yes name=cusid dbname="u_outware.cusid" ) column=(type=char(30) update=yes updatewhereclause=yes name=cusname dbname="u_outware.cusname" ) column=(type=long update=yes updatewhereclause=yes name=balcflag dbname="u_outware.balcflag" ) column=(type=long update=yes updatewhereclause=yes name=balcdateint dbname="u_outware.balcdateint" ) column=(type=long update=yes updatewhereclause=yes name=thflag dbname="u_outware.thflag" ) column=(type=long update=yes updatewhereclause=yes name=secflag dbname="u_outware.secflag" ) column=(type=datetime update=yes updatewhereclause=yes name=secauditingdate dbname="u_outware.secauditingdate" ) column=(type=char(10) update=yes updatewhereclause=yes name=secauditingrep dbname="u_outware.secauditingrep" ) column=(type=datetime update=yes updatewhereclause=yes name=sys_changetime dbname="u_outware.sys_changetime" ) column=(type=long update=yes updatewhereclause=yes name=ctmint dbname="u_outware.ctmint" ) column=(type=long update=yes updatewhereclause=yes name=printnum dbname="u_outware.printnum" ) column=(type=long update=yes updatewhereclause=yes name=wagemth dbname="u_outware.wagemth" ) column=(type=decimal(2) update=yes updatewhereclause=yes name=otheramt dbname="u_outware.otheramt" ) column=(type=char(50) update=yes updatewhereclause=yes name=relstr_1 dbname="u_outware.relstr_1" ) column=(type=char(50) update=yes updatewhereclause=yes name=relstr_2 dbname="u_outware.relstr_2" ) column=(type=char(50) update=yes updatewhereclause=yes name=relstr_3 dbname="u_outware.relstr_3" ) column=(type=long update=yes updatewhereclause=yes name=relint_1 dbname="u_outware.relint_1" ) column=(type=long update=yes updatewhereclause=yes name=relint_2 dbname="u_outware.relint_2" ) column=(type=long update=yes updatewhereclause=yes name=relint_3 dbname="u_outware.relint_3" ) column=(type=long update=yes updatewhereclause=yes name=priceflag dbname="u_outware.priceflag" ) column=(type=datetime update=yes updatewhereclause=yes name=pricedate dbname="u_outware.pricedate" ) column=(type=char(20) update=yes updatewhereclause=yes name=priceemp dbname="u_outware.priceemp" ) column=(type=char(4099) update=yes updatewhereclause=yes name=rel_address dbname="rel_address" ) column=(type=char(100) update=yes updatewhereclause=yes name=rel_tele dbname="u_outware.rel_tele" ) column=(type=char(100) update=yes updatewhereclause=yes name=rel_fax dbname="u_outware.rel_fax" ) column=(type=char(30) update=yes updatewhereclause=yes name=rel_rep dbname="u_outware.rel_rep" ) column=(type=decimal(5) update=yes updatewhereclause=yes name=mrate dbname="u_outware.mrate" ) column=(type=long update=yes updatewhereclause=yes name=relid_incase dbname="u_outware.relid_incase" ) column=(type=long update=yes updatewhereclause=yes name=lsflag dbname="u_outware.lsflag" ) column=(type=decimal(5) update=yes updatewhereclause=yes name=totalamt dbname="u_outware.totalamt" ) column=(type=decimal(5) update=yes updatewhereclause=yes name=getamt dbname="u_outware.getamt" ) column=(type=decimal(5) updatewhereclause=yes name=backamt dbname="backamt" ) retrieve=" SELECT u_outware.scid, u_outware.outwareid, u_outware.outwarecode, u_outware.billtype, u_outware.relid, u_outware.StorageID, u_outware.opdate, u_outware.opemp, u_outware.Modemp, u_outware.moddate, u_outware.flag, u_outware.auditingdate, u_outware.auditingrep, u_outware.outdate, u_outware.outrep, u_outware.part, u_outware.dscrp, u_outware.cusid, u_outware.cusname, u_outware.balcflag, u_outware.balcdateint, u_outware.thflag, u_outware.secflag, u_outware.secauditingdate, u_outware.secauditingrep, u_outware.sys_changetime, u_outware.ctmint, u_outware.printnum, u_outware.wagemth, u_outware.otheramt, u_outware.relstr_1, u_outware.relstr_2, u_outware.relstr_3, u_outware.relint_1, u_outware.relint_2, u_outware.relint_3, u_outware.priceflag, u_outware.pricedate, u_outware.priceemp, convert (text,u_outware.rel_address) as rel_address, u_outware.rel_tele, u_outware.rel_fax, u_outware.rel_rep, u_outware.mrate, u_outware.relid_incase, u_outware.lsflag, u_outware.totalamt, u_outware.getamt, getamt - totalamt as backamt FROM u_outware WHERE ( u_outware.billtype = 1 ) AND ( u_outware.thflag = 0 ) AND (u_outware.opemp = :arg_emp OR :arg_emp = '') AND (u_outware.outdate >= :arg_firstdate) AND (u_outware.outdate <= :arg_enddate) AND (u_outware.lsflag = 1 ) and (u_outware.scid = :arg_scid) " update="u_outware" updatewhere=1 updatekeyinplace=no arguments=(("arg_scid", number),("arg_emp", string),("arg_firstdate", datetime),("arg_enddate", datetime)) ) text(band=header alignment="2" text="单据号码" border="0" color="33554432" x="9" y="8" height="68" width="576" html.valueishtml="0" name=outwarecode_t visible="1" font.face="宋体" font.height="-11" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" ) text(band=header alignment="2" text="建立时间" border="0" color="33554432" x="594" y="8" height="68" width="603" html.valueishtml="0" name=opdate_t visible="1" font.face="宋体" font.height="-11" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" ) text(band=header alignment="2" text="建立人" border="0" color="33554432" x="2281" y="8" height="68" width="384" html.valueishtml="0" name=opemp_t visible="1" font.face="宋体" font.height="-11" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" ) text(band=header alignment="2" text="修改人" border="0" color="33554432" x="3287" y="8" height="68" width="302" html.valueishtml="0" name=modemp_t visible="1" font.face="宋体" font.height="-11" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" ) text(band=header alignment="2" text="修改日期" border="0" color="33554432" x="2674" y="8" height="68" width="603" html.valueishtml="0" name=moddate_t visible="1" font.face="宋体" font.height="-11" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" ) text(band=header alignment="2" text="应收" border="0" color="33554432" x="1207" y="8" height="68" width="329" html.valueishtml="0" name=totalamt_t visible="1" font.face="宋体" font.height="-11" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" ) text(band=header alignment="2" text="实收" border="0" color="33554432" x="1545" y="8" height="68" width="329" html.valueishtml="0" name=getamt_t visible="1" font.face="宋体" font.height="-11" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" ) text(band=header alignment="2" text="找回" border="0" color="33554432" x="1883" y="8" height="68" width="389" html.valueishtml="0" name=backamt_t visible="1" font.face="宋体" font.height="-11" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" ) column(band=detail id=3 alignment="0" tabsequence=32766 border="0" color="33554432" x="9" y="4" height="72" width="576" format="[general]" html.valueishtml="0" name=outwarecode tag="单据编号" visible="1" edit.limit=20 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-11" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" ) column(band=detail id=7 alignment="0" tabsequence=32766 border="0" color="33554432" x="594" y="4" height="72" width="603" format="yyyy-mm-dd hh:mm" html.valueishtml="0" name=opdate tag="建立时间" visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-11" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" ) column(band=detail id=8 alignment="0" tabsequence=32766 border="0" color="33554432" x="2281" y="4" height="72" width="384" format="[general]" html.valueishtml="0" name=opemp tag="建立操作员" visible="1" edit.limit=10 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-11" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" ) column(band=detail id=9 alignment="0" tabsequence=32766 border="0" color="33554432" x="3287" y="4" height="72" width="302" format="[general]" html.valueishtml="0" name=modemp tag="修改人" visible="1" edit.limit=10 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-11" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" ) column(band=detail id=10 alignment="0" tabsequence=32766 border="0" color="33554432" x="2674" y="4" height="72" width="603" format="[shortdate] [time]" html.valueishtml="0" name=moddate tag="修改日期" visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-11" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" ) column(band=detail id=47 alignment="1" tabsequence=32766 border="0" color="33554432" x="1207" y="4" height="72" width="329" format="#,##0.00" html.valueishtml="0" name=totalamt visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-11" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" ) column(band=detail id=48 alignment="1" tabsequence=32766 border="0" color="33554432" x="1545" y="4" height="72" width="329" format="#,##0.00" html.valueishtml="0" name=getamt visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-11" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" ) column(band=detail id=49 alignment="0" tabsequence=32766 border="0" color="33554432" x="1883" y="4" height="72" width="389" format="#,##0.00" html.valueishtml="0" name=backamt visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0 font.face="宋体" font.height="-11" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" ) htmltable(border="1" ) htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1" clientformatting="0" clientscriptable="0" generatejavascript="1" encodeselflinkargs="1" netscapelayers="0" ) export.xml(headgroups="1" includewhitespace="0" metadatatype=0 savemetadata=0 ) import.xml() export.pdf(method=0 distill.custompostscript="0" xslfop.print="0" )