123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542 |
- <DocRoot>
- <Parameters />
- <DataSources>
- <Reference name="RepaymentTDQuery" alias.zh_CN="还款单" alias="#1" desc.zh_CN="基础单据查询模板 " desc="#1" info="::/com/kingdee/eas/fm/fin/app/RepaymentTDQuery.bos-query" />
- </DataSources>
- <Styles version="1.0">
- <Style id="3">
- <Borders>
- <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000" />
- <Border position="top" lineStyle="Single" penStyle="Solid" color="#000000" />
- <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000" />
- <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000" />
- </Borders>
- <NumberFormat>#,##0.00;-#,##0.00</NumberFormat>
- </Style>
- <Style id="2">
- <Borders>
- <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000" />
- <Border position="top" lineStyle="Single" penStyle="Solid" color="#000000" />
- <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000" />
- <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000" />
- </Borders>
- </Style>
- <Style id="1" />
- <Style id="0">
- <Font fontName="宋体" size="14" color="#000000" bold="false" underline="false" italic="false" strikethrough="false" weight="400.0" />
- <Borders>
- <Border position="left" lineStyle="NullLine" />
- <Border position="top" lineStyle="NullLine" />
- <Border position="right" lineStyle="NullLine" />
- <Border position="bottom" lineStyle="NullLine" />
- <Border position="diagonalleft" lineStyle="NullLine" />
- <Border position="diagonalright" lineStyle="NullLine" />
- </Borders>
- <Interior color="#ffffff00" pattern="None" patternColor="#000000" />
- <Alignment horizontal="center" vertical="middle" wrapText="false" rotate="0" shrink="false" lineSpace="0.0" padding="1,1,1,1" clip="true" />
- <Protection hidden="false" locked="false" />
- </Style>
- <Style id="7">
- <NumberFormat>g/通用格式</NumberFormat>
- </Style>
- <Style id="6">
- <Borders>
- <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000" />
- <Border position="top" lineStyle="Single" penStyle="Solid" color="#000000" />
- <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000" />
- <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000" />
- </Borders>
- <Alignment wrapText="true" />
- </Style>
- <Style id="5">
- <Borders>
- <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000" />
- <Border position="top" lineStyle="Single" penStyle="Solid" color="#000000" />
- <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000" />
- <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000" />
- </Borders>
- <NumberFormat>G/通用格式</NumberFormat>
- </Style>
- <Style id="4">
- <Borders>
- <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000" />
- <Border position="top" lineStyle="Single" penStyle="Solid" color="#000000" />
- <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000" />
- <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000" />
- </Borders>
- <NumberFormat>0.00;-0.00</NumberFormat>
- </Style>
- <Style id="9">
- <Borders>
- <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000" />
- <Border position="top" lineStyle="Single" penStyle="Solid" color="#000000" />
- <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000" />
- <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000" />
- </Borders>
- <NumberFormat>g/通用格式</NumberFormat>
- </Style>
- <Style id="8">
- <Borders>
- <Border position="left" lineStyle="Single" penStyle="Solid" color="#000000" />
- <Border position="top" lineStyle="Single" penStyle="Solid" color="#000000" />
- <Border position="right" lineStyle="Single" penStyle="Solid" color="#000000" />
- <Border position="bottom" lineStyle="Single" penStyle="Solid" color="#000000" />
- </Borders>
- <Alignment wrapText="true" />
- <NumberFormat>g/通用格式</NumberFormat>
- </Style>
- </Styles>
- <Report type="r1-print" version="7.0.1">
- <Page id="page1" width="1720" height="2470">
- <Sub-objects>
- <Text id="text1" styleId="0" x="525" y="43" width="625" height="82">
- <Data><![CDATA[还款]]></Data>
- </Text>
- <PrintDataGrid id="dataGrid2" styleId="1" x="0" y="134" horizontalFill="true">
- <Data dataSource="CreditLimitTDQuery" />
- <Col width="224" id="column11" styleId="1" />
- <Col width="222" id="column5" styleId="1" />
- <Col width="244" id="column6" styleId="1" />
- <Col width="249" id="column7" styleId="1" />
- <Col width="269" id="column8" styleId="1" />
- <Col width="234" id="column15" />
- <Col width="278" id="column9" styleId="1" />
- <TR height="1924" type="normal" displayEveryPage="true" id="row16" styleId="1">
- <TD id="cell67" styleId="2">
- <Sub-objects>
- <PrintLayoutGrid id="layoutGrid2" styleId="1" x="0" y="1" horizontalFill="true">
- <Data />
- <Col width="349" id="column10" />
- <Col width="495" id="column1" />
- <Col width="357" id="column2" />
- <Col width="517" id="column3" />
- <TR height="70" id="row17" styleId="1">
- <TD id="cell73" styleId="2">
- <Value type="text"><![CDATA[编号]]></Value>
- </TD>
- <TD id="cell1" styleId="2">
- <Value type="field" dataSource="RepaymentTDQuery">number</Value>
- </TD>
- <TD id="cell2" styleId="2">
- <Value type="text"><![CDATA[融资机构]]></Value>
- </TD>
- <TD id="cell3" styleId="2">
- <Script><![CDATA[setValue(getValue()?"是":"否")]]></Script>
- <Value type="field" dataSource="RepaymentTDQuery">Creditor.name</Value>
- </TD>
- </TR>
- <TR height="70" id="row8" styleId="1">
- <TD id="cell25" styleId="2">
- <Value type="text"><![CDATA[对方科目]]></Value>
- </TD>
- <TD id="cell26" styleId="2">
- <Value type="field" dataSource="RepaymentTDQuery">LoanAcct.name</Value>
- </TD>
- <TD id="cell27" styleId="2">
- <Value type="text"><![CDATA[利息费用科目]]></Value>
- </TD>
- <TD id="cell47" styleId="2">
- <Value type="field" dataSource="RepaymentTDQuery">InterestAcct.name</Value>
- </TD>
- </TR>
- <TR height="70" id="row1" styleId="1">
- <TD id="cell40" styleId="2">
- <Value type="text"><![CDATA[还款日期]]></Value>
- </TD>
- <TD id="cell4" styleId="2">
- <Value type="field" dataSource="RepaymentTDQuery">bizDate</Value>
- </TD>
- <TD id="cell5" styleId="2">
- <Value type="text"><![CDATA[单据类型]]></Value>
- </TD>
- <TD id="cell6" styleId="2">
- <Value type="field" dataSource="RepaymentTDQuery">SourceType</Value>
- </TD>
- </TR>
- <TR height="70" id="row2" styleId="1">
- <TD id="cell41" styleId="2">
- <Value type="text"><![CDATA[还款序号]]></Value>
- </TD>
- <TD id="cell7" styleId="2">
- <Value type="field" dataSource="RepaymentTDQuery">repaySeq</Value>
- </TD>
- <TD id="cell8" styleId="2">
- <Value type="text"><![CDATA[源单编号]]></Value>
- </TD>
- <TD id="cell9" styleId="2">
- <Value type="field" dataSource="RepaymentTDQuery">SourceBillNum</Value>
- </TD>
- </TR>
- <TR height="70" id="row3" styleId="1">
- <TD id="cell42" styleId="2">
- <Value type="text"><![CDATA[币别]]></Value>
- </TD>
- <TD id="cell10" styleId="2">
- <Value type="field" dataSource="RepaymentTDQuery">Currency.name</Value>
- </TD>
- <TD id="cell11" styleId="2">
- <Value type="text"><![CDATA[折本位币汇率]]></Value>
- </TD>
- <TD id="cell12" styleId="3">
- <Value type="field" dataSource="RepaymentTDQuery">LocalCurExRate</Value>
- </TD>
- </TR>
- <TR height="70" id="row4" styleId="1">
- <TD id="cell43" styleId="2">
- <Value type="text"><![CDATA[还款金额]]></Value>
- </TD>
- <TD id="cell13" styleId="4">
- <Value type="field" dataSource="RepaymentTDQuery">SourceAmount</Value>
- </TD>
- <TD id="cell14" styleId="2">
- <Value type="text"><![CDATA[折本位币]]></Value>
- </TD>
- <TD id="cell15" styleId="3">
- <Value type="field" dataSource="RepaymentTDQuery">LocalAmount</Value>
- </TD>
- </TR>
- <TR height="70" id="row5" styleId="1">
- <TD id="cell44" styleId="2">
- <Value type="text"><![CDATA[源单币别]]></Value>
- </TD>
- <TD id="cell16" styleId="3">
- <Value type="field" dataSource="RepaymentTDQuery">SourceCurrency.name</Value>
- </TD>
- <TD id="cell17" styleId="2">
- <Value type="text"><![CDATA[折源单币别汇率]]></Value>
- </TD>
- <TD id="cell18" styleId="5">
- <Value type="field" dataSource="RepaymentTDQuery">SourceCurExRate</Value>
- </TD>
- </TR>
- <TR height="70" id="row6" styleId="1">
- <TD id="cell45" styleId="2">
- <Value type="text"><![CDATA[折源单币别还款金额]]></Value>
- </TD>
- <TD id="cell19" styleId="3">
- <Value type="field" dataSource="RepaymentTDQuery">Amount</Value>
- </TD>
- <TD id="cell20" styleId="2">
- <Value type="text"><![CDATA[保证金金额]]></Value>
- </TD>
- <TD id="cell21" styleId="5">
- <Value type="field" dataSource="RepaymentTDQuery">marginBalance</Value>
- </TD>
- </TR>
- <TR height="70" id="row7" styleId="1">
- <TD id="cell46" styleId="2">
- <Value type="text"><![CDATA[保证金账户]]></Value>
- </TD>
- <TD id="cell22" styleId="4">
- <Value type="field" dataSource="RepaymentTDQuery">acutionAcctBank.name</Value>
- </TD>
- <TD id="cell23" styleId="2">
- <Value type="text"><![CDATA[其中:保证金还款]]></Value>
- </TD>
- <TD id="cell24" styleId="2">
- <Value type="field" dataSource="RepaymentTDQuery">cautionAmt</Value>
- </TD>
- </TR>
- <TR height="70" id="row9" styleId="1">
- <TD id="cell48" styleId="2">
- <Value type="text"><![CDATA[保证金币别]]></Value>
- </TD>
- <TD id="cell28" styleId="2">
- <Value type="field" dataSource="RepaymentTDQuery">marginCurrency.name</Value>
- </TD>
- <TD id="cell29" styleId="2">
- <Value type="text"><![CDATA[付款账户]]></Value>
- </TD>
- <TD id="cell30" styleId="2">
- <Script><![CDATA[setValue(getValue()?"是":"否")]]></Script>
- <Value type="field" dataSource="RepaymentTDQuery">BankAcct.name</Value>
- </TD>
- </TR>
- <TR height="70" id="row11" styleId="1">
- <TD id="cell37" styleId="2">
- <Value type="text"><![CDATA[收款单位]]></Value>
- </TD>
- <TD id="cell38" styleId="2">
- <Value type="field" dataSource="RepaymentTDQuery">payeeName</Value>
- </TD>
- <TD id="cell39" styleId="2">
- <Value type="text"><![CDATA[累计已还金额]]></Value>
- </TD>
- <TD id="cell50" styleId="2">
- <Value type="field" dataSource="RepaymentTDQuery">addAmount</Value>
- </TD>
- </TR>
- <TR height="70" id="row18" styleId="1">
- <TD id="cell77" styleId="2">
- <Value type="text"><![CDATA[总额]]></Value>
- </TD>
- <TD id="cell78" styleId="2">
- <Value type="field" dataSource="RepaymentTDQuery">SourceAmount</Value>
- </TD>
- <TD id="cell79" styleId="2">
- <Value type="text"><![CDATA[利息费用科目]]></Value>
- </TD>
- <TD id="cell80" styleId="2">
- <Value type="field" dataSource="RepaymentTDQuery">InterestAcct.name</Value>
- </TD>
- </TR>
- <TR height="70" id="row19" styleId="1">
- <TD id="cell81" styleId="2">
- <Value type="text"><![CDATA[利息]]></Value>
- </TD>
- <TD id="cell82" styleId="2">
- <Value type="field" dataSource="RepaymentTDQuery">Interest</Value>
- </TD>
- <TD id="cell83" styleId="2">
- <Value type="text"><![CDATA[内部账户]]></Value>
- </TD>
- <TD id="cell84" styleId="2">
- <Value type="field" dataSource="RepaymentTDQuery">InnerAccount.Name</Value>
- </TD>
- </TR>
- <TR height="70" id="row20" styleId="1">
- <TD id="cell85" styleId="2">
- <Value type="text"><![CDATA[本息合计]]></Value>
- </TD>
- <TD id="cell86" styleId="2">
- <Value type="field" dataSource="RepaymentTDQuery">Payment</Value>
- </TD>
- <TD id="cell87" styleId="2">
- <Value type="text"><![CDATA[到期日期]]></Value>
- </TD>
- <TD id="cell88" styleId="2">
- <Value type="field" dataSource="RepaymentTDQuery">loan.ExpiredDate</Value>
- </TD>
- </TR>
- <TR height="70" id="row21" styleId="1">
- <TD id="cell89" styleId="2">
- <Value type="text"><![CDATA[开始日期]]></Value>
- </TD>
- <TD id="cell90" styleId="2">
- <Value type="field" dataSource="RepaymentTDQuery">loan.IssueDate</Value>
- </TD>
- <TD id="cell91" styleId="2">
- <Value type="text"><![CDATA[利率表式]]></Value>
- </TD>
- <TD id="cell92" styleId="2">
- <Value type="field" dataSource="RepaymentTDQuery">loan.intRateTypeExpression</Value>
- </TD>
- </TR>
- <TR height="70" id="row22" styleId="1">
- <TD id="cell93" styleId="2">
- <Value type="text"><![CDATA[借款天数]]></Value>
- </TD>
- <TD id="cell94" styleId="2">
- <Value type="field" dataSource="RepaymentTDQuery">days</Value>
- </TD>
- <TD id="cell95" styleId="2">
- <Value type="text"><![CDATA[预算项目]]></Value>
- </TD>
- <TD id="cell96" styleId="2">
- <Value type="field" dataSource="RepaymentTDQuery">outBgItemName</Value>
- </TD>
- </TR>
- <TR height="70" id="row10" styleId="1">
- <TD id="cell31" styleId="2">
- <Value type="text"><![CDATA[计划项目]]></Value>
- </TD>
- <TD id="cell32" styleId="2">
- <Value type="field" dataSource="RepaymentTDQuery">fpItem.name</Value>
- </TD>
- <TD id="cell33" styleId="2">
- <Value type="text"><![CDATA[是否履约]]></Value>
- </TD>
- <TD id="cell34" styleId="2">
- <Script><![CDATA[setValue(getValue()?"是":"否")]]></Script>
- <Value type="field" dataSource="RepaymentTDQuery">isPerformanced</Value>
- </TD>
- </TR>
- <TR height="70" id="row23" styleId="1">
- <TD id="cell97" styleId="2">
- <Value type="text"><![CDATA[利率]]></Value>
- </TD>
- <TD id="cell98" styleId="2">
- <Value type="field" dataSource="RepaymentTDQuery">intRate</Value>
- </TD>
- <TD id="cell99" styleId="2">
- <Value type="text"><![CDATA[核销单号]]></Value>
- </TD>
- <TD id="cell100" styleId="2">
- <Value type="field" dataSource="RepaymentTDQuery">hxdNumber</Value>
- </TD>
- </TR>
- <TR height="70" id="row24" styleId="1">
- <TD id="cell101" styleId="2">
- <Value type="text"><![CDATA[成本中心]]></Value>
- </TD>
- <TD id="cell102" styleId="2">
- <Value type="field" dataSource="RepaymentTDQuery">costCenter.name</Value>
- </TD>
- <TD id="cell103" styleId="2">
- <Value type="text"><![CDATA[项目]]></Value>
- </TD>
- <TD id="cell104" styleId="2">
- <Value type="field" dataSource="RepaymentTDQuery">project.name</Value>
- </TD>
- </TR>
- <TR height="70" id="row25" styleId="1">
- <TD id="cell105" styleId="2">
- <Value type="text"><![CDATA[计算利息]]></Value>
- </TD>
- <TD id="cell106" styleId="2">
- <Script><![CDATA[setValue(getValue()?"是":"否")]]></Script>
- <Value type="field" dataSource="RepaymentTDQuery">isCalInt</Value>
- </TD>
- <TD id="cell107" styleId="2">
- <Value type="text"><![CDATA[还本付息]]></Value>
- </TD>
- <TD id="cell108" styleId="2">
- <Script><![CDATA[setValue(getValue()?"是":"否")]]></Script>
- <Value type="field" dataSource="RepaymentTDQuery">isRepayInt</Value>
- </TD>
- </TR>
- <TR height="70" id="row26" styleId="1">
- <TD id="cell109" styleId="2">
- <Value type="text"><![CDATA[计算罚息]]></Value>
- </TD>
- <TD id="cell110" styleId="2">
- <Script><![CDATA[setValue(getValue()?"是":"否")]]></Script>
- <Value type="field" dataSource="RepaymentTDQuery">isCalPunishInt</Value>
- </TD>
- <TD id="cell111" styleId="2">
- <Value type="text"><![CDATA[备案表号]]></Value>
- </TD>
- <TD id="cell112" styleId="2">
- <Value type="field" dataSource="RepaymentTDQuery">babNumber</Value>
- </TD>
- </TR>
- <TR height="70" id="row27" styleId="1">
- <TD id="cell113" styleId="2">
- <Value type="text"><![CDATA[额度内]]></Value>
- </TD>
- <TD id="cell114" styleId="2">
- <Script><![CDATA[setValue(getValue()?"是":"否")]]></Script>
- <Value type="field" dataSource="RepaymentTDQuery">isIncredit</Value>
- </TD>
- <TD id="cell115" styleId="2">
- <Value type="text"><![CDATA[授信额度]]></Value>
- </TD>
- <TD id="cell116" styleId="2">
- <Value type="field" dataSource="RepaymentTDQuery">CreditLimit.number</Value>
- </TD>
- </TR>
- <TR height="70" id="row30" styleId="1">
- <TD id="cell129" styleId="2">
- <Value type="text"><![CDATA[授信币别]]></Value>
- </TD>
- <TD id="cell130" styleId="2">
- <Value type="field" dataSource="RepaymentTDQuery">CreditCurrency.name</Value>
- </TD>
- <TD id="cell131" styleId="2">
- <Value type="text"><![CDATA[折授信币别汇率]]></Value>
- </TD>
- <TD id="cell132" styleId="2">
- <Value type="field" dataSource="RepaymentTDQuery">CreditCurExRate</Value>
- </TD>
- </TR>
- <TR height="70" id="row29" styleId="1">
- <TD id="cell125" styleId="2">
- <Value type="text"><![CDATA[授信比例(%)]]></Value>
- </TD>
- <TD id="cell126" styleId="2">
- <Value type="field" dataSource="RepaymentTDQuery">creditPercetage</Value>
- </TD>
- <TD id="cell127" styleId="2">
- <Value type="text"><![CDATA[返还额度]]></Value>
- </TD>
- <TD id="cell128" styleId="2">
- <Value type="field" dataSource="RepaymentTDQuery">ReturnedQuota</Value>
- </TD>
- </TR>
- <TR height="70" id="row12" styleId="1">
- <TD id="cell35" styleId="2">
- <Value type="text"><![CDATA[备注]]></Value>
- </TD>
- <TD id="cell36" styleId="6">
- <Value type="field" dataSource="RepaymentTDQuery">description</Value>
- </TD>
- <TD id="cell49" styleId="1" />
- <TD id="cell51" styleId="1" />
- </TR>
- <TR height="70" id="row28" styleId="1">
- <TD id="cell121" styleId="2">
- <Value type="text"><![CDATA[制单人]]></Value>
- </TD>
- <TD id="cell122" styleId="2">
- <Value type="field" dataSource="RepaymentTDQuery">creator.name</Value>
- </TD>
- <TD id="cell123" styleId="2">
- <Value type="text"><![CDATA[组织]]></Value>
- </TD>
- <TD id="cell124" styleId="6">
- <Value type="field" dataSource="RepaymentTDQuery">company.name</Value>
- </TD>
- </TR>
- <TR height="50" id="row13">
- <TD id="cell52" styleId="2">
- <Value type="text"><![CDATA[审批人]]></Value>
- </TD>
- <TD id="cell53" styleId="2">
- <Value type="field" dataSource="RepaymentTDQuery">auditor.name</Value>
- </TD>
- <TD id="cell54" />
- <TD id="cell61" />
- </TR>
- <MergeBlocks>
- <Block left="1" right="3" top="24" bottom="24" />
- </MergeBlocks>
- </PrintLayoutGrid>
- </Sub-objects>
- </TD>
- <TD id="cell68" styleId="2" />
- <TD id="cell69" styleId="2" />
- <TD id="cell70" styleId="2" />
- <TD id="cell71" styleId="2" />
- <TD id="cell117" styleId="1" />
- <TD id="cell72" styleId="2" />
- </TR>
- <TR height="2" type="detail" id="row14" styleId="7">
- <TD id="cell55" styleId="8" />
- <TD id="cell56" styleId="8" />
- <TD id="cell57" styleId="8">
- <Script><![CDATA[if(getValue()=="true"){
- setValue("同意")
- }
- if(getValue()=="false"){
- setValue("不同意")
- }]]></Script>
- </TD>
- <TD id="cell58" styleId="8" />
- <TD id="cell59" styleId="8" />
- <TD id="cell119" styleId="9" />
- <TD id="cell60" styleId="8" />
- </TR>
- <MergeBlocks>
- <Block left="0" right="6" top="0" bottom="0" />
- </MergeBlocks>
- </PrintDataGrid>
- </Sub-objects>
- </Page>
- </Report>
- <PrintInfo>
- <PaperSetup>
- <Paper>iso-a4</Paper>
- <Orientation>PORTRAIT</Orientation>
- <PageMargin left="190" right="190" top="250" bottom="250" />
- <Header height="150" margin="100" />
- <Footer height="150" margin="100" />
- </PaperSetup>
- <PrinterSetup>
- <DynamicPaper>false</DynamicPaper>
- <EconomizePaper isVerEconomizePaper="false" verSpace="0" isHorEconomizePaper="false" horSpace="0" />
- </PrinterSetup>
- <PreviewSetup>
- <BackgroundPicture>false</BackgroundPicture>
- </PreviewSetup>
- </PrintInfo>
- </DocRoot>
|