Q5/ws_objects/Ew_machining.pbl.src/dw_rp_owwfjg_in_spt.srd

$PBExportHeader$dw_rp_owwfjg_in_spt.srd
release 9;
datawindow(units=0 timer_interval=60000 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=264 color="536870912" )
summary(height=0 color="536870912" )
footer(height=64 color="536870912" )
detail(height=76 color="536870912" )
table(column=(type=long updatewhereclause=yes name=ow_wfjg_in_inwareid dbname="ow_wfjg_in.inwareid" )
 column=(type=long updatewhereclause=yes name=ow_wfjg_in_scid dbname="ow_wfjg_in.scid" )
 column=(type=char(30) updatewhereclause=yes name=ow_wfjg_in_inwarecode dbname="ow_wfjg_in.inwarecode" )
 column=(type=char(50) updatewhereclause=yes name=u_spt_name dbname="u_spt.name" )
 column=(type=char(20) updatewhereclause=yes name=u_spt_sptcode dbname="u_spt.sptcode" )
 column=(type=datetime updatewhereclause=yes name=ow_wfjg_in_opdate dbname="ow_wfjg_in.opdate" )
 column=(type=char(10) updatewhereclause=yes name=ow_wfjg_in_opemp dbname="ow_wfjg_in.opemp" )
 column=(type=char(10) updatewhereclause=yes name=ow_wfjg_in_modemp dbname="ow_wfjg_in.Modemp" )
 column=(type=datetime updatewhereclause=yes name=ow_wfjg_in_moddate dbname="ow_wfjg_in.moddate" )
 column=(type=long updatewhereclause=yes name=ow_wfjg_in_flag dbname="ow_wfjg_in.flag" values="	1/	0" )
 column=(type=datetime updatewhereclause=yes name=ow_wfjg_in_auditingdate dbname="ow_wfjg_in.auditingdate" )
 column=(type=char(10) updatewhereclause=yes name=ow_wfjg_in_auditingrep dbname="ow_wfjg_in.auditingrep" )
 column=(type=datetime updatewhereclause=yes name=ow_wfjg_in_indate dbname="ow_wfjg_in.indate" )
 column=(type=char(10) updatewhereclause=yes name=ow_wfjg_in_inrep dbname="ow_wfjg_in.inrep" )
 column=(type=char(50) updatewhereclause=yes name=ow_wfjg_in_part dbname="ow_wfjg_in.part" )
 column=(type=char(255) updatewhereclause=yes name=ow_wfjg_in_dscrp dbname="ow_wfjg_in.dscrp" )
 column=(type=long updatewhereclause=yes name=ow_wfjg_in_balcflag dbname="ow_wfjg_in.balcflag" values="	1/	0" )
 column=(type=datetime updatewhereclause=yes name=ow_wfjg_in_balcdate dbname="ow_wfjg_in.balcdate" )
 column=(type=long updatewhereclause=yes name=ow_wfjg_in_thflag dbname="ow_wfjg_in.thflag" values="	1/	0" )
 column=(type=long updatewhereclause=yes name=ow_wfjg_in_billtype dbname="ow_wfjg_in.billtype" )
 column=(type=long updatewhereclause=yes name=ow_wfjg_in_secflag dbname="ow_wfjg_in.secflag" values="	1/	0" )
 column=(type=datetime updatewhereclause=yes name=ow_wfjg_in_secauditingdate dbname="ow_wfjg_in.secauditingdate" )
 column=(type=char(10) updatewhereclause=yes name=ow_wfjg_in_secauditingrep dbname="ow_wfjg_in.secauditingrep" )
 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(30) updatewhereclause=yes name=ow_wfjgmx_in_bef_plancode dbname="ow_wfjgmx_in_bef.plancode" )
 column=(type=char(255) updatewhereclause=yes name=ow_wfjgmx_in_bef_status dbname="ow_wfjgmx_in_bef.status" )
 column=(type=decimal(4) updatewhereclause=yes name=ow_wfjgmx_in_bef_qty dbname="ow_wfjgmx_in_bef.qty" )
 column=(type=decimal(10) updatewhereclause=yes name=ow_wfjgmx_in_bef_fprice dbname="ow_wfjgmx_in_bef.fprice" )
 column=(type=char(255) updatewhereclause=yes name=ow_wfjgmx_in_bef_mxdscrp dbname="ow_wfjgmx_in_bef.mxdscrp" )
 column=(type=char(255) updatewhereclause=yes name=ow_wfjgmx_in_bef_woodcode dbname="ow_wfjgmx_in_bef.woodcode" )
 column=(type=decimal(14) updatewhereclause=yes name=priceamt dbname="priceamt" )
 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=mtrlid dbname="ow_wfjgmx_in_bef.mtrlid" )
 retrieve="SELECT ow_wfjg_in.inwareid,
	ow_wfjg_in.scid,
	ow_wfjg_in.inwarecode,
	u_spt.name,
	u_spt.sptcode,
	ow_wfjg_in.opdate,
	ow_wfjg_in.opemp,
	ow_wfjg_in.Modemp,
	ow_wfjg_in.moddate,  
	ow_wfjg_in.flag,  
	ow_wfjg_in.auditingdate,  
	ow_wfjg_in.auditingrep,
	ow_wfjg_in.indate,
	ow_wfjg_in.inrep,
	ow_wfjg_in.part,
	ow_wfjg_in.dscrp,
	ow_wfjg_in.balcflag,
	ow_wfjg_in.balcdate,
	ow_wfjg_in.thflag,
	ow_wfjg_in.billtype,
	ow_wfjg_in.secflag,
	ow_wfjg_in.secauditingdate,
	ow_wfjg_in.secauditingrep,
	u_mtrldef.mtrlcode,
	u_mtrldef.mtrlname,
	u_mtrldef.mtrlmode,
	u_mtrldef.unit,
	ow_wfjgmx_in_bef.plancode,
	ow_wfjgmx_in_bef.status,
	ow_wfjgmx_in_bef.qty,
	ow_wfjgmx_in_bef.fprice,
	ow_wfjgmx_in_bef.mxdscrp,
	ow_wfjgmx_in_bef.woodcode,
	ROUND(ow_wfjgmx_in_bef.fprice * ow_wfjgmx_in_bef.qty, 2) AS priceamt,
	u_mtrldef.mtrlsectype,
	u_mtrldef.zxmtrlmode,
	ow_wfjgmx_in_bef.mtrlid
	FROM ow_wfjg_in INNER JOIN
	ow_wfjgmx_in_bef ON ow_wfjg_in.scid = ow_wfjgmx_in_bef.scid AND
	ow_wfjg_in.inwareid = ow_wfjgmx_in_bef.inwareid INNER JOIN
	u_mtrldef ON ow_wfjgmx_in_bef.mtrlid = u_mtrldef.mtrlid INNER JOIN
	u_spt ON ow_wfjg_in.sptid = u_spt.sptid
	WHERE 	( u_mtrldef.handtype LIKE :arg_handtype OR :arg_handtype = '' ) AND
	( ow_wfjg_in.indate >= :first_date ) AND
	( ow_wfjg_in.indate <= :end_date ) AND
	( ow_wfjg_in.flag = :flag OR :flag = -1 ) AND
	( ow_wfjg_in.thflag = :arg_thflag OR :arg_thflag = -1 ) and
	( u_spt.spttypeid in (:arg_spttypeid)) 
	and ( ow_wfjg_in.scid in (:arg_scid))
" arguments=(("arg_scid", numberlist),("first_date", datetime),("end_date", datetime),("flag", number),("arg_handtype", string),("arg_thflag", number),("arg_spttypeid", numberlist)) )
text(band=header alignment="2" text="加工商名称" border="2" color="33554432" x="1271" y="208" height="56" width="681" html.valueishtml="0"  name=u_spt_name_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="加工商编号" border="2" color="33554432" x="910" y="208" height="56" width="352" html.valueishtml="0"  name=u_spt_sptcode_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="建立日期" border="2" color="33554432" x="4750" y="208" height="56" width="485" html.valueishtml="0"  name=ow_wfjg_in_opdate_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="建立人" border="2" color="33554432" x="5243" y="208" height="56" width="247" html.valueishtml="0"  name=ow_wfjg_in_opemp_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="修改人" border="2" color="33554432" x="5499" y="208" height="56" width="238" html.valueishtml="0"  name=ow_wfjg_in_modemp_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="修改日期" border="2" color="33554432" x="5746" y="208" height="56" width="466" html.valueishtml="0"  name=ow_wfjg_in_moddate_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="审核" border="2" color="33554432" x="6222" y="208" height="56" width="114" html.valueishtml="0"  name=ow_wfjg_in_flag_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="审核日期" border="2" color="33554432" x="6345" y="208" height="56" width="539" html.valueishtml="0"  name=ow_wfjg_in_auditingdate_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="审核人" border="2" color="33554432" x="6894" y="208" height="56" width="169" html.valueishtml="0"  name=ow_wfjg_in_auditingrep_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="单据日期" border="2" color="33554432" x="517" y="208" height="56" width="384" html.valueishtml="0"  name=ow_wfjg_in_indate_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="经手人" border="2" color="33554432" x="1961" y="208" height="56" width="210" html.valueishtml="0"  name=ow_wfjg_in_inrep_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="相关号码" border="2" color="33554432" x="2181" y="208" height="56" width="297" html.valueishtml="0"  name=ow_wfjg_in_part_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="备注" border="2" color="33554432" x="7072" y="208" height="56" width="1033" html.valueishtml="0"  name=ow_wfjg_in_dscrp_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="日结" border="2" color="33554432" x="8114" y="208" height="56" width="101" html.valueishtml="0"  name=ow_wfjg_in_balcflag_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="结存日期" border="2" color="33554432" x="8224" y="208" height="56" width="462" html.valueishtml="0"  name=ow_wfjg_in_balcdate_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="退货" border="2" color="33554432" x="8695" y="208" height="56" width="110" html.valueishtml="0"  name=ow_wfjg_in_thflag_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="财审" border="2" color="33554432" x="8814" y="208" height="56" width="114" html.valueishtml="0"  name=ow_wfjg_in_secflag_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="财审日期" border="2" color="33554432" x="8937" y="208" height="56" width="475" html.valueishtml="0"  name=ow_wfjg_in_secauditingdate_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="财审人" border="2" color="33554432" x="9422" y="208" height="56" width="183" html.valueishtml="0"  name=ow_wfjg_in_secauditingrep_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="编码" border="2" color="33554432" x="2487" y="208" height="56" width="293" html.valueishtml="0"  name=u_mtrldef_mtrlcode_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="品名" border="2" color="33554432" x="2789" y="208" height="56" width="603" html.valueishtml="0"  name=u_mtrldef_mtrlname_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text=" 规格" border="2" color="33554432" x="3401" y="208" height="56" width="297" html.valueishtml="0"  name=u_mtrldef_mtrlmode_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="库存单位" border="2" color="33554432" x="3707" y="208" height="56" width="219" html.valueishtml="0"  name=u_mtrldef_unit_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="批号" border="2" color="33554432" x="9614" y="208" height="56" width="302" html.valueishtml="0"  name=ow_wfjgmx_in_bef_plancode_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="属性" border="2" color="33554432" x="9925" y="208" height="56" width="375" html.valueishtml="0"  name=ow_wfjgmx_in_bef_status_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="数量" border="2" color="33554432" x="3936" y="208" height="56" width="274" html.valueishtml="0"  name=ow_wfjgmx_in_bef_qty_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="实价" border="2" color="33554432" x="4219" y="208" height="56" width="192" html.valueishtml="0"  name=ow_wfjgmx_in_bef_fprice_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="明细备注" border="2" color="33554432" x="10309" y="208" height="56" width="581" html.valueishtml="0"  name=ow_wfjgmx_in_bef_mxdscrp_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="金额" border="2" color="33554432" x="4421" y="208" height="56" width="320" html.valueishtml="0"  name=priceamt_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="单据编号" border="2" color="33554432" x="137" y="208" height="56" width="370" html.valueishtml="0"  name=ow_wfjg_in_inwarecode_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=header alignment="0" text="返工" border="2" color="33554432" x="9" y="208" height="56" width="119" html.valueishtml="0"  name=ow_wfjg_in_thflag_1_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" )
text(band=header alignment="2" text="属性1" border="2" color="33554432" x="10898" y="208" height="56" width="315" html.valueishtml="0"  name=ow_wfjgmx_in_bef_woodcode_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="自定义一" border="2" color="33554432" x="11223" y="208" height="56" width="411" html.valueishtml="0"  name=u_mtrldef_mtrlsectype_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" )
text(band=header alignment="2" text="自定义二" border="2" color="33554432" x="11643" y="208" height="56" width="407" html.valueishtml="0"  name=u_mtrldef_zxmtrlmode_t visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" )
column(band=detail id=4 alignment="0" tabsequence=32766 border="0" color="33554432" x="1271" y="4" height="68" width="681" format="[general]" html.valueishtml="0"  name=u_spt_name 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="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="910" y="4" height="68" width="352" format="[general]" html.valueishtml="0"  name=u_spt_sptcode visible="1" edit.limit=20 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="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=6 alignment="2" tabsequence=32766 border="0" color="33554432" x="4750" y="4" height="68" width="485" format="yyyy-mm-dd hh:mm" html.valueishtml="0"  name=ow_wfjg_in_opdate 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="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=7 alignment="0" tabsequence=32766 border="0" color="33554432" x="5243" y="4" height="68" width="247" format="[general]" html.valueishtml="0"  name=ow_wfjg_in_opemp 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="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=8 alignment="0" tabsequence=32766 border="0" color="33554432" x="5499" y="4" height="68" width="238" format="[general]" html.valueishtml="0"  name=ow_wfjg_in_modemp 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="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=9 alignment="2" tabsequence=32766 border="0" color="33554432" x="5746" y="4" height="68" width="466" format="yyyy-mm-dd hh:mm" html.valueishtml="0"  name=ow_wfjg_in_moddate 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="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=10 alignment="2" tabsequence=32766 border="0" color="33554432" x="6222" y="4" height="68" width="114" format="[general]" html.valueishtml="0"  name=ow_wfjg_in_flag visible="1" checkbox.text="" checkbox.on="1" checkbox.off="0" checkbox.scale=no checkbox.threed=yes  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=11 alignment="2" tabsequence=32766 border="0" color="33554432" x="6345" y="4" height="68" width="539" format="yyyy-mm-dd hh:mm" html.valueishtml="0"  name=ow_wfjg_in_auditingdate 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="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="6894" y="4" height="68" width="169" format="[general]" html.valueishtml="0"  name=ow_wfjg_in_auditingrep 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="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=13 alignment="2" tabsequence=32766 border="0" color="33554432" x="517" y="4" height="68" width="384" format="yyyy-mm-dd" html.valueishtml="0"  name=ow_wfjg_in_indate 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="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="1961" y="4" height="68" width="210" format="[general]" html.valueishtml="0"  name=ow_wfjg_in_inrep 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="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="2181" y="4" height="68" width="297" format="[general]" html.valueishtml="0"  name=ow_wfjg_in_part 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="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="7072" y="4" height="68" width="1033" format="[general]" html.valueishtml="0"  name=ow_wfjg_in_dscrp 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="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=17 alignment="2" tabsequence=32766 border="0" color="33554432" x="8114" y="4" height="68" width="101" format="[general]" html.valueishtml="0"  name=ow_wfjg_in_balcflag visible="1" checkbox.text="" checkbox.on="1" checkbox.off="0" checkbox.scale=no checkbox.threed=yes  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=18 alignment="2" tabsequence=32766 border="0" color="33554432" x="8224" y="4" height="68" width="462" format="yyyy-mm-dd hh:mm" html.valueishtml="0"  name=ow_wfjg_in_balcdate 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="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=19 alignment="2" tabsequence=32766 border="0" color="33554432" x="8695" y="4" height="68" width="110" format="[general]" html.valueishtml="0"  name=ow_wfjg_in_thflag visible="1" checkbox.text="" checkbox.on="1" checkbox.off="0" checkbox.scale=no checkbox.threed=yes  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=21 alignment="2" tabsequence=32766 border="0" color="33554432" x="8814" y="4" height="68" width="114" format="[general]" html.valueishtml="0"  name=ow_wfjg_in_secflag visible="1" checkbox.text="" checkbox.on="1" checkbox.off="0" checkbox.scale=no checkbox.threed=yes  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=22 alignment="2" tabsequence=32766 border="0" color="33554432" x="8937" y="4" height="68" width="475" format="yyyy-mm-dd hh:mm" html.valueishtml="0"  name=ow_wfjg_in_secauditingdate 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="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=23 alignment="0" tabsequence=32766 border="0" color="33554432" x="9422" y="4" height="68" width="183" format="[general]" html.valueishtml="0"  name=ow_wfjg_in_secauditingrep 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="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=24 alignment="0" tabsequence=32766 border="0" color="33554432" x="2487" y="4" height="68" width="293" 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="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=25 alignment="0" tabsequence=32766 border="0" color="33554432" x="2789" y="4" height="68" width="603" 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="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=26 alignment="0" tabsequence=32766 border="0" color="33554432" x="3401" y="4" height="68" width="297" 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="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=27 alignment="2" tabsequence=32766 border="0" color="33554432" x="3707" y="4" height="68" width="219" 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="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=28 alignment="0" tabsequence=32766 border="0" color="33554432" x="9614" y="4" height="68" width="302" format="[general]" html.valueishtml="0"  name=ow_wfjgmx_in_bef_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="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=29 alignment="0" tabsequence=32766 border="0" color="33554432" x="9925" y="4" height="68" width="375" format="[general]" html.valueishtml="0"  name=ow_wfjgmx_in_bef_status 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="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=30 alignment="1" tabsequence=32766 border="0" color="33554432" x="3936" y="4" height="68" width="274" format="#,##0.##" html.valueishtml="0"  name=ow_wfjgmx_in_bef_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="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=32 alignment="0" tabsequence=32766 border="0" color="33554432" x="10309" y="4" height="68" width="581" format="[general]" html.valueishtml="0"  name=ow_wfjgmx_in_bef_mxdscrp 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="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=31 alignment="1" tabsequence=32766 border="0" color="33554432" x="4219" y="4" height="68" width="192" format="#,##0.##" html.valueishtml="0"  name=ow_wfjgmx_in_bef_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="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=34 alignment="1" tabsequence=32766 border="0" color="33554432" x="4421" y="4" height="68" width="320" format="#,##0.##" html.valueishtml="0"  name=priceamt visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=3 alignment="0" tabsequence=32766 border="0" color="33554432" x="137" y="4" height="68" width="370" format="[general]" html.valueishtml="0"  name=ow_wfjg_in_inwarecode 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="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=19 alignment="2" tabsequence=32766 border="0" color="33554432" x="9" y="4" height="68" width="119" format="[general]" html.valueishtml="0"  name=ow_wfjg_in_thflag_1 visible="1" checkbox.text="" checkbox.on="1" checkbox.off="0" checkbox.scale=no checkbox.threed=yes  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" )
column(band=detail id=33 alignment="0" tabsequence=32766 border="0" color="33554432" x="10898" y="4" height="68" width="315" format="[general]" html.valueishtml="0"  name=ow_wfjgmx_in_bef_woodcode 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="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=35 alignment="0" tabsequence=32766 border="0" color="33554432" x="11223" y="4" height="68" width="411" format="[general]" html.valueishtml="0"  name=u_mtrldef_mtrlsectype 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="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=36 alignment="0" tabsequence=32766 border="0" color="33554432" x="11643" y="4" height="68" width="407" format="[general]" html.valueishtml="0"  name=u_mtrldef_zxmtrlmode 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="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
compute(band=footer alignment="1" expression="count(ow_wfjg_in_inwarecode for all)"border="0" color="33554432" x="137" y="4" height="56" width="370" format="[general]" html.valueishtml="0"  name=compute_1 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" )
compute(band=footer alignment="1" expression="sum(ow_wfjgmx_in_bef_qty for all)"border="0" color="33554432" x="3936" y="4" height="56" width="274" format="#,##0.##" html.valueishtml="0"  name=compute_2 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" )
compute(band=footer alignment="1" expression="sum(priceamt for all)"border="0" color="33554432" x="4421" y="4" height="56" width="320" format="#,##0.##" html.valueishtml="0"  name=compute_3 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=foreground alignment="0" text="" border="0" color="0" x="0" y="0" height="200" width="12123" html.valueishtml="0"  name=background visible="1"  resizeable=1  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="33554431" )
text(band=foreground alignment="0" text="外协收货(外协商)明细表" border="0" color="0" x="9" y="8" height="124" width="3424" html.valueishtml="0"  name=title visible="1"  moveable=1  font.face="宋体" font.height="-20" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="33554431" )
compute(band=foreground alignment="0" expression="if( flag =0 ,'未审核 ','')+'进仓日期:'+string( first_date ,'yy-mm-dd') +'~~~~'+string(end_date ,'yy-mm-dd')  +' 打印日期: '+string(today(),'yyyy-mm-dd')+' 共 '+string(pageCount())+' 页 第 ' + string(page()) + ' 页'"border="0" color="0" x="9" y="140" height="60" width="1952" format="[general]" html.valueishtml="0"  name=compute_5 visible="1"  moveable=1  font.face="宋体" font.height="-10" font.weight="700"  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  template=(comment="" encoding="gb2312" name="d" xml="<?xml version=~"1.0~" encoding=~"gb2312~" standalone=~"no~"?><dw_rp_owwfjg_in_spt><dw_rp_owwfjg_in_spt_row __pbband=~"detail~"><ow_wfjg_in_inwareid>ow_wfjg_in_inwareid</ow_wfjg_in_inwareid><ow_wfjg_in_inwarecode>ow_wfjg_in_inwarecode</ow_wfjg_in_inwarecode><u_spt_name>u_spt_name</u_spt_name><u_spt_sptcode>u_spt_sptcode</u_spt_sptcode><ow_wfjg_in_opdate>ow_wfjg_in_opdate</ow_wfjg_in_opdate><ow_wfjg_in_opemp>ow_wfjg_in_opemp</ow_wfjg_in_opemp><ow_wfjg_in_modemp>ow_wfjg_in_modemp</ow_wfjg_in_modemp><ow_wfjg_in_moddate>ow_wfjg_in_moddate</ow_wfjg_in_moddate><ow_wfjg_in_flag>ow_wfjg_in_flag</ow_wfjg_in_flag><ow_wfjg_in_auditingdate>ow_wfjg_in_auditingdate</ow_wfjg_in_auditingdate><ow_wfjg_in_auditingrep>ow_wfjg_in_auditingrep</ow_wfjg_in_auditingrep><ow_wfjg_in_indate>ow_wfjg_in_indate</ow_wfjg_in_indate><ow_wfjg_in_inrep>ow_wfjg_in_inrep</ow_wfjg_in_inrep><ow_wfjg_in_part>ow_wfjg_in_part</ow_wfjg_in_part><ow_wfjg_in_dscrp>ow_wfjg_in_dscrp</ow_wfjg_in_dscrp><ow_wfjg_in_balcflag>ow_wfjg_in_balcflag</ow_wfjg_in_balcflag><ow_wfjg_in_balcdate>ow_wfjg_in_balcdate</ow_wfjg_in_balcdate><ow_wfjg_in_thflag>ow_wfjg_in_thflag</ow_wfjg_in_thflag><ow_wfjg_in_secflag>ow_wfjg_in_secflag</ow_wfjg_in_secflag><ow_wfjg_in_secauditingdate>ow_wfjg_in_secauditingdate</ow_wfjg_in_secauditingdate><ow_wfjg_in_secauditingrep>ow_wfjg_in_secauditingrep</ow_wfjg_in_secauditingrep><u_mtrldef_mtrlcode>u_mtrldef_mtrlcode</u_mtrldef_mtrlcode><u_mtrldef_mtrlname>u_mtrldef_mtrlname</u_mtrldef_mtrlname><u_mtrldef_mtrlmode>u_mtrldef_mtrlmode</u_mtrldef_mtrlmode><u_mtrldef_unit>u_mtrldef_unit</u_mtrldef_unit><ow_wfjgmx_in_bef_plancode>ow_wfjgmx_in_bef_plancode</ow_wfjgmx_in_bef_plancode><ow_wfjgmx_in_bef_status>ow_wfjgmx_in_bef_status</ow_wfjgmx_in_bef_status><ow_wfjgmx_in_bef_qty>ow_wfjgmx_in_bef_qty</ow_wfjgmx_in_bef_qty><ow_wfjgmx_in_bef_fprice>ow_wfjgmx_in_bef_fprice</ow_wfjgmx_in_bef_fprice><ow_wfjgmx_in_bef_price/><ow_wfjgmx_in_bef_mxdscrp>ow_wfjgmx_in_bef_mxdscrp</ow_wfjgmx_in_bef_mxdscrp><ow_wfjgmx_in_bef_woodcode>ow_wfjgmx_in_bef_woodcode</ow_wfjgmx_in_bef_woodcode><priceamt>priceamt</priceamt></dw_rp_owwfjg_in_spt_row></dw_rp_owwfjg_in_spt>"))
import.xml()
export.pdf(method=0 distill.custompostscript="0" xslfop.print="0" )