{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["読込前受金入金","印刷前受金入金","ukagai_output"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["読込FLG","証明・給水再開手数料"]
[20,"簿記伝票終わり"]
[20,"予算科目CD","借方科目CD","貸方科目CD","借方金額","貸方金額","摘要","発行日","消費税CD","消費税率","消費税額"]
[0,"口座"]
[21,null,"334010-1000","152010-1000",123456,123456,"臨時メータ精算","2020-11-18",99]
[21,null,"334010-2000","152010-1000",123456,123456,"仮設メータ精算","2020-11-18",99]
[0,"合計",null,null,null,null,null,null,99]
[0,"郵政納付",null,null,null,null,null,null,99]
[21,null,"334010-1000","152010-1000",123456,123456,"臨時メータ精算","2020-11-18",99]
[21,null,"334010-2000","152010-1000",123456,123456,"仮設メータ精算","2020-11-18",99]
[0,"合計",null,null,null,null,null,null,99]
[0,"銀行納付",null,null,null,null,null,null,99]
[21,null,"334010-1000","152010-1000",123456,123456,"臨時メータ精算","2020-11-18",99]
[21,null,"334010-2000","152010-1000",123456,123456,"仮設メータ精算","2020-11-18",99]
[0,"合計",null,null,null,null,null,null,99]
[21,"コンビニ",null,null,null,null,null,null,99]
[21,null,"334010-1000","152010-1000",123456,123456,"臨時メータ精算","2020-11-18",99]
[21,null,"334010-2000","152010-1000",123456,123456,"仮設メータ精算","2020-11-18",99]
[0,"合計",null,null,null,null,null,null,99]
[21,"窓口",null,null,null,null,null,null,99]
[21,null,"334010-1000","152010-1000",123456,123456,"臨時メータ精算","2020-11-18",99]
[21,null,"334010-2000","152010-1000",123456,123456,"仮設メータ精算","2020-11-18",99]
[0,"合計"]
[29,"簿記伝票終わり"]
[999,"全伝票終わり"]

{"sheet":"印刷前受金入金","index":1,"n_rows":43,"n_cols":90,"rows_kept":43,"cut":false,"hidden":false,"merged":[[40,9,40,29],[35,78,35,108],[36,78,36,108],[37,78,37,108],[12,0,12,109],[13,92,13,109],[2,0,6,0],[2,1,2,109],[3,1,3,11],[3,12,3,22],[3,23,3,33],[3,34,3,44],[7,0,11,0],[7,1,7,109],[8,1,8,11],[13,0,13,11],[13,12,13,31],[13,32,13,51],[13,52,13,71],[13,72,13,81],[13,82,13,91],[14,12,14,30],[14,31,14,40],[14,41,14,46],[8,12,8,22],[8,23,8,33],[8,34,8,44],[8,45,8,55],[34,1,34,10],[34,11,34,20],[34,21,34,35],[34,36,34,59],[34,60,34,77],[21,54,21,108],[22,0,22,15],[22,16,22,31],[22,32,22,53],[22,54,22,108],[24,0,24,5],[26,36,26,59],[26,60,26,77],[21,0,21,15],[21,16,21,31],[21,32,21,53],[33,78,33,108],[34,78,34,108],[14,47,14,56],[14,63,14,76],[33,1,33,10],[33,11,33,20],[33,21,33,35],[33,36,33,59],[33,60,33,77],[25,1,25,10],[25,11,25,20],[25,21,25,35],[0,0,0,55],[1,0,1,55],[0,56,0,109],[1,56,1,109],[31,1,31,10],[31,11,31,20],[31,21,31,35],[31,36,31,59],[31,60,31,77],[25,78,25,108],[16,49,16,65],[16,66,16,84],[16,85,16,96],[16,97,16,109],[17,0,17,109],[15,0,16,11],[15,12,15,29],[15,30,15,48],[15,49,15,65],[15,66,15,84],[15,85,15,96],[16,30,16,48],[14,0,14,11],[15,97,15,109],[16,12,16,29],[14,77,14,88],[14,89,14,98],[14,99,14,109],[26,1,26,10],[26,11,26,20],[26,21,26,35],[29,60,29,77],[28,1,28,10],[28,11,28,20],[28,21,28,35],[28,36,28,59],[28,60,28,77],[29,1,29,10],[29,11,29,20],[29,21,29,35],[29,36,29,59],[25,36,25,59],[25,60,25,77],[26,78,26,108],[27,78,27,108],[28,78,28,108],[29,78,29,108],[32,78,32,108],[30,1,30,10],[30,11,30,20],[30,21,30,35],[30,36,30,59],[30,60,30,77],[27,1,27,10],[27,11,27,20],[27,21,27,35],[27,36,27,59],[27,60,27,77],[32,1,32,10],[32,11,32,20],[32,21,32,35],[32,36,32,59],[32,60,32,77],[30,78,30,108],[31,78,31,108],[35,1,35,10],[35,11,35,20],[35,21,35,35],[35,36,35,59],[35,60,35,77],[37,1,37,10],[37,11,37,20],[37,21,37,35],[37,36,37,59],[37,60,37,77],[36,1,36,10],[36,11,36,20],[36,21,36,35],[36,36,36,59],[36,60,36,77]]}
["予算執行伺",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"簿記伝票種類"]
["発行なし",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,"係　長",null,null,null,null,null,null,null,null,null,null,"補　佐",null,null,null,null,null,null,null,null,null,null,"主　幹",null,null,null,null,null,null,null,null,null,null,"企業出納員"]
[]
[]
[]
[]
["起案責任者",null,null,null,null,null,null,null,null,null,null,null,"経営企画課",null,null,null,null,null,null,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-09",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"予算伝票",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"簿記伝票",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"一件処理番号",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"伺伝票ID"]
["関連情報",null,null,null,null,null,null,null,null,null,null,null,"決済日",null,null,null,null,null,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-09",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-02-09",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-02-09",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-02-09"]
[]
["簿記伝票"]
[]
["借方科目"]
["款",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"項",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"目",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"節"]
["流動資産",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"現金預金",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"現金預金",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"現金預金"]
[]
["貸方科目"]
["明細","款",null,null,null,null,null,null,null,null,null,"項",null,null,null,null,null,null,null,null,null,"目",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"節",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[]
[]
[null,null,null,null,null,null,null,null,null,"（発行課保存）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,94380298]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]

{"sheet":"ukagai_output","index":2,"n_rows":28,"n_cols":43,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["伝票種類","伝票種類CD","伺ID","一件処理番号","所属CD","起案日","予算伝票件数","簿記伝票件数","流用伺元件数","流用伺先件数","納付書出力CD","伝票番号","伺CD","所属名称","伺名称"]
["伺",1,211,154,10110000,"2021-02-25",null,null,null,null,null,null,null,"経営企画課"]
[]
["伝票種類","伝票種類CD","予算伝票ID","伺ID","連番","執行CD","一件処理番号","摘要名称","年度","予算CD","借方CD","貸方CD","金額増額","金額減額","借方金額","貸方金額","所属CD","発行日","処理FLG","消費税額","消費税CD","消費税率","伺CD","セグCD","簿記伝票ID","予備1","執行CD名称","予算科目名称","借方科目名称","貸方科目名称","予算款","予算款額","予算項","予算項額","予算目","予算目額","予算節","予算節額","所属名称","支出負担行為済額","支出命令済額","調定済額"]
["予算",2,81335,211,1,null,211,"定例調定：都市部：隔月分",2020,"110101-0100","152010-1000","611010-1000",549393689,null,0,0,10110000,"2020-11-18",null,0,1,10,null,null,null,0,null,"水道料金収入","給水未収金","水道料金収入","水道事業収益",9511000000,"営業収益",7784862000,"給水収益",7762551000,"水道料金収入",7609711000,"経営企画課",0,0,1603341535]
["予算",2,81336,211,1,null,211,"定例調定：都市部：毎月分",2020,"110101-0100","152010-1000","611010-1000",55523150,null,0,0,10110000,"2020-11-18",null,0,1,10,null,null,null,0,null,"水道料金収入","給水未収金","水道料金収入","水道事業収益",9511000000,"営業収益",7784862000,"給水収益",7762551000,"水道料金収入",7609711000,"経営企画課",0,0,1603341535]
["予算",2,81337,211,1,null,211,"調定増：現年度：都市部",2020,"110101-0100","152010-1000","611010-1000",14419,null,0,0,10110000,"2020-11-18",null,0,1,10,null,null,null,0,null,"水道料金収入","給水未収金","水道料金収入","水道事業収益",9511000000,"営業収益",7784862000,"給水収益",7762551000,"水道料金収入",7609711000,"経営企画課",0,0,1603341535]
["予算",2,81338,211,1,null,211,"調定減：現年度：都市部",2020,"110101-0100","611010-1000","152010-1000",null,28509,0,0,10110000,"2020-11-18",null,0,1,10,null,null,null,0,null,"水道料金収入","水道料金収入","給水未収金","水道事業収益",9511000000,"営業収益",7784862000,"給水収益",7762551000,"水道料金収入",7609711000,"経営企画課",0,0,1603341535]
["予算",2,81339,211,1,null,211,"定例調定：都祁：隔月分",2020,"110101-0300","152010-1000","611010-2000",10208052,null,0,0,10110000,"2020-11-18",null,0,1,10,null,null,null,0,null,"都祁水道料金収入","給水未収金","都祁水道料金収入","水道事業収益",9511000000,"営業収益",7784862000,"給水収益",7762551000,"都祁水道料金収入",127333000,"経営企画課",0,0,28581624]
[]
["伝票種類","伝票種類CD","簿記伝票ID","伺ID","連番","執行CD","一件処理番号","摘要名称","年度","予算CD","借方CD","貸方CD","金額増額","金額減額","借方金額","貸方金額","所属CD","発行日","処理FLG","消費税額","消費税CD","消費税率","伺CD","セグCD","簿記伝票ID","予備1","執行CD名称","予算科目名称","借方款","借方項","借方目","借方節","貸方款","貸方項","貸方目","貸方節","予算項","予算項額","予算目","予算目額","予算節","予算節額","所属名称"]
["簿記",3,70738,211,1,11,211,"定例調定：都市部：隔月分",2020,{"$f":"B4","v":"伝票種類CD"},{"$f":"C4","v":"予算伝票ID"},{"$f":"D4","v":"伺ID"},0,0,549393689,549393689,10110000,"2020-11-18",null,0,99,10,null,null,null,0,"調定",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"経営企画課"]
["簿記",3,70739,211,1,11,211,"消費税：定例調定：都市部：隔月分",2020,null,"152010-1000","336010-1000",0,0,54939369,54939369,10110000,"2020-11-18",null,0,99,10,null,null,null,0,"調定",null,"流動資産","未収金","営業未収金","給水未収金","流動負債","その他流動負債","仮受消費税","仮受消費税",null,null,null,null,null,null,"経営企画課"]
["簿記",3,70740,211,1,11,211,"定例調定：都市部：毎月分",2020,{"$f":"B5","v":2},{"$f":"C5","v":81335},{"$f":"D5","v":211},0,0,55523150,55523150,10110000,"2020-11-18",null,0,99,10,null,null,null,0,"調定",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"経営企画課"]
["簿記",3,70741,211,1,11,211,"消費税：",2020,null,"152010-1000","336010-1000",0,0,5552315,5552315,10110000,"2020-11-18",null,0,99,10,null,null,null,0,"調定",null,"流動資産","未収金","営業未収金","給水未収金","流動負債","その他流動負債","仮受消費税","仮受消費税",null,null,null,null,null,null,"経営企画課"]
["簿記",3,70742,211,1,11,211,"調定増：現年度：都市部",2020,{"$f":"B6","v":2},{"$f":"C6","v":81336},{"$f":"D6","v":211},0,0,14419,14419,10110000,"2020-11-18",null,0,99,10,null,null,null,0,"調定",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"経営企画課"]
["簿記",3,70743,211,1,11,211,"消費税：",2020,null,"152010-1000","336010-1000",0,0,1442,1442,10110000,"2020-11-18",null,0,99,10,null,null,null,0,"調定",null,"流動資産","未収金","営業未収金","給水未収金","流動負債","その他流動負債","仮受消費税","仮受消費税",null,null,null,null,null,null,"経営企画課"]
["簿記",3,70744,211,1,11,211,"調定減：現年度：都市部",2020,{"$f":"B8","v":2},{"$f":"C8","v":81338},{"$f":"D8","v":211},0,0,28509,28509,10110000,"2020-11-18",null,0,99,10,null,null,null,0,"調定",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"経営企画課"]
["簿記",3,70745,211,1,11,211,"消費税：",2020,null,"336010-1000","152010-1000",0,0,2851,2851,10110000,"2020-11-18",null,0,99,10,null,null,null,0,"調定",null,"流動負債","その他流動負債","仮受消費税","仮受消費税","流動資産","未収金","営業未収金","給水未収金",null,null,null,null,null,null,"経営企画課"]
["簿記",3,70746,211,1,11,211,"定例調定：都祁：隔月分",2020,{"$f":"B11","v":"伝票種類CD"},{"$f":"C11","v":"簿記伝票ID"},{"$f":"D11","v":"伺ID"},0,0,10208052,10208052,10110000,"2020-11-18",null,0,99,10,null,null,null,0,"調定",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"経営企画課"]
["簿記",3,70747,211,1,11,211,"消費税：",2020,null,"152010-1000","336010-1000",0,0,1020805,1020805,10110000,"2020-11-18",null,0,99,10,null,null,null,0,"調定",null,"流動資産","未収金","営業未収金","給水未収金","流動負債","その他流動負債","仮受消費税","仮受消費税",null,null,null,null,null,null,"経営企画課"]
[]
["伝票種類","伝票種類CD","支払情報ID","伺ID","一件処理番号","相手方CD","相手方登録CD","支払方法CD","支払日","控除額","請求日","請求番号","相手方登録CD","相手方名称１","相手方名称２","相手方郵便番号","相手方住所","相手方かな","相手方種別","電話番号","FAX番号","E-Mail","金融機関CD","口座種別","口座番号","口座名義人","口座用途区分"]
[]
["伝票種類","伝票種類CD","ユーザー名","現年度","会計区分"]
["その他情報",5,"池田 修",2020,"奈良市水道事業"]
[]
["伝票種類","伝票種類CD","予算額ID","伺ID","予算種類CD","年度","予算CD","予算額増","予算額減","日付","承認ステータス","予算款","予算項","予算目","予算節","流用前予算現額"]