[原创]用友公式EXCEL 中做.我做的VBA

sunyujie

<p>还可以查询明细帐</p><br/>

[此贴子已经被作者于2007-12-31 20:02:25编辑过]

wayy

没见附件呀，老兄。[em07]

hai

[em01]

7dong502

<p>小黑?</p><p>一大失误哦.</p>

学良

<p>等等吧！</p><p>楼主可不要发一个附件用两年的时间哦！</p>

一剑惊心

看看

sunyujie

<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 28.5pt; mso-char-indent-count: 1.9;"><span lang="EN-US" style="FONT-SIZE: 15pt;"><font face="Times New Roman">Excel</font></span><span style="FONT-SIZE: 15pt; FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">报表助手是为了方便做报表而设计的，他将</span><span lang="EN-US" style="FONT-SIZE: 15pt;"><font face="Times New Roman">Excel</font></span><span style="FONT-SIZE: 15pt; FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">强大的制表功能和</span><span lang="EN-US" style="FONT-SIZE: 15pt;"><font face="Times New Roman">U8</font></span><span style="FONT-SIZE: 15pt; FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">取数公式的方便快捷结合起来，能够在极短的时间内设计制作报表模板并自动快速生成报表。他有以下几个优点：</span><span lang="EN-US" style="FONT-SIZE: 15pt;"><p></p></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 45pt; TEXT-INDENT: -36pt; mso-list: l0 level1 lfo1; tab-stops: list 45.0pt;"><span lang="EN-US" style="FONT-SIZE: 15pt; mso-fareast-font-family: &quot;Times New Roman&quot;;"><span style="mso-list: Ignore;"><font face="Times New Roman">1、<span style="FONT: 7pt &quot;Times New Roman&quot;;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></font></span></span><span style="FONT-SIZE: 15pt; FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">结合</span><span lang="EN-US" style="FONT-SIZE: 15pt;"><font face="Times New Roman">Excel</font></span><span style="FONT-SIZE: 15pt; FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">强大的制表功能，能够适用于各种报表。</span><span lang="EN-US" style="FONT-SIZE: 15pt;"><p></p></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 45pt; TEXT-INDENT: -36pt; mso-list: l0 level1 lfo1; tab-stops: list 45.0pt;"><span lang="EN-US" style="FONT-SIZE: 15pt; mso-fareast-font-family: &quot;Times New Roman&quot;;"><span style="mso-list: Ignore;"><font face="Times New Roman">2、<span style="FONT: 7pt &quot;Times New Roman&quot;;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></font></span></span><span style="FONT-SIZE: 15pt; FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">取数公式简洁。比如</span><span lang="EN-US" style="FONT-SIZE: 15pt;"><font face="Times New Roman">5</font></span><span style="FONT-SIZE: 15pt; FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">月现金的期末余额公式为</span><span lang="EN-US" style="FONT-SIZE: 15pt;"><font face="Times New Roman">=QME1(5,1001)</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 45pt; TEXT-INDENT: -36pt; mso-list: l0 level1 lfo1; tab-stops: list 45.0pt;"><span lang="EN-US" style="FONT-SIZE: 15pt;"><font face="Times New Roman"><span lang="EN-US" style="FONT-SIZE: 15pt; FONT-FAMILY: &quot;Times New Roman&quot;; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;"><shapetype id="_x0000_t75" stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" opreferrelative="t" ospt="75" coordsize="21600,21600">&nbsp;<stroke joinstyle="miter"></stroke><formulas><f eqn="if lineDrawn pixelLineWidth 0"></f><f eqn="sum @0 1 0"></f><f eqn="sum 0 0 @1"></f><f eqn="prod @2 1 2"></f><f eqn="prod @3 21600 pixelWidth"></f><f eqn="prod @3 21600 pixelHeight"></f><f eqn="sum @0 0 1"></f><f eqn="prod @6 1 2"></f><f eqn="prod @7 21600 pixelWidth"></f><f eqn="sum @8 21600 0"></f><f eqn="prod @7 21600 pixelHeight"></f><f eqn="sum @10 21600 0"></f></formulas><path gradientshapeok="t"></path><lock aspectratio="t" vext="edit"></lock></shapetype><shape id="_x0000_i1025" type="#_x0000_t75" style="WIDTH: 351.75pt; HEIGHT: 236.25pt;"><imagedata otitle="1" src="file:///C:\DOCUME~1\syj\LOCALS~1\Temp\msohtml1\01\clip_image001.gif"></imagedata></shape></span><p></p></font></span></p>

sunyujie

<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 45pt; TEXT-INDENT: -36pt; mso-list: l0 level1 lfo1; tab-stops: list 45.0pt;"><span lang="EN-US" style="FONT-SIZE: 15pt; mso-fareast-font-family: &quot;Times New Roman&quot;;"><span style="mso-list: Ignore;"><font face="Times New Roman">1、<span style="FONT: 7pt &quot;Times New Roman&quot;;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></font></span></span><span style="FONT-SIZE: 15pt; FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">这样大大提高了报表模板的适用性和制作速度。</span><span lang="EN-US" style="FONT-SIZE: 15pt;"><p></p></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 45pt; TEXT-INDENT: -36pt; mso-list: l0 level1 lfo1; tab-stops: list 45.0pt;"><span lang="EN-US" style="FONT-SIZE: 15pt; mso-fareast-font-family: &quot;Times New Roman&quot;;"><span style="mso-list: Ignore;"><font face="Times New Roman">2、<span style="FONT: 7pt &quot;Times New Roman&quot;;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></font></span></span><span style="FONT-SIZE: 15pt; FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">取数速度快。采用了缓存技术优化代码大大提高了取数速度</span><span lang="EN-US" style="FONT-SIZE: 15pt;"><font face="Times New Roman">.<p></p></font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 45pt; TEXT-INDENT: -36pt; mso-list: l0 level1 lfo1; tab-stops: list 45.0pt;"><span lang="EN-US" style="FONT-SIZE: 15pt; mso-fareast-font-family: &quot;Times New Roman&quot;;"><span style="mso-list: Ignore;"><font face="Times New Roman">3、<span style="FONT: 7pt &quot;Times New Roman&quot;;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></font></span></span><span style="FONT-SIZE: 15pt; FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">设计了财务报表的一些实用公式，比如有的科目需要重分类后进入报表的不同数据项，于是设计了重分类公式比如</span><span lang="EN-US" style="FONT-SIZE: 15pt;"><font face="Times New Roman">QMDFE1(</font></span><span style="FONT-SIZE: 15pt; FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">期末贷方额</span><span lang="EN-US" style="FONT-SIZE: 15pt;"><font face="Times New Roman">)</font></span><span style="FONT-SIZE: 15pt; FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">、</span><span lang="EN-US" style="FONT-SIZE: 15pt;"><font face="Times New Roman">QMJFE1</font></span><span style="FONT-SIZE: 15pt; FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">（期末借方额）。</span><span style="FONT-SIZE: 15pt;"><font face="Times New Roman"> </font></span><span style="FONT-SIZE: 15pt; FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">根据科目的辅助项</span><span lang="EN-US" style="FONT-SIZE: 15pt;"><font face="Times New Roman">(</font></span><span style="FONT-SIZE: 15pt; FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">客户或供应商</span><span lang="EN-US" style="FONT-SIZE: 15pt;"><font face="Times New Roman">)</font></span><span style="FONT-SIZE: 15pt; FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">来重新进行分类</span><span lang="EN-US" style="FONT-SIZE: 15pt;"><font face="Times New Roman">.<p></p></font></span></p><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center;"><span lang="EN-US" style="FONT-SIZE: 15pt;"><p><font face="Times New Roman">&nbsp;</font></p></span></p>

sunyujie

<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><b style="mso-bidi-font-weight: normal;"><span lang="EN-US" style="FONT-SIZE: 15pt;"><font face="Times New Roman">2</font></span></b><b style="mso-bidi-font-weight: normal;"><span style="FONT-SIZE: 15pt; FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">、设置服务器连接参数</span></b><b style="mso-bidi-font-weight: normal;"><span lang="EN-US" style="FONT-SIZE: 15pt;"><p></p></span></b></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><b style="mso-bidi-font-weight: normal;"><span lang="EN-US" style="FONT-SIZE: 15pt;"><p><font face="Times New Roman">&nbsp;</font></p></span></b></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><b style="mso-bidi-font-weight: normal;"><span style="FONT-SIZE: 15pt; FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">数据库服务器名称或</span></b><b style="mso-bidi-font-weight: normal;"><span lang="EN-US" style="FONT-SIZE: 15pt;"><font face="Times New Roman">IP</font></span></b><b style="mso-bidi-font-weight: normal;"><span style="FONT-SIZE: 15pt; FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">地址</span></b><b style="mso-bidi-font-weight: normal;"><span lang="EN-US" style="FONT-SIZE: 15pt;"><p></p></span></b></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><b style="mso-bidi-font-weight: normal;"><span style="FONT-SIZE: 15pt; FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">用户为数据库</span></b><b style="mso-bidi-font-weight: normal;"><span lang="EN-US" style="FONT-SIZE: 15pt;"><font face="Times New Roman"> SA<p></p></font></span></b></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><b style="mso-bidi-font-weight: normal;"><span style="FONT-SIZE: 15pt; FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">密码为数据库密码，一般为空</span></b><b style="mso-bidi-font-weight: normal;"><span lang="EN-US" style="FONT-SIZE: 15pt;"><p></p></span></b></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><b style="mso-bidi-font-weight: normal;"><span lang="EN-US" style="FONT-SIZE: 15pt;"><p><font face="Times New Roman">&nbsp;</font></p></span></b></p>

sunyujie

<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-SIZE: 15pt; FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">公式一览表</span><span lang="EN-US" style="FONT-SIZE: 15pt;"><p></p></span></p><p style="MARGIN: 0cm 0cm 0pt;"><table class="MsoNormalTable" cellspacing="0" cellpadding="0" width="585" border="0" style="MARGIN: auto auto auto 4.65pt; WIDTH: 439pt; BORDER-COLLAPSE: collapse; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt;"><tbody><tr style="HEIGHT: 41.25pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes;"><td width="171" style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; WIDTH: 128pt; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 41.25pt; BACKGROUND-COLOR: transparent;"><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan;"><span lang="EN-US" style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">JFFSE1(</span><span style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">月份<span lang="EN-US">, </span>科目代码<span lang="EN-US">, </span>部门编码<span lang="EN-US">, </span>工程名称<span lang="EN-US">, </span>项目编号<span lang="EN-US">)<p></p></span></span></p></td><td width="153" style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; WIDTH: 115pt; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 41.25pt; BACKGROUND-COLOR: transparent;"><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan;"><span style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">本月借方发生额<span lang="EN-US"><p></p></span></span></p></td><td width="149" style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; WIDTH: 112pt; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 41.25pt; BACKGROUND-COLOR: transparent;"><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan;"><span lang="EN-US" style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;"><p>&nbsp;</p></span></p></td><td width="112" rowspan="5" style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; WIDTH: 84pt; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 41.25pt; BACKGROUND-COLOR: transparent;"><p class="MsoNormal" align="center" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: center; mso-pagination: widow-orphan;"><span style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">月份<span lang="EN-US">,</span>科目代码为必须选择的。部门<span lang="EN-US">,</span>项目为可选参数<span lang="EN-US">(</span>而工程是针对有自定义项目的<span lang="EN-US">,</span>特指自定义项二<span lang="EN-US">,</span>可选<span lang="EN-US">)<p></p></span></span></p></td></tr><tr style="HEIGHT: 41.25pt; mso-yfti-irow: 1;"><td width="171" style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; WIDTH: 128pt; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 41.25pt; BACKGROUND-COLOR: transparent;"><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan;"><span lang="EN-US" style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">LJJFFSE1(</span><span style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">月份<span lang="EN-US">, </span>科目代码<span lang="EN-US">, </span>部门编码<span lang="EN-US">, </span>工程名称<span lang="EN-US">, </span>项目编号<span lang="EN-US">)<p></p></span></span></p></td><td width="153" style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; WIDTH: 115pt; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 41.25pt; BACKGROUND-COLOR: transparent;"><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan;"><span lang="EN-US" style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">1</span><span style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">月至本月的借方累计发生额<span lang="EN-US"><p></p></span></span></p></td><td width="149" style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; WIDTH: 112pt; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 41.25pt; BACKGROUND-COLOR: transparent;"><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan;"><span lang="EN-US" style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;"><p>&nbsp;</p></span></p></td></tr><tr style="HEIGHT: 41.25pt; mso-yfti-irow: 2;"><td width="171" style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; WIDTH: 128pt; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 41.25pt; BACKGROUND-COLOR: transparent;"><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan;"><span lang="EN-US" style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">DFFSE1(</span><span style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">月份<span lang="EN-US">, </span>科目代码<span lang="EN-US">, </span>部门编码<span lang="EN-US">, </span>工程名称<span lang="EN-US">, </span>项目编号<span lang="EN-US">)<p></p></span></span></p></td><td width="153" style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; WIDTH: 115pt; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 41.25pt; BACKGROUND-COLOR: transparent;"><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan;"><span style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">本月贷方发生额<span lang="EN-US"><p></p></span></span></p></td><td width="149" style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; WIDTH: 112pt; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 41.25pt; BACKGROUND-COLOR: transparent;"><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan;"><span lang="EN-US" style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;"><p>&nbsp;</p></span></p></td></tr><tr style="HEIGHT: 41.25pt; mso-yfti-irow: 3;"><td width="171" style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; WIDTH: 128pt; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 41.25pt; BACKGROUND-COLOR: transparent;"><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan;"><span lang="EN-US" style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">LJDFFSE1(</span><span style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">月份<span lang="EN-US">, </span>科目代码<span lang="EN-US">, </span>部门编码<span lang="EN-US">, </span>工程名称<span lang="EN-US">, </span>项目编号<span lang="EN-US">)<p></p></span></span></p></td><td width="153" style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; WIDTH: 115pt; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 41.25pt; BACKGROUND-COLOR: transparent;"><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan;"><span lang="EN-US" style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">1</span><span style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">月至本月的贷方累计发生额<span lang="EN-US"><p></p></span></span></p></td><td width="149" style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; WIDTH: 112pt; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 41.25pt; BACKGROUND-COLOR: transparent;"><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan;"><span lang="EN-US" style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;"><p>&nbsp;</p></span></p></td></tr><tr style="HEIGHT: 41.25pt; mso-yfti-irow: 4; mso-yfti-lastrow: yes;"><td width="171" style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; WIDTH: 128pt; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 41.25pt; BACKGROUND-COLOR: transparent;"><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan;"><span lang="EN-US" style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">QME1(</span><span style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">月份<span lang="EN-US">, </span>科目代码<span lang="EN-US">, </span>部门编码<span lang="EN-US">, </span>工程名称<span lang="EN-US">, </span>项目编号<span lang="EN-US">)<p></p></span></span></p></td><td width="153" style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; WIDTH: 115pt; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 41.25pt; BACKGROUND-COLOR: transparent;"><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan;"><span style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">本月期末余额<span lang="EN-US"><p></p></span></span></p></td><td width="149" style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; WIDTH: 112pt; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 41.25pt; BACKGROUND-COLOR: transparent;"><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan;"><span style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">如科目属性来判断正负<span lang="EN-US"><p></p></span></span></p></td></tr></tbody></table></p>