<% ' ' %> <% 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) %>
先方申込内容 <% If BunsyoSyuruiCD = "BN" Then %> <% ElseIf BunsyoSyuruiCD = "BO" Then %> <% ElseIf BunsyoSyuruiCD = "BP" Then %> <% ElseIf BunsyoSyuruiCD = "BQ" Then %> <% ElseIf BunsyoSyuruiCD = "BR" Then %> <% ElseIf BunsyoSyuruiCD = "BS" Then %> <% ElseIf BunsyoSyuruiCD = "BT" Then %> <% End If %>
申込社名 <% = ConvKaisyaMeisyoDx(EnshuCD, SyosyaCD) %>
申込日 <% = Moshikomibi %>
口座種類 <% = ConvKubunMeisyo("口座区分", KozaKubun) %>
口座番号 <% = KozaBango %>
金額 <% = ConvIntToMoney(Kingaku, false, false) %>
暗証番号 <% = AnsyoBango %>
入金口座 <% = Koza %>
入金金額 <% = ConvIntToMoney(Kingaku, false, false) %>
出金口座 <% = Koza %>
出金金額 <% = ConvIntToMoney(Kingaku, false, false) %>
小切手 <% = Kogitte1 & "
" & Kogitte2 %>
暗証番号 <% = AnsyoBango %>
小切手 <% = Kogitte1 & "
" & Kogitte2 %>
暗証番号 <% = AnsyoBango %>
小切手 <% = Kogitte1 & "
" & Kogitte2 %>
手形 <% = Tegata1 & "
" & Tegata2 %>
手形 <% = Tegata1 & "
" & Tegata2 %>
申込摘要 <% = SenpoTekiyo %>
<% = Spacer(1,10) %>
銀行処理欄 <% If BunsyoSyuruiCD = "BO" Then%> <% ElseIf BunsyoSyuruiCD = "BP" Then%> <% ElseIf BunsyoSyuruiCD = "BQ" Then%> <% If FurikomimotoKoza <> "" Then %> <% Else %> <% End If %> <% ElseIf BunsyoSyuruiCD = "BR" OR BunsyoSyuruiCD = "BS" OR BunsyoSyuruiCD = "BT" Then%> <% If BunsyoSyuruiCD = "BS" Then%> <% End If %> <% If BunsyoSyuruiCD = "BT" Then %> <% End If %> <% End If %>
処理日 <% = Syoribi %>
受付 <% = ConvKubunMeisyo("受付区分", UketsukeKubun) %>
出金口座 <% = Koza %>
出金金額 <% = ConvIntToMoney(Kingaku, false, false) %>
振込元口座<% = FurikomimotoKoza %><% = Koza %>
出金金額 <% = ConvIntToMoney(Kingaku, false, false) %>
振込手数料 <% = ConvIntToMoney(FurikomiTesuryo, false, false) %>
振込先口座 <% = FurikomisakiKoza %>
入金金額 <% = ConvIntToMoney(FurikomiNyukinKingaku, false, false) %>
入金口座 <% = Koza %>
入金金額 <% = ConvIntToMoney(Kingaku , false, false) %>
出金口座 <% = TegataKogitteSyukkinKoza %>
出金金額 <% = ConvIntToMoney(TegataKogitteSyukkinSyukkinKingaku, false, false) %>
手形支払期日 <% = TegataShiharaiKijitsu %>
手形支払期日 <% = TegataShiharaiKijitsu %> 年利率 <% = WaribikiRiritsu %>% 手形金額 <% = ConvIntToMoney(TegataKingaku, false, false) %>
日数 <% = WaribikiRiritsuTekiyoNissu %>日 利息金額 <% = ConvIntToMoney(WaribikiRisokuKingaku, false, false) %>
通帳摘要 <% = 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("" & vbCrLf) Response.Write("" & vbCrLf) Response.Write("" & vbCrLf) Response.Write("" & vbCrLf) Content.MoveNext Loop %>
種 類 口座区分 口座番号 金  額
預金・積金" & ConvKubunMeisyo("口座区分", Content.Fields("口座区分")) & "預金" & Content.Fields("口座番号") & "\ " & ConvIntToMoney(Content.Fields("残高") , false, false) & "  
<% = Spacer(1,30) %>
<% End If %>
<% If PrintFlg = 1 Then Response.Write(PrintFooter()) End if %>
<% End Function %>