Halaman utama Jelajahi Bantuan
Masuk
Neil
/
Q5
1
0
Fork 0
Berkas Masalah 0 Tarik Permintaan 0 Wiki
Cabang: master
Ranting Tag
Q5
/
ws_objects
/
Ew_mrp.pbl.src
/
dw_rp_mtrl_will_rqqty.srd

dw_rp_mtrl_will_rqqty.srd 89 KB
Permalink Riwayat Mentahan

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371 
  1. $PBExportHeader$dw_rp_mtrl_will_rqqty.srd
    2. 

  2. release 11.5;
    3. 

  3. datawindow(units=0 timer_interval=0 color=16777215 brushmode=0 transparency=0 gradient.angle=0 gradient.color=8421504 gradient.focus=0 gradient.repetition.count=0 gradient.repetition.length=100 gradient.repetition.mode=0 gradient.scale=100 gradient.spread=100 gradient.transparency=0 picture.blur=0 picture.clip.bottom=0 picture.clip.left=0 picture.clip.right=0 picture.clip.top=0 picture.mode=0 picture.scale.x=100 picture.scale.y=100 picture.transparency=0 processing=1 HTMLDW=no print.printername="" print.documentname="" print.orientation = 1 print.margin.left = 110 print.margin.right = 110 print.margin.top = 96 print.margin.bottom = 96 print.paper.source = 0 print.paper.size = 9 print.canusedefaultprinter=yes print.prompt=no print.buttons=no print.preview.buttons=no print.cliptext=no print.overrideprintjob=no print.collate=yes print.background=no print.preview.background=no print.preview.outline=yes hidegrayline=no showbackcoloronxp=no picture.file="" grid.lines=0 selected.mouse=no )
    4. 

  4. header(height=80 color="536870912" transparency="0" gradient.color="8421504" gradient.transparency="0" gradient.angle="0" brushmode="0" gradient.repetition.mode="0" gradient.repetition.count="0" gradient.repetition.length="100" gradient.focus="0" gradient.scale="100" gradient.spread="100" )
    5. 

  5. summary(height=0 color="536870912" transparency="0" gradient.color="8421504" gradient.transparency="0" gradient.angle="0" brushmode="0" gradient.repetition.mode="0" gradient.repetition.count="0" gradient.repetition.length="100" gradient.focus="0" gradient.scale="100" gradient.spread="100" )
    6. 

  6. footer(height=64 color="536870912" transparency="0" gradient.color="8421504" gradient.transparency="0" gradient.angle="0" brushmode="0" gradient.repetition.mode="0" gradient.repetition.count="0" gradient.repetition.length="100" gradient.focus="0" gradient.scale="100" gradient.spread="100" )
    7. 

  7. detail(height=76 color="536870912" transparency="0" gradient.color="8421504" gradient.transparency="0" gradient.angle="0" brushmode="0" gradient.repetition.mode="0" gradient.repetition.count="0" gradient.repetition.length="100" gradient.focus="0" gradient.scale="100" gradient.spread="100" )
    8. 

  8. table(column=(type=long updatewhereclause=yes identity=yes name=uv_mtrl_willuse_mtrlid dbname="uv_mtrl_willuse.mtrlid" )
    9. 

  9.  column=(type=char(255) updatewhereclause=yes name=uv_mtrl_willuse_status dbname="uv_mtrl_willuse.status" )
    10. 

  10.  column=(type=char(255) updatewhereclause=yes name=uv_mtrl_willuse_woodcode dbname="uv_mtrl_willuse.woodcode" )
    11. 

  11.  column=(type=char(255) updatewhereclause=yes name=uv_mtrl_willuse_pcode dbname="uv_mtrl_willuse.pcode" )
    12. 

  12.  column=(type=long updatewhereclause=yes identity=yes name=uv_mtrl_willuse_plantype dbname="uv_mtrl_willuse.plantype" )
    13. 

  13.  column=(type=char(30) updatewhereclause=yes name=u_mtrldef_mtrlcode dbname="u_mtrldef.mtrlcode" )
    14. 

  14.  column=(type=char(50) updatewhereclause=yes name=u_mtrldef_mtrlname dbname="u_mtrldef.mtrlname" )
    15. 

  15.  column=(type=char(30) updatewhereclause=yes name=u_mtrldef_mtrlmode dbname="u_mtrldef.mtrlmode" )
    16. 

  16.  column=(type=char(30) updatewhereclause=yes name=u_mtrldef_mtrltype dbname="u_mtrldef.mtrltype" )
    17. 

  17.  column=(type=char(10) updatewhereclause=yes name=u_mtrldef_unit dbname="u_mtrldef.unit" )
    18. 

  18.  column=(type=decimal(5) updatewhereclause=yes identity=yes name=u_mtrldef_maxminqty_minqty dbname="u_mtrldef_maxminqty.minqty" )
    19. 

  19.  column=(type=decimal(5) updatewhereclause=yes identity=yes name=u_mtrldef_maxminqty_maxqty dbname="u_mtrldef_maxminqty.maxqty" )
    20. 

  20.  column=(type=long updatewhereclause=yes identity=yes name=u_mtrldef_mtrlorigin dbname="u_mtrldef.mtrlorigin" )
    21. 

  21.  column=(type=long updatewhereclause=yes identity=yes name=u_mtrldef_mtrlprp dbname="u_mtrldef.mtrlprp" )
    22. 

  22.  column=(type=long updatewhereclause=yes identity=yes name=u_mtrldef_mtrlkind dbname="u_mtrldef.mtrlkind" )
    23. 

  23.  column=(type=long updatewhereclause=yes identity=yes name=u_mtrldef_dftsptid dbname="u_mtrldef.dftsptid" )
    24. 

  24.  column=(type=long updatewhereclause=yes identity=yes name=u_mtrldef_mrp_unit dbname="u_mtrldef.mrp_unit" )
    25. 

  25.  column=(type=char(20) updatewhereclause=yes name=u_mtrldef_unit_buy dbname="u_mtrldef.unit_buy" )
    26. 

  26.  column=(type=decimal(5) updatewhereclause=yes identity=yes name=u_mtrldef_rate_buy dbname="u_mtrldef.rate_buy" )
    27. 

  27.  column=(type=char(20) updatewhereclause=yes name=u_mtrldef_unit_scll dbname="u_mtrldef.unit_scll" )
    28. 

  28.  column=(type=decimal(5) updatewhereclause=yes identity=yes name=u_mtrldef_rate_scll dbname="u_mtrldef.rate_scll" )
    29. 

  29.  column=(type=char(20) updatewhereclause=yes name=u_mtrldef_unit_sale dbname="u_mtrldef.unit_sale" )
    30. 

  30.  column=(type=decimal(5) updatewhereclause=yes identity=yes name=u_mtrldef_rate_sale dbname="u_mtrldef.rate_sale" )
    31. 

  31.  column=(type=long updatewhereclause=yes identity=yes name=u_mtrldef_buyunit dbname="u_mtrldef.buyunit" )
    32. 

  32.  column=(type=long updatewhereclause=yes identity=yes name=selectflag dbname="selectflag" values="	1/	0" )
    33. 

  33.  column=(type=decimal(5) updatewhereclause=yes identity=yes name=u_mtrlware_noallocqty dbname="noallocqty" )
    34. 

  34.  column=(type=decimal(5) updatewhereclause=yes identity=yes name=taskqty dbname="taskqty" )
    35. 

  35.  column=(type=decimal(10) updatewhereclause=yes identity=yes name=u_orderrqmtrl_rqqty dbname="rqqty" )
    36. 

  36.  column=(type=decimal(10) updatewhereclause=yes identity=yes name=uv_mtrl_willfinish_buytask_buytaskqty dbname="buytaskqty" )
    37. 

  37.  column=(type=decimal(5) updatewhereclause=yes identity=yes name=uv_mtrl_willfinish_order_ml_ordermlqty dbname="ordermlqty" )
    38. 

  38.  column=(type=decimal(5) updatewhereclause=yes identity=yes name=wfjgqty dbname="wfjgqty" )
    39. 

  39.  column=(type=decimal(5) updatewhereclause=yes identity=yes name=truerqqty dbname="truerqqty" )
    40. 

  40.  column=(type=char(20) updatewhereclause=yes name=sptcode dbname="sptcode" )
    41. 

  41.  column=(type=char(50) updatewhereclause=yes name=sptname dbname="sptname" )
    42. 

  42.  column=(type=char(50) updatewhereclause=yes name=u_mtrldef_mtrlsectype dbname="u_mtrldef.mtrlsectype" )
    43. 

  43.  column=(type=char(255) updatewhereclause=yes name=u_mtrldef_zxmtrlmode dbname="u_mtrldef.zxmtrlmode" )
    44. 

  44.  column=(type=decimal(2) updatewhereclause=yes identity=yes name=install_cmplqty dbname="install_cmplqty" )
    45. 

  45.  column=(type=decimal(5) updatewhereclause=yes identity=yes name=noassignqty dbname="noAssignQty" )
    46. 

  46.  column=(type=decimal(5) updatewhereclause=yes identity=yes name=unuse_noallocqty dbname="unuse_noallocqty" )
    47. 

  47.  retrieve="  SELECT uv_mtrl_willuse.mtrlid,
    48. 

  48. 			uv_mtrl_willuse.status,
    49. 

  49. 			uv_mtrl_willuse.woodcode,
    50. 

  50. 			uv_mtrl_willuse.pcode,
    51. 

  51. 			uv_mtrl_willuse.plantype,
    52. 

  52. 			u_mtrldef.mtrlcode,    
    53. 

  53.          u_mtrldef.mtrlname,   
    54. 

  54.          u_mtrldef.mtrlmode,   
    55. 

  55.          u_mtrldef.mtrltype,   
    56. 

  56. 		u_mtrldef.unit,   
    57. 

  57. 		u_mtrldef_maxminqty.minqty as minqty,   
    58. 

  58. 		u_mtrldef_maxminqty.maxqty as maxqty,   
    59. 

  59. 		u_mtrldef.mtrlorigin,    
    60. 

  60. 		u_mtrldef.mtrlprp,   
    61. 

  61. 		u_mtrldef.mtrlkind,   
    62. 

  62. 		u_mtrldef.dftsptid,   
    63. 

  63. 		u_mtrldef.mrp_unit,   
    64. 

  64. 		u_mtrldef.unit_buy,   
    65. 

  65. 		u_mtrldef.rate_buy,   
    66. 

  66. 		u_mtrldef.unit_scll,   
    67. 

  67. 		u_mtrldef.rate_scll,   
    68. 

  68. 		u_mtrldef.unit_sale,   
    69. 

  69. 		u_mtrldef.rate_sale, 
    70. 

  70. 		u_mtrldef.buyunit,
    71. 

  71. 		0 as selectflag,  
    72. 

  72. 		sum(isnull( uv_mtrlware2.noallocqty,0 )) as noallocqty,   
    73. 

  73. 		sum(isnull(uv_mtrl_willuse.taskqty,0)) as taskqty,   
    74. 

  74. 		sum(isnull(uv_mtrl_willuse.RqQty,0)) as rqqty,   
    75. 

  75. 		sum(isnull(uv_materiel_willfinish_buytask.qty,0)) as buytaskqty,   
    76. 

  76. 		sum(isnull(uv_materiel_willfinish_order_ml.qty,0)) as ordermlqty ,   
    77. 

  77. 		sum(isnull(uv_materiel_willfinish_wfjg.qty,0)) as wfjgqty ,  
    78. 

  78. 		sum(isnull(uv_mtrl_willuse.RqQty,0) * :arg_ifrqqty) + isnull(u_mtrldef_maxminqty.minqty,0) * :arg_ifminqty + sum(isnull(uv_mtrl_willuse.taskqty,0))* :arg_iftaskqty
    79. 

  79. 			- sum(isnull( uv_mtrlware2.noallocqty,0 )) * :arg_ifnoallocqty - sum(isnull(uv_materiel_willfinish_buytask.qty,0)) * :arg_ifbuytask 
    80. 

  80. 			- sum(isnull(uv_materiel_willfinish_order_ml.qty,0)) * :arg_iforder - sum(isnull(uv_materiel_willfinish_wfjg.qty,0)) * :arg_ifwfjg as truerqqty,
    81. 

  81. 		isnull(u_spt.sptcode, '') as sptcode,
    82. 

  82. 		isnull(u_spt.name, '') as sptname,
    83. 

  83.          u_mtrldef.mtrlsectype,   
    84. 

  84.          u_mtrldef.zxmtrlmode ,
    85. 

  85.         0.00 as install_cmplqty  ,
    86. 

  86. 	sum(isnull(noAssignQty,0 )) as noAssignQty,
    87. 

  87. 	sum(isnull(unuse_noallocqty,0 )) as unuse_noallocqty
    88. 

  88.     FROM uv_mtrl_willuse
    89. 

  89. 			LEFT OUTER JOIN uv_materiel_willfinish_order_ml 
    90. 

  90.          ON uv_materiel_willfinish_order_ml.Mtrlid = uv_mtrl_willuse.MtrlID 
    91. 

  91.          and uv_materiel_willfinish_order_ml.scid = uv_mtrl_willuse.scid 
    92. 

  92.          and uv_materiel_willfinish_order_ml.status = uv_mtrl_willuse.status 
    93. 

  93.          and uv_materiel_willfinish_order_ml.pcode = uv_mtrl_willuse.pcode 
    94. 

  94.          and uv_materiel_willfinish_order_ml.woodcode = uv_mtrl_willuse.woodcode 
    95. 

  95.          LEFT OUTER JOIN uv_materiel_willfinish_buytask 
    96. 

  96. 			ON uv_mtrl_willuse.MtrlID = uv_materiel_willfinish_buytask.MtrlID  
    97. 

  97.          and uv_mtrl_willuse.scid = uv_materiel_willfinish_buytask.scid  
    98. 

  98.          and uv_mtrl_willuse.status = uv_materiel_willfinish_buytask.status 
    99. 

  99.          and uv_mtrl_willuse.pcode = uv_materiel_willfinish_buytask.pcode 
    100. 

  100.          and uv_mtrl_willuse.woodcode = uv_materiel_willfinish_buytask.woodcode 
    101. 

  101. 			LEFT OUTER JOIN uv_materiel_willfinish_wfjg 
    102. 

  102.          ON uv_mtrl_willuse.MtrlID = uv_materiel_willfinish_wfjg.MtrlID  
    103. 

  103.          and uv_mtrl_willuse.scid = uv_materiel_willfinish_wfjg.scid  
    104. 

  104.          and uv_mtrl_willuse.status = uv_materiel_willfinish_wfjg.status 
    105. 

  105.          and uv_mtrl_willuse.pcode = uv_materiel_willfinish_wfjg.pcode 
    106. 

  106.          and uv_mtrl_willuse.woodcode = uv_materiel_willfinish_wfjg.woodcode 
    107. 

  107.          LEFT OUTER JOIN uv_mtrlware2 
    108. 

  108.          on uv_mtrl_willuse.MtrlID = uv_mtrlware2.mtrlid
    109. 

  109.          and uv_mtrl_willuse.scid = uv_mtrlware2.scid
    110. 

  110.          and uv_mtrl_willuse.status = uv_mtrlware2.status 
    111. 

  111.          and uv_mtrl_willuse.pcode = uv_mtrlware2.pcode 
    112. 

  112.          and uv_mtrl_willuse.woodcode = uv_mtrlware2.woodcode 
    113. 

  113. 		inner join u_mtrldef   on uv_mtrl_willuse.MtrlID = u_mtrldef.mtrlid  
    114. 

  114. 		left outer join u_spt
    115. 

  115. 			on u_mtrldef.dftsptid = u_spt.sptid 
    116. 

  116. 		left outer JOIN  u_mtrldef_maxminqty ON uv_mtrl_willuse.mtrlid = u_mtrldef_maxminqty.mtrlid AND 
    117. 

  117. 			uv_mtrl_willuse.Status = u_mtrldef_maxminqty.status AND 
    118. 

  118. 			uv_mtrl_willuse.woodcode = u_mtrldef_maxminqty.woodcode AND 
    119. 

  119. 			uv_mtrl_willuse.pcode = u_mtrldef_maxminqty.pcode
    120. 

  120. 		left join (select u_mtrlware.mtrlid,u_mtrlware.scid,sum(u_mtrlware.noallocqty - isnull(uv_mtrlware_noauditingqty.noauditingqty,0)) as unuse_noallocqty,
    121. 

  121. 					u_mtrlware.status,u_mtrlware.pcode,u_mtrlware.woodcode  
    122. 

  122. 					from u_mtrlware left join uv_mtrlware_noauditingqty on uv_mtrlware_noauditingqty.mtrlid = u_mtrlware.mtrlid 
    123. 

  123. 					and uv_mtrlware_noauditingqty.scid = u_mtrlware.scid
    124. 

  124. 					group by u_mtrlware.mtrlid,u_mtrlware.scid,
    125. 

  125. 					u_mtrlware.status,u_mtrlware.pcode,u_mtrlware.woodcode) mtrlware on mtrlware.mtrlid = uv_mtrl_willuse.mtrlid 
    126. 

  126. 					         and mtrlware.scid = uv_mtrl_willuse.scid 
    127. 

  127. 							and mtrlware.status = uv_mtrl_willuse.status 
    128. 

  128. 							and mtrlware.pcode = uv_mtrl_willuse.pcode 
    129. 

  129. 							and mtrlware.woodcode = uv_mtrl_willuse.woodcode 
    130. 

  130. 		left join (select sum(u_saletaskmx.orderqty - u_saletaskmx.assignqty) as noAssignQty,u_saletaskmx.MtrlID,u_saletaskmx.scid
    131. 

  131. 					,u_SaleTaskMx.status,u_SaleTaskMx.pcode,u_SaleTaskMx.woodcode				
    132. 

  132.  					from u_SaleTask inner join u_SaleTaskMx on u_SaleTask.TaskID = u_SaleTaskMx.TaskID 
    133. 

  133. 					and u_SaleTask.scid = u_SaleTaskMx.scid
    134. 

  134. 					where u_saletaskmx.ifsc = 1 and u_saletask.status = 1
    135. 

  135. 					group by u_saletaskmx.MtrlID,u_saletaskmx.scid
    136. 

  136. 					,u_SaleTaskMx.status,u_SaleTaskMx.pcode,u_SaleTaskMx.woodcode) saletask on saletask.MtrlID = uv_mtrl_willuse.mtrlid
    137. 

  137. 					         and saletask.scid = uv_mtrl_willuse.scid 
    138. 

  138. 							and saletask.status = uv_mtrl_willuse.status 
    139. 

  139. 							and saletask.pcode = uv_mtrl_willuse.pcode 
    140. 

  140. 							and saletask.woodcode = uv_mtrl_willuse.woodcode  
    141. 

  141.    WHERE ( uv_mtrl_willuse.plantype = :arg_Mtrlorigin or :arg_Mtrlorigin = -1 ) and 
    142. 

  142.       	( u_mtrldef.handtype like :arg_handtype or :arg_handtype='' ) and
    143. 

  143. 			( u_mtrldef.mtrlkind = :arg_mtrlkind or :arg_mtrlkind = -1) and 
    144. 

  144. 			( uv_mtrl_willuse.scid in (:arg_scid))
    145. 

  145. group by uv_mtrl_willuse.mtrlid,
    146. 

  146. 			uv_mtrl_willuse.status,
    147. 

  147. 			uv_mtrl_willuse.woodcode,
    148. 

  148. 			uv_mtrl_willuse.pcode,
    149. 

  149. 			uv_mtrl_willuse.plantype,
    150. 

  150. 			u_mtrldef.mtrlcode,   
    151. 

  151. 			u_mtrldef.mtrlname,   
    152. 

  152. 			u_mtrldef.mtrlmode,   
    153. 

  153. 			u_mtrldef.mtrltype,   
    154. 

  154. 			u_mtrldef.unit,   
    155. 

  155. 			u_mtrldef_maxminqty.minqty,  
    156. 

  156. 			u_mtrldef_maxminqty.maxqty,
    157. 

  157. 			u_mtrldef.mtrlorigin, 
    158. 

  158. 			u_mtrldef.mtrlprp,
    159. 

  159. 			u_mtrldef.mtrlkind,   
    160. 

  160. 			u_mtrldef.dftsptid,   
    161. 

  161. 			u_mtrldef.mrp_unit,   
    162. 

  162. 			u_mtrldef.unit_buy,   
    163. 

  163. 			u_mtrldef.rate_buy,   
    164. 

  164. 			u_mtrldef.unit_scll,   
    165. 

  165. 			u_mtrldef.rate_scll,   
    166. 

  166. 			u_mtrldef.unit_sale,   
    167. 

  167. 			u_mtrldef.rate_sale,
    168. 

  168. 			u_mtrldef.buyunit,
    169. 

  169. 			isnull(u_spt.sptcode, '') ,
    170. 

  170. 			isnull(u_spt.name, '') ,
    171. 

  171.          u_mtrldef.mtrlsectype,   
    172. 

  172.          u_mtrldef.zxmtrlmode   
    173. 

  173. having (:arg_qty = 1 and sum(isnull(uv_mtrl_willuse.RqQty,0) * :arg_ifrqqty) + isnull(u_mtrldef_maxminqty.minqty,0) * :arg_ifminqty + sum(isnull(uv_mtrl_willuse.taskqty,0))* :arg_iftaskqty
    174. 

  174. 			- sum(isnull( uv_mtrlware2.noallocqty,0 )) * :arg_ifnoallocqty - sum(isnull(uv_materiel_willfinish_buytask.qty,0)) * :arg_ifbuytask 
    175. 

  175. 			- sum(isnull(uv_materiel_willfinish_order_ml.qty,0)) * :arg_iforder - sum(isnull(uv_materiel_willfinish_wfjg.qty,0)) * :arg_ifwfjg > 0 
    176. 

  176. 		or :arg_qty = 0 )
    177. 

  177. 

  178. union all
    179. 

  179. 

  180.   SELECT u_mtrldef.mtrlid,
    181. 

  181. 			'' as status,
    182. 

  182. 			'' as woodcode,
    183. 

  183. 			'' as pcode,
    184. 

  184. 			u_mtrldef.mtrlorigin as plantype,
    185. 

  185. 			u_mtrldef.mtrlcode,   
    186. 

  186. 			u_mtrldef.mtrlname,   
    187. 

  187. 			u_mtrldef.mtrlmode,   
    188. 

  188. 			u_mtrldef.mtrltype,   
    189. 

  189. 			u_mtrldef.unit,   
    190. 

  190. 			u_mtrldef_maxminqty.minqty as minqty,   
    191. 

  191. 			u_mtrldef_maxminqty.maxqty as maxqty,   
    192. 

  192. 			u_mtrldef.mtrlorigin,    
    193. 

  193. 			u_mtrldef.mtrlprp,  
    194. 

  194. 			u_mtrldef.mtrlkind,   
    195. 

  195. 			u_mtrldef.dftsptid,   
    196. 

  196. 			u_mtrldef.mrp_unit,   
    197. 

  197. 			u_mtrldef.unit_buy,   
    198. 

  198. 			u_mtrldef.rate_buy,   
    199. 

  199. 			u_mtrldef.unit_scll,   
    200. 

  200. 			u_mtrldef.rate_scll,   
    201. 

  201. 			u_mtrldef.unit_sale,   
    202. 

  202. 			u_mtrldef.rate_sale, 
    203. 

  203. 			u_mtrldef.buyunit,
    204. 

  204. 			0 as selectflag, 
    205. 

  205. 			sum(isnull( uv_mtrlware2.noallocqty,0 )) as noallocqty,   
    206. 

  206. 			0 as taskqty,   
    207. 

  207. 			0 as rqqty,   
    208. 

  208. 			sum(isnull(uv_materiel_willfinish_buytask.qty,0)) as buytaskqty,   
    209. 

  209. 			sum(isnull(uv_materiel_willfinish_order_ml.qty,0)) as ordermlqty ,   
    210. 

  210. 			sum(isnull(uv_materiel_willfinish_wfjg.qty,0)) as wfjgqty , 
    211. 

  211. 			isnull(u_mtrldef_maxminqty.minqty,0) * :arg_ifminqty - sum(isnull( uv_mtrlware2.noallocqty,0 )) * :arg_ifnoallocqty 
    212. 

  212. 				- sum(isnull(uv_materiel_willfinish_buytask.qty,0)) * :arg_ifbuytask 
    213. 

  213. 				- sum(isnull(uv_materiel_willfinish_order_ml.qty,0)) * :arg_iforder - sum(isnull(uv_materiel_willfinish_wfjg.qty,0)) * :arg_ifwfjg as truerqqty,
    214. 

  214. 			isnull(u_spt.sptcode, '') as sptcode,
    215. 

  215. 			isnull(u_spt.name, '') as sptname,
    216. 

  216.          u_mtrldef.mtrlsectype,   
    217. 

  217.          u_mtrldef.zxmtrlmode  ,
    218. 

  218.      0.00 as install_cmplqty ,
    219. 

  219. 	sum(isnull(noAssignQty,0 )) as noAssignQty,
    220. 

  220. 	sum(isnull(unuse_noallocqty,0 )) as unuse_noallocqty
    221. 

  221. 

  222.          FROM u_mtrldef
    223. 

  223. 			LEFT OUTER JOIN uv_materiel_willfinish_order_ml 
    224. 

  224.          ON uv_materiel_willfinish_order_ml.Mtrlid = u_mtrldef.MtrlID 
    225. 

  225.          and uv_materiel_willfinish_order_ml.scid in (:arg_scid)
    226. 

  226.          LEFT OUTER JOIN uv_materiel_willfinish_buytask 
    227. 

  227. 			ON u_mtrldef.MtrlID = uv_materiel_willfinish_buytask.MtrlID  
    228. 

  228.          and uv_materiel_willfinish_buytask.scid in (:arg_scid)
    229. 

  229. 			LEFT OUTER JOIN uv_materiel_willfinish_wfjg 
    230. 

  230.          ON u_mtrldef.MtrlID = uv_materiel_willfinish_wfjg.MtrlID  
    231. 

  231.          and uv_materiel_willfinish_wfjg.scid in (:arg_scid)
    232. 

  232.          LEFT OUTER JOIN uv_mtrlware2 
    233. 

  233.          on u_mtrldef.MtrlID = uv_mtrlware2.mtrlid
    234. 

  234.          and uv_mtrlware2.scid in (:arg_scid)  left outer join u_spt
    235. 

  235. 			on u_mtrldef.dftsptid = u_spt.sptid 
    236. 

  236. 		left outer JOIN  u_mtrldef_maxminqty ON uv_mtrlware2.mtrlid = u_mtrldef_maxminqty.mtrlid AND 
    237. 

  237. 			uv_mtrlware2.Status = u_mtrldef_maxminqty.status AND 
    238. 

  238. 			uv_mtrlware2.woodcode = u_mtrldef_maxminqty.woodcode AND 
    239. 

  239. 			uv_mtrlware2.pcode = u_mtrldef_maxminqty.pcode
    240. 

  240. 		left join (select u_mtrlware.mtrlid,u_mtrlware.scid,sum(u_mtrlware.noallocqty - isnull(uv_mtrlware_noauditingqty.noauditingqty,0)) as unuse_noallocqty,
    241. 

  241. 					u_mtrlware.status,u_mtrlware.pcode,u_mtrlware.woodcode  
    242. 

  242. 					from u_mtrlware left join uv_mtrlware_noauditingqty on uv_mtrlware_noauditingqty.mtrlid = u_mtrlware.mtrlid 
    243. 

  243. 					and uv_mtrlware_noauditingqty.scid = u_mtrlware.scid
    244. 

  244. 					group by u_mtrlware.mtrlid,u_mtrlware.scid,
    245. 

  245. 					u_mtrlware.status,u_mtrlware.pcode,u_mtrlware.woodcode) mtrlware on mtrlware.mtrlid = u_mtrldef.mtrlid 
    246. 

  246. 					         and mtrlware.scid in (:arg_scid)
    247. 

  247. 							and mtrlware.status = uv_mtrlware2.status 
    248. 

  248. 							and mtrlware.pcode = uv_mtrlware2.pcode 
    249. 

  249. 							and mtrlware.woodcode = uv_mtrlware2.woodcode 
    250. 

  250. 		left join (select sum(u_saletaskmx.orderqty - u_saletaskmx.assignqty) as noAssignQty,u_saletaskmx.MtrlID,u_saletaskmx.scid
    251. 

  251. 					,u_SaleTaskMx.status,u_SaleTaskMx.pcode,u_SaleTaskMx.woodcode				
    252. 

  252.  					from u_SaleTask inner join u_SaleTaskMx on u_SaleTask.TaskID = u_SaleTaskMx.TaskID 
    253. 

  253. 					and u_SaleTask.scid = u_SaleTaskMx.scid
    254. 

  254. 					where u_saletaskmx.ifsc = 1 and u_saletask.status = 1
    255. 

  255. 					group by u_saletaskmx.MtrlID,u_saletaskmx.scid
    256. 

  256. 					,u_SaleTaskMx.status,u_SaleTaskMx.pcode,u_SaleTaskMx.woodcode) saletask on saletask.MtrlID = u_mtrldef.mtrlid
    257. 

  257. 					         and saletask.scid in (:arg_scid)
    258. 

  258. 							and saletask.status = uv_mtrlware2.status 
    259. 

  259. 							and saletask.pcode = uv_mtrlware2.pcode 
    260. 

  260. 							and saletask.woodcode = uv_mtrlware2.woodcode  
    261. 

  261.    WHERE ( u_mtrldef.mtrlorigin = :arg_Mtrlorigin or :arg_Mtrlorigin = -1 ) and 
    262. 

  262. 			( u_mtrldef.mtrlkind = :arg_mtrlkind or :arg_mtrlkind = -1) and
    263. 

  263.       	( u_mtrldef.handtype like :arg_handtype or :arg_handtype='' ) and
    264. 

  264.          ( u_mtrldef.mtrlid not in (select mtrlid from uv_mtrl_willuse))
    265. 

  265. group by u_mtrldef.mtrlid,
    266. 

  266. 		u_mtrldef.mtrlcode,   
    267. 

  267. 		u_mtrldef.mtrlname,   
    268. 

  268. 		u_mtrldef.mtrlmode,   
    269. 

  269. 		u_mtrldef.mtrltype,   
    270. 

  270. 		u_mtrldef.unit,   
    271. 

  271. 		u_mtrldef_maxminqty.minqty,   
    272. 

  272. 		u_mtrldef_maxminqty.maxqty,
    273. 

  273. 		u_mtrldef.mtrlorigin, 
    274. 

  274. 		u_mtrldef.mtrlprp,
    275. 

  275. 		u_mtrldef.mtrlkind,   
    276. 

  276. 		u_mtrldef.dftsptid,   
    277. 

  277. 		u_mtrldef.mrp_unit,   
    278. 

  278. 		u_mtrldef.unit_buy,   
    279. 

  279. 		u_mtrldef.rate_buy,   
    280. 

  280. 		u_mtrldef.unit_scll,   
    281. 

  281. 		u_mtrldef.rate_scll,   
    282. 

  282. 		u_mtrldef.unit_sale,   
    283. 

  283. 		u_mtrldef.rate_sale,
    284. 

  284. 		u_mtrldef.buyunit,
    285. 

  285. 		isnull(u_spt.sptcode, '') ,
    286. 

  286. 		isnull(u_spt.name, '') ,
    287. 

  287.          u_mtrldef.mtrlsectype,   
    288. 

  288.          u_mtrldef.zxmtrlmode   
    289. 

  289. having (:arg_qty = 1 and isnull(u_mtrldef_maxminqty.minqty,0) * :arg_ifminqty - sum(isnull( uv_mtrlware2.noallocqty,0 )) * :arg_ifnoallocqty 
    290. 

  290. 				- sum(isnull(uv_materiel_willfinish_buytask.qty,0)) * :arg_ifbuytask 
    291. 

  291. 				- sum(isnull(uv_materiel_willfinish_order_ml.qty,0)) * :arg_iforder - sum(isnull(uv_materiel_willfinish_wfjg.qty,0)) * :arg_ifwfjg > 0 
    292. 

  292. 			or :arg_qty = 0 )" arguments=(("arg_scid", numberlist),("arg_Mtrlorigin", number),("arg_qty", number),("arg_ifminqty", number),("arg_ifnoallocqty", number),("arg_ifbuytask", number),("arg_iforder", number),("arg_ifwfjg", number),("arg_handtype", string),("arg_mtrlkind", number),("arg_ifrqqty", number),("arg_iftaskqty", number))  sort="u_mtrldef_mtrlorigin A u_mtrldef_mtrlcode A " )
    293. 

  293. text(band=header alignment="2" text="选" border="0" color="33554432" x="9" y="12" height="52" width="87" html.valueishtml="0"  name=selectflag_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" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    294. 

  294. text(band=header alignment="2" text="物料来源" border="0" color="33554432" x="453" y="12" height="52" width="338" html.valueishtml="0"  name=u_mtrldef_mtrlorigin_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" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    295. 

  295. text(band=header alignment="2" text="物料编码" border="0" color="33554432" x="800" y="12" height="52" width="402" 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" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    296. 

  296. text(band=header alignment="2" text="物料名称" border="0" color="33554432" x="1211" y="12" height="52" width="663" 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" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    297. 

  297. text(band=header alignment="2" text="物料规格" border="0" color="33554432" x="1883" y="12" height="52" width="421" 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" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    298. 

  298. text(band=header alignment="2" text="单位" border="0" color="33554432" x="2313" y="12" height="52" width="155" 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" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    299. 

  299. text(band=header alignment="2" text="配置" border="0" color="33554432" x="6944" y="12" height="52" width="411" html.valueishtml="0"  name=uv_mtrl_willuse_status_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" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    300. 

  300. text(band=header alignment="2" text="库存数量" border="0" color="33554432" x="4635" y="12" height="52" width="329" html.valueishtml="0"  name=u_mtrlware_noallocqty_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="16776960" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    301. 

  301. text(band=header alignment="2" text="采购未到货数" border="0" color="33554432" x="4974" y="12" height="52" width="370" html.valueishtml="0"  name=uv_mtrl_willfinish_buytask_buytaskqty_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="16776960" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    302. 

  302. text(band=header alignment="2" text="生产未完成数" border="0" color="33554432" x="5353" y="12" height="52" width="366" html.valueishtml="0"  name=uv_mtrl_willfinish_order_ml_ordermlqty_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="16776960" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    303. 

  303. text(band=header alignment="2" text="配置1" border="0" color="33554432" x="7365" y="12" height="52" width="402" html.valueishtml="0"  name=uv_mtrl_willuse_woodcode_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" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    304. 

  304. text(band=header alignment="2" text="配置2" border="0" color="33554432" x="7776" y="12" height="52" width="489" html.valueishtml="0"  name=uv_mtrl_willuse_pcode_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" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    305. 

  305. text(band=header alignment="2" text="外协未到货数" border="0" color="33554432" x="5728" y="12" height="52" width="357" html.valueishtml="0"  name=wfjgqty_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="16776960" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    306. 

  306. text(band=header alignment="2" text="处理" border="0" color="33554432" x="105" y="12" height="52" width="338" html.valueishtml="0"  name=uv_mtrl_willuse_plantype_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" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    307. 

  307. text(band=header alignment="2" text="订单需求数" border="0" color="33554432" x="3209" y="12" height="52" width="325" html.valueishtml="0"  name=taskqty_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="12639424" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    308. 

  308. text(band=header alignment="2" text="领用属性" border="0" color="33554432" x="2478" y="12" height="52" width="311" html.valueishtml="0"  name=u_mtrldef_mtrlkind_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" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    309. 

  309. text(band=header alignment="2" text="物料类别" border="0" color="33554432" x="8274" y="12" height="52" width="338" html.valueishtml="0"  name=u_mtrldef_mtrltype_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" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    310. 

  310. text(band=header alignment="2" text="默认供应商编号" border="0" color="33554432" x="8622" y="12" height="52" width="453" html.valueishtml="0"  name=sptcode_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" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    311. 

  311. text(band=header alignment="2" text="默认供应商名称" border="0" color="33554432" x="9083" y="12" height="52" width="663" html.valueishtml="0"  name=sptname_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" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    312. 

  312. text(band=header alignment="2" text="生产需求数" border="0" color="33554432" x="3543" y="12" height="52" width="320" html.valueishtml="0"  name=u_orderrqmtrl_rqqty_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="12639424" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    313. 

  313. text(band=header alignment="2" text="报警下限数" border="0" color="33554432" x="3872" y="12" height="52" width="384" html.valueishtml="0"  name=u_mtrldef_maxminqty_minqty_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="12639424" background.transparency="0" background.gradient.color="0" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="0" background.gradient.focus="0" background.gradient.scale="0" background.gradient.spread="0" tooltip.backcolor="0" tooltip.delay.initial="0" tooltip.delay.visible="0" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="0" tooltip.transparency="0" transparency="0" )
    314. 

  314. text(band=header alignment="2" text="报警上限数" border="0" color="33554432" x="9755" y="12" height="52" width="443" html.valueishtml="0"  name=u_mtrldef_maxminqty_maxqty_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="0" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="0" background.gradient.focus="0" background.gradient.scale="0" background.gradient.spread="0" tooltip.backcolor="0" tooltip.delay.initial="0" tooltip.delay.visible="0" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="0" tooltip.transparency="0" transparency="0" )
    315. 

  315. text(band=header alignment="2" text="自定义1" border="0" color="33554432" x="10208" y="12" height="52" width="379" 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="1073741824" background.transparency="0" background.gradient.color="0" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="0" background.gradient.focus="0" background.gradient.scale="0" background.gradient.spread="0" tooltip.backcolor="0" tooltip.delay.initial="0" tooltip.delay.visible="0" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="0" tooltip.transparency="0" transparency="0" )
    316. 

  316. text(band=header alignment="2" text="自定义2" border="0" color="33554432" x="10597" y="12" height="52" width="443" 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="1073741824" background.transparency="0" background.gradient.color="0" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="0" background.gradient.focus="0" background.gradient.scale="0" background.gradient.spread="0" tooltip.backcolor="0" tooltip.delay.initial="0" tooltip.delay.visible="0" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="0" tooltip.transparency="0" transparency="0" )
    317. 

  317. text(band=header alignment="2" text="可装数" border="0" color="0" x="4265" y="12" height="52" width="361" html.valueishtml="0"  name=install_cmplqty_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="65535" background.transparency="0" background.gradient.color="0" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="0" background.gradient.focus="0" background.gradient.scale="0" background.gradient.spread="0" tooltip.backcolor="0" tooltip.delay.initial="0" tooltip.delay.visible="0" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="0" tooltip.transparency="0" transparency="0" )
    318. 

  318. text(band=header alignment="2" text="订单未进仓数" border="0" color="0" x="6094" y="12" height="52" width="421" html.valueishtml="0"  name=noassignqty_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="16776960" background.transparency="0" background.gradient.color="0" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="0" background.gradient.focus="0" background.gradient.scale="0" background.gradient.spread="0" tooltip.backcolor="0" tooltip.delay.initial="0" tooltip.delay.visible="0" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="0" tooltip.transparency="0" transparency="0" )
    319. 

  319. text(band=header alignment="2" text="库存未开单数" border="0" color="0" x="6523" y="12" height="52" width="411" html.valueishtml="0"  name=unuse_noallocqty_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="16776960" background.transparency="0" background.gradient.color="0" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="0" background.gradient.focus="0" background.gradient.scale="0" background.gradient.spread="0" tooltip.backcolor="0" tooltip.delay.initial="0" tooltip.delay.visible="0" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="0" tooltip.transparency="0" transparency="0" )
    320. 

  320. text(band=header alignment="2" text="缺料数" border="0" color="33554432" x="2802" y="12" height="52" width="398" html.valueishtml="0"  name=truerqqty_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="15780518" background.transparency="0" background.gradient.color="0" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="0" background.gradient.focus="0" background.gradient.scale="0" background.gradient.spread="0" tooltip.backcolor="0" tooltip.delay.initial="0" tooltip.delay.visible="0" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="0" tooltip.transparency="0" transparency="0" )
    321. 

  321. column(band=detail id=13 alignment="0" tabsequence=32766 border="0" color="33554432" x="453" y="4" height="68" width="338" format="[general]" html.valueishtml="0"  name=u_mtrldef_mtrlorigin visible="1" dddw.name=ddd_mtrlorigin dddw.displaycolumn=mtrlorigin_display dddw.datacolumn=mtrlorigin dddw.percentwidth=0 dddw.lines=0 dddw.limit=0 dddw.allowedit=no dddw.useasborder=no dddw.case=any  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    322. 

  322. column(band=detail id=6 alignment="0" tabsequence=32766 border="0" color="33554432" x="800" y="4" height="68" width="402" format="[general]" html.valueishtml="0"  name=u_mtrldef_mtrlcode visible="1" edit.limit=30 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.displayonly=yes  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    323. 

  323. column(band=detail id=7 alignment="0" tabsequence=32766 border="0" color="33554432" x="1211" y="4" height="68" width="663" format="[general]" html.valueishtml="0"  name=u_mtrldef_mtrlname visible="1" edit.limit=50 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.displayonly=yes  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    324. 

  324. column(band=detail id=8 alignment="0" tabsequence=32766 border="0" color="33554432" x="1883" y="4" height="68" width="421" format="[general]" html.valueishtml="0"  name=u_mtrldef_mtrlmode visible="1" edit.limit=30 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.displayonly=yes  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    325. 

  325. column(band=detail id=10 alignment="2" tabsequence=32766 border="0" color="33554432" x="2313" y="4" height="68" width="155" format="[general]" html.valueishtml="0"  name=u_mtrldef_unit visible="1" edit.limit=10 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.displayonly=yes  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    326. 

  326. column(band=detail id=2 alignment="0" tabsequence=32766 border="0" color="33554432" x="6944" y="4" height="68" width="411" format="[general]" html.valueishtml="0"  name=uv_mtrl_willuse_status visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    327. 

  327. column(band=detail id=3 alignment="0" tabsequence=32766 border="0" color="33554432" x="7365" y="4" height="68" width="402" format="[general]" html.valueishtml="0"  name=uv_mtrl_willuse_woodcode visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    328. 

  328. column(band=detail id=4 alignment="0" tabsequence=20 border="0" color="33554432" x="7776" y="4" height="68" width="489" format="[general]" html.valueishtml="0"  name=uv_mtrl_willuse_pcode visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    329. 

  329. column(band=detail id=25 alignment="2" tabsequence=10 border="0" color="33554432" x="9" y="4" height="68" width="87" format="[general]" html.valueishtml="0"  name=selectflag 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="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    330. 

  330. column(band=detail id=5 alignment="0" tabsequence=32766 border="0" color="33554432" x="105" y="4" height="68" width="338" format="[general]" html.valueishtml="0"  name=uv_mtrl_willuse_plantype visible="1" dddw.name=ddd_mtrlorigin dddw.displaycolumn=mtrlorigin_display dddw.datacolumn=mtrlorigin dddw.percentwidth=0 dddw.lines=0 dddw.limit=0 dddw.allowedit=no dddw.useasborder=no dddw.case=any  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    331. 

  331. column(band=detail id=28 alignment="1" tabsequence=32766 border="0" color="33554432" x="3543" y="4" height="68" width="320" format="#,##0.##########" html.valueishtml="0"  name=u_orderrqmtrl_rqqty visible="1" edit.limit=0 edit.case=any edit.format="#,##0.0####" edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.displayonly=yes  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    332. 

  332. column(band=detail id=26 alignment="1" tabsequence=32766 border="0" color="33554432" x="4635" y="4" height="68" width="329" format="#,##0.##########" html.valueishtml="0"  name=u_mtrlware_noallocqty visible="1" edit.limit=0 edit.case=any edit.format="#,##0.0####" edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.displayonly=yes  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    333. 

  333. column(band=detail id=29 alignment="1" tabsequence=32766 border="0" color="33554432" x="4974" y="4" height="68" width="370" format="#,##0.##########" html.valueishtml="0"  name=uv_mtrl_willfinish_buytask_buytaskqty visible="1" edit.limit=0 edit.case=any edit.format="#,##0.0####" edit.autoselect=yes edit.displayonly=yes  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    334. 

  334. column(band=detail id=30 alignment="1" tabsequence=32766 border="0" color="33554432" x="5353" y="4" height="68" width="366" format="#,##0.##########" html.valueishtml="0"  name=uv_mtrl_willfinish_order_ml_ordermlqty visible="1" edit.limit=0 edit.case=any edit.format="#,##0.0####" edit.autoselect=yes edit.displayonly=yes  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    335. 

  335. column(band=detail id=31 alignment="1" tabsequence=32766 border="0" color="33554432" x="5728" y="4" height="68" width="357" format="#,##0.##########" html.valueishtml="0"  name=wfjgqty visible="1" edit.limit=0 edit.case=any edit.autoselect=yes  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    336. 

  336. column(band=detail id=15 alignment="0" tabsequence=32766 border="0" color="33554432" x="2478" y="4" height="68" width="311" format="[general]" html.valueishtml="0"  name=u_mtrldef_mtrlkind visible="1" dddw.name=ddd_mtrlkind dddw.displaycolumn=mtrlkindname dddw.datacolumn=mtrlkind dddw.percentwidth=0 dddw.lines=0 dddw.limit=0 dddw.allowedit=no dddw.useasborder=no dddw.case=any  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    337. 

  337. column(band=detail id=9 alignment="2" tabsequence=32766 border="0" color="33554432" x="8274" y="4" height="68" width="338" format="[general]" html.valueishtml="0"  name=u_mtrldef_mtrltype visible="1" edit.limit=30 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.displayonly=yes  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    338. 

  338. column(band=detail id=33 alignment="0" tabsequence=32766 border="0" color="33554432" x="8622" y="4" height="68" width="453" format="[general]" html.valueishtml="0"  name=sptcode visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    339. 

  339. column(band=detail id=34 alignment="0" tabsequence=32766 border="0" color="33554432" x="9083" y="4" height="68" width="663" format="[general]" html.valueishtml="0"  name=sptname visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    340. 

  340. column(band=detail id=27 alignment="1" tabsequence=32766 border="0" color="33554432" x="3209" y="4" height="68" width="325" format="#,##0.##########" html.valueishtml="0"  name=taskqty visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    341. 

  341. column(band=detail id=11 alignment="1" tabsequence=32766 border="0" color="33554432" x="3872" y="4" height="68" width="384" format="#,##0.##########" html.valueishtml="0"  name=u_mtrldef_maxminqty_minqty visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    342. 

  342. column(band=detail id=12 alignment="1" tabsequence=32766 border="0" color="33554432" x="9755" y="4" height="68" width="443" format="#,##0.######" html.valueishtml="0"  name=u_mtrldef_maxminqty_maxqty visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    343. 

  343. column(band=detail id=35 alignment="0" tabsequence=32766 border="0" color="33554432" x="10208" y="4" height="68" width="379" format="[general]" html.valueishtml="0"  name=u_mtrldef_mtrlsectype visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    344. 

  344. column(band=detail id=36 alignment="0" tabsequence=32766 border="0" color="33554432" x="10597" y="4" height="68" width="443" format="[general]" html.valueishtml="0"  name=u_mtrldef_zxmtrlmode visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    345. 

  345. column(band=detail id=37 alignment="1" tabsequence=32766 border="0" color="33554432" x="4265" y="4" height="68" width="361" format="#,##0.##########" html.valueishtml="0"  name=install_cmplqty visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    346. 

  346. column(band=detail id=38 alignment="1" tabsequence=32766 border="0" color="33554432" x="6094" y="4" height="68" width="421" format="#,##0" html.valueishtml="0"  name=noassignqty visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    347. 

  347. column(band=detail id=39 alignment="1" tabsequence=32766 border="0" color="33554432" x="6523" y="4" height="68" width="411" format="#,##0" html.valueishtml="0"  name=unuse_noallocqty visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    348. 

  348. column(band=detail id=32 alignment="1" tabsequence=32766 border="0" color="33554432" x="2802" y="4" height="68" width="398" format="#,##0.##########" html.valueishtml="0"  name=truerqqty visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    349. 

  349. compute(band=footer alignment="2" expression="count(u_mtrldef_mtrlcode for all)"border="0" color="16711680" x="800" y="4" height="56" width="402" 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="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    350. 

  350. compute(band=footer alignment="1" expression="sum(u_mtrlware_noallocqty for all)"border="0" color="0" x="4635" y="4" height="56" width="329" format="#,##0.##########" 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="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    351. 

  351. compute(band=footer alignment="1" expression="sum(u_orderrqmtrl_rqqty for all)"border="0" color="0" x="3543" y="4" height="56" width="320" format="#,##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="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    352. 

  352. compute(band=footer alignment="1" expression="sum(uv_mtrl_willfinish_buytask_buytaskqty for all)"border="0" color="0" x="4974" y="4" height="56" width="370" format="#,##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="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    353. 

  353. compute(band=footer alignment="1" expression="sum(uv_mtrl_willfinish_order_ml_ordermlqty for all)"border="0" color="0" x="5353" y="4" height="56" width="366" format="#,##0.##########" html.valueishtml="0"  name=compute_5 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" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    354. 

  354. compute(band=footer alignment="1" expression="sum(wfjgqty for all)"border="0" color="0" x="5728" y="4" height="56" width="357" format="#,##0.##########" html.valueishtml="0"  name=compute_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="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    355. 

  355. compute(band=footer alignment="1" expression="sum(u_mtrldef_maxminqty_minqty for all)"border="0" color="0" x="3872" y="4" height="56" width="384" format="#,##0.##########" html.valueishtml="0"  name=compute_9 visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    356. 

  356. compute(band=footer alignment="1" expression="sum(install_cmplqty for all)"border="0" color="33554432" x="4265" y="12" height="56" width="361" format="#,##0.##########" html.valueishtml="0"  name=compute_11 visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    357. 

  357. compute(band=footer alignment="1" expression="sum(taskqty for all)"border="0" color="0" x="3209" y="4" height="56" width="325" format="#,##0.##########" html.valueishtml="0"  name=compute_8 visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    358. 

  358. compute(band=footer alignment="1" expression="sum( unuse_noallocqty  for all)"border="0" color="33554432" x="6523" y="4" height="52" width="411" format="#,##0" html.valueishtml="0"  name=compute_12 visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    359. 

  359. compute(band=footer alignment="1" expression="sum( noassignqty  for all)"border="0" color="33554432" x="6094" y="4" height="52" width="421" format="#,##0" html.valueishtml="0"  name=compute_10 visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    360. 

  360. compute(band=footer alignment="1" expression="sum(truerqqty for all)"border="0" color="33554432" x="2802" y="4" height="56" width="398" format="#,##0.##########" html.valueishtml="0"  name=compute_13 visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
    361. 

  361. htmltable(border="1" )
    362. 

  362. htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1" clientformatting="0" clientscriptable="0" generatejavascript="1" encodeselflinkargs="1" netscapelayers="0" pagingmethod=0 generatedddwframes="1" )
    363. 

  363. xhtmlgen() cssgen(sessionspecific="0" )
    364. 

  364. xmlgen(inline="0" )
    365. 

  365. xsltgen()
    366. 

  366. jsgen()
    367. 

  367. export.xml(headgroups="1" includewhitespace="0" metadatatype=0 savemetadata=0  template=(comment="" encoding="UTF-16LE" name="ew" xml="<?xml version=~"1.0~" encoding=~"UTF-16LE~" standalone=~"no~"?><dw_rp_mtrl_will_rqqty><dw_rp_mtrl_will_rqqty_row __pbband=~"detail~"><uv_mtrl_willuse_mtrlid>uv_mtrl_willuse_mtrlid</uv_mtrl_willuse_mtrlid><uv_mtrl_willuse_status>uv_mtrl_willuse_status</uv_mtrl_willuse_status><uv_mtrl_willuse_woodcode>uv_mtrl_willuse_woodcode</uv_mtrl_willuse_woodcode><uv_mtrl_willuse_pcode>uv_mtrl_willuse_pcode</uv_mtrl_willuse_pcode><uv_mtrl_willuse_plantype>uv_mtrl_willuse_plantype</uv_mtrl_willuse_plantype><u_mtrldef_mtrlcode>u_mtrldef_mtrlcode</u_mtrldef_mtrlcode><u_mtrldef_mtrlname>u_mtrldef_mtrlname</u_mtrldef_mtrlname><u_mtrldef_mtrlmode>u_mtrldef_mtrlmode</u_mtrldef_mtrlmode><u_mtrldef_mtrltype>u_mtrldef_mtrltype</u_mtrldef_mtrltype><u_mtrldef_unit>u_mtrldef_unit</u_mtrldef_unit><u_mtrldef_minqty/><u_mtrldef_maxminqty_maxqty>u_mtrldef_maxminqty_maxqty</u_mtrldef_maxminqty_maxqty><u_mtrldef_mtrlorigin>u_mtrldef_mtrlorigin</u_mtrldef_mtrlorigin><u_mtrldef_mtrlprp>u_mtrldef_mtrlprp</u_mtrldef_mtrlprp><u_mtrldef_mtrlkind>u_mtrldef_mtrlkind</u_mtrldef_mtrlkind><u_mtrldef_dftsptid>u_mtrldef_dftsptid</u_mtrldef_dftsptid><u_mtrldef_mrp_unit>u_mtrldef_mrp_unit</u_mtrldef_mrp_unit><u_mtrldef_unit_buy>u_mtrldef_unit_buy</u_mtrldef_unit_buy><u_mtrldef_rate_buy>u_mtrldef_rate_buy</u_mtrldef_rate_buy><u_mtrldef_unit_scll>u_mtrldef_unit_scll</u_mtrldef_unit_scll><u_mtrldef_rate_scll>u_mtrldef_rate_scll</u_mtrldef_rate_scll><u_mtrldef_unit_sale>u_mtrldef_unit_sale</u_mtrldef_unit_sale><u_mtrldef_rate_sale>u_mtrldef_rate_sale</u_mtrldef_rate_sale><selectflag>selectflag</selectflag><u_mtrlware_noallocqty>u_mtrlware_noallocqty</u_mtrlware_noallocqty><taskqty/><u_orderrqmtrl_rqqty>u_orderrqmtrl_rqqty</u_orderrqmtrl_rqqty><uv_mtrl_willfinish_buytask_buytaskqty>uv_mtrl_willfinish_buytask_buytaskqty</uv_mtrl_willfinish_buytask_buytaskqty><uv_mtrl_willfinish_order_ml_ordermlqty>uv_mtrl_willfinish_order_ml_ordermlqty</uv_mtrl_willfinish_order_ml_ordermlqty><wfjgqty>wfjgqty</wfjgqty><truerqqty/><sptcode/><sptname>sptname</sptname></dw_rp_mtrl_will_rqqty_row></dw_rp_mtrl_will_rqqty>"))
    368. 

  368. import.xml()
    369. 

  369. export.pdf(method=0 distill.custompostscript="0" xslfop.print="0" )
    370. 

  370. export.xhtml()
    371. 

  371.  
    372.