123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244 |
- <?xml version="1.0" encoding="UTF-8"?>
- <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">
- <DocInfo>
- <c:Created>Sat Dec 31 13:15:35 CST 2005</c:Created>
- <c:Company>kingdee.com</c:Company>
- <c:LastModified>Fri Nov 05 15:59:59 CST 2010</c:LastModified>
- <c:Author>null</c:Author>
- </DocInfo>
- <DataSources version="2.0">
- <c:DataSource id="ApCAStmtDS">
- <c:Reference />
- <c:Params />
- </c:DataSource>
- </DataSources>
- <Styles version="1.0">
- <c:Style id="3">
- <c:Font fontName="宋体" size="12" color="#000000" bold="true" underline="false" italic="false" strikethrough="false" weight="400.0" />
- <c:Borders>
- <c:Border position="left" lineStyle="NullLine" />
- <c:Border position="top" lineStyle="NullLine" />
- <c:Border position="right" lineStyle="NullLine" />
- <c:Border position="bottom" lineStyle="NullLine" />
- <c:Border position="diagonalleft" lineStyle="NullLine" />
- <c:Border position="diagonalright" lineStyle="NullLine" />
- </c:Borders>
- <c:Interior color="#ffffff" pattern="Solid" patternColor="#000000" />
- <c:Alignment horizontal="center" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" clip="true" />
- <c:Protection hidden="false" locked="false" />
- </c:Style>
- <c:Style id="2">
- <c:Font fontName="宋体" size="9" color="#000000" bold="false" underline="false" italic="false" strikethrough="false" weight="400.0" />
- <c:Borders>
- <c:Border position="left" lineStyle="NullLine" />
- <c:Border position="top" lineStyle="NullLine" />
- <c:Border position="right" lineStyle="NullLine" />
- <c:Border position="bottom" lineStyle="NullLine" />
- <c:Border position="diagonalleft" lineStyle="NullLine" />
- <c:Border position="diagonalright" lineStyle="NullLine" />
- </c:Borders>
- <c:Interior color="#ffffff" pattern="Solid" patternColor="#000000" />
- <c:Alignment horizontal="center" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" clip="true" />
- <c:Protection hidden="false" locked="false" />
- </c:Style>
- <c:Style id="1">
- <c:Font fontName="宋体" size="9" color="#000000" bold="false" underline="false" italic="false" strikethrough="false" weight="400.0" />
- <c:Borders>
- <c:Border position="left" lineStyle="NullLine" />
- <c:Border position="top" lineStyle="NullLine" />
- <c:Border position="right" lineStyle="NullLine" />
- <c:Border position="bottom" lineStyle="NullLine" />
- <c:Border position="diagonalleft" lineStyle="NullLine" />
- <c:Border position="diagonalright" lineStyle="NullLine" />
- </c:Borders>
- <c:Interior color="#ffffff00" pattern="None" patternColor="#000000" />
- <c:Alignment horizontal="center" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" clip="true" />
- <c:Protection hidden="false" locked="false" />
- </c:Style>
- <c:Style id="0">
- <c:Interior color="#ffffff" pattern="Solid" patternColor="#000000" />
- </c:Style>
- <c:Style id="4">
- <c:Font color="#000000" />
- <c:Borders>
- <c:Border position="left" lineStyle="Single" penStyle="Solid" color="#000000" />
- <c:Border position="top" lineStyle="Single" penStyle="Solid" color="#000000" />
- <c:Border position="right" lineStyle="Single" penStyle="Solid" color="#000000" />
- <c:Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000" />
- </c:Borders>
- <c:Interior color="#ffffff" pattern="Solid" patternColor="#000000" />
- </c:Style>
- </Styles>
- <Headers />
- <Footers />
- <DataObjects version="1.0">
- <DataObject name="ApCAStmtDS" alias.zh_CN="ApCAStmtDS" alias="#1">
- <CommonQuery name="ApCAStmtDS" alias.zh_CN="ApCAStmtDS" alias="#1">
- <Outputs>
- <Columns>
- <Column name="FSeq" alias.zh_CN="序号" alias="#1" dataType="string" expr="[ArApCAStmtRpt.bos-query].[FSeq]" order="0" />
- <Column name="FCussType" alias.zh_CN="往来户类型" alias="#1" dataType="string" expr="[ArApCAStmtRpt.bos-query].[FCussType]" order="0" />
- <Column name="FCussNum" alias.zh_CN="往来户代码" alias="#1" dataType="string" expr="[ArApCAStmtRpt.bos-query].[FCussNum]" order="0" />
- <Column name="FCussName" alias.zh_CN="往来户名称" alias="#1" dataType="string" expr="[ArApCAStmtRpt.bos-query].[FCussName]" order="0" />
- <Column name="FCurrency" alias.zh_CN="币别" alias="#1" dataType="string" expr="[ArApCAStmtRpt.bos-query].[FCurrency]" order="0" />
- <Column name="FDebitAmt" alias.zh_CN="本期应付/已收" alias="#1" dataType="string" expr="[ArApCAStmtRpt.bos-query].[FDebitAmt]" order="0" />
- <Column name="FCreditAmt" alias.zh_CN="本期应收/已付" alias="#1" dataType="string" expr="[ArApCAStmtRpt.bos-query].[FCreditAmt]" order="0" />
- <Column name="FStartBalanceAmt" alias.zh_TW="期初餘額(應收為負數)" alias.zh_CN="期初余额(应收为负数)" alias.en="" alias="#1" dataType="string" order="0" />
- <Column name="FBalanceAmt" alias.zh_TW="期末餘額(應收為負數)" alias.zh_CN="期末余额(应收为负数)" alias.en="" alias="#1" dataType="string" order="0" />
- </Columns>
- </Outputs>
- <Query version="1.0" type="bos.query">
- <Columns>
- <Column name="FSeq" alias.zh_CN="序号" alias="#1" dataType="string" expr="[ArApCAStmtRpt.bos-query].[FSeq]" />
- <Column name="FCussType" alias.zh_CN="往来户类型" alias="#1" dataType="string" expr="[ArApCAStmtRpt.bos-query].[FCussType]" />
- <Column name="FCussNum" alias.zh_CN="往来户代码" alias="#1" dataType="string" expr="[ArApCAStmtRpt.bos-query].[FCussNum]" />
- <Column name="FCussName" alias.zh_CN="往来户名称" alias="#1" dataType="string" expr="[ArApCAStmtRpt.bos-query].[FCussName]" />
- <Column name="FCurrency" alias.zh_CN="币别" alias="#1" dataType="string" expr="[ArApCAStmtRpt.bos-query].[FCurrency]" />
- <Column name="FDebitAmt" alias.zh_CN="本期应付/已收" alias="#1" dataType="string" expr="[ArApCAStmtRpt.bos-query].[FDebitAmt]" />
- <Column name="FCreditAmt" alias.zh_CN="本期应收/已付" alias="#1" dataType="string" expr="[ArApCAStmtRpt.bos-query].[FCreditAmt]" />
- <Column name="FStartBalanceAmt" alias.zh_TW="期初餘額(應收為負數)" alias.zh_CN="期初余额(应收为负数)" alias.en="" alias="#1" dataType="string" />
- <Column name="FBalanceAmt" alias.zh_TW="期末餘額(應收為負數)" alias.zh_CN="期末余额(应收为负数)" alias.en="" alias="#1" dataType="string" />
- </Columns>
- <Tables />
- <Joins />
- <Orders />
- <Filter />
- <Content><![CDATA[ArApCAStmtRpt.bos-query]]></Content>
- </Query>
- <EXT />
- </CommonQuery>
- </DataObject>
- </DataObjects>
- <Form id="form1" alias="ApCAStmt" version="3.1">
- <f:Page id="page1" alias="页1" styleID="0" repeat="-1">
- <f:DesignedPage paperSize="iso-a4" objWidth="2650" objHeight="1840" widthLimitless="false" heightLimitless="false" />
- <f:Area id="loop1" alias="循环区1" styleID="1" left="[page1.left]" right="[loop1.left]+2590.0" top="[page1.top]" bottom="[loop1.top]+1750.0" nextAreaID="loop1">
- <f:DesignedArea leftLocationType="relative" leftRelativeObjID="page1" leftRelativeBorder="left" leftRelativeOffset="0" rightLocationType="relative" rightRelativeObjID="loop1" rightRelativeBorder="left" rightRelativeOffset="2590" topLocationType="relative" topRelativeObjID="page1" topRelativeBorder="top" topRelativeOffset="0" bottomLocationType="relative" bottomRelativeObjID="loop1" bottomRelativeBorder="top" bottomRelativeOffset="1750" locked="false" />
- <f:Panel id="group1" alias="分组容器1" styleID="2" left="[loop1.left]" right="[loop1.right]-10.0" top="[loop1.top]" bottom="[loop1.bottom]" dataSourceID="ApCAStmtDS">
- <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" />
- <f:Cell id="text1" alias="文本1" styleID="3" left="[group1.left]+1030.0" right="[group1.left]+1479.0" top="[group1.top]+34.0" bottom="[group1.top]+87.0" type="constant">
- <f:DesignedCell leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="1030" 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" />
- <f:Data type="string">往来对帐单</f:Data>
- </f:Cell>
- <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">
- <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" />
- <f:Table id="table1" alias="网格容器1" left="[group2.left]" right="[group2.right]-5.0" top="[group2.top]" bottom="[group2.top]+70.0" layout="1">
- <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" />
- <f:Rows>
- <f:Row height="*" />
- </f:Rows>
- <f:Columns>
- <f:Column width="280" />
- <f:Column width="314" />
- <f:Column width="314" />
- <f:Column width="280" />
- <f:Column width="330" />
- <f:Column width="314" />
- <f:Column width="314" />
- <f:Column width="379" />
- </f:Columns>
- <f:Body>
- <f:Cell id="text2" alias="文本2" styleID="4" left="1" right="1" top="1" bottom="1" type="constant">
- <f:DesignedCell locked="false" />
- <f:Data type="string">往来户类型</f:Data>
- </f:Cell>
- <f:Cell id="text3" alias="文本3" styleID="4" left="2" right="2" top="1" bottom="1" type="constant">
- <f:DesignedCell locked="false" />
- <f:Data type="string">往来户代码</f:Data>
- </f:Cell>
- <f:Cell id="text4" alias="文本4" styleID="4" left="3" right="3" top="1" bottom="1" type="constant">
- <f:DesignedCell locked="false" />
- <f:Data type="string">往来户名称</f:Data>
- </f:Cell>
- <f:Cell id="text5" alias="文本5" styleID="4" left="4" right="4" top="1" bottom="1" type="constant">
- <f:DesignedCell locked="false" />
- <f:Data type="string">币别</f:Data>
- </f:Cell>
- <f:Cell id="text6" alias="文本6" styleID="4" left="5" right="5" top="1" bottom="1" type="constant">
- <f:DesignedCell locked="false" />
- <f:Data type="string">期初余额(应付为负数)</f:Data>
- </f:Cell>
- <f:Cell id="text7" alias="文本7" styleID="4" left="6" right="6" top="1" bottom="1" type="constant">
- <f:DesignedCell locked="false" />
- <f:Data type="string">应收/已付</f:Data>
- </f:Cell>
- <f:Cell id="text8" alias="文本8" styleID="4" left="7" right="7" top="1" bottom="1" type="constant">
- <f:DesignedCell locked="false" />
- <f:Data type="string">应付/已收</f:Data>
- </f:Cell>
- <f:Cell id="text9" alias="文本9" styleID="4" left="8" right="8" top="1" bottom="1" type="constant">
- <f:DesignedCell locked="false" />
- <f:Data type="string">期末余额(应付为负数)</f:Data>
- </f:Cell>
- </f:Body>
- </f:Table>
- <f:Area id="loop2" alias="循环区2" styleID="1" left="[group2.left]" right="[group2.right]" top="[table1.bottom]" nextAreaID="loop2">
- <f:DesignedArea leftLocationType="relative" leftRelativeObjID="group2" leftRelativeBorder="left" leftRelativeOffset="0" rightLocationType="relative" rightRelativeObjID="group2" rightRelativeBorder="right" rightRelativeOffset="0" topLocationType="relative" topRelativeObjID="table1" topRelativeBorder="bottom" topRelativeOffset="0" bottomLocationType="selfAdapt" bottomRelativeObjID="group2" bottomRelativeBorder="bottom" bottomRelativeOffset="0" locked="false" />
- <f:Table id="table2" alias="网格容器2" left="[loop2.left]" right="[loop2.right]-5.0" top="[loop2.top]" bottom="[loop2.top]+70.0" dataSourceID="ApCAStmtDS" layout="1">
- <f:DesignedTable layout="heightAuto" leftLocationType="relative" leftRelativeObjID="loop2" leftRelativeBorder="left" leftRelativeOffset="0" rightLocationType="relative" rightRelativeObjID="loop2" rightRelativeBorder="right" rightRelativeOffset="-5" topLocationType="relative" topRelativeObjID="loop2" topRelativeBorder="top" topRelativeOffset="0" bottomLocationType="relative" bottomRelativeObjID="loop2" bottomRelativeBorder="top" bottomRelativeOffset="70" locked="false" />
- <f:Rows>
- <f:Row height="*" />
- </f:Rows>
- <f:Columns>
- <f:Column width="280" />
- <f:Column width="314" />
- <f:Column width="314" />
- <f:Column width="280" />
- <f:Column width="330" />
- <f:Column width="314" />
- <f:Column width="314" />
- <f:Column width="379" />
- </f:Columns>
- <f:Body>
- <f:Cell id="field16" alias="字段16" styleID="4" left="1" right="1" top="1" bottom="1" type="field">
- <f:DesignedCell text="往来户类型" locked="false" />
- <f:Data type="string">FCussType</f:Data>
- </f:Cell>
- <f:Cell id="field15" alias="字段15" styleID="4" left="2" right="2" top="1" bottom="1" type="field">
- <f:DesignedCell text="往来户代码" locked="false" />
- <f:Data type="string">FCussNum</f:Data>
- </f:Cell>
- <f:Cell id="field14" alias="字段14" styleID="4" left="3" right="3" top="1" bottom="1" type="field">
- <f:DesignedCell text="往来户名称" locked="false" />
- <f:Data type="string">FCussName</f:Data>
- </f:Cell>
- <f:Cell id="field13" alias="字段13" styleID="4" left="4" right="4" top="1" bottom="1" type="field">
- <f:DesignedCell text="币别" locked="false" />
- <f:Data type="string">FCurrency</f:Data>
- </f:Cell>
- <f:Cell id="field1" alias="字段1" styleID="4" left="5" right="5" top="1" bottom="1" type="field">
- <f:DesignedCell text="期初余额(应收为负数)" locked="false" />
- <f:Data type="string">FStartBalanceAmt</f:Data>
- </f:Cell>
- <f:Cell id="field11" alias="字段11" styleID="4" left="6" right="6" top="1" bottom="1" type="field">
- <f:DesignedCell text="本期应付/已收" locked="false" />
- <f:Data type="string">FDebitAmt</f:Data>
- </f:Cell>
- <f:Cell id="field10" alias="字段10" styleID="4" left="7" right="7" top="1" bottom="1" type="field">
- <f:DesignedCell text="本期应收/已付" locked="false" />
- <f:Data type="string">FCreditAmt</f:Data>
- </f:Cell>
- <f:Cell id="field2" alias="字段2" styleID="4" left="8" right="8" top="1" bottom="1" type="field">
- <f:DesignedCell text="期末余额(应收为负数)" locked="false" />
- <f:Data type="string">FBalanceAmt</f:Data>
- </f:Cell>
- </f:Body>
- </f:Table>
- </f:Area>
- </f:Panel>
- </f:Panel>
- </f:Area>
- </f:Page>
- </Form>
- <PrintInfo>
- <c:PageSetup>
- <c:PageMargin left="160" right="160" top="130" bottom="130" header="80" footer="80" />
- <c:Orientation>LANDSCAPE</c:Orientation>
- <c:PaperSizeName>iso-a4</c:PaperSizeName>
- <c:Header height="80" margin="80" />
- <c:Footer height="80" margin="80" />
- </c:PageSetup>
- <c:PrinterSetup />
- </PrintInfo>
- </DocRoot>
|