{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["読込定例出金下水道","印刷定例出金下水道","ukagai_output"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":89,"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":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["読込FLG","全伝票始まり"]
[10,"予算科目CD","借方科目CD","貸方科目CD","金額増","金額減","摘要","発行日","消費税CD","消費税率","消費税額"]
[19,"予算伝票終わり",null,null,null,null,""]
[20,"簿記伝票始まり",null,null,null,null,""]
[21,"予算科目CD","借方科目CD","貸方科目CD","借方金額","貸方金額","摘要","発行日"]
[21,null,"335530-1000","151010-1000",67182693,67182693,"下水道使用料：都市部（上下併用）","2020-11-18",99]
[21,null,"335530-5000","151010-1000",543801,543801,"農業集落排水：東部（上下併用）","2020-11-18",99]
[21,null,"335530-3000","151010-1000",41321,41321,"下水道使用料：月ヶ瀬（上下併用）","2020-11-18",99]
[21,null,"335530-7000","151010-1000",77252,77252,"農業集落排水：月ヶ瀬（上下併用）","2020-11-18",99]
[21,null,"335530-2000","151010-1000",999,999,"下水道使用料：都市部（下水のみ）","2020-11-18",99]
[21,null,"335530-6000","151010-1000",999,999,"農業集落排水：東部（下水のみ）","2020-11-18",99]
[21,null,"335530-4000","151010-1000",41321,41321,"下水道使用料：月ヶ瀬（下水のみ）","2020-11-18",99]
[21,null,"335530-8000","151010-1000",77252,77252,"農業集落排水：月ヶ瀬（下水のみ）","2020-11-18",99]
[0]
[29,"簿記伝票終わり"]
[999,"全伝票終わり"]

{"sheet":"印刷定例出金下水道","index":1,"n_rows":36,"n_cols":100,"rows_kept":36,"cut":false,"hidden":false,"merged":[[24,1,24,15],[24,16,24,30],[24,31,24,45],[24,46,24,60],[30,60,30,75],[31,60,31,75],[26,1,26,45],[27,1,27,45],[28,1,28,45],[29,1,29,45],[30,1,30,45],[31,1,31,45],[32,1,32,45],[16,12,16,29],[16,30,16,48],[14,0,14,11],[14,12,14,30],[14,31,14,40],[21,46,21,60],[22,46,22,60],[21,1,21,15],[21,16,21,30],[23,1,23,15],[23,16,23,30],[23,31,23,45],[23,46,23,60],[29,60,29,75],[28,60,28,75],[27,60,27,75],[33,1,33,45],[27,46,27,59],[26,46,26,59],[28,46,28,59],[29,46,29,59],[0,0,0,79],[0,80,0,110],[1,0,1,79],[1,80,1,110],[2,0,6,0],[2,1,2,110],[3,1,3,11],[3,12,3,22],[3,23,3,33],[3,34,3,44],[7,0,11,0],[7,1,7,110],[8,1,8,11],[8,12,8,22],[8,23,8,33],[8,34,8,44],[8,45,8,55],[21,31,21,45],[16,49,16,65],[16,66,16,84],[16,85,16,96],[16,97,16,110],[15,97,15,110],[15,49,15,65],[15,66,15,84],[15,85,15,96],[20,0,20,13],[12,0,12,110],[13,0,13,11],[13,12,13,31],[13,32,13,51],[13,52,13,71],[13,72,13,81],[13,82,13,91],[13,92,13,110],[14,63,14,76],[14,77,14,88],[14,89,14,98],[14,99,14,110],[22,1,22,15],[22,16,22,30],[22,31,22,45],[14,41,14,46],[14,47,14,56],[18,0,18,11],[18,12,18,24],[18,25,18,55],[15,0,16,11],[15,12,15,29],[15,30,15,48],[26,76,26,105],[26,60,26,75],[34,60,34,75],[34,76,34,105],[32,60,32,75],[33,60,33,75],[31,76,31,105],[32,76,32,105],[33,76,33,105],[35,76,35,105],[27,76,27,105],[28,76,28,105],[29,76,29,105],[30,76,30,105],[35,60,35,75],[34,1,34,45],[35,1,35,45],[30,46,30,59],[31,46,31,59],[32,46,32,59],[33,46,33,59],[34,46,34,59],[35,46,35,59]]}
["予算執行伺",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"簿記伝票種類"]
["発行なし",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"入金伝票"]
["決　済","経営企画課"]
[null,"係　員",null,null,null,null,null,null,null,null,null,null,"係　長",null,null,null,null,null,null,null,null,null,null,"補　佐",null,null,null,null,null,null,null,null,null,null,"課　長"]
[]
[]
[]
["審　査","出納審査"]
[null,"係　員",null,null,null,null,null,null,null,null,null,null,"係　長",null,null,null,null,null,null,null,null,null,null,"補　佐",null,null,null,null,null,null,null,null,null,null,"主　幹",null,null,null,null,null,null,null,null,null,null,"企業出納員"]
[]
[]
[]
[]
["起案責任者",null,null,null,null,null,null,null,null,null,null,null,"経営企画課",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"係",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"池田 修"]
["起案日",null,null,null,null,null,null,null,null,null,null,null,"2021-02-23",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"予算伝票",null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"簿記伝票",null,null,null,null,null,null,null,null,null,16,null,null,null,null,null,"一件処理番号",null,null,null,null,null,null,null,null,null,null,null,null,null,152,null,null,null,null,null,null,null,null,null,null,null,"伺伝票ID",null,null,null,null,null,null,null,null,null,209]
["関連情報",null,null,null,null,null,null,null,null,null,null,null,"決済日",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"伝票発行日"]
[]
[]
["奈良市水道事業",null,null,null,null,null,null,null,null,null,null,null,2020]
["簿記伝票"]
["科目名称"]
[null,"科目１",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"科目２",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"科目３",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"科目４"]
["款","流動資産",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"流動資産",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"流動負債",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"流動負債"]
["項","現金預金",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"未収金",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"預り金",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"預り金"]
["目","現金預金",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"営業未収金",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"下水道使用料",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"雑預り金"]
[]
["明細","借方科目（節）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"貸方科目（節）",null,null,null,null,null,null,null,null,null,null,null,null,null,"借方/貸方金額",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"摘要"]
["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,67182693,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"下水道使用料（上水併用）"]
["2","科目３：農業集落排水施設使用料未収金（都市部・上水併用）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"科目１：現金預金",null,null,null,null,null,null,null,null,null,null,null,null,null,543801,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,"科目１：現金預金",null,null,null,null,null,null,null,null,null,null,null,null,null,41321,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"下水道使用料：月ヶ瀬"]
["4","科目３：農業集落排水施設使用料未収金（月ヶ瀬・上水併用）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"科目１：現金預金",null,null,null,null,null,null,null,null,null,null,null,null,null,77252,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"農業集落排水：月ヶ瀬"]
["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,null,null,null,null,null,null,"科目１：現金預金",null,null,null,null,null,null,null,null,null,null,null,null,null,999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"下水道使用料：下水のみ"]
["6","科目３：農業集落排水施設使用料未収金（都市部・下水のみ）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"科目１：現金預金",null,null,null,null,null,null,null,null,null,null,null,null,null,999,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"科目１：現金預金",null,null,null,null,null,null,null,null,null,null,null,null,null,41321,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"下水道使用料：月ヶ瀬・下水のみ"]
["8","科目３：農業集落排水施設使用料未収金（都市部・下水のみ）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"科目１：現金預金",null,null,null,null,null,null,null,null,null,null,null,null,null,77252,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"農業集落排水：月ヶ瀬・下水のみ"]
["9","科目４：過誤納預り金",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41321,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"過誤納：水道料金過誤納(都市部)"]

{"sheet":"ukagai_output","index":2,"n_rows":29,"n_cols":43,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["伝票種類","伝票種類CD","伺ID","一件処理番号","所属CD","起案日","予算伝票件数","簿記伝票件数","流用伺元件数","流用伺先件数","納付書出力CD","伝票番号","伺CD","所属名称","伺名称"]
["伺",1,209,152,10110000,"2021-02-23",0,16,null,null,null,null,null,"経営企画課"]
[]
["伝票種類","伝票種類CD","予算伝票ID","伺ID","連番","執行CD","一件処理番号","摘要名称","年度","予算CD","借方CD","貸方CD","金額増額","金額減額","借方金額","貸方金額","所属CD","発行日","処理FLG","消費税額","消費税CD","消費税率","伺CD","セグCD","簿記伝票ID","予備1","執行CD名称","予算科目名称","借方科目名称","貸方科目名称","予算款","予算款額","予算項","予算項額","予算目","予算目額","予算節","予算節額","所属名称","支出負担行為済額","支出命令済額","調定済額"]
[]
["伝票種類","伝票種類CD","簿記伝票ID","伺ID","連番","執行CD","一件処理番号","摘要名称","年度","予算CD","借方CD","貸方CD","金額増額","金額減額","借方金額","貸方金額","所属CD","発行日","処理FLG","消費税額","消費税CD","消費税率","伺CD","セグCD","簿記伝票ID","予備1","執行CD名称","予算科目名称","借方款","借方項","借方目","借方節","貸方款","貸方項","貸方目","貸方節","予算項","予算項額","予算目","予算目額","予算節","予算節額","所属名称"]
["簿記",3,70730,209,1,11,209,"水道料金：都市部",2020,"110101-0100","152010-1000","611010-1000",0,0,94380298,94380298,10110000,"2020-11-18",null,0,1,10,null,null,null,0,"調定","下水道料金収入","流動資産","未収金","営業未収金","下水道使用料未収金（上水併用）","下水道事業収益","営業収益","下水道使用料","下水道使用料","営業収益",7784862000,"下水道使用料",7762551000,"下水道使用料",7609711000,"経営企画課"]
["簿記",3,70730,209,1,11,209,"公共下水料金：都市部",2020,"110101-0100","152010-1000","336010-1000",0,0,67182693,67182693,10110000,"2020-11-18",null,0,1,10,null,null,null,0,"調定","下水道料金収入","流動資産","未収金","営業未収金","下水道使用料未収金（上水併用）","流動負債","その他流動負債","仮受消費税","仮受消費税","営業収益",7784862000,"下水道使用料",7762551000,"下水道使用料",7609711000,"経営企画課"]
["簿記",3,70731,209,1,11,209,"農業集落排水：都市部",2020,"110101-0100","152010-1000","611010-1000",0,0,543801,543801,10110000,"2020-11-18",null,0,1,10,null,null,null,0,"調定","下水道料金収入","流動資産","未収金","営業未収金","下水道使用料未収金（上水併用）","下水道事業収益","営業収益","下水道使用料","下水道使用料","営業収益",7784862000,"下水道使用料",7762551000,"下水道使用料",7609711000,"経営企画課"]
["簿記",3,70731,209,1,11,209,"水道料金：都祁",2020,"110101-0100","152010-1000","336010-1000",0,0,1322218,1322218,10110000,"2020-11-18",null,0,1,10,null,null,null,0,"調定","下水道料金収入","流動資産","未収金","営業未収金","下水道使用料未収金（上水併用）","流動負債","その他流動負債","仮受消費税","仮受消費税","営業収益",7784862000,"下水道使用料",7762551000,"下水道使用料",7609711000,"経営企画課"]
["簿記",3,70732,209,1,11,209,"水道料金：月ヶ瀬",2020,"110101-0100","152010-1000","611010-1000",0,0,134014,134014,10110000,"2020-11-18",null,0,1,10,null,null,null,0,"調定","下水道料金収入","流動資産","未収金","営業未収金","下水道使用料未収金（上水併用）","下水道事業収益","営業収益","下水道使用料","下水道使用料","営業収益",7784862000,"下水道使用料",7762551000,"下水道使用料",7609711000,"経営企画課"]
["簿記",3,70732,209,1,11,209,"公共下水料金：月ヶ瀬",2020,"110101-0100","152010-1000","336010-1000",0,0,41321,41321,10110000,"2020-11-18",null,0,1,10,null,null,null,0,"調定","下水道料金収入","流動資産","未収金","営業未収金","下水道使用料未収金（上水併用）","流動負債","その他流動負債","仮受消費税","仮受消費税","営業収益",7784862000,"下水道使用料",7762551000,"下水道使用料",7609711000,"経営企画課"]
["簿記",3,70733,209,1,11,209,"農業集落排水：月ヶ瀬",2020,"110503-0100","152010-1000","613020-1000",0,0,77252,77252,10110000,"2020-11-18",null,0,1,10,null,null,null,0,"調定","下水道料金収入","流動資産","未収金","営業未収金","下水道使用料未収金（上水併用）","下水道事業収益","営業収益","下水道使用料","下水道使用料","営業収益",7784862000,"下水道使用料",7762551000,"下水道使用料",7609711000,"経営企画課"]
["簿記",3,70737,209,1,11,209,"公共下水料金：都市部（下水のみ）",2020,"110503-0100","152010-1000","336010-1000",0,0,999,999,10110000,"2020-11-18",null,0,1,10,null,null,null,0,"調定","下水道料金収入","流動資産","未収金","営業未収金","下水道使用料未収金（上水併用）","流動負債","その他流動負債","仮受消費税","仮受消費税","営業収益",7784862000,"下水道使用料",7762551000,"下水道使用料",7609711000,"経営企画課"]
["簿記",3,70734,209,1,11,209,"農業集落排水：都市部（下水のみ）",2020,"110101-0100","611010-1000","152010-1000",0,0,999,999,10110000,"2020-11-18",null,0,1,10,null,null,null,0,"調定","下水道料金収入","流動資産","未収金","営業未収金","下水道使用料未収金（上水併用）","下水道事業収益","営業収益","下水道使用料","下水道使用料","営業収益",7784862000,"下水道使用料",7762551000,"下水道使用料",7609711000,"経営企画課"]
["簿記",3,70734,209,1,11,209,"公共下水料金：月ヶ瀬（下水のみ）",2020,"110101-0100","336010-1000","152010-1000",0,0,41321,41321,10110000,"2020-11-18",null,0,1,10,null,null,null,0,"調定","下水道料金収入","流動資産","未収金","営業未収金","下水道使用料未収金（上水併用）","流動負債","その他流動負債","仮受消費税","仮受消費税","営業収益",7784862000,"下水道使用料",7762551000,"下水道使用料",7609711000,"経営企画課"]
["簿記",3,70735,209,1,11,209,"農業集落排水：月ヶ瀬（下水のみ）",2020,"210507-0100","713040-1000","152010-1000",0,0,77252,77252,10110000,"2020-11-18",null,0,1,10,null,null,null,0,"調定","下水道料金収入","流動資産","未収金","営業未収金","下水道使用料未収金（上水併用）","下水道事業収益","営業収益","下水道使用料","下水道使用料","営業収益",7784862000,"下水道使用料",7762551000,"下水道使用料",7609711000,"経営企画課"]
["簿記",3,70732,209,1,11,209,"過誤納：水道料金過誤納(都市部)",2020,"110101-0100","152010-1000","336010-1000",0,0,41321,41321,10110000,"2020-11-18",null,0,1,10,null,null,null,0,"調定","下水道料金収入","流動資産","未収金","営業未収金","下水道使用料未収金（上水併用）","流動負債","その他流動負債","仮受消費税","仮受消費税","営業収益",7784862000,"下水道使用料",7762551000,"下水道使用料",7609711000,"経営企画課"]
["簿記",3,70733,209,1,11,209,"過誤納：水道料金過誤納(都祁)",2020,"110503-0100","152010-1000","613020-1000",0,0,77252,77252,10110000,"2020-11-18",null,0,1,10,null,null,null,0,"調定","下水道料金収入","流動資産","未収金","営業未収金","下水道使用料未収金（上水併用）","下水道事業収益","営業収益","下水道使用料","下水道使用料","営業収益",7784862000,"下水道使用料",7762551000,"下水道使用料",7609711000,"経営企画課"]
["簿記",3,70737,209,1,11,209,"過誤納：水道料金過誤納(月ヶ瀬)",2020,"110503-0100","152010-1000","336010-1000",0,0,999,999,10110000,"2020-11-18",null,0,1,10,null,null,null,0,"調定","下水道料金収入","流動資産","未収金","営業未収金","下水道使用料未収金（上水併用）","流動負債","その他流動負債","仮受消費税","仮受消費税","営業収益",7784862000,"下水道使用料",7762551000,"下水道使用料",7609711000,"経営企画課"]
["簿記",3,70734,209,1,11,209,"過誤納：下水料金過誤納都市部（下水のみ）",2020,"110101-0100","611010-1000","152010-1000",0,0,41321,41321,10110000,"2020-11-18",null,0,1,10,null,null,null,0,"調定","下水道料金収入","流動資産","未収金","営業未収金","下水道使用料未収金（上水併用）","下水道事業収益","営業収益","下水道使用料","下水道使用料","営業収益",7784862000,"下水道使用料",7762551000,"下水道使用料",7609711000,"経営企画課"]
["簿記",3,70734,209,1,11,209,"過誤納：下水料金過誤納月ヶ瀬（下水のみ）",2020,"110101-0100","336010-1000","152010-1000",0,0,77252,77252,10110000,"2020-11-18",null,0,1,10,null,null,null,0,"調定","下水道料金収入","流動資産","未収金","営業未収金","下水道使用料未収金（上水併用）","流動負債","その他流動負債","仮受消費税","仮受消費税","営業収益",7784862000,"下水道使用料",7762551000,"下水道使用料",7609711000,"経営企画課"]
[]
["伝票種類","伝票種類CD","支払情報ID","伺ID","一件処理番号","相手方CD","相手方登録CD","支払方法CD","支払日","控除額","請求日","請求番号","相手方登録CD","相手方名称１","相手方名称２","相手方郵便番号","相手方住所","相手方かな","相手方種別","電話番号","FAX番号","E-Mail","金融機関CD","口座種別","口座番号","口座名義人","口座用途区分"]
[]
["伝票種類","伝票種類CD","ユーザー名","現年度","会計区分"]
["その他情報",5,"池田 修",2020,"奈良市水道事業"]
[]
["伝票種類","伝票種類CD","予算額ID","伺ID","予算種類CD","年度","予算CD","予算額増","予算額減","日付","承認ステータス","予算款","予算項","予算目","予算節","流用前予算現額"]