Home Verkennen Help
Inloggen
Neil
/
Q5
1
0
Vork 0
Bestanden Issues 0 Pull-aanvragen 0 Wiki
Aftakking: master
Aftakkingen Labels
Q5
/
ws_objects
/
Ew_sale.pbl.src
/
dw_outwaremx_sale_wareaudit_edit_th.srd

dw_outwaremx_sale_wareaudit_edit_th.srd 35 KB
Permalink Geschiedenis Ruwe

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165 
  1. $PBExportHeader$dw_outwaremx_sale_wareaudit_edit_th.srd
    2. 

  2. release 9;
    3. 

  3. datawindow(units=0 timer_interval=0 color=16777215 processing=1 HTMLDW=no print.printername="" print.documentname="" print.orientation = 0 print.margin.left = 110 print.margin.right = 110 print.margin.top = 96 print.margin.bottom = 96 print.paper.source = 0 print.paper.size = 0 print.canusedefaultprinter=yes print.prompt=no print.buttons=no print.preview.buttons=no print.cliptext=no print.overrideprintjob=no print.collate=yes hidegrayline=no grid.lines=0 selected.mouse=no )
    4. 

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

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

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

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

  8. table(column=(type=long updatewhereclause=yes name=u_outwaremx_outtype dbname="u_outwaremx.outtype" initial="0" )
    9. 

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

  10.  column=(type=decimal(4) updatewhereclause=yes name=u_outwaremx_qty dbname="u_outwaremx.qty" initial="0" validationmsg="'请输入数字'" )
    11. 

  11.  column=(type=decimal(5) updatewhereclause=yes name=u_outwaremx_addqty dbname="u_outwaremx.addqty" initial="0" )
    12. 

  12.  column=(type=decimal(10) updatewhereclause=yes name=u_outwaremx_enprice dbname="u_outwaremx.enprice" initial="0" )
    13. 

  13.  column=(type=decimal(5) updatewhereclause=yes name=u_outwaremx_rebate dbname="u_outwaremx.rebate" initial="1" )
    14. 

  14.  column=(type=decimal(10) updatewhereclause=yes name=u_outwaremx_cost dbname="u_outwaremx.cost" initial="0" )
    15. 

  15.  column=(type=char(255) updatewhereclause=yes name=u_outwaremx_status dbname="u_outwaremx.status" initial="empty" )
    16. 

  16.  column=(type=char(255) updatewhereclause=yes name=u_outwaremx_mxdscrp dbname="u_outwaremx.mxdscrp" initial="empty" )
    17. 

  17.  column=(type=long updatewhereclause=yes name=u_outwaremx_packqty dbname="u_outwaremx.packqty" initial="0" validationmsg="'请输入数字'" )
    18. 

  18.  column=(type=char(255) updatewhereclause=yes name=u_outwaremx_woodcode dbname="u_outwaremx.woodcode" initial="empty" )
    19. 

  19.  column=(type=char(255) updatewhereclause=yes name=u_outwaremx_pcode dbname="u_outwaremx.pcode" initial="empty" )
    20. 

  20.  column=(type=char(30) updatewhereclause=yes name=u_outwaremx_plancode dbname="u_outwaremx.plancode" initial="empty" )
    21. 

  21.  column=(type=decimal(10) updatewhereclause=yes name=u_outwaremx_price dbname="u_outwaremx.price" initial="0" validationmsg="'请输入数字'" )
    22. 

  22.  column=(type=long updatewhereclause=yes name=u_outwaremx_storageid dbname="u_outwaremx.storageid" initial="0" )
    23. 

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

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

  25.  column=(type=long updatewhereclause=yes name=u_outwaremx_outwareid dbname="u_outwaremx.outwareid" initial="0" )
    26. 

  26.  column=(type=long updatewhereclause=yes name=u_outwaremx_mtrlwareid dbname="u_outwaremx.mtrlwareid" initial="0" )
    27. 

  27.  column=(type=long updatewhereclause=yes name=u_outwaremx_mtrlid dbname="u_outwaremx.mtrlid" initial="0" )
    28. 

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

  29.  column=(type=decimal(2) updatewhereclause=yes name=u_outwaremx_costamt dbname="u_outwaremx.costamt" initial="0" )
    30. 

  30.  column=(type=decimal(10) updatewhereclause=yes name=u_outwaremx_fprice dbname="u_outwaremx.fprice" initial="0" )
    31. 

  31.  column=(type=decimal(10) updatewhereclause=yes name=u_outwaremx_planprice dbname="u_outwaremx.planprice" initial="0" )
    32. 

  32.  column=(type=long updatewhereclause=yes name=u_outwaremx_printid dbname="u_outwaremx.printid" )
    33. 

  33.  column=(type=char(30) updatewhereclause=yes name=u_mtrldef_prdpackcode dbname="u_mtrldef.prdpackcode" )
    34. 

  34.  column=(type=decimal(4) updatewhereclause=yes name=u_mtrldef_packqty dbname="u_mtrldef.packqty" )
    35. 

  35.  column=(type=long updatewhereclause=yes name=u_outwaremx_dxflag dbname="u_outwaremx.dxflag" values="	1/	0" )
    36. 

  36.  column=(type=long updatewhereclause=yes name=u_outwaremx_relid dbname="u_outwaremx.relid" initial="0" )
    37. 

  37.  column=(type=char(50) updatewhereclause=yes name=u_outwaremx_relcode dbname="u_outwaremx.relcode" )
    38. 

  38.  column=(type=decimal(4) updatewhereclause=yes name=u_mtrldef_curware_qty dbname="curware_qty" )
    39. 

  39.  column=(type=decimal(4) updatewhereclause=yes name=u_mtrldef_sumware_qty dbname="sumware_qty" )
    40. 

  40.  column=(type=decimal(4) updatewhereclause=yes name=u_mtrldef_sumneed_qty dbname="sumneed_qty" )
    41. 

  41.  column=(type=long updatewhereclause=yes name=u_mtrldef_editflag dbname="editflag" initial="1" )
    42. 

  42.  column=(type=long updatewhereclause=yes name=u_mtrldef_tflag dbname="tflag" initial="0" )
    43. 

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

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

  45.  column=(type=char(255) updatewhereclause=yes name=u_mtrldef_waredscrp dbname="u_mtrldef.waredscrp" )
    46. 

  46.  column=(type=datetime updatewhereclause=yes name=u_mtrlware_inworkdate dbname="u_mtrlware.inworkdate" )
    47. 

  47.  column=(type=char(50) updatewhereclause=yes name=u_mtrldef_mtrlengname dbname="u_mtrldef.mtrlengname" )
    48. 

  48.  retrieve="  SELECT u_outwaremx.outtype,
    49. 

  49. 			u_mtrldef.mtrlcode,
    50. 

  50.          u_outwaremx.qty, 
    51. 

  51.           u_outwaremx.addqty,    
    52. 

  52.          u_outwaremx.enprice,   
    53. 

  53. 			u_outwaremx.rebate,  
    54. 

  54. 			u_outwaremx.cost,
    55. 

  55.          u_outwaremx.status,
    56. 

  56.          u_outwaremx.mxdscrp, 
    57. 

  57.          u_outwaremx.packqty,    
    58. 

  58.    		u_outwaremx.woodcode,
    59. 

  59. 			u_outwaremx.pcode,
    60. 

  60.          u_outwaremx.plancode,   
    61. 

  61. 			u_outwaremx.price,   
    62. 

  62.          u_outwaremx.storageid,               
    63. 

  63.          u_mtrldef.mtrlname,   
    64. 

  64.          u_mtrldef.unit,   
    65. 

  65.          u_outwaremx.outwareid,   
    66. 

  66.          u_outwaremx.mtrlwareid,   
    67. 

  67.          u_outwaremx.mtrlid,   
    68. 

  68.          u_mtrldef.mtrlmode,   
    69. 

  69.          u_outwaremx.costamt, 
    70. 

  70.          u_outwaremx.fprice,     
    71. 

  71.          u_outwaremx.planprice,   
    72. 

  72.          u_outwaremx.printid,
    73. 

  73.         	u_mtrldef.prdpackcode,
    74. 

  74. 			u_mtrldef.packqty,
    75. 

  75. 			u_outwaremx.dxflag,
    76. 

  76. 			u_outwaremx.relid,
    77. 

  77. 			u_outwaremx.relcode,			
    78. 

  78.          0.0000 as curware_qty,
    79. 

  79. 			0.0000 as sumware_qty,
    80. 

  80. 			0.0000 as sumneed_qty,
    81. 

  81.          0 as editflag,
    82. 

  82.          0 as tflag,
    83. 

  83. 			u_mtrldef.mtrlsectype,
    84. 

  84. 			u_mtrldef.zxmtrlmode ,
    85. 

  85. 	case when u_mtrlware.waredscrp is  null then '' else u_mtrlware.waredscrp end as waredscrp,
    86. 

  86. 	u_mtrlware.inworkdate,
    87. 

  87. u_mtrldef.mtrlengname
    88. 

  88.     FROM u_mtrldef,   
    89. 

  89.          u_outwaremx LEFT OUTER JOIN 
    90. 

  90. 	u_mtrlware on u_mtrlware.mtrlwareid = u_outwaremx.mtrlwareid
    91. 

  91.    WHERE ( u_mtrldef.mtrlid = u_outwaremx.mtrlid ) and  
    92. 

  92.          ( u_outwaremx.outwareid = :arg_outwareid ) and
    93. 

  93. 			(u_outwaremx.scid = :arg_scid or :arg_scid = -1 )   
    94. 

  94. " arguments=(("arg_scid", number),("arg_outwareid", number))  sort="u_outwaremx_printid A " )
    95. 

  95. text(band=header alignment="2" text="品名" border="0" color="8388608" x="736" y="8" height="56" width="731" 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="1" background.color="536870912" )
    96. 

  96. text(band=header alignment="2" text="库存单位" border="0" color="8388608" x="1477" y="8" height="56" width="251" 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="1" background.color="536870912" )
    97. 

  97. text(band=header alignment="2" text="数量" border="0" color="16711680" x="2171" y="8" height="56" width="270" html.valueishtml="0"  name=u_outwaremx_qty_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" )
    98. 

  98. text(band=header alignment="2" text="本批存量" border="0" color="8388608" x="6789" y="8" height="56" width="288" html.valueishtml="0"  name=u_mtrldef_curware_qty_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="15780518" )
    99. 

  99. text(band=header alignment="2" text="总存量" border="0" color="8388608" x="7086" y="8" height="56" width="311" html.valueishtml="0"  name=u_mtrldef_sumware_qty_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="15780518" )
    100. 

  100. text(band=header alignment="2" text="总需求量 " border="0" color="8388608" x="7406" y="8" height="56" width="302" html.valueishtml="0"  name=u_mtrldef_sumneed_qty_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="15780518" )
    101. 

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

  102. text(band=header alignment="2" text="折后价" border="0" color="0" x="6555" y="8" height="56" width="224" html.valueishtml="0"  name=u_outwaremx_price_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" )
    103. 

  103. text(band=header alignment="2" text="编码" border="0" color="8388608" x="329" y="8" height="56" width="398" 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="16776960" )
    104. 

  104. text(band=header alignment="2" text="规格" border="0" color="0" x="1737" y="8" height="56" width="425" 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" )
    105. 

  105. text(band=header alignment="2" text="单价" border="0" color="16711680" x="2720" y="8" height="56" width="256" html.valueishtml="0"  name=u_outwaremx_enprice_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" )
    106. 

  106. text(band=header alignment="2" text="折扣" border="0" color="16711680" x="2985" y="8" height="56" width="137" html.valueishtml="0"  name=u_outwaremx_rebate_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    107. 

  107. text(band=header alignment="2" text="原币金额" border="0" color="0" x="3131" y="8" height="56" width="338" html.valueishtml="0"  name=enamt_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    108. 

  108. text(band=header alignment="2" text="本位币金额" border="0" color="8388608" x="5993" y="8" height="56" width="334" html.valueishtml="0"  name=amt_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    109. 

  109. text(band=header alignment="2" text="人民币单价" border="0" color="8388608" x="5687" y="8" height="56" width="297" html.valueishtml="0"  name=u_outwaremx_fprice_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    110. 

  110. text(band=header alignment="2" text="包装数" border="0" color="8388608" x="6336" y="8" height="56" width="210" html.valueishtml="0"  name=pack_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" )
    111. 

  111. text(band=header alignment="2" text="类型" border="0" color="16711680" x="82" y="8" height="56" width="238" html.valueishtml="0"  name=u_outwaremx_outtype_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" )
    112. 

  112. text(band=header alignment="2" text="批号" border="0" color="16711680" x="5294" y="8" height="56" width="384" html.valueishtml="0"  name=t_1 visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
    113. 

  113. text(band=header alignment="2" text="明细备注" border="0" color="16711680" x="3776" y="8" height="56" width="475" html.valueishtml="0"  name=u_outwaremx_mxdscrp_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    114. 

  114. text(band=header alignment="2" text="属性" border="0" color="16711680" x="4261" y="8" height="56" width="329" html.valueishtml="0"  name=u_outwaremx_status_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" )
    115. 

  115. text(band=header alignment="2" text="属性1" border="0" color="16711680" x="4599" y="8" height="56" width="306" html.valueishtml="0"  name=u_outwaremx_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" )
    116. 

  116. text(band=header alignment="2" text="属性2" border="0" color="16711680" x="4914" y="8" height="56" width="370" html.valueishtml="0"  name=u_outwaremx_pcode_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" )
    117. 

  117. text(band=header alignment="2" text="辅数" border="0" color="16711680" x="2450" y="8" height="56" width="261" html.valueishtml="0"  name=u_outwaremx_addqty_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" )
    118. 

  118. text(band=header alignment="2" text="销售单号[保存]" border="0" color="0" x="7717" y="8" height="56" width="411" html.valueishtml="0"  name=u_outwaremx_relcode_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" )
    119. 

  119. text(band=header alignment="2" text="自定义1" border="0" color="33554432" x="8137" y="8" height="56" width="343" 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" )
    120. 

  120. text(band=header alignment="2" text="成本价" border="0" color="16711680" x="3479" y="8" height="56" width="288" html.valueishtml="0"  name=u_outwaremx_cost_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" )
    121. 

  121. text(band=header alignment="2" text="自定义2" border="0" color="33554432" x="8489" y="8" height="56" width="379" 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" )
    122. 

  122. text(band=header alignment="2" text="库存摘要" border="0" color="8388608" x="8878" y="8" height="56" width="553" html.valueishtml="0"  name=u_mtrldef_waredscrp_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" )
    123. 

  123. column(band=detail id=16 alignment="0" tabsequence=32766 border="0" color="8388608" x="736" y="4" height="68" width="731" format="[general]" html.valueishtml="0"  name=u_mtrldef_mtrlname  tag="物料名称" visible="1" edit.limit=50 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="0" background.color="536870912~tif( (  u_mtrldef_sumneed_qty >  u_mtrldef_sumware_qty  or  u_mtrldef_sumware_qty =0 ) and  u_mtrldef_editflag =1 and  u_mtrldef_tflag =0, if( u_outwaremx_mtrlid =0,rgb(255,200,200),rgb(255,255,200)),rgb(255,255,255))" )
    124. 

  124. column(band=detail id=31 alignment="1" tabsequence=32766 border="0" color="8388608" x="6789" y="4" height="68" width="288" format="#,##0.####" html.valueishtml="0"  name=u_mtrldef_curware_qty visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="0" background.color="536870912~tif( (  u_mtrldef_sumneed_qty >  u_mtrldef_sumware_qty  or  u_mtrldef_sumware_qty =0 ) and  u_mtrldef_editflag =1 and  u_mtrldef_tflag =0, if( u_outwaremx_mtrlid =0,rgb(255,200,200),rgb(255,255,200)),rgb(255,255,255))" )
    125. 

  125. column(band=detail id=32 alignment="1" tabsequence=32766 border="0" color="8388608" x="7086" y="4" height="68" width="311" format="#,##0.####" html.valueishtml="0"  name=u_mtrldef_sumware_qty visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="0" background.color="536870912~tif( (  u_mtrldef_sumneed_qty >  u_mtrldef_sumware_qty  or  u_mtrldef_sumware_qty =0 ) and  u_mtrldef_editflag =1 and  u_mtrldef_tflag =0, if( u_outwaremx_mtrlid =0,rgb(255,200,200),rgb(255,255,200)),rgb(255,255,255))" )
    126. 

  126. column(band=detail id=33 alignment="1" tabsequence=32766 border="0" color="8388608" x="7406" y="4" height="68" width="302" format="#,##0.####" html.valueishtml="0"  name=u_mtrldef_sumneed_qty visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="0" background.color="536870912~tif( (  u_mtrldef_sumneed_qty >  u_mtrldef_sumware_qty  or  u_mtrldef_sumware_qty =0 ) and  u_mtrldef_editflag =1 and  u_mtrldef_tflag =0, if( u_outwaremx_mtrlid =0,rgb(255,200,200),rgb(255,255,200)),rgb(255,255,255))" )
    127. 

  127. column(band=detail id=17 alignment="2" tabsequence=32766 border="0" color="8388608" x="1477" y="4" height="68" width="251" format="[general]" html.valueishtml="0"  name=u_mtrldef_unit  tag="标准库存单位" visible="1" edit.limit=10 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="0" background.color="536870912~tif( (  u_mtrldef_sumneed_qty >  u_mtrldef_sumware_qty  or  u_mtrldef_sumware_qty =0 ) and  u_mtrldef_editflag =1 and  u_mtrldef_tflag =0, if( u_outwaremx_mtrlid =0,rgb(255,200,200),rgb(255,255,200)),rgb(255,255,255))" )
    128. 

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

  129. column(band=detail id=14 alignment="1" tabsequence=32766 border="0" color="0" x="6555" y="4" height="68" width="224" format="#,##0.##########" html.valueishtml="0"  name=u_outwaremx_price  tag="出仓单价" visible="1" edit.limit=0 edit.case=any edit.format="#,##0.##########" edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="0" background.color="536870912~tif( (  u_mtrldef_sumneed_qty >  u_mtrldef_sumware_qty  or  u_mtrldef_sumware_qty =0 ) and  u_mtrldef_editflag =1 and  u_mtrldef_tflag =0, if( u_outwaremx_mtrlid =0,rgb(255,200,200),rgb(255,255,200)),rgb(255,255,255))" )
    130. 

  130. column(band=detail id=2 alignment="0" tabsequence=32766 border="0" color="8388608" x="329" y="4" height="68" width="398" format="[general]" html.valueishtml="0"  name=u_mtrldef_mtrlcode  tag="物料编码" visible="1" edit.limit=30 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="0" background.color="16776960~tif( (  u_mtrldef_sumneed_qty >  u_mtrldef_sumware_qty  or  u_mtrldef_sumware_qty =0 ) and  u_mtrldef_editflag =1 and  u_mtrldef_tflag =0, if( u_outwaremx_mtrlid =0,rgb(255,200,200),rgb(255,255,200)),rgb(230,230,255))" )
    131. 

  131. column(band=detail id=21 alignment="0" tabsequence=32766 border="0" color="0" x="1737" y="4" height="68" width="425" format="[general]" html.valueishtml="0"  name=u_mtrldef_mtrlmode visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="0" background.color="536870912~tif( (  u_mtrldef_sumneed_qty >  u_mtrldef_sumware_qty  or  u_mtrldef_sumware_qty =0 ) and  u_mtrldef_editflag =1 and  u_mtrldef_tflag =0, if( u_outwaremx_mtrlid =0,rgb(255,200,200),rgb(255,255,200)),rgb(255,255,255))" )
    132. 

  132. column(band=detail id=5 alignment="1" tabsequence=32766 border="0" color="16711680" x="2720" y="4" height="68" width="256" format="#,##0.##########" html.valueishtml="0"  name=u_outwaremx_enprice visible="1" edit.limit=0 edit.case=any edit.format="#,##0.##########" edit.autoselect=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
    133. 

  133. column(band=detail id=6 alignment="1" tabsequence=32766 border="0" color="16711680" x="2985" y="4" height="68" width="137" format="#,##0.0###" html.valueishtml="0"  name=u_outwaremx_rebate visible="1" edit.limit=0 edit.case=any edit.format="#,##0.0###" edit.focusrectangle=no edit.autoselect=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="0" background.color="536870912~tif( (  u_mtrldef_sumneed_qty >  u_mtrldef_sumware_qty  or  u_mtrldef_sumware_qty =0 ) and  u_mtrldef_editflag =1 and  u_mtrldef_tflag =0, if( u_outwaremx_mtrlid =0,rgb(255,200,200),rgb(255,255,200)),rgb(255,255,255))" )
    134. 

  134. compute(band=detail alignment="1" expression="  round(u_outwaremx_enprice  *  u_outwaremx_rebate   *  u_outwaremx_qty ,2)"border="0" color="0" x="3131" y="4" height="68" width="338" format="#,##0.00" html.valueishtml="0"  name=enamt 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" )
    135. 

  135. column(band=detail id=23 alignment="1" tabsequence=32766 border="0" color="8388608" x="5687" y="4" height="68" width="297" format="#,##0.##########" html.valueishtml="0"  name=u_outwaremx_fprice visible="1" edit.limit=0 edit.case=any edit.format="#,##0.##########" edit.focusrectangle=no edit.autoselect=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="0" background.color="536870912~tif( (  u_mtrldef_sumneed_qty >  u_mtrldef_sumware_qty  or  u_mtrldef_sumware_qty =0 ) and  u_mtrldef_editflag =1 and  u_mtrldef_tflag =0, if( u_outwaremx_mtrlid =0,rgb(255,200,200),rgb(255,255,200)),rgb(255,255,255))" )
    136. 

  136. compute(band=detail alignment="1" expression="  round(u_outwaremx_fprice  *  u_outwaremx_rebate   *  u_outwaremx_qty ,2)"border="0" color="8388608" x="5993" y="4" height="68" width="334" format="#,##0.00" html.valueishtml="0"  name=amt visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="0" background.color="16777215~tif( (  u_mtrldef_sumneed_qty >  u_mtrldef_sumware_qty  or  u_mtrldef_sumware_qty =0 ) and  u_mtrldef_editflag =1 and  u_mtrldef_tflag =0, if( u_outwaremx_mtrlid =0,rgb(255,200,200),rgb(255,255,200)),rgb(255,255,255))" )
    137. 

  137. compute(band=detail alignment="2" expression=" u_outwaremx_qty  *   u_mtrldef_packqty "border="0" color="8388608" x="6336" y="4" height="68" width="210" format="####" html.valueishtml="0"  name=pack 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" )
    138. 

  138. column(band=detail id=1 alignment="0" tabsequence=32766 border="0" color="16711680" x="82" y="4" height="68" width="238" format="[general]" html.valueishtml="0"  name=u_outwaremx_outtype visible="1" dddw.name=ddd_outtype dddw.displaycolumn=outtypename dddw.datacolumn=outtype dddw.percentwidth=0 dddw.lines=0 dddw.limit=0 dddw.allowedit=no dddw.useasborder=no dddw.case=any dddw.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
    139. 

  139. column(band=detail id=13 alignment="0" tabsequence=32766 border="0" color="16711680" x="5294" y="4" height="68" width="384" format="[general]" html.valueishtml="0"  name=u_outwaremx_plancode visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="0" background.color="536870912~tif( (  u_mtrldef_sumneed_qty >  u_mtrldef_sumware_qty  or  u_mtrldef_sumware_qty =0 ) and  u_mtrldef_editflag =1 and  u_mtrldef_tflag =0, if( u_outwaremx_mtrlid =0,rgb(255,200,200),rgb(255,255,200)),rgb(255,255,255))" )
    140. 

  140. column(band=detail id=9 alignment="0" tabsequence=32766 border="0" color="16711680" x="3776" y="4" height="68" width="475" format="[general]" html.valueishtml="0"  name=u_outwaremx_mxdscrp visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="0" background.color="536870912~tif( (  u_mtrldef_sumneed_qty >  u_mtrldef_sumware_qty  or  u_mtrldef_sumware_qty =0 ) and  u_mtrldef_editflag =1 and  u_mtrldef_tflag =0, if( u_outwaremx_mtrlid =0,rgb(255,200,200),rgb(255,255,200)),rgb(255,255,255))" )
    141. 

  141. column(band=detail id=8 alignment="0" tabsequence=32766 border="0" color="16711680" x="4261" y="4" height="68" width="329" format="[general]" html.valueishtml="0"  name=u_outwaremx_status visible="1" dddw.name=ddd_color dddw.displaycolumn=colorname dddw.datacolumn=colorname dddw.percentwidth=120 dddw.lines=0 dddw.limit=0 dddw.allowedit=yes dddw.useasborder=no dddw.case=any dddw.imemode=0 dddw.vscrollbar=yes  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
    142. 

  142. column(band=detail id=11 alignment="0" tabsequence=32766 border="0" color="16711680" x="4599" y="4" height="68" width="306" format="[general]" html.valueishtml="0"  name=u_outwaremx_woodcode visible="1" dddw.name=ddd_color_wood dddw.displaycolumn=woodcode dddw.datacolumn=woodcode dddw.percentwidth=150 dddw.lines=0 dddw.limit=0 dddw.allowedit=yes dddw.useasborder=no dddw.case=any dddw.imemode=0 dddw.vscrollbar=yes  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
    143. 

  143. column(band=detail id=12 alignment="0" tabsequence=32766 border="0" color="16711680" x="4914" y="4" height="68" width="370" format="[general]" html.valueishtml="0"  name=u_outwaremx_pcode visible="1" dddw.name=ddd_color_pcode dddw.displaycolumn=pcode dddw.datacolumn=pcode dddw.percentwidth=150 dddw.lines=0 dddw.limit=0 dddw.allowedit=yes dddw.useasborder=no dddw.case=any dddw.imemode=0 dddw.vscrollbar=yes  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
    144. 

  144. column(band=detail id=3 alignment="1" tabsequence=32766 border="0" color="16711680" x="2171" y="4" height="68" width="270" format="#,##0.####" html.valueishtml="0"  name=u_outwaremx_qty  tag="出仓数量" visible="1" edit.limit=0 edit.case=any edit.format="#,##0.####" edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="0" background.color="536870912~tif( (  u_mtrldef_sumneed_qty >  u_mtrldef_sumware_qty  or  u_mtrldef_sumware_qty =0 ) and  u_mtrldef_editflag =1 and  u_mtrldef_tflag =0, if( u_outwaremx_mtrlid =0,rgb(255,200,200),rgb(255,255,200)),rgb(255,255,255))" )
    145. 

  145. column(band=detail id=4 alignment="1" tabsequence=32766 border="0" color="16711680" x="2450" y="4" height="68" width="261" format="#,##0.####" html.valueishtml="0"  name=u_outwaremx_addqty visible="1" edit.limit=0 edit.case=any edit.format="#,##0.####" edit.autoselect=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
    146. 

  146. column(band=detail id=30 alignment="0" tabsequence=32766 border="0" color="0" x="7717" y="4" height="68" width="411" format="[general]" html.valueishtml="0"  name=u_outwaremx_relcode visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
    147. 

  147. column(band=detail id=36 alignment="0" tabsequence=32766 border="0" color="33554432" x="8137" y="4" height="68" width="343" format="[general]" html.valueishtml="0"  name=u_mtrldef_mtrlsectype visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
    148. 

  148. column(band=detail id=7 alignment="1" tabsequence=32766 border="0" color="16711680" x="3479" y="4" height="68" width="288" format="#,##0.##########" html.valueishtml="0" protect="0~t if (u_outwaremx_mtrlwareid >0,1,0)"  name=u_outwaremx_cost visible="1" edit.limit=0 edit.case=any edit.format="#,##0.##########" edit.focusrectangle=no edit.autoselect=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
    149. 

  149. column(band=detail id=37 alignment="0" tabsequence=32766 border="0" color="33554432" x="8489" y="4" height="68" width="379" format="[general]" html.valueishtml="0"  name=u_mtrldef_zxmtrlmode visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
    150. 

  150. column(band=detail id=38 alignment="0" tabsequence=32766 border="0" color="8388608" x="8878" y="4" height="68" width="553" format="[general]" html.valueishtml="0"  name=u_mtrldef_waredscrp visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
    151. 

  151. compute(band=footer alignment="1" expression="sum(u_outwaremx_qty for all)"border="0" color="16711680" x="2171" y="4" height="56" width="270" 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="1" background.color="536870912" )
    152. 

  152. compute(band=footer alignment="2" expression="count(  u_mtrldef_mtrlcode  for all )"border="0" color="16711680" x="329" y="4" height="56" width="398" format="[general]" html.valueishtml="0"  name=compute_3 visible="1"  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
    153. 

  153. compute(band=footer alignment="1" expression="sum(  round(u_outwaremx_enprice  *  u_outwaremx_rebate   *  u_outwaremx_qty ,2) for all)"border="0" color="0" x="3131" y="4" height="56" width="338" format="#,##0.00" html.valueishtml="0"  name=compute_6 visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    154. 

  154. compute(band=footer alignment="1" expression="sum( amt  for all)"border="0" color="8388608" x="5993" y="4" height="56" width="334" format="#,##0.00" html.valueishtml="0"  name=compute_1 visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    155. 

  155. compute(band=footer alignment="2" expression="sum( u_outwaremx_qty  *   u_mtrldef_packqty  for all)"border="0" color="8388608" x="6336" y="4" height="56" width="210" format="####" 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="16777215" )
    156. 

  156. compute(band=footer alignment="1" expression="sum(u_outwaremx_addqty for all)"border="0" color="16711680" x="2450" y="4" height="56" width="261" 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="1" background.color="536870912" )
    157. 

  157. text(band=header alignment="2" text="有效期" border="0" color="8388608" x="9440" y="8" height="56" width="503" html.valueishtml="0"  name=u_mtrlware_inworkdate_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" )
    158. 

  158. text(band=header alignment="2" text="英文名称" border="0" color="8388608" x="9952" y="8" height="56" width="462" html.valueishtml="0"  name=u_mtrldef_mtrlengname_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" )
    159. 

  159. column(band=detail id=39 alignment="0" tabsequence=32766 border="0" color="8388608" x="9440" y="4" height="68" width="503" format="yyyy-mm-dd" html.valueishtml="0"  name=u_mtrlware_inworkdate visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
    160. 

  160. column(band=detail id=40 alignment="0" tabsequence=0 border="0" color="8388608" x="9957" y="4" height="68" width="457" html.valueishtml="0"  name=u_mtrldef_mtrlengname visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
    161. 

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

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

  163. export.xml(headgroups="1" includewhitespace="0" metadatatype=0 savemetadata=0 )
    164. 

  164. import.xml()
    165. 

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