%
'
'
%>
<%
Function GinkoUketsukeSyorui(EnshuCD, KaisyaCD, SakuseiKaisyaCD, BunsyoSyuruiCD, BunsyoNaiyoCD, AutoFlg, PrintFlg)
Dim GinkoCD, SyosyaCD
Dim Moshikomibi, AnsyoBango, Tekiyo
Dim SenpoTekiyo
Dim SenpoFlg, SenpoBunsyoSyuruiCD, SenpoBunsyoNaiyoCD
Dim KozaKubun, Kingaku
Dim UketsukeKubun, KozaBango
Dim FurikomisakiGinkoCD, FurikomisakiKaisyaCD, FurikomisakiKozaKubun, FurikomisakiKozaBango, FurikomiNyukinKingaku, FurikomiTesuryo
Dim FurikomimotoGinkoCD, FurikomimotoKozaKubun, FurikomimotoKozaBango
Dim TegataFuridashininCD, TegataSyuruiKubun, TegataNo, TegataBunsyoNaiyoCD, TegataHikiukeninCD
Dim TegataShiharaiKijitsu, TegataKingaku
Dim WaribikiRiritsu, WaribikiRiritsuTekiyoNissu, WaribikiRisokuKingaku
Dim Syoribi
Dim RouteType, PageType
Dim FurikomisakiKoza, Koza, FurikomimotoKoza
Dim Tegata
Dim TegataKogitteSyukkinGinkoCD, TegataKogitteSyukkinKozaKubun, TegataKogitteSyukkinKozaBango
Dim TegataKogitteSyukkinSyukkinKingaku, TegataKogitteSyukkinKoza
PageType = Request("PageType")
RouteType = Request("RouteType")
GinkoCD = Request("GinkoCD")
SenpoFlg = Request("SenpoFlg")
SenpoBunsyoSyuruiCD = Request("SenpoBunsyoSyuruiCD")
SenpoBunsyoNaiyoCD = Request("SenpoBunsyoNaiyoCD")
Dim Query, Content
If KaisyaCD <> SakuseiKaisyaCD Then
SenpoFlg = "1"
End If
If SakuseiKaisyaCD = "" Then
SakuseiKaisyaCD = KaisyaCD
End If
If SenpoFlg = "1" Or GB_JisyaFlag <> "" Then '運用管理・演習管理(自社フラグ無し)では開封フラグを立てない(061213小野)
SyosyaCD = KaisyaCD
GinkoCD = SakuseiKaisyaCD
Query = "exec SPB銀行取引書類開封 '" & GB_SystemCD & "', '" & EnshuCD & "', '" & KaisyaCD & "', '" & SakuseiKaisyaCD & "', '" & BunsyoSyuruiCD & "', '" & BunsyoNaiyoCD & "'"
Set Content = OpenQuery(Query)
Query = "exec SPB銀行取引書類取得 '" & GB_SystemCD & "', '" & EnshuCD & "', '" & KaisyaCD & "', '" & SakuseiKaisyaCD & "', '" & BunsyoSyuruiCD & "', '" & BunsyoNaiyoCD & "'"
Else
GinkoCD = KaisyaCD
Query = "exec SPB銀行取引書類取得 '" & GB_SystemCD & "', '" & EnshuCD & "', '" & KaisyaCD & "', '" & SakuseiKaisyaCD & "', '" & BunsyoSyuruiCD & "', '" & BunsyoNaiyoCD & "'"
End If
'Response.Write(Query)
'Exit Function
Set Content = OpenQuery(Query)
If Not(Content.BOF Or Content.EOF) Then
If SenpoFlg = "1" Then
Else
End If
SyosyaCD = Content.Fields("取引先CD")
BunsyoNaiyoCD = Content.Fields("文書内容CD")
KozaKubun = Content.Fields("口座区分")
KozaBango = Content.Fields("口座番号")
Moshikomibi = SetTimeYYYYMMDD(Content.Fields("先方処理日"))
AnsyoBango = Content.Fields("暗証番号")
Kingaku = Content.Fields("金額")
Tekiyo = Content.Fields("摘要")
SenpoTekiyo = Content.Fields("先方摘要")
UketsukeKubun = Content.Fields("受付区分")
FurikomisakiGinkoCD = Content.Fields("振込先銀行CD")
FurikomisakiKozaKubun = Content.Fields("振込先口座区分")
FurikomisakiKozaBango = Content.Fields("振込先口座番号")
FurikomiNyukinKingaku = Content.Fields("振込入金金額")
FurikomiTesuryo = Content.Fields("振込手数料")
FurikomimotoGinkoCD = Content.Fields("振込元銀行CD")
FurikomimotoKozaKubun = Content.Fields("振込元口座区分")
FurikomimotoKozaBango = Content.Fields("振込元口座番号")
TegataKogitteSyukkinGinkoCD = Content.Fields("手形小切手出金銀行CD")
TegataKogitteSyukkinKozaKubun = Content.Fields("手形小切手出金口座区分")
TegataKogitteSyukkinKozaBango = Content.Fields("手形小切手出金口座番号")
TegataKogitteSyukkinSyukkinKingaku = Content.Fields("手形小切手出金金額")
TegataFuridashininCD = Content.Fields("手形作成会社CD")
TegataSyuruiKubun = Content.Fields("手形文書種類CD")
TegataBunsyoNaiyoCD = Content.Fields("手形文書内容CD")
TegataNo = Content.Fields("手形番号")
WaribikiRiritsu = Content.Fields("割引利率")
WaribikiRiritsuTekiyoNissu = Content.Fields("割引利率適用日数")
WaribikiRisokuKingaku = Content.Fields("割引利息金額")
Syoribi = SetTimeYYYYMMDD(Content.Fields("処理日"))
TegataShiharaiKijitsu = SetTimeYYYYMMDD(Content.Fields("手形支払期日"))
TegataKingaku = Content.Fields("手形金額")
If FurikomisakiKozaKubun <> "" Then
FurikomisakiKoza = GetKozaOutput(EnshuCD, FurikomisakiGinkoCD, FurikomisakiKozaKubun, FurikomisakiKozaBango)
Else
FurikomisakiKoza = "その他"
End If
If TegataNo <> "" Then
Tegata = ConvKaisyaRyakuMeisyo(TegataFuridashininCD) & "_" & ConvKubunMeisyo("手形種類区分", TegataSyuruiKubun) & "_" & TegataNo
End If
Koza = GetKozaOutput(EnshuCD, GinkoCD, KozaKubun, KozaBango)
FurikomimotoKoza = GetKozaOutput(EnshuCD, FurikomimotoGinkoCD, FurikomimotoKozaKubun, FurikomimotoKozaBango)
TegataKogitteSyukkinKoza = GetKozaOutput(EnshuCD, TegataKogitteSyukkinGinkoCD, TegataKogitteSyukkinKozaKubun, TegataKogitteSyukkinKozaBango)
End If
Dim title, DefSenpoBunsyoSyuruiCD
If BunsyoSyuruiCD = "BN" Then
title = "口座開設"
DefSenpoBunsyoSyuruiCD = "BA"
ElseIf BunsyoSyuruiCD = "BO" Then
title = "預入"
DefSenpoBunsyoSyuruiCD = "BB"
ElseIf BunsyoSyuruiCD = "BP" Then
title = "引出"
DefSenpoBunsyoSyuruiCD = "BC"
ElseIf BunsyoSyuruiCD = "BQ" Then
title = "振込"
DefSenpoBunsyoSyuruiCD = "BD"
ElseIf BunsyoSyuruiCD = "BR" Then
title = "小切手入金"
DefSenpoBunsyoSyuruiCD = "BE"
ElseIf BunsyoSyuruiCD = "BS" Then
title = "手形取立"
DefSenpoBunsyoSyuruiCD = "BF"
ElseIf BunsyoSyuruiCD = "BT" Then
title = "手形割引"
DefSenpoBunsyoSyuruiCD = "BG"
ElseIf BunsyoSyuruiCD = "BU" Then
title = "残高証明書"
DefSenpoBunsyoSyuruiCD = "BH"
End If
'先方書類は何かを入れている
If SenpoBunsyoSyuruiCD = "" Then
SenpoBunsyoSyuruiCD = DefSenpoBunsyoSyuruiCD
End If
Dim Tegata1, Tegata2, Kogitte1, Kogitte2, TegataShiharaininCD
If TegataNo <> "" Then
If TegataSyuruiKubun = "TY" Or TegataSyuruiKubun = "TG" Then
TegataShiharaininCD = TegataFuridashininCD
Else
TegataShiharaininCD = TegataHikiukeninCD
End If
Tegata1 = ConvKubunMeisyo("手形種類区分", TegataSyuruiKubun ) & " " & TegataNo
Tegata1 = Tegata1 & " 振出人:" & ConvKaisyaRyakuMeisyo(TegataFuridashininCD)
Tegata2 = "支払期日:" & TegataShiharaiKijitsu & " 金額:" & ConvIntToMoney(TegataKingaku, false, false)
Kogitte1 = ConvKubunMeisyo("手形種類区分", TegataSyuruiKubun ) & " " & TegataNo
Kogitte1 = Kogitte1 & " 振出人:" & ConvKaisyaRyakuMeisyo(TegataFuridashininCD)
Kogitte2 = "金額:" & ConvIntToMoney(TegataKingaku, false, false)
End If
'手動一括口座開設で受付許可の場合に直前の摘要が書き込まれてしまう不具合の対処(090714小野)
If UketsukeKubun = "Y" Then
Dim TmpTekiyo
TmpTekiyo = Tekiyo
If TmpTekiyo = "" Then
TmpTekiyo = SenpoTekiyo
End If
If Right(TmpTekiyo, 15) = "の当座口座はすでに開設済みです" Then
'会社略名称を抜き出す
TmpTekiyo = Mid(TmpTekiyo, 1, Len(TmpTekiyo) - 15)
'抜き出した会社略名称が申込会社の略名称と異なっていれば摘要をクリアする
If TmpTekiyo <> ConvKaisyaRyakuMeisyo(SyosyaCD) Then
Tekiyo = ""
SenpoTekiyo = ""
End If
End If
End If
Dim JitsuinRiyo
Query = "exec SPM演習取得 '" & GB_SystemCD & "','" & EnshuCD & "'"
Set Content = OpenQuery(Query)
If Not(Content.BOF Or Content.EOF) Then
JitsuinRiyo = "" & Content.Fields("実印利用")
End If
%>
<%
If PrintFlg = 1 Then
Response.Write(PrintHeader(AutoFlg, ""))
End if
%>
<% If BunsyoSyuruiCD <> "BU" Then %>
<% = ConvKaisyaRyakuMeisyoDx(EnshuCD, GinkoCD)%> <% = title & "結果通知書" %>
|
受付番号:<% = BunsyoNaiyoCD %>
|
|
|
<% = Spacer(1,10) %>
先方申込内容
申込社名 |
<% = ConvKaisyaMeisyoDx(EnshuCD, SyosyaCD) %> |
申込日 |
<% = Moshikomibi %> |
<% If BunsyoSyuruiCD = "BN" Then %>
口座種類 |
<% = ConvKubunMeisyo("口座区分", KozaKubun) %> |
口座番号 |
<% = KozaBango %> |
金額 |
<% = ConvIntToMoney(Kingaku, false, false) %> |
暗証番号 |
<% = AnsyoBango %> |
<% ElseIf BunsyoSyuruiCD = "BO" Then %>
入金口座 |
<% = Koza %> |
入金金額 |
<% = ConvIntToMoney(Kingaku, false, false) %> |
<% ElseIf BunsyoSyuruiCD = "BP" Then %>
出金口座 |
<% = Koza %> |
出金金額 |
<% = ConvIntToMoney(Kingaku, false, false) %> |
小切手 |
<% = Kogitte1 & " " & Kogitte2 %> |
暗証番号 |
<% = AnsyoBango %> |
<% ElseIf BunsyoSyuruiCD = "BQ" Then %>
小切手 |
<% = Kogitte1 & " " & Kogitte2 %> |
暗証番号 |
<% = AnsyoBango %> |
<% ElseIf BunsyoSyuruiCD = "BR" Then %>
小切手 |
<% = Kogitte1 & " " & Kogitte2 %> |
<% ElseIf BunsyoSyuruiCD = "BS" Then %>
手形 |
<% = Tegata1 & " " & Tegata2 %> |
<% ElseIf BunsyoSyuruiCD = "BT" Then %>
手形 |
<% = Tegata1 & " " & Tegata2 %> |
<% End If %>
申込摘要 |
<% = SenpoTekiyo %> |
|
<% = Spacer(1,10) %>
銀行処理欄
処理日 |
<% = Syoribi %> |
受付 |
<% = ConvKubunMeisyo("受付区分", UketsukeKubun) %> |
<% If BunsyoSyuruiCD = "BO" Then%>
<% ElseIf BunsyoSyuruiCD = "BP" Then%>
出金口座 |
<% = Koza %> |
出金金額 |
<% = ConvIntToMoney(Kingaku, false, false) %> |
<% ElseIf BunsyoSyuruiCD = "BQ" Then%>
振込元口座 |
<% If FurikomimotoKoza <> "" Then %>
<% = FurikomimotoKoza %> |
<% Else %>
<% = Koza %> |
<% End If %>
出金金額 |
<% = ConvIntToMoney(Kingaku, false, false) %> |
振込手数料 |
<% = ConvIntToMoney(FurikomiTesuryo, false, false) %> |
振込先口座 |
<% = FurikomisakiKoza %> |
入金金額 |
<% = ConvIntToMoney(FurikomiNyukinKingaku, false, false) %> |
<% ElseIf BunsyoSyuruiCD = "BR" OR BunsyoSyuruiCD = "BS" OR BunsyoSyuruiCD = "BT" Then%>
入金口座 |
<% = Koza %> |
入金金額 |
<% = ConvIntToMoney(Kingaku , false, false) %> |
出金口座 |
<% = TegataKogitteSyukkinKoza %> |
出金金額 |
<% = ConvIntToMoney(TegataKogitteSyukkinSyukkinKingaku, false, false) %> |
<% If BunsyoSyuruiCD = "BS" Then%>
手形支払期日 |
<% = TegataShiharaiKijitsu %> |
<% End If %>
<% If BunsyoSyuruiCD = "BT" Then %>
手形支払期日 <% = TegataShiharaiKijitsu %> | | 年利率 <% = WaribikiRiritsu %>% | | 手形金額 <% = ConvIntToMoney(TegataKingaku, false, false) %> |
日数 <% = WaribikiRiritsuTekiyoNissu %>日 | | 利息金額 <% = ConvIntToMoney(WaribikiRisokuKingaku, false, false) %> |
|
<% End If %>
<% End If %>
通帳摘要 |
<% = Tekiyo %> |
|
|
<% Else 'If BunsyoSyuruiCD = "BM" Then %>
<% = Spacer(1,30) %> |
残 高 証 明 書
|
<% = Spacer(1,20) %> |
<% = ConvKaisyaMeisyoDx(EnshuCD, SyosyaCD) %> 様
|
<% = Spacer(1,30) %> |
<%
Dim GinkoZandaka
GinkoZandaka = 0
Query = "exec SPB銀行口座残高一覧 '" & GB_SystemCD & "','" & EnshuCD & "', '" & SyosyaCD & "', '" & GinkoCD & "', '', '" & Syoribi & "'"
'Response.Write(Query)
'Exit Function
Set Content = OpenQuery(Query)
Do While Not(Content.EOF Or Content.BOF)
GinkoZandaka = GinkoZandaka + Content.Fields("残高")
Content.MoveNext
Loop
%>
預金・積金 : <% = ConvIntToMoney(GinkoZandaka, false, false) %> 円
|
<% = Spacer(1,30) %> |
貴名義の残高は <% = SetDate(Syoribi, 3) %> 現在上記の通り相違ないことを証明いたします。
|
<% = Spacer(1,25) %> |
<% = SetDate(Syoribi, 3) %>
|
<% If JitsuinRiyo = "1" Then %>
<% Else %>
<% = Spacer(1,48) %>
<% End If %>
|
<% = ConvKaisyaMeisyoDx(EnshuCD, GinkoCD) %>
|
|
<% = Spacer(1,25) %> |
< 内 訳 >
|
<% = Spacer(1,5) %> |
種 類 |
口座区分 |
口座番号 |
金 額 |
<%
Query = "exec SPB銀行口座残高一覧 '" & GB_SystemCD & "','" & EnshuCD & "', '" & SyosyaCD & "', '" & GinkoCD & "', '', '" & Syoribi & "'"
Set Content = OpenQuery(Query)
Do While Not(Content.EOF Or Content.BOF)
Response.Write("" & vbCrLf)
Response.Write("預金・積金 | " & vbCrLf)
Response.Write("" & ConvKubunMeisyo("口座区分", Content.Fields("口座区分")) & "預金 | " & vbCrLf)
Response.Write("" & Content.Fields("口座番号") & " | " & vbCrLf)
Response.Write("\ " & ConvIntToMoney(Content.Fields("残高") , false, false) & " | " & vbCrLf)
Response.Write(" " & vbCrLf)
Content.MoveNext
Loop
%>
|
<% = Spacer(1,30) %> |
<% End If %>
|
|
<%
If PrintFlg = 1 Then
Response.Write(PrintFooter())
End if
%>
|
<%
End Function
%>