123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105 |
- $PBExportHeader$dw_credence_edit.srd
- $PBExportComments$By Kivens.Jiang(kivens@21cn.com)
- release 9;
- datawindow ( units=3 timer_interval=0 color=15793151 processing=0 print.printername="" print.documentname="" print.orientation=0 print.margin.left=635 print.margin.right=635 print.margin.top=635 print.margin.bottom=635 print.paper.size=0 print.paper.source=0 print.canusedefaultprinter=yes selected.mouse=no)
- header(height=0 )
- summary(height=0 color="536870912" )
- footer(height=1190 color="536870912" )
- detail(height=10398 color="536870912" )
- table(column=(type=long key=yes updatewhereclause=yes initial="0" name=credid dbname="cw_credence.credid" )
- column=(type=long key=yes updatewhereclause=yes initial="0" name=accsetid dbname="cw_credence.accsetid" )
- column=(type=long key=yes updatewhereclause=yes initial="0" name=subaccsetid dbname="cw_credence.subaccsetid" )
- column=(type=char(10) updatewhereclause=yes initial="empty" name=credtype dbname="cw_credence.credtype"
- values="" )
- column=(type=long updatewhereclause=yes initial="0" name=credno dbname="cw_credence.credno" )
- column=(type=datetime updatewhereclause=yes name=reldate dbname="cw_credence.reldate" )
- column=(type=char(50) updatewhereclause=yes name=reldcode dbname="cw_credence.reldcode" )
- column=(type=datetime updatewhereclause=yes initial="today" name=creddate dbname="cw_credence.creddate" )
- column=(type=long updatewhereclause=yes initial="0" name=billnumber dbname="cw_credence.billnumber" )
- column=(type=long updatewhereclause=yes initial="0" name=readtype dbname="cw_credence.readtype"
- values=" 0/结转损益 100/资产增加 200/计提折旧 201/资产减少 202/自转凭证 300/结转 301/出纳 888/" )
- column=(type=long updatewhereclause=yes name=cmonth dbname="cw_credence.cmonth" )
- column=(type=char(20) updatewhereclause=yes initial="empty" name=billmaker dbname="cw_credence.billmaker" )
- column=(type=datetime updatewhereclause=yes name=billmakerdate dbname="cw_credence.billmakerdate" )
- column=(type=char(20) updatewhereclause=yes initial="empty" name=billcheck dbname="cw_credence.billcheck" )
- column=(type=datetime updatewhereclause=yes name=billcheckdate dbname="cw_credence.billcheckdate" )
- column=(type=char(20) updatewhereclause=yes initial="empty" name=billpost dbname="cw_credence.billpost" )
- column=(type=datetime updatewhereclause=yes name=billpostdate dbname="cw_credence.billpostdate" )
- column=(type=long updatewhereclause=yes name=checkflag dbname="cw_credence.checkflag" )
- column=(type=long updatewhereclause=yes name=postflag dbname="cw_credence.postflag" )
- column=(type=long updatewhereclause=yes name=relevantbillid dbname="cw_credence.relevantbillid" )
- column=(type=datetime updatewhereclause=yes name=moddate dbname="cw_credence.moddate" )
- column=(type=char(20) updatewhereclause=yes name=modemp dbname="cw_credence.modemp" )
- column=(type=long updatewhereclause=yes name=ifauto dbname="cw_credence.ifauto"
- values=" 1/ 0" )
- retrieve=" SELECT cw_credence.credid,
- cw_credence.accsetid,
- cw_credence.subaccsetid,
- cw_credence.credtype,
- cw_credence.credno,
- cw_credence.reldate,
- cw_credence.reldcode,
- cw_credence.creddate,
- cw_credence.billnumber,
- cw_credence.readtype,
- cw_credence.cmonth,
- cw_credence.billmaker,
- cw_credence.billmakerdate,
- cw_credence.billcheck,
- cw_credence.billcheckdate,
- cw_credence.billpost,
- cw_credence.billpostdate,
- cw_credence.checkflag,
- cw_credence.postflag,
- cw_credence.relevantbillid ,
- cw_credence.moddate ,
- cw_credence.modemp ,
- cw_credence.ifauto
- FROM cw_credence
- WHERE cw_credence.accsetid = :arg_accsetid
- and cw_credence.credid = :arg_credid
- "
- update="cw_credence" updatewhere=0 updatekeyinplace=no
- arguments=(("arg_accsetid", number), ("arg_credid", number))
- )
- column(name=billcheckdate visible="1" tag="审核时间" band=footer id=15 x="10027" y="662" height="476" width="2592" color="0" border="0" alignment="0" format="yyyy-mm-dd hh:mm" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=yes edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
- text(name=billcheckdate_t visible="1" band=footer font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="0" alignment="1" border="0" x="8466" y="662" height="370" width="1508" text="审核时间:" )
- column(name=billpostdate visible="1" tag="登帐时间" band=footer id=17 x="14234" y="662" height="476" width="2592" color="0" border="0" alignment="0" format="yyyy-mm-dd hh:mm" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=yes edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
- text(name=billpostdate_t visible="1" band=footer font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="0" alignment="1" border="0" x="12673" y="662" height="370" width="1508" text="登帐时间:" )
- column(name=billpost visible="1" tag="登帐" band=footer id=16 x="14234" y="80" height="476" width="2592" color="0" border="0" alignment="0" format="[general]" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=20 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
- text(name=billpost_t visible="1" band=footer font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="0" alignment="1" border="0" x="12673" y="80" height="370" width="1508" text="登 帐:" )
- column(name=billcheck visible="1" tag="审核" band=footer id=14 x="10027" y="80" height="476" width="2592" color="0" border="0" alignment="0" format="[general]" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=20 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
- text(name=billcheck_t visible="1" band=footer font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="0" alignment="1" border="0" x="8466" y="80" height="370" width="1508" text="审 核:" )
- column(name=billmaker visible="1" tag="制单" band=footer id=12 x="5820" y="80" height="476" width="2592" color="0" border="0" alignment="0" format="[general]" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=20 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
- text(name=billmaker_t visible="1" band=footer font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="0" alignment="1" border="0" x="4259" y="80" height="370" width="1508" text="制 单:" )
- text(name=billmakerdate_t visible="1" band=footer font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="0" alignment="1" border="0" x="4259" y="662" height="370" width="1508" text="制单时间:" )
- column(name=moddate visible="1" band=footer id=21 x="1613" y="662" height="476" width="2592" color="0" border="0" alignment="0" format="yyyy-mm-dd hh:mm" edit.autohscroll=no edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=yes edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="2" background.color="15793151" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
- column(name=modemp visible="1" band=footer id=22 x="1613" y="80" height="476" width="2592" color="0" border="0" alignment="0" format="[general]" edit.autohscroll=no edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="2" background.color="15793151" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
- text(name=t_6 visible="1" band=footer font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="15793151" color="0" alignment="0" border="0" x="52" y="662" height="370" width="1508" text="修改时间:" )
- text(name=t_7 visible="1" band=footer font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="15793151" color="0" alignment="0" border="0" x="52" y="80" height="370" width="1508" text="修 改:" )
- text(name=t_1 visible="1" band=detail font.charset="134" font.face="楷体_GB2312" font.family="1" font.height="-20" font.pitch="1" font.weight="700" background.mode="1" background.color="536870912" color="0" alignment="2" border="0" x="6482" y="80" height="820" width="4550" text="记 帐 凭 证" )
- text(name=subaccsetid_t visible="1 0" band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="0" alignment="1" border="0" x="17885" y="477" height="370" width="1640" text="子 帐:" )
- column(name=subaccsetid visible="1 0" tag="子帐ID" band=detail id=3 x="19658" y="371" height="476" width="1905" color="0" border="5" alignment="1" format="[general]" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="2" background.color="16777215" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
- text(name=credtype_t visible="1" band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="0" alignment="1" border="0" x="79" y="186" height="370" width="1666" text="凭 证 字:" )
- text(name=t_2 visible="1" band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="15793151" color="0" alignment="1" border="0" x="16668" y="768" height="370" width="370" text="张" )
- column(name=credtype visible="1" tag="凭证字类型" band=detail id=4 x="1852" y="80" height="476" width="2169" color="0" border="5" alignment="0" format="[general]" dddw.allowedit=no dddw.autohscroll=no dddw.autoretrieve=yes dddw.useasborder=yes dddw.datacolumn=credenceword dddw.displaycolumn=credenceword dddw.hscrollbar=no dddw.hsplitscroll=no dddw.imemode=0 dddw.limit=0 dddw.name=ddd_credword dddw.nilisnull=no dddw.percentwidth=100 dddw.lines=10 dddw.required=no dddw.showlist=no dddw.vscrollbar=yes criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="2" background.color="16777215" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
- column(name=credno visible="1" tag="编号" band=detail id=5 x="1852" y="662" height="476" width="2169" color="0" border="5" alignment="0" format="###0" edit.format="###0" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="2" background.color="16777215" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
- column(name=reldate visible="1" band=detail id=6 x="1852" y="1244" height="476" width="2169" color="0" border="5" alignment="2" format="[shortdate] [time]" editmask.focusrectangle=no editmask.autoskip=no editmask.required=no editmask.readonly=no editmask.codetable=no editmask.spin=yes editmask.useformat=no editmask.spinincr=1 editmask.spinrange="~~" editmask.mask="yyyy-mm-dd" editmask.imemode=0 criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="2" background.color="16777215" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
- text(name=t_3 visible="1" band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="0" alignment="1" border="0" x="4180" y="1350" height="370" width="1349" text="相关号:" )
- text(name=t_4 visible="1" band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="1" background.color="553648127" color="0" alignment="1" border="0" x="13096" y="186" height="370" width="1693" text="凭证类型:" )
- text(name=billnumber_t visible="1" band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="0" alignment="1" border="0" x="13096" y="768" height="370" width="1693" text="附 件:" )
- text(name=creddate_t visible="1" band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="0" alignment="1" border="0" x="13096" y="1350" height="370" width="1693" text="凭证日期:" )
- column(name=readtype visible="1" band=detail id=10 x="14896" y="80" height="476" width="2169" color="0" border="5" alignment="0" format="[general]" ddlb.allowedit=no ddlb.autohscroll=no ddlb.imemode=0 ddlb.limit=0 ddlb.showlist=no ddlb.sorted=no ddlb.useasborder=no ddlb.vscrollbar=no ddlb.nilisnull=no ddlb.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="2" background.color="16777215" font.charset="134" font.face="宋体" font.family="2" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
- column(name=billnumber visible="1" tag="附件" band=detail id=9 x="14896" y="662" height="476" width="1693" color="0" border="5" alignment="0" format="##0" edit.format="##0" edit.focusrectangle=no edit.autohscroll=no edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="2" background.color="16777215" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
- text(name=credno_t visible="1" band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="0" alignment="1" border="0" x="79" y="768" height="370" width="1666" text="凭证编号:" )
- text(name=t_5 visible="1" band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="0" alignment="1" border="0" x="79" y="1350" height="370" width="1666" text="相关日期:" )
- column(name=creddate visible="1" tag="日期" band=detail id=8 x="14896" y="1244" height="476" width="2169" color="0" border="5" alignment="2" format="yyyy-mm-dd" editmask.focusrectangle=no editmask.autoskip=no editmask.required=no editmask.readonly=no editmask.codetable=no editmask.spin=yes editmask.useformat=no editmask.spinincr=1 editmask.spinrange="~~" editmask.mask="yyyy-mm-dd" editmask.imemode=0 criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="2" background.color="16777215" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
- column(name=reldcode visible="1" band=detail id=7 x="5662" y="1244" height="476" width="7223" color="0" border="5" alignment="0" format="[general]" edit.autohscroll=no edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="2" background.color="16777215" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
- text(name=t_8 visible="1" band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="15793151" color="33554432" alignment="1" border="0" x="11615" y="741" height="370" width="793" text="自动" )
- column(name=ifauto visible="1" band=detail id=23 x="12488" y="741" height="370" width="396" color="0" border="0" alignment="0" format="[general]" checkbox.lefttext=no checkbox.scale=no checkbox.threed=yes checkbox.text="" checkbox.on="1" checkbox.off="0" criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="2" background.color="15793151" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
- column(name=billmakerdate visible="1" tag="制单时间" band=foreground id=13 x="5820" y="12250" height="476" width="2592" color="0" border="0" alignment="0" format="yyyy-mm-dd hh:mm" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=yes edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="2" background.color="15793151" font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
- htmltable(border="1" )
- htmlgen(clientComputedFields="1" clientEvents="1" clientFormatting="0" clientScriptable="0" clientValidation="1" generateJavaScript="1" netscapeLayers="0" netscapelayers="0" encodeSelfLinkArgs="1" )
- export.xml(headGroups="1" includewhitespace="0" metadatatype=0 savemetadata=0 )
- import.xml()
- export.pdf(method=0 distill.customPostScript="0" xslfop.print="0" )
|