{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["共通データ","画面仕様","システム機能","既存DB処理フロー","既存DB変更","既存DBからの移行"],"not_rendered":{"charts":0,"images":1,"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":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["区分","システム保持データ","備考",null,"システムの機能"]
["システム共通","ユーザーID","ユーザーID",null,null,"機能","処理方式"]
[null,"ユーザー所属課","ユーザー所属課",null,1,"伝票入力・修正","単件／複数"]
[null,null,null,null,2,"伝票集計・表示"]
["予算伝票","会計年度","現年度予算の年度（2020）",null,3,"次年度繰越"]
[null,"会計区分","セグメント",null,4,"初期登録"]
[null,"現年度/繰越区分",null,null,5]
[null,"予算種類区分","収益的・資本的・貯蔵品など",null,6]
["伺伝票","伺ID","伺伝票と予算・簿記伝票の関連付け",null,7,"その他"]
["予算伝票","一件処理番号","予算・簿記伝票の1件処理の関連付け",null,8,"システム・メンテ"]
["簿記伝票"]
[]
[]
["各テーブルの連結キー"]
["伝票テーブルU","伺伝票","伺IDでYとBを連結"]
["伝票テーブルY","予算伝票","一件処理番号で一連のYを連結"]
["伝票テーブルB","簿記伝票"]

{"sheet":"画面仕様","index":1,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,null,"修正・登録",null,null,null,"参照表示"]
["伺区分","検索：テーブル","伺伝票","予算伝票","簿記伝票１","消費税伝票","伺伝票","予算伝票","簿記伝票１","消費税伝票","備考"]
["支出負担行為","予算科目：昨年度負担行為伝票",1,1,0,0]
["同変更","予算科目：今年度負担行為伝票",1,1,0,0]
["支出命令","予算科目：今年度負担行為伝票",1,1,0,0]
["同変更","予算科目：今年度負担行為・命令伝票",1,2,0,0,null,1,null,null,"取消・変更後・元"]
[]
["兼命令","予算科目：昨年度兼命令伝票",1,1,1,1]
["同変更","予算科目：今年度兼命令伝票",1,2,1,1,null,1,1,1]
[]
["支払","予算科目：今年度命令伝票"]
[null,"一件処理番号：負担行為・命令伝票",1,0,1,1,null,2,1,1,"未払・現金"]
[]
["戻入","予算科目：今年度命令伝票"]
[null,"一件処理番号：負担行為・命令伝票",1,4,1,1,null,2,1,1,"取消・変更後・元"]
[]
["収入予算"]
["累積調定","予算科目：昨年度累積調定伝票",1,1,1,1]
["同変更","予算科目：昨年度累積調定伝票",1,1,1,1]
["同収納","予算科目：昨年度累積調定伝票",1,0,1,0]
["同還付","予算科目：昨年度累積調定伝票",1,0,1,0]
[]
["個別調定","予算科目：昨年度個別調定伝票",1,1,1,1]
["同変更","予算科目：今年度個別調定伝票",1,2,1,1,null,1,1,1,"取消・変更後・元"]
["同収納","予算科目：今年度個別調定伝票",1,0,1,0]
["同還付","予算科目：今年度個別調定伝票",1,0,1,0]

{"sheet":"システム機能","index":2,"n_rows":43,"n_cols":7,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["標準画面の仕様",null,null,null,null,null,"画面イメージ（１）"]
[1,"全ての画面で共通に保持すべきデータ"]
[null,"ログインユーザ"]
[null,"会計区分"]
[null,"予算の年度区分"]
[null,"予算執行の処理区分"]
[]
[2,"伝票検索のためのデータ"]
[null,"検索対象：","ひな型伝票／発行済み関連伝票"]
[null,"検索キー：","発行所属課","発行月","執行CD"]
[null,null,"予算CD","借方CD","貸方CD"]
[null,null,"一件処理番号"]
[3,"検索された伝票からのデータ取得"]
[null,"画面イメージ","省略・サンプル参照"]
[]
[4,"取得したデータからの伝票作成"]
[null,"伝票種類：","伺伝票","予算伝票","簿記伝票"]
[null,"作成枚数：","1枚","処理区分に応じた枚数"]
[null,"画面イメージ","省略・サンプル参照"]
[]
[5,"確認画面の表示"]
[null,"入力データのチェック・確認"]
[null,"４に戻る"]
[]
[6,"伝票の登録"]
[null,"登録先テーブル：","伺伝票","予算伝票","簿記伝票"]
[]
[]
[]
[]
[]
[]
[]
["要望事項"]
[1,"/common_denpyou/edit_denpyou_blank.phpの修正"]
[null,"添付zipファイルで上書きして下さい"]
[null,"予算伝票発行時の予算残高を表示させる"]
[]
[2,"伝票の入力時に、ユーザー判断でブランク伝票を1枚づつ増やしていきたい"]
[null,"また、その時、科目CDを変更・選択できるようにしたい"]
[]
[4,"伺伝票の予算件数・簿記件数のテキストボックスの表示データ"]
[null,"登録直前に、予算伝票・簿記伝票の枚数を表示・登録"]

{"sheet":"既存DB処理フロー","index":3,"n_rows":20,"n_cols":13,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["処理フロー",null,null,null,null,"システムの機能",null,null,null,"テーブルの仕様"]
[null,null,null,null,null,null,"機能","処理方式"]
["①","第１列にIDとして連番を入力（連続データ作成）",null,null,null,1,"伝票入力・修正","単件／複数",null,"伝票テーブルU","伺伝票","伺ID"]
[null,null,"A2に１を入力・最終セルの列番号を確認",null,null,2,"伝票集計・表示",null,null,"伝票テーブルY","予算伝票","伺ID","一件処理番号"]
[null,null,"「ホーム」－「編集」－「連続データの作成」",null,null,3,"次年度繰越",null,null,"伝票テーブルB","簿記伝票","伺ID","一件処理番号"]
[null,null,"範囲「列」を選択・最終セルの列番号を入力",null,null,4,"初期登録"]
["②","見出し行を修正",null,null,null,5]
[null,null,"「既存DB変更」シートのG列を第１行に上書き",null,null,6]
[null,null,"行列入替でペースト",null,null,7,"その他"]
["③","列の削除",null,null,null,8,"システム・メンテ"]
[null,null,"「既存DB変更」シートのH列「使用しない」列を削除"]
["④","日付データを日付型データに変換"]
[null,null,"「既存DB変更」シートのH列「日付型」列が変換対象"]
[null,null,"対象列の右隣に５列程度を挿入"]
[null,null,"ユーザー関数=num2date(num)を利用して変換"]
[null,null,"最後は数値ペーストと、見出しをコピー"]
[null,null,"余分な列を削除"]
[null,"ACCESSにインポート"]
["⑤","コード表作成"]
["⑥"]

{"sheet":"既存DB変更","index":4,"n_rows":120,"n_cols":10,"rows_kept":120,"cut":false,"hidden":false,"merged":[]}
["区分","枚数",null,"番号","元カラム名","新カラム名","カラム名","カラム",null,"コード表作成"]
["収入伝票",7281,null,1,"伝票カガミ－年度",{"$f":"MID(E2,1,2)&MID(E2,7,LEN(E2)-5)","v":"伝票年度"},"伝票年度"]
["支出伝票",9753,null,2,"伝票カガミ－伝票番号",{"$f":"MID(E3,1,2)&MID(E3,7,LEN(E3)-5)","v":"伝票伝票番号"},"伝票伝票番号"]
["振替伝票",10619,null,3,"伝票カガミ－事業会計","伝票事業会計","伝票事業会計",null,null,"会計区分CD"]
[null,{"$f":"SUM(B2:B4)","v":27653},null,4,"伝票カガミ－事業会計名称","伝票事業会計名称","伝票事業会計名称",null,null,"〇"]
[null,null,null,5,"伝票カガミ－伝票種別","伝票伝票種別","伝票伝票種別",null,null,"伝票区分CD"]
[null,null,null,6,"伝票カガミ－伝票種別名称","伝票伝票種別名称","伝票伝票種別名称",null,null,"〇"]
[null,null,null,7,"伝票カガミ－起案書種別","伝票起案書種別","伝票起案書種別",null,null,"伺CD"]
[null,null,null,8,"伝票カガミ－起案書種別名称","伝票起案書種別名称","伝票起案書種別名称",null,null,"〇"]
[null,null,null,9,"伝票カガミ－所属コード","伝票所属コード","伝票所属コード",null,null,"所属CD"]
[null,null,null,10,"伝票カガミ－所属名称","伝票所属名称","伝票所属名称",null,null,"〇"]
[null,null,null,11,"伝票カガミ－起案日","伝票起案日","伝票起案日","date型"]
[null,null,null,12,"伝票カガミ－発行日付","伝票発行日付","伝票発行日付","date型"]
[null,null,null,13,"伝票カガミ－合計件数","伝票合計件数","伝票合計件数"]
[null,null,null,14,"伝票カガミ－借方件数","伝票借方件数","伝票借方件数"]
[null,null,null,15,"伝票カガミ－貸方件数","伝票貸方件数","伝票貸方件数"]
[null,null,null,16,"伝票カガミ－金額","伝票金額","伝票金額","通貨型"]
[null,null,null,17,"伝票カガミ－消費税額","伝票消費税額","伝票消費税額","通貨型"]
[null,null,null,18,"伝票カガミ－予算残額","伝票予算残額","伝票予算残額","通貨型"]
[null,null,null,19,"伝票カガミ－執行残額","伝票執行残額","伝票執行残額","通貨型"]
[null,null,null,20,"伝票カガミ－貸方予算残額","伝票貸方予算残額","伝票貸方予算残額","通貨型"]
[null,null,null,21,"伝票カガミ－貸方執行残額","伝票貸方執行残額","伝票貸方執行残額","通貨型"]
[null,null,null,22,"伝票カガミ－修正仕訳区分","伝票修正仕訳区分","伝票修正仕訳区分",null,null,"修正CD"]
[null,null,null,23,"伝票カガミ－修正仕訳区分名称","伝票修正仕訳区分名称","伝票修正仕訳区分名称",null,null,"〇"]
[null,null,null,24,"伝票カガミ－摘要","伝票摘要","伝票摘要",null,null,"摘要CD"]
[null,null,null,25,"伝票カガミ－摘要名称","伝票摘要名称","伝票摘要名称",null,null,"〇"]
[null,null,null,26,"伝票カガミ－未収未払区分","伝票未収未払区分","伝票未収未払区分",null,null,"未収未払CD"]
[null,null,null,27,"伝票カガミ－未収未払区分名称","伝票未収未払区分名称","伝票未収未払区分名称",null,null,"〇"]
[null,null,null,28,"伝票カガミ－相手方番号","伝票相手方番号","伝票相手方番号",null,null,"相手方CD"]
[null,null,null,29,"伝票カガミ－相手方住所","伝票相手方住所","伝票相手方住所",null,null,"△"]
[null,null,null,30,"伝票カガミ－相手方名称","伝票相手方名称","伝票相手方名称",null,null,"△"]
[null,null,null,31,"伝票カガミ－相手方郵便番号","伝票相手方郵便番号","伝票相手方郵便番号",null,null,"△"]
[null,null,null,32,"伝票カガミ－調定命令年度","伝票調定命令年度","伝票調定命令年度"]
[null,null,null,33,"伝票カガミ－調定番号","伝票調定番号","伝票調定番号","一件処理番号"]
[null,null,null,34,"伝票カガミ－支出命令番号","伝票支出命令番号","伝票支出命令番号","一件処理番号"]
[null,null,null,35,"伝票カガミ－精算番号","伝票精算番号","伝票精算番号","一件処理番号"]
[null,null,null,36,"伝票カガミ－起票処理種別","伝票起票処理種別","伝票起票処理種別",null,null,"支払区分CD"]
[null,null,null,37,"伝票カガミ－起票処理種別名称","伝票起票処理種別名称","伝票起票処理種別名称",null,null,"〇"]
[null,null,null,38,"伝票カガミ－事由","伝票事由","伝票事由"]
[null,null,null,39,"伝票カガミ－正負区分","伝票正負区分","伝票正負区分","正負CD"]
[null,null,null,40,"伝票カガミ－正負区分名称","伝票正負区分名称","伝票正負区分名称","金額増・減で対応"]
[null,null,null,41,"伝票カガミ－納付書出力区分","伝票納付書出力区分","伝票納付書出力区分",null,null,"納付書CD"]
[null,null,null,42,"伝票カガミ－納付書出力区分名称","伝票納付書出力区分名称","伝票納付書出力区分名称",null,null,"〇"]
[null,null,null,43,"伝票カガミ－納期限","伝票納期限","伝票納期限","納期限CD"]
[null,null,null,44,"伝票カガミ－決裁種別","伝票決裁種別","伝票決裁種別","進捗CD1"]
[null,null,null,45,"伝票カガミ－決裁状態区分","伝票決裁状態区分","伝票決裁状態区分","進捗CD2"]
[null,null,null,46,"伝票カガミ－添付文書区分","伝票添付文書区分","伝票添付文書区分","添付CD"]
[null,null,null,47,"伝票カガミ－取消区分","伝票取消区分","伝票取消区分","取消CD"]
[null,null,null,48,"伝票借方－所属コード",{"$f":"MID(E49,3,2)&MID(E49,6,LEN(E49)-5)","v":"借方所属コード"},"借方所属コード","使用しない"]
[null,null,null,49,"伝票借方－所属名称",{"$f":"MID(E50,3,2)&MID(E50,6,LEN(E50)-5)","v":"借方所属名称"},"借方所属名称","使用しない"]
[null,null,null,50,"伝票借方－予算区分","借方予算区分","借方予算区分",null,null,"予算種類CD"]
[null,null,null,51,"伝票借方－予算区分名称","借方予算区分名称","借方予算区分名称",null,null,"〇"]
[null,null,null,52,"伝票借方－予算款","借方予算款","借方予算款",null,null,"予算CD"]
[null,null,null,53,"伝票借方－予算款名称","借方予算款名称","借方予算款名称",null,null,"予算CD"]
[null,null,null,54,"伝票借方－予算項","借方予算項","借方予算項",null,null,"予算CD"]
[null,null,null,55,"伝票借方－予算項名称","借方予算項名称","借方予算項名称",null,null,"予算CD"]
[null,null,null,56,"伝票借方－予算目","借方予算目","借方予算目",null,null,"予算CD"]
[null,null,null,57,"伝票借方－予算目名称","借方予算目名称","借方予算目名称",null,null,"予算CD"]
[null,null,null,58,"伝票借方－予算大事項","借方予算大事項","借方予算大事項","使用しない"]
[null,null,null,59,"伝票借方－予算大事項名称","借方予算大事項名称","借方予算大事項名称","使用しない"]
[null,null,null,60,"伝票借方－予算小事項","借方予算小事項","借方予算小事項","使用しない"]
[null,null,null,61,"伝票借方－予算小事項名称","借方予算小事項名称","借方予算小事項名称","使用しない"]
[null,null,null,62,"伝票借方－予算節","借方予算節","借方予算節",null,null,"予算CD"]
[null,null,null,63,"伝票借方－予算節名称","借方予算節名称","借方予算節名称",null,null,"予算CD"]
[null,null,null,64,"伝票借方－予算細節","借方予算細節","借方予算細節"]
[null,null,null,65,"伝票借方－予算細節名称","借方予算細節名称","借方予算細節名称"]
[null,null,null,66,"伝票借方－予算細々節","借方予算細々節","借方予算細々節","使用しない"]
[null,null,null,67,"伝票借方－予算細々節名称","借方予算細々節名称","借方予算細々節名称","使用しない"]
[null,null,null,68,"伝票借方－勘定款","借方勘定款","借方勘定款",null,null,"借方CD"]
[null,null,null,69,"伝票借方－勘定款名称","借方勘定款名称","借方勘定款名称",null,null,"借方CD"]
[null,null,null,70,"伝票借方－勘定項","借方勘定項","借方勘定項",null,null,"借方CD"]
[null,null,null,71,"伝票借方－勘定項名称","借方勘定項名称","借方勘定項名称",null,null,"借方CD"]
[null,null,null,72,"伝票借方－勘定目","借方勘定目","借方勘定目",null,null,"借方CD"]
[null,null,null,73,"伝票借方－勘定目名称","借方勘定目名称","借方勘定目名称",null,null,"借方CD"]
[null,null,null,74,"伝票借方－勘定節","借方勘定節","借方勘定節",null,null,"借方CD"]
[null,null,null,75,"伝票借方－勘定節名称","借方勘定節名称","借方勘定節名称",null,null,"借方CD"]
[null,null,null,76,"伝票借方－勘定細節","借方勘定細節","借方勘定細節",null,null,"借方CD"]
[null,null,null,77,"伝票借方－勘定細節名称","借方勘定細節名称","借方勘定細節名称",null,null,"借方CD"]
[null,null,null,78,"伝票借方－セグメント","借方セグメント","借方セグメント",null,null,"借方CD"]
[null,null,null,79,"伝票借方－消費税区分","借方消費税区分","借方消費税区分",null,null,"消費税区分CD"]
[null,null,null,80,"伝票借方－消費税区分名称","借方消費税区分名称","借方消費税区分名称",null,null,"〇"]
[null,null,null,81,"伝票借方－消費税率","借方消費税率","借方消費税率"]
[null,null,null,82,"伝票借方－予算用金額","借方予算用金額","借方予算用金額","通貨型"]
[null,null,null,83,"伝票借方－勘定用金額","借方勘定用金額","借方勘定用金額","通貨型"]
[null,null,null,84,"伝票貸方－所属コード","貸方所属コード","貸方所属コード"]
[null,null,null,85,"伝票貸方－所属名称","貸方所属名称","貸方所属名称"]
[null,null,null,86,"伝票貸方－予算区分","貸方予算区分","貸方予算区分"]
[null,null,null,87,"伝票貸方－予算区分名称","貸方予算区分名称","貸方予算区分名称"]
[null,null,null,88,"伝票貸方－予算款","貸方予算款","貸方予算款",null,null,"貸方CD"]
[null,null,null,89,"伝票貸方－予算款名称","貸方予算款名称","貸方予算款名称",null,null,"貸方CD"]
[null,null,null,90,"伝票貸方－予算項","貸方予算項","貸方予算項",null,null,"貸方CD"]
[null,null,null,91,"伝票貸方－予算項名称","貸方予算項名称","貸方予算項名称",null,null,"貸方CD"]
[null,null,null,92,"伝票貸方－予算目","貸方予算目","貸方予算目",null,null,"貸方CD"]
[null,null,null,93,"伝票貸方－予算目名称","貸方予算目名称","貸方予算目名称",null,null,"貸方CD"]
[null,null,null,94,"伝票貸方－予算大事項","貸方予算大事項","貸方予算大事項","使用しない"]
[null,null,null,95,"伝票貸方－予算大事項名称","貸方予算大事項名称","貸方予算大事項名称","使用しない"]
[null,null,null,96,"伝票貸方－予算小事項","貸方予算小事項","貸方予算小事項","使用しない"]
[null,null,null,97,"伝票貸方－予算小事項名称","貸方予算小事項名称","貸方予算小事項名称","使用しない"]
[null,null,null,98,"伝票貸方－予算節","貸方予算節","貸方予算節",null,null,"貸方CD"]
[null,null,null,99,"伝票貸方－予算節名称","貸方予算節名称","貸方予算節名称",null,null,"貸方CD"]
[null,null,null,100,"伝票貸方－予算細節","貸方予算細節","貸方予算細節"]
[null,null,null,101,"伝票貸方－予算細節名称","貸方予算細節名称","貸方予算細節名称"]
[null,null,null,102,"伝票貸方－予算細々節","貸方予算細々節","貸方予算細々節","使用しない"]
[null,null,null,103,"伝票貸方－予算細々節名称","貸方予算細々節名称","貸方予算細々節名称","使用しない"]
[null,null,null,104,"伝票貸方－勘定款","貸方勘定款","貸方勘定款",null,null,"貸方CD"]
[null,null,null,105,"伝票貸方－勘定款名称","貸方勘定款名称","貸方勘定款名称",null,null,"貸方CD"]
[null,null,null,106,"伝票貸方－勘定項","貸方勘定項","貸方勘定項",null,null,"貸方CD"]
[null,null,null,107,"伝票貸方－勘定項名称","貸方勘定項名称","貸方勘定項名称",null,null,"貸方CD"]
[null,null,null,108,"伝票貸方－勘定目","貸方勘定目","貸方勘定目",null,null,"貸方CD"]
[null,null,null,109,"伝票貸方－勘定目名称","貸方勘定目名称","貸方勘定目名称",null,null,"貸方CD"]
[null,null,null,110,"伝票貸方－勘定節","貸方勘定節","貸方勘定節",null,null,"貸方CD"]
[null,null,null,111,"伝票貸方－勘定節名称","貸方勘定節名称","貸方勘定節名称",null,null,"貸方CD"]
[null,null,null,112,"伝票貸方－勘定細節","貸方勘定細節","貸方勘定細節"]
[null,null,null,113,"伝票貸方－勘定細節名称",{"$f":"MID(E114,3,2)&MID(E114,6,LEN(E114)-5)","v":"貸方勘定細節名称"},"貸方勘定細節名称"]
[null,null,null,114,"伝票貸方－セグメント","貸方セグメント","貸方セグメント","使用しない"]
[null,null,null,115,"伝票貸方－消費税区分","貸方消費税区分","貸方消費税区分"]
[null,null,null,116,"伝票貸方－消費税区分名称","貸方消費税区分名称","貸方消費税区分名称"]
[null,null,null,117,"伝票貸方－消費税率","貸方消費税率","貸方消費税率"]
[null,null,null,118,"伝票貸方－予算用金額","貸方予算用金額","貸方予算用金額","通貨型"]
[null,null,null,119,"伝票貸方－勘定用金額","貸方勘定用金額","貸方勘定用金額","通貨型"]

{"sheet":"既存DBからの移行","index":5,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["既存DBから新DBの作成手順"]
[1,"既存DBから出力したcsvファイルをACCESSにimport"]
[2,"ACCESS上で新DB用テーブルのデータ作成"]
[3,"ACCESS上で作成したデータをcsvファイルにexport"]
[4,"phpmyadmin上でそのデータを各テーブルにimport"]
[5,"適宜、ACCESS用のテーブル定義sql生成ツール「jet-tool-0.6b-2018.01.12」を利用"]