{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["読込長前","印刷長前","元データ長前","ukagai_output"],"not_rendered":{"charts":0,"images":0,"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":130,"n_cols":17,"rows_kept":130,"cut":false,"hidden":false,"merged":[]}
["ID","読込FLG","予算科目CD","借方科目CD","貸方科目CD","金額増","金額減","摘要","発行日","財源の種別","当月分","毎月分","７月（4月～7月分）","執 行 予 定 額","簿記項","簿記目","簿記節"]
[1,10,"予算伝票始まり"]
[2,11,"予算科目CD","借方科目CD","貸方科目CD","金額増","金額減","摘要","発行日"]
[3,0,"都市部"]
[4,0,"有形固定資産"]
[5,1,"110309-0100","361065-1000","612050-1000",20609485,null,"分担金","2020-12-19","分担金",null,{"$f":"ROUNDDOWN($N6/12,0)","v":20609485},{"$f":"$N6-$L6*8","v":82437945},247313825]
[6,1,"110309-0100","361055-1000","612050-1000",5871021,null,"開発負担金","2020-12-19","開発負担金",null,5871021,23484092,70452260]
[7,1,"110309-0100","361075-1000","612050-1000",11221023,null,"受託負担金","2020-12-19","受託負担金",null,11221023,44884094,134652278]
[8,1,"110309-0100","361035-1000","612050-1000",1854069,null,"補助金","2020-12-19","補助金",null,1854069,7416278,22248830]
[9,1,"110309-0100","361025-1000","612050-1000",10410952,null,"負担金","2020-12-19","負担金",null,10410952,41643816,124931432]
[10,1,"110309-0100","361015-1000","612050-1000",16478387,null,"受贈財産","2020-12-19","受贈財産",null,16478387,65913548,197740644]
[11,1,"110309-0100","361045-1000","612050-1000",5674403,null,"一般会計補助金","2020-12-19","一般会計補助金",null,5674403,22697619,68092843]
[12,0,"合計額",null,null,{"$f":"SUM(F6:F12)","v":72119340},null,null,null,"合計額",null,{"$f":"SUM(L6:L12)","v":72119340},{"$f":"SUM(M6:M12)","v":288477392},{"$f":"SUM(N6:N12)","v":865432112}]
[13,0,"都市部"]
[14,0,"無形固定資産",null,null,null,null,null,null,null,null,{"$f":"ROUNDDOWN($N15/12,0)","v":0},{"$f":"$N15-$L15*8","v":0}]
[15,1,"110309-0300","361065-1000","612050-2000",0,null,"分担金","2020-12-19","分担金",null,0,0,0]
[16,1,"110309-0300","361055-1000","612050-2000",0,null,"開発負担金","2020-12-19","開発負担金",null,0,0,0]
[17,1,"110309-0300","361075-1000","612050-2000",0,null,"受託負担金","2020-12-19","受託負担金",null,0,0,0]
[18,1,"110309-0300","361035-1000","612050-2000",0,null,"補助金","2020-12-19","補助金",null,0,0,0]
[19,1,"110309-0300","361025-1000","612050-2000",19016430,null,"負担金","2020-12-19","負担金",null,19016430,76065724,228197164]
[20,1,"110309-0300","361015-1000","612050-2000",0,null,"受贈財産","2020-12-19","受贈財産",null,0,0,0]
[21,1,"110309-0300","361045-1000","612050-2000",0,null,"一般会計補助金","2020-12-19","一般会計補助金",null,0,0,0]
[22,0,"合計額",null,null,{"$f":"SUM(F16:F22)","v":19016430},null,null,null,"合計額",null,{"$f":"SUM(L16:L22)","v":19016430},{"$f":"SUM(M16:M22)","v":76065724},{"$f":"SUM(N16:N22)","v":228197164}]
[23,0,"都祁"]
[24,0,"有形固定資産"]
[25,1,"110309-0500","361065-1000","612050-3000",181821,null,"分担金","2020-12-19","分担金",null,{"$f":"ROUNDDOWN($N26/12,0)","v":181821},{"$f":"$N26-$L26*8","v":727293},2181861]
[26,1,"110309-0500","361055-1000","612050-3000",0,null,"開発負担金","2020-12-19","開発負担金",null,0,0,0]
[27,1,"110309-0500","361075-1000","612050-3000",9948,null,"受託負担金","2020-12-19","受託負担金",null,9948,39796,119380]
[28,1,"110309-0500","361035-1000","612050-3000",6148461,null,"補助金","2020-12-19","補助金",null,6148461,24593855,73781543]
[29,1,"110309-0500","361025-1000","612050-3000",2349422,null,"負担金","2020-12-19","負担金",null,2349422,9397696,28193072]
[30,1,"110309-0500","361015-1000","612050-3000",18791,null,"受贈財産","2020-12-19","受贈財産",null,18791,75166,225494]
[31,1,"110309-0500","361045-1000","612050-3000",4191901,null,"一般会計補助金","2020-12-19","一般会計補助金",null,4191901,16767604,50302812]
[32,0,"合計額",null,null,{"$f":"SUM(F26:F32)","v":12900344},null,null,null,"合計額",null,{"$f":"SUM(L26:L32)","v":12900344},{"$f":"SUM(M26:M32)","v":51601410},{"$f":"SUM(N26:N32)","v":154804162}]
[33,0,"都祁"]
[34,0,"無形固定資産"]
[35,1,"110309-0700","361065-1000","612050-4000",0,null,"分担金","2020-12-19","分担金",null,{"$f":"ROUNDDOWN($N36/12,0)","v":0},{"$f":"$N36-$L36*8","v":0},0]
[36,1,"110309-0700","361055-1000","612050-4000",0,null,"開発負担金","2020-12-19","開発負担金",null,0,0,0]
[37,1,"110309-0700","361075-1000","612050-4000",0,null,"受託負担金","2020-12-19","受託負担金",null,0,0,0]
[38,1,"110309-0700","361035-1000","612050-4000",0,null,"補助金","2020-12-19","補助金",null,0,0,0]
[39,1,"110309-0700","361025-1000","612050-4000",0,null,"負担金","2020-12-19","負担金",null,0,0,0]
[40,1,"110309-0700","361015-1000","612050-4000",0,null,"受贈財産","2020-12-19","受贈財産",null,0,0,0]
[41,1,"110309-0700","361045-1000","612050-4000",0,null,"一般会計補助金","2020-12-19","一般会計補助金",null,0,0,0]
[42,0,"合計額",null,null,{"$f":"SUM(F36:F42)","v":0},null,null,null,"合計額",null,{"$f":"SUM(L36:L42)","v":0},{"$f":"SUM(M36:M42)","v":0},{"$f":"SUM(N36:N42)","v":0}]
[43,0,"月ヶ瀬"]
[44,0,"有形固定資産"]
[45,1,"110309-0900","361065-1000","612050-5000",26490,null,"分担金","2020-12-19","分担金",null,{"$f":"ROUNDDOWN($N46/12,0)","v":26490},{"$f":"$N46-$L46*8","v":105961},317881]
[46,1,"110309-0900","361055-1000","612050-5000",0,null,"開発負担金","2020-12-19","開発負担金",null,0,0,0]
[47,1,"110309-0900","361075-1000","612050-5000",3466,null,"受託負担金","2020-12-19","受託負担金",null,3466,13875,41603]
[48,1,"110309-0900","361035-1000","612050-5000",1827030,null,"補助金","2020-12-19","補助金",null,1827030,7308128,21924368]
[49,1,"110309-0900","361025-1000","612050-5000",1226694,null,"負担金","2020-12-19","負担金",null,1226694,4906776,14720328]
[50,1,"110309-0900","361015-1000","612050-5000",0,null,"受贈財産","2020-12-19","受贈財産",null,0,0,0]
[51,1,"110309-0900","361045-1000","612050-5000",256698,null,"一般会計補助金","2020-12-19","一般会計補助金",null,256698,1026796,3080380]
[52,0,"合計額",null,null,{"$f":"SUM(F46:F52)","v":3340378},null,null,null,"合計額",null,{"$f":"SUM(L46:L52)","v":3340378},{"$f":"SUM(M46:M52)","v":13361536},{"$f":"SUM(N46:N52)","v":40084560}]
[53,0,"月ヶ瀬"]
[54,0,"無形固定資産"]
[55,1,"110309-1100","361065-1000","612050-6000",0,null,"分担金","2020-12-19","分担金",null,{"$f":"ROUNDDOWN($N56/12,0)","v":0},{"$f":"$N56-$L56*8","v":0},0]
[56,1,"110309-1100","361055-1000","612050-6000",0,null,"開発負担金","2020-12-19","開発負担金",null,0,0,0]
[57,1,"110309-1100","361075-1000","612050-6000",0,null,"受託負担金","2020-12-19","受託負担金",null,0,0,0]
[58,1,"110309-1100","361035-1000","612050-6000",805441,null,"補助金","2020-12-19","補助金",null,805441,3221768,9665296]
[59,1,"110309-1100","361025-1000","612050-6000",297082,null,"負担金","2020-12-19","負担金",null,297082,1188338,3564994]
[60,1,"110309-1100","361015-1000","612050-6000",0,null,"受贈財産","2020-12-19","受贈財産",null,0,0,0]
[61,1,"110309-1100","361045-1000","612050-6000",0,null,"一般会計補助金","2020-12-19","一般会計補助金",null,0,0,0]
[62,0,"合計額",null,null,{"$f":"SUM(F56:F62)","v":1102523},null,null,null,"合計額",null,{"$f":"SUM(L56:L62)","v":1102523},{"$f":"SUM(M56:M62)","v":4410106},{"$f":"SUM(N56:N62)","v":13230290}]
[81,0,"金額合計"]
[82,19,"予算伝票終わり",null,null,null,null,""]
[83,20,"簿記伝票始まり",null,null,null,null,""]
[84,22,"簿記科目CD","借方科目CD","貸方科目CD","借方金額","貸方金額","摘要","発行日"]
[85,0,"都市部"]
[86,0,"有形固定資産"]
[87,2,"110309-0100","361065-1000","612050-1000",20609485,20609485,"分担金"]
[88,2,"110309-0100","361055-1000","612050-1000",5871021,5871021,"開発負担金"]
[89,2,"110309-0100","361075-1000","612050-1000",11221023,11221023,"受託負担金"]
[90,2,"110309-0100","361035-1000","612050-1000",1854069,1854069,"補助金"]
[91,2,"110309-0100","361025-1000","612050-1000",10410952,10410952,"負担金"]
[92,2,"110309-0100","361015-1000","612050-1000",16478387,16478387,"受贈財産"]
[93,2,"110309-0100","361045-1000","612050-1000",5674403,5674403,"一般会計補助金"]
[94,2,"合計額",null,null,72119340,72119340]
[95,2,"都市部"]
[96,2,"無形固定資産"]
[97,2,"110309-0300","361065-1000","612050-2000",0,0,"分担金"]
[98,2,"110309-0300","361055-1000","612050-2000",0,0,"開発負担金"]
[99,2,"110309-0300","361075-1000","612050-2000",0,0,"受託負担金"]
[100,2,"110309-0300","361035-1000","612050-2000",0,0,"補助金"]
[101,2,"110309-0300","361025-1000","612050-2000",19016430,19016430,"負担金"]
[102,2,"110309-0300","361015-1000","612050-2000",0,0,"受贈財産"]
[103,2,"110309-0300","361045-1000","612050-2000",0,0,"一般会計補助金"]
[104,0,"合計額",null,null,19016430,19016430]
[105,0,"都祁"]
[106,0,"有形固定資産"]
[107,2,"110309-0500","361065-1000","612050-3000",181821,181821,"分担金"]
[108,2,"110309-0500","361055-1000","612050-3000",0,0,"開発負担金"]
[109,2,"110309-0500","361075-1000","612050-3000",9948,9948,"受託負担金"]
[110,2,"110309-0500","361035-1000","612050-3000",6148461,6148461,"補助金"]
[111,0,"110309-0500","361025-1000","612050-3000",2349422,2349422,"負担金"]
[112,2,"110309-0500","361015-1000","612050-3000",18791,18791,"受贈財産"]
[113,2,"110309-0500","361045-1000","612050-3000",4191901,4191901,"一般会計補助金"]
[114,0,"合計額",null,null,12900344,12900344]
[115,0,"都祁"]
[116,0,"無形固定資産"]
[117,2,"110309-0700","361065-1000","612050-4000",0,0,"分担金"]
[118,2,"110309-0700","361055-1000","612050-4000",0,0,"開発負担金"]
[119,2,"110309-0700","361075-1000","612050-4000",0,0,"受託負担金"]
[120,2,"110309-0700","361035-1000","612050-4000",0,0,"補助金"]
[121,2,"110309-0700","361025-1000","612050-4000",0,0,"負担金"]
[122,2,"110309-0700","361015-1000","612050-4000",0,0,"受贈財産"]
[123,2,"110309-0700","361045-1000","612050-4000",0,0,"一般会計補助金"]
[124,0,"合計額",null,null,0,0]
[125,0,"月ヶ瀬"]
[126,0,"有形固定資産"]
[127,2,"110309-0900","361065-1000","612050-5000",26490,26490,"分担金"]
[128,2,"110309-0900","361055-1000","612050-5000",0,0,"開発負担金"]
[129,2,"110309-0900","361075-1000","612050-5000",3466,3466,"受託負担金"]
[130,2,"110309-0900","361035-1000","612050-5000",1827030,1827030,"補助金"]
[131,2,"110309-0900","361025-1000","612050-5000",1226694,1226694,"負担金"]
[132,2,"110309-0900","361015-1000","612050-5000",0,0,"受贈財産"]
[133,2,"110309-0900","361045-1000","612050-5000",256698,256698,"一般会計補助金"]
[134,0,"合計額",null,null,3340378,3340378]
[135,0,"月ヶ瀬"]
[136,0,"無形固定資産"]
[137,0,"110309-1100","361065-1000","612050-6000",0,0,"分担金"]
[138,2,"110309-1100","361055-1000","612050-6000",0,0,"開発負担金"]
[139,2,"110309-1100","361075-1000","612050-6000",0,0,"受託負担金"]
[140,2,"110309-1100","361035-1000","612050-6000",805441,805441,"補助金"]
[141,2,"110309-1100","361025-1000","612050-6000",297082,297082,"負担金"]
[142,2,"110309-1100","361015-1000","612050-6000",0,0,"受贈財産"]
[143,2,"110309-1100","361045-1000","612050-6000",0,0,"一般会計補助金"]
[162,0,"合計額",null,null,1102523,1102523]
[163,0,"金額合計"]
[164,29,"簿記伝票終わり"]
[999,999,"全伝票終わり"]

{"sheet":"印刷長前","index":1,"n_rows":79,"n_cols":103,"rows_kept":79,"cut":false,"hidden":false,"merged":[[51,9,51,28],[80,1,80,30],[80,31,80,55],[81,31,81,55],[80,56,80,72],[80,73,80,109],[84,56,84,72],[84,73,84,109],[83,56,83,72],[83,73,83,109],[81,56,81,72],[81,73,81,109],[82,1,82,30],[82,31,82,55],[82,56,82,72],[82,73,82,109],[85,1,85,30],[85,31,85,55],[85,56,85,72],[85,73,85,109],[86,1,86,30],[86,31,86,55],[86,56,86,72],[86,73,86,109],[81,1,81,30],[84,1,84,30],[84,31,84,55],[83,1,83,30],[83,31,83,55],[65,1,65,48],[65,49,65,63],[79,1,79,30],[79,31,79,55],[79,56,79,72],[73,49,73,94],[74,49,74,94],[75,49,75,94],[76,49,76,94],[78,56,78,72],[79,73,79,109],[78,1,78,30],[78,31,78,55],[66,1,66,48],[66,49,66,63],[66,64,66,108],[78,73,78,109],[57,1,57,48],[58,1,58,48],[59,1,59,48],[73,1,73,48],[74,1,74,48],[75,1,75,48],[76,1,76,48],[70,49,70,63],[70,64,70,108],[67,1,67,48],[67,49,67,63],[67,64,67,108],[68,1,68,48],[68,49,68,63],[68,64,68,108],[63,64,63,108],[64,1,64,48],[64,49,64,63],[64,64,64,108],[69,1,69,48],[69,49,69,63],[69,64,69,108],[70,1,70,48],[65,64,65,108],[62,1,62,48],[60,1,60,48],[62,49,62,63],[62,64,62,108],[63,1,63,48],[63,49,63,63],[47,16,47,55],[47,56,47,66],[47,67,47,70],[47,71,47,110],[48,71,48,110],[49,1,49,11],[49,12,49,55],[49,56,49,66],[49,67,49,110],[52,0,52,108],[54,89,54,101],[54,102,54,108],[44,0,49,0],[46,71,46,110],[44,71,44,110],[45,1,45,11],[45,12,45,15],[45,16,45,55],[46,1,46,11],[46,12,46,15],[46,16,46,55],[46,56,46,66],[48,1,48,11],[48,12,48,15],[48,16,48,55],[48,56,48,66],[48,67,48,70],[47,1,47,11],[47,12,47,15],[46,67,46,70],[45,56,45,66],[45,67,45,70],[45,71,45,110],[43,1,43,11],[43,12,43,55],[43,56,43,66],[43,67,43,110],[44,1,44,11],[44,12,44,15],[44,16,44,55],[44,56,44,66],[44,67,44,70],[41,12,41,15],[41,16,41,55],[41,56,41,66],[41,67,41,70],[41,71,41,110],[42,1,42,11],[42,12,42,15],[42,16,42,55],[42,56,42,66],[42,67,42,70],[42,71,42,110],[38,67,38,70],[38,71,38,110],[34,56,34,110],[36,0,36,31],[37,1,37,55],[37,56,37,110],[38,0,43,0],[38,1,38,11],[38,12,38,15],[38,16,38,55],[38,56,38,66],[40,1,40,11],[39,1,39,11],[39,12,39,15],[39,16,39,55],[39,56,39,66],[39,67,39,70],[39,71,39,110],[40,12,40,15],[40,16,40,55],[40,56,40,66],[40,67,40,70],[40,71,40,110],[41,1,41,11],[32,81,32,95],[32,96,32,110],[33,0,34,11],[33,12,33,22],[33,23,33,55],[33,56,33,66],[33,67,33,80],[28,0,28,110],[29,0,29,30],[30,0,30,11],[30,12,30,110],[33,81,33,95],[33,96,33,110],[34,12,34,22],[32,0,32,11],[32,12,32,31],[32,32,32,42],[32,43,32,55],[32,56,32,66],[32,67,32,80],[34,23,34,55],[24,75,24,92],[24,93,24,110],[25,1,25,11],[25,12,25,15],[25,16,25,55],[25,56,25,74],[25,75,25,92],[25,93,25,110],[31,0,31,5],[31,6,31,11],[31,12,31,21],[31,22,31,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],[21,0,21,110],[22,0,22,11],[22,12,22,24],[22,25,22,55],[22,56,22,74],[22,75,22,92],[26,1,26,11],[26,12,26,15],[26,16,26,55],[26,56,26,74],[26,75,26,92],[26,93,26,110],[22,93,22,110],[23,0,27,0],[23,1,23,11],[23,12,23,15],[23,16,23,55],[23,56,23,74],[23,75,23,92],[23,93,23,110],[24,1,24,11],[24,12,24,15],[24,16,24,55],[24,56,24,74],[8,100,9,110],[12,0,12,110],[14,0,14,11],[14,12,14,30],[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],[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],[14,31,14,40],[14,41,14,46],[14,47,14,56],[14,63,14,76],[14,77,14,88],[14,89,14,98],[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],[14,99,14,110],[18,0,19,11],[18,12,18,110],[19,12,19,110],[15,0,16,11],[15,12,15,29],[15,30,15,48],[15,49,15,65],[15,66,15,84],[15,85,15,96],[15,97,15,110],[16,12,16,29],[16,30,16,48],[16,49,16,65],[16,66,16,84],[16,85,16,96],[16,97,16,110],[20,93,20,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]]}
["予算執行伺",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"簿記伝票種類"]
["長期前受金戻入執行伺",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"振替伝票"]
["決　裁","経営企画課"]
[null,"係　員",null,null,null,null,null,null,null,null,null,null,"係　長",null,null,null,null,null,null,null,null,null,null,"補　佐",null,null,null,null,null,null,null,null,null,null,"課　長"]
[]
[]
[]
["審　査","経理審査"]
[null,"係　員",null,null,null,null,null,null,null,null,null,null,"係　長",null,null,null,null,null,null,null,null,null,null,"補　佐",null,null,null,null,null,null,null,null,null,null,"主　幹",null,null,null,null,null,null,null,null,null,null,"課　長",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"2021-02-02",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"予算伝票",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"簿記伝票",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"一件処理番号",null,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-02",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-02-02"]
[]
["摘　要",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"現計予算額",null,null,null,null,null,null,null,null,null,null,null,null,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算\n科\n目","款",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"BE24-(BE28+BX28-CP28)","v":-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,"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,9904000,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,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,"貸　　　　　方"]
["伝\n票\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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"項"]
[null,"目",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"目"]
[null,"節",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"備消品費",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"節",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"未払金"]
[null,"細節",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"細節"]
[null,"借方金額",null,null,null,null,null,null,null,null,null,null,100,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"貸方金額",null,null,null,null,null,null,null,null,null,null,100]
["伝\n票\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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"項"]
[null,"目",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"目"]
[null,"節",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"仮払消費税",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"節",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"未払金"]
[null,"細節",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"発行日",null,null,null,null,null,null,null,null,null,null,null,null,"page"]
[]
["予算伝票"]
[null,"予算科目"]
["款"]
["項"]
["目"]
[]
["明細","予算科目節",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"金額",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"摘要"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["簿記伝票"]
[null,"借方科目",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"貸方科目"]
["款"]
["項"]
["目"]
[]
["明細","借方科目節",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"貸方科目節",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"金額",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"摘要"]

{"sheet":"元データ長前","index":2,"n_rows":70,"n_cols":6,"rows_kept":70,"cut":false,"hidden":false,"merged":[]}
["都市部"]
[null,"有形固定資産前受金戻入",null,"612050-1000"]
[null,"財源の種別","当月分","毎月分","７月（4月～7月分）","執 行 予 定 額"]
[null,"分担金",null,{"$f":"ROUNDDOWN($F4/12,0)","v":20609485},{"$f":"$F4-$D4*8","v":82437945},247313825]
[null,"開発負担金",null,5871021,23484092,70452260]
[null,"受託負担金",null,11221023,44884094,134652278]
[null,"補助金",null,1854069,7416278,22248830]
[null,"負担金",null,10410952,41643816,124931432]
[null,"受贈財産",null,16478387,65913548,197740644]
[null,"一般会計補助金",null,5674403,22697619,68092843]
[null,"合計額",null,{"$f":"SUM(D4:D10)","v":72119340},{"$f":"SUM(E4:E10)","v":288477392},{"$f":"SUM(F4:F10)","v":865432112}]
[]
[null,"無形固定資産前受金戻入",null,"612050-2000"]
[null,"財源の種別","当月分","毎月分","７月（4月～7月分）","執 行 予 定 額"]
[null,"分担金",null,{"$f":"ROUNDDOWN($F15/12,0)","v":0},{"$f":"$F15-$D15*8","v":0},0]
[null,"開発負担金",null,0,0,0]
[null,"受託負担金",null,0,0,0]
[null,"補助金",null,0,0,0]
[null,"負担金",null,{"$f":"ROUNDDOWN($F19/12,0)","v":19016430},76065724,228197164]
[null,"受贈財産",null,{"$f":"ROUNDDOWN($F20/12,0)","v":0},0,0]
[null,"一般会計補助金",null,0,0,0]
[null,"合計額",null,{"$f":"SUM(D15:D21)","v":19016430},{"$f":"SUM(E15:E21)","v":76065724},{"$f":"SUM(F15:F21)","v":228197164}]
[]
[]
["都祁"]
[null,"有形固定資産前受金戻入",null,"612050-3000"]
[null,"財源の種別",null,"８月","７月（4月～7月分）","合     計"]
[null,"分担金",null,{"$f":"ROUNDDOWN($F28/12,0)","v":181821},{"$f":"$F28-$D28*8","v":727293},2181861]
[null,"開発負担金",null,0,0,0]
[null,"受託負担金",null,9948,39796,119380]
[null,"補助金",null,6148461,24593855,73781543]
[null,"負担金",null,2349422,9397696,28193072]
[null,"受贈財産",null,18791,75166,225494]
[null,"一般会計補助金",null,4191901,16767604,50302812]
[null,"合計額",null,{"$f":"SUM(D28:D34)","v":12900344},{"$f":"SUM(E28:E34)","v":51601410},154804162]
[]
[]
[null,"無形固定資産前受金戻入",null,"612050-4000"]
[null,"財源の種別",null,"８月","７月（4月～7月分）","合     計"]
[null,"分担金",null,{"$f":"ROUNDDOWN($F40/12,0)","v":0},{"$f":"$F40-$D40*8","v":0},0]
[null,"開発負担金",null,0,0,0]
[null,"受託負担金",null,0,0,0]
[null,"補助金",null,0,0,0]
[null,"負担金",null,0,0,0]
[null,"受贈財産",null,0,0,0]
[null,"一般会計補助金",null,0,0,0]
[null,"合計額",null,{"$f":"SUM(D40:D46)","v":0},{"$f":"SUM(E40:E46)","v":0},{"$f":"SUM(F40:F46)","v":0}]
[]
["月ヶ瀬"]
[null,"有形固定資産前受金戻入",null,"612050-5000"]
[null,"財源の種別",null,"８月","７月（4月～7月分）","合     計"]
[null,"分担金",null,{"$f":"ROUNDDOWN($F52/12,0)","v":26490},{"$f":"$F52-$D52*8","v":105961},317881]
[null,"開発負担金",null,0,0,0]
[null,"受託負担金",null,3466,13875,41603]
[null,"補助金",null,1827030,7308128,21924368]
[null,"負担金",null,1226694,4906776,14720328]
[null,"受贈財産",null,0,0,0]
[null,"一般会計補助金",null,256698,1026796,3080380]
[null,"合計額",null,{"$f":"SUM(D52:D58)","v":3340378},{"$f":"SUM(E52:E58)","v":13361536},{"$f":"SUM(F52:F58)","v":40084560}]
[]
[null,"無形固定資産前受金戻入",null,"612050-6000"]
[null,"財源の種別",null,"８月","７月（4月～7月分）","合     計"]
[null,"分担金",null,{"$f":"ROUNDDOWN($F63/12,0)","v":0},{"$f":"$F63-$D63*8","v":0},0]
[null,"開発負担金",null,0,0,0]
[null,"受託負担金",null,0,0,0]
[null,"補助金",null,805441,3221768,9665296]
[null,"負担金",null,297082,1188338,3564994]
[null,"受贈財産",null,0,0,0]
[null,"一般会計補助金",null,0,0,0]
[null,"合計額",null,{"$f":"SUM(D63:D69)","v":1102523},{"$f":"SUM(E63:E69)","v":4410106},{"$f":"SUM(F63:F69)","v":13230290}]

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