ArCAStmt.kdrs-form 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266
  1. <?xml version="1.0"?>
  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="3.1">
  3. <DocInfo>
  4. <c:Created>Mon Dec 26 17:19:39 CST 2005</c:Created>
  5. <c:Company>kingdee.com</c:Company>
  6. <c:LastModified>Sat Dec 31 12:34:28 CST 2005</c:LastModified>
  7. <c:Author>null</c:Author>
  8. </DocInfo>
  9. <DataSources>
  10. <c:DataSource id="ArCAStmtDS">
  11. <c:BosQueryDataSource type="query">
  12. <c:QueryXmlSource name="who" package="packAlong" />
  13. <c:Params />
  14. </c:BosQueryDataSource>
  15. <c:DesignedDataSource id="ArCAStmtDS" name="ArCAStmtDS" queryType="0" objectClass="KDQuery" isLinked="true" isSelfDefine="false">
  16. <c:Columns>
  17. <c:Column id="queryColumn22" name="序号" fieldID="FSeq" type="STRING">
  18. <c:Formula>[往来对帐单].[序号]</c:Formula>
  19. <c:Formula4Sql>[往来对帐单].[FSeq]</c:Formula4Sql>
  20. </c:Column>
  21. <c:Column id="queryColumn23" name="往来户类型" fieldID="FCussType" type="STRING">
  22. <c:Formula>[往来对帐单].[往来户类型]</c:Formula>
  23. <c:Formula4Sql>[往来对帐单].[FCussType]</c:Formula4Sql>
  24. </c:Column>
  25. <c:Column id="queryColumn24" name="往来户代码" fieldID="FCussNum" type="STRING">
  26. <c:Formula>[往来对帐单].[往来户代码]</c:Formula>
  27. <c:Formula4Sql>[往来对帐单].[FCussNum]</c:Formula4Sql>
  28. </c:Column>
  29. <c:Column id="queryColumn25" name="往来户名称" fieldID="FCussName" type="STRING">
  30. <c:Formula>[往来对帐单].[往来户名称]</c:Formula>
  31. <c:Formula4Sql>[往来对帐单].[FCussName]</c:Formula4Sql>
  32. </c:Column>
  33. <c:Column id="queryColumn26" name="币别" fieldID="FCurrency" type="STRING">
  34. <c:Formula>[往来对帐单].[币别]</c:Formula>
  35. <c:Formula4Sql>[往来对帐单].[FCurrency]</c:Formula4Sql>
  36. </c:Column>
  37. <c:Column id="queryColumn27" name="期初余额(应付为负数)" fieldID="FStartBalanceAmt" type="STRING">
  38. <c:Formula>[往来对帐单].[期初余额(应付为负数)]</c:Formula>
  39. <c:Formula4Sql>[往来对帐单].[FStartBalanceAmt]</c:Formula4Sql>
  40. </c:Column>
  41. <c:Column id="queryColumn28" name="本期应收/已付" fieldID="FDebitAmt" type="STRING">
  42. <c:Formula>[往来对帐单].[本期应收/已付]</c:Formula>
  43. <c:Formula4Sql>[往来对帐单].[FDebitAmt]</c:Formula4Sql>
  44. </c:Column>
  45. <c:Column id="queryColumn29" name="本期应付/已收" fieldID="FCreditAmt" type="STRING">
  46. <c:Formula>[往来对帐单].[本期应付/已收]</c:Formula>
  47. <c:Formula4Sql>[往来对帐单].[FCreditAmt]</c:Formula4Sql>
  48. </c:Column>
  49. <c:Column id="queryColumn30" name="期末余额(应付为负数)" fieldID="FBalanceAmt" type="STRING">
  50. <c:Formula>[往来对帐单].[期末余额(应付为负数)]</c:Formula>
  51. <c:Formula4Sql>[往来对帐单].[FBalanceAmt]</c:Formula4Sql>
  52. </c:Column>
  53. </c:Columns>
  54. <c:SubQuerys>
  55. <c:SubQuery id="queryTable21" name="往来对帐单" subQueryID="EASPrintDataSource/ArApCAStmtRpt" />
  56. </c:SubQuerys>
  57. </c:DesignedDataSource>
  58. </c:DataSource>
  59. </DataSources>
  60. <Schemes />
  61. <Styles version="1.0">
  62. <c:Style id="3">
  63. <c:Font fontName="宋体" size="12" color="#000000" bold="true" underline="false" italic="false" strikethrough="false" weight="400.0" />
  64. <c:Borders>
  65. <c:Border position="left" lineStyle="NullLine" />
  66. <c:Border position="top" lineStyle="NullLine" />
  67. <c:Border position="right" lineStyle="NullLine" />
  68. <c:Border position="bottom" lineStyle="NullLine" />
  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="false" rotate="0" shrink="false" lineSpace="0.0" clip="true" />
  74. <c:Protection hidden="false" locked="false" />
  75. </c:Style>
  76. <c:Style id="5">
  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="Single" penStyle="Solid" color="#000000" />
  80. <c:Border position="top" lineStyle="Single" penStyle="Solid" color="#000000" />
  81. <c:Border position="right" lineStyle="Single" penStyle="Solid" color="#000000" />
  82. <c:Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000" />
  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="right" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" clip="true" />
  88. <c:Protection hidden="false" locked="false" />
  89. </c:Style>
  90. <c:Style id="2">
  91. <c:Font fontName="宋体" size="9" color="#000000" bold="false" underline="false" italic="false" strikethrough="false" weight="400.0" />
  92. <c:Borders>
  93. <c:Border position="left" lineStyle="NullLine" />
  94. <c:Border position="top" lineStyle="NullLine" />
  95. <c:Border position="right" lineStyle="NullLine" />
  96. <c:Border position="bottom" lineStyle="NullLine" />
  97. <c:Border position="diagonalleft" lineStyle="NullLine" />
  98. <c:Border position="diagonalright" lineStyle="NullLine" />
  99. </c:Borders>
  100. <c:Interior color="#ffffff" pattern="Solid" patternColor="#000000" />
  101. <c:Alignment horizontal="center" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" clip="true" />
  102. <c:Protection hidden="false" locked="false" />
  103. </c:Style>
  104. <c:Style id="0">
  105. <c:Interior color="#ffffff" pattern="Solid" patternColor="#000000" />
  106. </c:Style>
  107. <c:Style id="4">
  108. <c:Font color="#000000" />
  109. <c:Borders>
  110. <c:Border position="left" lineStyle="Single" penStyle="Solid" color="#000000" />
  111. <c:Border position="top" lineStyle="Single" penStyle="Solid" color="#000000" />
  112. <c:Border position="right" lineStyle="Single" penStyle="Solid" color="#000000" />
  113. <c:Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000" />
  114. </c:Borders>
  115. <c:Interior color="#ffffff" pattern="Solid" patternColor="#000000" />
  116. </c:Style>
  117. <c:Style id="1">
  118. <c:Font fontName="宋体" size="9" color="#000000" bold="false" underline="false" italic="false" strikethrough="false" weight="400.0" />
  119. <c:Borders>
  120. <c:Border position="left" lineStyle="NullLine" />
  121. <c:Border position="top" lineStyle="NullLine" />
  122. <c:Border position="right" lineStyle="NullLine" />
  123. <c:Border position="bottom" lineStyle="NullLine" />
  124. <c:Border position="diagonalleft" lineStyle="NullLine" />
  125. <c:Border position="diagonalright" lineStyle="NullLine" />
  126. </c:Borders>
  127. <c:Interior color="#ffffff00" pattern="None" patternColor="#000000" />
  128. <c:Alignment horizontal="center" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" clip="true" />
  129. <c:Protection hidden="false" locked="false" />
  130. </c:Style>
  131. </Styles>
  132. <Headers />
  133. <Footers />
  134. <Form id="form1" alias="ArCAStmt" version="3.1">
  135. <f:Page id="page1" alias="页1" styleID="0" repeat="-1" dataSourceID="ArCAStmtDS">
  136. <f:DesignedPage paperSize="iso-a4" objWidth="2650" objHeight="1840" widthLimitless="false" heightLimitless="false" />
  137. <f:Area id="loop1" alias="循环区1" styleID="1" left="[page1.left]" right="[page1.right]-10.0" top="[page1.top]+10.0" bottom="[page1.bottom]-10.0">
  138. <f:DesignedArea leftLocationType="relative" leftRelativeObjID="page1" leftRelativeBorder="left" leftRelativeOffset="0" rightLocationType="relative" rightRelativeObjID="page1" rightRelativeBorder="right" rightRelativeOffset="-10" topLocationType="relative" topRelativeObjID="page1" topRelativeBorder="top" topRelativeOffset="10" bottomLocationType="relative" bottomRelativeObjID="page1" bottomRelativeBorder="bottom" bottomRelativeOffset="-10" locked="false" />
  139. <f:Panel id="group1" alias="分组容器1" styleID="2" left="[loop1.left]" right="[loop1.right]-10.0" top="[loop1.top]" bottom="[loop1.bottom]" dataSourceID="ArCAStmtDS">
  140. <f:DesignedPanel leftLocationType="relative" leftRelativeObjID="loop1" leftRelativeBorder="left" leftRelativeOffset="0" rightLocationType="relative" rightRelativeObjID="loop1" rightRelativeBorder="right" rightRelativeOffset="-10" topLocationType="relative" topRelativeObjID="loop1" topRelativeBorder="top" topRelativeOffset="0" bottomLocationType="relative" bottomRelativeObjID="loop1" bottomRelativeBorder="bottom" bottomRelativeOffset="0" locked="false" />
  141. <f:Cell id="text1" alias="文本1" styleID="3" left="[group1.left]+930.0" right="[group1.left]+1479.0" top="[group1.top]+34.0" bottom="[group1.top]+87.0" type="constant">
  142. <f:DesignedCell leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="930" rightLocationType="relative" rightRelativeObjID="group1" rightRelativeBorder="left" rightRelativeOffset="1479" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="34" bottomLocationType="relative" bottomRelativeObjID="group1" bottomRelativeBorder="top" bottomRelativeOffset="87" locked="false" />
  143. <f:Data type="string">往来对帐单</f:Data>
  144. </f:Cell>
  145. <f:Panel id="group2" alias="分组容器2" styleID="2" left="[group1.left]" right="[group1.right]-50.0" top="[group1.top]+150.0" bottom="[group1.bottom]-10.0">
  146. <f:DesignedPanel leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="0" rightLocationType="relative" rightRelativeObjID="group1" rightRelativeBorder="right" rightRelativeOffset="-50" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="150" bottomLocationType="relative" bottomRelativeObjID="group1" bottomRelativeBorder="bottom" bottomRelativeOffset="-10" locked="false" />
  147. <f:Table id="table3" alias="网格容器3" left="[group2.left]" right="[group2.right]-5.0" top="[group2.top]" bottom="[group2.top]+70.0" layout="1">
  148. <f:DesignedTable layout="heightAuto" leftLocationType="relative" leftRelativeObjID="group2" leftRelativeBorder="left" leftRelativeOffset="0" rightLocationType="relative" rightRelativeObjID="group2" rightRelativeBorder="right" rightRelativeOffset="-5" topLocationType="relative" topRelativeObjID="group2" topRelativeBorder="top" topRelativeOffset="0" bottomLocationType="relative" bottomRelativeObjID="group2" bottomRelativeBorder="top" bottomRelativeOffset="70" locked="false" />
  149. <f:Rows>
  150. <f:Row height="*" />
  151. </f:Rows>
  152. <f:Columns>
  153. <f:Column width="280" />
  154. <f:Column width="314" />
  155. <f:Column width="314" />
  156. <f:Column width="280" />
  157. <f:Column width="330" />
  158. <f:Column width="314" />
  159. <f:Column width="314" />
  160. <f:Column width="429" />
  161. </f:Columns>
  162. <f:Body>
  163. <f:Cell id="text17" alias="文本17" styleID="4" left="1" right="1" top="1" bottom="1" type="constant">
  164. <f:DesignedCell locked="false" />
  165. <f:Data type="string">往来户类型</f:Data>
  166. </f:Cell>
  167. <f:Cell id="text10" alias="文本10" styleID="4" left="2" right="2" top="1" bottom="1" type="constant">
  168. <f:DesignedCell locked="false" />
  169. <f:Data type="string">往来户代码</f:Data>
  170. </f:Cell>
  171. <f:Cell id="text11" alias="文本11" styleID="4" left="3" right="3" top="1" bottom="1" type="constant">
  172. <f:DesignedCell locked="false" />
  173. <f:Data type="string">往来户名称</f:Data>
  174. </f:Cell>
  175. <f:Cell id="text12" alias="文本12" styleID="4" left="4" right="4" top="1" bottom="1" type="constant">
  176. <f:DesignedCell locked="false" />
  177. <f:Data type="string">币别</f:Data>
  178. </f:Cell>
  179. <f:Cell id="text13" alias="文本13" styleID="4" left="5" right="5" top="1" bottom="1" type="constant">
  180. <f:DesignedCell locked="false" />
  181. <f:Data type="string">期初余额(应付为负数)</f:Data>
  182. </f:Cell>
  183. <f:Cell id="text14" alias="文本14" styleID="4" left="6" right="6" top="1" bottom="1" type="constant">
  184. <f:DesignedCell locked="false" />
  185. <f:Data type="string">本期应收/已付</f:Data>
  186. </f:Cell>
  187. <f:Cell id="text15" alias="文本15" styleID="4" left="7" right="7" top="1" bottom="1" type="constant">
  188. <f:DesignedCell locked="false" />
  189. <f:Data type="string">本期应付/已收</f:Data>
  190. </f:Cell>
  191. <f:Cell id="text16" alias="文本16" styleID="4" left="8" right="8" top="1" bottom="1" type="constant">
  192. <f:DesignedCell locked="false" />
  193. <f:Data type="string">期末余额(应付为负数)</f:Data>
  194. </f:Cell>
  195. </f:Body>
  196. </f:Table>
  197. <f:Area id="loop3" alias="循环区3" styleID="1" left="[group2.left]" right="[group2.right]" top="[table3.bottom]">
  198. <f:DesignedArea leftLocationType="relative" leftRelativeObjID="group2" leftRelativeBorder="left" leftRelativeOffset="0" rightLocationType="relative" rightRelativeObjID="group2" rightRelativeBorder="right" rightRelativeOffset="0" topLocationType="relative" topRelativeObjID="table3" topRelativeBorder="bottom" topRelativeOffset="0" bottomLocationType="selfAdapt" bottomRelativeObjID="group2" bottomRelativeBorder="bottom" bottomRelativeOffset="0" locked="false" />
  199. <f:Table id="table4" alias="网格容器4" left="[loop3.left]" right="[loop3.right]-5.0" top="[loop3.top]" bottom="[loop3.top]+70.0" dataSourceID="ArCAStmtDS" layout="1">
  200. <f:DesignedTable layout="heightAuto" leftLocationType="relative" leftRelativeObjID="loop3" leftRelativeBorder="left" leftRelativeOffset="0" rightLocationType="relative" rightRelativeObjID="loop3" rightRelativeBorder="right" rightRelativeOffset="-5" topLocationType="relative" topRelativeObjID="loop3" topRelativeBorder="top" topRelativeOffset="0" bottomLocationType="relative" bottomRelativeObjID="loop3" bottomRelativeBorder="top" bottomRelativeOffset="70" locked="false" />
  201. <f:Rows>
  202. <f:Row height="*" />
  203. </f:Rows>
  204. <f:Columns>
  205. <f:Column width="280" />
  206. <f:Column width="314" />
  207. <f:Column width="314" />
  208. <f:Column width="280" />
  209. <f:Column width="330" />
  210. <f:Column width="314" />
  211. <f:Column width="314" />
  212. <f:Column width="429" />
  213. </f:Columns>
  214. <f:Body>
  215. <f:Cell id="field9" alias="字段9" styleID="4" left="1" right="1" top="1" bottom="1" type="field">
  216. <f:DesignedCell text="往来户类型" locked="false" />
  217. <f:Data type="string">FCussType</f:Data>
  218. </f:Cell>
  219. <f:Cell id="field10" alias="字段10" styleID="4" left="2" right="2" top="1" bottom="1" type="field">
  220. <f:DesignedCell text="往来户代码" locked="false" />
  221. <f:Data type="string">FCussNum</f:Data>
  222. </f:Cell>
  223. <f:Cell id="field11" alias="字段11" styleID="4" left="3" right="3" top="1" bottom="1" type="field">
  224. <f:DesignedCell text="往来户名称" locked="false" />
  225. <f:Data type="string">FCussName</f:Data>
  226. </f:Cell>
  227. <f:Cell id="field12" alias="字段12" styleID="4" left="4" right="4" top="1" bottom="1" type="field">
  228. <f:DesignedCell text="币别" locked="false" />
  229. <f:Data type="string">FCurrency</f:Data>
  230. </f:Cell>
  231. <f:Cell id="field13" alias="字段13" styleID="5" left="5" right="5" top="1" bottom="1" type="field">
  232. <f:DesignedCell text="期初余额(应付为负数)" locked="false" />
  233. <f:Data type="string">FStartBalanceAmt</f:Data>
  234. </f:Cell>
  235. <f:Cell id="field14" alias="字段14" styleID="5" left="6" right="6" top="1" bottom="1" type="field">
  236. <f:DesignedCell text="本期应收/已付" locked="false" />
  237. <f:Data type="string">FDebitAmt</f:Data>
  238. </f:Cell>
  239. <f:Cell id="field15" alias="字段15" styleID="5" left="7" right="7" top="1" bottom="1" type="field">
  240. <f:DesignedCell text="本期应付/已收" locked="false" />
  241. <f:Data type="string">FCreditAmt</f:Data>
  242. </f:Cell>
  243. <f:Cell id="field16" alias="字段16" styleID="5" left="8" right="8" top="1" bottom="1" type="field">
  244. <f:DesignedCell text="期末余额(应付为负数)" locked="false" />
  245. <f:Data type="string">FBalanceAmt</f:Data>
  246. </f:Cell>
  247. </f:Body>
  248. </f:Table>
  249. </f:Area>
  250. </f:Panel>
  251. </f:Panel>
  252. </f:Area>
  253. </f:Page>
  254. </Form>
  255. <PrintInfo>
  256. <c:PageSetup>
  257. <c:PageMargin left="160" right="160" top="130" bottom="130" header="80" footer="80" />
  258. <c:Orientation>LANDSCAPE</c:Orientation>
  259. <c:PaperSizeName>iso-a4</c:PaperSizeName>
  260. <c:Header height="80" margin="80" />
  261. <c:Footer height="80" margin="80" />
  262. </c:PageSetup>
  263. <c:PrinterSetup />
  264. </PrintInfo>
  265. </DocRoot>