<%
Function KimatsuFurikaeDenpyo(EnshuCD, KaisyaCD, SakuseiKaisyaCD, DenpyoKubun, DenpyoNo, AutoFlg, PrintFlg)
'伝票区分は非利用なので伝票処理区分に転用
If DenpyoNo = "9999999" Or DenpyoNo = "AAAAAAA" Then
Exit Function
End If
Dim LabelSoumu
Dim LabelTanto
Dim LabelKakari
LabelSoumu = ""
LabelTanto = ""
LabelKakari = "係 印"
If MHMINRANLEFT <> "" Then LabelSoumu = MHMINRANLEFT End If
If MHMINRANCENTER <> "" Then LabelTanto = MHMINRANCENTER End If
If MHMINRANRIGHT <> "" Then LabelKakari = MHMINRANRIGHT End If
Dim PageType
PageType = "決算整理仕訳"
'繰越記入にトグルするためのフラグ（081021小野）
If DenpyoKubun = "10" Then
PageType = "決算振替仕訳"
End If
Dim Torihikibi, DenpyoTekiyo
Dim KanjyoCD(10)
Dim Kanjyomei(10)
Dim Kingaku(10)
Dim TekiyoCD(10)
Dim Tekiyo(10)
Dim KarikataGokei, KashikataGokei
Dim Query
Dim Content
Dim Shimei
Dim SakujyoFlg
Dim GakuseiBango
Dim RouteType
RouteType = Request("RouteType")
KashikataGokei = 0
KarikataGokei = 0
SakujyoFlg = 0
Dim SenColor
If PrintFlg < 1 Then
SenColor = "#015B23"
If DenpyoKubun = "10" Then
SenColor = "#885522"
End If
Else
SenColor = "#000000"
End If
SenColor = "#015B23"
If DenpyoKubun = "10" Then
SenColor = "#885522"
End If
Dim NextDenpyoNo, PrevDenpyoNo
NextDenpyoNo = ""
PrevDenpyoNo = ""
If DenpyoNo <> "" Then
Query = "exec SPK伝票_振替伝票取得 '" & GB_SystemCD & "','" & EnshuCD & "', '" & KaisyaCD & "', '" & DenpyoNo & "', '" & ConvKaisyaGyosyuKubun(KaisyaCD) & "'"
Set Content = OpenQuery(Query)
If Not(Content.BOF Or Content.EOF) Then
Torihikibi = Content.Fields("取引日")
DenpyoTekiyo = Content.Fields("伝票摘要")
SakujyoFlg = Content.Fields("削除フラグ")
Shimei = Content.Fields("氏名")
GakuseiBango = Content.Fields("学生番号")
Do While Not(Content.BOF Or Content.EOF)
Dim DenpyoSEQ
DenpyoSEQ = Content.Fields("伝票SEQ")
KanjyoCD(DenpyoSEQ) = Content.Fields("勘定CD")
Kanjyomei(DenpyoSEQ) = ConvKanjyoMeisyoDx(GB_SystemCD, EnshuCD, Content.Fields("勘定CD"))
If DenpyoSEQ mod 2 = 0 Then
Kingaku(DenpyoSEQ) = Content.Fields("貸方金額")
KashikataGokei = KashikataGokei + Content.Fields("貸方金額")
Else
Kingaku(DenpyoSEQ) = Content.Fields("借方金額")
KarikataGokei = KarikataGokei + Content.Fields("借方金額")
End If
TekiyoCD(DenpyoSEQ) = Content.Fields("摘要会社名称")
Tekiyo(DenpyoSEQ) = Content.Fields("摘要")
'小売販売
If Content.Fields("摘要CD") = "SJ4KOURIHANBAI" Then
TekiyoCD(DenpyoSEQ) = ConvKaisyaMeisyo(Content.Fields("摘要CD"))
End If
Content.MoveNext
Loop
Query = "exec SPK伝票次番号 '" & GB_SystemCD & "','" & EnshuCD & "', '" & KaisyaCD & "', 'd5', '" & DenpyoKubun & "', '" & Torihikibi & "', '" & DenpyoNo & "'"
Set Content = OpenQuery(Query)
If Not(Content.BOF Or Content.EOF) Then
NextDenpyoNo = Content.Fields("伝票番号")
End If
Query = "exec SPK伝票前番号 '" & GB_SystemCD & "','" & EnshuCD & "', '" & KaisyaCD & "', 'd5', '" & DenpyoKubun & "', '" & Torihikibi & "', '" & DenpyoNo & "'"
Set Content = OpenQuery(Query)
If Not(Content.BOF Or Content.EOF) Then
PrevDenpyoNo = Content.Fields("伝票番号")
End If
End If
End If
Dim Gyousu
Query = "exec SPM演習取得 '" & GB_SystemCD & "','" & EnshuCD & "'"
Set Content = OpenQuery(Query)
If Not(Content.BOF Or Content.EOF) Then
Gyousu = Content.Fields("振替伝票表示行数")
End If
If Gyousu = 0 Or "" & Gyousu = "" Then
Gyousu = 5
End If
Dim GyouHeight
Dim GyouHeight2
Dim GyouHeight3
Dim GyouHaichi
If Gyousu = 1 Then
GyouHeight = 250
GyouHeight2 = 20
GyouHeight3 = 230
GyouHaichi = "middle"
ElseIf Gyousu = 2 Then
GyouHeight = 125
GyouHeight2 = 20
GyouHeight3 = 105
GyouHaichi = "middle"
ElseIf Gyousu = 3 Then
GyouHeight = 83
GyouHeight2 = 20
GyouHeight3 = 63
GyouHaichi = "middle"
ElseIf Gyousu = 4 Then
GyouHeight = 62
GyouHeight2 = 20
GyouHeight3 = 42
GyouHaichi = "bottom"
Else
GyouHeight = 50
GyouHeight2 = 20
GyouHeight3 = 30
GyouHaichi = "bottom"
End If
%>
<%
If PrintFlg > 0 Then
'連続印刷用追加（070606小野）PrintFlg = 2の場合は改ページ
If PrintFlg = 2 Then
Response.Write(PageBreakBefore)
End if
End if
%>
<table width="640" height="400" border="0" cellpadding="0" cellspacing="5">
<tr>
<td align="center" valign="top">
<%
If PrintFlg > 0 Then
Response.Write(PrintHeader(AutoFlg, ""))
End if
%>
<table width="650" height="430" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border:solid 1px #111111">
<tr>
<td height="60">
<table width="625" height="70" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="165" align="right" valign="bottom">
<table width="145" height="50" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="35" colspan="2" class="tx1820" style="color:<% = SenColor %>">
<% = PageType %>伝票<% If "" & SakujyoFlg = "1" Then Response.Write("<div class=""tx1214"">※削除済み</div>") End If %></td>
</tr>
<tr class="tx1416">
<td width="60" height="20" align="right" style="color:<% = SenColor %>">取引日：</td>
<td height="20"><% = Torihikibi %></td>
</tr>
</table>
</td>
<td width="325" valign="bottom">
<table width="325" height="50" border="0" cellpadding="0" cellspacing="0">
<tr class="tx1416">
<td width="80" height="20" align="right" style="color:<% = SenColor %>">伝票番号：</td>
<td height="20"><% = DenpyoNo %></td>
</tr>
<tr class="tx1416">
<td width="80" height="20" align="right" style="color:<% = SenColor %>">伝票摘要：</td>
<td height="20"><% = DenpyoTekiyo %></td>
</tr>
</table>
</td>
<td align="right" valign="bottom">
<table width="120" height="50" border="1" cellpadding="0" cellspacing="0" bordercolor="<% = SenColor %>" STYLE="border-collapse: collapse">
<tr class="tx1214" style="color:<% = SenColor %>">
<td width="40" height="14" align="center"><% = LabelSoumu %></td>
<td width="40" height="14" align="center"><% = LabelTanto %></td>
<td width="40" height="14" align="center"><% = LabelKakari %></td>
</tr>
<tr class="tx1214">
<td width="40" height="40" align="center"> </td>
<td width="40" height="40" align="center"> </td>
<td width="40" height="40" align="center"><% = ConvShimeiRyakuMeisyo(GakuseiBango) %></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="285" align="center" valign="top">
<table width="620" height="285" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="310" align="left" valign="top">
<table width="305" height="265" class="ctable" border="1" cellpadding="0" cellspacing="0" bordercolor="<% = SenColor %>" style="border-collapse: collapse">
<tr>
<td height="15" align="center" class="tx1618" style="color:<% = SenColor %>">借 方</td>
</tr>
<tr>
<td height="30" align="center">
<table width="100%" height="15" border="1" class="ctable" cellpadding="0" cellspacing="0" frame="below" style="border-collapse: collapse" bordercolor="<% = SenColor %>">
<tr class="tx1416" style="color:<% = SenColor %>">
<td align="center" width="19%" class="tx1214">勘定コード</td>
<td align="center" width="50%">勘定名称</td>
<td align="center" width="31%">金 額</td>
</tr>
</table>
<table width="100%" height="15" border="1" class="ctable" cellpadding="0" cellspacing="0" frame="void" style="border-collapse: collapse" bordercolor="<% = SenColor %>" class="tx1214">
<tr class="tx1416" style="color:<% = SenColor %>">
<td align="center" width="30%">取引先</td>
<td align="center" width="70%">明細摘要</td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="<% = GyouHeight %>">
<table width="100%" height="<% = GyouHeight3 %>" class="ctable" border="1" cellpadding="0" cellspacing="0" bordercolor="<% = SenColor %>" frame="below" style="border-collapse: collapse">
<tr class="tx1618" valign="<% = GyouHaichi %>">
<td width="14%" align="center"><% = KanjyoCD(1) %> </td>
<td width="55%" align="center"><% = Kanjyomei(1) %> </td>
<td width="31%" align="right"><% = SetMoney(Kingaku(1), false, true) %> </td>
</tr>
</table>
<table width="100%" height="<% = GyouHeight2 %>" class="ctable" border="1" cellpadding="0" cellspacing="0" bordercolor="<% = SenColor %>" frame="void" style="border-collapse: collapse">
<tr class="tx1416" valign="middle">
<td width="30%" align="center"><% = TekiyoCD(1) %> </td>
<td width="70%" align="center"><% = Tekiyo(1) %> </td>
</tr>
</table>
</td>
</tr>
<% If Gyousu > 1 Then %>
<tr>
<td height="<% = GyouHeight %>">
<table width="100%" height="<% = GyouHeight3 %>" class="ctable" border="1" cellpadding="0" cellspacing="0" bordercolor="<% = SenColor %>" frame="below" style="border-collapse: collapse">
<tr class="tx1618" valign="<% = GyouHaichi %>">
<td width="14%" align="center"><% = KanjyoCD(3) %> </td>
<td width="55%" align="center"><% = Kanjyomei(3) %> </td>
<td width="31%" align="right"><% = SetMoney(Kingaku(3), false, true) %> </td>
</tr>
</table>
<table width="100%" height="<% = GyouHeight2 %>" class="ctable" border="1" cellpadding="0" cellspacing="0" bordercolor="<% = SenColor %>" frame="void" style="border-collapse: collapse">
<tr class="tx1416" valign="middle">
<td width="30%" align="center"><% = TekiyoCD(3) %> </td>
<td width="70%" align="center"><% = Tekiyo(3) %> </td>
</tr>
</table>
</td>
</tr>
<% End If %>
<% If Gyousu > 2 Then %>
<tr>
<td height="<% = GyouHeight %>">
<table width="100%" height="<% = GyouHeight3 %>" class="ctable" border="1" cellpadding="0" cellspacing="0" bordercolor="<% = SenColor %>" frame="below" style="border-collapse: collapse">
<tr class="tx1618" valign="<% = GyouHaichi %>">
<td width="14%" align="center"><% = KanjyoCD(5) %> </td>
<td width="55%" align="center"><% = Kanjyomei(5) %> </td>
<td width="31%" align="right"><% = SetMoney(Kingaku(5), false, true) %> </td>
</tr>
</table>
<table width="100%" height="<% = GyouHeight2 %>" class="ctable" border="1" cellpadding="0" cellspacing="0" bordercolor="<% = SenColor %>" frame="void" style="border-collapse: collapse">
<tr class="tx1416" valign="middle">
<td width="30%" align="center"><% = TekiyoCD(5) %> </td>
<td width="70%" align="center"><% = Tekiyo(5) %> </td>
</tr>
</table>
</td>
</tr>
<% End If %>
<% If Gyousu > 3 Then %>
<tr>
<td height="<% = GyouHeight %>">
<table width="100%" height="<% = GyouHeight3 %>" class="ctable" border="1" cellpadding="0" cellspacing="0" bordercolor="<% = SenColor %>" frame="below" style="border-collapse: collapse">
<tr class="tx1618" valign="<% = GyouHaichi %>">
<td width="14%" align="center"><% = KanjyoCD(7) %> </td>
<td width="55%" align="center"><% = Kanjyomei(7) %> </td>
<td width="31%" align="right"><% = SetMoney(Kingaku(7), false, true) %> </td>
</tr>
</table>
<table width="100%" height="<% = GyouHeight2 %>" class="ctable" border="1" cellpadding="0" cellspacing="0" bordercolor="<% = SenColor %>" frame="void" style="border-collapse: collapse">
<tr class="tx1416" valign="middle">
<td width="30%" align="center"><% = TekiyoCD(7) %> </td>
<td width="70%" align="center"><% = Tekiyo(7) %> </td>
</tr>
</table>
</td>
</tr>
<% End If %>
<% If Gyousu > 4 Then %>
<tr>
<td height="<% = GyouHeight %>">
<table width="100%" height="<% = GyouHeight3 %>" class="ctable" border="1" cellpadding="0" cellspacing="0" bordercolor="<% = SenColor %>" frame="below" style="border-collapse: collapse">
<tr class="tx1618" valign="<% = GyouHaichi %>">
<td width="14%" align="center"><% = KanjyoCD(9) %> </td>
<td width="55%" align="center"><% = Kanjyomei(9) %> </td>
<td width="31%" align="right"><% = SetMoney(Kingaku(9), false, true) %> </td>
</tr>
</table>
<table width="100%" height="<% = GyouHeight2 %>" class="ctable" border="1" cellpadding="0" cellspacing="0" bordercolor="<% = SenColor %>" frame="void" style="border-collapse: collapse">
<tr class="tx1416" valign="middle">
<td width="30%" align="center"><% = TekiyoCD(9) %> </td>
<td width="70%" align="center"><% = Tekiyo(9) %> </td>
</tr>
</table>
</td>
</tr>
<% End If %>
<tr>
<td height="20">
<table width="100%" height="20" class="ctable" border="1" cellpadding="0" cellspacing="0" bordercolor="<% = SenColor %>" frame="void" style="border-collapse: collapse">
<tr class="tx1618">
<td align="CENTER" width="69%" style="color:<% = SenColor %>">借方合計</td>
<td width="31%" align="right"><% = SetMoney(KarikataGokei, false, true) %> </td>
</tr>
</table>
</td>
</tr>
</table>
</td>
<td width="310" align="right" valign="top">
<table width="305" height="265" class="ctable" border="1" cellpadding="0" cellspacing="0" bordercolor="<% = SenColor %>" style="border-collapse: collapse">
<tr>
<td height="15" align="center" class="tx1618" style="color:<% = SenColor %>">貸 方</td>
</tr>
<tr>
<td height="15" align="center">
<table width="100%" height="15" class="ctable" border="1" cellpadding="0" cellspacing="0" frame="below" style="border-collapse: collapse" bordercolor="<% = SenColor %>">
<tr class="tx1416" style="color:<% = SenColor %>">
<td align="center" width="19%" class="tx1214">勘定コード</td>
<td align="center" width="50%">勘定名称</td>
<td align="center" width="31%">金 額</td>
</tr>
</table>
<table width="100%" height="15" class="ctable" border="1" cellpadding="0" cellspacing="0" frame="void" style="border-collapse: collapse" bordercolor="<% = SenColor %>">
<tr class="tx1416" style="color:<% = SenColor %>">
<td align="center" width="30%">取引先</td>
<td align="center" width="70%">明細摘要</td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="<% = GyouHeight %>">
<table width="100%" height="<% = GyouHeight3 %>" class="ctable" border="1" cellpadding="0" cellspacing="0" bordercolor="<% = SenColor %>" frame="below" style="border-collapse: collapse">
<tr class="tx1618" valign="<% = GyouHaichi %>">
<td width="14%" align="center"><% = KanjyoCD(2) %> </td>
<td width="55%" align="center"><% = Kanjyomei(2) %> </td>
<td width="31%" align="right"><% = SetMoney(Kingaku(2), false, true) %> </td>
</tr>
</table>
<table width="100%" height="<% = GyouHeight2 %>" class="ctable" border="1" cellpadding="0" cellspacing="0" bordercolor="<% = SenColor %>" frame="void" style="border-collapse: collapse">
<tr class="tx1416" valign="middle">
<td width="30%" align="center"><% = TekiyoCD(2) %> </td>
<td width="70%" align="center"><% = Tekiyo(2) %> </td>
</tr>
</table>
</td>
</tr>
<% If Gyousu > 1 Then %>
<tr>
<td height="<% = GyouHeight %>">
<table width="100%" height="<% = GyouHeight3 %>" class="ctable" border="1" cellpadding="0" cellspacing="0" bordercolor="<% = SenColor %>" frame="below" style="border-collapse: collapse">
<tr class="tx1618" valign="<% = GyouHaichi %>">
<td width="14%" align="center"><% = KanjyoCD(4) %> </td>
<td width="55%" align="center"><% = Kanjyomei(4) %> </td>
<td width="31%" align="right"><% = SetMoney(Kingaku(4), false, true) %> </td>
</tr>
</table>
<table width="100%" height="<% = GyouHeight2 %>" class="ctable" border="1" cellpadding="0" cellspacing="0" bordercolor="<% = SenColor %>" frame="void" style="border-collapse: collapse">
<tr class="tx1416" valign="middle">
<td width="30%" align="center"><% = TekiyoCD(4) %> </td>
<td width="70%" align="center"><% = Tekiyo(4) %> </td>
</tr>
</table>
</td>
</tr>
<% End If %>
<% If Gyousu > 2 Then %>
<tr>
<td height="<% = GyouHeight %>">
<table width="100%" height="<% = GyouHeight3 %>" class="ctable" border="1" cellpadding="0" cellspacing="0" bordercolor="<% = SenColor %>" frame="below" style="border-collapse: collapse">
<tr class="tx1618" valign="<% = GyouHaichi %>">
<td width="14%" align="center"><% = KanjyoCD(6) %> </td>
<td width="55%" align="center"><% = Kanjyomei(6) %> </td>
<td width="31%" align="right"><% = SetMoney(Kingaku(6), false, true) %> </td>
</tr>
</table>
<table width="100%" height="<% = GyouHeight2 %>" class="ctable" border="1" cellpadding="0" cellspacing="0" bordercolor="<% = SenColor %>" frame="void" style="border-collapse: collapse">
<tr class="tx1416" valign="middle">
<td width="30%" align="center"><% = TekiyoCD(6) %> </td>
<td width="70%" align="center"><% = Tekiyo(6) %> </td>
</tr>
</table>
</td>
</tr>
<% End If %>
<% If Gyousu > 3 Then %>
<tr>
<td height="<% = GyouHeight %>">
<table width="100%" height="<% = GyouHeight3 %>" class="ctable" border="1" cellpadding="0" cellspacing="0" bordercolor="<% = SenColor %>" frame="below" style="border-collapse: collapse">
<tr class="tx1618" valign="<% = GyouHaichi %>">
<td width="14%" align="center"><% = KanjyoCD(8) %> </td>
<td width="55%" align="center"><% = Kanjyomei(8) %> </td>
<td width="31%" align="right"><% = SetMoney(Kingaku(8), false, true) %> </td>
</tr>
</table>
<table width="100%" height="<% = GyouHeight2 %>" class="ctable" border="1" cellpadding="0" cellspacing="0" bordercolor="<% = SenColor %>" frame="void" style="border-collapse: collapse">
<tr class="tx1416" valign="middle">
<td width="30%" align="center"><% = TekiyoCD(8) %> </td>
<td width="70%" align="center"><% = Tekiyo(8) %> </td>
</tr>
</table>
</td>
</tr>
<% End If %>
<% If Gyousu > 4 Then %>
<tr>
<td height="<% = GyouHeight %>">
<table width="100%" height="<% = GyouHeight3 %>" class="ctable" border="1" cellpadding="0" cellspacing="0" bordercolor="<% = SenColor %>" frame="below" style="border-collapse: collapse">
<tr class="tx1618" valign="<% = GyouHaichi %>">
<td width="14%" align="center"><% = KanjyoCD(10) %> </td>
<td width="55%" align="center"><% = Kanjyomei(10) %> </td>
<td width="31%" align="right"><% = SetMoney(Kingaku(10), false, true) %> </td>
</tr>
</table>
<table width="100%" height="<% = GyouHeight2 %>" class="ctable" border="1" cellpadding="0" cellspacing="0" bordercolor="<% = SenColor %>" frame="void" style="border-collapse: collapse">
<tr class="tx1416" valign="middle">
<td width="30%" align="center"><% = TekiyoCD(10) %> </td>
<td width="70%" align="center"><% = Tekiyo(10) %> </td>
</tr>
</table>
</td>
</tr>
<% End If %>
<tr>
<td height="20">
<table width="100%" height="20" class="ctable" border="1" cellpadding="0" cellspacing="0" bordercolor="<% = SenColor %>" frame="void" style="border-collapse: collapse">
<tr class="tx1618">
<td align="center" width="69%" style="color:<% = SenColor %>">貸方合計</td>
<td width="31%" align="right"><% = SetMoney(KashikataGokei, false, true) %> </td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<%
If PrintFlg > 0 Then
Response.Write(PrintFooter())
'連続印刷用追加（070606小野）
Response.Write("<div><img src=""/" & HomeAlias & "/images/spacer.gif"" width=""1"" height=""30""></div>" & vbCrLf)
End if
%>
</td>
</tr>
</table>
<%
End Function
%>