{"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":2,"comments":0,"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":"DEN","index":1,"n_rows":11,"n_cols":41,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,null,"X","　←　“X”を入力し、バッチインプットの処理モードを“E”で実行すると伝票概要画面で止まり、確認することが出来る"]
["伝票日付","会社","転記日付","伝票ﾀｲﾌﾟ","通貨ｺｰﾄﾞ","換算ﾚｰﾄ","参照伝票番号","ﾍｯﾀﾞﾃｷｽﾄ","税自動計算","転記ｷｰ","勘定コード","特殊GL","金額","国内通貨額","税ｺｰﾄﾞ","事業領域","原価ｾﾝﾀ","利益ｾﾝﾀ","ソートキー","明細テキスト","起算日","期日","振出日","支払方法","支払保留","取引先銀行","取引銀行","中央銀行CD","数量","数量単位","指図書","ＷＢＳ","得意先ｺｰﾄﾞ","品目ｺｰﾄﾞ","販売組織","流通ﾁｬﾈﾙ","製品部門","品目ｸﾞﾙｰﾌﾟ","営業所","営業グループ","需要家"]
[{"$f":"TEXT(TODAY(),\"yyyymmdd\")","v":"20210707"},"NS",{"$f":"入力シート!$L$2","v":20210630},"AB","JPY",null,null,"0427 収支訂正","X","01",{"$f":"\"NS-\"&入力シート!B5","v":"NS-00ML10"},null,{"$f":"SUM(M4:M6)","v":0},null,null,"NS03",null,null,"0427 収支訂正","部課0427 収支訂正"]
[null,null,null,null,null,null,null,null,null,"50",811150,null,{"$f":"入力シート!L5","v":0},null,"UA","NS03",null,"NS-0427",{"$f":"IF(入力シート!K5<>\"\",入力シート!K5,\"\")","v":""},"0427 収支訂正"]
[null,null,null,null,null,null,null,null,null,"50",811150,null,{"$f":"入力シート!L6","v":0},null,"UA","NS03",null,"NS-0427",{"$f":"IF(入力シート!K6<>\"\",入力シート!K6,\"\")","v":""},"0427 収支訂正"]
[null,null,null,null,null,null,null,null,null,"50",811150,null,{"$f":"入力シート!L7","v":0},null,"UA","NS03",null,"NS-0427",{"$f":"IF(入力シート!K7<>\"\",入力シート!K7,\"\")","v":""},"0427 収支訂正"]
[{"$f":"TEXT(TODAY(),\"yyyymmdd\")","v":"20210707"},"NS",{"$f":"入力シート!$L$2","v":20210630},"AB","JPY",null,null,"0427 収支訂正","X","01",{"$f":"\"NS-\"&入力シート!B14","v":"NS-00ML10"},null,{"$f":"SUM(M8:M8)","v":20058733},null,null,"NS03",null,null,"0427 収支訂正","部課0427 収支訂正"]
[null,null,null,null,null,null,null,null,null,"50",811150,null,{"$f":"入力シート!L14","v":20058733},null,"UA","NS03",null,"NS-0427",{"$f":"入力シート!K14","v":"042710777706"},"0427 収支訂正"]
[null,null,null,null,null,null,null,null,null,"31",{"$f":"\"NS-\"&入力シート!F20","v":"NS-009937"},null,{"$f":"M10","v":20058733},null,null,"NS03",null,null,"0427 収支訂正","部課0427 収支訂正"]
[null,null,null,null,null,null,null,null,null,"40",351050,null,{"$f":"入力シート!L20","v":20058733},null,"AA","NS03","NS-0427",null,{"$f":"入力シート!K20","v":"H21070006014 "},"0427 収支訂正"]
["eof"]

{"sheet":"入力シート","index":2,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,"月次",20210630]
[]
["①売上のみ",null,"借方",null,null,null,"貸方",null,null,null,"請求書NO","税込金額"]
[null,"00ML10","ENEOS㈱",{"$f":"L8","v":0},null,811150,"売上-陸運（社有車）",{"$f":"L5/1.08","v":0},"U8",null,null,0]
[null,null,null,null,null,811150,"売上-陸運（社有車）",{"$f":"L6/1.08","v":0},"U8",null,null,0]
[null,null,null,null,null,811150,"売上-陸運（社有車）",{"$f":"L7/1.08","v":0},"U8",null,null,0]
[null,null,null,null,null,422100,"仮受消費税",{"$f":"SUM(H5:H7)*0.08","v":0},null,null,null,{"$f":"SUM(L5:L7)","v":0}]
[null,null,null,{"$f":"D5","v":0},null,null,null,{"$f":"SUM(H5:H8)","v":0},null,{"$f":"IF(D9=H9,\"OK\",\"NG\")","v":"OK"}]
[]
[]
[]
["②売上・原価",null,"借方",null,null,null,"貸方",null,null,null,"請求書NO","税込金額"]
[null,"00ML10","ENEOS㈱",{"$f":"L14","v":20058733},null,811150,"売上-陸運（社有車）",{"$f":"L14/1.1","v":18235211.818181816},null,null,"042710777706",20058733]
[null,null,null,null,null,422100,"仮受消費税",{"$f":"SUM(H14:H14)*0.1","v":1823521.1818181816},null,null,null,{"$f":"SUM(L14:L14)","v":20058733}]
[null,null,null,{"$f":"SUM(D14:D14)","v":20058733},null,null,null,{"$f":"SUM(H14:H15)","v":20058733},null,{"$f":"IF(D16=H16,\"OK\",\"NG\")","v":"OK"}]
[]
[]
[null,null,"借方",null,null,null,"貸方",null,null,null,"依頼NO","税込金額"]
[null,351050,"売上原価-陸運（社有車）",{"$f":"L21/1.1","v":18235211.818181816},null,"009937","㈱エヌ・ディ・ティ",{"$f":"L21","v":20058733},null,null,"H21070006014 ",20058733]
[null,148200,"仮払消費税",{"$f":"D20*0.1","v":1823521.1818181816},null,null,null,null,null,null,null,{"$f":"SUM(L20:L20)","v":20058733}]
[null,null,null,{"$f":"SUM(D20:D21)","v":20058733},null,null,null,{"$f":"SUM(H20:H21)","v":20058733},null,{"$f":"IF(D22=H22,\"OK\",\"NG\")","v":"OK"}]

{"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"]