123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589 |
- <?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>Fri May 11 13:18:42 CST 2007</c:Created>
- <c:Company>kingdee.com</c:Company>
- <c:LastModified>Sat Sep 19 14:30:48 CST 2009</c:LastModified>
- <c:Author>null</c:Author>
- </DocInfo>
- <DataSources version="2.0">
- <c:DataSource id="BankBalanceAdjustment.bos-query">
- <c:Reference />
- <c:Params />
- </c:DataSource>
- </DataSources>
- <DataObjects version="1.0">
- <DataObject name="BankBalanceAdjustment.bos-query" alias.zh_CN="余额调节表" alias.en="" alias.zh_TW="" alias="#1" desc.zh_TW="" desc.en="" desc.zh_CN="" desc="#1">
- <CommonQuery name="BankBalanceAdjustment.bos-query" alias.zh_CN="余额调节表" alias.en="" alias.zh_TW="" alias="#1" desc.zh_TW="" desc.en="" desc.zh_CN="" desc="#1">
- <Outputs>
- <Columns>
- <Column name="entprUnreachedDetails.createDate" alias="企业未达帐明细.日期" dataType="string" expr="[BankBalanceAdjustment].[entprUnreachedDetails.createDate]" order="0" />
- <Column name="entprUnreachedDetails.description" alias="企业未达帐明细.摘要" dataType="string" expr="[BankBalanceAdjustment].[entprUnreachedDetails.description]" order="0" />
- <Column name="entprUnreachedDetails.settleType" alias="企业未达帐明细.结算方式" dataType="string" expr="[BankBalanceAdjustment].[entprUnreachedDetails.settleType]" order="0" />
- <Column name="entprUnreachedDetails.settleNumber" alias="企业未达帐明细.结算号" dataType="string" expr="[BankBalanceAdjustment].[entprUnreachedDetails.settleNumber]" order="0" />
- <Column name="entprUnreachedDetails.debitAmount" alias="企业未达帐明细.借方金额" dataType="string" expr="[BankBalanceAdjustment].[entprUnreachedDetails.debitAmount]" order="0" />
- <Column name="entprUnreachedDetails.creditAmount" alias="企业未达帐明细.贷方金额" dataType="string" expr="[BankBalanceAdjustment].[entprUnreachedDetails.creditAmount]" order="0" />
- <Column name="bankUnreachedDetails.createDate" alias="银行未达帐明细.日期" dataType="string" expr="[BankBalanceAdjustment].[bankUnreachedDetails.createDate]" order="0" />
- <Column name="bankUnreachedDetails.voucherType" alias="银行未达帐明细.凭证类型" dataType="string" expr="[BankBalanceAdjustment].[bankUnreachedDetails.voucherType]" order="0" />
- <Column name="bankUnreachedDetails.voucherNumber" alias="银行未达帐明细.凭证号" dataType="string" expr="[BankBalanceAdjustment].[bankUnreachedDetails.voucherNumber]" order="0" />
- <Column name="bankUnreachedDetails.description" alias="银行未达帐明细.摘要" dataType="string" expr="[BankBalanceAdjustment].[bankUnreachedDetails.description]" order="0" />
- <Column name="bankUnreachedDetails.settlementType" alias="银行未达帐明细.结算方式" dataType="string" expr="[BankBalanceAdjustment].[bankUnreachedDetails.settlementType]" order="0" />
- <Column name="bankUnreachedDetails.settlementNumber" alias="银行未达帐明细.结算号" dataType="string" expr="[BankBalanceAdjustment].[bankUnreachedDetails.settlementNumber]" order="0" />
- <Column name="bankUnreachedDetails.debitAmount" alias="银行未达帐明细.借方金额" dataType="string" expr="[BankBalanceAdjustment].[bankUnreachedDetails.debitAmount]" order="0" />
- <Column name="bankUnreachedDetails.creditAmount" alias="银行未达帐明细.贷方金额" dataType="string" expr="[BankBalanceAdjustment].[bankUnreachedDetails.creditAmount]" order="0" />
- <Column name="bankAccount" alias="银行帐户" dataType="string" expr="[BankBalanceAdjustment].[bankAccount]" order="0" />
- <Column name="currency" alias="币别" dataType="string" expr="[BankBalanceAdjustment].[currency]" order="0" />
- <Column name="bankAccountView" alias="银行科目" dataType="string" expr="[BankBalanceAdjustment].[bankAccountView]" order="0" />
- <Column name="intTerm" alias="期间" dataType="string" expr="[BankBalanceAdjustment].[intTerm]" order="0" />
- <Column name="jornalAmount" alias="企业银行存款日记账.期末余额" dataType="string" expr="[BankBalanceAdjustment].[jornalAmount]" order="0" />
- <Column name="bankGot" alias="企业银行存款日记账.银行已收企业未收" dataType="string" expr="[BankBalanceAdjustment].[bankGot]" order="0" />
- <Column name="bankPayed" alias="企业银行存款日记账.银行已付企业未付" dataType="string" expr="[BankBalanceAdjustment].[bankPayed]" order="0" />
- <Column name="adjustedJournalAmount" alias="企业银行存款日记账.调整后期末余额" dataType="string" expr="[BankBalanceAdjustment].[adjustedJournalAmount]" order="0" />
- <Column name="statmntAmount" alias="银行对账单.期末余额" dataType="string" expr="[BankBalanceAdjustment].[statmntAmount]" order="0" />
- <Column name="entprGot" alias="银行对账单.企业已收银行未收" dataType="string" expr="[BankBalanceAdjustment].[entprGot]" order="0" />
- <Column name="entprPayed" alias="银行对账单.企业已付银行未付" dataType="string" expr="[BankBalanceAdjustment].[entprPayed]" order="0" />
- <Column name="adjustedStatmntAmount" alias="银行对账单.调整后期末余额" dataType="string" expr="[BankBalanceAdjustment].[adjustedStatmntAmount]" order="0" />
- </Columns>
- </Outputs>
- <Query name="BankBalanceAdjustment.bos-query" alias.zh_CN="余额调节表" alias.en="" alias.zh_TW="" alias="#1" desc.zh_TW="" desc.en="" desc.zh_CN="" desc="#1" version="1.0" type="bos.query">
- <Columns>
- <Column name="entprUnreachedDetails.createDate" alias="企业未达帐明细.日期" dataType="string" expr="[BankBalanceAdjustment].[entprUnreachedDetails.createDate]" />
- <Column name="entprUnreachedDetails.description" alias="企业未达帐明细.摘要" dataType="string" expr="[BankBalanceAdjustment].[entprUnreachedDetails.description]" />
- <Column name="entprUnreachedDetails.settleType" alias="企业未达帐明细.结算方式" dataType="string" expr="[BankBalanceAdjustment].[entprUnreachedDetails.settleType]" />
- <Column name="entprUnreachedDetails.settleNumber" alias="企业未达帐明细.结算号" dataType="string" expr="[BankBalanceAdjustment].[entprUnreachedDetails.settleNumber]" />
- <Column name="entprUnreachedDetails.debitAmount" alias="企业未达帐明细.借方金额" dataType="string" expr="[BankBalanceAdjustment].[entprUnreachedDetails.debitAmount]" />
- <Column name="entprUnreachedDetails.creditAmount" alias="企业未达帐明细.贷方金额" dataType="string" expr="[BankBalanceAdjustment].[entprUnreachedDetails.creditAmount]" />
- <Column name="bankUnreachedDetails.createDate" alias="银行未达帐明细.日期" dataType="string" expr="[BankBalanceAdjustment].[bankUnreachedDetails.createDate]" />
- <Column name="bankUnreachedDetails.voucherType" alias="银行未达帐明细.凭证类型" dataType="string" expr="[BankBalanceAdjustment].[bankUnreachedDetails.voucherType]" />
- <Column name="bankUnreachedDetails.voucherNumber" alias="银行未达帐明细.凭证号" dataType="string" expr="[BankBalanceAdjustment].[bankUnreachedDetails.voucherNumber]" />
- <Column name="bankUnreachedDetails.description" alias="银行未达帐明细.摘要" dataType="string" expr="[BankBalanceAdjustment].[bankUnreachedDetails.description]" />
- <Column name="bankUnreachedDetails.settlementType" alias="银行未达帐明细.结算方式" dataType="string" expr="[BankBalanceAdjustment].[bankUnreachedDetails.settlementType]" />
- <Column name="bankUnreachedDetails.settlementNumber" alias="银行未达帐明细.结算号" dataType="string" expr="[BankBalanceAdjustment].[bankUnreachedDetails.settlementNumber]" />
- <Column name="bankUnreachedDetails.debitAmount" alias="银行未达帐明细.借方金额" dataType="string" expr="[BankBalanceAdjustment].[bankUnreachedDetails.debitAmount]" />
- <Column name="bankUnreachedDetails.creditAmount" alias="银行未达帐明细.贷方金额" dataType="string" expr="[BankBalanceAdjustment].[bankUnreachedDetails.creditAmount]" />
- <Column name="bankAccount" alias="银行帐户" dataType="string" expr="[BankBalanceAdjustment].[bankAccount]" />
- <Column name="currency" alias="币别" dataType="string" expr="[BankBalanceAdjustment].[currency]" />
- <Column name="bankAccountView" alias="银行科目" dataType="string" expr="[BankBalanceAdjustment].[bankAccountView]" />
- <Column name="intTerm" alias="期间" dataType="string" expr="[BankBalanceAdjustment].[intTerm]" />
- <Column name="jornalAmount" alias="企业银行存款日记账.期末余额" dataType="string" expr="[BankBalanceAdjustment].[jornalAmount]" />
- <Column name="bankGot" alias="企业银行存款日记账.银行已收企业未收" dataType="string" expr="[BankBalanceAdjustment].[bankGot]" />
- <Column name="bankPayed" alias="企业银行存款日记账.银行已付企业未付" dataType="string" expr="[BankBalanceAdjustment].[bankPayed]" />
- <Column name="adjustedJournalAmount" alias="企业银行存款日记账.调整后期末余额" dataType="string" expr="[BankBalanceAdjustment].[adjustedJournalAmount]" />
- <Column name="statmntAmount" alias="银行对账单.期末余额" dataType="string" expr="[BankBalanceAdjustment].[statmntAmount]" />
- <Column name="entprGot" alias="银行对账单.企业已收银行未收" dataType="string" expr="[BankBalanceAdjustment].[entprGot]" />
- <Column name="entprPayed" alias="银行对账单.企业已付银行未付" dataType="string" expr="[BankBalanceAdjustment].[entprPayed]" />
- <Column name="adjustedStatmntAmount" alias="银行对账单.调整后期末余额" dataType="string" expr="[BankBalanceAdjustment].[adjustedStatmntAmount]" />
- </Columns>
- <Tables />
- <Joins />
- <Orders />
- <Filter />
- <Content><![CDATA[BankBalanceAdjustment.bos-query]]></Content>
- </Query>
- <EXT />
- </CommonQuery>
- </DataObject>
- </DataObjects>
- <Styles version="1.0">
- <c:Style id="10">
- <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" padding="1,1,1,1" clip="true" />
- <c:Protection hidden="false" locked="false" />
- </c:Style>
- <c:Style id="3">
- <c:Font fontName="宋体" size="16" color="#000000" bold="true" underline="true" 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" padding="1,1,1,1" clip="true" />
- <c:Protection hidden="false" locked="false" />
- </c:Style>
- <c:Style id="5">
- <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="left" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" padding="1,1,1,1" clip="true" />
- <c:Protection hidden="false" locked="false" />
- </c:Style>
- <c:Style id="7">
- <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="left" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" padding="1,1,1,1" 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" padding="1,1,1,1" 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="11">
- <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="right" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" padding="1,1,1,1" clip="true" />
- <c:Protection hidden="false" locked="false" />
- </c:Style>
- <c:Style id="9">
- <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" padding="1,1,1,1" clip="true" />
- <c:Protection hidden="false" locked="false" />
- </c:Style>
- <c:Style id="4">
- <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:Borders>
- <c:Interior color="#ffffff" pattern="Solid" patternColor="#000000" />
- </c:Style>
- <c:Style id="8">
- <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="right" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" padding="1,1,1,1" clip="true" />
- <c:Protection hidden="false" locked="false" />
- </c:Style>
- <c:Style id="6">
- <c:Font fontName="宋体" size="9" 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="left" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" padding="1,1,1,1" 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" padding="1,1,1,1" clip="true" />
- <c:Protection hidden="false" locked="false" />
- </c:Style>
- </Styles>
- <Headers />
- <Footers />
- <Form id="form1" alias="BankBalanceAdjustment.kdrs-form" version="3.1">
- <f:Page id="page1" alias="页1" styleID="0" repeat="-1">
- <f:DesignedPage paperSize="iso-a4" objWidth="2590" objHeight="1600" 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]+1600.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="1600" locked="false" />
- <f:Panel id="group1" alias="分组容器1" styleID="2" left="[loop1.left]" right="[group1.left]+2590.0" top="[loop1.top]" bottom="[group1.top]+1600.0" dataSourceID="BankBalanceAdjustment.bos-query">
- <f:DesignedPanel leftLocationType="relative" leftRelativeObjID="loop1" leftRelativeBorder="left" leftRelativeOffset="0" rightLocationType="relative" rightRelativeObjID="group1" rightRelativeBorder="left" rightRelativeOffset="2590" topLocationType="relative" topRelativeObjID="loop1" topRelativeBorder="top" topRelativeOffset="0" bottomLocationType="relative" bottomRelativeObjID="group1" bottomRelativeBorder="top" bottomRelativeOffset="1600" locked="false" />
- <f:Cell id="text1" alias="文本1" styleID="3" left="[group1.left]+1168.0" right="[text1.left]+469.0" top="[group1.top]+3.0" bottom="[text1.top]+109.0" type="constant">
- <f:DesignedCell leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="1168" rightLocationType="relative" rightRelativeObjID="text1" rightRelativeBorder="left" rightRelativeOffset="469" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="3" bottomLocationType="relative" bottomRelativeObjID="text1" bottomRelativeBorder="top" bottomRelativeOffset="109" locked="false" />
- <f:Data type="string">余额调节表</f:Data>
- </f:Cell>
- <f:Table id="table1" alias="网格容器1" styleID="4" left="[group1.left]" right="[table1.left]+2590.0" top="[group1.top]+111.0" bottom="[table1.top]+138.0" dataSourceID="BankBalanceAdjustment.bos-query" layout="1">
- <f:DesignedTable layout="heightAuto" leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="0" rightLocationType="relative" rightRelativeObjID="table1" rightRelativeBorder="left" rightRelativeOffset="2590" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="111" bottomLocationType="relative" bottomRelativeObjID="table1" bottomRelativeBorder="top" bottomRelativeOffset="138" locked="false" />
- <f:Rows>
- <f:Row height="69" />
- <f:Row height="69" />
- </f:Rows>
- <f:Columns>
- <f:Column width="300" />
- <f:Column width="1600" />
- <f:Column width="300" />
- <f:Column width="390" />
- </f:Columns>
- <f:Body>
- <f:Cell id="text2" alias="文本2" styleID="5" 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="field1" alias="字段1" styleID="5" left="2" right="2" top="1" bottom="1" type="field">
- <f:DesignedCell text="银行帐户" locked="false" />
- <f:Data type="string">bankAccount</f:Data>
- </f:Cell>
- <f:Cell id="text6" alias="文本6" styleID="5" 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="field3" alias="字段3" styleID="5" left="4" right="4" top="1" bottom="1" type="field">
- <f:DesignedCell text="币别" locked="false" />
- <f:Data type="string">currency</f:Data>
- </f:Cell>
- <f:Cell id="text3" alias="文本3" styleID="5" left="1" right="1" top="2" bottom="2" type="constant">
- <f:DesignedCell locked="false" />
- <f:Data type="string">银行科目</f:Data>
- </f:Cell>
- <f:Cell id="field2" alias="字段2" styleID="5" left="2" right="2" top="2" bottom="2" type="field">
- <f:DesignedCell text="银行科目" locked="false" />
- <f:Data type="string">bankAccountView</f:Data>
- </f:Cell>
- <f:Cell id="text7" alias="文本7" styleID="5" left="3" right="3" top="2" bottom="2" type="constant">
- <f:DesignedCell locked="false" />
- <f:Data type="string">期间</f:Data>
- </f:Cell>
- <f:Cell id="field4" alias="字段4" styleID="5" left="4" right="4" top="2" bottom="2" type="field">
- <f:DesignedCell text="期间" locked="false" />
- <f:Data type="string">intTerm</f:Data>
- </f:Cell>
- </f:Body>
- </f:Table>
- <f:Cell id="text4" alias="文本4" styleID="6" left="[group1.left]" right="[text4.left]+1178.0" top="[group1.top]+313.0" bottom="[text4.top]+77.0" type="constant">
- <f:DesignedCell leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="0" rightLocationType="relative" rightRelativeObjID="text4" rightRelativeBorder="left" rightRelativeOffset="1178" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="313" bottomLocationType="relative" bottomRelativeObjID="text4" bottomRelativeBorder="top" bottomRelativeOffset="77" locked="false" />
- <f:Data type="string">企业银行存款日记账</f:Data>
- </f:Cell>
- <f:Cell id="text5" alias="文本5" styleID="6" left="[group1.left]+1293.0" right="[text5.left]+1295.0" top="[group1.top]+313.0" bottom="[text5.top]+77.0" type="constant">
- <f:DesignedCell leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="1293" rightLocationType="relative" rightRelativeObjID="text5" rightRelativeBorder="left" rightRelativeOffset="1295" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="313" bottomLocationType="relative" bottomRelativeObjID="text5" bottomRelativeBorder="top" bottomRelativeOffset="77" locked="false" />
- <f:Data type="string">银行对账单</f:Data>
- </f:Cell>
- <f:Table id="table2" alias="网格容器2" styleID="4" left="[group1.left]" right="[table2.left]+1179.0" top="[group1.top]+390.0" bottom="[table2.top]+307.0" dataSourceID="BankBalanceAdjustment.bos-query" layout="1">
- <f:DesignedTable layout="heightAuto" leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="0" rightLocationType="relative" rightRelativeObjID="table2" rightRelativeBorder="left" rightRelativeOffset="1179" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="390" bottomLocationType="relative" bottomRelativeObjID="table2" bottomRelativeBorder="top" bottomRelativeOffset="307" locked="false" />
- <f:Rows>
- <f:Row height="76" />
- <f:Row height="77" />
- <f:Row height="77" />
- <f:Row height="77" />
- </f:Rows>
- <f:Columns>
- <f:Column width="320" />
- <f:Column width="859" />
- </f:Columns>
- <f:Body>
- <f:Cell id="text8" alias="文本8" styleID="7" 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="field5" alias="字段5" styleID="8" left="2" right="2" top="1" bottom="1" type="field">
- <f:DesignedCell text="企业银行存款日记账.期末余额" locked="false" />
- <f:Data type="string">jornalAmount</f:Data>
- </f:Cell>
- <f:Cell id="text10" alias="文本10" styleID="7" left="1" right="1" top="2" bottom="2" type="constant">
- <f:DesignedCell locked="false" />
- <f:Data type="string">加 银行已收企业未收</f:Data>
- </f:Cell>
- <f:Cell id="field6" alias="字段6" styleID="8" left="2" right="2" top="2" bottom="2" type="field">
- <f:DesignedCell text="企业银行存款日记账.银行已收企业未收" locked="false" />
- <f:Data type="string">bankGot</f:Data>
- </f:Cell>
- <f:Cell id="text9" alias="文本9" styleID="7" left="1" right="1" top="3" bottom="3" type="constant">
- <f:DesignedCell locked="false" />
- <f:Data type="string">减 银行已付企业未付</f:Data>
- </f:Cell>
- <f:Cell id="field7" alias="字段7" styleID="8" left="2" right="2" top="3" bottom="3" type="field">
- <f:DesignedCell text="企业银行存款日记账.银行已付企业未付" locked="false" />
- <f:Data type="string">bankPayed</f:Data>
- </f:Cell>
- <f:Cell id="text11" alias="文本11" styleID="7" left="1" right="1" top="4" bottom="4" type="constant">
- <f:DesignedCell locked="false" />
- <f:Data type="string">调整后期末余额</f:Data>
- </f:Cell>
- <f:Cell id="field8" alias="字段8" styleID="8" left="2" right="2" top="4" bottom="4" type="field">
- <f:DesignedCell text="企业银行存款日记账.调整后期末余额" locked="false" />
- <f:Data type="string">adjustedJournalAmount</f:Data>
- </f:Cell>
- </f:Body>
- </f:Table>
- <f:Table id="table3" alias="网格容器3" styleID="4" left="[group1.left]+1294.0" right="[table3.left]+1296.0" top="[group1.top]+390.0" bottom="[table3.top]+307.0" dataSourceID="BankBalanceAdjustment.bos-query" layout="1">
- <f:DesignedTable layout="heightAuto" leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="1294" rightLocationType="relative" rightRelativeObjID="table3" rightRelativeBorder="left" rightRelativeOffset="1296" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="390" bottomLocationType="relative" bottomRelativeObjID="table3" bottomRelativeBorder="top" bottomRelativeOffset="307" locked="false" />
- <f:Rows>
- <f:Row height="76" />
- <f:Row height="77" />
- <f:Row height="77" />
- <f:Row height="77" />
- </f:Rows>
- <f:Columns>
- <f:Column width="320" />
- <f:Column width="976" />
- </f:Columns>
- <f:Body>
- <f:Cell id="text15" alias="文本15" styleID="7" 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="field9" alias="字段9" styleID="8" left="2" right="2" top="1" bottom="1" type="field">
- <f:DesignedCell text="银行对账单.期末余额" locked="false" />
- <f:Data type="string">statmntAmount</f:Data>
- </f:Cell>
- <f:Cell id="text14" alias="文本14" styleID="7" left="1" right="1" top="2" bottom="2" type="constant">
- <f:DesignedCell locked="false" />
- <f:Data type="string">加 企业已收银行未收</f:Data>
- </f:Cell>
- <f:Cell id="field10" alias="字段10" styleID="8" left="2" right="2" top="2" bottom="2" type="field">
- <f:DesignedCell text="银行对账单.企业已收银行未收" locked="false" />
- <f:Data type="string">entprGot</f:Data>
- </f:Cell>
- <f:Cell id="text13" alias="文本13" styleID="7" left="1" right="1" top="3" bottom="3" type="constant">
- <f:DesignedCell locked="false" />
- <f:Data type="string">减 企业已付银行未付</f:Data>
- </f:Cell>
- <f:Cell id="field11" alias="字段11" styleID="8" left="2" right="2" top="3" bottom="3" type="field">
- <f:DesignedCell text="银行对账单.企业已付银行未付" locked="false" />
- <f:Data type="string">entprPayed</f:Data>
- </f:Cell>
- <f:Cell id="text12" alias="文本12" styleID="7" left="1" right="1" top="4" bottom="4" type="constant">
- <f:DesignedCell locked="false" />
- <f:Data type="string">调整后期末余额</f:Data>
- </f:Cell>
- <f:Cell id="field12" alias="字段12" styleID="8" left="2" right="2" top="4" bottom="4" type="field" format="g/通用格式">
- <f:DesignedCell text="银行对账单.调整后期末余额" locked="false" />
- <f:Data type="string">adjustedStatmntAmount</f:Data>
- </f:Cell>
- </f:Body>
- </f:Table>
- <f:Cell id="text16" alias="文本16" styleID="6" left="[group1.left]" right="[text16.left]+1112.0" top="[group1.top]+744.0" bottom="[text16.top]+85.0" type="constant">
- <f:DesignedCell leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="0" rightLocationType="relative" rightRelativeObjID="text16" rightRelativeBorder="left" rightRelativeOffset="1112" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="744" bottomLocationType="relative" bottomRelativeObjID="text16" bottomRelativeBorder="top" bottomRelativeOffset="85" locked="false" />
- <f:Data type="string">企业未达账明细</f:Data>
- </f:Cell>
- <f:Cell id="text17" alias="文本17" styleID="6" left="[group1.left]+1113.0" right="[text17.left]+1477.0" top="[group1.top]+744.0" bottom="[text17.top]+85.0" type="constant">
- <f:DesignedCell leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="1113" rightLocationType="relative" rightRelativeObjID="text17" rightRelativeBorder="left" rightRelativeOffset="1477" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="744" bottomLocationType="relative" bottomRelativeObjID="text17" bottomRelativeBorder="top" bottomRelativeOffset="85" locked="false" />
- <f:Data type="string">银行未达账明细</f:Data>
- </f:Cell>
- <f:Table id="table4" alias="网格容器4" styleID="4" left="[group1.left]" right="[table4.left]+2590.0" top="[group1.top]+829.0" bottom="[table4.top]+74.0">
- <f:DesignedTable layout="auto" leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="0" rightLocationType="relative" rightRelativeObjID="table4" rightRelativeBorder="left" rightRelativeOffset="2590" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="829" bottomLocationType="relative" bottomRelativeObjID="table4" bottomRelativeBorder="top" bottomRelativeOffset="74" locked="false" />
- <f:Rows>
- <f:Row />
- </f:Rows>
- <f:Columns>
- <f:Column />
- <f:Column />
- <f:Column />
- <f:Column />
- <f:Column />
- <f:Column />
- <f:Column />
- <f:Column />
- <f:Column />
- <f:Column />
- <f:Column />
- <f:Column />
- <f:Column />
- <f:Column />
- </f:Columns>
- <f:Body>
- <f:Cell id="text30" alias="文本30" styleID="9" 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="text19" alias="文本19" styleID="9" 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="text20" alias="文本20" styleID="9" 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="text22" alias="文本22" styleID="9" 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="text21" alias="文本21" styleID="9" 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="text18" alias="文本18" styleID="9" 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="text24" alias="文本24" styleID="9" 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="text23" alias="文本23" styleID="9" left="8" right="8" top="1" bottom="1" type="constant">
- <f:DesignedCell locked="false" />
- <f:Data type="string">凭证类型</f:Data>
- </f:Cell>
- <f:Cell id="text25" alias="文本25" styleID="9" left="9" right="9" top="1" bottom="1" type="constant">
- <f:DesignedCell locked="false" />
- <f:Data type="string">凭证号</f:Data>
- </f:Cell>
- <f:Cell id="text26" alias="文本26" styleID="9" left="10" right="10" top="1" bottom="1" type="constant">
- <f:DesignedCell locked="false" />
- <f:Data type="string">摘要</f:Data>
- </f:Cell>
- <f:Cell id="text29" alias="文本29" styleID="9" left="11" right="11" top="1" bottom="1" type="constant">
- <f:DesignedCell locked="false" />
- <f:Data type="string">结算方式</f:Data>
- </f:Cell>
- <f:Cell id="text28" alias="文本28" styleID="9" left="12" right="12" top="1" bottom="1" type="constant">
- <f:DesignedCell locked="false" />
- <f:Data type="string">结算号</f:Data>
- </f:Cell>
- <f:Cell id="text27" alias="文本27" styleID="9" left="13" right="13" top="1" bottom="1" type="constant">
- <f:DesignedCell locked="false" />
- <f:Data type="string">企业已收银行未收</f:Data>
- </f:Cell>
- <f:Cell id="text31" alias="文本31" styleID="9" left="14" right="14" 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="10" left="[group1.left]" right="[loop2.left]+2590.0" top="[group1.top]+904.0" bottom="[loop2.top]+577.0" nextAreaID="loop2">
- <f:DesignedArea leftLocationType="relative" leftRelativeObjID="group1" leftRelativeBorder="left" leftRelativeOffset="0" rightLocationType="relative" rightRelativeObjID="loop2" rightRelativeBorder="left" rightRelativeOffset="2590" topLocationType="relative" topRelativeObjID="group1" topRelativeBorder="top" topRelativeOffset="904" bottomLocationType="relative" bottomRelativeObjID="loop2" bottomRelativeBorder="top" bottomRelativeOffset="577" locked="false" />
- <f:Table id="table5" alias="网格容器5" styleID="9" left="[loop2.left]" right="[table5.left]+2590.0" top="[loop2.top]+1.0" bottom="[table5.top]+77.0" dataSourceID="BankBalanceAdjustment.bos-query">
- <f:DesignedTable layout="auto" leftLocationType="relative" leftRelativeObjID="loop2" leftRelativeBorder="left" leftRelativeOffset="0" rightLocationType="relative" rightRelativeObjID="table5" rightRelativeBorder="left" rightRelativeOffset="2590" topLocationType="relative" topRelativeObjID="loop2" topRelativeBorder="top" topRelativeOffset="1" bottomLocationType="relative" bottomRelativeObjID="table5" bottomRelativeBorder="top" bottomRelativeOffset="77" locked="false" />
- <f:Rows>
- <f:Row />
- </f:Rows>
- <f:Columns>
- <f:Column />
- <f:Column />
- <f:Column />
- <f:Column />
- <f:Column />
- <f:Column />
- <f:Column />
- <f:Column />
- <f:Column />
- <f:Column />
- <f:Column />
- <f:Column />
- <f:Column />
- <f:Column />
- </f:Columns>
- <f:Body>
- <f:Cell id="field13" alias="字段13" styleID="9" left="1" right="1" top="1" bottom="1" type="field">
- <f:DesignedCell text="企业未达帐明细.日期" locked="false" />
- <f:Data type="string">entprUnreachedDetails.createDate</f:Data>
- </f:Cell>
- <f:Cell id="field14" alias="字段14" styleID="9" left="2" right="2" top="1" bottom="1" type="field">
- <f:DesignedCell text="企业未达帐明细.摘要" locked="false" />
- <f:Data type="string">entprUnreachedDetails.description</f:Data>
- </f:Cell>
- <f:Cell id="field15" alias="字段15" styleID="9" left="3" right="3" top="1" bottom="1" type="field">
- <f:DesignedCell text="企业未达帐明细.结算方式" locked="false" />
- <f:Data type="string">entprUnreachedDetails.settleType</f:Data>
- </f:Cell>
- <f:Cell id="field16" alias="字段16" styleID="9" left="4" right="4" top="1" bottom="1" type="field">
- <f:DesignedCell text="企业未达帐明细.结算号" locked="false" />
- <f:Data type="string">entprUnreachedDetails.settleNumber</f:Data>
- </f:Cell>
- <f:Cell id="field17" alias="字段17" styleID="8" left="5" right="5" top="1" bottom="1" type="field" format="G/通用格式">
- <f:DesignedCell text="企业未达帐明细.借方金额" locked="false" />
- <f:Data type="string">entprUnreachedDetails.debitAmount</f:Data>
- </f:Cell>
- <f:Cell id="field27" alias="字段27" styleID="11" left="6" right="6" top="1" bottom="1" type="field" format="g/通用格式">
- <f:DesignedCell text="企业未达帐明细.贷方金额" locked="false" />
- <f:Data type="string">entprUnreachedDetails.creditAmount</f:Data>
- </f:Cell>
- <f:Cell id="field19" alias="字段19" styleID="9" left="7" right="7" top="1" bottom="1" type="field">
- <f:DesignedCell text="银行未达帐明细.日期" locked="false" />
- <f:Data type="string">bankUnreachedDetails.createDate</f:Data>
- </f:Cell>
- <f:Cell id="field20" alias="字段20" styleID="9" left="8" right="8" top="1" bottom="1" type="field">
- <f:DesignedCell text="银行未达帐明细.凭证类型" locked="false" />
- <f:Data type="string">bankUnreachedDetails.voucherType</f:Data>
- </f:Cell>
- <f:Cell id="field22" alias="字段22" styleID="9" left="9" right="9" top="1" bottom="1" type="field">
- <f:DesignedCell text="银行未达帐明细.凭证号" locked="false" />
- <f:Data type="string">bankUnreachedDetails.voucherNumber</f:Data>
- </f:Cell>
- <f:Cell id="field21" alias="字段21" styleID="9" left="10" right="10" top="1" bottom="1" type="field">
- <f:DesignedCell text="银行未达帐明细.摘要" locked="false" />
- <f:Data type="string">bankUnreachedDetails.description</f:Data>
- </f:Cell>
- <f:Cell id="field23" alias="字段23" styleID="9" left="11" right="11" top="1" bottom="1" type="field">
- <f:DesignedCell text="银行未达帐明细.结算方式" locked="false" />
- <f:Data type="string">bankUnreachedDetails.settlementType</f:Data>
- </f:Cell>
- <f:Cell id="field24" alias="字段24" styleID="9" left="12" right="12" top="1" bottom="1" type="field">
- <f:DesignedCell text="银行未达帐明细.结算号" locked="false" />
- <f:Data type="string">bankUnreachedDetails.settlementNumber</f:Data>
- </f:Cell>
- <f:Cell id="field25" alias="字段25" styleID="8" left="13" right="13" top="1" bottom="1" type="field" format="#,##0.0000;[Red](#,##0.0000)">
- <f:DesignedCell text="银行未达帐明细.借方金额" locked="false" />
- <f:Data type="string">bankUnreachedDetails.debitAmount</f:Data>
- </f:Cell>
- <f:Cell id="field26" alias="字段26" styleID="8" left="14" right="14" top="1" bottom="1" type="field" format="#,##0.0000;[Red](#,##0.0000)">
- <f:DesignedCell text="银行未达帐明细.贷方金额" locked="false" />
- <f:Data type="string">bankUnreachedDetails.creditAmount</f:Data>
- </f:Cell>
- </f:Body>
- </f:Table>
- </f:Area>
- </f:Panel>
- </f:Area>
- </f:Page>
- </Form>
- <PrintInfo>
- <c:PageSetup>
- <c:PageMargin left="190" right="190" top="250" bottom="250" 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>
|