123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646 |
- <?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 Feb 03 14:46:21 CST 2007</c:Created>
- <c:Company>kingdee.com</c:Company>
- <c:LastModified>Wed Jul 09 14:35:58 CST 2008</c:LastModified>
- <c:Author>null</c:Author>
- </DocInfo>
- <DataSources version="2.0">
- <c:DataSource id="LoanInsteretQuery">
- <c:Reference />
- <c:Params />
- </c:DataSource>
- </DataSources>
- <DataObjects version="1.0">
- <DataObject name="LoanInsteretQuery">
- <CommonQuery name="LoanInsteretQuery">
- <Outputs>
- <Columns>
- <Column name="id" alias="ID" dataType="string" order="0" />
- <Column name="bank.id" alias="金融机构ID" dataType="string" order="0" />
- <Column name="bank.name" alias="金融机构" dataType="string" order="0" />
- <Column name="loanCompany.id" alias="贷款单位ID" dataType="string" order="0" />
- <Column name="loanCompany.name" alias="贷款单位名称" dataType="string" order="0" />
- <Column name="loanBill.number" alias="贷款单编号" dataType="string" order="0" />
- <Column name="currency.id" alias="币别ID" dataType="string" order="0" />
- <Column name="currency.name" alias="币别名称" dataType="string" order="0" />
- <Column name="beginDate" alias="计息开始日" dataType="datetime" order="0" />
- <Column name="endDate" alias="计息结束日" dataType="datetime" order="0" />
- <Column name="days" alias="计息天数" dataType="integer" order="0" />
- <Column name="intRateTypeExpression" alias="利率表示" dataType="string" order="0" />
- <Column name="yearIntRate" alias="利率" dataType="decimal" order="0" />
- <Column name="punishIntType" alias="罚息方式" dataType="string" order="0" />
- <Column name="punishIntRate" alias="罚息率" dataType="decimal" order="0" />
- <Column name="entrys.beginDate" alias="分段利息-计息开始日" dataType="datetime" order="0" />
- <Column name="entrys.endDate" alias="分段利息-计息结束日" dataType="datetime" order="0" />
- <Column name="entrys.days" alias="分段利息-计息天数" dataType="integer" order="0" />
- <Column name="entrys.amount" alias="分段利息-计息本金" dataType="decimal" order="0" />
- <Column name="entrys.yearIntRate" alias="分段利息-利率" dataType="decimal" order="0" />
- <Column name="entrys.interest" alias="分段利息-应计利息" dataType="decimal" order="0" />
- <Column name="entrys.punishInterest" alias="分段利息-应计罚息" dataType="decimal" order="0" />
- <Column name="entrys.id" alias="分段利息-ID" dataType="string" order="0" />
- <Column name="intAccount.id" alias="计息帐户ID" dataType="string" order="0" />
- <Column name="intAccount.name" alias="计息帐户名称" dataType="string" order="0" />
- <Column name="printeExcutor" alias="打印人" dataType="string" order="0" />
- <Column name="currency.precision" alias="精度" dataType="integer" order="0" />
- <Column name="yearIntRateDis" alias="年利率显示" dataType="string" order="0" />
- <Column name="punishIntRateDis" alias="罚息率显示" dataType="string" order="0" />
- <Column name="intAccount.acctNumber" alias="计息帐户帐号" dataType="string" order="0" />
- <Column name="creator.name" alias="制单人" dataType="string" order="0" />
- <Column name="intCalType" alias="类别" dataType="integer" order="0" />
- <Column name="daysOverdue" alias="逾期天数" dataType="integer" order="0" />
- <Column name="unVerifyAmount" alias="未核销金额" dataType="decimal" order="0" />
- <Column name="strikeAmount" alias="已冲账金额" dataType="decimal" order="0" />
- <Column name="accountant.name" alias="会计" dataType="string" order="0" />
- <Column name="description" alias="摘要" dataType="string" order="0" />
- <Column name="entrys.yearIntRateDis" alias.zh_CN=" 分段利率1" alias.en="" alias.zh_TW=" 分段利率" alias="#1" desc.zh_TW="" desc.en="" desc.zh_CN="" desc="#1" dataType="string" order="0" />
- <Column name="interest" alias.zh_CN="应计利息" alias.en="" alias.zh_TW="應計利息" alias="#1" desc.zh_TW="" desc.en="" desc.zh_CN="" desc="#1" dataType="decimal" order="0" />
- <Column name="punishInterest" alias.zh_CN="应计罚息" alias.en="" alias.zh_TW="應計罰息" alias="#1" desc.zh_TW="" desc.en="" desc.zh_CN="" desc="#1" dataType="decimal" order="0" />
- <Column name="punishInterestActual" alias.zh_CN="实计罚息" alias.en="" alias.zh_TW="實計罰息" alias="#1" desc.zh_TW="" desc.en="" desc.zh_CN="" desc="#1" dataType="decimal" order="0" />
- <Column name="interestAcctual" alias.zh_CN="实计利息" alias.en="" alias.zh_TW="實計利息" alias="#1" desc.zh_TW="" desc.en="" desc.zh_CN="" desc="#1" dataType="decimal" order="0" />
- <Column name="interestActual" alias.zh_CN="应计金额" alias.en="" alias.zh_TW="應計金額" alias="#1" desc.zh_TW="" desc.en="" desc.zh_CN="" desc="#1" dataType="decimal" order="0" />
- <Column name="interestToPay" alias.zh_CN="实计金额" alias.en="" alias.zh_TW="實計金額" alias="#1" desc.zh_TW="" desc.en="" desc.zh_CN="" desc="#1" dataType="decimal" order="0" />
- </Columns>
- </Outputs>
- <Query version="1.0" type="bos.query">
- <Columns>
- <Column name="id" alias="ID" dataType="string" />
- <Column name="bank.id" alias="金融机构ID" dataType="string" />
- <Column name="bank.name" alias="金融机构" dataType="string" />
- <Column name="loanCompany.id" alias="贷款单位ID" dataType="string" />
- <Column name="loanCompany.name" alias="贷款单位名称" dataType="string" />
- <Column name="loanBill.number" alias="贷款单编号" dataType="string" />
- <Column name="currency.id" alias="币别ID" dataType="string" />
- <Column name="currency.name" alias="币别名称" dataType="string" />
- <Column name="beginDate" alias="计息开始日" dataType="datetime" />
- <Column name="endDate" alias="计息结束日" dataType="datetime" />
- <Column name="days" alias="计息天数" dataType="integer" />
- <Column name="intRateTypeExpression" alias="利率表示" dataType="string" />
- <Column name="yearIntRate" alias="利率" dataType="decimal" />
- <Column name="punishIntType" alias="罚息方式" dataType="string" />
- <Column name="punishIntRate" alias="罚息率" dataType="decimal" />
- <Column name="entrys.beginDate" alias="分段利息-计息开始日" dataType="datetime" />
- <Column name="entrys.endDate" alias="分段利息-计息结束日" dataType="datetime" />
- <Column name="entrys.days" alias="分段利息-计息天数" dataType="integer" />
- <Column name="entrys.amount" alias="分段利息-计息本金" dataType="decimal" />
- <Column name="entrys.yearIntRate" alias="分段利息-利率" dataType="decimal" />
- <Column name="entrys.interest" alias="分段利息-应计利息" dataType="decimal" />
- <Column name="entrys.punishInterest" alias="分段利息-应计罚息" dataType="decimal" />
- <Column name="entrys.id" alias="分段利息-ID" dataType="string" />
- <Column name="intAccount.id" alias="计息帐户ID" dataType="string" />
- <Column name="intAccount.name" alias="计息帐户名称" dataType="string" />
- <Column name="printeExcutor" alias="打印人" dataType="string" />
- <Column name="currency.precision" alias="精度" dataType="integer" />
- <Column name="yearIntRateDis" alias="年利率显示" dataType="string" />
- <Column name="punishIntRateDis" alias="罚息率显示" dataType="string" />
- <Column name="intAccount.acctNumber" alias="计息帐户帐号" dataType="string" />
- <Column name="creator.name" alias="制单人" dataType="string" />
- <Column name="intCalType" alias="类别" dataType="integer" />
- <Column name="daysOverdue" alias="逾期天数" dataType="integer" />
- <Column name="unVerifyAmount" alias="未核销金额" dataType="decimal" />
- <Column name="strikeAmount" alias="已冲账金额" dataType="decimal" />
- <Column name="accountant.name" alias="会计" dataType="string" />
- <Column name="description" alias="摘要" dataType="string" />
- <Column name="entrys.yearIntRateDis" alias.zh_CN=" 分段利率1" alias.en="" alias.zh_TW=" 分段利率" alias="#1" desc.zh_TW="" desc.en="" desc.zh_CN="" desc="#1" dataType="string" />
- <Column name="interest" alias.zh_CN="应计利息" alias.en="" alias.zh_TW="應計利息" alias="#1" desc.zh_TW="" desc.en="" desc.zh_CN="" desc="#1" dataType="decimal" />
- <Column name="punishInterest" alias.zh_CN="应计罚息" alias.en="" alias.zh_TW="應計罰息" alias="#1" desc.zh_TW="" desc.en="" desc.zh_CN="" desc="#1" dataType="decimal" />
- <Column name="punishInterestActual" alias.zh_CN="实计罚息" alias.en="" alias.zh_TW="實計罰息" alias="#1" desc.zh_TW="" desc.en="" desc.zh_CN="" desc="#1" dataType="decimal" />
- <Column name="interestAcctual" alias.zh_CN="实计利息" alias.en="" alias.zh_TW="實計利息" alias="#1" desc.zh_TW="" desc.en="" desc.zh_CN="" desc="#1" dataType="decimal" />
- <Column name="interestActual" alias.zh_CN="应计金额" alias.en="" alias.zh_TW="應計金額" alias="#1" desc.zh_TW="" desc.en="" desc.zh_CN="" desc="#1" dataType="decimal" />
- <Column name="interestToPay" alias.zh_CN="实计金额" alias.en="" alias.zh_TW="實計金額" alias="#1" desc.zh_TW="" desc.en="" desc.zh_CN="" desc="#1" dataType="decimal" />
- </Columns>
- <Tables />
- <Joins />
- <Orders />
- <Filter />
- <Content><![CDATA[LoanInsterestBill.bos-query]]></Content>
- </Query>
- <EXT />
- </CommonQuery>
- </DataObject>
- </DataObjects>
- <Styles version="1.0">
- <c:Style id="3">
- <c:Font fontName="宋体" size="11" 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="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="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="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:Border position="diagonalleft" lineStyle="NullLine" />
- <c:Border position="diagonalright" lineStyle="NullLine" />
- </c:Borders>
- <c:Interior color="#ffffff00" pattern="None" 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="#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="0">
- <c:Interior color="#ffffff" pattern="Solid" patternColor="#000000" />
- </c:Style>
- <c:Style id="14">
- <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="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>
- <c:Style id="6">
- <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="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="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: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="5">
- <c:Font fontName="宋体" size="22" 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="#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="16">
- <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="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="13">
- <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="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: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="15">
- <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="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="9">
- <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>
- <c:Style id="11">
- <c:Font fontName="宋体" size="15" 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="#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="4">
- <c:Font fontName="宋体" size="11" 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="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="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="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: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="12">
- <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="企业贷款利息单套打模板New.kdrs-form" version="3.1">
- <f:Page id="page1" alias="页1" styleID="0" repeat="-1" dataSourceID="LoanInterestTDQuery.bos-query">
- <f:DesignedPage paperSize="iso-a4" objWidth="1720" objHeight="2470" widthLimitless="false" heightLimitless="false" />
- <f:Area id="loop2" alias="循环区2" styleID="1" left="[page1.left]" right="[loop2.left]+1720.0" top="[page1.top]" bottom="[loop2.top]+1634.0" nextAreaID="loop2">
- <f:DesignedArea leftLocationType="relative" leftRelativeObjID="page1" leftRelativeBorder="left" leftRelativeOffset="0" rightLocationType="relative" rightRelativeObjID="loop2" rightRelativeBorder="left" rightRelativeOffset="1720" topLocationType="relative" topRelativeObjID="page1" topRelativeBorder="top" topRelativeOffset="0" bottomLocationType="relative" bottomRelativeObjID="loop2" bottomRelativeBorder="top" bottomRelativeOffset="1634" locked="false" />
- <f:Panel id="group2" alias="分组容器2" styleID="2" left="[loop2.left]" right="[group2.left]+1720.0" top="[loop2.top]+3.0" bottom="[group2.top]+1356.0" dataSourceID="LoanInsteretQuery">
- <f:DesignedPanel leftLocationType="relative" leftRelativeObjID="loop2" leftRelativeBorder="left" leftRelativeOffset="0" rightLocationType="relative" rightRelativeObjID="group2" rightRelativeBorder="left" rightRelativeOffset="1720" topLocationType="relative" topRelativeObjID="loop2" topRelativeBorder="top" topRelativeOffset="3" bottomLocationType="relative" bottomRelativeObjID="group2" bottomRelativeBorder="top" bottomRelativeOffset="1356" locked="false" />
- <f:Cell id="text5" alias="文本1" styleID="3" left="[group2.left]+620.0" right="[text5.left]+238.0" top="[group2.top]+37.0" bottom="[text5.top]+77.0" type="constant">
- <f:DesignedCell leftLocationType="relative" leftRelativeObjID="group2" leftRelativeBorder="left" leftRelativeOffset="620" rightLocationType="relative" rightRelativeObjID="text5" rightRelativeBorder="left" rightRelativeOffset="238" topLocationType="relative" topRelativeObjID="group2" topRelativeBorder="top" topRelativeOffset="37" bottomLocationType="relative" bottomRelativeObjID="text5" bottomRelativeBorder="top" bottomRelativeOffset="77" locked="false" />
- <f:Data type="string">金融机构 :</f:Data>
- </f:Cell>
- <f:Cell id="field2" alias="字段2" styleID="4" left="[group2.left]+858.0" right="[field2.left]+442.0" top="[group2.top]+37.0" bottom="[field2.top]+77.0" type="field">
- <f:DesignedCell text="金融机构" leftLocationType="relative" leftRelativeObjID="group2" leftRelativeBorder="left" leftRelativeOffset="858" rightLocationType="relative" rightRelativeObjID="field2" rightRelativeBorder="left" rightRelativeOffset="442" topLocationType="relative" topRelativeObjID="group2" topRelativeBorder="top" topRelativeOffset="37" bottomLocationType="relative" bottomRelativeObjID="field2" bottomRelativeBorder="top" bottomRelativeOffset="77" locked="false" />
- <f:Data type="string">bank.name</f:Data>
- </f:Cell>
- <f:Cell id="text6" alias="文本2" styleID="5" left="[group2.left]+416.0" right="[text6.left]+885.0" top="[group2.top]+114.0" bottom="[text6.top]+103.0" type="constant">
- <f:DesignedCell leftLocationType="relative" leftRelativeObjID="group2" leftRelativeBorder="left" leftRelativeOffset="416" rightLocationType="relative" rightRelativeObjID="text6" rightRelativeBorder="left" rightRelativeOffset="885" topLocationType="relative" topRelativeObjID="group2" topRelativeBorder="top" topRelativeOffset="114" bottomLocationType="relative" bottomRelativeObjID="text6" bottomRelativeBorder="top" bottomRelativeOffset="103" locked="false" />
- <f:Data type="string">贷款利息单</f:Data>
- </f:Cell>
- <f:Table id="table4" alias="网格容器4" styleID="6" left="[group2.left]" right="[table4.left]+1719.0" top="[group2.top]+246.0" bottom="[table4.top]+392.0" dataSourceID="LoanInsteretQuery" layout="1">
- <f:DesignedTable layout="heightAuto" leftLocationType="relative" leftRelativeObjID="group2" leftRelativeBorder="left" leftRelativeOffset="0" rightLocationType="relative" rightRelativeObjID="table4" rightRelativeBorder="left" rightRelativeOffset="1719" topLocationType="relative" topRelativeObjID="group2" topRelativeBorder="top" topRelativeOffset="246" bottomLocationType="relative" bottomRelativeObjID="table4" bottomRelativeBorder="top" bottomRelativeOffset="392" locked="false" />
- <f:Rows>
- <f:Row height="78" />
- <f:Row height="78" />
- <f:Row height="78" />
- <f:Row height="79" />
- <f:Row height="79" />
- </f:Rows>
- <f:Columns>
- <f:Column width="265" />
- <f:Column width="380" />
- <f:Column width="265" />
- <f:Column width="380" />
- <f:Column width="230" />
- <f:Column width="199" />
- </f:Columns>
- <f:Body>
- <f:Cell id="text7" alias="文本5" 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="7" left="2" right="2" top="1" bottom="1" type="field">
- <f:DesignedCell text="贷款单位名称" locked="false" />
- <f:Data type="string">loanCompany.name</f:Data>
- </f:Cell>
- <f:Cell id="text8" alias="文本6" styleID="7" 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="field10" alias="字段10" styleID="7" left="4" right="4" top="1" bottom="1" type="field">
- <f:DesignedCell text="计息帐户名称" locked="false" />
- <f:Data type="string">intAccount.name</f:Data>
- </f:Cell>
- <f:Cell id="text9" alias="文本7" styleID="7" 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="field11" alias="字段11" styleID="7" left="6" right="6" top="1" bottom="1" type="field">
- <f:DesignedCell text="币别名称" locked="false" />
- <f:Data type="string">currency.name</f:Data>
- </f:Cell>
- <f:Cell id="text10" alias="文本9" 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="field12" alias="字段12" styleID="7" left="2" right="2" top="2" bottom="2" type="field">
- <f:DesignedCell text="计息开始日" locked="false" />
- <f:Data type="string">beginDate</f:Data>
- </f:Cell>
- <f:Cell id="text11" alias="文本10" styleID="7" 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="field13" alias="字段13" styleID="7" left="4" right="4" top="2" bottom="2" type="field">
- <f:DesignedCell text="计息结束日" locked="false" />
- <f:Data type="string">endDate</f:Data>
- </f:Cell>
- <f:Cell id="text12" alias="文本11" styleID="7" left="5" right="5" top="2" bottom="2" type="constant">
- <f:DesignedCell locked="false" />
- <f:Data type="string">计息天数</f:Data>
- </f:Cell>
- <f:Cell id="field14" alias="字段14" styleID="7" left="6" right="6" top="2" bottom="2" type="field">
- <f:DesignedCell text="计息天数" locked="false" />
- <f:Data type="string">days</f:Data>
- </f:Cell>
- <f:Cell id="text13" alias="文本12" 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="field15" alias="字段15" styleID="7" left="2" right="2" top="3" bottom="3" type="field">
- <f:DesignedCell text="利率表示" locked="false" />
- <f:Data type="string">intRateTypeExpression</f:Data>
- </f:Cell>
- <f:Cell id="text14" alias="文本13" styleID="7" left="3" right="3" top="3" bottom="3" type="constant">
- <f:DesignedCell locked="false" />
- <f:Data type="string">利率</f:Data>
- </f:Cell>
- <f:Cell id="field3" alias="字段3" styleID="8" left="4" right="4" top="3" bottom="3" type="field">
- <f:DesignedCell text="年利率显示" locked="false" />
- <f:Data type="string">yearIntRateDis</f:Data>
- </f:Cell>
- <f:Cell id="text15" alias="文本15" styleID="7" left="5" right="5" top="3" bottom="3" type="constant">
- <f:DesignedCell locked="false" />
- <f:Data type="string">实计利息</f:Data>
- </f:Cell>
- <f:Cell id="field17" alias="字段17" styleID="9" left="6" right="6" top="3" bottom="3" type="field">
- <f:DesignedCell text="实计利息" locked="false" />
- <f:Data type="string">interestAcctual</f:Data>
- </f:Cell>
- <f:Cell id="text18" alias="文本16" 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="field31" alias="字段31" styleID="7" left="2" right="2" top="4" bottom="4" type="field">
- <f:DesignedCell text="罚息方式" locked="false" />
- <f:Data type="string">punishIntType</f:Data>
- </f:Cell>
- <f:Cell id="text19" alias="文本17" styleID="7" left="3" right="3" top="4" bottom="4" type="constant">
- <f:DesignedCell locked="false" />
- <f:Data type="string">罚息率</f:Data>
- </f:Cell>
- <f:Cell id="field1" alias="字段1" styleID="8" left="4" right="4" top="4" bottom="4" type="field">
- <f:DesignedCell text="罚息率显示" locked="false" />
- <f:Data type="string">punishIntRateDis</f:Data>
- </f:Cell>
- <f:Cell id="text20" alias="文本18" styleID="7" left="5" right="5" top="4" bottom="4" type="constant">
- <f:DesignedCell locked="false" />
- <f:Data type="string">实计罚息</f:Data>
- </f:Cell>
- <f:Cell id="field16" alias="字段16" styleID="9" left="6" right="6" top="4" bottom="4" type="field">
- <f:DesignedCell text="实计罚息" locked="false" />
- <f:Data type="string">punishInterestActual</f:Data>
- </f:Cell>
- <f:Cell id="text21" alias="文本19" styleID="7" left="1" right="1" top="5" bottom="5" type="constant">
- <f:DesignedCell locked="false" />
- <f:Data type="string">利息合计(大写)</f:Data>
- </f:Cell>
- <f:Cell id="field18" alias="字段18" styleID="10" left="2" right="4" top="5" bottom="5" type="field">
- <f:DesignedCell text="实计金额" locked="false" />
- <f:Data type="string">interestToPay</f:Data>
- </f:Cell>
- <f:Cell id="text22" alias="文本20" styleID="7" left="5" right="5" top="5" bottom="5" type="constant">
- <f:DesignedCell locked="false" />
- <f:Data type="string">小写</f:Data>
- </f:Cell>
- <f:Cell id="field8" alias="字段8" styleID="9" left="6" right="6" top="5" bottom="5" type="field">
- <f:DesignedCell text="实计金额" locked="false" />
- <f:Data type="string">interestToPay</f:Data>
- </f:Cell>
- </f:Body>
- </f:Table>
- <f:Cell id="text23" alias="文本21" styleID="11" left="[group2.left]+638.0" right="[text23.left]+477.0" top="[group2.top]+685.0" bottom="[text23.top]+93.0" type="constant">
- <f:DesignedCell leftLocationType="relative" leftRelativeObjID="group2" leftRelativeBorder="left" leftRelativeOffset="638" rightLocationType="relative" rightRelativeObjID="text23" rightRelativeBorder="left" rightRelativeOffset="477" topLocationType="relative" topRelativeObjID="group2" topRelativeBorder="top" topRelativeOffset="685" bottomLocationType="relative" bottomRelativeObjID="text23" bottomRelativeBorder="top" bottomRelativeOffset="93" locked="false" />
- <f:Data type="string">分段利息明细</f:Data>
- </f:Cell>
- <f:Table id="table5" alias="网格容器5" styleID="12" left="[group2.left]" right="[table5.left]+1719.0" top="[group2.top]+779.0" bottom="[table5.top]+77.0" dataSourceID="LoanInterestTDQuery.bos-query" groupField="id">
- <f:DesignedTable layout="auto" leftLocationType="relative" leftRelativeObjID="group2" leftRelativeBorder="left" leftRelativeOffset="0" rightLocationType="relative" rightRelativeObjID="table5" rightRelativeBorder="left" rightRelativeOffset="1719" topLocationType="relative" topRelativeObjID="group2" topRelativeBorder="top" topRelativeOffset="779" 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:Columns>
- <f:Body>
- <f:Cell id="text24" alias="文本22" styleID="13" 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="text25" alias="文本23" styleID="13" 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="text26" alias="文本24" styleID="13" 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="text27" alias="文本25" styleID="13" 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="text31" alias="文本26" styleID="13" 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="text32" alias="文本27" styleID="13" 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="text36" alias="文本28" styleID="13" left="7" right="7" 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="loop4" alias="循环区4" styleID="1" left="[group2.left]" right="[loop4.left]+1719.0" top="[group2.top]+855.0" nextAreaID="loop4">
- <f:DesignedArea leftLocationType="relative" leftRelativeObjID="group2" leftRelativeBorder="left" leftRelativeOffset="0" rightLocationType="relative" rightRelativeObjID="loop4" rightRelativeBorder="left" rightRelativeOffset="1719" topLocationType="relative" topRelativeObjID="group2" topRelativeBorder="top" topRelativeOffset="855" bottomLocationType="selfAdapt" bottomRelativeObjID="loop4" bottomRelativeBorder="top" bottomRelativeOffset="337" locked="false" />
- <f:Table id="table7" alias="网格容器7" styleID="6" left="[loop4.left]" right="[table7.left]+1719.0" top="[loop4.top]" bottom="[table7.top]+79.0" dataSourceID="LoanInsteretQuery" layout="1">
- <f:DesignedTable layout="widthAuto" leftLocationType="relative" leftRelativeObjID="loop4" leftRelativeBorder="left" leftRelativeOffset="0" rightLocationType="relative" rightRelativeObjID="table7" rightRelativeBorder="left" rightRelativeOffset="1719" topLocationType="relative" topRelativeObjID="loop4" topRelativeBorder="top" topRelativeOffset="0" bottomLocationType="relative" bottomRelativeObjID="table7" bottomRelativeBorder="top" bottomRelativeOffset="79" locked="false" />
- <f:Rows>
- <f:Row height="0" />
- <f:Row height="79" />
- </f:Rows>
- <f:Columns>
- <f:Column width="*" />
- <f:Column width="*" />
- <f:Column width="*" />
- <f:Column width="*" />
- <f:Column width="*" />
- <f:Column width="*" />
- <f:Column width="*" />
- </f:Columns>
- <f:Body>
- <f:Cell id="field36" alias="字段36" styleID="13" left="1" right="1" top="2" bottom="2" type="field">
- <f:DesignedCell text="分段利息-计息开始日" locked="false" />
- <f:Data type="string">entrys.beginDate</f:Data>
- </f:Cell>
- <f:Cell id="field37" alias="字段37" styleID="13" left="2" right="2" top="2" bottom="2" type="field">
- <f:DesignedCell text="分段利息-计息结束日" locked="false" />
- <f:Data type="string">entrys.endDate</f:Data>
- </f:Cell>
- <f:Cell id="field40" alias="字段40" styleID="13" left="3" right="3" top="2" bottom="2" type="field">
- <f:DesignedCell text="分段利息-计息天数" locked="false" />
- <f:Data type="string">entrys.days</f:Data>
- </f:Cell>
- <f:Cell id="field42" alias="字段42" styleID="13" left="4" right="4" top="2" bottom="2" type="field">
- <f:DesignedCell text="分段利息-计息本金" locked="false" />
- <f:Data type="string">entrys.amount</f:Data>
- </f:Cell>
- <f:Cell id="field43" alias="字段43" styleID="13" left="5" right="5" top="2" bottom="2" type="field">
- <f:DesignedCell text=" 分段利率1" locked="false" />
- <f:Data type="string">entrys.yearIntRateDis</f:Data>
- </f:Cell>
- <f:Cell id="field44" alias="字段44" styleID="13" left="6" right="6" top="2" bottom="2" type="field">
- <f:DesignedCell text="分段利息-应计利息" locked="false" />
- <f:Data type="string">entrys.interest</f:Data>
- </f:Cell>
- <f:Cell id="field45" alias="字段45" styleID="13" left="7" right="7" top="2" bottom="2" type="field" format="G/通用格式">
- <f:DesignedCell text="分段利息-应计罚息" locked="false" />
- <f:Data type="string">entrys.punishInterest</f:Data>
- </f:Cell>
- </f:Body>
- </f:Table>
- </f:Area>
- <f:Table id="table9" alias="网格容器9" styleID="6" left="[group2.left]" right="[table9.left]+1719.0" top="[loop4.bottom]" bottom="[table9.top]+64.0" dataSourceID="LoanInsteretQuery" layout="1">
- <f:DesignedTable layout="heightAuto" leftLocationType="relative" leftRelativeObjID="group2" leftRelativeBorder="left" leftRelativeOffset="0" rightLocationType="relative" rightRelativeObjID="table9" rightRelativeBorder="left" rightRelativeOffset="1719" topLocationType="relative" topRelativeObjID="loop4" topRelativeBorder="bottom" topRelativeOffset="0" bottomLocationType="relative" bottomRelativeObjID="table9" bottomRelativeBorder="top" bottomRelativeOffset="64" locked="false" />
- <f:Rows>
- <f:Row height="64" />
- </f:Rows>
- <f:Columns>
- <f:Column width="265" />
- <f:Column width="380" />
- <f:Column width="265" />
- <f:Column width="380" />
- <f:Column width="230" />
- <f:Column width="199" />
- </f:Columns>
- <f:Body>
- <f:Cell id="text51" alias="文本29" styleID="14" 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="formula2" alias="公式2" styleID="15" left="2" right="4" top="1" bottom="1" type="formula" format="yyyy-m-d">
- <f:DesignedCell locked="false" />
- <f:Data type="string">NOW()</f:Data>
- </f:Cell>
- <f:Cell id="text52" alias="文本30" styleID="14" 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="field46" alias="字段46" styleID="16" left="6" right="6" top="1" bottom="1" type="field">
- <f:DesignedCell text="打印人" locked="false" />
- <f:Data type="string">printeExcutor</f:Data>
- </f:Cell>
- </f:Body>
- </f:Table>
- </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>PORTRAIT</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>
|