{"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":72,"n_cols":44,"rows_kept":72,"cut":false,"hidden":false,"merged":[[6,3,6,8],[31,2,31,4],[30,2,30,4],[44,2,44,4],[32,2,32,4],[38,5,38,21],[28,2,28,4],[26,5,26,21],[35,5,35,8],[34,9,34,21],[35,9,35,21],[36,5,36,21],[21,2,21,4],[25,2,25,4],[24,2,24,4],[19,2,19,4],[19,5,19,21],[20,5,20,8],[25,5,25,21],[16,2,16,4],[20,9,20,21],[23,2,23,4],[21,9,21,21],[22,2,22,4],[70,1,71,1],[70,2,70,4],[71,2,71,4],[70,5,70,21],[62,1,69,1],[52,2,52,4],[39,2,39,4],[40,2,40,4],[67,2,67,4],[55,1,61,1],[53,2,53,4],[54,2,54,4],[50,2,50,4],[51,2,51,4],[41,2,41,4],[49,2,49,4],[42,2,42,4],[49,0,54,1],[55,0,71,0],[43,2,43,4],[48,2,48,4],[39,0,48,1],[59,2,59,4],[61,2,61,4],[68,2,68,4],[69,2,69,4],[62,2,62,4],[71,5,71,7],[71,8,71,21],[52,5,52,21],[50,5,50,21],[51,5,51,21],[49,5,49,21],[58,5,58,21],[55,9,55,21],[56,5,56,21],[57,5,57,21],[59,5,59,21],[60,5,60,21],[61,5,61,21],[63,5,63,8],[68,5,68,21],[55,5,55,8],[57,2,57,4],[58,2,58,4],[66,2,66,4],[60,2,60,4],[55,2,55,4],[69,5,69,21],[45,15,48,21],[62,5,62,8],[62,9,62,21],[43,9,43,21],[44,9,44,21],[53,9,53,21],[15,5,15,21],[17,9,17,21],[16,9,16,21],[18,9,18,21],[27,5,27,21],[30,5,30,21],[17,5,17,7],[23,5,23,21],[46,5,46,14],[47,5,47,14],[48,5,48,14],[66,5,66,21],[67,5,67,21],[44,5,44,8],[37,5,37,21],[40,5,40,21],[39,5,39,21],[15,0,15,4],[28,5,28,21],[29,5,29,21],[20,2,20,4],[16,5,16,8],[18,5,18,8],[21,5,21,8],[24,5,24,21],[22,5,22,21],[17,2,17,4],[18,2,18,4],[27,2,27,4],[16,0,38,1],[26,2,26,4],[31,5,31,21],[32,5,32,21],[33,5,33,21],[33,2,33,4],[29,2,29,4],[35,2,35,4],[36,2,36,4],[37,2,37,4],[34,5,34,8],[63,2,63,4],[64,2,64,4],[65,2,65,4],[54,9,54,21],[53,5,53,8],[54,5,54,8],[43,5,43,8],[63,9,63,21],[64,5,64,21],[65,5,65,21],[46,2,46,4],[45,2,45,4],[47,2,47,4],[45,5,45,14],[34,2,34,4],[38,2,38,4],[56,2,56,4],[41,5,41,21],[42,5,42,21]]}
[null,"入力上の注意事項（別添記入例もご参照ください）"]
[null,"① 支払通知書配信先メールアドレス・担当者名は必ずご入力ください。"]
[null,"  　本社所在地は登録基本情報と異なる場合のみご記入ください。"]
[null,"② お手数ですが、変更の場合でも必要事項をすべてご記入ください。"]
[null,"③ でんさいネット情報についてご不明の点がございましたら、下記のリンクをクリックしてください。"]
[null,null,"でんさいネットのHPが閲覧できます。"]
[null,null,"URL：","https://www.densai.net/"]
[null,null,"なお、ご不明の点がございましたら、本社管理部 TEL 044-455-7142 までご連絡ください。"]
[null,"④","登録票印刷ボタンをクリックし登録票本紙を印刷してください。"]
[null,"⑤","本紙に会社名・代表者名のゴム印（ゴム印がない場合は手書き）・代表者印をご捺印の上、"]
[null,null,"当社の担当者までPDFにてメール送信いただき、本書はご郵送ください。"]
[null,null,"取引先登録票をご提出の際は貴社の現在事項全部証明書(3か月以内、コピー可)もあわせてご提出願います。"]
[]
[]
[]
["項目",null,null,null,null,"入力・備考",null,null,null,null,null,null,null,null,null,null,null,null,null,null,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=\"\",1,0)","v":1}]
[null,null,"登録区分",null,null,null,null,null,null,{"$f":"IF(AND(F19<>\"\",F22<>\"\"),\"\",IF(F18=\"変更\",\"※変更の場合は変更事由及び取引先ｺｰﾄﾞも記入ください\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F18=\"\",1,0)","v":1}]
[null,null,"変更内容",null,null,null,null,null,null,{"$f":"IF(F19=\"その他\",\"※変更内容がその他の場合その他変更内容もご記入ください\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($F$18=\"変更\",F19=\"\"),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(F19=\"その他\",F20=\"\"),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(F21<>\"\",\"\",IF(F19=\"会社名\",\"※会社名変更の場合は、旧社名をご記入ください\",\"\"))","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$18=\"変更\",F22=\"\"),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,{"$f":"IF(F24=\"\",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(F25=\"\",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(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,"支店・部署ガナ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(F35=\"\",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(F36=\"\",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(F37=\"\",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(F38=\"\",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(F39=\"\",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,"※配信先は必ず２名様分\nご登録ください"]
[null,null,"配信先1（E-Mail）"]
[null,null,"配信先2（担当者）"]
[null,null,"配信先2（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(F72=\"\",\"\",IF(F72=\"本社集金\",\"※集金対応は弊社本社のみです。\",\"\"))","v":""}]

{"sheet":"登録票","index":1,"n_rows":61,"n_cols":31,"rows_kept":61,"cut":false,"hidden":false,"merged":[[24,5,24,7],[23,8,23,30],[24,8,24,30],[22,22,22,30],[23,2,23,4],[46,6,46,30],[47,6,47,30],[46,3,46,5],[47,3,47,5],[30,5,30,7],[42,15,42,30],[41,3,41,5],[40,13,40,14],[40,15,40,16],[39,13,39,15],[37,2,37,4],[37,5,37,9],[37,10,37,12],[37,13,37,17],[37,18,37,20],[37,21,37,25],[37,26,37,30],[42,3,42,5],[39,3,39,5],[0,25,0,26],[1,2,1,30],[2,2,2,30],[5,14,5,21],[5,23,5,30],[21,2,21,4],[21,5,21,18],[21,19,21,21],[21,22,21,30],[13,2,13,9],[11,25,11,30],[12,25,19,30],[11,10,11,24],[12,10,19,24],[7,23,7,30],[18,2,19,9],[3,2,3,30],[12,2,12,9],[11,2,11,9],[14,2,17,9],[9,2,9,13],[9,14,9,30],[26,5,26,15],[26,16,26,18],[29,2,29,4],[30,2,30,4],[27,2,27,4],[27,10,27,12],[27,5,27,9],[27,13,27,17],[27,21,27,30],[27,18,27,20],[26,19,26,30],[25,19,25,30],[26,2,26,4],[24,2,24,4],[22,2,22,4],[22,5,22,18],[22,19,22,21],[25,2,25,4],[25,5,25,15],[25,16,25,18],[23,5,23,7],[31,10,31,12],[31,13,31,17],[30,8,30,30],[29,5,29,7],[29,8,29,30],[35,5,35,7],[35,8,35,30],[31,18,31,30],[36,2,36,4],[31,2,31,4],[32,2,32,4],[33,2,33,4],[32,13,32,15],[33,13,33,15],[35,2,35,4],[36,5,36,7],[36,8,36,30],[32,5,32,12],[33,5,33,12],[32,16,32,30],[33,16,33,30],[31,5,31,9],[49,2,51,4],[49,5,49,30],[46,2,47,2],[43,3,43,5],[45,3,45,5],[43,13,43,15],[51,5,51,30],[50,5,50,30],[40,3,40,5],[42,2,45,2],[39,2,41,2],[43,16,43,30],[44,3,44,5],[44,13,44,14],[44,15,44,16],[44,17,44,30],[45,6,45,16],[45,17,45,19],[45,20,45,30],[39,16,39,30],[41,17,41,19],[41,20,41,30],[41,6,41,16],[40,17,40,30],[54,2,54,30],[55,2,55,10],[56,2,56,5],[57,2,57,5],[58,2,58,5],[57,6,57,7],[58,6,58,10],[59,2,59,5],[56,6,56,8],[56,9,56,10],[57,9,57,10],[56,28,59,30],[55,11,55,14],[55,15,55,20],[55,28,55,30],[56,11,59,14],[56,15,59,20],[55,21,55,27],[56,21,59,27]]}
[]
[]
[null,null,"取　引　先　登　録　票"]
[null,null,"(でんさい対応版）"]
[]
[null,null,null,"株式会社Ｅ＆ＣＳ",null,null,null,null,null,null,"御中",null,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=\"\",\"\",MIDB(入力シート!F22,1,1))","v":""},{"$f":"IF(入力シート!F22=\"\",\"\",MIDB(入力シート!F22,2,1))","v":""},{"$f":"IF(入力シート!F22=\"\",\"\",MIDB(入力シート!F22,3,1))","v":""},{"$f":"IF(入力シート!F22=\"\",\"\",MIDB(入力シート!F22,4,1))","v":""},{"$f":"IF(入力シート!F22=\"\",\"\",MIDB(入力シート!F22,5,1))","v":""},{"$f":"IF(入力シート!F22=\"\",\"\",MIDB(入力シート!F22,6,1))","v":""},{"$f":"IF(入力シート!F22=\"\",\"\",MIDB(入力シート!F22,7,1))","v":""},{"$f":"IF(入力シート!F22=\"\",\"\",MIDB(入力シート!F22,8,1))","v":""},null,{"$f":"DBCS(IF(入力シート!F17=\"\",\"　　年　　月　　日\",YEAR(入力シート!F17)&\"年\"&RIGHT(\" \"&MONTH(入力シート!F17),2)&\"月\"&RIGHT(\" \"&DAY(入力シート!F17),2)&\"日\"))","v":"　　年　　月　　日"}]
[]
[null,null,"適格請求書発行事業者登録番号",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(入力シート!F23=\"\",\"\",入力シート!F23)","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(入力シート!F18=\"\",\"\",入力シート!F18)","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(入力シート!F63=\"\",\"\",\"不要\")","v":""}]
[null,null,"変更事由"]
[null,null,{"$f":"IF(入力シート!F20=\"\",\"\",入力シート!F20)","v":""}]
[]
[]
[]
[null,null,{"$f":"IF(入力シート!F21=\"\",\"\",\"旧社名：\"&入力シート!F21)","v":""}]
[]
[null,null,"（お取引先情報）"]
[null,null,"フリガナ",null,null,{"$f":"IF(入力シート!F25=\"\",\"\",入力シート!F25)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"フリガナ",null,null,{"$f":"IF(入力シート!F30=\"\",\"\",入力シート!F30)","v":""}]
[null,null,"会社名",null,null,{"$f":"IF(入力シート!F24=\"\",\"\",入力シート!F24)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"支店名他",null,null,{"$f":"IF(入力シート!F29=\"\",\"\",入力シート!F29)","v":""}]
[null,null,"フリガナ",null,null,null,null,null,{"$f":"IF(入力シート!F33=\"\",\"\",入力シート!F33)","v":""}]
[null,null,"住所",null,null,{"$f":"IF(入力シート!F31=\"\",\"\",\"〒\"&入力シート!F31)","v":""},null,null,{"$f":"IF(入力シート!F32=\"\",\"\",入力シート!F32&IF(入力シート!F34=\"\",\"\",\" \"&入力シート!F34))","v":""}]
[null,null,"フリガナ",null,null,{"$f":"IF(入力シート!F27=\"\",\"\",入力シート!F27)","v":""},null,null,null,null,null,null,null,null,null,null,"フリガナ",null,null,{"$f":"IF(入力シート!F39=\"\",\"\",入力シート!F39)","v":""}]
[null,null,"代表者名",null,null,{"$f":"IF(入力シート!F26=\"\",\"\",入力シート!F26)","v":""},null,null,null,null,null,null,null,null,null,null,"担当者部署\n担当者氏名",null,null,{"$f":"IF(入力シート!F38=\"\",\"\",入力シート!F38)","v":""}]
[null,null,"ＴＥＬ",null,null,{"$f":"IF(入力シート!F35=\"\",\"\",入力シート!F35)","v":""},null,null,null,null,"ＦＡＸ",null,null,{"$f":"IF(入力シート!F36=\"\",\"\",入力シート!F36)","v":""},null,null,null,null,"E-Mail",null,null,{"$f":"IF(入力シート!F37=\"\",\"\",入力シート!F37)","v":""}]
[null,null,"（支払通知書配信先）"]
[null,null,"フリガナ",null,null,null,null,null,{"$f":"IF(入力シート!F42=\"\",\"\",入力シート!F42)","v":""}]
[null,null,"住所",null,null,{"$f":"IF(入力シート!F40=\"\",\"\",\"〒\"&入力シート!F40)","v":""},null,null,{"$f":"IF(入力シート!F41=\"\",\"\",入力シート!F41&IF(入力シート!F43=\"\",\"\",\" \"&入力シート!F43))","v":""}]
[null,null,"ＴＥＬ",null,null,{"$f":"IF(入力シート!F44=\"\",\"\",入力シート!F44)","v":""},null,null,null,null,"ＦＡＸ",null,null,{"$f":"IF(入力シート!F45=\"\",\"\",入力シート!F45)","v":""}]
[null,null,"配信先１",null,null,{"$f":"IF(入力シート!F46=\"\",\"\",入力シート!F46)","v":""},null,null,null,null,null,null,null,"E-Mail　1",null,null,{"$f":"IF(入力シート!F47=\"\",\"\",入力シート!F47)","v":""}]
[null,null,"配信先２",null,null,{"$f":"IF(入力シート!F48=\"\",\"\",入力シート!F48)","v":""},null,null,null,null,null,null,null,"E-Mail　2",null,null,{"$f":"IF(入力シート!F49=\"\",\"\",入力シート!F49)","v":""}]
[null,null,"（本社所在地）"]
[null,null,"フリガナ",null,null,null,null,null,{"$f":"IF(入力シート!F52=\"\",\"\",入力シート!F52)","v":""}]
[null,null,"住所",null,null,{"$f":"IF(入力シート!F50=\"\",\"\",\"〒\"&入力シート!F50)","v":""},null,null,{"$f":"IF(入力シート!F51=\"\",\"\",入力シート!F51&IF(入力シート!F53=\"\",\"\",\" \"&入力シート!F53))","v":""}]
[null,null,"ＴＥＬ",null,null,{"$f":"IF(入力シート!F54=\"\",\"\",入力シート!F54)","v":""},null,null,null,null,"ＦＡＸ",null,null,{"$f":"IF(入力シート!F55=\"\",\"\",入力シート!F55)","v":""},null,null,null,null,"資本金",null,null,{"$f":"IF(入力シート!F28=\"\",\"\",入力シート!F28)","v":""}]
[null,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(入力シート!$F$63=\"\",\"\",MIDB(ASC(入力シート!$F$63),1,1))","v":""},{"$f":"IF(ASC(入力シート!$F$63)=\"\",\"\",MIDB(ASC(入力シート!$F$63),2,1))","v":""},{"$f":"IF(ASC(入力シート!$F$63)=\"\",\"\",MIDB(ASC(入力シート!$F$63),3,1))","v":""},{"$f":"IF(ASC(入力シート!$F$63)=\"\",\"\",MIDB(ASC(入力シート!$F$63),4,1))","v":""},{"$f":"IF(ASC(入力シート!$F$63)=\"\",\"\",MIDB(ASC(入力シート!$F$63),5,1))","v":""},{"$f":"IF(ASC(入力シート!$F$63)=\"\",\"\",MIDB(ASC(入力シート!$F$63),6,1))","v":""},{"$f":"IF(ASC(入力シート!$F$63)=\"\",\"\",MIDB(ASC(入力シート!$F$63),7,1))","v":""},{"$f":"IF(ASC(入力シート!$F$63)=\"\",\"\",MIDB(ASC(入力シート!$F$63),8,1))","v":""},{"$f":"IF(ASC(入力シート!$F$63)=\"\",\"\",MIDB(ASC(入力シート!$F$63),9,1))","v":""}]
[null,null,null,"金融機関C",null,null,{"$f":"IF(入力シート!$F$64=\"\",\"\",MIDB(入力シート!$F$64,1,1))","v":""},{"$f":"IF(入力シート!$F$64=\"\",\"\",MIDB(入力シート!$F$64,2,1))","v":""},{"$f":"IF(入力シート!$F$64=\"\",\"\",MIDB(入力シート!$F$64,3,1))","v":""},{"$f":"IF(入力シート!$F$64=\"\",\"\",MIDB(入力シート!$F$64,4,1))","v":""},{"$f":"IF(入力シート!$F$64=\"\",\"\",MIDB(入力シート!$F$64,5,1))","v":""},{"$f":"IF(入力シート!$F$64=\"\",\"\",MIDB(入力シート!$F$64,6,1))","v":""},{"$f":"IF(入力シート!$F$64=\"\",\"\",MIDB(入力シート!$F$64,7,1))","v":""},"銀行名称",null,null,{"$f":"IF(入力シート!F65=\"\",\"\",入力シート!F65)&IF(入力シート!F66=\"\",\"\",\" \"&入力シート!F66)","v":""}]
[null,null,null,"口座番号",null,null,{"$f":"IF(入力シート!$F$68=\"\",\"\",MIDB(RIGHT(\"0000000\"&入力シート!$F$68,7),1,1))","v":""},{"$f":"IF(入力シート!$F$68=\"\",\"\",MIDB(RIGHT(\"0000000\"&入力シート!$F$68,7),2,1))","v":""},{"$f":"IF(入力シート!$F$68=\"\",\"\",MIDB(RIGHT(\"0000000\"&入力シート!$F$68,7),3,1))","v":""},{"$f":"IF(入力シート!$F$68=\"\",\"\",MIDB(RIGHT(\"0000000\"&入力シート!$F$68,7),4,1))","v":""},{"$f":"IF(入力シート!$F$68=\"\",\"\",MIDB(RIGHT(\"0000000\"&入力シート!$F$68,7),5,1))","v":""},{"$f":"IF(入力シート!$F$68=\"\",\"\",MIDB(RIGHT(\"0000000\"&入力シート!$F$68,7),6,1))","v":""},{"$f":"IF(入力シート!$F$68=\"\",\"\",MIDB(RIGHT(\"0000000\"&入力シート!$F$68,7),7,1))","v":""},"種別",null,{"$f":"IF(入力シート!F67=\"\",\"\",入力シート!F67)","v":""}]
[null,null,null,"口座名義",null,null,{"$f":"IF(入力シート!F69=\"\",\"\",入力シート!F69)","v":""},null,null,null,null,null,null,null,null,null,null,"口座名義ｶﾅ",null,null,{"$f":"IF(入力シート!F70=\"\",\"\",入力シート!F70)","v":""}]
[null,null,"手形","受取人名称",null,null,{"$f":"IF(入力シート!F71=\"\",\"\",入力シート!F71)","v":""}]
[null,null,null,"集金方法",null,null,{"$f":"IF(入力シート!F72=\"\",\"\",入力シート!F72)","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,"更新日：2024年 12月 1日"]

{"sheet":"【記入例】入力シート","index":2,"n_rows":59,"n_cols":16,"rows_kept":59,"cut":false,"hidden":false,"merged":[[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,25,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],[12,2,12,4],[12,5,12,21],[13,2,13,4],[13,5,13,21],[14,2,14,4],[14,5,14,21],[8,2,8,4],[8,5,8,8],[8,9,8,21],[10,2,10,4],[10,5,10,21],[11,2,11,4],[11,5,11,21],[18,2,18,4],[18,5,18,21],[9,2,9,4],[9,5,9,21],[19,2,19,4],[19,5,19,21],[20,2,20,4],[20,5,20,21],[15,2,15,4],[15,5,15,21],[16,2,16,4],[16,5,16,21],[17,2,17,4],[17,5,17,21],[23,2,23,4],[23,5,23,21],[24,2,24,4],[24,5,24,21],[25,2,25,4],[25,5,25,21],[21,2,21,4],[21,5,21,8],[21,9,21,21],[22,2,22,4],[22,5,22,8],[22,9,22,21],[30,5,30,8],[30,9,30,21],[31,2,31,4],[31,5,31,8],[31,9,31,21],[35,2,35,4],[26,0,35,1],[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],[29,5,29,21],[30,2,30,4],[32,2,32,4],[33,2,33,4],[34,2,34,4],[32,5,32,14],[32,15,35,21],[33,5,33,14],[34,5,34,14],[35,5,35,14],[40,5,40,8],[40,9,40,21],[41,2,41,4],[41,5,41,8],[41,9,41,21],[42,0,58,0],[42,1,48,1],[42,2,42,4],[42,5,42,8],[42,9,42,21],[36,0,41,1],[36,2,36,4],[36,5,36,21],[37,2,37,4],[37,5,37,21],[38,2,38,4],[38,5,38,21],[39,2,39,4],[39,5,39,21],[40,2,40,4],[52,2,52,4],[46,2,46,4],[46,5,46,21],[47,2,47,4],[47,5,47,21],[48,2,48,4],[48,5,48,21],[43,2,43,4],[43,5,43,21],[44,2,44,4],[44,5,44,21],[45,2,45,4],[45,5,45,21],[56,2,56,4],[56,5,56,21],[57,1,58,1],[57,2,57,4],[57,5,57,21],[58,2,58,4],[58,5,58,7],[58,8,58,21],[52,5,52,21],[53,2,53,4],[53,5,53,21],[54,2,54,4],[54,5,54,21],[55,2,55,4],[55,5,55,21],[49,1,56,1],[49,2,49,4],[49,5,49,8],[49,9,49,21],[50,2,50,4],[50,5,50,8],[50,9,50,21],[51,2,51,4],[51,5,51,21]]}
["取引先登録票 記入例"]
[]
["項目",null,null,null,null,"入力・備考"]
["登録基本情報",null,"提出日",null,null,"2024-12-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,"T1234567890123"]
[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,"配信先１（担当者）",null,null,"東日本支店　佐藤 一郎",null,null,null,null,null,null,null,null,null,"※配信先は必ず２名様分\nご登録ください"]
[null,null,"配信先1（E-Mail）",null,null,"ichirousatou@kk-ecs.co.jp"]
[null,null,"配信先2（担当者）",null,null,"経理部　鈴木 二郎"]
[null,null,"配信先2（E-Mail）",null,null,"jirousuzuki@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(F59=\"\",\"\",IF(F59=\"本社集金\",\"※集金対応は弊社本社のみです。\",\"\"))","v":"※集金対応は弊社本社のみです。"}]