$PBExportHeader$dw_rp_givebackmx_index.srd
release 9;
datawindow ( units=1 timer_interval=0 color=1073741824 processing=1 print.orientation=0 print.margin.left=24 print.margin.right=24 print.margin.top=24 print.margin.bottom=24 print.paper.size=0 print.paper.source=0 grid.lines=0 selected.mouse=yes)
header(height=17 color="536870912" )
summary(height=16 color="536870912" )
footer(height=0 color="536870912" )
detail(height=23 color="536870912" )
table(column=(type=datetime update=yes updatewhereclause=yes initial="null" name=givebackdate dbname="u_givebackmx.givebackdate"  )
column=(type=char(255) update=yes updatewhereclause=yes initial="null" name=mxdscrp dbname="u_givebackmx.mxDscrp"  )
column=(type=char(30) update=yes updatewhereclause=yes initial="null" name=relcode dbname="u_givebackmx.relcode"  )
column=(type=decimal(5) update=yes updatewhereclause=yes initial="null" name=childsumamt dbname="u_givebackmx.childsumamt"  )
column=(type=decimal(5) update=yes updatewhereclause=yes initial="null" name=norebateamt dbname="u_givebackmx.norebateamt"  )
column=(type=long key=yes update=yes updatewhereclause=yes initial="null" name=scid dbname="u_givebackmx.scid" 
 values="分部ID	/"  )
column=(type=long key=yes update=yes updatewhereclause=yes initial="null" name=givebackid dbname="u_givebackmx.givebackid" 
 values="返利单ID	/"  )
column=(type=long key=yes update=yes updatewhereclause=yes initial="null" name=outwareid dbname="u_givebackmx.outwareid" 
 values="发货单ID	/"  )
column=(type=long update=yes updatewhereclause=yes initial="null" name=printid dbname="u_givebackmx.printid" 
 values="序号	/"  )
 retrieve="SELECT u_givebackmx.givebackdate,  
         u_givebackmx.mxDscrp  ,  
			u_givebackmx.relcode,               
         u_givebackmx.childsumamt,
			u_givebackmx.norebateamt,
			u_givebackmx.scid,   
         u_givebackmx.givebackid,   
         u_givebackmx.outwareid,   
         u_givebackmx.printid
    FROM u_givebackmx   
where (u_givebackmx.scid=:arg_scid or :arg_scid = -1) and  
       (  u_givebackmx.givebackid=:arg_givebackid  )"
  update="u_givebackmx" updatewhere=1 updatekeyinplace=no
  arguments=(("arg_scid", number), ("arg_givebackid", number))
)
text(name=t_1 visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="2" background.color="1073741824" color="33554432" alignment="2" border="0" x="2" y="2" height="14" width="19" text="序" )
text(name=givebackdate_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="2" background.color="16777215" color="33554432" alignment="2" border="0" x="135" y="2" height="14" width="88" text="出货日期" )
text(name=mxdscrp_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="2" background.color="16777215" color="33554432" alignment="2" border="0" x="427" y="2" height="14" width="285" text="明细备注" )
text(name=relcode_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="2" background.color="1073741824" color="33554432" alignment="2" border="0" x="23" y="2" height="14" width="110" text="单据编号" )
text(name=norebateamt_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="33554432" alignment="2" border="0" x="324" y="2" height="14" width="101" text="非折扣金额" )
text(name=childsumamt_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="33554432" alignment="2" border="0" x="225" y="2" height="14" width="97" text="单据金额" )
compute(name=compute_1 visible="1" tag="count(givebackdate for all)" band=summary font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="700" background.mode="2" background.color="16777215" color="33554432" x="135" y="1" height="15" width="88" format="[general]" expression="count(givebackdate for all)" alignment="2" border="0" crosstab.repeat=no )
text(name=t_2 visible="1" band=summary font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="700" background.mode="2" background.color="1073741824" color="33554432" alignment="2" border="0" x="23" y="1" height="15" width="110" text="合计" )
compute(name=compute_2 visible="1" tag="sum(childsumamt for all)" band=summary font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="700" background.mode="1" background.color="536870912" color="33554432" x="225" y="1" height="14" width="97" format="####0.00###" expression="sum(childsumamt for all)" alignment="1" border="0" crosstab.repeat=no )
compute(name=compute_3 visible="1" tag="sum(norebateamt for all)" band=summary font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="700" background.mode="1" background.color="536870912" color="33554432" x="324" y="1" height="14" width="101" format="####0.00###" expression="sum(norebateamt for all)" alignment="1" border="0" crosstab.repeat=no )
compute(name=pid visible="1" tag="getrow()" band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="2" background.color="1073741824" color="33554432" x="2" y="3" height="17" width="19" format="[GENERAL]" expression="getrow()" alignment="2" border="0" crosstab.repeat=no )
column(name=givebackdate visible="1" tag="givebackdate" band=detail id=1 x="135" y="3" height="17" width="88" color="33554432" border="0" alignment="2" format="yyyy-mm-dd" protect="0" editmask.focusrectangle=no editmask.autoskip=no editmask.required=no editmask.readonly=no editmask.codetable=no editmask.spin=no editmask.useformat=no editmask.mask="yyyy-mm-dd" editmask.imemode=0 criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="2" background.color="16777215" font.charset="134" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=mxdscrp visible="1" tag="mxdscrp" band=detail id=2 x="427" y="3" height="17" width="285" color="33554432" border="0" alignment="0" format="[general]" protect="0" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=100 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="2" background.color="16777215" font.charset="134" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=relcode visible="1" tag="relcode" band=detail id=3 x="23" y="3" height="17" width="110" color="33554432" border="0" alignment="0" format="[general]" protect="0" edit.autohscroll=no edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=childsumamt visible="1" tag="childsumamt" band=detail id=4 x="225" y="3" height="17" width="97" color="33554432" border="0" alignment="1" format="####0.00###" protect="0" edit.format="####0.00###" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=norebateamt visible="1" tag="norebateamt" band=detail id=5 x="324" y="3" height="17" width="101" color="33554432" border="0" alignment="1" format="####0.00###" protect="0" edit.format="####0.00###" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=0 )
htmltable()
htmlgen()
export.xml(metadatatype=0 savemetadata=0 )
import.xml()
export.pdf(method=0 )