Trang chủ Khám phá Trợ giúp
Đăng nhập
Neil
/
Q5
1
0
Fork 0
Các tập tin Các vấn đề 0 Yêu cầu khéo về 0 Wiki
Tree: ef56296430
Branches Tags
Q5
/
ws_objects
/
Ew_money.pbl.src
/
dw_inwaremx_buy_permit.srd

dw_inwaremx_buy_permit.srd 35 KB
Lịch sử Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165 
  1. $PBExportHeader$dw_inwaremx_buy_permit.srd
    2. 

  2. release 9;
    3. 

  3. datawindow(units=0 timer_interval=0 color=16777215 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. 

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

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

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

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

  8. table(column=(type=long updatewhereclause=yes name=u_inwaremx_mtrlid dbname="u_inwaremx.mtrlid" initial="0" )
    9. 

  9.  column=(type=long updatewhereclause=yes name=u_inwaremx_ifrel dbname="u_inwaremx.ifrel" initial="0" values="	1/	0" )
    10. 

  10.  column=(type=char(50) updatewhereclause=yes name=u_inwaremx_relcode dbname="u_inwaremx.relcode" initial="empty" )
    11. 

  11.  column=(type=char(30) updatewhereclause=yes name=u_mtrldef_mtrlcode dbname="u_mtrldef.mtrlcode" initial="empty" )
    12. 

  12.  column=(type=char(255) updatewhereclause=yes name=u_inwaremx_status dbname="u_inwaremx.status" initial="empty" )
    13. 

  13.  column=(type=char(255) updatewhereclause=yes name=u_inwaremx_woodcode dbname="u_inwaremx.woodcode" initial="empty" )
    14. 

  14.  column=(type=char(255) updatewhereclause=yes name=u_inwaremx_pcode dbname="u_inwaremx.pcode" initial="empty" )
    15. 

  15.  column=(type=char(30) updatewhereclause=yes name=u_inwaremx_unit dbname="u_inwaremx.unit" initial="empty" )
    16. 

  16.  column=(type=decimal(2) updatewhereclause=yes name=u_inwaremx_inputamt dbname="inputamt" initial="0" validationmsg="'请输入数字'" )
    17. 

  17.  column=(type=decimal(5) updatewhereclause=yes name=u_inwaremx_uqty dbname="u_inwaremx.uqty" initial="0" validationmsg="'请输入数字'" )
    18. 

  18.  column=(type=decimal(5) updatewhereclause=yes name=u_inwaremx_rate dbname="u_inwaremx.rate" initial="1" )
    19. 

  19.  column=(type=decimal(5) updatewhereclause=yes name=u_inwaremx_addqty dbname="u_inwaremx.addqty" initial="0" )
    20. 

  20.  column=(type=decimal(10) updatewhereclause=yes name=u_inwaremx_uprice dbname="u_inwaremx.uprice" initial="0" validationmsg="'请输入数字'" )
    21. 

  21.  column=(type=decimal(4) updatewhereclause=yes name=u_inwaremx_rebate dbname="u_inwaremx.rebate" initial="1" validationmsg="'请输入数字'" )
    22. 

  22.  column=(type=char(30) updatewhereclause=yes name=u_inwaremx_plancode dbname="u_inwaremx.plancode" initial="empty" )
    23. 

  23.  column=(type=char(255) updatewhereclause=yes name=u_inwaremx_mxdscrp dbname="u_inwaremx.mxdscrp" initial="empty" )
    24. 

  24.  column=(type=decimal(10) updatewhereclause=yes name=u_inwaremx_fprice dbname="u_inwaremx.fprice" initial="0" validationmsg="'请输入数字'" )
    25. 

  25.  column=(type=char(15) updatewhereclause=yes name=u_buytask_taskcode dbname="u_buyTask.taskcode" initial="empty" )
    26. 

  26.  column=(type=decimal(4) updatewhereclause=yes name=u_inwaremx_qty dbname="u_inwaremx.qty" initial="0" validationmsg="'请输入数字'" )
    27. 

  27.  column=(type=decimal(10) updatewhereclause=yes name=u_inwaremx_price dbname="u_inwaremx.price" initial="0" )
    28. 

  28.  column=(type=char(10) updatewhereclause=yes name=u_mtrldef_unit dbname="u_mtrldef.unit" initial="empty" )
    29. 

  29.  column=(type=char(50) updatewhereclause=yes name=u_mtrldef_mtrlname dbname="u_mtrldef.mtrlname" initial="empty" )
    30. 

  30.  column=(type=long updatewhereclause=yes name=u_inwaremx_inwareid dbname="u_inwaremx.inwareid" initial="0" )
    31. 

  31.  column=(type=long updatewhereclause=yes name=u_inwaremx_printid dbname="u_inwaremx.printid" initial="0" )
    32. 

  32.  column=(type=char(30) updatewhereclause=yes name=u_mtrldef_mtrlmode dbname="u_mtrldef.mtrlmode" initial="empty" )
    33. 

  33.  column=(type=long updatewhereclause=yes name=u_inwaremx_relid dbname="u_inwaremx.relid" initial="0" )
    34. 

  34.  column=(type=long updatewhereclause=yes name=u_inwaremx_sptid_cusid dbname="u_inwaremx.sptid_cusid" initial="0" )
    35. 

  35.  column=(type=decimal(6) updatewhereclause=yes name=amt dbname="amt" initial="0" )
    36. 

  36.  column=(type=decimal(10) updatewhereclause=yes name=u_inwaremx_cost dbname="u_inwaremx.cost" initial="0" )
    37. 

  37.  column=(type=char(50) updatewhereclause=yes name=u_inwaremx_sptmtrlname dbname="u_inwaremx.sptmtrlname" initial="empty" )
    38. 

  38.  column=(type=decimal(5) updatewhereclause=yes name=u_inwaremx_bootqty dbname="u_inwaremx.bootqty" initial="0" )
    39. 

  39.  column=(type=decimal(5) updatewhereclause=yes name=u_inwaremx_noauditqty dbname="u_inwaremx.noauditqty" initial="0" )
    40. 

  40.  column=(type=decimal(10) updatewhereclause=yes name=u_inwaremx_dftsptprice dbname="u_inwaremx.dftsptprice" initial="0" )
    41. 

  41.  column=(type=char(30) updatewhereclause=yes name=u_mtrldef_mtrlsectype dbname="u_mtrldef.mtrlsectype" initial="empty" )
    42. 

  42.  column=(type=char(50) updatewhereclause=yes name=u_mtrldef_zxmtrlmode dbname="u_mtrldef.zxmtrlmode" initial="empty" )
    43. 

  43.  column=(type=long updatewhereclause=yes name=u_mtrldef_statusflag dbname="u_mtrldef.statusflag" initial="0" )
    44. 

  44.  column=(type=long updatewhereclause=yes name=u_mtrldef_woodcodeflag dbname="u_mtrldef.woodcodeflag" initial="0" )
    45. 

  45.  column=(type=long updatewhereclause=yes name=u_mtrldef_pcodeflag dbname="u_mtrldef.pcodeflag" initial="0" )
    46. 

  46.  column=(type=char(30) updatewhereclause=yes name=u_buytask_relcode dbname="u_inwaremx.buytaskrelcode" initial="empty" )
    47. 

  47.  column=(type=decimal(5) updatewhereclause=yes name=wareqty dbname="wareqty" initial="0" )
    48. 

  48.  retrieve="SELECT u_inwaremx.mtrlid,
    49. 

  49. 	u_inwaremx.ifrel,
    50. 

  50. 	u_inwaremx.relcode ,
    51. 

  51. 	u_mtrldef.mtrlcode,
    52. 

  52. 	u_inwaremx.status ,
    53. 

  53. 	u_inwaremx.woodcode ,
    54. 

  54. 	u_inwaremx.pcode ,
    55. 

  55. 	u_inwaremx.unit,
    56. 

  56. 	0.00 as inputamt,
    57. 

  57. 	u_inwaremx.uqty,  
    58. 

  58. 	 u_inwaremx.rate,  
    59. 

  59. 	 u_inwaremx.addqty,
    60. 

  60. 	u_inwaremx.uprice,
    61. 

  61. 	u_inwaremx.rebate,
    62. 

  62. 	u_inwaremx.plancode,
    63. 

  63. 	u_inwaremx.mxdscrp,
    64. 

  64. 	u_inwaremx.fprice,
    65. 

  65. 	u_buytask.taskcode,
    66. 

  66. 	u_inwaremx.qty,
    67. 

  67. 	u_inwaremx.price,
    68. 

  68. 	u_mtrldef.unit,
    69. 

  69. 	u_mtrldef.mtrlname,
    70. 

  70. 	u_inwaremx.inwareid,
    71. 

  71. 	u_inwaremx.printid,
    72. 

  72. 	u_mtrldef.mtrlmode,
    73. 

  73. 	u_inwaremx.relid ,
    74. 

  74. 	u_inwaremx.sptid_cusid,
    75. 

  75. 	u_inwaremx.uprice*u_inwaremx.rebate*u_inwaremx.uqty  as amt,
    76. 

  76. 	u_inwaremx.cost ,
    77. 

  77. 	u_inwaremx.sptmtrlname  ,
    78. 

  78. 	u_inwaremx.bootqty  ,
    79. 

  79. 	u_inwaremx.noauditqty,
    80. 

  80. 	u_inwaremx.dftsptprice,
    81. 

  81. 	u_mtrldef.mtrlsectype,
    82. 

  82. 	u_mtrldef.zxmtrlmode,
    83. 

  83. 	u_mtrldef.statusflag,
    84. 

  84. u_mtrldef.woodcodeflag,
    85. 

  85. u_mtrldef.pcodeflag,
    86. 

  86. 	case when u_buytask.relcode is null then '' else u_buytask.relcode end as buytaskrelcode,
    87. 

  87. 	0.00000 as wareqty
    88. 

  88. 	FROM u_inwaremx LEFT OUTER JOIN u_buytask ON u_inwaremx.relid = u_buytask.taskid
    89. 

  89. 	AND u_inwaremx.scid = u_buytask.scid left outer join 
    90. 

  90. 	u_mtrldef on   ( u_inwaremx.mtrlid = u_mtrldef.mtrlid )
    91. 

  91. 	WHERE ( u_inwaremx.inwareid = :arg_inwareid ) AND
    92. 

  92. 	( u_inwaremx.scid = :arg_scid ) 
    93. 

  93. " arguments=(("arg_scid", number),("arg_inwareid", number))  sort="u_inwaremx_printid A " )
    94. 

  94. text(band=header alignment="2" text="品名" border="0" color="33554432" x="1029" y="8" height="56" width="608" html.valueishtml="0"  name=u_mtrldef_mtrlname_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" )
    95. 

  95. text(band=header alignment="2" text="入仓数量" border="0" color="33554432" x="7241" y="8" height="56" width="270" html.valueishtml="0"  name=u_inwaremx_qty_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" )
    96. 

  96. text(band=header alignment="2" text=" 规格" border="0" color="33554432" x="1646" y="8" height="56" width="375" html.valueishtml="0"  name=u_mtrldef_mtrlmode_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" )
    97. 

  97. text(band=header alignment="2" text="入仓单价" border="0" color="33554432" x="7520" y="8" height="56" width="274" html.valueishtml="0"  name=u_inwaremx_fprice_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" )
    98. 

  98. text(band=header alignment="2" text="折扣" border="0" color="33554432" x="5019" y="8" height="56" width="137" html.valueishtml="0"  name=u_inwaremx_rebate_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. 

  99. text(band=header alignment="2" text="入仓实价" border="0" color="33554432" x="7803" y="8" height="56" width="270" html.valueishtml="0"  name=u_inwaremx_price_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" )
    100. 

  100. text(band=header alignment="2" text="批号" border="0" color="33554432" x="5554" y="8" height="56" width="375" html.valueishtml="0"  name=u_inwaremx_plancode_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" )
    101. 

  101. text(band=header alignment="2" text="明细备注" border="0" color="33554432" x="5938" y="8" height="56" width="425" html.valueishtml="0"  name=u_inwaremx_mxdscrp_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" )
    102. 

  102. text(band=header alignment="2" text="序" border="0" color="33554432" x="9" y="8" height="56" width="64" html.valueishtml="0"  name=t_2 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. 

  103. text(band=header alignment="2" text=" 编码" border="0" color="33554432" x="672" y="8" height="56" width="347" html.valueishtml="0"  name=u_mtrldef_mtrlcode_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. 

  104. text(band=header alignment="2" text="订单" border="0" color="33554432" x="82" y="8" height="56" width="151" html.valueishtml="0"  name=u_inwaremx_ifrel_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. 

  105. text(band=header alignment="2" text="属性" border="0" color="33554432" x="2697" y="8" height="56" width="402" html.valueishtml="0"  name=u_inwaremx_status_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="16777215" )
    106. 

  106. text(band=header alignment="2" text="属性1" border="0" color="33554432" x="3109" y="8" height="56" width="352" html.valueishtml="0"  name=u_inwaremx_woodcode_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="16777215" )
    107. 

  107. text(band=header alignment="2" text="属性2" border="0" color="33554432" x="3470" y="8" height="56" width="375" html.valueishtml="0"  name=u_inwaremx_pcode_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="16777215" )
    108. 

  108. text(band=header alignment="2" text="物料别名" border="0" color="33554432" x="8082" y="8" height="56" width="521" html.valueishtml="0"  name=u_inwaremx_sptmtrlname_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. 

  109. text(band=header alignment="2" text="采购单位" border="0" color="33554432" x="3854" y="8" height="56" width="233" html.valueishtml="0"  name=u_inwaremx_unit_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="16777215" )
    110. 

  110. text(band=header alignment="2" text="数量" border="0" color="33554432" x="4096" y="8" height="56" width="311" html.valueishtml="0"  name=u_inwaremx_uqty_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="16777215" )
    111. 

  111. text(band=header alignment="2" text="单价" border="0" color="33554432" x="4727" y="8" height="56" width="283" html.valueishtml="0"  name=u_inwaremx_uprice_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="16777215" )
    112. 

  112. text(band=header alignment="2" text="转换率" border="0" color="33554432" x="6939" y="8" height="56" width="293" html.valueishtml="0"  name=u_inwaremx_rate_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="16777215" )
    113. 

  113. text(band=header alignment="2" text="本次应收数" border="0" color="33554432" x="8613" y="8" height="56" width="366" html.valueishtml="0"  name=u_inwaremx_bootqty_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="16777215" )
    114. 

  114. text(band=header alignment="2" text="超数量" border="0" color="33554432" x="8987" y="8" height="56" width="338" html.valueishtml="0"  name=t_1 visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
    115. 

  115. text(band=header alignment="2" text="库存单位" border="0" color="33554432" x="6697" y="8" height="56" width="233" html.valueishtml="0"  name=u_mtrldef_unit_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" )
    116. 

  116. text(band=header alignment="2" text="辅数" border="0" color="33554432" x="4416" y="8" height="56" width="302" html.valueishtml="0"  name=u_inwaremx_addqty_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" )
    117. 

  117. text(band=header alignment="2" text="自定义1" border="0" color="33554432" x="2030" y="8" height="56" width="334" html.valueishtml="0"  name=u_mtrldef_mtrlsectype_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" )
    118. 

  118. text(band=header alignment="2" text="自定义2" border="0" color="33554432" x="2373" y="8" height="56" width="315" html.valueishtml="0"  name=u_mtrldef_zxmtrlmode_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" )
    119. 

  119. text(band=header alignment="2" text="订单号" border="0" color="33554432" x="242" y="8" height="56" width="421" html.valueishtml="0"  name=u_inwaremx_relcode_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" )
    120. 

  120. text(band=header alignment="2" text="已收货数" border="0" color="33554432" x="9335" y="8" height="56" width="357" html.valueishtml="0"  name=u_inwaremx_noauditqty_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" )
    121. 

  121. text(band=header alignment="2" text="金额" border="0" color="33554432" x="5166" y="8" height="56" width="379" html.valueishtml="0"  name=amt_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" )
    122. 

  122. text(band=header alignment="2" text="报价" border="0" color="33554432" x="6373" y="8" height="56" width="315" html.valueishtml="0"  name=u_inwaremx_dftsptprice_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="16777215" )
    123. 

  123. text(band=header alignment="2" text="采购订单相关号" border="0" color="33554432" x="9701" y="8" height="56" width="512" html.valueishtml="0"  name=u_buytask_relcode_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. 

  124. text(band=header alignment="2" text="当前库存总量" border="0" color="33554432" x="10222" y="8" height="56" width="421" html.valueishtml="0"  name=wareqty_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. 

  125. column(band=detail id=22 alignment="0" tabsequence=32766 border="0" color="33554432" x="1029" y="4" height="68" width="608" format="[general]" html.valueishtml="0"  name=u_mtrldef_mtrlname  tag="物料名称" visible="1" edit.limit=50 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" )
    126. 

  126. column(band=detail id=19 alignment="1" tabsequence=32766 border="0" color="33554432" x="7241" y="4" height="68" width="270" format="#,##0.0###" html.valueishtml="0"  name=u_inwaremx_qty  tag="进仓数量" visible="1" edit.limit=0 edit.case=any edit.format="#########0.0###" 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" )
    127. 

  127. column(band=detail id=25 alignment="0" tabsequence=32766 border="0" color="33554432" x="1646" y="4" height="68" width="375" format="[general]" html.valueishtml="0"  name=u_mtrldef_mtrlmode 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" )
    128. 

  128. column(band=detail id=20 alignment="1" tabsequence=32766 border="0" color="33554432" x="7803" y="4" height="68" width="270" format="#,##0.##########" html.valueishtml="0"  name=u_inwaremx_price  tag="进仓单价" visible="1" edit.limit=0 edit.case=any edit.format="#,##0.##########" 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" )
    129. 

  129. column(band=detail id=17 alignment="1" tabsequence=32766 border="0" color="33554432" x="7520" y="4" height="68" width="274" format="#,##0.##########" html.valueishtml="0"  name=u_inwaremx_fprice visible="1" edit.limit=0 edit.case=any edit.format="#,##0.##########" 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" )
    130. 

  130. column(band=detail id=14 alignment="1" tabsequence=32766 border="0" color="33554432" x="5019" y="4" height="68" width="137" format="#,##0.0###" html.valueishtml="0"  name=u_inwaremx_rebate visible="1" edit.limit=0 edit.case=any edit.format="#,##0.0###" 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" )
    131. 

  131. column(band=detail id=15 alignment="0" tabsequence=32766 border="0" color="33554432" x="5554" y="4" height="68" width="375" format="[general]" html.valueishtml="0"  name=u_inwaremx_plancode 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" )
    132. 

  132. column(band=detail id=16 alignment="0" tabsequence=32766 border="0" color="33554432" x="5938" y="4" height="68" width="425" format="[general]" html.valueishtml="0"  name=u_inwaremx_mxdscrp visible="1" edit.limit=0 edit.case=any 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" )
    133. 

  133. compute(band=detail alignment="2" expression="getrow()"border="0" color="33554432" x="9" y="4" height="68" width="64" format="[general]" html.valueishtml="0"  name=printid 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" )
    134. 

  134. column(band=detail id=2 alignment="2" tabsequence=32766 border="0" color="33554432" x="82" y="4" height="68" width="151" format="[general]" html.valueishtml="0"  name=u_inwaremx_ifrel 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" )
    135. 

  135. column(band=detail id=4 alignment="0" tabsequence=32766 border="0" color="33554432" x="672" y="4" height="68" width="347" format="[general]" html.valueishtml="0"  name=u_mtrldef_mtrlcode  tag="物料编码" visible="1" edit.limit=30 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" )
    136. 

  136. column(band=detail id=5 alignment="0" tabsequence=32766 border="0" color="33554432" x="2697" y="4" height="68" width="402" format="[general]" html.valueishtml="0"  name=u_inwaremx_status visible="1" dddw.name=ddd_color dddw.displaycolumn=colorname dddw.datacolumn=colorname dddw.percentwidth=150 dddw.lines=0 dddw.limit=0 dddw.allowedit=yes 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="0" background.mode="2" background.color="16777215" )
    137. 

  137. column(band=detail id=6 alignment="0" tabsequence=32766 border="0" color="33554432" x="3109" y="4" height="68" width="352" format="[general]" html.valueishtml="0"  name=u_inwaremx_woodcode visible="1" dddw.name=ddd_color_wood dddw.displaycolumn=woodcode dddw.datacolumn=woodcode dddw.percentwidth=150 dddw.lines=0 dddw.limit=0 dddw.allowedit=yes 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" )
    138. 

  138. column(band=detail id=7 alignment="0" tabsequence=32766 border="0" color="33554432" x="3470" y="4" height="68" width="375" format="[general]" html.valueishtml="0"  name=u_inwaremx_pcode visible="1" dddw.name=ddd_color_pcode dddw.displaycolumn=pcode dddw.datacolumn=pcode dddw.percentwidth=150 dddw.lines=0 dddw.limit=0 dddw.allowedit=yes 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" )
    139. 

  139. column(band=detail id=30 alignment="0" tabsequence=32766 border="0" color="33554432" x="8082" y="4" height="68" width="521" format="[general]" html.valueishtml="0"  name=u_inwaremx_sptmtrlname 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" )
    140. 

  140. column(band=detail id=8 alignment="2" tabsequence=32766 border="0" color="33554432" x="3854" y="4" height="68" width="233" format="[general]" html.valueishtml="0"  name=u_inwaremx_unit visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0 edit.displayonly=yes  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    141. 

  141. column(band=detail id=13 alignment="1" tabsequence=32766 border="0" color="33554432" x="4727" y="4" height="68" width="283" format="#,##0.##########" html.valueishtml="0"  name=u_inwaremx_uprice visible="1" edit.limit=0 edit.case=any edit.format="#,##0.##########" 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" )
    142. 

  142. column(band=detail id=31 alignment="1" tabsequence=32766 border="0" color="33554432" x="8613" y="4" height="68" width="366" format="#,##0.0####" html.valueishtml="0"  name=u_inwaremx_bootqty 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" )
    143. 

  143. compute(band=detail alignment="1" expression="if ( u_inwaremx_ifrel =0 ,0 ,round(  u_inwaremx_uqty - u_inwaremx_bootqty    ,5))"border="0" color="33554432" x="8987" y="4" height="68" width="338" format="#,##0.0####" html.valueishtml="0"  name=compute_5 visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
    144. 

  144. column(band=detail id=11 alignment="1" tabsequence=32766 border="0" color="33554432" x="6939" y="4" height="68" width="293" format="#,##0.00###" html.valueishtml="0"  name=u_inwaremx_rate visible="1" edit.limit=0 edit.case=any edit.format="#,##0.#####" 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" )
    145. 

  145. column(band=detail id=21 alignment="2" tabsequence=32766 border="0" color="33554432" x="6697" y="4" height="68" width="233" format="[general]" html.valueishtml="0"  name=u_mtrldef_unit 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" )
    146. 

  146. column(band=detail id=10 alignment="1" tabsequence=32766 border="0" color="33554432" x="4096" y="4" height="68" width="311" format="#,##0.#####" html.valueishtml="0"  name=u_inwaremx_uqty visible="1" edit.limit=0 edit.case=any edit.format="#,##0.#####" 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" )
    147. 

  147. column(band=detail id=12 alignment="1" tabsequence=32766 border="0" color="33554432" x="4416" y="4" height="68" width="302" format="#,##0.#####" html.valueishtml="0"  name=u_inwaremx_addqty visible="1" edit.limit=0 edit.case=any edit.format="#,##0.#####" 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" )
    148. 

  148. column(band=detail id=34 alignment="0" tabsequence=32766 border="0" color="33554432" x="2030" y="4" height="68" width="334" format="[general]" html.valueishtml="0"  name=u_mtrldef_mtrlsectype 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="134" background.mode="2" background.color="16777215" )
    149. 

  149. column(band=detail id=35 alignment="0" tabsequence=32766 border="0" color="33554432" x="2373" y="4" height="68" width="315" format="[general]" html.valueishtml="0"  name=u_mtrldef_zxmtrlmode 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="134" background.mode="2" background.color="16777215" )
    150. 

  150. column(band=detail id=3 alignment="0" tabsequence=32766 border="0" color="33554432" x="242" y="4" height="68" width="421" format="[general]" html.valueishtml="0"  name=u_inwaremx_relcode 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" )
    151. 

  151. column(band=detail id=32 alignment="1" tabsequence=32766 border="0" color="33554432" x="9335" y="4" height="68" width="357" format="#,##0.0####" html.valueishtml="0"  name=u_inwaremx_noauditqty 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" )
    152. 

  152. column(band=detail id=28 alignment="1" tabsequence=32766 border="0" color="33554432" x="5166" y="4" height="68" width="379" format="#,##0.00" html.valueishtml="0"  name=amt 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="134" background.mode="2" background.color="16777215" )
    153. 

  153. column(band=detail id=33 alignment="1" tabsequence=32766 border="0" color="33554432" x="6373" y="4" height="68" width="315" format="#,##0.##########" html.valueishtml="0"  name=u_inwaremx_dftsptprice 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="134" background.mode="2" background.color="16777215" )
    154. 

  154. column(band=detail id=39 alignment="0" tabsequence=32766 border="0" color="33554432" x="9701" y="4" height="68" width="512" format="[general]" html.valueishtml="0"  name=u_buytask_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="134" background.mode="2" background.color="16777215" )
    155. 

  155. column(band=detail id=40 alignment="1" tabsequence=32766 border="0" color="33554432" x="10222" y="4" height="68" width="421" format="##,##0.#####" html.valueishtml="0"  name=wareqty visible="1" edit.limit=0 edit.case=any edit.format="##,##0.#####" 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="134" background.mode="2" background.color="16777215" )
    156. 

  156. compute(band=footer alignment="2" expression="count(  u_mtrldef_mtrlcode  for all )"border="0" color="33554432" x="672" y="4" height="56" width="347" format="[general]" html.valueishtml="0"  name=compute_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" )
    157. 

  157. compute(band=footer alignment="1" expression="sum(u_inwaremx_qty for all)"border="0" color="33554432" x="7241" y="4" height="56" width="270" format="#,##0.0###" html.valueishtml="0"  name=compute_3 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" )
    158. 

  158. compute(band=footer alignment="1" expression="sum(u_inwaremx_uqty for all)"border="0" color="33554432" x="4096" y="4" height="56" width="311" format="#,##0.0###" html.valueishtml="0"  name=compute_4 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" )
    159. 

  159. compute(band=footer alignment="1" expression="sum(u_inwaremx_addqty for all)"border="0" color="33554432" x="4416" y="4" height="56" width="302" format="#,##0.0###" html.valueishtml="0"  name=compute_6 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" )
    160. 

  160. compute(band=footer alignment="1" expression="sum(  amt  for all )"border="0" color="33554432" x="5166" y="4" height="56" width="379" format="#,##0.00" html.valueishtml="0"  name=compute_2 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" )
    161. 

  161. htmltable(border="1" )
    162. 

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

  163. export.xml(headgroups="1" includewhitespace="0" metadatatype=0 savemetadata=0  template=(comment="" encoding="gb2312" name="1" xml="<?xml version=~"1.0~" encoding=~"gb2312~" standalone=~"no~"?><dw_inwaremx_buy_edit><dw_inwaremx_buy_edit_row __pbband=~"detail~"><u_inwaremx_mtrlid>u_inwaremx_mtrlid</u_inwaremx_mtrlid><u_inwaremx_ifrel>u_inwaremx_ifrel</u_inwaremx_ifrel><u_inwaremx_relcode>u_inwaremx_relcode</u_inwaremx_relcode><u_mtrldef_mtrlcode>u_mtrldef_mtrlcode</u_mtrldef_mtrlcode><u_inwaremx_status>u_inwaremx_status</u_inwaremx_status><u_inwaremx_woodcode>u_inwaremx_woodcode</u_inwaremx_woodcode><u_inwaremx_pcode>u_inwaremx_pcode</u_inwaremx_pcode><u_inwaremx_unit>u_inwaremx_unit</u_inwaremx_unit><u_inwaremx_inputamt>u_inwaremx_inputamt</u_inwaremx_inputamt><u_inwaremx_uqty>u_inwaremx_uqty</u_inwaremx_uqty><u_inwaremx_rate>u_inwaremx_rate</u_inwaremx_rate><u_inwaremx_addqty>u_inwaremx_addqty</u_inwaremx_addqty><u_inwaremx_uprice>u_inwaremx_uprice</u_inwaremx_uprice><u_inwaremx_rebate>u_inwaremx_rebate</u_inwaremx_rebate><u_inwaremx_plancode>u_inwaremx_plancode</u_inwaremx_plancode><u_inwaremx_mxdscrp>u_inwaremx_mxdscrp</u_inwaremx_mxdscrp><u_inwaremx_fprice>u_inwaremx_fprice</u_inwaremx_fprice><u_buytask_taskcode>u_buytask_taskcode</u_buytask_taskcode><u_inwaremx_qty>u_inwaremx_qty</u_inwaremx_qty><u_inwaremx_price>u_inwaremx_price</u_inwaremx_price><u_mtrldef_unit>u_mtrldef_unit</u_mtrldef_unit><u_mtrldef_mtrlname>u_mtrldef_mtrlname</u_mtrldef_mtrlname><u_inwaremx_inwareid>u_inwaremx_inwareid</u_inwaremx_inwareid><u_inwaremx_printid>u_inwaremx_printid</u_inwaremx_printid><u_mtrldef_mtrlmode>u_mtrldef_mtrlmode</u_mtrldef_mtrlmode><u_inwaremx_relid>u_inwaremx_relid</u_inwaremx_relid><u_inwaremx_sptid_cusid>u_inwaremx_sptid_cusid</u_inwaremx_sptid_cusid><amt>amt</amt><u_inwaremx_cost>u_inwaremx_cost</u_inwaremx_cost><u_inwaremx_sptmtrlname>u_inwaremx_sptmtrlname</u_inwaremx_sptmtrlname><u_inwaremx_bootqty>u_inwaremx_bootqty</u_inwaremx_bootqty><u_inwaremx_noauditqty>u_inwaremx_noauditqty</u_inwaremx_noauditqty><u_inwaremx_dftsptprice>u_inwaremx_dftsptprice</u_inwaremx_dftsptprice><u_mtrldef_mtrlsectype>u_mtrldef_mtrlsectype</u_mtrldef_mtrlsectype><u_mtrldef_zxmtrlmode>u_mtrldef_zxmtrlmode</u_mtrldef_zxmtrlmode><u_mtrldef_statusflag/><u_mtrldef_woodcodeflag/><u_mtrldef_pcodeflag/></dw_inwaremx_buy_edit_row></dw_inwaremx_buy_edit>"))
    164. 

  164. import.xml()
    165. 

  165. export.pdf(method=0 distill.custompostscript="0" xslfop.print="0" )
    166.