{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["印刷調定","ukagai_output"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":53,"n_cols":101,"rows_kept":53,"cut":false,"hidden":false,"merged":[[52,9,52,29],[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],[13,12,13,31],[13,32,13,51],[13,52,13,71],[13,72,13,81],[13,82,13,91],[13,92,13,110],[3,12,3,22],[3,23,3,33],[3,34,3,44],[14,99,14,110],[13,0,13,11],[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],[8,100,9,110],[12,0,12,110],[14,0,14,11],[14,12,14,30],[14,31,14,40],[14,41,14,46],[14,47,14,56],[14,63,14,76],[14,77,14,88],[14,89,14,98],[38,56,38,110],[39,67,39,70],[22,0,22,11],[30,0,30,11],[26,56,26,74],[23,0,23,11],[23,12,23,24],[23,25,23,55],[23,56,23,74],[23,75,23,92],[23,93,23,110],[24,0,28,0],[24,1,24,11],[28,1,28,11],[26,1,26,11],[26,75,26,92],[26,93,26,110],[27,1,27,11],[27,12,27,15],[27,16,27,55],[27,56,27,74],[27,75,27,92],[27,93,27,110],[24,12,24,15],[15,0,16,11],[15,12,15,29],[15,30,15,48],[15,49,15,65],[15,66,15,84],[16,12,16,29],[28,93,28,110],[26,12,26,15],[26,16,26,55],[16,30,16,48],[16,49,16,65],[16,66,16,84],[25,75,25,92],[25,93,25,110],[24,16,24,55],[24,56,24,74],[24,75,24,92],[24,93,24,110],[45,71,45,110],[45,56,45,66],[43,71,43,110],[40,67,40,70],[39,71,39,110],[40,71,40,110],[43,56,43,66],[44,1,44,11],[44,56,44,66],[43,67,43,70],[43,16,43,55],[43,12,43,15],[44,12,44,55],[44,67,44,110],[42,71,42,110],[42,12,42,15],[42,16,42,55],[42,67,42,70],[50,12,50,55],[45,0,50,0],[45,1,45,11],[47,67,47,70],[48,67,48,70],[49,67,49,70],[45,67,45,70],[45,12,45,15],[45,16,45,55],[48,12,48,15],[51,0,51,110],[47,56,47,66],[48,1,48,11],[48,56,48,66],[49,1,49,11],[49,56,49,66],[46,1,46,11],[46,56,46,66],[47,1,47,11],[46,12,46,15],[47,12,47,15],[50,67,50,110],[49,16,49,55],[46,71,46,110],[47,71,47,110],[48,71,48,110],[50,1,50,11],[50,56,50,66],[49,71,49,110],[47,16,47,55],[48,16,48,55],[49,12,49,15],[46,67,46,70],[46,16,46,55],[32,0,32,5],[32,6,32,11],[32,12,32,21],[32,22,32,110],[39,0,44,0],[39,12,39,15],[40,12,40,15],[41,71,41,110],[40,56,40,66],[40,1,40,11],[41,12,41,15],[41,1,41,11],[41,56,41,66],[40,16,40,55],[41,16,41,55],[41,67,41,70],[39,1,39,11],[37,0,37,11],[39,56,39,66],[39,16,39,55],[38,1,38,55],[42,1,42,11],[42,56,42,66],[43,1,43,11],[31,0,31,11],[31,12,31,110],[29,0,29,110],[25,1,25,11],[25,12,25,15],[25,16,25,55],[25,56,25,74],[18,0,19,11],[18,12,18,110],[19,12,19,110],[20,0,20,11],[20,12,20,24],[20,25,20,35],[20,36,20,47],[20,48,20,57],[20,58,20,61],[20,62,20,70],[20,71,20,84],[20,85,20,92],[20,93,20,110],[28,12,28,15],[28,16,28,55],[28,56,28,74],[28,75,28,92]]}
["予算執行伺",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"簿記伝票種類"]
["調定伺",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,"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,"JTX 付箋 １セット×１２０９円 ほか６種類"]
[]
["セグメント",null,null,null,null,null,null,null,null,null,null,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,"10",null,null,null,"消費税額",null,null,null,null,null,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,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,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,"21",null,null,null,"水道事業費用",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9904000]
[null,"項",null,null,null,null,null,null,null,null,null,null,"01",null,null,null,"営業費用"]
[null,"目",null,null,null,null,null,null,null,null,null,null,"13",null,null,null,"総係費",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,0]
[null,"節",null,null,null,null,null,null,null,null,null,null,"25",null,null,null,"備消品費",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"執行前調定済額",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"調定額増",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"調定額減"]
[null,"細節",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,0]
[]
["納付者"]
["納付者名称"]
["郵便番号",null,null,null,null,null,"住所"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,9904000]
["簿記伝票"]
[null,"借　　　　　方",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"貸　　　　　方"]
["伝票１","款",null,null,null,null,null,null,null,null,null,null,"71",null,null,null,"水道事業費用",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"款",null,null,null,null,null,null,null,null,null,null,"33",null,null,null,"流動負債"]
[null,"項",null,null,null,null,null,null,null,null,null,null,"10",null,null,null,"営業費用",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"項",null,null,null,null,null,null,null,null,null,null,"35",null,null,null,"未払金"]
[null,"目",null,null,null,null,null,null,null,null,null,null,"70",null,null,null,"総係費",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"目",null,null,null,null,null,null,null,null,null,null,"10",null,null,null,"未払金"]
[null,"節",null,null,null,null,null,null,null,null,null,null,"25",null,null,null,"備消品費",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"節",null,null,null,null,null,null,null,null,null,null,"10",null,null,null,"未払金"]
[null,"細節",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"15",null,null,null,"流動資産",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"款",null,null,null,null,null,null,null,null,null,null,"33",null,null,null,"流動負債"]
[null,"項",null,null,null,null,null,null,null,null,null,null,"80",null,null,null,"その他流動資産",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"項",null,null,null,null,null,null,null,null,null,null,"35",null,null,null,"未払金"]
[null,"目",null,null,null,null,null,null,null,null,null,null,"30",null,null,null,"仮払消費税",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"目",null,null,null,null,null,null,null,null,null,null,"10",null,null,null,"未払金"]
[null,"節",null,null,null,null,null,null,null,null,null,null,"10",null,null,null,"仮払消費税",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"節",null,null,null,null,null,null,null,null,null,null,"10",null,null,null,"未払金"]
[null,"細節",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"（発行課保存）"]

{"sheet":"ukagai_output","index":1,"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","予算額増","予算額減","日付","承認ステータス","予算款","予算項","予算目","予算節","流用前予算現額"]