123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990 |
- $PBExportHeader$dw_xls_inwaremx_wfjg_edit_shd.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=168 color="536870912" )
- summary(height=0 color="536870912" )
- footer(height=0 color="536870912" )
- detail(height=104 color="536870912" )
- table(column=(type=char(255) updatewhereclause=yes name=ow_wfjgmx_in_aft_mxdscrp dbname="ow_wfjgmx_in_aft.mxdscrp" )
- column=(type=long updatewhereclause=yes name=ow_wfjgmx_in_aft_storageid dbname="ow_wfjgmx_in_aft.storageid" )
- column=(type=long updatewhereclause=yes name=ow_wfjgmx_in_aft_inwareid dbname="ow_wfjgmx_in_aft.inwareid" )
- column=(type=char(30) updatewhereclause=yes name=ow_wfjgmx_in_aft_plancode dbname="ow_wfjgmx_in_aft.plancode" )
- column=(type=char(255) updatewhereclause=yes name=ow_wfjgmx_in_aft_status dbname="ow_wfjgmx_in_aft.status" )
- column=(type=decimal(4) updatewhereclause=yes name=ow_wfjgmx_in_aft_qty dbname="ow_wfjgmx_in_aft.qty" )
- column=(type=decimal(10) updatewhereclause=yes name=ow_wfjgmx_in_aft_fprice dbname="ow_wfjgmx_in_aft.fprice" )
- column=(type=decimal(10) updatewhereclause=yes name=ow_wfjgmx_in_aft_price dbname="ow_wfjgmx_in_aft.price" )
- column=(type=decimal(10) updatewhereclause=yes name=ow_wfjgmx_in_aft_planprice dbname="ow_wfjgmx_in_aft.planprice" )
- column=(type=decimal(10) updatewhereclause=yes name=ow_wfjgmx_in_aft_jgprice dbname="ow_wfjgmx_in_aft.jgprice" )
- column=(type=char(255) updatewhereclause=yes name=ow_wfjgmx_in_aft_woodcode dbname="ow_wfjgmx_in_aft.woodcode" )
- column=(type=char(255) updatewhereclause=yes name=ow_wfjgmx_in_aft_pcode dbname="ow_wfjgmx_in_aft.pcode" )
- column=(type=decimal(10) updatewhereclause=yes name=ow_wfjgmx_in_aft_cost dbname="ow_wfjgmx_in_aft.cost" )
- column=(type=char(30) updatewhereclause=yes name=ow_wfjgmx_in_aft_unit dbname="ow_wfjgmx_in_aft.unit" )
- column=(type=char(30) updatewhereclause=yes name=u_mtrldef_mtrlcode dbname="u_mtrldef.mtrlcode" )
- column=(type=char(50) updatewhereclause=yes name=u_mtrldef_mtrlname dbname="u_mtrldef.mtrlname" )
- column=(type=char(30) updatewhereclause=yes name=u_mtrldef_mtrlmode dbname="u_mtrldef.mtrlmode" )
- column=(type=char(10) updatewhereclause=yes name=u_mtrldef_unit dbname="u_mtrldef.unit" )
- column=(type=char(50) updatewhereclause=yes name=u_mtrldef_zxmtrlmode dbname="u_mtrldef.zxmtrlmode" )
- column=(type=char(50) updatewhereclause=yes name=u_mtrldef_mtrlengname dbname="u_mtrldef.mtrlengname" )
- column=(type=char(30) updatewhereclause=yes name=u_mtrldef_mtrlsectype dbname="u_mtrldef.mtrlsectype" )
- column=(type=char(30) updatewhereclause=yes name=u_storage_storagename dbname="u_storage.storagename" )
- retrieve="SELECT ow_wfjgmx_in_aft.mxdscrp, ow_wfjgmx_in_aft.storageid,
- ow_wfjgmx_in_aft.inwareid, ow_wfjgmx_in_aft.plancode,
- ow_wfjgmx_in_aft.status, ow_wfjgmx_in_aft.qty, ow_wfjgmx_in_aft.fprice,
- ow_wfjgmx_in_aft.price, ow_wfjgmx_in_aft.planprice, ow_wfjgmx_in_aft.jgprice,
- ow_wfjgmx_in_aft.woodcode, ow_wfjgmx_in_aft.pcode, ow_wfjgmx_in_aft.cost,
- ow_wfjgmx_in_aft.unit, u_mtrldef.mtrlcode, u_mtrldef.mtrlname, u_mtrldef.mtrlmode,
- u_mtrldef.unit, u_mtrldef.zxmtrlmode, u_mtrldef.mtrlengname,
- u_mtrldef.mtrlsectype, u_storage.storagename
- FROM ow_wfjgmx_in_aft INNER JOIN
- u_mtrldef ON ow_wfjgmx_in_aft.mtrlid = u_mtrldef.mtrlid INNER JOIN
- u_storage ON ow_wfjgmx_in_aft.storageid = u_storage.storageid
- where ow_wfjgmx_in_aft.scid=:arg_scid and ow_wfjgmx_in_aft.inwareid=:arg_inwareid" arguments=(("arg_scid", number),("arg_inwareid", number)) )
- text(band=header alignment="2" text="明细备注" border="0" color="33554432" x="9" y="8" height="76" width="1632" html.valueishtml="0" name=ow_wfjgmx_in_aft_mxdscrp_t visible="1" font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- text(band=header alignment="2" text="" border="0" color="33554432" x="1650" y="8" height="76" width="530" html.valueishtml="0" name=ow_wfjgmx_in_aft_storageid_t visible="1" font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- text(band=header alignment="2" text="" border="0" color="33554432" x="2190" y="8" height="76" width="530" html.valueishtml="0" name=ow_wfjgmx_in_aft_inwareid_t visible="1" font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- text(band=header alignment="2" text="批号" border="0" color="33554432" x="2729" y="8" height="76" width="992" html.valueishtml="0" name=ow_wfjgmx_in_aft_plancode_t visible="1" font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- text(band=header alignment="2" text="配置" border="0" color="33554432" x="3730" y="8" height="76" width="992" html.valueishtml="0" name=ow_wfjgmx_in_aft_status_t visible="1" font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- text(band=header alignment="2" text="数量" border="0" color="33554432" x="4731" y="8" height="76" width="530" html.valueishtml="0" name=ow_wfjgmx_in_aft_qty_t visible="1" font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- text(band=header alignment="2" text="材料成本价" border="0" color="33554432" x="5271" y="8" height="76" width="530" html.valueishtml="0" name=ow_wfjgmx_in_aft_fprice_t visible="1" font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- text(band=header alignment="2" text="" border="0" color="33554432" x="5810" y="8" height="76" width="530" html.valueishtml="0" name=ow_wfjgmx_in_aft_price_t visible="1" font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- text(band=header alignment="2" text="" border="0" color="33554432" x="6350" y="8" height="76" width="530" html.valueishtml="0" name=ow_wfjgmx_in_aft_planprice_t visible="1" font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- text(band=header alignment="2" text="加工价" border="0" color="33554432" x="6889" y="8" height="76" width="530" html.valueishtml="0" name=ow_wfjgmx_in_aft_jgprice_t visible="1" font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- text(band=header alignment="2" text="配置1" border="0" color="33554432" x="7429" y="8" height="76" width="992" html.valueishtml="0" name=ow_wfjgmx_in_aft_woodcode_t visible="1" font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- text(band=header alignment="2" text="配置2" border="0" color="33554432" x="8430" y="8" height="76" width="992" html.valueishtml="0" name=ow_wfjgmx_in_aft_pcode_t visible="1" font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- text(band=header alignment="2" text="成本价" border="0" color="33554432" x="9431" y="8" height="76" width="530" html.valueishtml="0" name=ow_wfjgmx_in_aft_cost_t visible="1" font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- text(band=header alignment="2" text="单位" border="0" color="33554432" x="9970" y="8" height="76" width="992" html.valueishtml="0" name=ow_wfjgmx_in_aft_unit_t visible="1" font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- text(band=header alignment="2" text="编码" border="0" color="33554432" x="10971" y="8" height="76" width="992" html.valueishtml="0" name=u_mtrldef_mtrlcode_t visible="1" font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- text(band=header alignment="2" text="品名" border="0" color="33554432" x="11973" y="8" height="76" width="1632" html.valueishtml="0" name=u_mtrldef_mtrlname_t visible="1" font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- text(band=header alignment="2" text="规格" border="0" color="33554432" x="13614" y="8" height="76" width="992" html.valueishtml="0" name=u_mtrldef_mtrlmode_t visible="1" font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- text(band=header alignment="2" text="库存单位" border="0" color="33554432" x="14615" y="8" height="76" width="494" html.valueishtml="0" name=u_mtrldef_unit_t visible="1" font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- text(band=header alignment="2" text="自定义2" border="0" color="33554432" x="15118" y="8" height="76" width="1632" html.valueishtml="0" name=u_mtrldef_zxmtrlmode_t visible="1" font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- text(band=header alignment="2" text="" border="0" color="33554432" x="16759" y="8" height="76" width="1632" html.valueishtml="0" name=u_mtrldef_mtrlengname_t visible="1" font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- text(band=header alignment="2" text="自定义1" border="0" color="33554432" x="18400" y="8" height="76" width="992" html.valueishtml="0" name=u_mtrldef_mtrlsectype_t visible="1" font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- text(band=header alignment="2" text="仓库" border="0" color="33554432" x="19401" y="8" height="76" width="992" html.valueishtml="0" name=u_storage_storagename_t visible="1" font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- column(band=detail id=1 alignment="0" tabsequence=32766 border="0" color="33554432" x="9" y="8" height="88" width="1632" format="[general]" html.valueishtml="0" name=ow_wfjgmx_in_aft_mxdscrp visible="1" edit.limit=50 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- column(band=detail id=2 alignment="1" tabsequence=32766 border="0" color="33554432" x="1650" y="8" height="88" width="530" format="[general]" html.valueishtml="0" name=ow_wfjgmx_in_aft_storageid visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- column(band=detail id=3 alignment="1" tabsequence=32766 border="0" color="33554432" x="2190" y="8" height="88" width="530" format="[general]" html.valueishtml="0" name=ow_wfjgmx_in_aft_inwareid visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- column(band=detail id=4 alignment="0" tabsequence=32766 border="0" color="33554432" x="2729" y="8" height="88" width="992" format="[general]" html.valueishtml="0" name=ow_wfjgmx_in_aft_plancode visible="1" edit.limit=30 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- column(band=detail id=5 alignment="0" tabsequence=32766 border="0" color="33554432" x="3730" y="8" height="88" width="992" format="[general]" html.valueishtml="0" name=ow_wfjgmx_in_aft_status visible="1" edit.limit=30 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- column(band=detail id=6 alignment="1" tabsequence=32766 border="0" color="33554432" x="4731" y="8" height="88" width="530" format="[general]" html.valueishtml="0" name=ow_wfjgmx_in_aft_qty visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- column(band=detail id=7 alignment="1" tabsequence=32766 border="0" color="33554432" x="5271" y="8" height="88" width="530" format="[general]" html.valueishtml="0" name=ow_wfjgmx_in_aft_fprice visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- column(band=detail id=8 alignment="1" tabsequence=32766 border="0" color="33554432" x="5810" y="8" height="88" width="530" format="[general]" html.valueishtml="0" name=ow_wfjgmx_in_aft_price visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- column(band=detail id=9 alignment="1" tabsequence=32766 border="0" color="33554432" x="6350" y="8" height="88" width="530" format="[general]" html.valueishtml="0" name=ow_wfjgmx_in_aft_planprice visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- column(band=detail id=10 alignment="1" tabsequence=32766 border="0" color="33554432" x="6889" y="8" height="88" width="530" format="[general]" html.valueishtml="0" name=ow_wfjgmx_in_aft_jgprice visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- column(band=detail id=11 alignment="0" tabsequence=32766 border="0" color="33554432" x="7429" y="8" height="88" width="992" format="[general]" html.valueishtml="0" name=ow_wfjgmx_in_aft_woodcode visible="1" edit.limit=30 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- column(band=detail id=12 alignment="0" tabsequence=32766 border="0" color="33554432" x="8430" y="8" height="88" width="992" format="[general]" html.valueishtml="0" name=ow_wfjgmx_in_aft_pcode visible="1" edit.limit=30 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- column(band=detail id=13 alignment="1" tabsequence=32766 border="0" color="33554432" x="9431" y="8" height="88" width="530" format="[general]" html.valueishtml="0" name=ow_wfjgmx_in_aft_cost visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- column(band=detail id=14 alignment="0" tabsequence=32766 border="0" color="33554432" x="9970" y="8" height="88" width="992" format="[general]" html.valueishtml="0" name=ow_wfjgmx_in_aft_unit visible="1" edit.limit=30 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- column(band=detail id=15 alignment="0" tabsequence=32766 border="0" color="33554432" x="10971" y="8" height="88" width="992" 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="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- column(band=detail id=16 alignment="0" tabsequence=32766 border="0" color="33554432" x="11973" y="8" height="88" width="1632" 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="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- column(band=detail id=17 alignment="0" tabsequence=32766 border="0" color="33554432" x="13614" y="8" height="88" width="992" 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="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- column(band=detail id=18 alignment="0" tabsequence=32766 border="0" color="33554432" x="14615" y="8" height="88" width="494" 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="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- column(band=detail id=19 alignment="0" tabsequence=32766 border="0" color="33554432" x="15118" y="8" height="88" width="1632" 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="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- column(band=detail id=20 alignment="0" tabsequence=32766 border="0" color="33554432" x="16759" y="8" height="88" width="1632" format="[general]" html.valueishtml="0" name=u_mtrldef_mtrlengname visible="1" edit.limit=50 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- column(band=detail id=21 alignment="0" tabsequence=32766 border="0" color="33554432" x="18400" y="8" height="88" width="992" 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="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
- column(band=detail id=22 alignment="0" tabsequence=32766 border="0" color="33554432" x="19401" y="8" height="88" width="992" format="[general]" html.valueishtml="0" name=u_storage_storagename visible="1" edit.limit=30 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" 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" )
|