{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["入力シート","登録票","【記入例】入力シート"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"入力シート","index":0,"n_rows":64,"n_cols":44,"rows_kept":64,"cut":false,"hidden":false,"merged":[[39,5,39,8],[22,2,22,4],[11,5,11,21],[13,9,13,21],[12,9,12,21],[14,9,14,21],[22,5,22,21],[25,5,25,21],[13,5,13,7],[18,5,18,21],[11,0,11,4],[23,5,23,21],[24,5,24,21],[16,2,16,4],[32,2,32,4],[29,5,29,8],[12,5,12,8],[14,5,14,8],[17,5,17,8],[19,5,19,21],[20,5,20,21],[12,2,12,4],[13,2,13,4],[14,2,14,4],[63,5,63,7],[63,8,63,21],[44,5,44,21],[40,5,40,21],[42,5,42,21],[43,5,43,21],[41,5,41,21],[36,5,36,21],[37,5,37,21],[50,5,50,21],[47,9,47,21],[48,5,48,21],[49,5,49,21],[51,5,51,21],[52,5,52,21],[53,5,53,21],[55,5,55,8],[60,5,60,21],[61,5,61,21],[55,9,55,21],[56,5,56,21],[57,5,57,21],[58,5,58,21],[59,5,59,21],[17,2,17,4],[20,2,20,4],[19,2,19,4],[15,2,15,4],[15,5,15,21],[16,5,16,8],[16,9,16,21],[18,2,18,4],[17,9,17,21],[47,1,53,1],[45,2,45,4],[46,2,46,4],[28,2,28,4],[24,2,24,4],[42,2,42,4],[43,2,43,4],[36,2,36,4],[41,2,41,4],[37,2,37,4],[30,2,30,4],[31,2,31,4],[41,0,46,1],[47,0,63,0],[38,2,38,4],[40,2,40,4],[34,0,40,1],[51,2,51,4],[52,2,52,4],[47,2,47,4],[48,2,48,4],[60,2,60,4],[61,2,61,4],[54,2,54,4],[59,2,59,4],[21,2,21,4],[35,5,35,21],[34,5,34,21],[26,5,26,21],[27,5,27,21],[28,5,28,21],[21,5,21,21],[30,5,30,8],[29,9,29,21],[30,9,30,21],[31,5,31,21],[55,2,55,4],[56,2,56,4],[57,2,57,4],[54,5,54,8],[54,9,54,21],[38,9,38,21],[39,9,39,21],[45,9,45,21],[46,9,46,21],[45,5,45,8],[46,5,46,8],[38,5,38,8],[5,3,5,8],[26,2,26,4],[25,2,25,4],[39,2,39,4],[27,2,27,4],[33,5,33,21],[23,2,23,4],[62,1,63,1],[62,2,62,4],[63,2,63,4],[62,5,62,21],[54,1,61,1],[44,2,44,4],[34,2,34,4],[35,2,35,4],[29,2,29,4],[33,2,33,4],[53,2,53,4],[47,5,47,8],[32,5,32,21],[12,0,33,1],[49,2,49,4],[50,2,50,4],[58,2,58,4]]}
[null,"入力上の注意事項（別添記入例もご参照ください）"]
[null,"①支払案内送付先・本社所在地は登録基本情報と異なる場合のみご記入ください。"]
[null,"②お手数ですが、変更の場合でも必要事項をすべてご記入ください。"]
[null,"③でんさいネット情報についてご不明の点がございましたら、下記のリンクをクリックしてください。"]
[null,null,"でんさいネットのHPが閲覧できます。"]
[null,null,"URL：","https://www.densai.net/"]
[null,null,"なお、ご不明の点がございましたら、本社管理部 TEL 044-812-0776 までご連絡ください。"]
[null,"④","本紙に会社名・代表者名のゴム印（ゴム印がない場合は手書き）・代表者印・金銭領収印をご捺印の上、",null,null,null,"にメール送信終了後、登録票印刷ボタンをクリックし登録票本紙を印刷してください。"]
[null,null,"本紙を当社の担当者までご送付ください。"]
[]
[]
["項目",null,null,null,null,"入力・備考",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"エラーチェック"]
["登録基本情報",null,"提出日",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F13=\"\",1,0)","v":1}]
[null,null,"登録区分",null,null,null,null,null,null,{"$f":"IF(AND(F15<>\"\",F18<>\"\"),\"\",IF(F14=\"変更\",\"※変更の場合は変更事由及び取引先ｺｰﾄﾞも記入ください\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F14=\"\",1,0)","v":1}]
[null,null,"変更内容",null,null,null,null,null,null,{"$f":"IF(F15=\"その他\",\"※変更内容がその他の場合その他変更内容もご記入ください\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($F$14=\"変更\",F15=\"\"),1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"新規"]
[null,null,"変更事由メモ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(F15=\"その他\",F16=\"\"),1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"変更"]
[null,null,"旧社名",null,null,null,null,null,null,{"$f":"IF(F17<>\"\",\"\",IF(F15=\"会社名\",\"※会社名変更の場合は、旧社名をご記入ください\",\"\"))","v":""}]
[null,null,"取引先コード",null,null,null,null,null,null,"※変更の場合はこちらもご記入ください",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($F$14=\"変更\",F18=\"\"),1,0)","v":0}]
[null,null,"会社名",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F19=\"\",1,0)","v":1}]
[null,null,"会社名カナ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F20=\"\",1,0)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"会社名"]
[null,null,"代表者役職・氏名",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F21=\"\",1,0)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"代表者名"]
[null,null,"代表者カナ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F22=\"\",1,0)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"取引先住所"]
[null,null,"資本金(百万単位)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F23=\"\",1,0)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"支払案内送付先"]
[null,null,"支店・部署名等",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"本社所在地"]
[null,null,"支店・部署ガナ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"振込口座情報"]
[null,null,"郵便番号",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F26=\"\",1,0)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"でんさい情報"]
[null,null,"住所",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F27=\"\",1,0)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"その他"]
[null,null,"住所カナ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F28=\"\",1,0)","v":1}]
[null,null,"ビル名等",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"本社集金"]
[null,null,"ＴＥＬ",null,null,null,null,null,null,"※番号の区切りについては-（ハイフォン）をご使用ください",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F30=\"\",1,0)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"郵送"]
[null,null,"ＦＡＸ",null,null,null,null,null,null,"※番号の区切りについては-（ハイフォン）をご使用ください",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F31=\"\",1,0)","v":1}]
[null,null,"E-Mail",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F32=\"\",1,0)","v":1}]
[null,null,"担当者部署・氏名",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F33=\"\",1,0)","v":1}]
[null,null,"担当者カナ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F34=\"\",1,0)","v":1}]
["支払案内送付先",null,"郵便番号"]
[null,null,"住所"]
[null,null,"住所カナ"]
[null,null,"ビル名等"]
[null,null,"ＴＥＬ",null,null,null,null,null,null,"※番号の区切りについては-（ハイフォン）をご使用ください"]
[null,null,"ＦＡＸ",null,null,null,null,null,null,"※番号の区切りについては-（ハイフォン）をご使用ください"]
[null,null,"E-Mail"]
["本社所在地",null,"郵便番号"]
[null,null,"住所"]
[null,null,"住所カナ"]
[null,null,"ビル名等"]
[null,null,"ＴＥＬ",null,null,null,null,null,null,"※番号の区切りについては-（ハイフォン）をご使用ください"]
[null,null,"ＦＡＸ",null,null,null,null,null,null,"※番号の区切りについては-（ハイフォン）をご使用ください"]
["支払情報","振込","金融機関コード",null,null,null,null,null,null,"※金融機関ごとの7ケタのコード、通常は通帳に記載があります"]
[null,null,"金融機関名"]
[null,null,"支店名"]
[null,null,"口座種別"]
[null,null,"口座番号"]
[null,null,"口座名義"]
[null,null,"名義カナ"]
[null,"でんさいネット","利用者番号",null,null,null,null,null,null,"※全銀電子債権ネットワークが発行する9ケタの番号"]
[null,null,"金融機関コード",null,null,null,null,null,null,"※金融機関ごとの7ケタのコード、通常は通帳に記載があります"]
[null,null,"金融機関名"]
[null,null,"支店名"]
[null,null,"口座種別"]
[null,null,"口座番号"]
[null,null,"口座名義"]
[null,null,"名義カナ"]
[null,"手形","受取人名"]
[null,null,"支払方法",null,null,null,null,null,{"$f":"IF(F64=\"\",\"\",IF(F64=\"本社集金\",\"※集金対応は弊社本社のみです。\",\"\"))","v":""}]

{"sheet":"登録票","index":1,"n_rows":58,"n_cols":31,"rows_kept":58,"cut":false,"hidden":false,"merged":[[51,2,51,30],[52,2,52,10],[53,2,53,5],[54,2,54,5],[55,2,55,5],[54,6,54,7],[55,6,55,10],[56,2,56,5],[53,6,53,8],[53,9,53,10],[54,9,54,10],[53,28,56,30],[52,11,52,14],[52,15,52,20],[52,28,52,30],[53,11,56,14],[53,15,56,20],[52,21,52,27],[53,21,56,27],[45,2,47,4],[45,5,45,30],[42,2,43,2],[39,3,39,5],[41,3,41,5],[39,13,39,15],[47,5,47,30],[46,5,46,30],[36,3,36,5],[38,2,41,2],[35,2,37,2],[39,16,39,30],[40,3,40,5],[40,13,40,14],[40,15,40,16],[40,17,40,30],[41,6,41,16],[41,17,41,19],[41,20,41,30],[35,16,35,30],[37,17,37,19],[37,20,37,30],[37,6,37,16],[36,17,36,30],[24,19,24,30],[23,19,23,30],[32,5,32,7],[32,8,32,30],[24,2,24,4],[24,5,24,15],[24,16,24,18],[27,2,27,4],[28,2,28,4],[25,2,25,4],[25,10,25,12],[29,5,29,9],[29,10,29,12],[29,13,29,17],[28,8,28,30],[31,5,31,7],[31,8,31,30],[29,18,29,30],[32,2,32,4],[25,5,25,9],[25,13,25,17],[25,21,25,30],[29,2,29,4],[25,18,25,20],[0,25,0,26],[1,2,1,30],[2,2,2,30],[5,14,5,21],[5,23,5,30],[19,2,19,4],[19,5,19,18],[19,19,19,21],[19,22,19,30],[11,2,11,9],[9,25,9,30],[10,25,17,30],[9,10,9,24],[10,10,17,24],[7,23,7,30],[16,2,17,9],[3,2,3,30],[10,2,10,9],[9,2,9,9],[12,2,15,9],[22,2,22,4],[20,2,20,4],[20,5,20,18],[20,19,20,21],[23,2,23,4],[23,5,23,15],[23,16,23,18],[21,5,21,7],[22,5,22,7],[21,8,21,30],[22,8,22,30],[20,22,20,30],[21,2,21,4],[27,5,27,7],[27,8,27,30],[31,2,31,4],[42,6,42,30],[43,6,43,30],[42,3,42,5],[43,3,43,5],[28,5,28,7],[38,15,38,30],[37,3,37,5],[36,13,36,14],[36,15,36,16],[35,13,35,15],[33,2,33,4],[33,5,33,9],[33,10,33,12],[33,13,33,17],[33,18,33,20],[33,21,33,25],[33,26,33,30],[38,3,38,5],[35,3,35,5]]}
[]
[]
[null,null,"取　引　先　登　録　票"]
[null,null,"(でんさい対応版）"]
[]
[null,null,null,"株式会社Ｅ＆ＣＳ",null,null,null,null,null,null,"御中",null,null,null,"取引先コード",null,null,null,null,null,null,null,null,"提出日"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(入力シート!F18=\"\",\"\",MIDB(入力シート!F18,1,1))","v":""},{"$f":"IF(入力シート!F18=\"\",\"\",MIDB(入力シート!F18,2,1))","v":""},{"$f":"IF(入力シート!F18=\"\",\"\",MIDB(入力シート!F18,3,1))","v":""},{"$f":"IF(入力シート!F18=\"\",\"\",MIDB(入力シート!F18,4,1))","v":""},{"$f":"IF(入力シート!F18=\"\",\"\",MIDB(入力シート!F18,5,1))","v":""},{"$f":"IF(入力シート!F18=\"\",\"\",MIDB(入力シート!F18,6,1))","v":""},{"$f":"IF(入力シート!F18=\"\",\"\",MIDB(入力シート!F18,7,1))","v":""},{"$f":"IF(入力シート!F18=\"\",\"\",MIDB(入力シート!F18,8,1))","v":""},null,{"$f":"DBCS(IF(入力シート!F13=\"\",\"　　年　　月　　日\",YEAR(入力シート!F13)&\"年\"&RIGHT(\" \"&MONTH(入力シート!F13),2)&\"月\"&RIGHT(\" \"&DAY(入力シート!F13),2)&\"日\"))","v":"　　年　　月　　日"}]
[]
[null,null,"登録区分",null,null,null,null,null,null,null,"会社名(事業所名)及び代表者",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"金銭領収印鑑"]
[null,null,{"$f":"IF(入力シート!F14=\"\",\"\",入力シート!F14)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(入力シート!F55=\"\",\"\",\"不要\")","v":""}]
[null,null,"変更事由"]
[null,null,{"$f":"IF(入力シート!F16=\"\",\"\",入力シート!F16)","v":""}]
[]
[]
[]
[null,null,{"$f":"IF(入力シート!F17=\"\",\"\",\"旧社名：\"&入力シート!F17)","v":""}]
[]
[null,null,"（お取引先情報）"]
[null,null,"フリガナ",null,null,{"$f":"IF(入力シート!F20=\"\",\"\",入力シート!F20)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"フリガナ",null,null,{"$f":"IF(入力シート!F25=\"\",\"\",入力シート!F25)","v":""}]
[null,null,"会社名",null,null,{"$f":"IF(入力シート!F19=\"\",\"\",入力シート!F19)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"支店名他",null,null,{"$f":"IF(入力シート!F24=\"\",\"\",入力シート!F24)","v":""}]
[null,null,"フリガナ",null,null,null,null,null,{"$f":"IF(入力シート!F28=\"\",\"\",入力シート!F28)","v":""}]
[null,null,"住所",null,null,{"$f":"IF(入力シート!F26=\"\",\"\",\"〒\"&入力シート!F26)","v":""},null,null,{"$f":"IF(入力シート!F27=\"\",\"\",入力シート!F27&IF(入力シート!F29=\"\",\"\",\" \"&入力シート!F29))","v":""}]
[null,null,"フリガナ",null,null,{"$f":"IF(入力シート!F22=\"\",\"\",入力シート!F22)","v":""},null,null,null,null,null,null,null,null,null,null,"フリガナ",null,null,{"$f":"IF(入力シート!F34=\"\",\"\",入力シート!F34)","v":""}]
[null,null,"代表者名",null,null,{"$f":"IF(入力シート!F21=\"\",\"\",入力シート!F21)","v":""},null,null,null,null,null,null,null,null,null,null,"担当者部署\n担当者氏名",null,null,{"$f":"IF(入力シート!F33=\"\",\"\",入力シート!F33)","v":""}]
[null,null,"ＴＥＬ",null,null,{"$f":"IF(入力シート!F30=\"\",\"\",入力シート!F30)","v":""},null,null,null,null,"ＦＡＸ",null,null,{"$f":"IF(入力シート!F31=\"\",\"\",入力シート!F31)","v":""},null,null,null,null,"E-Mail",null,null,{"$f":"IF(入力シート!F32=\"\",\"\",入力シート!F32)","v":""}]
[null,null,"（支払案内書郵送先）"]
[null,null,"フリガナ",null,null,null,null,null,{"$f":"IF(入力シート!F37=\"\",\"\",入力シート!F37)","v":""}]
[null,null,"住所",null,null,{"$f":"IF(入力シート!F35=\"\",\"\",\"〒\"&入力シート!F35)","v":""},null,null,{"$f":"IF(入力シート!F36=\"\",\"\",入力シート!F36&IF(入力シート!F38=\"\",\"\",\" \"&入力シート!F38))","v":""}]
[null,null,"ＴＥＬ",null,null,{"$f":"IF(入力シート!F39=\"\",\"\",入力シート!F39)","v":""},null,null,null,null,"ＦＡＸ",null,null,{"$f":"IF(入力シート!F40=\"\",\"\",入力シート!F40)","v":""}]
[null,null,"（本社所在地）"]
[null,null,"フリガナ",null,null,null,null,null,{"$f":"IF(入力シート!F44=\"\",\"\",入力シート!F44)","v":""}]
[null,null,"住所",null,null,{"$f":"IF(入力シート!F42=\"\",\"\",\"〒\"&入力シート!F42)","v":""},null,null,{"$f":"IF(入力シート!F43=\"\",\"\",入力シート!F43&IF(入力シート!F45=\"\",\"\",\" \"&入力シート!F45))","v":""}]
[null,null,"ＴＥＬ",null,null,{"$f":"IF(入力シート!F46=\"\",\"\",入力シート!F46)","v":""},null,null,null,null,"ＦＡＸ",null,null,{"$f":"IF(入力シート!F47=\"\",\"\",入力シート!F47)","v":""},null,null,null,null,"資本金",null,null,{"$f":"IF(入力シート!F23=\"\",\"\",入力シート!F23)","v":""}]
[null,null,"（お支払情報）"]
[null,null,"振込","金融機関C",null,null,{"$f":"IF(入力シート!$F$48=\"\",\"\",MIDB(入力シート!$F$48,1,1))","v":""},{"$f":"IF(入力シート!$F$48=\"\",\"\",MIDB(入力シート!$F$48,2,1))","v":""},{"$f":"IF(入力シート!$F$48=\"\",\"\",MIDB(入力シート!$F$48,3,1))","v":""},{"$f":"IF(入力シート!$F$48=\"\",\"\",MIDB(入力シート!$F$48,4,1))","v":""},{"$f":"IF(入力シート!$F$48=\"\",\"\",MIDB(入力シート!$F$48,5,1))","v":""},{"$f":"IF(入力シート!$F$48=\"\",\"\",MIDB(入力シート!$F$48,6,1))","v":""},{"$f":"IF(入力シート!$F$48=\"\",\"\",MIDB(入力シート!$F$48,7,1))","v":""},"銀行名称",null,null,{"$f":"IF(入力シート!F49=\"\",\"\",入力シート!F49)&IF(入力シート!F50=\"\",\"\",\" \"&入力シート!F50)","v":""}]
[null,null,null,"口座番号",null,null,{"$f":"IF(入力シート!$F$52=\"\",\"\",MIDB(RIGHT(\"0000000\"&入力シート!$F$52,7),1,1))","v":""},{"$f":"IF(入力シート!$F$52=\"\",\"\",MIDB(RIGHT(\"0000000\"&入力シート!$F$52,7),2,1))","v":""},{"$f":"IF(入力シート!$F$52=\"\",\"\",MIDB(RIGHT(\"0000000\"&入力シート!$F$52,7),3,1))","v":""},{"$f":"IF(入力シート!$F$52=\"\",\"\",MIDB(RIGHT(\"0000000\"&入力シート!$F$52,7),4,1))","v":""},{"$f":"IF(入力シート!$F$52=\"\",\"\",MIDB(RIGHT(\"0000000\"&入力シート!$F$52,7),5,1))","v":""},{"$f":"IF(入力シート!$F$52=\"\",\"\",MIDB(RIGHT(\"0000000\"&入力シート!$F$52,7),6,1))","v":""},{"$f":"IF(入力シート!$F$52=\"\",\"\",MIDB(RIGHT(\"0000000\"&入力シート!$F$52,7),7,1))","v":""},"種別",null,{"$f":"IF(入力シート!F51=\"\",\"\",入力シート!F51)","v":""}]
[null,null,null,"口座名義",null,null,{"$f":"IF(入力シート!F53=\"\",\"\",入力シート!F53)","v":""},null,null,null,null,null,null,null,null,null,null,"口座名義ｶﾅ",null,null,{"$f":"IF(入力シート!F54=\"\",\"\",入力シート!F54)","v":""}]
[null,null,"でんさい","コード",null,null,{"$f":"IF(入力シート!$F$55=\"\",\"\",MIDB(ASC(入力シート!$F$55),1,1))","v":""},{"$f":"IF(ASC(入力シート!$F$55)=\"\",\"\",MIDB(ASC(入力シート!$F$55),2,1))","v":""},{"$f":"IF(ASC(入力シート!$F$55)=\"\",\"\",MIDB(ASC(入力シート!$F$55),3,1))","v":""},{"$f":"IF(ASC(入力シート!$F$55)=\"\",\"\",MIDB(ASC(入力シート!$F$55),4,1))","v":""},{"$f":"IF(ASC(入力シート!$F$55)=\"\",\"\",MIDB(ASC(入力シート!$F$55),5,1))","v":""},{"$f":"IF(ASC(入力シート!$F$55)=\"\",\"\",MIDB(ASC(入力シート!$F$55),6,1))","v":""},{"$f":"IF(ASC(入力シート!$F$55)=\"\",\"\",MIDB(ASC(入力シート!$F$55),7,1))","v":""},{"$f":"IF(ASC(入力シート!$F$55)=\"\",\"\",MIDB(ASC(入力シート!$F$55),8,1))","v":""},{"$f":"IF(ASC(入力シート!$F$55)=\"\",\"\",MIDB(ASC(入力シート!$F$55),9,1))","v":""}]
[null,null,null,"金融機関C",null,null,{"$f":"IF(入力シート!$F$56=\"\",\"\",MIDB(入力シート!$F$56,1,1))","v":""},{"$f":"IF(入力シート!$F$56=\"\",\"\",MIDB(入力シート!$F$56,2,1))","v":""},{"$f":"IF(入力シート!$F$56=\"\",\"\",MIDB(入力シート!$F$56,3,1))","v":""},{"$f":"IF(入力シート!$F$56=\"\",\"\",MIDB(入力シート!$F$56,4,1))","v":""},{"$f":"IF(入力シート!$F$56=\"\",\"\",MIDB(入力シート!$F$56,5,1))","v":""},{"$f":"IF(入力シート!$F$56=\"\",\"\",MIDB(入力シート!$F$56,6,1))","v":""},{"$f":"IF(入力シート!$F$56=\"\",\"\",MIDB(入力シート!$F$56,7,1))","v":""},"銀行名称",null,null,{"$f":"IF(入力シート!F57=\"\",\"\",入力シート!F57)&IF(入力シート!F58=\"\",\"\",\" \"&入力シート!F58)","v":""}]
[null,null,null,"口座番号",null,null,{"$f":"IF(入力シート!$F$60=\"\",\"\",MIDB(RIGHT(\"0000000\"&入力シート!$F$60,7),1,1))","v":""},{"$f":"IF(入力シート!$F$60=\"\",\"\",MIDB(RIGHT(\"0000000\"&入力シート!$F$60,7),2,1))","v":""},{"$f":"IF(入力シート!$F$60=\"\",\"\",MIDB(RIGHT(\"0000000\"&入力シート!$F$60,7),3,1))","v":""},{"$f":"IF(入力シート!$F$60=\"\",\"\",MIDB(RIGHT(\"0000000\"&入力シート!$F$60,7),4,1))","v":""},{"$f":"IF(入力シート!$F$60=\"\",\"\",MIDB(RIGHT(\"0000000\"&入力シート!$F$60,7),5,1))","v":""},{"$f":"IF(入力シート!$F$60=\"\",\"\",MIDB(RIGHT(\"0000000\"&入力シート!$F$60,7),6,1))","v":""},{"$f":"IF(入力シート!$F$60=\"\",\"\",MIDB(RIGHT(\"0000000\"&入力シート!$F$60,7),7,1))","v":""},"種別",null,{"$f":"IF(入力シート!F59=\"\",\"\",入力シート!F59)","v":""}]
[null,null,null,"口座名義",null,null,{"$f":"IF(入力シート!F61=\"\",\"\",入力シート!F61)","v":""},null,null,null,null,null,null,null,null,null,null,"口座名義ｶﾅ",null,null,{"$f":"IF(入力シート!F62=\"\",\"\",入力シート!F62)","v":""}]
[null,null,"手形","受取人名称",null,null,{"$f":"IF(入力シート!F63=\"\",\"\",入力シート!F63)","v":""}]
[null,null,null,"集金方法",null,null,{"$f":"IF(入力シート!F64=\"\",\"\",入力シート!F64)","v":""}]
[]
[null,null,"ご案内",null,null,"・登録記載内容に変更が生じた場合は、遅滞なく登録票を再提出願います。"]
[null,null,null,null,null,"・弊社指定請求書には、必ず「取引先コード」をご記入願います。"]
[null,null,null,null,null,"・取引先登録票をご提出の際は貴社の現在事項全部証明書(3か月以内、コピー可)もあわせてご提出願います。"]
[]
[]
[]
[null,null,"E & C S　社内処理欄"]
[null,null,"支払条件",null,null,null,null,null,null,null,null,"登録部署",null,null,null,"登録区分",null,null,null,null,null,"検印",null,null,null,null,null,null,"担当者"]
[null,null,"現金手形比率",null,null,null,"：",null,null,null,null,null,null,null,null,"新規 ・ 変更"]
[null,null,"手形サイト",null,null,null,null,null,"日"]
[null,null,"支払方法",null,null,null,"でんさい  約束手形"]
[null,null,"備考"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"更新日：2019年 5月 1日"]

{"sheet":"【記入例】入力シート","index":2,"n_rows":55,"n_cols":10,"rows_kept":55,"cut":false,"hidden":false,"merged":[[52,2,52,4],[52,5,52,21],[53,1,54,1],[53,2,53,4],[53,5,53,21],[54,2,54,4],[54,5,54,7],[54,8,54,21],[48,5,48,21],[49,2,49,4],[49,5,49,21],[50,2,50,4],[50,5,50,21],[51,2,51,4],[51,5,51,21],[45,1,52,1],[45,2,45,4],[45,5,45,8],[45,9,45,21],[46,2,46,4],[46,5,46,8],[46,9,46,21],[47,2,47,4],[47,5,47,21],[43,5,43,21],[44,2,44,4],[44,5,44,21],[39,2,39,4],[39,5,39,21],[40,2,40,4],[40,5,40,21],[41,2,41,4],[41,5,41,21],[36,5,36,8],[36,9,36,21],[37,2,37,4],[37,5,37,8],[37,9,37,21],[38,0,54,0],[38,1,44,1],[38,2,38,4],[38,5,38,8],[38,9,38,21],[32,0,37,1],[32,2,32,4],[32,5,32,21],[33,2,33,4],[33,5,33,21],[34,2,34,4],[34,5,34,21],[35,2,35,4],[35,5,35,21],[36,2,36,4],[48,2,48,4],[42,2,42,4],[42,5,42,21],[43,2,43,4],[29,5,29,8],[29,9,29,21],[30,2,30,4],[30,5,30,8],[30,9,30,21],[31,2,31,4],[31,5,31,21],[25,0,31,1],[25,2,25,4],[25,5,25,21],[26,2,26,4],[26,5,26,21],[27,2,27,4],[27,5,27,21],[28,2,28,4],[28,5,28,21],[29,2,29,4],[22,2,22,4],[22,5,22,21],[23,2,23,4],[23,5,23,21],[24,2,24,4],[24,5,24,21],[20,2,20,4],[20,5,20,8],[20,9,20,21],[21,2,21,4],[21,5,21,8],[21,9,21,21],[18,2,18,4],[18,5,18,21],[19,2,19,4],[19,5,19,21],[14,2,14,4],[14,5,14,21],[15,2,15,4],[15,5,15,21],[16,2,16,4],[16,5,16,21],[8,2,8,4],[8,5,8,8],[8,9,8,21],[9,2,9,4],[9,5,9,21],[10,2,10,4],[10,5,10,21],[17,2,17,4],[17,5,17,21],[0,0,0,21],[5,2,5,4],[5,5,5,8],[5,9,5,21],[6,2,6,4],[6,5,6,21],[7,2,7,4],[7,5,7,8],[7,9,7,21],[2,0,2,4],[2,5,2,21],[3,0,24,1],[3,2,3,4],[3,5,3,8],[3,9,3,21],[4,2,4,4],[4,5,4,7],[4,9,4,21],[11,2,11,4],[11,5,11,21],[12,2,12,4],[12,5,12,21],[13,2,13,4],[13,5,13,21]]}
["取引先登録票 記入例"]
[]
["項目",null,null,null,null,"入力・備考"]
["登録基本情報",null,"提出日",null,null,"2019-05-01"]
[null,null,"登録区分",null,null,"変更",null,null,null,{"$f":"IF(AND(F6<>\"\",F9<>\"\"),\"\",IF(F5=\"変更\",\"※変更の場合は変更事由及び取引先ｺｰﾄﾞも記入ください\",\"\"))","v":""}]
[null,null,"変更内容",null,null,"その他",null,null,null,{"$f":"IF(F6=\"その他\",\"※変更内容がその他の場合その他変更内容もご記入ください\",\"\")","v":"※変更内容がその他の場合その他変更内容もご記入ください"}]
[null,null,"変更事由メモ",null,null,"会社名・代表者名・住所"]
[null,null,"旧社名",null,null,"飛島物産株式会社",null,null,null,{"$f":"IF(F8<>\"\",\"\",IF(F6=\"会社名\",\"※会社名変更の場合は、旧社名をご記入ください\",\"\"))","v":""}]
[null,null,"取引先コード",null,null,"00000100",null,null,null,"※変更の場合はこちらもご記入ください"]
[null,null,"会社名",null,null,"株式会社　Ｅ＆ＣＳ"]
[null,null,"会社名カナ",null,null,"ｶ)ｲｰｱﾝﾄﾞｼｰｴｽ"]
[null,null,"代表者役職・氏名",null,null,"東日本支店長 山田 太郎"]
[null,null,"代表者カナ",null,null,"ﾋｶﾞｼﾆﾎﾝｼﾃﾝﾁｮｳ ﾔﾏﾀﾞ ﾀﾛｳ"]
[null,null,"資本金(百万単位)",null,null,180]
[null,null,"支店・部署名等",null,null,"東日本支店"]
[null,null,"支店・部署ガナ",null,null,"ﾋｶﾞｼﾆﾎﾝｼﾃﾝ"]
[null,null,"郵便番号",null,null,"213-0012"]
[null,null,"住所",null,null,"神奈川県川崎市高津区坂戸3-2-1"]
[null,null,"住所カナ",null,null,"ｶﾅｶﾞﾜｹﾝｶﾜｻｷｼﾀｶﾂｸｻｶﾄﾞ"]
[null,null,"ビル名等",null,null,"ＫＳＰ西棟506号室"]
[null,null,"ＴＥＬ",null,null,"090-2631-6964",null,null,null,"※番号の区切りについては-（ハイフォン）をご使用ください"]
[null,null,"ＦＡＸ",null,null,"044-829-6794",null,null,null,"※番号の区切りについては-（ハイフォン）をご使用ください"]
[null,null,"E-Mail",null,null,"ichirousatou@kk-ecs.co.jp"]
[null,null,"担当者部署・氏名",null,null,"東日本支店　佐藤 一郎"]
[null,null,"担当者カナ",null,null,"ﾋｶﾞｼﾆﾎﾝｼﾃﾝ ｻﾄｳ ｲﾁﾛｳ"]
["支払案内送付先",null,"郵便番号",null,null,"102-8332"]
[null,null,"住所",null,null,"東京都千代田区三番町２"]
[null,null,"住所カナ",null,null,"ﾄｳｷｮｳﾄ ﾁﾖﾀﾞｸ ｻﾝﾊﾞﾝﾁｮｳ"]
[null,null,"ビル名等",null,null,"飛島建設 本社ビル２Ｆ"]
[null,null,"ＴＥＬ",null,null,"03-5275-3123",null,null,null,"※番号の区切りについては-（ハイフォン）をご使用ください"]
[null,null,"ＦＡＸ",null,null,"03-3288-6510",null,null,null,"※番号の区切りについては-（ハイフォン）をご使用ください"]
[null,null,"E-Mail",null,null,"keikatou@kk-ecs.co.jp"]
["本社所在地",null,"郵便番号",null,null,"102-8332"]
[null,null,"住所",null,null,"東京都千代田区三番町２"]
[null,null,"住所カナ",null,null,"ﾄｳｷｮｳﾄ ﾁﾖﾀﾞｸ ｻﾝﾊﾞﾝﾁｮｳ"]
[null,null,"ビル名等",null,null,"飛島建設 本社ビル２Ｆ"]
[null,null,"ＴＥＬ",null,null,"03-5275-3122",null,null,null,"※番号の区切りについては-（ハイフォン）をご使用ください"]
[null,null,"ＦＡＸ",null,null,"03-3288-6509",null,null,null,"※番号の区切りについては-（ハイフォン）をご使用ください"]
["支払情報","振込","金融機関コード",null,null,"1234567",null,null,null,"※金融機関ごとの7ケタのコード、通常は通帳に記載があります"]
[null,null,"金融機関名",null,null,"みずほ銀行"]
[null,null,"支店名",null,null,"大手町営業部"]
[null,null,"口座種別",null,null,"当座"]
[null,null,"口座番号",null,null,19602]
[null,null,"口座名義",null,null,"株式会社　Ｅ＆ＣＳ"]
[null,null,"名義カナ",null,null,"ｶ)ｲｰｱﾝﾄﾞｼｰｴｽ"]
[null,"でんさいネット","利用者番号",null,null,"000003WH0",null,null,null,"※全銀電子債権ネットワークが発行する9ケタの番号"]
[null,null,"金融機関コード",null,null,"2345678",null,null,null,"※金融機関ごとの7ケタのコード、通常は通帳に記載があります"]
[null,null,"金融機関名",null,null,"みずほ銀行"]
[null,null,"支店名",null,null,"大手町営業部"]
[null,null,"口座種別",null,null,"当座"]
[null,null,"口座番号",null,null,19614]
[null,null,"口座名義",null,null,"株式会社　Ｅ＆ＣＳ"]
[null,null,"名義カナ",null,null,"ｶ)ｲｰｱﾝﾄﾞｼｰｴｽ"]
[null,"手形","受取人名",null,null,"株式会社　Ｅ＆ＣＳ"]
[null,null,"支払方法",null,null,"本社集金",null,null,{"$f":"IF(F55=\"\",\"\",IF(F55=\"本社集金\",\"※集金対応は弊社本社のみです。\",\"\"))","v":"※集金対応は弊社本社のみです。"}]