SubContractMatReq.kdrs-form 65 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <DocRoot xmlns:c="http://www.kingdee.com/Common" xmlns:f="http://www.kingdee.com/Form" xmlns:t="http://www.kingdee.com/Table" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="4.0">
  3. <DocInfo>
  4. <c:Created>Sat Jan 07 17:09:49 CST 2006</c:Created>
  5. <c:Company>kingdee.com</c:Company>
  6. <c:LastModified>Sat Jun 27 19:16:08 CST 2009</c:LastModified>
  7. <c:Author>null</c:Author>
  8. </DocInfo>
  9. <DataSources version="2.0">
  10. <c:DataSource id="metas">
  11. <c:Reference />
  12. <c:Params />
  13. </c:DataSource>
  14. </DataSources>
  15. <Schemes />
  16. <Styles version="1.0">
  17. <c:Style id="3">
  18. <c:Font fontName="宋体" size="9" color="#000000" bold="false" underline="false" italic="false" strikethrough="false" weight="400.0" />
  19. <c:Borders>
  20. <c:Border position="left" lineStyle="NullLine" />
  21. <c:Border position="top" lineStyle="NullLine" />
  22. <c:Border position="right" lineStyle="NullLine" />
  23. <c:Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000" />
  24. <c:Border position="diagonalleft" lineStyle="NullLine" />
  25. <c:Border position="diagonalright" lineStyle="NullLine" />
  26. </c:Borders>
  27. <c:Interior color="#ffffff" pattern="Solid" patternColor="#000000" />
  28. <c:Alignment horizontal="center" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" clip="true" />
  29. <c:Protection hidden="false" locked="false" />
  30. </c:Style>
  31. <c:Style id="2">
  32. <c:Font fontName="宋体" size="9" color="#000000" bold="false" underline="false" italic="false" strikethrough="false" weight="400.0" />
  33. <c:Borders>
  34. <c:Border position="left" lineStyle="NullLine" />
  35. <c:Border position="top" lineStyle="NullLine" />
  36. <c:Border position="right" lineStyle="NullLine" />
  37. <c:Border position="bottom" lineStyle="NullLine" />
  38. <c:Border position="diagonalleft" lineStyle="NullLine" />
  39. <c:Border position="diagonalright" lineStyle="NullLine" />
  40. </c:Borders>
  41. <c:Interior color="#ffffff" pattern="Solid" patternColor="#000000" />
  42. <c:Alignment horizontal="center" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" clip="true" />
  43. <c:Protection hidden="false" locked="false" />
  44. </c:Style>
  45. <c:Style id="1">
  46. <c:Font fontName="宋体" size="9" color="#000000" bold="false" underline="false" italic="false" strikethrough="false" weight="400.0" />
  47. <c:Borders>
  48. <c:Border position="left" lineStyle="NullLine" />
  49. <c:Border position="top" lineStyle="NullLine" />
  50. <c:Border position="right" lineStyle="NullLine" />
  51. <c:Border position="bottom" lineStyle="NullLine" />
  52. <c:Border position="diagonalleft" lineStyle="NullLine" />
  53. <c:Border position="diagonalright" lineStyle="NullLine" />
  54. </c:Borders>
  55. <c:Interior color="#ffffff00" pattern="None" patternColor="#000000" />
  56. <c:Alignment horizontal="center" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" clip="true" />
  57. <c:Protection hidden="false" locked="false" />
  58. </c:Style>
  59. <c:Style id="0">
  60. <c:Interior color="#ffffff" pattern="Solid" patternColor="#000000" />
  61. </c:Style>
  62. <c:Style id="5">
  63. <c:Font fontName="宋体" size="9" color="#000000" bold="false" underline="false" italic="false" strikethrough="false" weight="400.0" />
  64. <c:Borders>
  65. <c:Border position="left" lineStyle="Single" penStyle="Solid" color="#000000" />
  66. <c:Border position="top" lineStyle="Single" penStyle="Solid" color="#000000" />
  67. <c:Border position="right" lineStyle="Single" penStyle="Solid" color="#000000" />
  68. <c:Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000" />
  69. <c:Border position="diagonalleft" lineStyle="NullLine" />
  70. <c:Border position="diagonalright" lineStyle="NullLine" />
  71. </c:Borders>
  72. <c:Interior color="#ffffff" pattern="Solid" patternColor="#000000" />
  73. <c:Alignment horizontal="center" vertical="middle" wrapText="true" rotate="0" shrink="false" lineSpace="0.0" clip="true" />
  74. <c:Protection hidden="false" locked="false" />
  75. </c:Style>
  76. <c:Style id="4">
  77. <c:Font fontName="宋体" size="9" color="#000000" bold="false" underline="false" italic="false" strikethrough="false" weight="400.0" />
  78. <c:Borders>
  79. <c:Border position="left" lineStyle="NullLine" />
  80. <c:Border position="top" lineStyle="NullLine" />
  81. <c:Border position="right" lineStyle="NullLine" />
  82. <c:Border position="bottom" lineStyle="NullLine" />
  83. <c:Border position="diagonalleft" lineStyle="NullLine" />
  84. <c:Border position="diagonalright" lineStyle="NullLine" />
  85. </c:Borders>
  86. <c:Interior color="#ffffff" pattern="Solid" patternColor="#000000" />
  87. <c:Alignment horizontal="left" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" clip="true" />
  88. <c:Protection hidden="false" locked="false" />
  89. </c:Style>
  90. </Styles>
  91. <Headers />
  92. <Footers />
  93. <DataObjects version="1.0">
  94. <DataObject name="metas">
  95. <CommonQuery name="metas">
  96. <Outputs>
  97. <Columns>
  98. <Column name="number" alias.zh_TW="單據號" alias.zh_CN="单据号" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  99. <Column name="transactionType.name" alias.zh_TW="事務類型" alias.zh_CN="事务类型" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  100. <Column name="bizDate" alias.zh_TW="業務日期" alias.zh_CN="业务日期" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  101. <Column name="sourceBillType.name" alias.zh_TW="源單據類型" alias.zh_CN="源单据类型" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  102. <Column name="storageOrgUnit.name" alias.zh_TW="庫存組織" alias.zh_CN="库存组织" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  103. <Column name="companyOrgUnit.name" alias.zh_TW="財務組織" alias.zh_CN="财务组织" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  104. <Column name="adminOrgUnit.name" alias.zh_TW="部門" alias.zh_CN="部门" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  105. <Column name="creator.name" alias.zh_TW="制單人" alias.zh_CN="制单人" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  106. <Column name="createTime" alias.zh_TW="制單日期" alias.zh_CN="制单日期" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  107. <Column name="auditor.name" alias.zh_TW="審核人" alias.zh_CN="审核人" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  108. <Column name="auditTime" alias.zh_TW="審核日期" alias.zh_CN="审核日期" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  109. <Column name="modifier.name" alias.zh_TW="更改人" alias.zh_CN="更改人" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  110. <Column name="modificationTime" alias.zh_TW="更改日期" alias.zh_CN="更改日期" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  111. <Column name="isReversed" alias.zh_TW="沖銷" alias.zh_CN="冲销" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  112. <Column name="entry.seq" alias.zh_TW="行號" alias.zh_CN="行号" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  113. <Column name="entry.orderNumber" alias.zh_TW="訂單單號" alias.zh_CN="订单单号" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  114. <Column name="productID.number" alias.zh_TW="產品編碼" alias.zh_CN="产品编码" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  115. <Column name="productID.name" alias.zh_TW="產品名稱" alias.zh_CN="产品名称" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  116. <Column name="material.number" alias.zh_TW="物料編碼" alias.zh_CN="物料编码" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  117. <Column name="material.name" alias.zh_TW="物料名稱" alias.zh_CN="物料名称" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  118. <Column name="material.model" alias.zh_TW="規格型號" alias.zh_CN="规格型号" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  119. <Column name="assistProperty.name" alias.zh_TW="輔助屬性" alias.zh_CN="辅助属性" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  120. <Column name="entry.mfg" alias.zh_TW="生產日期" alias.zh_CN="生产日期" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  121. <Column name="entry.exp" alias.zh_TW="到期日期" alias.zh_CN="到期日期" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  122. <Column name="entry.lot" alias.zh_TW="批次" alias.zh_CN="批次" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  123. <Column name="unit.name" alias.zh_TW="計量單位" alias.zh_CN="计量单位" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  124. <Column name="entry.qty" alias.zh_TW="數量" alias.zh_CN="数量" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  125. <Column name="assistUnit.name" alias.zh_TW="輔助計量單位" alias.zh_CN="辅助计量单位" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  126. <Column name="entry.assistQty" alias.zh_TW="輔助數量" alias.zh_CN="辅助数量" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  127. <Column name="baseUnit.name" alias.zh_TW="基本計量單位" alias.zh_CN="基本计量单位" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  128. <Column name="entry.baseQty" alias.zh_TW="基本數量" alias.zh_CN="基本数量" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  129. <Column name="warehouse.name" alias.zh_TW="倉庫" alias.zh_CN="仓库" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  130. <Column name="stocker1.name" alias.zh_TW="倉管員" alias.zh_CN="仓管员" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  131. <Column name="location.name" alias.zh_TW="庫位" alias.zh_CN="库位" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  132. <Column name="entry.unitStandardCost" alias.zh_TW="單位標準成本" alias.zh_CN="单位标准成本" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  133. <Column name="entry.standardCost" alias.zh_TW="標準成本" alias.zh_CN="标准成本" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  134. <Column name="entry.unitActualCost" alias.zh_TW="單位實際成本" alias.zh_CN="单位实际成本" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  135. <Column name="entry.actualCost" alias.zh_TW="實際成本" alias.zh_CN="实际成本" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  136. <Column name="entry.reverseQty" alias.zh_TW="累計沖銷數量" alias.zh_CN="累计冲销数量" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  137. <Column name="totalStandardCost" alias.zh_TW="總標準成本" alias.zh_CN="总标准成本" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  138. <Column name="totalActualCost" alias.zh_TW="總實際成本" alias.zh_CN="总实际成本" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  139. <Column name="entry.remark" alias.zh_TW="備註" alias.zh_CN="备注" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  140. <Column name="baseStatus" alias.zh_TW="單據狀態" alias.zh_CN="单据状态" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  141. <Column name="costCenterOrgUnit.name" alias.zh_TW="成本中心" alias.zh_CN="成本中心" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" order="0" />
  142. <Column name="supplier.name" alias.zh_TW="供應商名稱" alias.zh_CN="供应商名称" alias.en="" alias="#1" dataType="string" order="0" />
  143. <Column name="entry.subWrittenOffQty" alias.zh_TW="委外已核銷數量" alias.zh_CN="委外已核销数量" alias.en="" alias="#1" dataType="string" order="0" />
  144. <Column name="entry.subWrittenOffBaseQty" alias.zh_TW="委外已核銷基本數量" alias.zh_CN="委外已核销基本数量" alias.en="" alias="#1" dataType="string" order="0" />
  145. <Column name="entry.subUnWriteOffQty" alias.zh_TW="委外未核銷數量" alias.zh_CN="委外未核销数量" alias.en="" alias="#1" dataType="string" order="0" />
  146. <Column name="entry.subUnWriteOffBaseQty" alias.zh_TW="委外未核銷基本數量" alias.zh_CN="委外未核销基本数量" alias.en="" alias="#1" dataType="string" order="0" />
  147. <Column name="processMaterial.number" alias.zh_TW="加工物料編碼" alias.zh_CN="加工物料编码" alias.en="" alias="#1" dataType="string" order="0" />
  148. <Column name="processMaterial.name" alias.zh_TW="加工物料名稱" alias.zh_CN="加工物料名称" alias.en="" alias="#1" dataType="string" order="0" />
  149. <Column name="issueAdminOrgUnit.name" alias.zh_TW="發料部門" alias.zh_CN="发料部门" alias.en="" alias="#1" dataType="string" order="0" />
  150. <Column name="issuePerson.name" alias.zh_TW="發料人員" alias.zh_CN="发料人员" alias.en="" alias="#1" dataType="string" order="0" />
  151. </Columns>
  152. </Outputs>
  153. <Query version="1.0" type="bos.query">
  154. <Columns>
  155. <Column name="number" alias.zh_TW="單據號" alias.zh_CN="单据号" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  156. <Column name="transactionType.name" alias.zh_TW="事務類型" alias.zh_CN="事务类型" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  157. <Column name="bizDate" alias.zh_TW="業務日期" alias.zh_CN="业务日期" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  158. <Column name="sourceBillType.name" alias.zh_TW="源單據類型" alias.zh_CN="源单据类型" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  159. <Column name="storageOrgUnit.name" alias.zh_TW="庫存組織" alias.zh_CN="库存组织" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  160. <Column name="companyOrgUnit.name" alias.zh_TW="財務組織" alias.zh_CN="财务组织" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  161. <Column name="adminOrgUnit.name" alias.zh_TW="部門" alias.zh_CN="部门" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  162. <Column name="creator.name" alias.zh_TW="制單人" alias.zh_CN="制单人" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  163. <Column name="createTime" alias.zh_TW="制單日期" alias.zh_CN="制单日期" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  164. <Column name="auditor.name" alias.zh_TW="審核人" alias.zh_CN="审核人" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  165. <Column name="auditTime" alias.zh_TW="審核日期" alias.zh_CN="审核日期" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  166. <Column name="modifier.name" alias.zh_TW="更改人" alias.zh_CN="更改人" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  167. <Column name="modificationTime" alias.zh_TW="更改日期" alias.zh_CN="更改日期" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  168. <Column name="isReversed" alias.zh_TW="沖銷" alias.zh_CN="冲销" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  169. <Column name="entry.seq" alias.zh_TW="行號" alias.zh_CN="行号" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  170. <Column name="entry.orderNumber" alias.zh_TW="訂單單號" alias.zh_CN="订单单号" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  171. <Column name="productID.number" alias.zh_TW="產品編碼" alias.zh_CN="产品编码" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  172. <Column name="productID.name" alias.zh_TW="產品名稱" alias.zh_CN="产品名称" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  173. <Column name="material.number" alias.zh_TW="物料編碼" alias.zh_CN="物料编码" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  174. <Column name="material.name" alias.zh_TW="物料名稱" alias.zh_CN="物料名称" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  175. <Column name="material.model" alias.zh_TW="規格型號" alias.zh_CN="规格型号" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  176. <Column name="assistProperty.name" alias.zh_TW="輔助屬性" alias.zh_CN="辅助属性" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  177. <Column name="entry.mfg" alias.zh_TW="生產日期" alias.zh_CN="生产日期" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  178. <Column name="entry.exp" alias.zh_TW="到期日期" alias.zh_CN="到期日期" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  179. <Column name="entry.lot" alias.zh_TW="批次" alias.zh_CN="批次" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  180. <Column name="unit.name" alias.zh_TW="計量單位" alias.zh_CN="计量单位" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  181. <Column name="entry.qty" alias.zh_TW="數量" alias.zh_CN="数量" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  182. <Column name="assistUnit.name" alias.zh_TW="輔助計量單位" alias.zh_CN="辅助计量单位" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  183. <Column name="entry.assistQty" alias.zh_TW="輔助數量" alias.zh_CN="辅助数量" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  184. <Column name="baseUnit.name" alias.zh_TW="基本計量單位" alias.zh_CN="基本计量单位" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  185. <Column name="entry.baseQty" alias.zh_TW="基本數量" alias.zh_CN="基本数量" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  186. <Column name="warehouse.name" alias.zh_TW="倉庫" alias.zh_CN="仓库" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  187. <Column name="stocker1.name" alias.zh_TW="倉管員" alias.zh_CN="仓管员" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  188. <Column name="location.name" alias.zh_TW="庫位" alias.zh_CN="库位" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  189. <Column name="entry.unitStandardCost" alias.zh_TW="單位標準成本" alias.zh_CN="单位标准成本" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  190. <Column name="entry.standardCost" alias.zh_TW="標準成本" alias.zh_CN="标准成本" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  191. <Column name="entry.unitActualCost" alias.zh_TW="單位實際成本" alias.zh_CN="单位实际成本" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  192. <Column name="entry.actualCost" alias.zh_TW="實際成本" alias.zh_CN="实际成本" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  193. <Column name="entry.reverseQty" alias.zh_TW="累計沖銷數量" alias.zh_CN="累计冲销数量" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  194. <Column name="totalStandardCost" alias.zh_TW="總標準成本" alias.zh_CN="总标准成本" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  195. <Column name="totalActualCost" alias.zh_TW="總實際成本" alias.zh_CN="总实际成本" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  196. <Column name="entry.remark" alias.zh_TW="備註" alias.zh_CN="备注" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  197. <Column name="baseStatus" alias.zh_TW="單據狀態" alias.zh_CN="单据状态" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  198. <Column name="costCenterOrgUnit.name" alias.zh_TW="成本中心" alias.zh_CN="成本中心" alias.en="" alias="#1" desc.zh_TW="" desc.zh_CN="" desc.en="" desc="#1" dataType="string" />
  199. <Column name="supplier.name" alias.zh_TW="供應商名稱" alias.zh_CN="供应商名称" alias.en="" alias="#1" dataType="string" />
  200. <Column name="entry.subWrittenOffQty" alias.zh_TW="委外已核銷數量" alias.zh_CN="委外已核销数量" alias.en="" alias="#1" dataType="string" />
  201. <Column name="entry.subWrittenOffBaseQty" alias.zh_TW="委外已核銷基本數量" alias.zh_CN="委外已核销基本数量" alias.en="" alias="#1" dataType="string" />
  202. <Column name="entry.subUnWriteOffQty" alias.zh_TW="委外未核銷數量" alias.zh_CN="委外未核销数量" alias.en="" alias="#1" dataType="string" />
  203. <Column name="entry.subUnWriteOffBaseQty" alias.zh_TW="委外未核銷基本數量" alias.zh_CN="委外未核销基本数量" alias.en="" alias="#1" dataType="string" />
  204. <Column name="processMaterial.number" alias.zh_TW="加工物料編碼" alias.zh_CN="加工物料编码" alias.en="" alias="#1" dataType="string" />
  205. <Column name="processMaterial.name" alias.zh_TW="加工物料名稱" alias.zh_CN="加工物料名称" alias.en="" alias="#1" dataType="string" />
  206. <Column name="issueAdminOrgUnit.name" alias.zh_TW="發料部門" alias.zh_CN="发料部门" alias.en="" alias="#1" dataType="string" />
  207. <Column name="issuePerson.name" alias.zh_TW="發料人員" alias.zh_CN="发料人员" alias.en="" alias="#1" dataType="string" />
  208. </Columns>
  209. <Tables />
  210. <Joins />
  211. <Orders />
  212. <Filter />
  213. <Content><![CDATA[MaterialReqBill.bos-query]]></Content>
  214. </Query>
  215. <EXT />
  216. </CommonQuery>
  217. </DataObject>
  218. </DataObjects>
  219. <Form id="form1" alias="MaterialReqBill_Template1" version="3.1">
  220. <f:Page id="page1" alias="页1" styleID="0" repeat="-1">
  221. <f:DesignedPage paperSize="iso-a4" objWidth="2590" objHeight="1720" widthLimitless="false" heightLimitless="false" />
  222. <f:Area id="loop1" alias="循环区1" styleID="1" left="[page1.left]" right="[page1.right]" top="[page1.top]" bottom="[page1.bottom]" nextAreaID="loop1">
  223. <f:DesignedArea leftLocationType="relative" leftRelativeObjID="page1" leftRelativeBorder="left" leftRelativeOffset="0" rightLocationType="relative" rightRelativeObjID="page1" rightRelativeBorder="right" rightRelativeOffset="0" topLocationType="relative" topRelativeObjID="page1" topRelativeBorder="top" topRelativeOffset="0" bottomLocationType="relative" bottomRelativeObjID="page1" bottomRelativeBorder="bottom" bottomRelativeOffset="0" locked="false" />
  224. <f:Panel id="group1" alias="分组容器1" styleID="2" left="[loop1.left]" right="[loop1.right]" top="[loop1.top]" bottom="[loop1.bottom]" dataSourceID="metas">
  225. <f:DesignedPanel leftLocationType="relative" leftRelativeObjID="loop1" leftRelativeBorder="left" leftRelativeOffset="0" rightLocationType="relative" rightRelativeObjID="loop1" rightRelativeBorder="right" rightRelativeOffset="0" topLocationType="relative" topRelativeObjID="loop1" topRelativeBorder="top" topRelativeOffset="0" bottomLocationType="relative" bottomRelativeObjID="loop1" bottomRelativeBorder="bottom" bottomRelativeOffset="0" locked="false" />
  226. <f:Cell id="field1" alias="字段1" styleID="2" left="[group1.left]+1130.0" right="[group1.left]+1447.0" top="[group1.top]+56.0" bottom="[group1.top]+161.0" type="field">
  227. <f:DesignedCell text="财务组织" leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="1130" rightLocationType="relative" rightRelativeObjID="group1" rightRelativeBorder="left" rightRelativeOffset="1447" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="56" bottomLocationType="relative" bottomRelativeObjID="group1" bottomRelativeBorder="top" bottomRelativeOffset="161" locked="false" />
  228. <f:Data type="string">companyOrgUnit.name</f:Data>
  229. </f:Cell>
  230. <f:Cell id="text25" alias="文本25" styleID="2" left="[group1.left]+1159.0" right="[group1.left]+1426.0" top="[group1.top]+203.0" bottom="[group1.top]+263.0" type="constant">
  231. <f:DesignedCell leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="1159" rightLocationType="relative" rightRelativeObjID="group1" rightRelativeBorder="left" rightRelativeOffset="1426" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="203" bottomLocationType="relative" bottomRelativeObjID="group1" bottomRelativeBorder="top" bottomRelativeOffset="263" locked="false" />
  232. <f:Data type="string">委外发料单</f:Data>
  233. </f:Cell>
  234. <f:Cell id="field6" alias="字段6" styleID="3" left="[group1.left]+1237.0" right="[field6.left]+317.0" top="[group1.top]+306.0" bottom="[field6.top]+82.0" type="field">
  235. <f:DesignedCell text="事务类型" leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="1237" rightLocationType="relative" rightRelativeObjID="field6" rightRelativeBorder="left" rightRelativeOffset="317" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="306" bottomLocationType="relative" bottomRelativeObjID="field6" bottomRelativeBorder="top" bottomRelativeOffset="82" locked="false" />
  236. <f:Data type="string">transactionType.name</f:Data>
  237. </f:Cell>
  238. <f:Cell id="field8" alias="字段8" styleID="3" left="[group1.left]+2123.0" right="[field8.left]+317.0" top="[group1.top]+312.0" bottom="[field8.top]+76.0" type="field">
  239. <f:DesignedCell text="业务日期" leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="2123" rightLocationType="relative" rightRelativeObjID="field8" rightRelativeBorder="left" rightRelativeOffset="317" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="312" bottomLocationType="relative" bottomRelativeObjID="field8" bottomRelativeBorder="top" bottomRelativeOffset="76" locked="false" />
  240. <f:Data type="string">bizDate</f:Data>
  241. </f:Cell>
  242. <f:Cell id="text19" alias="文本19" styleID="4" left="[group1.left]+165.0" right="[text19.left]+238.0" top="[group1.top]+324.0" bottom="[text19.top]+47.0" type="constant">
  243. <f:DesignedCell leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="165" rightLocationType="relative" rightRelativeObjID="text19" rightRelativeBorder="left" rightRelativeOffset="238" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="324" bottomLocationType="relative" bottomRelativeObjID="text19" bottomRelativeBorder="top" bottomRelativeOffset="47" locked="false" />
  244. <f:Data type="string">单据编号:</f:Data>
  245. </f:Cell>
  246. <f:Cell id="field2" alias="字段2" styleID="3" left="[group1.left]+376.0" right="[field2.left]+317.0" top="[group1.top]+324.0" bottom="[field2.top]+71.0" type="field">
  247. <f:DesignedCell text="单据号" leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="376" rightLocationType="relative" rightRelativeObjID="field2" rightRelativeBorder="left" rightRelativeOffset="317" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="324" bottomLocationType="relative" bottomRelativeObjID="field2" bottomRelativeBorder="top" bottomRelativeOffset="71" locked="false" />
  248. <f:Data type="string">number</f:Data>
  249. </f:Cell>
  250. <f:Cell id="text21" alias="文本21" styleID="4" left="[group1.left]+1008.0" right="[text21.left]+238.0" top="[group1.top]+324.0" bottom="[text21.top]+47.0" type="constant">
  251. <f:DesignedCell leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="1008" rightLocationType="relative" rightRelativeObjID="text21" rightRelativeBorder="left" rightRelativeOffset="238" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="324" bottomLocationType="relative" bottomRelativeObjID="text21" bottomRelativeBorder="top" bottomRelativeOffset="47" locked="false" />
  252. <f:Data type="string">事务类型:</f:Data>
  253. </f:Cell>
  254. <f:Cell id="text23" alias="文本23" styleID="4" left="[group1.left]+1900.0" right="[text23.left]+238.0" top="[group1.top]+324.0" bottom="[text23.top]+47.0" type="constant">
  255. <f:DesignedCell leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="1900" rightLocationType="relative" rightRelativeObjID="text23" rightRelativeBorder="left" rightRelativeOffset="238" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="324" bottomLocationType="relative" bottomRelativeObjID="text23" bottomRelativeBorder="top" bottomRelativeOffset="47" locked="false" />
  256. <f:Data type="string">业务日期:</f:Data>
  257. </f:Cell>
  258. <f:Cell id="field7" alias="字段7" styleID="3" left="[group1.left]+1237.0" right="[field7.left]+317.0" top="[group1.top]+399.0" bottom="[field7.top]+82.0" type="field">
  259. <f:DesignedCell text="部门" leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="1237" rightLocationType="relative" rightRelativeObjID="field7" rightRelativeBorder="left" rightRelativeOffset="317" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="399" bottomLocationType="relative" bottomRelativeObjID="field7" bottomRelativeBorder="top" bottomRelativeOffset="82" locked="false" />
  260. <f:Data type="string">adminOrgUnit.name</f:Data>
  261. </f:Cell>
  262. <f:Cell id="text20" alias="文本20" styleID="4" left="[group1.left]+162.0" right="[text20.left]+238.0" top="[group1.top]+421.0" bottom="[text20.top]+47.0" type="constant">
  263. <f:DesignedCell leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="162" rightLocationType="relative" rightRelativeObjID="text20" rightRelativeBorder="left" rightRelativeOffset="238" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="421" bottomLocationType="relative" bottomRelativeObjID="text20" bottomRelativeBorder="top" bottomRelativeOffset="47" locked="false" />
  264. <f:Data type="string">库存组织:</f:Data>
  265. </f:Cell>
  266. <f:Cell id="text22" alias="文本22" styleID="4" left="[group1.left]+1007.0" right="[text22.left]+238.0" top="[group1.top]+421.0" bottom="[text22.top]+47.0" type="constant">
  267. <f:DesignedCell leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="1007" rightLocationType="relative" rightRelativeObjID="text22" rightRelativeBorder="left" rightRelativeOffset="238" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="421" bottomLocationType="relative" bottomRelativeObjID="text22" bottomRelativeBorder="top" bottomRelativeOffset="47" locked="false" />
  268. <f:Data type="string">部门:</f:Data>
  269. </f:Cell>
  270. <f:Cell id="field15" alias="字段15" styleID="3" left="[group1.left]+2122.0" right="[field15.left]+318.0" top="[group1.top]+421.0" bottom="[field15.top]+56.0" postMacro="$SETOUTPUTVALUE(&quot;text&quot;,$IFF($GETOUTPUTVALUE(&quot;value&quot;)==&quot;true&quot;,&quot;是&quot;,&quot;否&quot;)) " type="field">
  271. <f:DesignedCell text="冲销" leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="2122" rightLocationType="relative" rightRelativeObjID="field15" rightRelativeBorder="left" rightRelativeOffset="318" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="421" bottomLocationType="relative" bottomRelativeObjID="field15" bottomRelativeBorder="top" bottomRelativeOffset="56" locked="false" />
  272. <f:Data type="string">isReversed</f:Data>
  273. </f:Cell>
  274. <f:Cell id="text18" alias="文本18" styleID="2" left="[group1.left]+1900.0" right="[text18.left]+170.0" top="[group1.top]+422.0" bottom="[text18.top]+56.0" type="constant">
  275. <f:DesignedCell leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="1900" rightLocationType="relative" rightRelativeObjID="text18" rightRelativeBorder="left" rightRelativeOffset="170" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="422" bottomLocationType="relative" bottomRelativeObjID="text18" bottomRelativeBorder="top" bottomRelativeOffset="56" locked="false" />
  276. <f:Data type="string">冲销:</f:Data>
  277. </f:Cell>
  278. <f:Cell id="field3" alias="字段3" styleID="3" left="[group1.left]+376.0" right="[field3.left]+317.0" top="[group1.top]+432.0" bottom="[field3.top]+71.0" type="field">
  279. <f:DesignedCell text="库存组织" leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="376" rightLocationType="relative" rightRelativeObjID="field3" rightRelativeBorder="left" rightRelativeOffset="317" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="432" bottomLocationType="relative" bottomRelativeObjID="field3" bottomRelativeBorder="top" bottomRelativeOffset="71" locked="false" />
  280. <f:Data type="string">storageOrgUnit.name</f:Data>
  281. </f:Cell>
  282. <f:Table id="table1" alias="网格容器1" left="[group1.left]+199.0" right="[group1.right]-139.0" top="[group1.top]+551.0" bottom="[group1.top]+631.0">
  283. <f:DesignedTable layout="auto" leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="199" rightLocationType="relative" rightRelativeObjID="group1" rightRelativeBorder="right" rightRelativeOffset="-139" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="551" bottomLocationType="relative" bottomRelativeObjID="group1" bottomRelativeBorder="top" bottomRelativeOffset="631" locked="false" />
  284. <f:Rows>
  285. <f:Row />
  286. </f:Rows>
  287. <f:Columns>
  288. <f:Column />
  289. <f:Column />
  290. <f:Column />
  291. <f:Column />
  292. <f:Column />
  293. <f:Column />
  294. <f:Column />
  295. <f:Column />
  296. <f:Column />
  297. <f:Column />
  298. <f:Column />
  299. <f:Column />
  300. <f:Column />
  301. <f:Column />
  302. <f:Column />
  303. <f:Column />
  304. <f:Column />
  305. </f:Columns>
  306. <f:Body>
  307. <f:Cell id="text2" alias="文本2" styleID="5" left="1" right="1" top="1" bottom="1" type="constant">
  308. <f:DesignedCell locked="false" />
  309. <f:Data type="string">序号</f:Data>
  310. </f:Cell>
  311. <f:Cell id="text3" alias="文本3" styleID="5" left="2" right="2" top="1" bottom="1" type="constant">
  312. <f:DesignedCell locked="false" />
  313. <f:Data type="string">物料编码</f:Data>
  314. </f:Cell>
  315. <f:Cell id="text4" alias="文本4" styleID="5" left="3" right="3" top="1" bottom="1" type="constant">
  316. <f:DesignedCell locked="false" />
  317. <f:Data type="string">物料名称</f:Data>
  318. </f:Cell>
  319. <f:Cell id="text5" alias="文本5" styleID="5" left="4" right="4" top="1" bottom="1" type="constant">
  320. <f:DesignedCell locked="false" />
  321. <f:Data type="string">规格型号</f:Data>
  322. </f:Cell>
  323. <f:Cell id="text6" alias="文本6" styleID="5" left="5" right="5" top="1" bottom="1" type="constant">
  324. <f:DesignedCell locked="false" />
  325. <f:Data type="string">辅助属性</f:Data>
  326. </f:Cell>
  327. <f:Cell id="text7" alias="文本7" styleID="5" left="6" right="6" top="1" bottom="1" type="constant">
  328. <f:DesignedCell locked="false" />
  329. <f:Data type="string">批次</f:Data>
  330. </f:Cell>
  331. <f:Cell id="text8" alias="文本8" styleID="5" left="7" right="7" top="1" bottom="1" type="constant">
  332. <f:DesignedCell locked="false" />
  333. <f:Data type="string">计量单位</f:Data>
  334. </f:Cell>
  335. <f:Cell id="text9" alias="文本9" styleID="5" left="8" right="8" top="1" bottom="1" type="constant">
  336. <f:DesignedCell locked="false" />
  337. <f:Data type="string">数量</f:Data>
  338. </f:Cell>
  339. <f:Cell id="text10" alias="文本10" styleID="5" left="9" right="9" top="1" bottom="1" type="constant">
  340. <f:DesignedCell locked="false" />
  341. <f:Data type="string">辅助计量单位</f:Data>
  342. </f:Cell>
  343. <f:Cell id="text11" alias="文本11" styleID="5" left="10" right="10" top="1" bottom="1" type="constant">
  344. <f:DesignedCell locked="false" />
  345. <f:Data type="string">辅助数量</f:Data>
  346. </f:Cell>
  347. <f:Cell id="text12" alias="文本12" styleID="5" left="11" right="11" top="1" bottom="1" type="constant">
  348. <f:DesignedCell locked="false" />
  349. <f:Data type="string">仓库</f:Data>
  350. </f:Cell>
  351. <f:Cell id="text13" alias="文本13" styleID="5" left="12" right="12" top="1" bottom="1" type="constant">
  352. <f:DesignedCell locked="false" />
  353. <f:Data type="string">仓管员</f:Data>
  354. </f:Cell>
  355. <f:Cell id="text14" alias="文本14" styleID="5" left="13" right="13" top="1" bottom="1" type="constant">
  356. <f:DesignedCell locked="false" />
  357. <f:Data type="string">库位</f:Data>
  358. </f:Cell>
  359. <f:Cell id="text15" alias="文本15" styleID="5" left="14" right="14" top="1" bottom="1" type="constant">
  360. <f:DesignedCell locked="false" />
  361. <f:Data type="string">生产订单单号</f:Data>
  362. </f:Cell>
  363. <f:Cell id="text47" alias="文本47" styleID="5" left="15" right="15" top="1" bottom="1" type="constant">
  364. <f:DesignedCell locked="false" />
  365. <f:Data type="string">产品编码</f:Data>
  366. </f:Cell>
  367. <f:Cell id="text16" alias="文本16" styleID="5" left="16" right="16" top="1" bottom="1" type="constant">
  368. <f:DesignedCell locked="false" />
  369. <f:Data type="string">产品名称</f:Data>
  370. </f:Cell>
  371. <f:Cell id="text17" alias="文本17" styleID="5" left="17" right="17" top="1" bottom="1" type="constant">
  372. <f:DesignedCell locked="false" />
  373. <f:Data type="string">备注</f:Data>
  374. </f:Cell>
  375. </f:Body>
  376. </f:Table>
  377. <f:Area id="loop3" alias="循环区3" styleID="1" left="[group1.left]+199.0" right="[group1.right]-134.0" top="[group1.top]+630.0" bottom="[group1.bottom]-563.0" nextAreaID="loop3">
  378. <f:DesignedArea leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="199" rightLocationType="relative" rightRelativeObjID="group1" rightRelativeBorder="right" rightRelativeOffset="-134" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="630" bottomLocationType="relative" bottomRelativeObjID="group1" bottomRelativeBorder="bottom" bottomRelativeOffset="-563" locked="false" />
  379. <f:Table id="table3" alias="网格容器3" left="[loop3.left]" right="[loop3.right]-2.0" top="[loop3.top]" bottom="[loop3.top]+67.0" dataSourceID="metas" groupField="number">
  380. <f:DesignedTable layout="auto" leftLocationType="relative" leftRelativeObjID="loop3" leftRelativeBorder="left" leftRelativeOffset="0" rightLocationType="relative" rightRelativeObjID="loop3" rightRelativeBorder="right" rightRelativeOffset="-2" topLocationType="relative" topRelativeObjID="loop3" topRelativeBorder="top" topRelativeOffset="0" bottomLocationType="relative" bottomRelativeObjID="loop3" bottomRelativeBorder="top" bottomRelativeOffset="67" locked="false" />
  381. <f:Rows>
  382. <f:Row />
  383. </f:Rows>
  384. <f:Columns>
  385. <f:Column />
  386. <f:Column />
  387. <f:Column />
  388. <f:Column />
  389. <f:Column />
  390. <f:Column />
  391. <f:Column />
  392. <f:Column />
  393. <f:Column />
  394. <f:Column />
  395. <f:Column />
  396. <f:Column />
  397. <f:Column />
  398. <f:Column />
  399. <f:Column />
  400. <f:Column />
  401. <f:Column />
  402. </f:Columns>
  403. <f:Body>
  404. <f:Cell id="field4" alias="字段4" styleID="5" left="1" right="1" top="1" bottom="1" type="field">
  405. <f:DesignedCell text="行号" locked="false" />
  406. <f:Data type="string">entry.seq</f:Data>
  407. </f:Cell>
  408. <f:Cell id="field5" alias="字段5" styleID="5" left="2" right="2" top="1" bottom="1" type="field">
  409. <f:DesignedCell text="物料编码" locked="false" />
  410. <f:Data type="string">material.number</f:Data>
  411. </f:Cell>
  412. <f:Cell id="field9" alias="字段9" styleID="5" left="3" right="3" top="1" bottom="1" type="field">
  413. <f:DesignedCell text="物料名称" locked="false" />
  414. <f:Data type="string">material.name</f:Data>
  415. </f:Cell>
  416. <f:Cell id="field10" alias="字段10" styleID="5" left="4" right="4" top="1" bottom="1" type="field">
  417. <f:DesignedCell text="规格型号" locked="false" />
  418. <f:Data type="string">material.model</f:Data>
  419. </f:Cell>
  420. <f:Cell id="field11" alias="字段11" styleID="5" left="5" right="5" top="1" bottom="1" type="field">
  421. <f:DesignedCell text="辅助属性" locked="false" />
  422. <f:Data type="string">assistProperty.name</f:Data>
  423. </f:Cell>
  424. <f:Cell id="field12" alias="字段12" styleID="5" left="6" right="6" top="1" bottom="1" priority="1" type="field">
  425. <f:DesignedCell text="批次" locked="false" />
  426. <f:Data type="string">entry.lot</f:Data>
  427. </f:Cell>
  428. <f:Cell id="field13" alias="字段13" styleID="5" left="7" right="7" top="1" bottom="1" type="field">
  429. <f:DesignedCell text="计量单位" locked="false" />
  430. <f:Data type="string">unit.name</f:Data>
  431. </f:Cell>
  432. <f:Cell id="field14" alias="字段14" styleID="5" left="8" right="8" top="1" bottom="1" type="field">
  433. <f:DesignedCell text="数量" locked="false" />
  434. <f:Data type="string">entry.qty</f:Data>
  435. </f:Cell>
  436. <f:Cell id="field16" alias="字段16" styleID="5" left="9" right="9" top="1" bottom="1" type="field">
  437. <f:DesignedCell text="辅助计量单位" locked="false" />
  438. <f:Data type="string">assistUnit.name</f:Data>
  439. </f:Cell>
  440. <f:Cell id="field17" alias="字段17" styleID="5" left="10" right="10" top="1" bottom="1" type="field">
  441. <f:DesignedCell text="辅助数量" locked="false" />
  442. <f:Data type="string">entry.assistQty</f:Data>
  443. </f:Cell>
  444. <f:Cell id="field21" alias="字段21" styleID="5" left="11" right="11" top="1" bottom="1" type="field">
  445. <f:DesignedCell text="仓库" locked="false" />
  446. <f:Data type="string">warehouse.name</f:Data>
  447. </f:Cell>
  448. <f:Cell id="field22" alias="字段22" styleID="5" left="12" right="12" top="1" bottom="1" type="field">
  449. <f:DesignedCell text="仓管员" locked="false" />
  450. <f:Data type="string">stocker1.name</f:Data>
  451. </f:Cell>
  452. <f:Cell id="field23" alias="字段23" styleID="5" left="13" right="13" top="1" bottom="1" type="field">
  453. <f:DesignedCell text="库位" locked="false" />
  454. <f:Data type="string">location.name</f:Data>
  455. </f:Cell>
  456. <f:Cell id="field24" alias="字段24" styleID="5" left="14" right="14" top="1" bottom="1" type="field">
  457. <f:DesignedCell text="订单单号" locked="false" />
  458. <f:Data type="string">entry.orderNumber</f:Data>
  459. </f:Cell>
  460. <f:Cell id="field20" alias="字段20" styleID="5" left="15" right="15" top="1" bottom="1" type="field">
  461. <f:DesignedCell text="产品编码" locked="false" />
  462. <f:Data type="string">productID.number</f:Data>
  463. </f:Cell>
  464. <f:Cell id="field18" alias="字段18" styleID="5" left="16" right="16" top="1" bottom="1" type="field">
  465. <f:DesignedCell text="产品名称" locked="false" />
  466. <f:Data type="string">productID.name</f:Data>
  467. </f:Cell>
  468. <f:Cell id="field19" alias="字段19" styleID="5" left="17" right="17" top="1" bottom="1" type="field">
  469. <f:DesignedCell text="备注" locked="false" />
  470. <f:Data type="string">entry.remark</f:Data>
  471. </f:Cell>
  472. </f:Body>
  473. </f:Table>
  474. </f:Area>
  475. <f:Cell id="field32" alias="字段32" styleID="3" left="[group1.left]+2123.0" right="[field32.left]+317.0" top="[group1.top]+1391.0" bottom="[field32.top]+76.0" priority="2" type="field">
  476. <f:DesignedCell text="制单人" leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="2123" rightLocationType="relative" rightRelativeObjID="field32" rightRelativeBorder="left" rightRelativeOffset="317" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="1391" bottomLocationType="relative" bottomRelativeObjID="field32" bottomRelativeBorder="top" bottomRelativeOffset="76" locked="false" />
  477. <f:Data type="string">creator.name</f:Data>
  478. </f:Cell>
  479. <f:Cell id="field30" alias="字段30" styleID="3" left="[group1.left]+1237.0" right="[field30.left]+317.0" top="[group1.top]+1397.0" bottom="[field30.top]+82.0" priority="2" type="field">
  480. <f:DesignedCell text="更改人" leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="1237" rightLocationType="relative" rightRelativeObjID="field30" rightRelativeBorder="left" rightRelativeOffset="317" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="1397" bottomLocationType="relative" bottomRelativeObjID="field30" bottomRelativeBorder="top" bottomRelativeOffset="82" locked="false" />
  481. <f:Data type="string">modifier.name</f:Data>
  482. </f:Cell>
  483. <f:Cell id="field28" alias="字段28" styleID="3" left="[group1.left]+376.0" right="[field28.left]+317.0" top="[group1.top]+1406.0" bottom="[field28.top]+71.0" priority="2" type="field">
  484. <f:DesignedCell text="审核人" leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="376" rightLocationType="relative" rightRelativeObjID="field28" rightRelativeBorder="left" rightRelativeOffset="317" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="1406" bottomLocationType="relative" bottomRelativeObjID="field28" bottomRelativeBorder="top" bottomRelativeOffset="71" locked="false" />
  485. <f:Data type="string">auditor.name</f:Data>
  486. </f:Cell>
  487. <f:Cell id="text28" alias="文本28" styleID="4" left="[group1.left]+1943.0" right="[text28.left]+238.0" top="[group1.top]+1422.0" bottom="[text28.top]+47.0" priority="2" type="constant">
  488. <f:DesignedCell leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="1943" rightLocationType="relative" rightRelativeObjID="text28" rightRelativeBorder="left" rightRelativeOffset="238" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="1422" bottomLocationType="relative" bottomRelativeObjID="text28" bottomRelativeBorder="top" bottomRelativeOffset="47" locked="false" />
  489. <f:Data type="string">制单人:</f:Data>
  490. </f:Cell>
  491. <f:Cell id="text24" alias="文本24" styleID="4" left="[group1.left]+1033.0" right="[text24.left]+238.0" top="[group1.top]+1423.0" bottom="[text24.top]+47.0" priority="2" type="constant">
  492. <f:DesignedCell leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="1033" rightLocationType="relative" rightRelativeObjID="text24" rightRelativeBorder="left" rightRelativeOffset="238" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="1423" bottomLocationType="relative" bottomRelativeObjID="text24" bottomRelativeBorder="top" bottomRelativeOffset="47" locked="false" />
  493. <f:Data type="string">修改人:</f:Data>
  494. </f:Cell>
  495. <f:Cell id="text1" alias="文本1" styleID="4" left="[group1.left]+143.0" right="[text1.left]+238.0" top="[group1.top]+1428.0" bottom="[text1.top]+47.0" priority="2" type="constant">
  496. <f:DesignedCell leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="143" rightLocationType="relative" rightRelativeObjID="text1" rightRelativeBorder="left" rightRelativeOffset="238" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="1428" bottomLocationType="relative" bottomRelativeObjID="text1" bottomRelativeBorder="top" bottomRelativeOffset="47" locked="false" />
  497. <f:Data type="string">审核人:</f:Data>
  498. </f:Cell>
  499. <f:Cell id="field33" alias="字段33" styleID="3" left="[group1.left]+2123.0" right="[field33.left]+317.0" top="[group1.top]+1473.0" bottom="[field33.top]+76.0" priority="2" type="field" format="yyyy-m-d">
  500. <f:DesignedCell text="制单日期" leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="2123" rightLocationType="relative" rightRelativeObjID="field33" rightRelativeBorder="left" rightRelativeOffset="317" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="1473" bottomLocationType="relative" bottomRelativeObjID="field33" bottomRelativeBorder="top" bottomRelativeOffset="76" locked="false" />
  501. <f:Data type="string">createTime</f:Data>
  502. </f:Cell>
  503. <f:Cell id="field29" alias="字段29" styleID="3" left="[group1.left]+376.0" right="[field29.left]+317.0" top="[group1.top]+1488.0" bottom="[field29.top]+71.0" priority="2" type="field" format="yyyy-m-d">
  504. <f:DesignedCell text="审核日期" leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="376" rightLocationType="relative" rightRelativeObjID="field29" rightRelativeBorder="left" rightRelativeOffset="317" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="1488" bottomLocationType="relative" bottomRelativeObjID="field29" bottomRelativeBorder="top" bottomRelativeOffset="71" locked="false" />
  505. <f:Data type="string">auditTime</f:Data>
  506. </f:Cell>
  507. <f:Cell id="text27" alias="文本27" styleID="4" left="[group1.left]+1037.0" right="[text27.left]+238.0" top="[group1.top]+1504.0" bottom="[text27.top]+47.0" priority="2" type="constant">
  508. <f:DesignedCell leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="1037" rightLocationType="relative" rightRelativeObjID="text27" rightRelativeBorder="left" rightRelativeOffset="238" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="1504" bottomLocationType="relative" bottomRelativeObjID="text27" bottomRelativeBorder="top" bottomRelativeOffset="47" locked="false" />
  509. <f:Data type="string">修改日期:</f:Data>
  510. </f:Cell>
  511. <f:Cell id="text29" alias="文本29" styleID="4" left="[group1.left]+1952.0" right="[text29.left]+238.0" top="[group1.top]+1504.0" bottom="[text29.top]+47.0" priority="2" type="constant">
  512. <f:DesignedCell leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="1952" rightLocationType="relative" rightRelativeObjID="text29" rightRelativeBorder="left" rightRelativeOffset="238" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="1504" bottomLocationType="relative" bottomRelativeObjID="text29" bottomRelativeBorder="top" bottomRelativeOffset="47" locked="false" />
  513. <f:Data type="string">制单日期:</f:Data>
  514. </f:Cell>
  515. <f:Cell id="field31" alias="字段31" styleID="3" left="[group1.left]+1237.0" right="[field31.left]+317.0" top="[group1.top]+1505.0" bottom="[field31.top]+56.0" priority="2" type="field" format="yyyy-m-d">
  516. <f:DesignedCell text="更改日期" leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="1237" rightLocationType="relative" rightRelativeObjID="field31" rightRelativeBorder="left" rightRelativeOffset="317" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="1505" bottomLocationType="relative" bottomRelativeObjID="field31" bottomRelativeBorder="top" bottomRelativeOffset="56" locked="false" />
  517. <f:Data type="string">modificationTime</f:Data>
  518. </f:Cell>
  519. <f:Cell id="text26" alias="文本26" styleID="4" left="[group1.left]+141.0" right="[text26.left]+238.0" top="[group1.top]+1509.0" bottom="[text26.top]+47.0" priority="2" type="constant">
  520. <f:DesignedCell leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="141" rightLocationType="relative" rightRelativeObjID="text26" rightRelativeBorder="left" rightRelativeOffset="238" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="1509" bottomLocationType="relative" bottomRelativeObjID="text26" bottomRelativeBorder="top" bottomRelativeOffset="47" locked="false" />
  521. <f:Data type="string">审核日期:</f:Data>
  522. </f:Cell>
  523. </f:Panel>
  524. </f:Area>
  525. </f:Page>
  526. </Form>
  527. <PrintInfo>
  528. <c:PageSetup>
  529. <c:PageMargin left="190" right="190" top="190" bottom="190" header="80" footer="80" />
  530. <c:Orientation>LANDSCAPE</c:Orientation>
  531. <c:PaperSizeName>iso-a4</c:PaperSizeName>
  532. <c:Header height="80" margin="80" />
  533. <c:Footer height="80" margin="80" />
  534. </c:PageSetup>
  535. <c:PrinterSetup />
  536. </PrintInfo>
  537. </DocRoot>