dw_outware_sale_wareaudit_edit_th.srd 22 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131
  1. $PBExportHeader$dw_outware_sale_wareaudit_edit_th.srd
  2. release 9;
  3. 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 )
  4. summary(height=0 color="536870912" )
  5. footer(height=0 color="536870912" )
  6. detail(height=816 color="536870912" )
  7. table(column=(type=long updatewhereclause=yes name=u_outware_outwareid dbname="u_outware.outwareid" initial="0" )
  8. column=(type=long updatewhereclause=yes name=u_outware_storageid dbname="u_outware.StorageID" initial="0" )
  9. column=(type=long updatewhereclause=yes name=u_outware_relint_2 dbname="u_outware.relint_2" initial="0" )
  10. column=(type=decimal(5) updatewhereclause=yes name=u_outware_mrate dbname="u_outware.mrate" initial="0" )
  11. column=(type=long updatewhereclause=yes name=u_outware_relint_1 dbname="u_outware.relint_1" initial="0" )
  12. column=(type=char(50) updatewhereclause=yes name=u_outware_part dbname="u_outware.part" initial="empty" )
  13. column=(type=char(20) updatewhereclause=yes name=u_cust_cuscode dbname="u_cust.cuscode" initial="empty" )
  14. column=(type=datetime updatewhereclause=yes name=u_outware_outdate dbname="u_outware.outdate" initial="today" )
  15. column=(type=char(10) updatewhereclause=yes name=u_outware_outrep dbname="u_outware.outrep" initial="empty" )
  16. column=(type=decimal(2) updatewhereclause=yes name=u_outware_otheramt dbname="u_outware.otheramt" initial="0" )
  17. column=(type=char(50) updatewhereclause=yes name=u_outware_relstr_1 dbname="u_outware.relstr_1" initial="empty" )
  18. column=(type=char(50) updatewhereclause=yes name=u_outware_relstr_2 dbname="u_outware.relstr_2" initial="empty" )
  19. column=(type=char(255) updatewhereclause=yes name=u_outware_dscrp dbname="u_outware.dscrp" initial="empty" )
  20. column=(type=char(50) updatewhereclause=yes name=u_cust_name dbname="u_cust.name" initial="empty" )
  21. column=(type=char(20) updatewhereclause=yes name=u_outware_outwarecode dbname="u_outware.outwarecode" initial="empty" )
  22. column=(type=datetime updatewhereclause=yes name=u_outware_opdate dbname="u_outware.opdate" initial="today" )
  23. column=(type=char(10) updatewhereclause=yes name=u_outware_opemp dbname="u_outware.opemp" )
  24. column=(type=datetime updatewhereclause=yes name=u_outware_auditingdate dbname="u_outware.auditingdate" )
  25. column=(type=long updatewhereclause=yes name=flag dbname="u_outware.flag" initial="0" values=" 1/ 0" )
  26. column=(type=char(10) updatewhereclause=yes name=u_outware_auditingrep dbname="u_outware.auditingrep" initial="empty" )
  27. column=(type=long updatewhereclause=yes name=u_outware_cusid dbname="u_outware.cusid" initial="0" )
  28. column=(type=long updatewhereclause=yes name=u_outware_balcflag dbname="u_outware.balcflag" initial="0" values=" 1/ 0" )
  29. column=(type=long updatewhereclause=yes name=u_outware_relid dbname="u_outware.relid" initial="0" )
  30. column=(type=char(30) updatewhereclause=yes name=u_storage_storagename dbname="u_storage.storagename" initial="empty" )
  31. column=(type=long updatewhereclause=yes name=u_outware_thflag dbname="u_outware.thflag" initial="0" values=" 1/ 0" )
  32. column=(type=datetime updatewhereclause=yes name=u_outware_secauditingdate dbname="u_outware.secauditingdate" )
  33. column=(type=long updatewhereclause=yes name=secflag dbname="u_outware.secflag" values=" 1/ 0" )
  34. column=(type=char(10) updatewhereclause=yes name=u_outware_secauditingrep dbname="u_outware.secauditingrep" )
  35. column=(type=datetime updatewhereclause=yes name=u_outware_pricedate dbname="u_outware.pricedate" )
  36. column=(type=long updatewhereclause=yes name=u_outware_priceflag dbname="u_outware.priceflag" values=" 1/ 0" )
  37. column=(type=char(20) updatewhereclause=yes name=u_outware_priceemp dbname="u_outware.priceemp" )
  38. column=(type=char(10) updatewhereclause=yes name=u_outware_modemp dbname="u_outware.modemp" )
  39. column=(type=datetime updatewhereclause=yes name=u_outware_moddate dbname="u_outware.moddate" )
  40. column=(type=long updatewhereclause=yes name=u_outware_scid dbname="u_outware.scid" )
  41. column=(type=long updatewhereclause=yes name=u_outware_printnum dbname="u_outware.printnum" )
  42. column=(type=long updatewhereclause=yes name=u_outware_balcdateint dbname="u_outware.balcdateint" )
  43. retrieve="select top 0 u_outware.outwareid ,
  44. u_outware.StorageID ,
  45. u_outware.relint_2,
  46. u_outware.mrate,
  47. u_outware.relint_1,
  48. u_outware.part ,
  49. u_cust.cuscode ,
  50. u_outware.outdate ,
  51. u_outware.outrep ,
  52. u_outware.otheramt ,
  53. u_outware.relstr_1,
  54. u_outware.relstr_2,
  55. u_outware.dscrp ,
  56. u_cust.name ,
  57. u_outware.outwarecode ,
  58. u_outware.opdate ,
  59. u_outware.opemp ,
  60. u_outware.auditingdate ,
  61. u_outware.flag ,
  62. u_outware.auditingrep ,
  63. u_outware.cusid ,
  64. u_outware.balcflag ,
  65. u_outware.relid ,
  66. u_storage.storagename ,
  67. u_outware.thflag ,
  68. u_outware.secauditingdate ,
  69. u_outware.secflag ,
  70. u_outware.secauditingrep,
  71. u_outware.pricedate ,
  72. u_outware.priceflag ,
  73. u_outware.priceemp,
  74. u_outware.modemp,
  75. u_outware.moddate,
  76. u_outware.scid,
  77. u_outware.printnum,
  78. u_outware.balcdateint
  79. FROM u_outware,
  80. u_cust ,
  81. u_storage
  82. WHERE ( u_cust.cusid = u_outware.cusid ) AND
  83. ( u_outware.StorageID = u_storage.storageid ) AND
  84. ( u_outware.billtype = 1 )
  85. " sort="u_outware_outwarecode D " )
  86. 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" )
  87. 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" )
  88. 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" )
  89. 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" )
  90. 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" )
  91. 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" )
  92. 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" )
  93. 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" )
  94. 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" )
  95. 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" )
  96. 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" )
  97. 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" )
  98. 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" )
  99. 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" )
  100. 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" )
  101. 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" )
  102. 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" )
  103. 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" )
  104. 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" )
  105. 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" )
  106. 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" )
  107. 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" )
  108. 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" )
  109. 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" )
  110. 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" )
  111. 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" )
  112. 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" )
  113. 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" )
  114. 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" )
  115. 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" )
  116. 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" )
  117. 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" )
  118. 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" )
  119. 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" )
  120. 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" )
  121. 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" )
  122. 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" )
  123. 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" )
  124. 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" )
  125. 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" )
  126. 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" )
  127. htmltable(border="1" )
  128. htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1" clientformatting="0" clientscriptable="0" generatejavascript="1" encodeselflinkargs="1" netscapelayers="0" )
  129. export.xml(headgroups="1" includewhitespace="0" metadatatype=0 savemetadata=0 )
  130. import.xml()
  131. export.pdf(method=0 distill.custompostscript="0" xslfop.print="0" )