$PBExportHeader$dw_inwaremx_buy_mod_price.srd
release 9;
datawindow(units=0 timer_interval=0 color=16777215 processing=0 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 )
summary(height=0 color="536870912" )
footer(height=0 color="536870912" )
detail(height=728 color="536870912" )
table(column=(type=long updatewhereclause=yes name=u_inwaremx_mtrlid dbname="u_inwaremx.mtrlid" )
 column=(type=long updatewhereclause=yes name=u_inwaremx_ifrel dbname="u_inwaremx.ifrel" )
 column=(type=char(30) updatewhereclause=yes name=u_mtrldef_mtrlcode dbname="u_mtrldef.mtrlcode" )
 column=(type=char(30) updatewhereclause=yes name=u_inwaremx_unit dbname="u_inwaremx.unit" )
 column=(type=decimal(5) updatewhereclause=yes name=u_inwaremx_uqty dbname="u_inwaremx.uqty" )
 column=(type=decimal(10) updatewhereclause=yes name=u_inwaremx_uprice dbname="u_inwaremx.uprice" )
 column=(type=decimal(4) updatewhereclause=yes name=u_inwaremx_rebate dbname="u_inwaremx.rebate" )
 column=(type=char(255) updatewhereclause=yes name=u_inwaremx_status dbname="u_inwaremx.status" )
 column=(type=char(255) updatewhereclause=yes name=u_inwaremx_woodcode dbname="u_inwaremx.woodcode" )
 column=(type=char(255) updatewhereclause=yes name=u_inwaremx_pcode dbname="u_inwaremx.pcode" )
 column=(type=char(30) updatewhereclause=yes name=u_inwaremx_plancode dbname="u_inwaremx.plancode" )
 column=(type=char(255) updatewhereclause=yes name=u_inwaremx_mxdscrp dbname="u_inwaremx.mxdscrp" )
 column=(type=decimal(10) updatewhereclause=yes name=u_inwaremx_fprice dbname="u_inwaremx.fprice" )
 column=(type=decimal(5) updatewhereclause=yes name=u_inwaremx_rate dbname="u_inwaremx.rate" )
 column=(type=decimal(4) updatewhereclause=yes name=u_inwaremx_qty dbname="u_inwaremx.qty" )
 column=(type=decimal(10) updatewhereclause=yes name=u_inwaremx_price dbname="u_inwaremx.price" )
 column=(type=char(50) updatewhereclause=yes name=u_inwaremx_relcode dbname="u_inwaremx.relcode" )
 column=(type=char(10) updatewhereclause=yes name=u_mtrldef_unit dbname="u_mtrldef.unit" )
 column=(type=char(50) updatewhereclause=yes name=u_mtrldef_mtrlname dbname="u_mtrldef.mtrlname" )
 column=(type=char(255) updatewhereclause=yes name=u_mtrldef_dscrp dbname="u_mtrldef.dscrp" )
 column=(type=long updatewhereclause=yes name=u_inwaremx_inwareid dbname="u_inwaremx.inwareid" )
 column=(type=long updatewhereclause=yes name=u_inwaremx_printid dbname="u_inwaremx.printid" )
 column=(type=char(30) updatewhereclause=yes name=u_mtrldef_mtrlmode dbname="u_mtrldef.mtrlmode" )
 column=(type=char(30) updatewhereclause=yes name=u_mtrldef_mtrlsectype dbname="u_mtrldef.mtrlsectype" )
 column=(type=char(50) updatewhereclause=yes name=u_mtrldef_zxmtrlmode dbname="u_mtrldef.zxmtrlmode" )
 column=(type=long updatewhereclause=yes name=u_inwaremx_relid dbname="u_inwaremx.relid" )
 column=(type=long updatewhereclause=yes name=u_inwaremx_sptid_cusid dbname="u_inwaremx.sptid_cusid" )
 column=(type=decimal(10) updatewhereclause=yes name=u_inwaremx_cost dbname="u_inwaremx.cost" )
 column=(type=char(50) updatewhereclause=yes name=u_inwaremx_sptmtrlname dbname="u_inwaremx.sptmtrlname" )
 column=(type=decimal(5) updatewhereclause=yes name=u_inwaremx_bootqty dbname="u_inwaremx.bootqty" )
 column=(type=decimal(5) updatewhereclause=yes name=u_inwaremx_noauditqty dbname="u_inwaremx.noauditqty" )
 column=(type=long updatewhereclause=yes name=u_mtrldef_statusflag dbname="u_mtrldef.statusflag" )
 column=(type=long updatewhereclause=yes name=u_mtrldef_statustype dbname="u_mtrldef.statustype" )
 column=(type=long updatewhereclause=yes name=u_mtrldef_woodcodeflag dbname="u_mtrldef.woodcodeflag" )
 column=(type=long updatewhereclause=yes name=u_mtrldef_woodcodetype dbname="u_mtrldef.woodcodetype" )
 column=(type=long updatewhereclause=yes name=u_mtrldef_pcodeflag dbname="u_mtrldef.pcodeflag" )
 column=(type=long updatewhereclause=yes name=u_mtrldef_pcodetype dbname="u_mtrldef.pcodetype" )
 column=(type=decimal(10) updatewhereclause=yes name=u_inwaremx_jgprice dbname="u_inwaremx.jgprice" )
 retrieve="  SELECT u_inwaremx.mtrlid,  
			u_inwaremx.ifrel,   
			u_mtrldef.mtrlcode,  
         u_inwaremx.unit,    
         u_inwaremx.uqty,   
         u_inwaremx.uprice,   
         u_inwaremx.rebate,   
         u_inwaremx.status ,  
         u_inwaremx.woodcode , 
         u_inwaremx.pcode , 
         u_inwaremx.plancode, 
         u_inwaremx.mxdscrp,    
         u_inwaremx.fprice,   
         u_inwaremx.rate,   
         u_inwaremx.qty,   
         u_inwaremx.price,    
			u_inwaremx.relcode ,
         u_mtrldef.unit,    
         u_mtrldef.mtrlname,   
         u_mtrldef.dscrp,   
         u_inwaremx.inwareid,   
         u_inwaremx.printid,   
         u_mtrldef.mtrlmode,    
         u_mtrldef.mtrlsectype,    
         u_mtrldef.zxmtrlmode,   
			u_inwaremx.relid ,     
			u_inwaremx.sptid_cusid,
			u_inwaremx.cost ,
			u_inwaremx.sptmtrlname  ,
			u_inwaremx.bootqty  ,
			u_inwaremx.noauditqty ,
			u_mtrldef.statusflag,
			u_mtrldef.statustype,
			u_mtrldef.woodcodeflag,
			u_mtrldef.woodcodetype,
			u_mtrldef.pcodeflag,
			u_mtrldef.pcodetype,
			u_inwaremx.jgprice
FROM u_inwaremx INNER JOIN
      u_mtrldef ON u_inwaremx.mtrlid = u_mtrldef.mtrlid 
 where u_inwaremx.scid = :arg_scid
and u_inwaremx.inwareid = :arg_inwareid
and u_inwaremx.printid = :arg_printid" arguments=(("arg_scid", number),("arg_inwareid", number),("arg_printid", number)) )
text(band=detail alignment="1" text="物料编号" border="0" color="0" x="155" y="24" height="56" width="233" html.valueishtml="0"  name=u_mtrldef_mtrlcode_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=detail alignment="1" text="配置" border="0" color="0" x="155" y="108" height="56" width="233" html.valueishtml="0"  name=u_inwaremx_status_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=detail alignment="1" text="自定义1" border="0" color="0" x="155" y="196" height="56" width="233" html.valueishtml="0"  name=u_mtrldef_mtrlsectype_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=3 alignment="0" tabsequence=32766 border="4" color="0" x="402" y="24" height="68" width="416" format="[general]" html.valueishtml="0"  name=u_mtrldef_mtrlcode visible="1" edit.limit=30 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  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="4" color="0" x="402" y="108" height="68" width="416" format="[general]" html.valueishtml="0"  name=u_inwaremx_status visible="1" edit.limit=255 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=24 alignment="0" tabsequence=32766 border="4" color="0" x="402" y="196" height="68" width="416" format="[general]" html.valueishtml="0"  name=u_mtrldef_mtrlsectype visible="1" edit.limit=30 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=19 alignment="0" tabsequence=32766 border="4" color="0" x="1102" y="24" height="68" width="425" format="[general]" html.valueishtml="0"  name=u_mtrldef_mtrlname visible="1" edit.limit=50 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=detail alignment="1" text="物料规格" border="0" color="0" x="1550" y="24" height="56" width="233" html.valueishtml="0"  name=u_mtrldef_mtrlmode_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=detail alignment="1" text="配置2" border="0" color="0" x="1550" y="108" height="56" width="233" html.valueishtml="0"  name=u_inwaremx_pcode_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=detail alignment="1" text="自定义2" border="0" color="0" x="1550" y="200" height="56" width="233" html.valueishtml="0"  name=u_mtrldef_zxmtrlmode_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=detail alignment="1" text="物料名称" border="0" color="0" x="850" y="24" height="56" width="233" html.valueishtml="0"  name=u_mtrldef_mtrlname_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=detail alignment="1" text="配置1" border="0" color="0" x="850" y="108" height="56" width="233" html.valueishtml="0"  name=u_inwaremx_woodcode_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  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="4" color="0" x="1102" y="108" height="68" width="425" format="[general]" html.valueishtml="0"  name=u_inwaremx_woodcode visible="1" edit.limit=255 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=5 alignment="1" tabsequence=32766 border="4" color="0" x="402" y="288" height="68" width="329" format="#,##0.##########" html.valueishtml="0"  name=u_inwaremx_uqty visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=detail alignment="1" text="数    量" border="0" color="0" x="155" y="288" height="56" width="233" html.valueishtml="0"  name=u_inwaremx_uqty_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=6 alignment="1" tabsequence=10 border="4" color="16711680" x="1097" y="288" height="68" width="329" format="#,##0.00########" html.valueishtml="0"  name=u_inwaremx_uprice visible="1" edit.limit=0 edit.case=any edit.format="#,##0.00########" edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=detail alignment="1" text="单    价" border="0" color="16711680" x="850" y="288" height="56" width="233" html.valueishtml="0"  name=u_inwaremx_uprice_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=11 alignment="0" tabsequence=32766 border="4" color="0" x="402" y="380" height="68" width="425" format="[general]" html.valueishtml="0"  name=u_inwaremx_plancode visible="1" edit.limit=30 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=detail alignment="1" text="批    号" border="0" color="0" x="155" y="380" height="56" width="233" html.valueishtml="0"  name=u_inwaremx_plancode_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=detail alignment="1" text="相关号码" border="0" color="0" x="850" y="380" height="56" width="233" html.valueishtml="0"  name=u_inwaremx_relcode_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=17 alignment="0" tabsequence=32766 border="4" color="0" x="1102" y="380" height="68" width="480" format="[general]" html.valueishtml="0"  name=u_inwaremx_relcode visible="1" edit.limit=50 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=15 alignment="1" tabsequence=32766 border="4" color="0" x="402" y="468" height="68" width="329" format="#,##0.##########" html.valueishtml="0"  name=u_inwaremx_qty visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=detail alignment="1" text="数量-库存单位" border="0" color="0" x="32" y="468" height="56" width="357" html.valueishtml="0"  name=u_inwaremx_qty_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=18 alignment="0" tabsequence=32766 border="4" color="0" x="1106" y="468" height="68" width="283" format="[general]" html.valueishtml="0"  name=u_mtrldef_unit visible="1" edit.limit=10 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=detail alignment="1" text="库存单位" border="0" color="0" x="855" y="468" height="56" width="233" html.valueishtml="0"  name=u_mtrldef_unit_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=13 alignment="1" tabsequence=32766 border="4" color="0" x="402" y="552" height="68" width="329" format="#,##0.00########" html.valueishtml="0"  name=u_inwaremx_fprice visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=detail alignment="1" text="单价-库存单位" border="0" color="0" x="27" y="552" height="56" width="357" html.valueishtml="0"  name=u_inwaremx_fprice_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=detail alignment="1" text="折    扣" border="0" color="0" x="855" y="556" height="56" width="219" html.valueishtml="0"  name=u_inwaremx_rebate_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=7 alignment="1" tabsequence=32766 border="4" color="0" x="1097" y="552" height="68" width="302" format="#,##0.00##" html.valueishtml="0"  name=u_inwaremx_rebate visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=12 alignment="0" tabsequence=32766 border="4" color="0" x="393" y="640" height="68" width="1911" format="[general]" html.valueishtml="0"  name=u_inwaremx_mxdscrp visible="1" edit.limit=255 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=detail alignment="1" text="明细备注" border="0" color="0" x="142" y="640" height="56" width="233" html.valueishtml="0"  name=u_inwaremx_mxdscrp_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=23 alignment="0" tabsequence=32766 border="4" color="0" x="1801" y="24" height="68" width="466" format="[general]" html.valueishtml="0"  name=u_mtrldef_mtrlmode visible="1" edit.limit=30 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  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="4" color="0" x="1801" y="108" height="68" width="466" format="[general]" html.valueishtml="0"  name=u_inwaremx_pcode visible="1" edit.limit=255 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=25 alignment="2" tabsequence=32766 border="4" color="0" x="1801" y="200" height="68" width="466" format="[general]" html.valueishtml="0"  name=u_mtrldef_zxmtrlmode visible="1" edit.limit=50 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=4 alignment="0" tabsequence=32766 border="4" color="0" x="1806" y="288" height="68" width="233" format="[general]" html.valueishtml="0"  name=u_inwaremx_unit visible="1" edit.limit=30 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=14 alignment="1" tabsequence=32766 border="4" color="0" x="1806" y="468" height="68" width="329" format="#,##0.00##" html.valueishtml="0"  name=u_inwaremx_rate visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=16 alignment="1" tabsequence=32766 border="4" color="0" x="1806" y="552" height="68" width="329" format="#,##0.00########" html.valueishtml="0"  name=u_inwaremx_price visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=detail alignment="1" text="单    位" border="0" color="0" x="1554" y="288" height="56" width="233" html.valueishtml="0"  name=u_inwaremx_unit_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=detail alignment="1" text="转换率" border="0" color="0" x="1554" y="468" height="56" width="233" html.valueishtml="0"  name=u_inwaremx_rate_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=detail alignment="1" text="实价-库存单位" border="0" color="0" x="1417" y="556" height="56" width="370" html.valueishtml="0"  name=u_inwaremx_price_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  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" )