Sākums Izpētīt Palīdzība
Pierakstīties
Neil
/
Q5
1
0
Atdalīts 0
Faili Problēmas 0 Izmaiņu pieprasījumi 0 Vikivietne
Koks: 4935c28b75
Atzari Tagi
Q5
/
ws_objects
/
Ew_sale_ls.pbl.src
/
dw_outware_pos_hisbill.srd

dw_outware_pos_hisbill.srd 14 KB
Vēsture Neapstrādāts

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136 
  1. $PBExportHeader$dw_outware_pos_hisbill.srd
    2. 

  2. release 9;
    3. 

  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 )
    4. 

  4. header(height=80 color="536870912" )
    5. 

  5. summary(height=0 color="536870912" )
    6. 

  6. footer(height=0 color="536870912" )
    7. 

  7. detail(height=80 color="536870912" )
    8. 

  8. table(column=(type=long update=yes updatewhereclause=yes key=yes name=scid dbname="u_outware.scid" )
    9. 

  9.  column=(type=long update=yes updatewhereclause=yes key=yes name=outwareid dbname="u_outware.outwareid" )
    10. 

  10.  column=(type=char(20) update=yes updatewhereclause=yes name=outwarecode dbname="u_outware.outwarecode" )
    11. 

  11.  column=(type=long update=yes updatewhereclause=yes name=billtype dbname="u_outware.billtype" )
    12. 

  12.  column=(type=long update=yes updatewhereclause=yes name=relid dbname="u_outware.relid" )
    13. 

  13.  column=(type=long update=yes updatewhereclause=yes name=storageid dbname="u_outware.StorageID" )
    14. 

  14.  column=(type=datetime update=yes updatewhereclause=yes name=opdate dbname="u_outware.opdate" )
    15. 

  15.  column=(type=char(10) update=yes updatewhereclause=yes name=opemp dbname="u_outware.opemp" )
    16. 

  16.  column=(type=char(10) update=yes updatewhereclause=yes name=modemp dbname="u_outware.Modemp" )
    17. 

  17.  column=(type=datetime update=yes updatewhereclause=yes name=moddate dbname="u_outware.moddate" )
    18. 

  18.  column=(type=long update=yes updatewhereclause=yes name=flag dbname="u_outware.flag" )
    19. 

  19.  column=(type=datetime update=yes updatewhereclause=yes name=auditingdate dbname="u_outware.auditingdate" )
    20. 

  20.  column=(type=char(10) update=yes updatewhereclause=yes name=auditingrep dbname="u_outware.auditingrep" )
    21. 

  21.  column=(type=datetime update=yes updatewhereclause=yes name=outdate dbname="u_outware.outdate" )
    22. 

  22.  column=(type=char(10) update=yes updatewhereclause=yes name=outrep dbname="u_outware.outrep" )
    23. 

  23.  column=(type=char(50) update=yes updatewhereclause=yes name=part dbname="u_outware.part" )
    24. 

  24.  column=(type=char(255) update=yes updatewhereclause=yes name=dscrp dbname="u_outware.dscrp" )
    25. 

  25.  column=(type=long update=yes updatewhereclause=yes name=cusid dbname="u_outware.cusid" )
    26. 

  26.  column=(type=char(30) update=yes updatewhereclause=yes name=cusname dbname="u_outware.cusname" )
    27. 

  27.  column=(type=long update=yes updatewhereclause=yes name=balcflag dbname="u_outware.balcflag" )
    28. 

  28.  column=(type=long update=yes updatewhereclause=yes name=balcdateint dbname="u_outware.balcdateint" )
    29. 

  29.  column=(type=long update=yes updatewhereclause=yes name=thflag dbname="u_outware.thflag" )
    30. 

  30.  column=(type=long update=yes updatewhereclause=yes name=secflag dbname="u_outware.secflag" )
    31. 

  31.  column=(type=datetime update=yes updatewhereclause=yes name=secauditingdate dbname="u_outware.secauditingdate" )
    32. 

  32.  column=(type=char(10) update=yes updatewhereclause=yes name=secauditingrep dbname="u_outware.secauditingrep" )
    33. 

  33.  column=(type=datetime update=yes updatewhereclause=yes name=sys_changetime dbname="u_outware.sys_changetime" )
    34. 

  34.  column=(type=long update=yes updatewhereclause=yes name=ctmint dbname="u_outware.ctmint" )
    35. 

  35.  column=(type=long update=yes updatewhereclause=yes name=printnum dbname="u_outware.printnum" )
    36. 

  36.  column=(type=long update=yes updatewhereclause=yes name=wagemth dbname="u_outware.wagemth" )
    37. 

  37.  column=(type=decimal(2) update=yes updatewhereclause=yes name=otheramt dbname="u_outware.otheramt" )
    38. 

  38.  column=(type=char(50) update=yes updatewhereclause=yes name=relstr_1 dbname="u_outware.relstr_1" )
    39. 

  39.  column=(type=char(50) update=yes updatewhereclause=yes name=relstr_2 dbname="u_outware.relstr_2" )
    40. 

  40.  column=(type=char(50) update=yes updatewhereclause=yes name=relstr_3 dbname="u_outware.relstr_3" )
    41. 

  41.  column=(type=long update=yes updatewhereclause=yes name=relint_1 dbname="u_outware.relint_1" )
    42. 

  42.  column=(type=long update=yes updatewhereclause=yes name=relint_2 dbname="u_outware.relint_2" )
    43. 

  43.  column=(type=long update=yes updatewhereclause=yes name=relint_3 dbname="u_outware.relint_3" )
    44. 

  44.  column=(type=long update=yes updatewhereclause=yes name=priceflag dbname="u_outware.priceflag" )
    45. 

  45.  column=(type=datetime update=yes updatewhereclause=yes name=pricedate dbname="u_outware.pricedate" )
    46. 

  46.  column=(type=char(20) update=yes updatewhereclause=yes name=priceemp dbname="u_outware.priceemp" )
    47. 

  47.  column=(type=char(4099) update=yes updatewhereclause=yes name=rel_address dbname="rel_address" )
    48. 

  48.  column=(type=char(100) update=yes updatewhereclause=yes name=rel_tele dbname="u_outware.rel_tele" )
    49. 

  49.  column=(type=char(100) update=yes updatewhereclause=yes name=rel_fax dbname="u_outware.rel_fax" )
    50. 

  50.  column=(type=char(30) update=yes updatewhereclause=yes name=rel_rep dbname="u_outware.rel_rep" )
    51. 

  51.  column=(type=decimal(5) update=yes updatewhereclause=yes name=mrate dbname="u_outware.mrate" )
    52. 

  52.  column=(type=long update=yes updatewhereclause=yes name=relid_incase dbname="u_outware.relid_incase" )
    53. 

  53.  column=(type=long update=yes updatewhereclause=yes name=lsflag dbname="u_outware.lsflag" )
    54. 

  54.  column=(type=decimal(5) update=yes updatewhereclause=yes name=totalamt dbname="u_outware.totalamt" )
    55. 

  55.  column=(type=decimal(5) update=yes updatewhereclause=yes name=getamt dbname="u_outware.getamt" )
    56. 

  56.  column=(type=decimal(5) updatewhereclause=yes name=backamt dbname="backamt" )
    57. 

  57.  retrieve="  SELECT u_outware.scid,   
    58. 

  58.          u_outware.outwareid,   
    59. 

  59.          u_outware.outwarecode,   
    60. 

  60.          u_outware.billtype,   
    61. 

  61.          u_outware.relid,   
    62. 

  62.          u_outware.StorageID,   
    63. 

  63.          u_outware.opdate,   
    64. 

  64.          u_outware.opemp,   
    65. 

  65.          u_outware.Modemp,   
    66. 

  66.          u_outware.moddate,   
    67. 

  67.          u_outware.flag,   
    68. 

  68.          u_outware.auditingdate,   
    69. 

  69.          u_outware.auditingrep,   
    70. 

  70.          u_outware.outdate,   
    71. 

  71.          u_outware.outrep,   
    72. 

  72.          u_outware.part,   
    73. 

  73.          u_outware.dscrp,   
    74. 

  74.          u_outware.cusid,   
    75. 

  75.          u_outware.cusname,   
    76. 

  76.          u_outware.balcflag,   
    77. 

  77.          u_outware.balcdateint,   
    78. 

  78.          u_outware.thflag,   
    79. 

  79.          u_outware.secflag,   
    80. 

  80.          u_outware.secauditingdate,   
    81. 

  81.          u_outware.secauditingrep,   
    82. 

  82.          u_outware.sys_changetime,   
    83. 

  83.          u_outware.ctmint,   
    84. 

  84.          u_outware.printnum,   
    85. 

  85.          u_outware.wagemth,   
    86. 

  86.          u_outware.otheramt,   
    87. 

  87.          u_outware.relstr_1,   
    88. 

  88.          u_outware.relstr_2,   
    89. 

  89.          u_outware.relstr_3,   
    90. 

  90.          u_outware.relint_1,   
    91. 

  91.          u_outware.relint_2,   
    92. 

  92.          u_outware.relint_3,   
    93. 

  93.          u_outware.priceflag,   
    94. 

  94.          u_outware.pricedate,   
    95. 

  95.          u_outware.priceemp,   
    96. 

  96.          convert (text,u_outware.rel_address) as rel_address,  
    97. 

  97.          u_outware.rel_tele,   
    98. 

  98.          u_outware.rel_fax,   
    99. 

  99.          u_outware.rel_rep,   
    100. 

  100.          u_outware.mrate,   
    101. 

  101.          u_outware.relid_incase,   
    102. 

  102.          u_outware.lsflag,   
    103. 

  103.          u_outware.totalamt,   
    104. 

  104.          u_outware.getamt,   
    105. 

  105.          getamt - totalamt as backamt  
    106. 

  106.     FROM u_outware  
    107. 

  107.    WHERE ( u_outware.billtype = 1 ) AND  
    108. 

  108.          ( u_outware.thflag = 0 ) AND  
    109. 

  109.          (u_outware.opemp = :arg_emp OR  
    110. 

  110.          :arg_emp = '') AND  
    111. 

  111.          (u_outware.outdate >= :arg_firstdate) AND  
    112. 

  112.          (u_outware.outdate <= :arg_enddate) AND  
    113. 

  113.          (u_outware.lsflag = 1 )  and
    114. 

  114. 			(u_outware.scid = :arg_scid)  
    115. 

  115. " update="u_outware" updatewhere=1 updatekeyinplace=no arguments=(("arg_scid", number),("arg_emp", string),("arg_firstdate", datetime),("arg_enddate", datetime)) )
    116. 

  116. text(band=header alignment="2" text="单据号码" border="0" color="33554432" x="9" y="8" height="68" width="576" html.valueishtml="0"  name=outwarecode_t visible="1"  font.face="宋体" font.height="-11" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
    117. 

  117. text(band=header alignment="2" text="建立时间" border="0" color="33554432" x="594" y="8" height="68" width="603" html.valueishtml="0"  name=opdate_t visible="1"  font.face="宋体" font.height="-11" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
    118. 

  118. text(band=header alignment="2" text="建立人" border="0" color="33554432" x="2281" y="8" height="68" width="384" html.valueishtml="0"  name=opemp_t visible="1"  font.face="宋体" font.height="-11" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
    119. 

  119. text(band=header alignment="2" text="修改人" border="0" color="33554432" x="3287" y="8" height="68" width="302" html.valueishtml="0"  name=modemp_t visible="1"  font.face="宋体" font.height="-11" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
    120. 

  120. text(band=header alignment="2" text="修改日期" border="0" color="33554432" x="2674" y="8" height="68" width="603" html.valueishtml="0"  name=moddate_t visible="1"  font.face="宋体" font.height="-11" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
    121. 

  121. text(band=header alignment="2" text="应收" border="0" color="33554432" x="1207" y="8" height="68" width="329" html.valueishtml="0"  name=totalamt_t visible="1"  font.face="宋体" font.height="-11" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
    122. 

  122. text(band=header alignment="2" text="实收" border="0" color="33554432" x="1545" y="8" height="68" width="329" html.valueishtml="0"  name=getamt_t visible="1"  font.face="宋体" font.height="-11" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
    123. 

  123. text(band=header alignment="2" text="找回" border="0" color="33554432" x="1883" y="8" height="68" width="389" html.valueishtml="0"  name=backamt_t visible="1"  font.face="宋体" font.height="-11" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" )
    124. 

  124. column(band=detail id=3 alignment="0" tabsequence=32766 border="0" color="33554432" x="9" y="4" height="72" width="576" format="[general]" html.valueishtml="0"  name=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="-11" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
    125. 

  125. column(band=detail id=7 alignment="0" tabsequence=32766 border="0" color="33554432" x="594" y="4" height="72" width="603" format="yyyy-mm-dd hh:mm" html.valueishtml="0"  name=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="-11" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
    126. 

  126. column(band=detail id=8 alignment="0" tabsequence=32766 border="0" color="33554432" x="2281" y="4" height="72" width="384" format="[general]" html.valueishtml="0"  name=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="-11" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
    127. 

  127. column(band=detail id=9 alignment="0" tabsequence=32766 border="0" color="33554432" x="3287" y="4" height="72" width="302" format="[general]" html.valueishtml="0"  name=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="-11" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
    128. 

  128. column(band=detail id=10 alignment="0" tabsequence=32766 border="0" color="33554432" x="2674" y="4" height="72" width="603" format="[shortdate] [time]" html.valueishtml="0"  name=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="-11" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
    129. 

  129. column(band=detail id=47 alignment="1" tabsequence=32766 border="0" color="33554432" x="1207" y="4" height="72" width="329" format="#,##0.00" html.valueishtml="0"  name=totalamt visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="宋体" font.height="-11" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
    130. 

  130. column(band=detail id=48 alignment="1" tabsequence=32766 border="0" color="33554432" x="1545" y="4" height="72" width="329" format="#,##0.00" html.valueishtml="0"  name=getamt visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="宋体" font.height="-11" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
    131. 

  131. column(band=detail id=49 alignment="0" tabsequence=32766 border="0" color="33554432" x="1883" y="4" height="72" width="389" format="#,##0.00" html.valueishtml="0"  name=backamt visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="宋体" font.height="-11" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
    132. 

  132. htmltable(border="1" )
    133. 

  133. htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1" clientformatting="0" clientscriptable="0" generatejavascript="1" encodeselflinkargs="1" netscapelayers="0" )
    134. 

  134. export.xml(headgroups="1" includewhitespace="0" metadatatype=0 savemetadata=0 )
    135. 

  135. import.xml()
    136. 

  136. export.pdf(method=0 distill.custompostscript="0" xslfop.print="0" )
    137.