{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["利用方法","項目定義","サンプル例","請求情報アップロードファイル作成"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":0,"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":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"項目定義","index":1,"n_rows":82,"n_cols":3,"rows_kept":82,"cut":false,"hidden":false,"merged":[[21,2,33,2],[9,0,10,0],[9,1,10,1],[44,0,45,0],[44,1,45,1],[4,0,5,0],[4,1,5,1],[7,0,8,0],[7,1,8,1],[57,0,58,0],[57,1,58,1]]}
[null,null,"注：項目名に(　)が付いているものは、入力・変更してアップロードを行っても反映されません。※印は、必須項目です。"]
[null,"項目名","内容\n注意）0で始まるコードの場合、CSVファイルをExcel形式で開くと頭の0が表示されません。\nアップロードする際に0を入力し、正しいコードとなるようにしてください。"]
["A","※ ファイルID","固定値"]
["B","※ ETF_MOTO_SEIKYU","固定値"]
["A2","※ 更新種別","更新種別"]
[null,null,"C:追加、U:変更、D:削除"]
["B2","※ 区分","区分（H:請求情報　D:請求明細情報）"]
["C2","※ 請求番号","請求番号（任意のコード半角英数のみ、30桁以内）"]
[null,null,"※C:追加として利用する場合、すでに登録済の請求番号を登録することはできません。"]
["D2"," ステータス","ステータス（“10”:一時保存　“30”:提出 “50”:確定）"]
[null,null,"※どのステータスを入力しても、一時保存で登録されます。"]
["E2","※ 請求対象年月","請求対象年月"]
["F2","※ 派遣先企業コード","半角英数のみ、5桁　※派遣先企業コードは、HRstation契約検索メニュー_請求管理メニュー_請求登録画面の派遣先会社虫眼鏡ボタンより検索し確認してください。"]
["G2"," 派遣先会社名","半角カナ以外、24文字以内　※ダウンロードしたデータを流用する場合、略町名が表示されます。必要に応じて変更してください。"]
["H2","※ 送付先事業所コード","半角英数のみ、10桁以内　※送付先事業所コードは、HRstation契約検索メニュー_請求管理メニュー_請求登録画面の送付先事業所虫眼鏡ボタンより検索し確認してください。"]
["I2"," 送付先事業所名","半角カナ以外、24文字以内　※ダウンロードしたデータを流用する場合、略町名が表示されます。必要に応じて変更してください。"]
["J2","※ 送付先部署コード","半角英数のみ、20桁以内　※送付先部署コードは、HRstation契約検索メニュー_請求管理メニュー_請求登録画面の送付先部署虫眼鏡ボタンより検索し確認してください。"]
["K2"," 送付先部署名","半角カナ以外、24文字以内　※ダウンロードしたデータを流用する場合、略町名が表示されます。必要に応じて変更してください。"]
["L2"," 請求年月日","形式：YYYYMMDD"]
["M2"," 問合せ先","半角カナ以外、50文字以内"]
["N2"," 電話番号","ハイフンあり、13桁"]
["O2","(振込口座1銀行名)","マスタ取得項目です。入力・編集しても反映されません。\nダウンロードしたファイルを流用する場合、口座情報が入力されていない場合は、空欄で出力されます。\n口座情報は、派遣元会社マスタ検索より入力・編集を行ってください。"]
["P2","(振込口座1支店名)"]
["Q2","(振込口座1口座種別)"]
["R2","(振込口座1口座番号)"]
["S2","(振込口座2銀行名)"]
["T2","(振込口座2支店名)"]
["U2","(振込口座2口座種別)"]
["V2","(振込口座2口座番号)"]
["W2","(振込口座3銀行名)"]
["X2","(振込口座3支店名)"]
["Y2","(振込口座3口座種別)"]
["Z2","(振込口座3口座番号)"]
["AA2","(振込口座名義人)"]
["AB2"," 支払い期日","形式：YYYYMMDD"]
["AC2"," 請求対象期間From","形式：YYYYMMDD"]
["AD2"," 請求対象期間To","形式：YYYYMMDD"]
["AE2"," 請求小計","半角数字、8桁以内"]
["AF2"," 特別調整額1","半角数字、8桁以内"]
["AG2"," 特別調整額2","半角数字、8桁以内"]
["AH2"," 消費税額","半角数字、8桁以内"]
["AI2"," (請求合計)","半角数字、8桁以内"]
["AJ2"," 立替金額計","半角数字、8桁以内"]
["AK2"," (請求総計)","半角数字、8桁以内"]
["AL2"," 請求明細NO","請求明細NO（半角数字　1～500連番）"]
[null,null,"※アップロードファイルとして利用する場合、1より連番で入力します。"]
["AM2","※ 契約NO","半角数字、13桁、ハイフンあり　　例）0000000000-000"]
["AN2","Ｊobコード","半角英数のみ、50桁以内"]
["AO2"," (就業先事業所コード)","半角英数のみ、10桁以内"]
["AP2"," 就業先事業所名","半角カナ以外、24文字以内"]
["AQ2"," (就業先部署コード)","半角英数のみ、20桁以内"]
["AR2"," 就業先部署名","全角カナ以外、24文字以内"]
["AS2","（スタッフコード）","半角英数のみ15桁以内（ユーザID：企業コード5桁+任意のコード10桁以内）"]
["AT2","スタッフ名","半角カナ以外、姓（24文字）+半角スペース+名（24文字）"]
["AU2","※ 明細対象期間From","形式：YYYYMMDD"]
["AV2","※ 明細対象期間To","形式：YYYYMMDD"]
["AW2"," 単価","半角数字、8桁以内"]
["AX2"," 単価単位","単価単位"]
[null,null,"時間、 日、 週、 月、 年"]
["AY2"," 契約内金額","半角数字、8桁以内"]
["AZ2"," 契約内時間","形式：HH:MM"]
["BA2"," 法定内契約外金額","半角数字、8桁以内"]
["BB2"," 法定内契約外時間","形式：HH:MM"]
["BC2"," 法定外契約外金額","半角数字、8桁以内"]
["BD2"," 法定外契約外時間","形式：HH:MM"]
["BE2"," 深夜金額","半角数字、8桁以内"]
[" BF2"," 深夜時間","形式：HH:MM"]
["BG2"," 休出金額","半角数字、8桁以内"]
["BH2"," 休出時間","形式：HH:MM"]
["BI2"," 法定休出金額","半角数字、8桁以内"]
["BJ2"," 法定休出時間","形式：HH:MM"]
["BK2"," 控除時間金額","半角数字、8桁以内"]
["BL2"," 控除時間","形式：HH:MM"]
["BM2"," 控除日金額","半角数字、8桁以内"]
["BN2"," 控除日数","半角数字、8桁以内"]
["BO2"," 立替金","半角数字、8桁以内"]
["BP2"," 調整額1","半角数字、8桁以内"]
["BQ2"," 調整額2","半角数字、8桁以内"]
["BR2"," その他調整額","半角数字、8桁以内"]
["BS2"," 法定休日調整額","半角数字、8桁以内"]
["BT2"," (小計)","半角数字、8桁以内"]
["BU2"," 明細コメント","半角カナ以外、500文字以内"]

{"sheet":"サンプル例","index":2,"n_rows":4,"n_cols":73,"rows_kept":4,"cut":false,"hidden":false,"merged":[[2,14,3,26]]}
["ファイルID","ETF_MOTO_SEIKYU"]
["※更新種別","※区分","※請求番号","ステータス","※請求対象年月","※派遣先企業コード","派遣先会社名","※送付先事業所コード","送付先事業所名","※送付先部署コード","送付先部署名","請求年月日","問合せ先","電話番号","（振込口座1銀行名）","（振込口座1支店名）","（振込口座1口座種別）","（振込口座1口座番号）","（振込口座2銀行名）","（振込口座2支店名）","（振込口座2口座種別）","（振込口座2口座番号）","（振込口座3銀行名）","（振込口座3支店名）","（振込口座3口座種別）","（振込口座3口座番号）","（振込口座名義人）","支払い期日","請求対象期間From","請求対象期間To","請求小計","特別調整額1","特別調整額2","消費税額","（請求合計）","立替金額計","（請求総計）","請求明細NO","※契約NO","Jobコード","（就業先事業所コード）","就業先事業所名","（就業先部署コード）","就業先部署名","（スタッフコード）","スタッフ氏名","※明細対象期間From","※明細対象期間To","単価","単価単位","契約内金額","契約内時間","法定内契約外金額","法定内契約外時間","法定外契約外金額","法定外契約外時間","深夜金額","深夜時間","休出金額","休出時間","法定休出金額","法定休出時間","控除時間金額","控除時間","控除日金額","控除日数","立替金","調整額1","調整額2","その他調整額","法定休日調整額","（小計）","明細コメント"]
["U","H","00001",10,201403,"demA1","新宿商事株式会社","C00002","総務部","ZZ111011","総務Ｇ",20140401,"担当　花子","03-0000-0000","（　）の付いた項目は、マスタ取得項目です。入力・編集を行っても反映されません。口座情報の入力、編集は、派遣元会社マスタより実施してください。",null,null,null,null,null,null,null,null,null,null,null,null,20140430,20140301,20140331,379500,0,0,30360,0,1000,0]
["U","D","00001",10,201403,"demA1","新宿商事株式会社","C00002","総務部","ZZ111011","総務Ｇ",20140401,"担当　花子","03-0000-0000",null,null,null,null,null,null,null,null,null,null,null,null,null,20140430,20140301,20140331,null,null,null,null,null,null,null,1,"0000016378-000",null,"C00002","総務部","ZZ111011","総務Ｇ","demZ2100061","秋田 小町",20140301,20140331,2200,"時間",330000,6.25,22000,0.41666666666666669,27500,0.41666666666666669,0,0,0,0,0,0,0,0,0,0,1000,15000,0,0,0,0,"調整額1は、インセンティブです。"]

{"sheet":"請求情報アップロードファイル作成","index":3,"n_rows":2,"n_cols":73,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["ファイルID","ETF_MOTO_SEIKYU"]
["※更新種別","※区分","※請求番号","ステータス","※請求対象年月","※派遣先企業コード","派遣先会社名","※送付先事業所コード","送付先事業所名","※送付先部署コード","送付先部署名","請求年月日","問合せ先","電話番号","（振込口座1銀行名）","（振込口座1支店名）","（振込口座1口座種別）","（振込口座1口座番号）","（振込口座2銀行名）","（振込口座2支店名）","（振込口座2口座種別）","（振込口座2口座番号）","（振込口座3銀行名）","（振込口座3支店名）","（振込口座3口座種別）","（振込口座3口座番号）","（振込口座名義人）","支払い期日","請求対象期間From","請求対象期間To","請求小計","特別調整額1","特別調整額2","消費税額","（請求合計）","立替金額計","（請求総計）","請求明細NO","※契約NO","Jobコード","（就業先事業所コード）","就業先事業所名","（就業先部署コード）","就業先部署名","（スタッフコード）","スタッフ氏名","※明細対象期間From","※明細対象期間To","単価","単価単位","契約内金額","契約内時間","法定内契約外金額","法定内契約外時間","法定外契約外金額","法定外契約外時間","深夜金額","深夜時間","休出金額","休出時間","法定休出金額","法定休出時間","控除時間金額","控除時間","控除日金額","控除日数","立替金","調整額1","調整額2","その他調整額","法定休日調整額","（小計）","明細コメント"]