Q5/ws_objects/xls_defaultdw.pbl.src/dw_xls_w_outware_scll.srd

$PBExportHeader$dw_xls_w_outware_scll.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=128 color="536870912" )
summary(height=0 color="536870912" )
footer(height=0 color="536870912" )
detail(height=84 color="536870912" )
table(column=(type=char(30) updatewhereclause=yes name=u_storage_storagename dbname="u_storage.storagename" )
 column=(type=char(20) updatewhereclause=yes name=u_outware_outwarecode dbname="u_outware.outwarecode" )
 column=(type=char(10) updatewhereclause=yes name=u_outware_outrep dbname="u_outware.outrep" )
 column=(type=char(255) updatewhereclause=yes name=u_outware_dscrp dbname="u_outware.dscrp" )
 column=(type=char(10) updatewhereclause=yes name=u_outware_auditingrep dbname="u_outware.auditingrep" )
 column=(type=datetime updatewhereclause=yes name=u_outware_auditingdate dbname="u_outware.auditingdate" )
 column=(type=datetime updatewhereclause=yes name=u_outware_outdate dbname="u_outware.outdate" )
 column=(type=datetime updatewhereclause=yes name=u_outware_opdate dbname="u_outware.opdate" )
 column=(type=char(50) updatewhereclause=yes name=u_outware_cusname dbname="u_outware.cusname" )
 column=(type=char(10) updatewhereclause=yes name=u_outware_opemp dbname="u_outware.opemp" )
 column=(type=char(10) updatewhereclause=yes name=u_outware_modemp dbname="u_outware.Modemp" )
 column=(type=datetime updatewhereclause=yes name=u_outware_moddate dbname="u_outware.moddate" )
 column=(type=char(50) updatewhereclause=yes name=u_outware_part dbname="u_outware.part" )
 column=(type=datetime updatewhereclause=yes name=u_outware_secauditingdate dbname="u_outware.secauditingdate" )
 column=(type=char(10) updatewhereclause=yes name=u_outware_secauditingrep dbname="u_outware.secauditingrep" )
 column=(type=datetime updatewhereclause=yes name=u_outware_pricedate dbname="u_outware.pricedate" )
 column=(type=char(20) updatewhereclause=yes name=u_outware_priceemp dbname="u_outware.priceemp" )
 column=(type=char(50) updatewhereclause=yes name=u_workgroup_workgroupname dbname="u_workgroup.workgroupname" )
 retrieve="SELECT u_storage.storagename, u_outware.outwarecode, u_outware.outrep, 
      u_outware.dscrp, u_outware.auditingrep, u_outware.auditingdate, u_outware.outdate, 
      u_outware.opdate, u_outware.cusname, u_outware.opemp, u_outware.Modemp, 
      u_outware.moddate, u_outware.part, u_outware.secauditingdate, 
      u_outware.secauditingrep, u_outware.pricedate, u_outware.priceemp, 
       u_workgroup.workgroupname    
        
FROM u_outware INNER JOIN
      u_storage ON u_outware.StorageID = u_storage.storageid INNER JOIN
      u_workgroup ON u_outware.relid = u_workgroup.workgroupid
where u_outware.scid =   :arg_scid and u_outware.outwareid = :arg_outwareid" arguments=(("arg_scid", number),("arg_outwareid", number)) )
text(band=header alignment="2" text="仓库名称" border="0" color="33554432" x="9" y="8" height="56" width="850" html.valueishtml="0"  name=u_storage_storagename_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=header alignment="2" text="单据编号" border="0" color="33554432" x="869" y="8" height="56" width="576" html.valueishtml="0"  name=u_outware_outwarecode_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=header alignment="2" text="经手人" border="0" color="33554432" x="1454" y="8" height="56" width="571" html.valueishtml="0"  name=u_outware_outrep_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=header alignment="2" text="备注" border="0" color="33554432" x="2034" y="8" height="56" width="3511" html.valueishtml="0"  name=u_outware_dscrp_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=header alignment="2" text="审核人" border="0" color="33554432" x="5554" y="8" height="56" width="590" html.valueishtml="0"  name=u_outware_auditingrep_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=header alignment="2" text="审核时间" border="0" color="33554432" x="6153" y="8" height="56" width="603" html.valueishtml="0"  name=u_outware_auditingdate_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=header alignment="2" text="出仓时间" border="0" color="33554432" x="6766" y="8" height="56" width="603" html.valueishtml="0"  name=u_outware_outdate_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=header alignment="2" text="建立时间" border="0" color="33554432" x="7378" y="8" height="56" width="603" html.valueishtml="0"  name=u_outware_opdate_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=header alignment="2" text="客户名称" border="0" color="33554432" x="7991" y="8" height="56" width="850" html.valueishtml="0"  name=u_outware_cusname_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=header alignment="2" text="建立人" border="0" color="33554432" x="8850" y="8" height="56" width="384" html.valueishtml="0"  name=u_outware_opemp_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=header alignment="2" text="修改人" border="0" color="33554432" x="9243" y="8" height="56" width="471" html.valueishtml="0"  name=u_outware_modemp_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=header alignment="2" text="修改日期" border="0" color="33554432" x="9723" y="8" height="56" width="603" html.valueishtml="0"  name=u_outware_moddate_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=header alignment="2" text="相关号码" border="0" color="33554432" x="10336" y="8" height="56" width="1399" html.valueishtml="0"  name=u_outware_part_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=header alignment="2" text="二审时间" border="0" color="33554432" x="11744" y="8" height="56" width="603" html.valueishtml="0"  name=u_outware_secauditingdate_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=header alignment="2" text="二审人" border="0" color="33554432" x="12357" y="8" height="56" width="302" html.valueishtml="0"  name=u_outware_secauditingrep_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=header alignment="2" text="确认时间" border="0" color="33554432" x="12667" y="8" height="56" width="603" html.valueishtml="0"  name=u_outware_pricedate_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=header alignment="2" text="确认人" border="0" color="33554432" x="13280" y="8" height="56" width="576" html.valueishtml="0"  name=u_outware_priceemp_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=header alignment="2" text="领料组" border="0" color="33554432" x="13865" y="8" height="56" width="1399" html.valueishtml="0"  name=u_workgroup_workgroupname_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=1 alignment="0" tabsequence=32766 border="0" color="33554432" x="9" y="8" height="68" width="850" 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="宋体" 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=2 alignment="0" tabsequence=32766 border="0" color="33554432" x="869" y="8" height="68" width="576" format="[general]" html.valueishtml="0"  name=u_outware_outwarecode  tag="单据编号" 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="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=3 alignment="0" tabsequence=32766 border="0" color="33554432" x="1454" y="8" height="68" width="571" format="[general]" html.valueishtml="0"  name=u_outware_outrep  tag="业务员" 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" )
column(band=detail id=4 alignment="0" tabsequence=32766 border="0" color="33554432" x="2034" y="8" height="68" width="3511" format="[general]" html.valueishtml="0"  name=u_outware_dscrp  tag="备注" 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="0" tabsequence=32766 border="0" color="33554432" x="5554" y="8" height="68" width="590" format="[general]" html.valueishtml="0"  name=u_outware_auditingrep  tag="审核人" 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" )
column(band=detail id=6 alignment="0" tabsequence=32766 border="0" color="33554432" x="6153" y="8" height="68" width="603" format="[shortdate] [time]" html.valueishtml="0"  name=u_outware_auditingdate  tag="审核时间" 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=7 alignment="0" tabsequence=32766 border="0" color="33554432" x="6766" y="8" height="68" width="603" format="[shortdate] [time]" html.valueishtml="0"  name=u_outware_outdate  tag="出仓时间" 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=8 alignment="0" tabsequence=32766 border="0" color="33554432" x="7378" y="8" height="68" width="603" format="[shortdate] [time]" html.valueishtml="0"  name=u_outware_opdate  tag="建立时间" 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=9 alignment="0" tabsequence=32766 border="0" color="33554432" x="7991" y="8" height="68" width="850" format="[general]" html.valueishtml="0"  name=u_outware_cusname  tag="客户名称" 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="0" color="33554432" x="8850" y="8" height="68" width="384" format="[general]" html.valueishtml="0"  name=u_outware_opemp  tag="建立操作员" 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" )
column(band=detail id=11 alignment="0" tabsequence=32766 border="0" color="33554432" x="9243" y="8" height="68" width="471" format="[general]" html.valueishtml="0"  name=u_outware_modemp  tag="修改人" 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" )
column(band=detail id=12 alignment="0" tabsequence=32766 border="0" color="33554432" x="9723" y="8" height="68" width="603" format="[shortdate] [time]" html.valueishtml="0"  name=u_outware_moddate  tag="修改日期" 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=13 alignment="0" tabsequence=32766 border="0" color="33554432" x="10336" y="8" height="68" width="1399" format="[general]" html.valueishtml="0"  name=u_outware_part  tag="相关号码" 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=14 alignment="0" tabsequence=32766 border="0" color="33554432" x="11744" y="8" height="68" width="603" format="[shortdate] [time]" html.valueishtml="0"  name=u_outware_secauditingdate  tag="财务审核时间" 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=15 alignment="0" tabsequence=32766 border="0" color="33554432" x="12357" y="8" height="68" width="302" format="[general]" html.valueishtml="0"  name=u_outware_secauditingrep  tag="财务审核人" 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" )
column(band=detail id=16 alignment="0" tabsequence=32766 border="0" color="33554432" x="12667" y="8" height="68" width="603" format="[shortdate] [time]" html.valueishtml="0"  name=u_outware_pricedate 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=17 alignment="0" tabsequence=32766 border="0" color="33554432" x="13280" y="8" height="68" width="576" format="[general]" html.valueishtml="0"  name=u_outware_priceemp 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="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=18 alignment="0" tabsequence=32766 border="0" color="33554432" x="13865" y="8" height="68" width="1399" format="[general]" html.valueishtml="0"  name=u_workgroup_workgroupname 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" )
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="1" xml="<?xml version=~"1.0~" encoding=~"gb2312~" standalone=~"no~"?><untitled><untitled_row __pbband=~"detail~"><u_storage_storagename>u_storage_storagename</u_storage_storagename><u_outware_outwarecode>u_outware_outwarecode</u_outware_outwarecode><u_outware_outrep>u_outware_outrep</u_outware_outrep><u_outware_dscrp>u_outware_dscrp</u_outware_dscrp><u_outware_auditingrep>u_outware_auditingrep</u_outware_auditingrep><u_outware_auditingdate>u_outware_auditingdate</u_outware_auditingdate><u_outware_outdate>u_outware_outdate</u_outware_outdate><u_outware_opdate>u_outware_opdate</u_outware_opdate><u_outware_cusname>u_outware_cusname</u_outware_cusname><u_outware_opemp>u_outware_opemp</u_outware_opemp><u_outware_modemp>u_outware_modemp</u_outware_modemp><u_outware_moddate>u_outware_moddate</u_outware_moddate><u_outware_part>u_outware_part</u_outware_part><u_outware_secauditingdate>u_outware_secauditingdate</u_outware_secauditingdate><u_outware_secauditingrep>u_outware_secauditingrep</u_outware_secauditingrep><u_outware_pricedate>u_outware_pricedate</u_outware_pricedate><u_outware_priceemp>u_outware_priceemp</u_outware_priceemp><u_workgroup_wrkgrpid/><u_workgroup_workgroupname>u_workgroup_workgroupname</u_workgroup_workgroupname><u_workgroup_workgroupid/><u_outware_relid/></untitled_row></untitled>"))
import.xml()
export.pdf(method=0 distill.custompostscript="0" xslfop.print="0" )