$PBExportHeader$dw_rp_outware_sale_edit_ls.srd
release 9;
datawindow(units=1 timer_interval=60000 color=16777215 processing=0 HTMLDW=no print.printername="" print.documentname="" print.orientation = 0 print.margin.left = 24 print.margin.right = 24 print.margin.top = 24 print.margin.bottom = 24 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 )
header(height=37 color="536870912" )
summary(height=114 color="536870912" )
footer(height=0 color="536870912" )
detail(height=30 color="536870912"  height.autosize=yes)
table(column=(type=long updatewhereclause=yes name=u_outware_outwareid dbname="u_outware.outwareid" initial="null" values="单据ID	/" )
 column=(type=datetime updatewhereclause=yes name=u_outware_outdate dbname="u_outware.outdate" initial="null" values="出仓时间	/" )
 column=(type=char(10) updatewhereclause=yes name=u_outware_outrep dbname="u_outware.outrep" initial="null" values="业务员	/" )
 column=(type=char(50) updatewhereclause=yes name=u_outware_part dbname="u_outware.part" initial="null" values="相关号码	/" )
 column=(type=char(255) updatewhereclause=yes name=u_outware_dscrp dbname="u_outware.dscrp" initial="null" values="备注	/" )
 column=(type=char(50) updatewhereclause=yes name=u_cust_name dbname="u_cust.name" initial="null" values="客户名称	/" )
 column=(type=char(20) updatewhereclause=yes name=u_outware_outwarecode dbname="u_outware.outwarecode" initial="null" )
 column=(type=datetime updatewhereclause=yes name=u_outware_opdate dbname="u_outware.opdate" initial="null" )
 column=(type=char(10) updatewhereclause=yes name=u_outware_opemp dbname="u_outware.opemp" initial="null" )
 column=(type=datetime updatewhereclause=yes name=u_outware_auditingdate dbname="u_outware.auditingdate" initial="null" values="审核时间	/" )
 column=(type=long updatewhereclause=yes name=u_outware_flag dbname="u_outware.flag" initial="null" values="审核标志	/" )
 column=(type=char(10) updatewhereclause=yes name=u_outware_auditingrep dbname="u_outware.auditingrep" initial="null" values="审核人	/" )
 column=(type=long updatewhereclause=yes name=u_outware_cusid dbname="u_outware.cusid" initial="null" values="客户id	/" )
 column=(type=long updatewhereclause=yes name=u_outware_balcflag dbname="u_outware.balcflag" initial="null" values="日结标记	/" )
 column=(type=char(20) updatewhereclause=yes name=u_cust_cuscode dbname="u_cust.cuscode" initial="null" values="客户编号	/" )
 column=(type=char(100) updatewhereclause=yes name=u_cust_tele dbname="u_cust.tele" initial="null" values="联系电话	/" )
 column=(type=char(255) updatewhereclause=yes name=u_cust_address dbname="u_cust.address" initial="null" values="地址	/" )
 column=(type=long updatewhereclause=yes name=u_outware_relid dbname="u_outware.relid" initial="null" values="相关ID	/" )
 column=(type=long updatewhereclause=yes name=u_outware_relint_1 dbname="u_outware.relint_1" initial="null" values="结算方式ID	/" )
 column=(type=char(50) updatewhereclause=yes name=u_outware_relstr_1 dbname="u_outware.relstr_1" initial="null" values="货运部	/" )
 column=(type=char(50) updatewhereclause=yes name=u_outware_relstr_2 dbname="u_outware.relstr_2" initial="null" values="电话	/" )
 column=(type=long updatewhereclause=yes name=u_outware_printnum dbname="u_outware.printnum" initial="null" values="打印次数	/" )
 column=(type=decimal(5) updatewhereclause=yes name=u_outware_totalamt dbname="u_outware.totalamt" initial="null" )
 column=(type=decimal(2) updatewhereclause=yes name=score dbname="score" initial="null" )
 column=(type=decimal(5) updatewhereclause=yes name=backamt dbname="backamt" initial="null" )
 column=(type=decimal(6) updatewhereclause=yes name=billscore dbname="billscore" initial="null" )
 retrieve="SELECT u_outware.outwareid,   
         u_outware.outdate,   
         u_outware.outrep,   
         u_outware.part,   
         u_outware.dscrp,   
         u_cust.name,   
         u_outware.outwarecode,   
         u_outware.opdate,     
         u_outware.opemp,   
         u_outware.auditingdate,   
         u_outware.flag,   
         u_outware.auditingrep,   
         u_outware.cusid,    
         u_outware.balcflag,   
         u_cust.cuscode,
         u_cust.tele,
         u_cust.address,
			u_outware.relid,
			u_outware.relint_1,   
			u_outware.relstr_1,
			u_outware.relstr_2,
			u_outware.printnum,
			u_outware.totalamt,
			score = case when u_cust.lsflag = 1 then null else u_cust.score end ,
			u_outware.getamt - u_outware.totalamt as backamt ,
			u_cust_member.scoretype * u_outware.totalamt as billscore
    FROM u_cust left outer join u_cust_member on
			u_cust_member.memberid = u_cust.memberid and u_cust.lsflag = 0 ,   
         u_outware 
   WHERE ( u_cust.cusid = u_outware.cusid ) and  
         ( u_outware.billtype = 1 ) AND  
         ( u_outware.outwareid = :arg_outwareid )  and 
         ( u_outware.scid = :arg_scid )  and 
         ( :arg_printrow = :arg_printrow ) and
			( :arg_top = :arg_top )

" arguments=(("arg_scid", number),("arg_outwareid", number),("arg_printrow", number),("arg_top", number)) )
text(band=header alignment="2" text="" border="4" color="0" x="54" y="7" height="27" width="260" html.valueishtml="0"  name=title visible="1"  resizeable=1  moveable=1  font.face="宋体" font.height="-18" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
report(band=detail dataobject="dw_rp_outwaremx_sale_index_ls" x="6" y="2" height="25" width="384" border="0"  height.autosize=yes criteria="" nest_arguments=((" arg_scid "),(" arg_outwareid "),(" arg_printrow "),(" arg_top ")) trail_footer = yes  name=mxreport visible="1"  slideleft=yes  slideup=directlyabove )
column(band=summary id=8 alignment="0" tabsequence=32766 border="0" color="33554432" x="234" y="6" height="16" width="125" format="[shortdate] [time]" html.valueishtml="0"  name=u_outware_opdate  tag="u_outware_opdate" visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" )
text(band=summary alignment="0" text="操作时间:" border="0" color="0" x="180" y="7" height="14" width="52" html.valueishtml="0"  name=t_2 visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
column(band=summary id=7 alignment="0" tabsequence=32766 border="0" color="0" x="65" y="5" height="15" width="98" format="[general]" html.valueishtml="0"  name=u_outware_outwarecode  tag="u_outware_outwarecode" visible="1"  resizeable=1  moveable=1 edit.limit=20 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="宋体" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
text(band=summary alignment="0" text="流水号:" border="0" color="0" x="6" y="5" height="15" width="57" html.valueishtml="0"  name=u_outware_outwarecode_t visible="1"  moveable=1  font.face="宋体" font.height="-10" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
text(band=summary alignment="0" text="实收金额:" border="0" color="0" x="180" y="23" height="14" width="63" html.valueishtml="0"  name=t_3 visible="1"  font.face="宋体" font.height="-10" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
column(band=summary id=9 alignment="0" tabsequence=32766 border="0" color="33554432" x="62" y="23" height="14" width="74" format="[general]" html.valueishtml="0"  name=u_outware_opemp  tag="u_outware_opemp" visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" )
text(band=summary alignment="0" text="收银员：" border="0" color="0" x="6" y="23" height="14" width="54" html.valueishtml="0"  name=t_1 visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
text(band=summary alignment="0" text="找回金额：" border="0" color="0" x="180" y="41" height="15" width="67" html.valueishtml="0"  name=t_4 visible="1"  font.face="宋体" font.height="-10" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
text(band=summary alignment="0" text="当前积分：" border="0" color="0" x="6" y="41" height="15" width="59" html.valueishtml="0"  name=t_5 visible="1"  font.face="宋体" font.height="-10" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
text(band=summary alignment="0" text="谢谢惠顾！" border="0" color="0" x="180" y="60" height="15" width="62" html.valueishtml="0"  name=t_7 visible="1"  font.face="宋体" font.height="-10" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
text(band=summary alignment="0" text="本单积分：" border="0" color="0" x="6" y="60" height="15" width="60" html.valueishtml="0"  name=t_6 visible="1"  font.face="宋体" font.height="-10" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
text(band=summary alignment="0" text="地址：" border="0" color="0" x="6" y="95" height="14" width="42" html.valueishtml="0"  name=t_8 visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
text(band=summary alignment="0" text="电话：" border="0" color="0" x="6" y="78" height="14" width="36" html.valueishtml="0"  name=t_9 visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
column(band=summary id=24 alignment="0" tabsequence=32766 border="0" color="33554432" x="68" y="42" height="14" width="69" format="##,##0.####" html.valueishtml="0"  name=score  tag="score" visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" )
column(band=summary id=25 alignment="0" tabsequence=32766 border="0" color="33554432" x="251" y="42" height="14" width="87" format="##,##0.00##" html.valueishtml="0"  name=backamt  tag="backamt" visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" )
column(band=summary id=23 alignment="0" tabsequence=32766 border="0" color="33554432" x="251" y="25" height="14" width="86" format="##,##0.00##" html.valueishtml="0"  name=u_outware_totalamt  tag="u_outware_totalamt" visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" )
column(band=summary id=26 alignment="0" tabsequence=32766 border="0" color="33554432" x="69" y="60" height="14" width="86" format="##,##0.####" html.valueishtml="0"  name=billscore  tag="billscore" visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" )
compute(band=summary alignment="0" expression="f_sys_customer_tel()"border="0" color="33554432" x="46" y="78" height="14" width="317" format="[GENERAL]" html.valueishtml="0"  name=compute_1  tag="f_sys_customer_tel()" visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" )
htmltable(border="0" )
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" )