{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Sheet1","集計表","DEN","BTIN","TBL","入力","Module1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":1,"pivot_tables":0},"unopened":[{"sheet":"Module1","index":6,"reason":"part_missing"}],"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":"Sheet1","index":0,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":true,"merged":[[2,7,10,7],[11,7,42,7],[0,0,1,0],[2,4,9,4],[0,1,1,1],[10,4,38,4]]}
["№","列","Ｒ　　Ｍ　　標　　準",null,null,"日　新　バ　ー　ジ　ョ　ン"]
[null,null,"項　目　名　称","項　目　名","分類","項　目　名　称","項　目　名","分類"]
[1,"A","伝票日付","BLDAT","ヘッダ","伝票日付","BLDAT","ヘッダ"]
[2,"B","会社ｺｰﾄﾞ","BUKRS",null,"伝票タイプ","BUKRS"]
[3,"C","転記日付","BUDAT",null,"会社コード","BUDAT"]
[4,"D","伝票ﾀｲﾌﾟ","BLART",null,"転記日付","BLART"]
[5,"E","通貨ｺｰﾄﾞ","WAERS",null,"通貨コード","WAERS"]
[6,"F","ヘッダテキスト","BKTXT",null,"換算レート","KURSF"]
[7,"G","参照伝票番号","XBLNR",null,"参照伝票番号","XBLNR"]
[8,"H","税自動計算","XMWST",null,"ヘッダテキスト","BKTXT"]
[9,"I","転記ｷｰ","NEWBS","明　　　　　　　　　細","税自動計算","XMWST"]
[10,"J","勘定ｺｰﾄﾞ","NEWKO",null,"転記キー","NEWBS","明　　　　　　　　　細"]
[11,"K","特殊GL","NEWUM",null,"勘定コード","NEWKO"]
[12,"L","金額","WRBTR",null,"特殊GL","NEWUM"]
[13,"M","税ｺｰﾄﾞ","MWSKZ",null,"金額","WRBTR"]
[14,"N","ｿｰﾄｷｰ","ZUONR",null,"国内通貨額","DMBTR"]
[15,"O","明細ﾃｷｽﾄ","SGTXT",null,"税コード","MWSKZ"]
[16,"P","起算日","VALUT",null,"ソートキー","ZUONR"]
[17,"Q","期日","ZFBDT",null,"明細テキスト","SGTXT"]
[18,"R","振出日","WDATE",null,"起算日","VALUT"]
[19,"S","支払方法","ZLSCH",null,"期日","ZFBDT"]
[20,"T","支払保留","ZLSPR",null,"振出日","WDATE"]
[21,"U","数量","MENGE",null,"支払方法","ZLSCH"]
[22,"V","数量単位","MEINS",null,"支払保留","ZLSPR"]
[23,"W","事業領域","GSBER",null,"取引先銀行","BVTYP"]
[24,"X","原価ｾﾝﾀ","KOSTL",null,"取引銀行","HBKID"]
[25,"Y","利益ｾﾝﾀ","PRCTR",null,"中央銀行コード","LZBKZ"]
[26,"Z","指図書","AUFNR",null,"数量","MENGE"]
[27,"AA","ＷＢＳ","PS_PSP_PNR",null,"数量単位","MEINS"]
[28,"AB","得意先ｺｰﾄﾞ","RKEAK-FIELD1",null,"事業領域","GSBER"]
[29,"AC","品目ｺｰﾄﾞ","RKEAK-FIELD2",null,"原価センタ","KOSTL"]
[30,"AD","販売組織","RKEAK-FIELD6",null,"利益センタ","PRCTR"]
[31,"AE","流通ﾁｬﾈﾙ","RKEAK-FIELD7",null,"指図書","AUFNR"]
[32,"AF","製品部門","RKEAK-FIELD8",null,"ＷＢＳ","PS_PSP_PNR"]
[33,"AG","品目ｸﾞﾙｰﾌﾟ","RKEAK-FIELD9",null,"得意先コード","RKEAK-FIELD1"]
[34,"AH","営業所","RKEAK-FIELD2",null,"品目コード","RKEAK-FIELD2"]
[35,"AI","営業グループ","RKEAK-FIELD3",null,"販売組織","RKEAK-FIELD6"]
[36,"AJ","需要家","RKEAK-FIELD2",null,"流通チャネル","RKEAK-FIELD7"]
[37,"AK","研究室/設計室","RKEAK-FIELD3",null,"製品部門","RKEAK-FIELD8"]
[38,"AL",null,null,null,"品目グループ","RKEAK-FIELD9"]
[39,"AM",null,null,null,"営業所","RKEAK-FIELD2"]
[40,"AN",null,null,null,"営業グループ","RKEAK-FIELD3"]
[41,"AO",null,null,null,"需要家","RKEAK-FIELD2"]

{"sheet":"集計表","index":1,"n_rows":76,"n_cols":15,"rows_kept":76,"cut":false,"hidden":false,"merged":[[75,2,75,3],[3,6,4,6],[56,6,64,6]]}
["前払金振替原価表　2023年9月"]
[]
["部門","発行部課","支払先コード","支払先","依頼NO","前払金額","受領","テキスト","勘定項目","勘定コード","振替金額","税コード","振替部課"]
["総一",624,"00LU85","(株)丸八アセットマネージメント","G230700171600-01",214880,"2023-07-18","浜松 町会費（丸八ｱｾｯﾄﾏﾈｰｼﾞﾒﾝﾄ)","原価-会費加入","352810",1000,"A0","NS-0624","*"]
[null,null,null,null,null,null,null,"浜松 事務所家賃（丸八ｱｾｯﾄﾏﾈｰｼﾞﾒﾝﾄ)","原価-賃借事務所",351610,213880,"AA","NS-0624","←支払先変更（2021.09）"]
["総一",625,"00N521","須田運送(株)",null,null,null,"太田 事務所家賃（須田運送)","原価-賃借事務所",351610,232650,"AA","NS-0625"]
[null,null,null,null,null,null,null,"太田 共益費（須田運送)","原価-雑費",352900,66000,"AA","NS-0625"]
[null,null,null,null,null,null,null,"太田 駐車場代（須田運送)","原価-賃借駐車場",351650,44000,"AA","NS-0625","←2022.04～変更"]
["総一",628,"00Y184","丸新産業(有)",null,null,null,"厚木 事務所家賃（丸新産業)","原価-賃借事務所",351610,68369,"AA","NS-0628","*","*財務課に契約書有(ﾌﾟﾙｰﾌのみ到着でOK)"]
[null,null,null,null,null,null,null,"厚木 共益費（丸新産業）","原価-雑費",352900,24334,"AA","NS-0628","2023年7月解約"]
["総一",628,"00Y147","東横興業(有)",null,null,null,"厚木 駐車場代（東横興業）","原価-賃借駐車場",351650,27500,"AA","NS-0628","*"]
["総一",628,"00LY57","原田建物",null,null,null,"厚木 事務所家賃（原田建物)","原価-賃借事務所",352900,311540,"AA","NS-0628"]
[null,null,null,null,null,null,null,"厚木 事務所共益費（原田建物）","原価-雑費",352900,55697,"AA","NS-0628"]
["総一",646,"00LP46","かつみ開発(株)",null,null,null,"朝霞 駐車場代（かつみ不動産)","原価-賃借駐車場","351650",14300,"AA","NS-0646","*"]
["総一",614,"00CA03","(株)谷澤総合コンサルタント",null,null,null,"ふじみ野 駐車場代（谷澤総合ｺﾝｻﾙﾀﾝﾄ）","原価-賃借駐車場",351650,25974,"AA","NS-0614","*"]
["総一",614,"00CA03","(株)谷澤総合コンサルタント",null,null,null,"ふじみ野 駐車場代（谷澤総合ｺﾝｻﾙﾀﾝﾄ）","原価-賃借駐車場",351650,8658,"AA","NS-0733","*"]
["総一",614,"00CA03","(株)谷澤総合コンサルタント",null,null,null,"ふじみ野 事務所賃料（谷澤総合ｺﾝｻﾙﾀﾝﾄ）","原価-賃借事務所",351610,473000,"AA","NS-0614","*"]
["総一",621,"00LV71","(株)リオ・ソリューション",null,null,null,"SP長岡ビル旧朝日生命　事務所賃借料","原価-賃借事務所","351610",101574,"AA","NS-0621"]
["総一",621,"00LV71","(株)リオ・ソリューション",null,null,null,"ステーションプラザ長岡ビル TR3","原価-賃借事務所","351610",6600,"AA","NS-0621"]
["総一",621,"00LW40","鈴木　啓利",null,null,null,"長岡営業所 駐車場代","原価-賃借駐車場","351650",17600,"AA","NS-0623","*"]
["総一",624,"004755","セコム(株)",null,null,null,"セコム　事務所管理料","原価-雑費",352900,17380,"AA","NS-0624"]
["総務",123,"00LU39","住友不動産(株)",null,null,null,"半蔵門駅前ビル 清掃業務委託料","原価-雑費","352900",2165900,"AA","NS-0129"]
[null,null,null,null,null,null,null,"半蔵門駅前ビル 賃借料","原価-賃借事務所","351610",43795651,"AA","NS-0129"]
[null,null,null,null,null,null,null,"半蔵門駅前ビル 駐車場代","原価-賃借駐車場","351650",528000,"AA","NS-0129"]
["京浜",331,"00N349","山下ふ頭交通対策協議会",null,null,null,"山下ふ頭交通対策協議会駐車場代","原価-賃借駐車場",351650,20000,"AA","NS-0330"]
["港運",325,"00Y792","APMターミナルズジャパン(株)",null,null,null,"南本牧事務所賃借料","原価-賃借事務所",351610,1667281,"AA","NS-0325"]
[null,null,null,null,null,null,null,"南本牧駐車場代","原価-賃借駐車場",351650,88550,"AA","NS-0325"]
["秘書室",150,"00Y587","フジ商事不動産",null,null,null,"001　役員車駐車場代","原価-賃借駐車場",351650,24150,"AA","NS-0101"]
["秘書室",150,"00V757","濱田　直和",null,null,null,"002　役員車駐車場代","原価-賃借駐車場",351650,15000,"AA","NS-0101"]
["航空一部",691,"00LW04","北海道エアポート(株)",null,null,null,"新千歳_事務所賃料","原価-賃借事務所",351610,135119,"AA","NS-0804","請求書の共益費の金額は入れない"]
[null,null,null,null,null,null,null,"新千歳_駐車場","原価-賃借駐車場",351650,26400,"AA","NS-0804"]
[null,null,null,null,null,null,null,"新千歳_清掃料","原価-雑費",352900,2727,"AA","NS-0804"]
[null,null,null,null,null,null,null,"新千歳_電気料金","原価-水道光熱費",351300,8531,"AA","NS-0804","(+共益費の中の電気料金)"]
[null,null,null,null,null,null,null,"新千歳_上下水道料金","原価-水道光熱費",351300,909,"AA","NS-0804"]
[null,null,null,null,null,null,null,"新千歳_保管庫使用料","原価-雑費",352900,11000,"AA","NS-0804"]
[null,null,null,null,null,null,null,"新千歳_灯油代","原価-水道光熱費",351300,0,"AA","NS-0804","冬期は灯油代（水道光熱費）が発生"]
["航空一部",644,"00A550","(財)全専売会館",null,null,null,"東東京営業所　事務所賃借料","原価-賃借事務所",351610,472202,"AA","NS-0644","※前月前払い残金を振替"]
["航空一部",644,"00A550","(財)全専売会館",null,null,null,"東東京営業所  (共益費+蛍光灯類代)","原価-雑費",352900,171606,"AA","NS-0644","毎月当月分","毎月17日頃に入力､20~21日頃に到着、別プルーフの電気代は入れないこと！"]
[null,null,null,null,null,null,null,"東東京営業所　家賃","前払金","142102",472202,null,"NS-0644","毎月翌月分","(貸室賃料翌月分+1階屋外倉庫)"]
["航空二部",647,"00A794","横浜航空貨物ターミナル(株)",null,null,null,"YAT事務所賃借料","原価-賃借事務所",351610,330000,"AA","NS-0647"]
["航空二部",647,"00N349","山下ふ頭交通対策協議会",null,null,null,"山下埠頭駐車場代","原価-賃借駐車場",351650,5000,"AA","NS-0647"]
["陸運",259,"00Y719","(株)JR貨物・不動産開発",null,null,null,"駐車場代","原価-陸運（通運）","351052",29150,"AA","NS-0259"]
[null,null,null,null,null,null,null,"駐車場代","原価-賃借駐車場",351650,16500,"AA","NS-0259"]
["総三",421,"00LC67","(社)川崎市電設工業会",null,null,null,"川崎市電設工業会　事務所賃料代","原価-賃借事務所",351610,208890,"AA","NS-0421"]
[null,421,"00LC67","(社)川崎市電設工業会",null,null,null,"川崎市電設工業会　駐車場代","原価-賃借駐車場",351650,66000,"AA","NS-0421"]
["総一",629,"00LR13","（株）不二ロジカーゴ",null,null,null,"事務所賃料（不二ロジカーゴ）","原価-賃借事務所",351610,60291,"AA","NS-0629"]
[null,null,null,null,null,null,null,"駐車場代（不二ロジカーゴ）","原価-賃借駐車場",351650,28050,"AA","NS-0629"]
[null,null,null,null,null,null,null,"共益費等（不二ロジカーゴ）","原価-雑費",352900,11000,"AA","NS-0629"]
["航空一部",690,"00LV50","(有)スピカ",null,null,null,"新宿MOAビル 事務所賃借料","原価-賃借事務所","351610",491018,"AA","NS-0643"]
[null,null,null,null,null,null,null,"新宿MOAビル 共益費","原価-雑費","352900",89276,"AA","NS-0643"]
[null,null,null,null,null,null,null,"新宿MOAビル 事務所賃借料","原価-賃借事務所","351610",491018,"AA","NS-0609"]
[null,null,null,null,null,null,null,"新宿MOAビル 共益費","原価-雑費","352900",89276,"AA","NS-0609","←2022.02～開始"]
["引越",738,"00LX02","(株)アズーム",null,null,null,"2022/第74号 名古屋営業所駐車場","原価-賃借駐車場",351650,33000,"AA","NS-0738"]
["総務",123,"00LY76","日本車庫(株)",null,null,null,"筒井専務車専用　駐車場代","原価-賃借駐車場",351650,38500,"AA","NS-0101"]
["総一",624,"00LR46","中部ガス不動産（株）","G230700171500-01",5000,"2023-07-18","駐車場代（中部ガス不動産）","原価-賃借駐車場",351650,5000,"A0","NS-0624"]
["総務",129,"009941","京浜不動産(株)",null,null,null,"ニッセイビル　賃借料","原価-賃借事務所",351610,8192250,"AA","NS-0129"]
["引越",735,"009904","(株)愛知日新",null,null,null,"愛知日新　事務所賃借料 ","原価-賃借事務所",351610,174550,"AA","NS-0735"]
[null,null,null,null,null,null,null,"愛知日新　駐車場代 ","原価-賃借駐車場",351650,33000,"AA","NS-0735"]
[null,null,null,null,null,null,null,"愛知日新　共益費 ","原価-雑費",352900,107415,"AA","NS-0735"]
[null,null,null,null,null,null,null,"愛知日新　電気代 ","原価-電力料",351300,26955,"AA","NS-0735"]
[null,null,null,null,null,null,null,"愛知日新　カラー複合機リース代 ","原価-賃借事務器","351620",10841,"AA","NS-0735"]
[null,null,null,null,null,null,null,"愛知日新　シュレッダーリース代 ","原価-賃借事務器","351620",3218,"AA","NS-0735"]
[null,null,null,null,null,null,null,"愛知日新　電話機リース代 ","原価-賃借事務器","351620",11568,"AA","NS-0735"]
[null,null,null,null,null,null,null,"愛知日新 宅急便送料","原価-郵便料","352130",1320,"AA","NS-0735"]
[null,null,null,null,null,null,null,"愛知日新　コピー代 ","原価-印刷代","352430",41094,"AA","NS-0735"]
["総-三鶴見",427,"009905","鶴見倉庫(株)",null,null,null,"鶴見　事務所賃料","原価-賃借事務所",351610,297000,"AA","NS-0427"]
["食品",310,"009941","京浜不動産(株)",null,null,null,"社用車駐車場使用料","原価-賃借事務所",351610,42350,"AA","NS-0310"]
[null,null,null,null,null,{"$f":"SUM(F4:F66)","v":219880},null,null,null,null,{"$f":"SUM(K4:K66)","v":62206464}]
[]
[]
[null,null,null,null,null,"毎月入力する"]
[]
[null,null,null,null,"*","644の全専売会館は要注意。毎回最後に届き、\"前払金\" であるが、プルーフの記載は翌月以降分ではなく、\"当月分\" になっている(他部店と比べてズレている)"]
[null,null,null,null,null,"また時折、直接資金課へ上がってしまうので、その場合にはデータで確認する"]
[]
[null,null,"(財)全専売会館\nSAP→勘定コード明細→142102\n→伝票番号(金額で呼び出す)"]

{"sheet":"DEN","index":2,"n_rows":72,"n_cols":43,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
[null,null,"X","　←　“X”を入力し、バッチインプットの処理モードを“E”で実行すると伝票概要画面で止まり、確認することが出来る"]
["伝票日付","会社","転記日付","伝票ﾀｲﾌﾟ","通貨ｺｰﾄﾞ","換算ﾚｰﾄ","参照伝票番号","ヘッダテキスト","税自動計算","転記ｷｰ","勘定コード","特殊GL","金額","国内通貨額","税ｺｰﾄﾞ","事業領域","原価センタ","利益センタ","ソートキー","明細テキスト","起算日","期日","振出日","支払方法","支払保留","取引先銀行","取引銀行","中央銀行CD","数量","数量単位","指図書","ＷＢＳ","得意先ｺｰﾄﾞ","品目ｺｰﾄﾞ","販売組織","流通ﾁｬﾈﾙ","製品部門","品目ｸﾞﾙｰﾌﾟ","営業所","営業グループ","需要家"]
[{"$f":"C3","v":"2023.09.30"},"NS","2023.09.30","SA","JPY",null,null,{"$f":"\"前払費用振替（単月）\"&MID(C3,6,2)&\"月\"","v":"前払費用振替（単月）09月"},"×",{"$f":"IF(K3<>0,\"40\",\"\")","v":"40"},{"$f":"集計表!J4","v":"352810"},null,{"$f":"集計表!K4","v":1000},null,{"$f":"IF(集計表!L4=\"\",\"\",集計表!L4)","v":"A0"},null,{"$f":"集計表!M4","v":"NS-0624"},null,{"$f":"Q3","v":"NS-0624"},{"$f":"集計表!H4&MID($C$3,6,2)&\" \"&\"月\"","v":"浜松 町会費（丸八ｱｾｯﾄﾏﾈｰｼﾞﾒﾝﾄ)09 月"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[{"$f":"IF(AND(J3=\"40\",J4=\"\"),\"eof\",\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(K4<>0,\"40\",\"\")","v":"40"},{"$f":"集計表!J5","v":351610},null,{"$f":"集計表!K5","v":213880},null,{"$f":"IF(集計表!L5=\"\",\"\",集計表!L5)","v":"AA"},null,{"$f":"集計表!M5","v":"NS-0624"},null,{"$f":"Q4","v":"NS-0624"},{"$f":"集計表!H5&MID($C$3,6,2)&\" \"&\"月\"","v":"浜松 事務所家賃（丸八ｱｾｯﾄﾏﾈｰｼﾞﾒﾝﾄ)09 月"}]
[{"$f":"IF(AND(J4=\"40\",J5=\"\"),\"eof\",\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(K5<>0,\"40\",\"\")","v":"40"},{"$f":"集計表!J6","v":351610},null,{"$f":"集計表!K6","v":232650},null,{"$f":"IF(集計表!L6=\"\",\"\",集計表!L6)","v":"AA"},null,{"$f":"集計表!M6","v":"NS-0625"},null,{"$f":"Q5","v":"NS-0625"},{"$f":"集計表!H6&MID($C$3,6,2)&\" \"&\"月\"","v":"太田 事務所家賃（須田運送)09 月"}]
[null,null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J7","v":352900},null,{"$f":"集計表!K7","v":66000},null,{"$f":"IF(集計表!L7=\"\",\"\",集計表!L7)","v":"AA"},null,{"$f":"集計表!M7","v":"NS-0625"},null,"NS-0625",{"$f":"集計表!H7&MID($C$3,6,2)&\" \"&\"月\"","v":"太田 共益費（須田運送)09 月"}]
[{"$f":"IF(AND(J5=\"40\",J7=\"\"),\"eof\",\"\")","v":""},null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J8","v":351650},null,{"$f":"集計表!K8","v":44000},null,{"$f":"IF(集計表!L8=\"\",\"\",集計表!L8)","v":"AA"},null,{"$f":"集計表!M8","v":"NS-0625"},null,"NS-0625",{"$f":"集計表!H8&MID($C$3,6,2)&\" \"&\"月\"","v":"太田 駐車場代（須田運送)09 月"}]
["",null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J9","v":351610},null,{"$f":"集計表!K9","v":68369},null,{"$f":"IF(集計表!L9=\"\",\"\",集計表!L9)","v":"AA"},null,{"$f":"集計表!M9","v":"NS-0628"},null,"NS-0628",{"$f":"集計表!H9&MID($C$3,6,2)&\" \"&\"月\"","v":"厚木 事務所家賃（丸新産業)09 月"}]
["",null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J10","v":352900},null,{"$f":"集計表!K10","v":24334},null,{"$f":"IF(集計表!L10=\"\",\"\",集計表!L10)","v":"AA"},null,{"$f":"集計表!M10","v":"NS-0628"},null,"NS-0628",{"$f":"集計表!H10&MID($C$3,6,2)&\" \"&\"月\"","v":"厚木 共益費（丸新産業）09 月"}]
["",null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J11","v":351650},null,{"$f":"集計表!K11","v":27500},null,{"$f":"IF(集計表!L11=\"\",\"\",集計表!L11)","v":"AA"},null,{"$f":"集計表!M11","v":"NS-0628"},null,"NS-0628",{"$f":"集計表!H11&MID($C$3,6,2)&\" \"&\"月\"","v":"厚木 駐車場代（東横興業）09 月"}]
[null,null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J12","v":352900},null,{"$f":"集計表!K12","v":311540},null,{"$f":"IF(集計表!L12=\"\",\"\",集計表!L12)","v":"AA"},null,{"$f":"集計表!M12","v":"NS-0628"},null,"NS-0628",{"$f":"集計表!H12&MID($C$3,6,2)&\" \"&\"月\"","v":"厚木 事務所家賃（原田建物)09 月"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(K12<>0,\"40\",\"\")","v":"40"},{"$f":"集計表!J13","v":352900},null,{"$f":"集計表!K13","v":55697},null,{"$f":"IF(集計表!L13=\"\",\"\",集計表!L13)","v":"AA"},null,{"$f":"集計表!M13","v":"NS-0628"},null,"NS-0628",{"$f":"集計表!H13&MID($C$3,6,2)&\" \"&\"月\"","v":"厚木 事務所共益費（原田建物）09 月"}]
[{"$f":"IF(AND(J10=\"40\",J13=\"\"),\"eof\",\"\")","v":""},null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J14","v":"351650"},null,{"$f":"集計表!K14","v":14300},null,{"$f":"IF(集計表!L14=\"\",\"\",集計表!L14)","v":"AA"},null,{"$f":"集計表!M14","v":"NS-0646"},null,"NS-0646",{"$f":"集計表!H14&MID($C$3,6,2)&\" \"&\"月\"","v":"朝霞 駐車場代（かつみ不動産)09 月"}]
["",null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J15","v":351650},null,{"$f":"集計表!K15","v":25974},null,{"$f":"IF(集計表!L15=\"\",\"\",集計表!L15)","v":"AA"},null,{"$f":"集計表!M15","v":"NS-0614"},null,"NS-0614",{"$f":"集計表!H15&MID($C$3,6,2)&\" \"&\"月\"","v":"ふじみ野 駐車場代（谷澤総合ｺﾝｻﾙﾀﾝﾄ）09 月"}]
["",null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J16","v":351650},null,{"$f":"集計表!K16","v":8658},null,{"$f":"IF(集計表!L16=\"\",\"\",集計表!L16)","v":"AA"},null,{"$f":"集計表!M16","v":"NS-0733"},null,"NS-0733",{"$f":"集計表!H16&MID($C$3,6,2)&\" \"&\"月\"","v":"ふじみ野 駐車場代（谷澤総合ｺﾝｻﾙﾀﾝﾄ）09 月"}]
["",null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J17","v":351610},null,{"$f":"集計表!K17","v":473000},null,{"$f":"IF(集計表!L17=\"\",\"\",集計表!L17)","v":"AA"},null,{"$f":"集計表!M17","v":"NS-0614"},null,"NS-0614",{"$f":"集計表!H17&MID($C$3,6,2)&\" \"&\"月\"","v":"ふじみ野 事務所賃料（谷澤総合ｺﾝｻﾙﾀﾝﾄ）09 月"}]
[null,null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J18","v":"351610"},null,{"$f":"集計表!K18","v":101574},null,{"$f":"IF(集計表!L18=\"\",\"\",集計表!L18)","v":"AA"},null,{"$f":"集計表!M18","v":"NS-0621"},null,"NS-0621",{"$f":"集計表!H18&MID($C$3,6,2)&\" \"&\"月\"","v":"SP長岡ビル旧朝日生命　事務所賃借料09 月"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(K18<>0,\"40\",\"\")","v":"40"},{"$f":"集計表!J19","v":"351610"},null,{"$f":"集計表!K19","v":6600},null,{"$f":"IF(集計表!L19=\"\",\"\",集計表!L19)","v":"AA"},null,{"$f":"集計表!M19","v":"NS-0621"},null,{"$f":"Q18","v":"NS-0621"},{"$f":"集計表!H19&MID($C$3,6,2)&\" \"&\"月\"","v":"ステーションプラザ長岡ビル TR309 月"}]
[null,null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J20","v":"351650"},null,{"$f":"集計表!K20","v":17600},null,{"$f":"IF(集計表!L20=\"\",\"\",集計表!L20)","v":"AA"},null,{"$f":"集計表!M20","v":"NS-0623"},null,"NS-0623",{"$f":"集計表!H20&MID($C$3,6,2)&\" \"&\"月\"","v":"長岡営業所 駐車場代09 月"}]
[{"$f":"IF(AND(J16=\"40\",J20=\"\"),\"eof\",\"\")","v":""},null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J21","v":352900},null,{"$f":"集計表!K21","v":17380},null,{"$f":"IF(集計表!L21=\"\",\"\",集計表!L21)","v":"AA"},null,{"$f":"集計表!M21","v":"NS-0624"},null,"NS-0624",{"$f":"集計表!H21&MID($C$3,6,2)&\" \"&\"月\"","v":"セコム　事務所管理料09 月"}]
["",null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J22","v":"352900"},null,{"$f":"集計表!K22","v":2165900},null,{"$f":"IF(集計表!L22=\"\",\"\",集計表!L22)","v":"AA"},null,{"$f":"集計表!M22","v":"NS-0129"},null,"NS-0129",{"$f":"集計表!H22&MID($C$3,6,2)&\" \"&\"月\"","v":"半蔵門駅前ビル 清掃業務委託料09 月"}]
[null,null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J23","v":"351610"},null,{"$f":"集計表!K23","v":43795651},null,{"$f":"IF(集計表!L23=\"\",\"\",集計表!L23)","v":"AA"},null,{"$f":"集計表!M23","v":"NS-0129"},null,"半蔵門駅前ビル",{"$f":"集計表!H23&MID($C$3,6,2)&\" \"&\"月\"","v":"半蔵門駅前ビル 賃借料09 月"}]
[{"$f":"IF(AND(J21=\"40\",J23=\"\"),\"eof\",\"\")","v":""},null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J24","v":"351650"},null,{"$f":"集計表!K24","v":528000},null,{"$f":"IF(集計表!L24=\"\",\"\",集計表!L24)","v":"AA"},null,{"$f":"集計表!M24","v":"NS-0129"},null,"NS-0129",{"$f":"集計表!H24&MID($C$3,6,2)&\" \"&\"月\"","v":"半蔵門駅前ビル 駐車場代09 月"}]
[{"$f":"IF(AND(J22=\"40\",J24=\"\"),\"eof\",\"\")","v":""},null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J25","v":351650},null,{"$f":"集計表!K25","v":20000},null,{"$f":"IF(集計表!L25=\"\",\"\",集計表!L25)","v":"AA"},null,{"$f":"集計表!M25","v":"NS-0330"},null,"NS-0330",{"$f":"集計表!H25&MID($C$3,6,2)&\" \"&\"月\"","v":"山下ふ頭交通対策協議会駐車場代09 月"}]
["",null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J26","v":351610},null,{"$f":"集計表!K26","v":1667281},null,{"$f":"IF(集計表!L26=\"\",\"\",集計表!L26)","v":"AA"},null,{"$f":"集計表!M26","v":"NS-0325"},null,"NS-0325",{"$f":"集計表!H26&MID($C$3,6,2)&\" \"&\"月\"","v":"南本牧事務所賃借料09 月"}]
["",null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J27","v":351650},null,{"$f":"集計表!K27","v":88550},null,{"$f":"IF(集計表!L27=\"\",\"\",集計表!L27)","v":"AA"},null,{"$f":"集計表!M27","v":"NS-0325"},null,"NS-0325",{"$f":"集計表!H27&MID($C$3,6,2)&\" \"&\"月\"","v":"南本牧駐車場代09 月"}]
["",null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J28","v":351650},null,{"$f":"集計表!K28","v":24150},null,{"$f":"IF(集計表!L28=\"\",\"\",集計表!L28)","v":"AA"},null,{"$f":"集計表!M28","v":"NS-0101"},null,"NS-0101",{"$f":"集計表!H28&MID($C$3,6,2)&\" \"&\"月\"","v":"001　役員車駐車場代09 月"}]
["",null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J29","v":351650},null,{"$f":"集計表!K29","v":15000},null,{"$f":"IF(集計表!L29=\"\",\"\",集計表!L29)","v":"AA"},null,{"$f":"集計表!M29","v":"NS-0101"},null,"NS-0101",{"$f":"集計表!H29&MID($C$3,6,2)&\" \"&\"月\"","v":"002　役員車駐車場代09 月"}]
["",null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J30","v":351610},null,{"$f":"集計表!K30","v":135119},null,{"$f":"IF(集計表!L30=\"\",\"\",集計表!L30)","v":"AA"},null,{"$f":"集計表!M30","v":"NS-0804"},null,"NS-0804",{"$f":"集計表!H30&MID($C$3,6,2)&\" \"&\"月\"","v":"新千歳_事務所賃料09 月"}]
["",null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J31","v":351650},null,{"$f":"集計表!K31","v":26400},null,{"$f":"IF(集計表!L31=\"\",\"\",集計表!L31)","v":"AA"},null,{"$f":"集計表!M31","v":"NS-0804"},null,"NS-0804",{"$f":"集計表!H31&MID($C$3,6,2)&\" \"&\"月\"","v":"新千歳_駐車場09 月"}]
["",null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J32","v":352900},null,{"$f":"集計表!K32","v":2727},null,{"$f":"IF(集計表!L32=\"\",\"\",集計表!L32)","v":"AA"},null,{"$f":"集計表!M32","v":"NS-0804"},null,"NS-0804",{"$f":"集計表!H32&MID($C$3,6,2)&\" \"&\"月\"","v":"新千歳_清掃料09 月"}]
["",null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J33","v":351300},null,{"$f":"集計表!K33","v":8531},null,{"$f":"IF(集計表!L33=\"\",\"\",集計表!L33)","v":"AA"},null,{"$f":"集計表!M33","v":"NS-0804"},null,"NS-0804",{"$f":"集計表!H33&MID($C$3,6,2)&\" \"&\"月\"","v":"新千歳_電気料金09 月"}]
["",null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J34","v":351300},null,{"$f":"集計表!K34","v":909},null,{"$f":"IF(集計表!L34=\"\",\"\",集計表!L34)","v":"AA"},null,{"$f":"集計表!M34","v":"NS-0804"},null,"NS-0804",{"$f":"集計表!H34&MID($C$3,6,2)&\" \"&\"月\"","v":"新千歳_上下水道料金09 月"}]
["",null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J35","v":352900},null,{"$f":"集計表!K35","v":11000},null,{"$f":"IF(集計表!L35=\"\",\"\",集計表!L35)","v":"AA"},null,{"$f":"集計表!M35","v":"NS-0804"},null,"NS-0804",{"$f":"集計表!H35&MID($C$3,6,2)&\" \"&\"月\"","v":"新千歳_保管庫使用料09 月"}]
["",null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J36","v":351300},null,{"$f":"集計表!K36","v":0},null,{"$f":"IF(集計表!L36=\"\",\"\",集計表!L36)","v":"AA"},null,{"$f":"集計表!M36","v":"NS-0804"},null,"NS-0804",{"$f":"集計表!H36&MID($C$3,6,2)&\" \"&\"月\"","v":"新千歳_灯油代09 月"}]
["",null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J37","v":351610},null,{"$f":"集計表!K37","v":472202},null,{"$f":"IF(集計表!L37=\"\",\"\",集計表!L37)","v":"AA"},null,{"$f":"集計表!M37","v":"NS-0644"},null,"NS-0644",{"$f":"集計表!H37&MID($C$3,6,2)&\" \"&\"月\"","v":"東東京営業所　事務所賃借料09 月"}]
["",null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J38","v":352900},null,{"$f":"集計表!K38","v":171606},null,{"$f":"IF(集計表!L38=\"\",\"\",集計表!L38)","v":"AA"},null,{"$f":"集計表!M38","v":"NS-0644"},null,"NS-0644",{"$f":"集計表!H38&MID($C$3,6,2)&\" \"&\"月\"","v":"東東京営業所  (共益費+蛍光灯類代)09 月"}]
["",null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J39","v":"142102"},null,{"$f":"集計表!K39","v":472202},null,{"$f":"IF(集計表!L39=\"\",\"\",集計表!L39)","v":""},null,{"$f":"集計表!M39","v":"NS-0644"},null,"NS-0644",{"$f":"集計表!H39&MID($C$3,6,2)&\" \"&\"月\"","v":"東東京営業所　家賃09 月"}]
["",null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J40","v":351610},null,{"$f":"集計表!K40","v":330000},null,{"$f":"IF(集計表!L40=\"\",\"\",集計表!L40)","v":"AA"},null,{"$f":"集計表!M40","v":"NS-0647"},null,"NS-0647",{"$f":"集計表!H40&MID($C$3,6,2)&\" \"&\"月\"","v":"YAT事務所賃借料09 月"}]
["",null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J41","v":351650},null,{"$f":"集計表!K41","v":5000},null,{"$f":"IF(集計表!L41=\"\",\"\",集計表!L41)","v":"AA"},null,{"$f":"集計表!M41","v":"NS-0647"},null,"NS-0647",{"$f":"集計表!H41&MID($C$3,6,2)&\" \"&\"月\"","v":"山下埠頭駐車場代09 月"}]
["",null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J42","v":"351052"},null,{"$f":"集計表!K42","v":29150},null,{"$f":"IF(集計表!L42=\"\",\"\",集計表!L42)","v":"AA"},null,{"$f":"集計表!M42","v":"NS-0259"},null,"NS-0259",{"$f":"集計表!H42&MID($C$3,6,2)&\" \"&\"月\"","v":"駐車場代09 月"}]
["",null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J43","v":351650},null,{"$f":"集計表!K43","v":16500},null,{"$f":"IF(集計表!L43=\"\",\"\",集計表!L43)","v":"AA"},null,{"$f":"集計表!M43","v":"NS-0259"},null,"NS-0259",{"$f":"集計表!H43&MID($C$3,6,2)&\" \"&\"月\"","v":"駐車場代09 月"}]
["",null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J44","v":351610},null,{"$f":"集計表!K44","v":208890},null,{"$f":"IF(集計表!L44=\"\",\"\",集計表!L44)","v":"AA"},null,{"$f":"集計表!M44","v":"NS-0421"},null,"NS-0421",{"$f":"集計表!H44&MID($C$3,6,2)&\" \"&\"月\"","v":"川崎市電設工業会　事務所賃料代09 月"}]
["",null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J45","v":351650},null,{"$f":"集計表!K45","v":66000},null,{"$f":"IF(集計表!L45=\"\",\"\",集計表!L45)","v":"AA"},null,{"$f":"集計表!M45","v":"NS-0421"},null,"NS-0421",{"$f":"集計表!H45&MID($C$3,6,2)&\" \"&\"月\"","v":"川崎市電設工業会　駐車場代09 月"}]
["",null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J46","v":351610},null,{"$f":"集計表!K46","v":60291},null,{"$f":"IF(集計表!L46=\"\",\"\",集計表!L46)","v":"AA"},null,{"$f":"集計表!M46","v":"NS-0629"},null,"NS-0629",{"$f":"集計表!H46&MID($C$3,6,2)&\" \"&\"月\"","v":"事務所賃料（不二ロジカーゴ）09 月"}]
["",null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J47","v":351650},null,{"$f":"集計表!K47","v":28050},null,{"$f":"IF(集計表!L47=\"\",\"\",集計表!L47)","v":"AA"},null,{"$f":"集計表!M47","v":"NS-0629"},null,"NS-0629",{"$f":"集計表!H47&MID($C$3,6,2)&\" \"&\"月\"","v":"駐車場代（不二ロジカーゴ）09 月"}]
["",null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J48","v":352900},null,{"$f":"集計表!K48","v":11000},null,{"$f":"IF(集計表!L48=\"\",\"\",集計表!L48)","v":"AA"},null,{"$f":"集計表!M48","v":"NS-0629"},null,"NS-0629",{"$f":"集計表!H48&MID($C$3,6,2)&\" \"&\"月\"","v":"共益費等（不二ロジカーゴ）09 月"}]
["",null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J49","v":"351610"},null,{"$f":"集計表!K49","v":491018},null,{"$f":"IF(集計表!L49=\"\",\"\",集計表!L49)","v":"AA"},null,{"$f":"集計表!M49","v":"NS-0643"},null,"NS-0643",{"$f":"集計表!H49&MID($C$3,6,2)&\" \"&\"月\"","v":"新宿MOAビル 事務所賃借料09 月"}]
["",null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J50","v":"352900"},null,{"$f":"集計表!K50","v":89276},null,{"$f":"IF(集計表!L50=\"\",\"\",集計表!L50)","v":"AA"},null,{"$f":"集計表!M50","v":"NS-0643"},null,"NS-0643",{"$f":"集計表!H50&MID($C$3,6,2)&\" \"&\"月\"","v":"新宿MOAビル 共益費09 月"}]
["",null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J51","v":"351610"},null,{"$f":"集計表!K51","v":491018},null,{"$f":"IF(集計表!L51=\"\",\"\",集計表!L51)","v":"AA"},null,{"$f":"集計表!M51","v":"NS-0609"},null,"NS-0609",{"$f":"集計表!H51&MID($C$3,6,2)&\" \"&\"月\"","v":"新宿MOAビル 事務所賃借料09 月"}]
["",null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J52","v":"352900"},null,{"$f":"集計表!K52","v":89276},null,{"$f":"IF(集計表!L52=\"\",\"\",集計表!L52)","v":"AA"},null,{"$f":"集計表!M52","v":"NS-0609"},null,"NS-0609",{"$f":"集計表!H52&MID($C$3,6,2)&\" \"&\"月\"","v":"新宿MOAビル 共益費09 月"}]
["",null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J53","v":351650},null,{"$f":"集計表!K53","v":33000},null,{"$f":"IF(集計表!L53=\"\",\"\",集計表!L53)","v":"AA"},null,{"$f":"集計表!M53","v":"NS-0738"},null,"NS-0738",{"$f":"集計表!H53&MID($C$3,6,2)&\" \"&\"月\"","v":"2022/第74号 名古屋営業所駐車場09 月"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(K53<>0,\"40\",\"\")","v":"40"},{"$f":"集計表!J54","v":351650},null,{"$f":"集計表!K54","v":38500},null,{"$f":"IF(集計表!L54=\"\",\"\",集計表!L54)","v":"AA"},null,{"$f":"集計表!M54","v":"NS-0101"},null,{"$f":"Q53","v":"NS-0101"},{"$f":"集計表!H54&MID($C$3,6,2)&\" \"&\"月\"","v":"筒井専務車専用　駐車場代09 月"}]
[{"$f":"IF(AND(J52=\"40\",J54=\"\"),\"eof\",\"\")","v":""},null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J55","v":351650},null,{"$f":"集計表!K55","v":5000},null,{"$f":"IF(集計表!L55=\"\",\"\",集計表!L55)","v":"A0"},null,{"$f":"集計表!M55","v":"NS-0624"},null,"NS-0624",{"$f":"集計表!H55&MID($C$3,6,2)&\" \"&\"月\"","v":"駐車場代（中部ガス不動産）09 月"}]
[{"$f":"A3","v":"2023.09.30"},"NS",{"$f":"C3","v":"2023.09.30"},"SA","JPY",null,null,{"$f":"H3","v":"前払費用振替（単月）09月"},"×","40",{"$f":"集計表!J56","v":351610},null,{"$f":"集計表!K56","v":8192250},null,{"$f":"IF(集計表!L56=\"\",\"\",集計表!L56)","v":"AA"},null,{"$f":"集計表!M56","v":"NS-0129"},null,"NS-0129",{"$f":"集計表!H56&MID($C$3,6,2)&\" \"&\"月\"","v":"ニッセイビル　賃借料09 月"}]
[{"$f":"A3","v":"2023.09.30"},"NS",{"$f":"C3","v":"2023.09.30"},"SA","JPY",null,null,{"$f":"H3","v":"前払費用振替（単月）09月"},"×","40",{"$f":"集計表!J57","v":351610},null,{"$f":"集計表!K57","v":174550},null,{"$f":"IF(集計表!L57=\"\",\"\",集計表!L57)","v":"AA"},null,{"$f":"集計表!M57","v":"NS-0735"},null,"NS-0735",{"$f":"集計表!H57&MID($C$3,6,2)&\" \"&\"月\"","v":"愛知日新　事務所賃借料 09 月"}]
[{"$f":"IF(AND(J56=\"40\",J57=\"\"),\"eof\",\"\")","v":""},null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J58","v":351650},null,{"$f":"集計表!K58","v":33000},null,{"$f":"IF(集計表!L58=\"\",\"\",集計表!L58)","v":"AA"},null,{"$f":"集計表!M58","v":"NS-0735"},null,"NS-0735",{"$f":"集計表!H58&MID($C$3,6,2)&\" \"&\"月\"","v":"愛知日新　駐車場代 09 月"}]
[{"$f":"IF(AND(J57=\"40\",J58=\"\"),\"eof\",\"\")","v":""},null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J59","v":352900},null,{"$f":"集計表!K59","v":107415},null,{"$f":"IF(集計表!L59=\"\",\"\",集計表!L59)","v":"AA"},null,{"$f":"集計表!M59","v":"NS-0735"},null,"NS-0735",{"$f":"集計表!H59&MID($C$3,6,2)&\" \"&\"月\"","v":"愛知日新　共益費 09 月"}]
[{"$f":"IF(AND(J58=\"40\",J59=\"\"),\"eof\",\"\")","v":""},null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J60","v":351300},null,{"$f":"集計表!K60","v":26955},null,{"$f":"IF(集計表!L60=\"\",\"\",集計表!L60)","v":"AA"},null,{"$f":"集計表!M60","v":"NS-0735"},null,"NS-0735",{"$f":"集計表!H60&MID($C$3,6,2)&\" \"&\"月\"","v":"愛知日新　電気代 09 月"}]
[{"$f":"IF(AND(J59=\"40\",J60=\"\"),\"eof\",\"\")","v":""},null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J61","v":"351620"},null,{"$f":"集計表!K61","v":10841},null,{"$f":"IF(集計表!L61=\"\",\"\",集計表!L61)","v":"AA"},null,{"$f":"集計表!M61","v":"NS-0735"},null,"NS-0735",{"$f":"集計表!H61&MID($C$3,6,2)&\" \"&\"月\"","v":"愛知日新　カラー複合機リース代 09 月"}]
[null,null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J62","v":"351620"},null,{"$f":"集計表!K62","v":3218},null,{"$f":"IF(集計表!L62=\"\",\"\",集計表!L62)","v":"AA"},null,{"$f":"集計表!M62","v":"NS-0735"},null,"NS-0735",{"$f":"集計表!H62&MID($C$3,6,2)&\" \"&\"月\"","v":"愛知日新　シュレッダーリース代 09 月"}]
[null,null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J63","v":"351620"},null,{"$f":"集計表!K63","v":11568},null,{"$f":"IF(集計表!L63=\"\",\"\",集計表!L63)","v":"AA"},null,{"$f":"集計表!M63","v":"NS-0735"},null,"NS-0735",{"$f":"集計表!H63&MID($C$3,6,2)&\" \"&\"月\"","v":"愛知日新　電話機リース代 09 月"}]
[null,null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J64","v":"352130"},null,{"$f":"集計表!K64","v":1320},null,{"$f":"IF(集計表!L64=\"\",\"\",集計表!L64)","v":"AA"},null,{"$f":"集計表!M64","v":"NS-0735"},null,"NS-0735",{"$f":"集計表!H64&MID($C$3,6,2)&\" \"&\"月\"","v":"愛知日新 宅急便送料09 月"}]
[{"$f":"IF(AND(J60=\"40\",J64=\"\"),\"eof\",\"\")","v":""},null,null,null,null,null,null,null,null,"40",{"$f":"集計表!J65","v":"352430"},null,{"$f":"集計表!K65","v":41094},null,{"$f":"IF(集計表!L65=\"\",\"\",集計表!L65)","v":"AA"},null,{"$f":"集計表!M65","v":"NS-0735"},null,"NS-0735",{"$f":"集計表!H65&MID($C$3,6,2)&\" \"&\"月\"","v":"愛知日新　コピー代 09 月"}]
[{"$f":"A3","v":"2023.09.30"},"NS",{"$f":"C3","v":"2023.09.30"},"SA","JPY",null,null,{"$f":"H3","v":"前払費用振替（単月）09月"},"×","40",{"$f":"集計表!J66","v":351610},null,{"$f":"集計表!K66","v":297000},null,{"$f":"IF(集計表!L66=\"\",\"\",集計表!L66)","v":"AA"},null,{"$f":"集計表!M66","v":"NS-0427"},null,"NS-0427",{"$f":"集計表!H66&MID($C$3,6,2)&\" \"&\"月\"","v":"鶴見　事務所賃料09 月"}]
[{"$f":"A3","v":"2023.09.30"},"NS",{"$f":"C3","v":"2023.09.30"},"SA","JPY",null,null,{"$f":"H3","v":"前払費用振替（単月）09月"},"×",{"$f":"IF(K66<>0,\"40\",\"\")","v":"40"},{"$f":"集計表!J67","v":351610},null,{"$f":"集計表!K67","v":42350},null,{"$f":"IF(集計表!L67=\"\",\"\",集計表!L67)","v":"AA"},null,{"$f":"集計表!M67","v":"NS-0310"},null,{"$f":"Q66","v":"NS-0310"},{"$f":"集計表!H67&MID($C$3,6,2)&\" \"&\"月\"","v":"社用車駐車場使用料09 月"}]
["eof"]
[{"$f":"IF(AND(J67=40,J68=\"\"),\"eof\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"前払合計",{"$f":"SUM(M3:M65)","v":62206464}]
[{"$f":"IF(AND(J68=40,J69=\"\"),\"eof\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"集計表合計",{"$f":"SUM(集計表!F4:F66)","v":219880}]
[{"$f":"IF(AND(J69=40,J70=\"\"),\"eof\",\"\")","v":""}]
[]
[{"$f":"IF(AND(J71=40,J72=\"\"),\"eof\",\"\")","v":""}]

{"sheet":"BTIN","index":3,"n_rows":291,"n_cols":9,"rows_kept":291,"cut":false,"hidden":true,"merged":[]}
["識別","ﾌﾗｸﾞ","入力項目名","入力値","列","画面項目名",null,"INDEX"]
["P-01　",null,null,"一般勘定－明細",null,null,null,"P-01",3]
[2,null,"RF05A-NEWBS",null,"J","転記キー",null,"P-02",22]
[2,null,"RF05A-NEWKO",null,"K","勘定コード",null,"P-03",46]
[2,null,"BDC_OKCODE","/00",null,null,null,"P-04",67]
[1,"#","SAPLKACB","0002",null,null,null,"P-05",85]
[2,"#","BDC_OKCODE","/00",null,null,null,"P-06",108]
[1,null,"SAPMF05A","0300",null,null,null,"P-07",125]
[2,null,"BSEG-WRBTR",null,"M","金額",null,"P-08",142]
[2,null,"BSEG-DMBTR",null,"N","国内通貨額",null,"P-09",159]
[2,null,"BSEG-MWSKZ",null,"O","消費税コード",null,"P-10",181]
[2,null,"BSEG-VALUT",null,"U","起算日",null,"P-11",206]
[2,null,"BSEG-ZUONR",null,"S","ソートキー",null,"P-12",246]
[2,null,"BSEG-SGTXT",null,"T","明細テキスト",null,"P-13",261]
[2,null,"BDC_OKCODE","/00",null,null,null,"P-14",278]
[1,null,"SAPLKACB","0002"]
[2,null,"COBL-GSBER",null,"P","事業領域"]
[2,null,"BDC_OKCODE","/00"]
[1,null,"SAPMF05A","0300"]
["eof"]
["P-02　",null,null,"原価要素－明細"]
[2,null,"RF05A-NEWBS",null,"J","転記キー"]
[2,null,"RF05A-NEWKO",null,"K","勘定コード"]
[2,null,"BDC_OKCODE","/00"]
[1,"#","SAPLKACB","0002"]
[2,"#","BDC_OKCODE","/00"]
[1,null,"SAPMF05A","0300"]
[2,null,"BSEG-WRBTR",null,"M","金額"]
[2,null,"BSEG-DMBTR",null,"N","国内通貨額"]
[2,null,"BSEG-MWSKZ",null,"O","消費税コード"]
[2,null,"BSEG-ZUONR",null,"S","ソートキー"]
[2,null,"BSEG-SGTXT",null,"T","明細テキスト"]
[2,null,"BSEG-MENGE",null,"AC","数量"]
[2,null,"BSEG-MEINS",null,"AD","数量単位"]
[2,null,"BDC_OKCODE","/00"]
[1,null,"SAPLKACB","0002"]
[2,null,"COBL-GSBER",null,"P","事業領域"]
[2,null,"COBL-KOSTL",null,"Q","原価センタ"]
[2,null,"COBL-PRCTR",null,"R","利益センタ"]
[2,null,"COBL-AUFNR",null,"AE","指図書"]
[2,null,"COBL-PS_PSP_PNR",null,"AF","ＷＢＳ要素"]
[2,null,"BDC_OKCODE","/00"]
[1,null,"SAPMF05A","0300"]
["eof"]
["P-03",null,null,"棚卸資産－明細"]
[2,null,"RF05A-NEWBS",null,"J","転記キー"]
[2,null,"RF05A-NEWKO",null,"K","勘定コード"]
[2,null,"BDC_OKCODE","/00"]
[1,"#","SAPLKACB","0002"]
[2,"#","BDC_OKCODE","/00"]
[1,null,"SAPMF05A","0300"]
[2,null,"BSEG-WRBTR",null,"M","金額"]
[2,null,"BSEG-DMBTR",null,"N","国内通貨額"]
[2,null,"BSEG-MWSKZ",null,"O","消費税コード"]
[2,null,"BSEG-VALUT",null,"U","起算日"]
[2,null,"BSEG-ZUONR",null,"S","ソートキー"]
[2,null,"BSEG-SGTXT",null,"T","明細テキスト"]
[2,null,"BSEG-MENGE",null,"AC","数量"]
[2,null,"BSEG-MEINS",null,"AD","数量単位"]
[2,null,"BDC_OKCODE","/00"]
[1,null,"SAPLKACB","0002"]
[2,null,"COBL-GSBER",null,"P","事業領域"]
[2,null,"BDC_OKCODE","/00"]
[1,null,"SAPMF05A","0300"]
["eof"]
["P-04",null,null,"売掛金－明細"]
[2,null,"RF05A-NEWBS",null,"J","転記キー"]
[2,null,"RF05A-NEWKO",null,"K","勘定コード"]
[2,null,"BDC_OKCODE","/00"]
[1,"#","SAPLKACB","0002"]
[2,"#","BDC_OKCODE","/00"]
[1,null,"SAPMF05A","0301"]
[2,null,"BSEG-WRBTR",null,"M","金額"]
[2,null,"BSEG-DMBTR",null,"N","国内通貨額"]
[2,null,"BSEG-MWSKZ","**"]
[2,null,"BSEG-GSBER",null,"P","事業領域"]
[2,null,"BSEG-ZFBDT",null,"V","支払基準日"]
[2,null,"BSEG-ZLSCH",null,"X","支払方法"]
[2,"*","BSEG-ZTERM",null,null,"支払条件"]
[2,null,"BSEG-ZLSPR",null,"Y","支払保留"]
[2,null,"BSEG-ZUONR",null,"S","ソートキー"]
[2,null,"BSEG-SGTXT",null,"T","明細テキスト"]
["eof"]
["P-05",null,null,"買掛金－明細"]
[2,null,"RF05A-NEWBS",null,"J","転記キー"]
[2,null,"RF05A-NEWKO",null,"K","勘定コード"]
[2,null,"BDC_OKCODE","/00"]
[1,"#","SAPLKACB","0002"]
[2,"#","BDC_OKCODE","/00"]
[1,null,"SAPMF05A","0302"]
[2,null,"BSEG-WRBTR",null,"M","金額"]
[2,null,"BSEG-DMBTR",null,"N","国内通貨額"]
[2,null,"BSEG-MWSKZ","**"]
[2,null,"BSEG-GSBER",null,"P","事業領域"]
[2,null,"BSEG-ZFBDT",null,"V","支払基準日"]
[2,null,"BSEG-ZLSCH",null,"X","支払方法"]
[2,"*","BSEG-ZTERM",null,null,"支払条件"]
[2,null,"BSEG-ZLSPR",null,"Y","支払保留"]
[2,null,"BSEG-ZUONR",null,"S","ソートキー"]
[2,null,"BSEG-SGTXT",null,"T","明細テキスト"]
[2,null,"BDC_OKCODE","/07"]
[1,null,"SAPMF05A","0332"]
[2,null,"BSEG-BVTYP",null,"Z","取引先銀行"]
[2,null,"BSEG-HBKID",null,"AA","取引銀行"]
[2,null,"BSEG-LZBKZ",null,"AB","中央銀行CD"]
["eof"]
["P-06",null,null,"受取手形－明細"]
[2,null,"RF05A-NEWBS",null,"J","転記キー"]
[2,null,"RF05A-NEWKO",null,"K","勘定コード"]
[2,null,"RF05A-NEWUM",null,"L","特殊G/L"]
[2,null,"BDC_OKCODE","/00"]
[1,"#","SAPLKACB","0002"]
[2,"#","BDC_OKCODE","/00"]
[1,null,"SAPMF05A","2320"]
[2,null,"BSEG-WRBTR",null,"M","金額"]
[2,null,"BSEG-DMBTR",null,"N","国内通貨額"]
[2,null,"BSEG-GSBER",null,"P","事業領域"]
[2,null,"BSEG-ZUONR",null,"S","ソートキー"]
[2,null,"BSEG-SGTXT",null,"T","明細テキスト"]
[2,null,"BSEG-ZFBDT",null,"V","期日"]
[2,null,"BSED-WDATE",null,"W","振出日"]
[2,null,"BSEG-ZLSCH",null,"X","支払方法"]
["eof"]
["P-07",null,null,"支払手形－明細"]
[2,null,"RF05A-NEWBS",null,"J","転記キー"]
[2,null,"RF05A-NEWKO",null,"K","勘定コード"]
[2,null,"RF05A-NEWUM",null,"L","特殊G/L"]
[2,null,"BDC_OKCODE","/00"]
[1,"#","SAPLKACB","0002"]
[2,"#","BDC_OKCODE","/00"]
[1,null,"SAPMF05A","2320"]
[2,null,"BSEG-WRBTR",null,"M","金額"]
[2,null,"BSEG-DMBTR",null,"N","国内通貨額"]
[2,null,"BSEG-GSBER",null,"P","事業領域"]
[2,null,"BSEG-ZUONR",null,"S","ソートキー"]
[2,null,"BSEG-SGTXT",null,"T","明細テキスト"]
[2,null,"BSEG-ZFBDT",null,"V","期日"]
[2,null,"BSED-WDATE",null,"W","振出日"]
[2,null,"BSEG-ZLSCH",null,"X","支払方法"]
["eof"]
["P-08",null,null,"得意先(特殊仕訳)－明細"]
[2,null,"RF05A-NEWBS",null,"J","転記キー"]
[2,null,"RF05A-NEWKO",null,"K","勘定コード"]
[2,null,"RF05A-NEWUM",null,"L","特殊G/L"]
[2,null,"BDC_OKCODE","/00"]
[1,"#","SAPLKACB","0002"]
[2,"#","BDC_OKCODE","/00"]
[1,null,"SAPMF05A","0303"]
[2,null,"BSEG-WRBTR",null,"M","金額"]
[2,null,"BSEG-DMBTR",null,"N","国内通貨額"]
[2,null,"BSEG-GSBER",null,"P","事業領域"]
[2,null,"BSEG-ZFBDT",null,"V","期日"]
[2,null,"BSEG-ZLSCH",null,"X","支払方法"]
[2,null,"BSEG-ZLSPR",null,"Y","支払保留"]
[2,null,"BSEG-ZUONR",null,"S","ソートキー"]
[2,null,"BSEG-SGTXT",null,"T","明細テキスト"]
["eof"]
["P-09",null,null,"仕入先(特殊仕訳)－明細"]
[2,null,"RF05A-NEWBS",null,"J","転記キー"]
[2,null,"RF05A-NEWKO",null,"K","勘定コード"]
[2,null,"RF05A-NEWUM",null,"L","特殊G/L"]
[2,null,"BDC_OKCODE","/00"]
[1,"#","SAPLKACB","0002"]
[2,"#","BDC_OKCODE","/00"]
[1,null,"SAPMF05A","0303"]
[2,null,"BSEG-WRBTR",null,"M","金額"]
[2,null,"BSEG-DMBTR",null,"N","国内通貨額"]
[2,null,"BSEG-GSBER",null,"P","事業領域"]
[2,null,"BSEG-ZFBDT",null,"V","期日"]
[2,null,"BSEG-ZLSCH",null,"X","支払方法"]
[2,null,"BSEG-ZLSPR",null,"Y","支払保留"]
[2,null,"BSEG-ZUONR",null,"S","ソートキー"]
[2,null,"BSEG-SGTXT",null,"T","明細テキスト"]
[2,null,"BDC_OKCODE","/07"]
[1,null,"SAPMF05A","0332"]
[2,null,"BSEG-BVTYP",null,"Z","取引先銀行"]
[2,null,"BSEG-HBKID",null,"AA","取引銀行"]
[2,null,"BSEG-LZBKZ",null,"AB","中央銀行CD"]
["eof"]
["P-10",null,null,"収益・費用－明細"]
[2,null,"RF05A-NEWBS",null,"J","転記キー"]
[2,null,"RF05A-NEWKO",null,"K","勘定コード"]
[2,null,"BDC_OKCODE","/00"]
[1,"#","SAPLKACB","0002"]
[2,"#","BDC_OKCODE","/00"]
[1,null,"SAPMF05A","0300"]
[2,null,"BSEG-WRBTR",null,"M","金額"]
[2,null,"BSEG-DMBTR",null,"N","国内通貨額"]
[2,null,"BSEG-MWSKZ",null,"O","消費税コード"]
[2,null,"BSEG-VALUT",null,"U","起算日"]
[2,null,"BSEG-ZUONR",null,"S","ソートキー"]
[2,null,"BSEG-SGTXT",null,"T","明細テキスト"]
[2,null,"BSEG-MENGE",null,"AC","数量"]
[2,null,"BSEG-MEINS",null,"AD","数量単位"]
[2,null,"BDC_OKCODE","/00"]
[1,null,"SAPLKACB","0002"]
[2,null,"COBL-GSBER",null,"P","事業領域"]
[2,null,"COBL-KOSTL",null,"Q","原価センタ"]
[2,null,"COBL-PRCTR",null,"R","利益センタ"]
[2,null,"COBL-AUFNR",null,"AE","指図書"]
[2,null,"COBL-PS_PSP_PNR",null,"AF","ＷＢＳ要素"]
[2,null,"BDC_OKCODE","/00"]
[1,null,"SAPMF05A","0300"]
["eof"]
["P-11",null,null,"売上・販売直接費－明細(収益性分析）"]
[2,null,"RF05A-NEWBS",null,"J","転記キー"]
[2,null,"RF05A-NEWKO",null,"K","勘定コード"]
[2,null,"BDC_OKCODE","/00"]
[1,"#","SAPLKACB","0002"]
[2,"#","BDC_OKCODE","/00"]
[1,null,"SAPMF05A","0300"]
[2,null,"BSEG-WRBTR",null,"M","金額"]
[2,null,"BSEG-DMBTR",null,"N","国内通貨額"]
[2,null,"BSEG-MWSKZ",null,"O","消費税コード"]
[2,null,"BSEG-ZUONR",null,"S","ソートキー"]
[2,null,"BSEG-SGTXT",null,"T","明細テキスト"]
[2,null,"BSEG-MENGE",null,"AC","数量"]
[2,null,"BSEG-MEINS",null,"AD","数量単位"]
[2,null,"BDC_OKCODE","/00"]
[1,null,"SAPLKACB","0002"]
[2,null,"COBL-GSBER",null,"P","事業領域"]
[2,null,"COBL-KOSTL",null,"Q","原価センタ"]
[2,null,"COBL-PRCTR",null,"R","利益センタ"]
[2,null,"COBL-AUFNR",null,"AE","指図書"]
[2,null,"COBL-PS_PSP_PNR",null,"AF","ＷＢＳ要素"]
[2,null,"DKACB-XERGO","X",null,"詳細"]
[2,null,"BDC_OKCODE","/00"]
[1,null,"SAPLKEAK","0300"]
[2,null,"RKEAK-FIELD(1)",null,"AG","得意先コード"]
[2,null,"RKEAK-FIELD(2)",null,"AH","品目コード"]
[2,null,"RKEAK-FIELD(6)",null,"AI","販売組織"]
[2,null,"RKEAK-FIELD(7)",null,"AJ","流通チャネル"]
[2,null,"RKEAK-FIELD(8)",null,"AK","製品部門"]
[2,null,"RKEAK-FIELD(15)",null,"AL","品目ｸﾞﾙｰﾌﾟ"]
[2,null,"BDC_OKCODE","P+"]
[1,null,"SAPLKEAK","0300"]
[2,null,"RKEAK-FIELD(2)",null,"AM","営業所"]
[2,null,"RKEAK-FIELD(3)",null,"AN","営業グループ"]
[2,null,"BDC_OKCODE","P+"]
[1,null,"SAPLKEAK","0300"]
[2,null,"RKEAK-FIELD(11)",null,"AO","需要家"]
[2,null,"BDC_OKCODE","WEIT"]
[1,null,"SAPMF05A","0300"]
["eof"]
["P-12",null,null,"消費税－明細"]
[2,null,"RF05A-NEWBS",null,"J","転記キー"]
[2,null,"RF05A-NEWKO",null,"K","勘定コード"]
[2,null,"BDC_OKCODE","/00"]
[1,"#","SAPLKACB","0002"]
[2,"#","BDC_OKCODE","/00"]
[1,null,"SAPMF05A","0312"]
[2,null,"BSEG-WRBTR",null,"M","金額"]
[2,null,"BSEG-DMBTR",null,"N","国内通貨額"]
[2,null,"RF05A-XSTBA","X",null,"課税基準額決定"]
[2,null,"BSEG-MWSKZ",null,"O","消費税コード"]
[2,null,"BSEG-GSBER",null,"P","事業領域"]
[2,null,"BSEG-ZUONR",null,"S","ソートキー"]
[2,null,"BSEG-SGTXT",null,"T","明細テキスト"]
["eof"]
["P-13",null,null,"得意先(特殊仕訳:前受金･借方)－明細"]
[2,null,"RF05A-NEWBS",null,"J","転記キー"]
[2,null,"RF05A-NEWKO",null,"K","勘定コード"]
[2,null,"RF05A-NEWUM",null,"L","特殊G/L"]
[2,null,"BDC_OKCODE","/00"]
[1,"#","SAPLKACB","0002"]
[2,"#","BDC_OKCODE","/00"]
[1,null,"SAPMF05A","0304"]
[2,null,"BSEG-WRBTR",null,"M","金額"]
[2,null,"BSEG-DMBTR",null,"N","国内通貨額"]
[2,null,"BSEG-GSBER",null,"P","事業領域"]
[2,null,"BSEG-ZFBDT",null,"V","期日"]
[2,null,"BSEG-ZLSCH",null,"X","支払方法"]
[2,null,"BSEG-ZLSPR",null,"Y","支払保留"]
[2,null,"BSEG-ZUONR",null,"S","ソートキー"]
[2,null,"BSEG-SGTXT",null,"T","明細テキスト"]
["eof"]
["P-14",null,null,"得意先(特殊仕訳:前受金･貸方)－明細"]
[2,null,"RF05A-NEWBS",null,"J","転記キー"]
[2,null,"RF05A-NEWKO",null,"K","勘定コード"]
[2,null,"RF05A-NEWUM",null,"L","特殊G/L"]
[2,null,"BDC_OKCODE","/00"]
[1,"#","SAPLKACB","0002"]
[2,"#","BDC_OKCODE","/00"]
[1,null,"SAPMF05A","0304"]
[2,null,"BSEG-WRBTR",null,"M","金額"]
[2,null,"BSEG-DMBTR",null,"N","国内通貨額"]
[2,null,"BSEG-GSBER",null,"P","事業領域"]
[2,null,"BSEG-ZFBDT",null,"V","期日"]
[2,null,"BSEG-ZUONR",null,"S","ソートキー"]
[2,null,"BSEG-SGTXT",null,"T","明細テキスト"]
["eof"]

{"sheet":"TBL","index":4,"n_rows":58,"n_cols":50,"rows_kept":58,"cut":false,"hidden":true,"merged":[]}
["勘定","行",null,"転記ｷｰ","ﾀｲﾌﾟ","特殊","勘定(開始)","勘定(終了)","ﾊﾟﾀｰﾝ","勘定名",null,null,null,"転記ｷｰ","ﾀｲﾌﾟ","特殊","勘定(開始)","勘定(終了)","ﾊﾟﾀｰﾝ","勘定名",null,null,null,"転記ｷｰ","ﾀｲﾌﾟ","特殊","勘定(開始)","勘定(終了)","ﾊﾟﾀｰﾝ","勘定名",null,null,null,"転記ｷｰ","ﾀｲﾌﾟ","特殊","勘定(開始)","勘定(終了)","ﾊﾟﾀｰﾝ","勘定名",null,null,null,"転記ｷｰ","ﾀｲﾌﾟ","特殊","勘定(開始)","勘定(終了)","ﾊﾟﾀｰﾝ","勘定名"]
[1,2,19,"40/50","Ｓ",null,100010,109999,"P-01"," 現金／預金",null,null,null,"09/19","Ｄ","W",112110,112119,"P-06"," 受取手形",null,null,null,"29/39","Ｋ","W",411100,411100,"P-07"," 支払手形",null,null,null,"21/31","K",null,"412100",412109,"P-05"," 買掛金",null,null,null,"01/11","D",null,"113100",113199,"P-04"," 売掛金"]
[2,20,24,"40/50","Ｓ",null,113999,113999,"P-01"," 売掛金-調整",null,null,null,"09/19","Ｄ","M",145100,145100,"P-08"," 未収入金",null,null,null,"29/39","Ｋ","N",414100,414100,"P-09"," 未払金",null,null,null,"21/31","K",null,415100,415100,"P-09"," 未払費用",null,null,null,"01/11","D",null,113200,113200,"P-04"," 社内売掛金"]
[3,25,28,"40/50","Ｓ",null,"114000",116099,"P-01"," 有価証券／自己株式／預け金",null,null,null,"09/19","Ｄ","X",147101,147101,"P-08"," 営業立替金",null,null,null,"29/39","Ｋ","Q",414300,414300,"P-09"," 未払金（有形固定資産）",null,null,null,"eof",null,null,null,null,null,null,null,null,null,"eof"]
[4,29,39,"40/50","Ｓ",null,"121100",127900,"P-03"," 棚卸資産",null,null,null,"09/19","Ｄ","R",147105,147105,"P-08"," 代理店勘定（債権)",null,null,null,"29/39","Ｋ","R",414400,414400,"P-09"," 未払金（無形固定資産）"]
["5",40,41,"40/50","Ｓ",null,135000,140199,"P-02"," 未成工事",null,null,null,"09/19","Ｄ","S",147107,147107,"P-08"," 海外代理店勘定(債権)",null,null,null,"29/39","Ｋ","K",415100,415100,"P-09"," 未払費用"]
["7",42,43,"40/50","Ｓ",null,"141101",141199,"P-01"," 前渡金",null,null,null,"09/19","Ｄ","T",147109,147109,"P-08"," 関係会社立替金",null,null,null,"29/39","Ｋ","U",418305,418305,"P-09"," 代理店勘定預り金"]
[8,44,51,"40/50","Ｓ",null,"142101",142199,"P-01"," 前払費用",null,null,null,"09/19","Ｄ","Q",411910,411919,"P-08"," 割引手形",null,null,null,"29/39","Ｋ","Y",418307,418307,"P-09"," 海外代理店勘定（債務）"]
["9",52,53,"40/50","Ｓ",null,144100,144199,"P-01"," 短期貸付金",null,null,null,"09/19","Ｄ","U",411920,411929,"P-08"," 譲渡手形",null,null,null,"29/39","Ｋ","V",441011,441011,"P-09"," 仮受金－運賃（特定）"]
["eof",null,null,"40/50","Ｓ",null,145110,145199,"P-01"," 未収入金",null,null,null,"09/19","Ｄ","A","416100","416100","P-13"," 前受金",null,null,null,"eof"]
[null,null,null,"40/50","Ｓ",null,146100,146199,"P-01"," 前渡金",null,null,null,"09/19","Ｄ","C","441000","441000","P-13"," 仮受金-仮受売掛"]
[null,null,null,"40/50","Ｓ",null,147100,147199,"P-01"," 社内立替金",null,null,null,"eof"]
[null,null,null,"40/50","Ｓ",null,147200,147299,"P-01"," 関係会社立替金"]
[null,null,null,"40/50","Ｓ",null,148100,148199,"P-01"," 仮払金"]
[null,null,null,"40/50","Ｓ",null,"148200",148209,"P-12"," 仮払消費税"]
[null,null,null,"40/50","Ｓ",null,"148210","148210","P-01"," 輸入消費税"]
[null,null,null,"40/50","Ｓ",null,"148220",148399,"P-01"," 仮払法人税／仮払利子割"]
[null,null,null,"40/50","Ｓ",null,148500,170999,"P-01"," 立替金／引当金等"]
[]
[null,null,null,"40/50","Ｓ",null,227000,241500,"P-02"," 建設仮勘定"]
[null,null,null,"40/50","Ｓ",null,"261100",262999,"P-01"," 投資有価証券／株式／出資金"]
[null,null,null,"40/50","Ｓ",null,"263500",271099,"P-01"," 長期貸付金(他）"]
[null,null,null,"40/50","Ｓ",null,"281000",292999,"P-01"," 長期前払費用／貸倒引当金"]
[]
[null,null,null,"40/50","Ｓ",null,351000,359999,"P-02"," 生産原価"]
[null,null,null,"40/50","Ｓ",null,361000,361000,"P-02"," 仕入原価"]
[null,null,null,"40/50","Ｓ",null,372001,386400,"P-01"," 事業部勘定勘定"]
[]
[null,null,null,"40/50","Ｓ",null,412999,412999,"P-01"," 買掛金-調整"]
[null,null,null,"40/50","Ｓ",null,"413100",413699,"P-01"," 短期/長期借入金"]
[null,null,null,"40/50","Ｓ",null,414101,415299,"P-01"," 未払金"]
[null,null,null,"40/50","Ｓ",null,416199,416199,"P-01"," 前受金-調整"]
[null,null,null,"40/50","Ｓ",null,"417100",418399,"P-01"," 諸預り金"]
[null,null,null,"40/50","Ｓ",null,"422100",422199,"P-12"," 仮受消費税"]
[null,null,null,"40/50","Ｓ",null,422300,422599,"P-01"," その他流動負債"]
[null,null,null,"40/50","Ｓ",null,441001,441099,"P-01"," 仮受金"]
[null,null,null,"40/50","Ｓ",null,462100,462199,"P-01"," 原価仮勘定"]
[null,null,null,"40/50","Ｓ",null,499000,499000,"P-01"," 在庫初期化"]
[]
[null,null,null,"40/50","Ｓ",null,510000,599999,"P-01"," 長期借入金・引当金関係"]
[]
[null,null,null,"40/50","Ｓ",null,700000,7999999,"P-01"," 資本金"]
[]
[null,null,null,"40/50","Ｓ",null,811100,812999,"P-11"," 売上"]
[null,null,null,"40/50","Ｓ",null,820000,823999,"P-01"," 原価"]
[null,null,null,"40/50","Ｓ",null,824100,827999,"P-02"," 一般管理費"]
[null,null,null,"40/50","Ｓ",null,861000,878399,"P-10"," 受取利息／営業収益／特別利益"]
[null,null,null,"40/50","Ｓ",null,881000,882999,"P-02","支払利息／借入金利息／社債利息"]
[null,null,null,"40/50","Ｓ",null,883400,883599,"P-02"," 原価差額"]
[null,null,null,"40/50","Ｓ",null,884000,886999,"P-02"," 営業外費用／特別損失"]
[]
[null,null,null,"40/50","Ｓ",null,980000,9999999,"P-01"," 税その他"]
[]
[null,null,null,"eof"]
[null,null,null,"　※タイプ(勘定ﾀｲﾌﾟ）・・・Ｓ：勘定コード，Ｄ：得意先コード，Ｋ：仕入先コード"]
[]
["勘定：勘定の最初の一桁"]
["行：開始行"]

{"sheet":"入力","index":5,"n_rows":46,"n_cols":7,"rows_kept":46,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[null,"セル","項 目 名 称","分　　　類","項 目 名",null,"備　　　　　　考"]
[null,"Ａ列"," 伝票日付","　ヘッダ部","BLDAT"]
[null,"Ｂ列"," 会社コード",null,"BUKRS"]
[null,"Ｃ列"," 転記日付",null,"BUDAT"]
[null,"Ｄ列"," 伝票タイプ",null,"BLART"]
[null,"Ｅ列"," 通貨コード",null,"WAERS"]
[null,"Ｆ列"," 換算レート",null,"KURSF"]
[null,"Ｇ列"," 参照伝票番号",null,"XBLNR"]
[null,"Ｈ列"," ヘッダテキスト",null,"BKTXT"]
[null,"Ｉ列"," 税自動計算",null,"XMWST"]
[null,"Ｊ列"," 転記キー","　明細部","NEWBS"]
[null,"Ｋ列"," 勘定",null,"NEWKO"]
[null,"Ｌ列"," 特殊Ｇ／Ｌ",null,"NEWUM"]
[null,"Ｍ列"," 金額",null,"WRBTR"]
[null,"Ｎ列"," 国内通貨額",null,"DMBTR"]
[null,"Ｏ列"," 消費税コード",null,"MWSKZ"]
[null,"Ｐ列"," ソートキー",null,"ZUONR"]
[null,"Ｑ列"," 明細テキスト",null,"SGTXT"]
[null,"Ｒ列"," 起算日",null,"VALUT"]
[null,"Ｓ列"," 期日",null,"ZFBDT"]
[null,"Ｔ列"," 振出日",null,"WDATE"]
[null,"Ｕ列"," 支払方法",null,"ZLSCH"]
[null,"Ｖ列"," 支払保留",null,"ZLSPR"]
[null,"Ｗ列"," 取引先銀行",null,"BVTYP"]
[null,"Ｘ列"," 取引銀行",null,"HBKID"]
[null,"Ｙ列"," 中央銀行コード",null,"LZBKZ"]
[null,"Ｚ列"," 数量",null,"MENGE"]
[null,"AA列"," 数量単位",null,"MEINS"]
[null,"AB列"," 事業領域",null,"GSBER"]
[null,"AC列"," 原価センタ",null,"KOSTL"]
[null,"AD列"," 利益センタ",null,"PRCTR"]
[null,"AE列"," 指図書",null,"AUFNR"]
[null,"AF列"," ＷＢＳ",null,"PS_PSP_PNR"]
[null,"AG列"," 得意先コード",null,"RKEAK-FIELD1"]
[null,"AH列"," 品目コード",null,"RKEAK-FIELD2"]
[null,"AI列"," 販売組織",null,"RKEAK-FIELD6"]
[null,"AJ列"," 流通チャネル",null,"RKEAK-FIELD7"]
[null,"AK列","製品部門",null,"RKEAK-FIELD8"]
[null,"AL列","品目ｸﾞﾙｰﾌﾟ",null,"RKEAK-FIELD9"]
[null,"AM列","営業所",null,"RKEAK-FIELD2"]
[null,"AN列","営業グループ",null,"RKEAK-FIELD3"]
[null,"AO列","需要家",null,"RKEAK-FIELD2"]