Strona główna Odkrywaj Pomoc
Zaloguj się
Neil
/
Q5
1
0
Forkuj 0
Pliki Problemy 0 Oczekujące zmiany 0 Wiki
Drzewo: c3343d5110
Gałęzie Tagi
Q5
/
ws_objects
/
xls_defaultdw.pbl.src
/
dw_xls_inwaremx_cp.srd

dw_xls_inwaremx_cp.srd 29 KB
Historia Czysty

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149 
  1. $PBExportHeader$dw_xls_inwaremx_cp.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=72 color="536870912" )
    7. 

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

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

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

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

  11.  column=(type=decimal(10) updatewhereclause=yes name=u_inwaremx_fprice dbname="u_inwaremx.fprice" initial="0" )
    12. 

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

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

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

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

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

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

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

  19.  column=(type=char(255) updatewhereclause=yes name=u_inwaremx_formula dbname="u_inwaremx.formula" initial="empty" )
    20. 

  20.  column=(type=char(255) updatewhereclause=yes name=u_inwaremx_waredscrp dbname="u_inwaremx.waredscrp" initial="empty" )
    21. 

  21.  column=(type=datetime updatewhereclause=yes name=u_inwaremx_inworkdate dbname="u_inwaremx.inworkdate" initial="empty" )
    22. 

  22.  column=(type=long updatewhereclause=yes name=if_mtrlware dbname="u_inwaremx.if_mtrlware" initial="0" values="	1/	0" )
    23. 

  23.  column=(type=char(20) updatewhereclause=yes name=u_cust_cuscode dbname="u_cust.cuscode" initial="empty" )
    24. 

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

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

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

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

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

  29.  column=(type=decimal(4) updatewhereclause=yes name=u_mtrldef_packqty dbname="u_mtrldef.packqty" initial="0" )
    30. 

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

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

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

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

  34.  column=(type=char(30) updatewhereclause=yes name=u_inwaremx_mtrlcuscode dbname="u_inwaremx.mtrlcuscode" initial="empty" )
    35. 

  35.  column=(type=char(50) updatewhereclause=yes name=u_cust_name dbname="u_cust.name" initial="empty" )
    36. 

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

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

  38.  column=(type=decimal(10) updatewhereclause=yes name=u_mtrldef_lmsaleprice dbname="u_mtrldef.lmsaleprice" initial="0" )
    39. 

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

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

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

  42.  column=(type=char(255) updatewhereclause=yes name=pic dbname="pic" )
    43. 

  43.  retrieve="  SELECT u_inwaremx.mtrlid, 
    44. 

  44. 			u_inwaremx.ifrel,   
    45. 

  45.          u_mtrldef.mtrlcode,
    46. 

  46. 			u_inwaremx.fprice,   
    47. 

  47.          u_inwaremx.qty, 
    48. 

  48. 			u_inwaremx.addqty,
    49. 

  49. 			u_inwaremx.mxdscrp,   
    50. 

  50.          u_inwaremx.status,
    51. 

  51.          u_inwaremx.woodcode,    
    52. 

  52.          u_inwaremx.pcode,        
    53. 

  53.          u_inwaremx.plancode,
    54. 

  54. 			u_inwaremx.formula,
    55. 

  55. 			u_inwaremx.waredscrp,
    56. 

  56.  			u_inwaremx.inworkdate , 
    57. 

  57. 			case u_inwaremx.sptid_cusid when 0 then 0 else 1 end as if_mtrlware,
    58. 

  58. 			u_cust.cuscode, 
    59. 

  59.            
    60. 

  60.          u_mtrldef.unit,   
    61. 

  61.          u_mtrldef.mtrlname,   
    62. 

  62.          u_inwaremx.inwareid,   
    63. 

  63.          u_mtrldef.mtrlmode,   
    64. 

  64.          u_mtrldef.prdpackcode,   
    65. 

  65.          u_mtrldef.packqty,   
    66. 

  66.          u_inwaremx.printid,   
    67. 

  67.          u_inwaremx.relid  ,   
    68. 

  68.          u_inwaremx.relcode ,   
    69. 

  69.          u_inwaremx.sptid_cusid ,  
    70. 

  70. 			u_inwaremx.mtrlcuscode,
    71. 

  71. 			u_cust.name ,
    72. 

  72. 			u_mtrldef.mtrlsectype,
    73. 

  73. 			u_mtrldef.zxmtrlmode,
    74. 

  74. 			u_mtrldef.lmsaleprice,
    75. 

  75. u_mtrldef.statusflag,
    76. 

  76. u_mtrldef.woodcodeflag,
    77. 

  77. u_mtrldef.pcodeflag,
    78. 

  78. 			SPACE(255)  as pic
    79. 

  79.     FROM u_inwaremx left outer join u_cust on u_inwaremx.sptid_cusid = u_cust.cusid,   
    80. 

  80.          u_mtrldef  
    81. 

  81.    WHERE ( u_inwaremx.mtrlid = u_mtrldef.mtrlid ) and  
    82. 

  82.          ( u_inwaremx.inwareid = :arg_inwareid ) and
    83. 

  83. 			( u_inwaremx.scid = :arg_scid ) " arguments=(("arg_inwareid", number),("arg_scid", number))  sort="u_inwaremx_printid A " )
    84. 

  84. text(band=header alignment="2" text="品名" border="0" color="8388608" x="494" y="8" height="56" width="539" 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" )
    85. 

  85. text(band=header alignment="2" text="进仓金额" border="0" color="0" x="3186" y="8" height="56" width="329" 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" )
    86. 

  86. text(band=header alignment="2" text="规格" border="0" color="8388608" x="1042" y="8" height="56" 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" )
    87. 

  87. text(band=header alignment="2" text="库存单位" border="0" color="8388608" x="2126" y="8" height="56" width="229" 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" )
    88. 

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

  89. text(band=header alignment="2" text="属性" border="0" color="16711680" x="4539" y="8" height="56" width="352" html.valueishtml="0"  name=u_inwaremx_status_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
    90. 

  90. text(band=header alignment="2" text="数量" border="0" color="16711680" x="2615" y="8" height="56" width="293" html.valueishtml="0"  name=u_inwaremx_qty_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    91. 

  91. text(band=header alignment="2" text="序" border="0" color="0" x="9" y="8" height="56" width="73" html.valueishtml="0"  name=t_4 visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    92. 

  92. text(band=header alignment="2" text="属性1" border="0" color="16711680" x="4901" y="8" height="56" width="320" html.valueishtml="0"  name=u_inwaremx_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="16777215" )
    93. 

  93. text(band=header alignment="2" text="客户名称" border="0" color="33554432" x="7579" y="8" height="56" width="690" html.valueishtml="0"  name=u_cust_name_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
    94. 

  94. text(band=header alignment="2" text="批号" border="0" color="16711680" x="5609" y="8" height="56" width="357" 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="2" background.color="16777215" )
    95. 

  95. text(band=header alignment="2" text="公式" border="0" color="16711680" x="3986" y="8" height="56" width="544" html.valueishtml="0"  name=u_inwaremx_formula_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
    96. 

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

  97. text(band=header alignment="2" text="客户编号" border="0" color="16711680" x="7109" y="8" height="56" width="462" html.valueishtml="0"  name=u_cust_cuscode_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
    98. 

  98. text(band=header alignment="2" text="按客户" border="0" color="16711680" x="6926" y="8" height="56" width="174" html.valueishtml="0"  name=if_mtrlware_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
    99. 

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

  100. text(band=header alignment="2" text="库存摘要" border="0" color="16711680" x="5975" y="8" height="56" width="430" html.valueishtml="0"  name=u_inwaremx_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="16777215" )
    101. 

  101. text(band=header alignment="2" text="有效期" border="0" color="16711680" x="6414" y="8" height="56" width="503" html.valueishtml="0"  name=u_inwaremx_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="16777215" )
    102. 

  102. text(band=header alignment="2" text="自定义1" border="0" color="33554432" x="1472" y="8" height="56" width="306" html.valueishtml="0"  name=u_mtrldef_mtrlsectype_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    103. 

  103. text(band=header alignment="2" text="自定义2" border="0" color="33554432" x="1787" y="8" height="56" width="329" html.valueishtml="0"  name=u_mtrldef_zxmtrlmode_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    104. 

  104. text(band=header alignment="2" text="包装" border="0" color="33554432" x="8279" y="8" height="56" width="334" html.valueishtml="0"  name=t_2 visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    105. 

  105. text(band=header alignment="2" text="订单号" border="0" color="33554432" x="8622" y="8" height="56" width="453" html.valueishtml="0"  name=u_inwaremx_relcode_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    106. 

  106. text(band=header alignment="2" text="客户说明" border="0" color="33554432" x="9083" y="8" height="56" width="475" html.valueishtml="0"  name=u_inwaremx_mtrlcuscode_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="33554432" x="9568" y="8" height="56" width="343" html.valueishtml="0"  name=u_mtrldef_lmsaleprice_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="0" x="2363" y="8" height="56" width="242" html.valueishtml="0"  name=u_inwaremx_fprice_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
    109. 

  109. text(band=header alignment="2" text="设定售价金额" border="0" color="33554432" x="9920" y="8" height="56" width="366" html.valueishtml="0"  name=lmsaleamt_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="91" y="8" height="56" width="393" 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="15793151" )
    111. 

  111. column(band=detail id=18 alignment="0" tabsequence=32766 border="0" color="8388608" x="494" y="4" height="68" width="539" format="[general]" html.valueishtml="0"  name=u_mtrldef_mtrlname  tag="物料名称" visible="1" edit.limit=50 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    112. 

  112. column(band=detail id=20 alignment="0" tabsequence=32766 border="0" color="8388608" x="1042" y="4" height="68" width="421" format="[general]" html.valueishtml="0"  name=u_mtrldef_mtrlmode visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    113. 

  113. column(band=detail id=17 alignment="2" tabsequence=32766 border="0" color="8388608" x="2126" y="4" height="68" width="229" format="[general]" html.valueishtml="0"  name=u_mtrldef_unit visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    114. 

  114. column(band=detail id=7 alignment="0" tabsequence=32766 border="0" color="16711680" x="3525" y="4" height="68" width="453" format="[general]" html.valueishtml="0"  name=u_inwaremx_mxdscrp visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    115. 

  115. column(band=detail id=8 alignment="0" tabsequence=32766 border="0" color="16711680" x="4539" y="4" height="68" width="352" format="[general]" html.valueishtml="0"  name=u_inwaremx_status visible="1" ddlb.limit=0 ddlb.allowedit=no ddlb.case=any ddlb.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    116. 

  116. compute(band=detail alignment="1" expression=" round(u_inwaremx_fprice  *  u_inwaremx_qty  ,2)"border="0" color="0" x="3186" y="4" height="68" width="329" 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="2" background.color="16777215" )
    117. 

  117. compute(band=detail alignment="2" expression="getrow()"border="0" color="0" x="9" y="4" height="68" width="73" format="[general]" html.valueishtml="0"  name=printid visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    118. 

  118. column(band=detail id=9 alignment="0" tabsequence=32766 border="0" color="16711680" x="4901" y="4" height="68" width="320" format="[general]" html.valueishtml="0"  name=u_inwaremx_woodcode visible="1" ddlb.limit=0 ddlb.allowedit=no ddlb.case=any ddlb.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    119. 

  119. column(band=detail id=28 alignment="0" tabsequence=32766 border="0" color="8388608" x="7579" y="4" height="68" width="690" format="[general]" html.valueishtml="0"  name=u_cust_name visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    120. 

  120. column(band=detail id=11 alignment="0" tabsequence=32766 border="0" color="16711680" x="5609" y="4" height="68" width="357" format="" html.valueishtml="0"  name=u_inwaremx_plancode visible="1" edit.limit=30 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    121. 

  121. column(band=detail id=10 alignment="0" tabsequence=32766 border="0" color="16711680" x="5230" y="4" height="68" width="370" format="[general]" html.valueishtml="0"  name=u_inwaremx_pcode visible="1" ddlb.limit=0 ddlb.allowedit=no ddlb.case=any ddlb.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    122. 

  122. column(band=detail id=16 alignment="0" tabsequence=32766 border="0" color="16711680" x="7109" y="4" height="68" width="462" format="[general]" html.valueishtml="0" protect="0~tif(arg_cus_mtrlware =1,0,1)"  name=u_cust_cuscode visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    123. 

  123. column(band=detail id=15 alignment="2" tabsequence=32766 border="0" color="8388608" x="6926" y="4" height="68" width="174" format="[general]" html.valueishtml="0"  name=if_mtrlware visible="1" checkbox.text="" checkbox.on="1" checkbox.off="0" checkbox.scale=no checkbox.threed=yes  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    124. 

  124. column(band=detail id=5 alignment="1" tabsequence=32766 border="0" color="16711680" x="2615" y="4" height="68" width="293" format="#,##0.####" html.valueishtml="0"  name=u_inwaremx_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="2" background.color="16777215" )
    125. 

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

  126. column(band=detail id=29 alignment="0" tabsequence=32766 border="0" color="8388608" x="1472" y="4" height="68" width="306" format="[general]" html.valueishtml="0"  name=u_mtrldef_mtrlsectype visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    127. 

  127. column(band=detail id=30 alignment="0" tabsequence=32766 border="0" color="8388608" x="1787" y="4" height="68" width="329" format="[general]" html.valueishtml="0"  name=u_mtrldef_zxmtrlmode visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    128. 

  128. compute(band=detail alignment="0" expression="f_pack_dscrp(  u_inwaremx_mtrlid  , u_inwaremx_qty , u_mtrldef_prdpackcode , u_mtrldef_packqty , u_mtrldef_unit )"border="0" color="33554432" x="8279" y="4" height="68" width="334" format="[GENERAL]" html.valueishtml="0"  name=compute_4 visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    129. 

  129. column(band=detail id=25 alignment="0" tabsequence=32766 border="0" color="33554432" x="8622" y="4" height="68" width="453" format="[general]" html.valueishtml="0"  name=u_inwaremx_relcode visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    130. 

  130. column(band=detail id=27 alignment="0" tabsequence=32766 border="0" color="33554432" x="9083" y="4" height="68" width="475" format="[general]" html.valueishtml="0"  name=u_inwaremx_mtrlcuscode visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    131. 

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

  132. column(band=detail id=12 alignment="0" tabsequence=32766 border="0" color="16711680" x="3986" y="4" height="68" width="544" format="[general]" html.valueishtml="0"  name=u_inwaremx_formula visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    133. 

  133. column(band=detail id=31 alignment="1" tabsequence=32766 border="0" color="33554432" x="9568" y="4" height="68" width="343" format="#,##0.#####" html.valueishtml="0"  name=u_mtrldef_lmsaleprice visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    134. 

  134. compute(band=detail alignment="1" expression=" u_inwaremx_qty  *  u_mtrldef_lmsaleprice "border="0" color="33554432" x="9920" y="4" height="68" width="366" format="#,##0.##" html.valueishtml="0"  name=lmsaleamt 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=13 alignment="0" tabsequence=32766 border="0" color="16711680" x="5975" y="4" height="68" width="430" format="[general]" html.valueishtml="0"  name=u_inwaremx_waredscrp visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    136. 

  136. column(band=detail id=14 alignment="0" tabsequence=32766 border="0" color="16711680" x="6414" y="4" height="68" width="503" format="[shortdate] [time]" html.valueishtml="0"  name=u_inwaremx_inworkdate visible="1" editmask.spin=yes editmask.mask="yyyy-mm-dd" editmask.imemode=0 editmask.spinincr=0 editmask.focusrectangle=no  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    137. 

  137. column(band=detail id=3 alignment="0" tabsequence=32766 border="0" color="8388608" x="91" y="4" height="68" width="393" format="[general]" html.valueishtml="0"  name=u_mtrldef_mtrlcode  tag="物料编码" visible="1" edit.limit=30 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="15793151" )
    138. 

  138. compute(band=footer alignment="1" expression=" sum(  round(u_inwaremx_fprice  *  u_inwaremx_qty,2)  for all) "border="0" color="0" x="3186" y="4" height="56" width="329" format="#,##0.00" html.valueishtml="0"  name=compute_2 visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    139. 

  139. compute(band=footer alignment="1" expression="sum(u_inwaremx_qty for all)"border="0" color="16711680" x="2615" y="4" height="56" width="293" format="#,##0.0###" html.valueishtml="0"  name=compute_3 visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    140. 

  140. compute(band=footer alignment="1" expression="sum(u_inwaremx_addqty for all)"border="0" color="16711680" x="2917" y="4" height="56" width="261" format="#########0.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="16777215" )
    141. 

  141. compute(band=footer alignment="1" expression="sum(lmsaleamt for all)"border="0" color="33554432" x="9920" y="8" height="56" width="366" format="#,##0.##" html.valueishtml="0"  name=compute_6 visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    142. 

  142. compute(band=footer alignment="2" expression="count(  u_mtrldef_mtrlcode  for all )"border="0" color="16711680" x="91" y="4" height="56" width="393" format="[general]" html.valueishtml="0"  name=compute_1 visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    143. 

  143. column(band=detail id=35 alignment="0" tabsequence=0 border="0" color="8388608" x="10299" y="0" height="56" width="608" html.valueishtml="0"  name=pic visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    144. 

  144. text(band=header alignment="2" text="图片" border="0" color="33554432" x="10295" y="4" height="76" width="613" html.valueishtml="0"  name=pic_t visible="1"  font.face="Arial" font.height="-12" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" )
    145. 

  145. htmltable(border="1" )
    146. 

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

  147. export.xml(headgroups="1" includewhitespace="0" metadatatype=0 savemetadata=0 )
    148. 

  148. import.xml()
    149. 

  149. export.pdf(method=0 distill.custompostscript="0" xslfop.print="0" )
    150.