123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131 |
- $PBExportHeader$dw_outware_sale_wareaudit_edit_th.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=816 color="536870912" )
- table(column=(type=long updatewhereclause=yes name=u_outware_outwareid dbname="u_outware.outwareid" initial="0" )
- column=(type=long updatewhereclause=yes name=u_outware_storageid dbname="u_outware.StorageID" initial="0" )
- column=(type=long updatewhereclause=yes name=u_outware_relint_2 dbname="u_outware.relint_2" initial="0" )
- column=(type=decimal(5) updatewhereclause=yes name=u_outware_mrate dbname="u_outware.mrate" initial="0" )
- column=(type=long updatewhereclause=yes name=u_outware_relint_1 dbname="u_outware.relint_1" initial="0" )
- column=(type=char(50) updatewhereclause=yes name=u_outware_part dbname="u_outware.part" initial="empty" )
- column=(type=char(20) updatewhereclause=yes name=u_cust_cuscode dbname="u_cust.cuscode" initial="empty" )
- column=(type=datetime updatewhereclause=yes name=u_outware_outdate dbname="u_outware.outdate" initial="today" )
- column=(type=char(10) updatewhereclause=yes name=u_outware_outrep dbname="u_outware.outrep" initial="empty" )
- column=(type=decimal(2) updatewhereclause=yes name=u_outware_otheramt dbname="u_outware.otheramt" initial="0" )
- column=(type=char(50) updatewhereclause=yes name=u_outware_relstr_1 dbname="u_outware.relstr_1" initial="empty" )
- column=(type=char(50) updatewhereclause=yes name=u_outware_relstr_2 dbname="u_outware.relstr_2" initial="empty" )
- column=(type=char(255) updatewhereclause=yes name=u_outware_dscrp dbname="u_outware.dscrp" initial="empty" )
- column=(type=char(50) updatewhereclause=yes name=u_cust_name dbname="u_cust.name" initial="empty" )
- column=(type=char(20) updatewhereclause=yes name=u_outware_outwarecode dbname="u_outware.outwarecode" initial="empty" )
- column=(type=datetime updatewhereclause=yes name=u_outware_opdate dbname="u_outware.opdate" initial="today" )
- column=(type=char(10) updatewhereclause=yes name=u_outware_opemp dbname="u_outware.opemp" )
- column=(type=datetime updatewhereclause=yes name=u_outware_auditingdate dbname="u_outware.auditingdate" )
- column=(type=long updatewhereclause=yes name=flag dbname="u_outware.flag" initial="0" values=" 1/ 0" )
- column=(type=char(10) updatewhereclause=yes name=u_outware_auditingrep dbname="u_outware.auditingrep" initial="empty" )
- column=(type=long updatewhereclause=yes name=u_outware_cusid dbname="u_outware.cusid" initial="0" )
- column=(type=long updatewhereclause=yes name=u_outware_balcflag dbname="u_outware.balcflag" initial="0" values=" 1/ 0" )
- column=(type=long updatewhereclause=yes name=u_outware_relid dbname="u_outware.relid" initial="0" )
- column=(type=char(30) updatewhereclause=yes name=u_storage_storagename dbname="u_storage.storagename" initial="empty" )
- column=(type=long updatewhereclause=yes name=u_outware_thflag dbname="u_outware.thflag" initial="0" values=" 1/ 0" )
- column=(type=datetime updatewhereclause=yes name=u_outware_secauditingdate dbname="u_outware.secauditingdate" )
- column=(type=long updatewhereclause=yes name=secflag dbname="u_outware.secflag" values=" 1/ 0" )
- 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=long updatewhereclause=yes name=u_outware_priceflag dbname="u_outware.priceflag" values=" 1/ 0" )
- column=(type=char(20) updatewhereclause=yes name=u_outware_priceemp dbname="u_outware.priceemp" )
- 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=long updatewhereclause=yes name=u_outware_scid dbname="u_outware.scid" )
- column=(type=long updatewhereclause=yes name=u_outware_printnum dbname="u_outware.printnum" )
- column=(type=long updatewhereclause=yes name=u_outware_balcdateint dbname="u_outware.balcdateint" )
- retrieve="select top 0 u_outware.outwareid ,
- u_outware.StorageID ,
- u_outware.relint_2,
- u_outware.mrate,
- u_outware.relint_1,
- u_outware.part ,
- u_cust.cuscode ,
- u_outware.outdate ,
- u_outware.outrep ,
- u_outware.otheramt ,
- u_outware.relstr_1,
- u_outware.relstr_2,
- u_outware.dscrp ,
- u_cust.name ,
- u_outware.outwarecode ,
- u_outware.opdate ,
- u_outware.opemp ,
- u_outware.auditingdate ,
- u_outware.flag ,
- u_outware.auditingrep ,
- u_outware.cusid ,
- u_outware.balcflag ,
- u_outware.relid ,
- u_storage.storagename ,
- u_outware.thflag ,
- u_outware.secauditingdate ,
- u_outware.secflag ,
- u_outware.secauditingrep,
- u_outware.pricedate ,
- u_outware.priceflag ,
- u_outware.priceemp,
- u_outware.modemp,
- u_outware.moddate,
- u_outware.scid,
- u_outware.printnum,
- u_outware.balcdateint
- FROM u_outware,
- u_cust ,
- u_storage
- WHERE ( u_cust.cusid = u_outware.cusid ) AND
- ( u_outware.StorageID = u_storage.storageid ) AND
- ( u_outware.billtype = 1 )
- " sort="u_outware_outwarecode D " )
- column(band=detail id=22 alignment="2" tabsequence=32766 border="0" color="0" x="919" y="52" height="56" width="82" format="[general]" html.valueishtml="0" name=u_outware_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="134" background.mode="2" background.color="16777215" )
- text(band=detail alignment="0" text="结存" border="0" color="0" x="795" y="52" height="56" width="114" html.valueishtml="0" name=u_outware_balcflag_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
- column(band=detail id=19 alignment="2" tabsequence=32766 border="0" color="255~tif(flag=1,rgb(0,0,255),rgb(255,0,0))" x="1367" y="52" height="56" width="82" format="[general]" html.valueishtml="0" name=flag tag="审核标志" 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="16777215" )
- text(band=detail alignment="0" text="仓审" border="0" color="255~tif(flag=1,rgb(0,0,0),rgb(255,0,0))" x="1243" y="52" height="56" width="114" html.valueishtml="0" name=flag_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
- column(band=detail id=25 alignment="2" tabsequence=32766 border="0" color="0" x="1147" y="52" height="56" width="82" format="[general]" html.valueishtml="0" name=u_outware_thflag visible="1" checkbox.text="" checkbox.on="1" checkbox.off="0" checkbox.scale=no checkbox.threed=yes font.face="宋体" font.height="-9" font.weight="700" font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
- text(band=detail alignment="0" text="退货" border="0" color="0" x="1024" y="52" height="56" width="114" html.valueishtml="0" name=t_1 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
- text(band=detail alignment="0" text="财审" border="0" color="65280~tif(secflag=1,rgb(0,0,0),rgb(128,0,128))" x="1463" y="52" height="56" width="114" html.valueishtml="0" name=secflag_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
- column(band=detail id=27 alignment="2" tabsequence=32766 border="0" color="0" x="1586" y="52" height="56" width="82" format="[general]" html.valueishtml="0" name=secflag visible="1" checkbox.text="" checkbox.on="1" checkbox.off="0" checkbox.scale=no checkbox.threed=yes font.face="宋体" font.height="-9" font.weight="700" font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
- text(band=detail alignment="0" text="确认" border="0" color="0" x="1678" y="52" height="56" width="114" html.valueishtml="0" name=t_7 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
- column(band=detail id=30 alignment="0" tabsequence=32766 border="0" color="0" x="1797" y="52" height="56" width="82" format="[general]" html.valueishtml="0" name=u_outware_priceflag 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="16777215" )
- text(band=detail alignment="2" text="待审核" border="0" color="255" x="1911" y="52" height="56" width="233" html.valueishtml="0" name=t_2 visible="1~tif (flag=0 or secflag=0,1,0)" font.face="宋体" font.height="-9" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
- column(band=detail id=15 alignment="0" tabsequence=32766 border="4" color="0" x="274" y="52" height="68" width="512" 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="700" font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
- text(band=detail alignment="1" text="单据编号" border="0" color="0" x="14" y="52" height="56" width="251" 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="2" background.color="16777215" )
- column(band=detail id=2 alignment="0" tabsequence=32766 border="4" color="16711680" x="274" y="156" height="68" width="512" format="[general]" html.valueishtml="0" name=u_outware_storageid visible="1" dddw.name=dw_dddw_storage_withscid dddw.displaycolumn=storagename dddw.datacolumn=storageid dddw.percentwidth=100 dddw.lines=10 dddw.limit=0 dddw.allowedit=no dddw.useasborder=no dddw.case=any dddw.imemode=0 dddw.vscrollbar=yes font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
- column(band=detail id=8 alignment="2" tabsequence=32766 border="4" color="16711680" x="1051" y="156" height="68" width="512" format="yyyy-mm-dd" html.valueishtml="0" name=u_outware_outdate visible="1" editmask.spin=yes editmask.mask="yyyy-mm-dd" editmask.imemode=0 editmask.spinrange="~~" editmask.spinincr=1 editmask.focusrectangle=no font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
- column(band=detail id=6 alignment="0" tabsequence=32766 border="4" color="16711680" x="1865" y="156" height="68" width="443" format="[general]" html.valueishtml="0" name=u_outware_part tag="相关部门" visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
- text(band=detail alignment="1" text="仓 库" border="0" color="16711680" x="14" y="156" height="56" width="251" 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="2" background.color="16777215" )
- text(band=detail alignment="1" text="销售时间" border="0" color="16711680" x="814" y="156" height="56" width="224" 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="2" background.color="16777215" )
- text(band=detail alignment="1" text="相关号码" border="0" color="16711680" x="1632" y="156" height="56" width="219" 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="2" background.color="16777215" )
- column(band=detail id=13 alignment="0" tabsequence=32766 border="4" color="16711680" x="274" y="264" height="68" width="2039" format="[general]" html.valueishtml="0" name=u_outware_dscrp tag="备注" visible="1" edit.limit=200 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
- text(band=detail alignment="1" text="备 注" border="0" color="16711680" x="14" y="264" height="56" width="251" 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="2" background.color="16777215" )
- text(band=detail alignment="1" text="建 立 人" border="0" color="0" x="795" y="420" height="56" width="219" html.valueishtml="0" name=u_outware_operator_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
- text(band=detail alignment="1" text="仓 审 人" border="0" color="0~tif(flag=1,rgb(0,0,0),rgb(255,0,0))" x="795" y="504" height="56" width="219" 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="2" background.color="16777215" )
- text(band=detail alignment="1" text="财 审 人" border="0" color="0~tif(secflag=1,rgb(0,0,0),rgb(128,0,128))" x="795" y="588" height="56" width="219" 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="2" background.color="16777215" )
- text(band=detail alignment="1" text="修 改 人" border="0" color="0" x="795" y="672" height="56" width="219" html.valueishtml="0" name=t_11 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
- column(band=detail id=28 alignment="0" tabsequence=32766 border="4" color="0~tif(secflag=1,rgb(0,0,255),rgb(0,255,0))" x="1029" y="588" height="68" width="443" format="[general]" html.valueishtml="0" name=u_outware_secauditingrep 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="134" background.mode="2" background.color="16777215" )
- column(band=detail id=32 alignment="0" tabsequence=32766 border="4" color="0" x="1029" y="672" height="68" width="443" format="[general]" html.valueishtml="0" name=u_outware_modemp visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
- column(band=detail id=17 alignment="0" tabsequence=32766 border="4" color="0" x="1029" y="420" height="68" width="443" format="[general]" html.valueishtml="0" name=u_outware_opemp 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="134" background.mode="2" background.color="16777215" )
- text(band=detail alignment="1" text="确认时间" border="0" color="0" x="1495" y="420" height="56" width="229" html.valueishtml="0" name=t_8 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
- column(band=detail id=20 alignment="0" tabsequence=32766 border="4" color="0~tif(flag=1,rgb(0,0,255),rgb(255,0,0))" x="1029" y="504" height="68" width="443" 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="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
- text(band=detail alignment="1" text="确 认 人" border="0" color="0" x="1495" y="504" height="56" width="229" html.valueishtml="0" name=t_9 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
- column(band=detail id=31 alignment="0" tabsequence=32766 border="4" color="0" x="1733" y="504" height="68" width="581" format="[general]" html.valueishtml="0" name=u_outware_priceemp 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="134" background.mode="2" background.color="16777215" )
- column(band=detail id=29 alignment="0" tabsequence=32766 border="4" color="0" x="1733" y="420" height="68" width="581" format="yyyy-mm-dd hh:mm" html.valueishtml="0" name=u_outware_pricedate 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="134" background.mode="2" background.color="16777215" )
- column(band=detail id=16 alignment="0" tabsequence=32766 border="4" color="0" x="274" y="420" height="68" width="512" format="yyyy-mm-dd hh:mm" 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="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
- column(band=detail id=33 alignment="0" tabsequence=32766 border="4" color="0" x="274" y="672" height="68" width="512" format="yyyy-mm-dd hh:mm" html.valueishtml="0" name=u_outware_moddate visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
- column(band=detail id=26 alignment="0" tabsequence=32766 border="4" color="0~tif(secflag=1,rgb(0,0,255),rgb(0,255,0))" x="274" y="588" height="68" width="512" format="yyyy-mm-dd hh:mm" html.valueishtml="0" name=u_outware_secauditingdate visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.nilisnull=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
- column(band=detail id=18 alignment="0" tabsequence=32766 border="4" color="0~tif(flag=1,rgb(0,0,255),rgb(255,0,0))" x="274" y="504" height="68" width="512" format="yyyy-mm-dd hh:mm" html.valueishtml="0" name=u_outware_auditingdate tag="审核时间" visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.nilisnull=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
- text(band=detail alignment="1" text="建立时间" border="0" color="0" x="14" y="420" height="56" width="251" 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="2" background.color="16777215" )
- text(band=detail alignment="1" text="仓审时间" border="0" color="0~tif(flag=1,rgb(0,0,255),rgb(255,0,0))" x="14" y="504" height="56" width="251" 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="2" background.color="16777215" )
- text(band=detail alignment="1" text="财审时间" border="0" color="0~tif(secflag=1,rgb(0,0,0),rgb(128,0,128))" x="14" y="588" height="56" width="251" 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="2" background.color="16777215" )
- text(band=detail alignment="1" text="修改时间" border="0" color="0" x="14" y="672" height="56" width="251" html.valueishtml="0" name=t_10 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
- 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" )
|