123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132 |
- $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" )
|