dw_rap_money_transfer_permit.srd 20 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495
  1. $PBExportHeader$dw_rap_money_transfer_permit.srd
  2. release 9;
  3. 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 selected.mouse=no )
  4. header(height=68 color="536870912" )
  5. summary(height=0 color="536870912" )
  6. footer(height=64 color="536870912" )
  7. detail(height=76 color="536870912" )
  8. table(column=(type=long updatewhereclause=yes key=yes name=billid dbname="u_rap_money_transfer.billid" initial="0" )
  9. column=(type=datetime updatewhereclause=yes name=checkdate dbname="u_rap_money_transfer.checkdate" initial="today" )
  10. column=(type=char(20) updatewhereclause=yes name=checkemp dbname="u_rap_money_transfer.checkemp" initial="empty" )
  11. column=(type=char(30) updatewhereclause=yes name=relcode dbname="u_rap_money_transfer.relcode" initial="empty" )
  12. column=(type=long updatewhereclause=yes name=banktypeid dbname="u_rap_money_transfer.banktypeid" initial="0" )
  13. column=(type=long updatewhereclause=yes name=accountid_out dbname="u_rap_money_transfer.accountid_out" initial="0" )
  14. column=(type=long updatewhereclause=yes name=accountid_in dbname="u_rap_money_transfer.accountid_in" initial="0" )
  15. column=(type=decimal(2) updatewhereclause=yes name=transferamt dbname="u_rap_money_transfer.transferamt" initial="0" )
  16. column=(type=char(255) updatewhereclause=yes name=dscrp dbname="u_rap_money_transfer.dscrp" initial="empty" )
  17. column=(type=datetime updatewhereclause=yes name=opdate dbname="u_rap_money_transfer.opdate" initial="empty" )
  18. column=(type=char(10) updatewhereclause=yes name=opemp dbname="u_rap_money_transfer.opemp" initial="empty" )
  19. column=(type=datetime updatewhereclause=yes name=moddate dbname="u_rap_money_transfer.moddate" initial="empty" )
  20. column=(type=char(10) updatewhereclause=yes name=modemp dbname="u_rap_money_transfer.modemp" initial="empty" )
  21. column=(type=long updatewhereclause=yes name=flag dbname="u_rap_money_transfer.flag" initial="0" values=" 1/ 0" )
  22. column=(type=char(10) updatewhereclause=yes name=permit_emp dbname="u_rap_money_transfer.permit_emp" initial="empty" )
  23. column=(type=datetime updatewhereclause=yes name=permit_date dbname="u_rap_money_transfer.permit_date" initial="empty" )
  24. column=(type=char(30) updatewhereclause=yes name=billcode dbname="u_rap_money_transfer.billcode" initial="empty" )
  25. column=(type=long updatewhereclause=yes name=secflag dbname="u_rap_money_transfer.secflag" initial="0" values=" 1/ 0" )
  26. column=(type=char(30) updatewhereclause=yes name=secemp dbname="u_rap_money_transfer.secemp" initial="empty" )
  27. column=(type=datetime updatewhereclause=yes name=secdate dbname="u_rap_money_transfer.secdate" initial="empty" )
  28. retrieve=" SELECT u_rap_money_transfer.billid,
  29. u_rap_money_transfer.checkdate,
  30. u_rap_money_transfer.checkemp,
  31. u_rap_money_transfer.relcode,
  32. u_rap_money_transfer.banktypeid,
  33. u_rap_money_transfer.accountid_out,
  34. u_rap_money_transfer.accountid_in,
  35. u_rap_money_transfer.transferamt,
  36. u_rap_money_transfer.dscrp,
  37. u_rap_money_transfer.opdate,
  38. u_rap_money_transfer.opemp,
  39. u_rap_money_transfer.moddate,
  40. u_rap_money_transfer.modemp,
  41. u_rap_money_transfer.flag,
  42. u_rap_money_transfer.permit_emp,
  43. u_rap_money_transfer.permit_date,
  44. u_rap_money_transfer.billcode,
  45. u_rap_money_transfer.secflag,
  46. u_rap_money_transfer.secemp,
  47. u_rap_money_transfer.secdate
  48. FROM u_rap_money_transfer
  49. WHERE (:arg_secflag = -1 OR
  50. u_rap_money_transfer.secflag = :arg_secflag) and
  51. u_rap_money_transfer.flag = 1" update="u_rap_money_transfer" updatewhere=0 updatekeyinplace=no arguments=(("arg_secflag", number)) )
  52. text(band=header alignment="2" text="转帐日期" border="0" color="33554432" x="425" y="8" height="56" width="311" html.valueishtml="0" name=checkdate_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" )
  53. text(band=header alignment="2" text="经手人" border="0" color="33554432" x="745" y="8" height="56" width="233" html.valueishtml="0" name=checkemp_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" )
  54. text(band=header alignment="2" text="凭证号" border="0" color="33554432" x="987" y="8" height="56" width="517" html.valueishtml="0" name=relcode_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" )
  55. text(band=header alignment="2" text="结算方式" border="0" color="33554432" x="1513" y="8" height="56" width="361" html.valueishtml="0" name=banktypeid_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" )
  56. text(band=header alignment="2" text="转出帐号" border="0" color="33554432" x="1883" y="8" height="56" width="503" html.valueishtml="0" name=accountid_out_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" )
  57. text(band=header alignment="2" text="转入帐号" border="0" color="33554432" x="2395" y="8" height="56" width="521" html.valueishtml="0" name=accountid_in_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" )
  58. text(band=header alignment="2" text="转帐金额" border="0" color="33554432" x="2926" y="8" height="56" width="315" html.valueishtml="0" name=transferamt_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" )
  59. text(band=header alignment="2" text="备注" border="0" color="33554432" x="3250" y="8" height="56" width="535" html.valueishtml="0" name=dscrp_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" )
  60. text(band=header alignment="2" text="建立时间" border="0" color="33554432" x="4014" y="8" height="56" width="448" html.valueishtml="0" name=opdate_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" )
  61. text(band=header alignment="2" text="建立人" border="0" color="33554432" x="3794" y="8" height="56" width="210" html.valueishtml="0" name=opemp_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" )
  62. text(band=header alignment="2" text="修改时间" border="0" color="33554432" x="4713" y="8" height="56" width="457" html.valueishtml="0" name=moddate_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" )
  63. text(band=header alignment="2" text="修改人" border="0" color="33554432" x="4471" y="8" height="56" width="233" html.valueishtml="0" name=modemp_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" )
  64. text(band=header alignment="2" text="初审" border="0" color="33554432" x="5179" y="8" height="56" width="128" html.valueishtml="0" name=flag_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" )
  65. text(band=header alignment="2" text="初审人" border="0" color="33554432" x="5317" y="8" height="56" width="192" html.valueishtml="0" name=permit_emp_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" )
  66. text(band=header alignment="2" text="单据编号" border="0" color="33554432" x="9" y="8" height="56" width="407" html.valueishtml="0" name=billcode_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" )
  67. text(band=header alignment="2" text="初审时间" border="0" color="33554432" x="5518" y="8" height="56" width="521" html.valueishtml="0" name=permit_date_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="1073741824" )
  68. text(band=header alignment="2" text="终审" border="0" color="33554432" x="6048" y="8" height="56" width="165" 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="1073741824" )
  69. text(band=header alignment="2" text="终审人" border="0" color="33554432" x="6222" y="8" height="56" width="274" html.valueishtml="0" name=secemp_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="1073741824" )
  70. text(band=header alignment="2" text="终审时间" border="0" color="33554432" x="6505" y="8" height="56" width="599" html.valueishtml="0" name=secdate_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="1073741824" )
  71. compute(band=footer alignment="2" expression="count(billcode for all)"border="0" color="16711680" x="9" y="4" height="56" width="407" format="[general]" html.valueishtml="0" name=compute_1 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" )
  72. column(band=detail id=2 alignment="2" tabsequence=32766 border="0" color="33554432~tif(flag=0,rgb(255,0,0),if(secflag=0,rgb(128,0,128),rgb(0,0,0)))" x="425" y="4" height="68" width="311" format="yyyy-mm-dd" html.valueishtml="0" name=checkdate 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="2" background.color="1073741824" )
  73. column(band=detail id=3 alignment="0" tabsequence=32766 border="0" color="33554432~tif(flag=0,rgb(255,0,0),if(secflag=0,rgb(128,0,128),rgb(0,0,0)))" x="745" y="4" height="68" width="233" format="[general]" html.valueishtml="0" name=checkemp 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="2" background.color="1073741824" )
  74. column(band=detail id=4 alignment="0" tabsequence=32766 border="0" color="33554432~tif(flag=0,rgb(255,0,0),if(secflag=0,rgb(128,0,128),rgb(0,0,0)))" x="987" y="4" height="68" width="517" format="[general]" html.valueishtml="0" name=relcode 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="2" background.color="1073741824" )
  75. column(band=detail id=5 alignment="0" tabsequence=32766 border="0" color="33554432~tif(flag=0,rgb(255,0,0),if(secflag=0,rgb(128,0,128),rgb(0,0,0)))" x="1513" y="4" height="68" width="361" format="[general]" html.valueishtml="0" name=banktypeid visible="1" dddw.name=ddd_banktype dddw.displaycolumn=banktypename dddw.datacolumn=banktypeid dddw.percentwidth=0 dddw.lines=0 dddw.limit=0 dddw.allowedit=no dddw.useasborder=no dddw.case=any dddw.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" )
  76. column(band=detail id=6 alignment="0" tabsequence=32766 border="0" color="33554432~tif(flag=0,rgb(255,0,0),if(secflag=0,rgb(128,0,128),rgb(0,0,0)))" x="1883" y="4" height="68" width="503" format="[general]" html.valueishtml="0" name=accountid_out visible="1" dddw.name=ddd_accountsid dddw.displaycolumn=accountsname dddw.datacolumn=accountsid dddw.percentwidth=0 dddw.lines=0 dddw.limit=0 dddw.allowedit=no dddw.useasborder=no dddw.case=any dddw.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" )
  77. column(band=detail id=7 alignment="0" tabsequence=32766 border="0" color="33554432~tif(flag=0,rgb(255,0,0),if(secflag=0,rgb(128,0,128),rgb(0,0,0)))" x="2395" y="4" height="68" width="521" format="[general]" html.valueishtml="0" name=accountid_in visible="1" dddw.name=ddd_accountsid dddw.displaycolumn=accountsname dddw.datacolumn=accountsid dddw.percentwidth=0 dddw.lines=0 dddw.limit=0 dddw.allowedit=no dddw.useasborder=no dddw.case=any dddw.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" )
  78. column(band=detail id=8 alignment="1" tabsequence=32766 border="0" color="33554432~tif(flag=0,rgb(255,0,0),if(secflag=0,rgb(128,0,128),rgb(0,0,0)))" x="2926" y="4" height="68" width="315" format="#,##0.00" html.valueishtml="0" name=transferamt 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="2" background.color="1073741824" )
  79. column(band=detail id=9 alignment="0" tabsequence=32766 border="0" color="33554432~tif(flag=0,rgb(255,0,0),if(secflag=0,rgb(128,0,128),rgb(0,0,0)))" x="3250" y="4" height="68" width="535" format="[general]" html.valueishtml="0" name=dscrp 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="2" background.color="1073741824" )
  80. column(band=detail id=10 alignment="0" tabsequence=32766 border="0" color="33554432~tif(flag=0,rgb(255,0,0),if(secflag=0,rgb(128,0,128),rgb(0,0,0)))" x="4014" y="4" height="68" width="448" format="yyyy-mm-dd hh:mm" html.valueishtml="0" name=opdate 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="2" background.color="1073741824" )
  81. column(band=detail id=11 alignment="0" tabsequence=32766 border="0" color="33554432~tif(flag=0,rgb(255,0,0),if(secflag=0,rgb(128,0,128),rgb(0,0,0)))" x="3794" y="4" height="68" width="210" format="[general]" html.valueishtml="0" name=opemp 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="2" background.color="1073741824" )
  82. column(band=detail id=12 alignment="0" tabsequence=32766 border="0" color="33554432~tif(flag=0,rgb(255,0,0),if(secflag=0,rgb(128,0,128),rgb(0,0,0)))" x="4713" y="4" height="68" width="457" format="yyyy-mm-dd hh:mm" html.valueishtml="0" name=moddate 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="2" background.color="1073741824" )
  83. column(band=detail id=13 alignment="0" tabsequence=32766 border="0" color="33554432~tif(flag=0,rgb(255,0,0),if(secflag=0,rgb(128,0,128),rgb(0,0,0)))" x="4471" y="4" height="68" width="233" format="[general]" html.valueishtml="0" name=modemp 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="2" background.color="1073741824" )
  84. column(band=detail id=14 alignment="2" tabsequence=32766 border="0" color="33554432~tif(flag=0,rgb(255,0,0),if(secflag=0,rgb(128,0,128),rgb(0,0,0)))" x="5179" y="4" height="68" width="128" format="[general]" html.valueishtml="0" name=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="2" background.color="1073741824" )
  85. column(band=detail id=15 alignment="0" tabsequence=32766 border="0" color="33554432~tif(flag=0,rgb(255,0,0),if(secflag=0,rgb(128,0,128),rgb(0,0,0)))" x="5317" y="4" height="68" width="192" format="[general]" html.valueishtml="0" name=permit_emp 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="2" background.color="1073741824" )
  86. column(band=detail id=17 alignment="0" tabsequence=32766 border="0" color="33554432~tif(flag=0,rgb(255,0,0),if(secflag=0,rgb(128,0,128),rgb(0,0,0)))" x="9" y="4" height="68" width="407" format="[general]" html.valueishtml="0" name=billcode 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="2" background.color="1073741824" )
  87. column(band=detail id=16 alignment="0" tabsequence=32766 border="0" color="33554432~tif(flag=0,rgb(255,0,0),if(secflag=0,rgb(128,0,128),rgb(0,0,0)))" x="5518" y="4" height="68" width="521" format="yyyy-mm-dd hh:mm" html.valueishtml="0" name=permit_date 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="2" background.color="1073741824" )
  88. column(band=detail id=18 alignment="2" tabsequence=32766 border="0" color="33554432~tif(flag=0,rgb(255,0,0),if(secflag=0,rgb(128,0,128),rgb(0,0,0)))" x="6048" y="4" height="68" width="165" 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="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" )
  89. column(band=detail id=19 alignment="0" tabsequence=32766 border="0" color="33554432~tif(flag=0,rgb(255,0,0),if(secflag=0,rgb(128,0,128),rgb(0,0,0)))" x="6222" y="4" height="68" width="274" format="[general]" html.valueishtml="0" name=secemp 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="2" background.color="1073741824" )
  90. column(band=detail id=20 alignment="0" tabsequence=32766 border="0" color="33554432~tif(flag=0,rgb(255,0,0),if(secflag=0,rgb(128,0,128),rgb(0,0,0)))" x="6505" y="4" height="68" width="599" format="yyyy-mm-dd hh:mm" html.valueishtml="0" name=secdate 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="2" background.color="1073741824" )
  91. htmltable(border="1" )
  92. htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1" clientformatting="0" clientscriptable="0" generatejavascript="1" encodeselflinkargs="1" netscapelayers="0" )
  93. export.xml(headgroups="1" includewhitespace="0" metadatatype=0 savemetadata=0 )
  94. import.xml()
  95. export.pdf(method=0 distill.custompostscript="0" xslfop.print="0" )