/** * Copyright (c) 2003-2004 System Integrator Corporation. * All Rights Reserved. */ package jp.co.sint.config; import java.util.ArrayList; import jp.co.sint.database.SIOrderBy; import jp.co.sint.tools.SIDateTime; import jp.co.sint.tools.SIUtil; import org.apache.log4j.Category; /** * @version $Id : SICSVConf.java,v 1.0 Exp $ * @author : Jinwang Chen *
Description :CSV関連の定数などを定義します。 *

History

*

Author         Date        Reason

* ============   ==========  ===========================
* J.W.Chen 2003/08/25 Original */ public class SICSVConf { //ログ用のインスタンスの生成 private static Category log=Category.getInstance(SIConfig.SILOG4J_WEBSHOP_CATEGORY_NAME); //ファイルの拡張名 public final static String SICSV_EXTENSION_NAME = "csv"; //改行 public final static String SINEW_LINE = "\r\n"; //分割の文字 public final static String SICSV_TOKEN = ","; //分割の文字 public final static String SICSV_DATE_TYPE = "date"; public final static String SICSV_DATE_TIME_TYPE = "dateTime"; //各画面に出力するファイルに対する定数定義 public final static int SICSV_INX = 0; public final static int SICSV_CMDTY_INX = SICSV_INX + 0; //商品一覧 public final static int SICSV_ORDER_INX = SICSV_INX + 1; //受注 public final static int SICSV_SHOP_INX = SICSV_INX + 2; //ショップ一覧 public final static int SICSV_CUST_INX = SICSV_INX + 3; //顧客一覧 public final static int SICSV_POINTMAN_ALL_INX = SICSV_INX + 4; //ポイント一覧、全明細 public final static int SICSV_POINTMAN_SHOP_INX = SICSV_INX + 5; //ポイント一覧、ショップ public final static int SICSV_POINTMAN_CUST_INX = SICSV_INX + 6; //ポイント一覧、顧客 public final static int SICSV_SALE_SHOP_M_INX = SICSV_INX + 7; //売上一覧、ショップ //7.2.0 ST0542 修正 public final static int SICSV_SALE_CMDTY_INX = SICSV_INX + 8; //売上一覧、商品 public final static int SICSV_MEMBER_LEVEL_INX = SICSV_INX + 9; //会員種別 public final static int SICSV_CUST_ATTR_INX = SICSV_INX + 10; //会員属性 public final static int SICSV_CUST_HOBBY_INX = SICSV_INX + 11; //会員趣味 public final static int SICSV_CUST_ADDRESS_INX = SICSV_INX + 12; //会員アドレス帳 public final static int SICSV_WRAPPING_INX = SICSV_INX + 13; //ラッピング public final static int SICSV_CMDTY_STNDRD_INX = SICSV_INX + 14; //商品規格関連 public final static int SICSV_STNDRD_NAME_INX = SICSV_INX + 15; //規格名称 public final static int SICSV_STNDRD_CONTENT_INX = SICSV_INX + 16; //規格内容 public final static int SICSV_ORDER_HEADER_INX = SICSV_INX + 17; //受注ヘッダ public final static int SICSV_ORDER_DELIVERY_INX = SICSV_INX + 18; //受注配送先 public final static int SICSV_ORDER_DETAIL_INX = SICSV_INX + 19; //受注明細 public final static int SICSV_ACCESS_DATE_INX = SICSV_INX + 20; //アクセス分析日付 public final static int SICSV_ACCESS_TIME_INX = SICSV_INX + 21; //アクセス分析時間 public final static int SICSV_RFM_ORDER_INX = SICSV_INX + 22; //RFM分析 public final static int SICSV_CMDTY_CTGRY_INX = SICSV_INX + 23; //商品カテゴリ関連 public final static int SICSV_CONN_CMDTY_INX = SICSV_INX + 24; //関連商品 public final static int SICSV_STOCK_STATUS_INX = SICSV_INX + 25; //在庫状況 public final static int SICSV_STOCK_INX = SICSV_INX + 26; //仕入先 public final static int SICSV_PAYEE_INFO_INX = SICSV_INX + 27; //支払先情報 public final static int SICSV_PAY_METHOD_INX = SICSV_INX + 28; //支払方法 public final static int SICSV_PAY_METHOD_FEE_INX = SICSV_INX + 29; //支払方法手数料 public final static int SICSV_DELIVERY_TIME_INX = SICSV_INX + 30; //時間帯 public final static int SICSV_CTGRY_INX = SICSV_INX + 31; //カテゴリ public final static int SICSV_SALE_SHOP_S_INX = SICSV_INX + 32; //売上一覧、ショップ //7.2.0 ST0542 追加 public final static int SICSV_ACCESS_MONTH_TITLE_INX = SICSV_INX + 33; //アクセス分析 年月　//7.2.0 ST0546 追加 public final static int SICSV_ACCESS_DAYOFWEEK_TITLE_INX = SICSV_INX + 34; //アクセス分析 曜日　//7.2.0 ST0546 追加 public final static int SICSV_CMDTY_LIST_INX = SICSV_INX + 35;//商品マスタ（親） //7.3.0 PI-NES0501 追加 public final static int SICSV_INDIVIDUAL_LIST_INX = SICSV_INX + 36;//商品マスタ（個別） //7.3.0 PI-NES0501 追加 public final static int SICSV_STOCK_LIST_INX = SICSV_INX + 37;//支店在庫マスタ //7.3.0 PI-NES0501 追加 public final static int SICSV_INQUIRY_LIST_INX = SICSV_INX + 38;//探してほしいマスタ //7.3.0 PI-NES0501 追加 public final static int SICSV_KAITORISTOCK_LIST_INX = SICSV_INX + 39;//買取入庫一覧 public final static int SICSV_INVENTORY_LIST_INX = SICSV_INX + 40;//棚卸基礎データ public final static int SICSV_UNAPPROVAL_STORE_LIST_INX = SICSV_INX + 41;//未承認入庫データ public final static int SICSV_UNAPPROVAL_SHIP_LIST_INX = SICSV_INX + 42;//未承認出庫データ public final static int SICSV_KEEP_LIST_INX = SICSV_INX + 43;//キープデータ public final static int SICSV_MIKANSAI_LIST_INX = SICSV_INX + 44;//未完済リスト public final static int SICSV_URIAGE_LIST_INX = SICSV_INX + 45;//過去3ヶ月売上リスト public final static int SICSV_LACK_LIST_INX = SICSV_INX + 46;//欠品管理リスト（東京） public final static int SICSV_CMDTY_ALLOCATION_LIST_INX = SICSV_INX + 47;//商品引当管理リスト public final static int SICSV_SALES_DATA_LIST_INX = SICSV_INX + 48;//販売分析データ public final static int SICSV_URIAGE_LIST6_INX = SICSV_INX + 49;//過去6ヶ月売上リスト public final static int SICSV_CUST_ADDRESS_VIEW_INX = SICSV_INX + 50;//都道府県別顧客登録リスト public final static int SICSV_CUST_ROUTE_VIEW_INX = SICSV_INX + 51;//登録経路別顧客登録リスト public final static int SICSV_CUST_JOB_VIEW_INX = SICSV_INX + 52;//営業形態別顧客登録リスト public final static int SICSV_KAITORILATEST_LIST_INX = SICSV_INX + 53;//最新買取一覧 public final static int SICSV_ORDER_ROUTE_VIEW_INX = SICSV_INX + 54;//受注基礎データ public final static int SICSV_URIAGEBASE_LIST_VIEW_INX = SICSV_INX + 55;//売上基礎データ public final static int SICSV_POINTRECORD_LIST_INX = SICSV_INX + 56;//ポイント基礎データ public final static int SICSV_HACCHU_PAYMENT_LIST_INX = SICSV_INX + 57;//支払一覧表 public final static int SICSV_HACCHU_PAYMENT_DETAIL_LIST_INX = SICSV_INX + 58;//支払明細表 public final static int SICSV_HACCHU_STATUS_LIST_INX = SICSV_INX + 59;//支払ステータス public final static int SICSV_ARRIVALSCHEDULEMSG_LIST_INX = SICSV_INX + 60;//入荷予定チェックリスト public final static int SICSV_HISTORY_DETAIL_LIST_INX = SICSV_INX + 61;//各種入出庫明細表 public final static int SICSV_LACK_LIST2_INX = SICSV_INX + 62;//欠品管理リスト（輸入品） public final static int SICSV_RESERVE_LIST_INX = SICSV_INX + 63;//予約商品リスト public final static int SICSV_INVEST_POINT_LOG_LIST_INX = SICSV_INX + 64;//ポイント付与履歴 public final static int SICSV_SOLDOUT_LIST_INX = SICSV_INX + 65;//売り切れ商品チェックリスト public final static int SICSV_CMDTYDATA_LIST_INX = SICSV_INX + 66;//商品詳細データリスト public final static int SICSV_DEADSTOCK_LIST_INX = SICSV_INX + 67;//滞留在庫チェックリスト public final static int SICSV_LACK_LIST_RAKUTEN_INX = SICSV_INX + 68;//欠品管理リスト（楽天） public final static int SICSV_STOCKNUMBER_LIST_INX = SICSV_INX + 69;//棚番リスト public final static int SICSV_FLAGUPDATELOG_LIST_INX = SICSV_INX + 70;//商品マスタ更新管理 public final static int SICSV_MAKER_LIST_INX = SICSV_INX + 71;//ブランドマスタ public final static int SICSV_OPINION_LIST_INX = SICSV_INX + 72;//ご意見ボックス public final static int SICSV_COSTCOMPARE_LIST_INX = SICSV_INX + 73;//原価比較 public final static int SICSV_HACCHU_DETAIL_LIST_INX = SICSV_INX + 74;//納品リスト public final static int SICSV_WAREHOUSE_STORE_LIST_INX = SICSV_INX + 75;//出荷指示リスト public final static int SICSV_WAREHOUSE_SHIP_LIST_INX = SICSV_INX + 76;//入荷予定リスト public final static int SICSV_WAREHOUSE_CMDTY_LIST_INX = SICSV_INX + 77;//品目台帳データ public final static int SICSV_SHIPPMENT_LIST_INX = SICSV_INX + 78;//出荷管理CSV public final static int SICSV_ACTIVEUSER_LIST_INX = SICSV_INX + 79;//アクティブユーザCSV public final static int SICSV_NODELIVERY_LIST_INX = SICSV_INX + 80;//未出荷受注リスト public final static int SICSV_NOPAYMENT_LIST_INX = SICSV_INX + 81;//出荷済未入金リスト public final static int SICSV_BRANCH_DEADSTOCK_LIST_INX = SICSV_INX + 82;//支店滞留在庫リスト public final static int SICSV_REPEAT_SALES_LIST_INX = SICSV_INX + 83;//リピート売上データ public final static int SICSV_EG_POINT_LIST_INX = SICSV_INX + 84;//アイラッシュガレージ受注ポイント public final static int SICSV_EYELASH_SALES_LIST_INX = SICSV_INX + 85;//まつげ商材売上 public final static int SICSV_UNAPPROVAL_DATA_LIST_INX = SICSV_INX + 86;//未承認入出庫（一括決裁画面） public final static int SICSV_RANKING_ANALYSIS_LIST_INX = SICSV_INX + 87;//ランキング分析 public final static int SICSV_CUST_SALES_DATA_LIST_INX = SICSV_INX + 88;//顧客別販売データ public final static int SICSV_PURCHASECOMMENT_LIST_INX = SICSV_INX + 89;//特記事項メモ //タイトルの定義:項目タイトル名とテーブルのfield名とデータタイプ(日付以外は、必要ない) private final static String[][] SICSV_CMDTY_TITLE_NAME ={ {"ショップコード","ShopCode",""}, {"親コード","CmdtyCode",""}, {"JANコード","JanCode",""}, {"仕入先コード","StockCode",""}, {"商品名","CmdtyName",""}, {"商品説明","Description",""}, {"仕入価格","StockUnitPrice",""}, {"本体価格","UnitPrice",""}, {"特別価格","SalesUnitPrice",""}, {"本体価格税区分","TaxFlg",""}, {"おすすめフラグ","AdviceFlg",""}, {"商品バナーファイル","BannerFile",""}, {"バナーリンク先アドレス","BannerURL",""}, {"会員値引フラグ","MemberDiscountFlg",""}, {"検索キーワード1","SrchKeyName1",""}, {"検索キーワード2","SrchKeyName2",""}, {"検索キーワード3","SrchKeyName3",""}, {"商品サイズ","CmdtySize",""}, {"販売開始日","SellFromDate",SICSV_DATE_TYPE}, {"販売終了日設定フラグ","EndSellFlg",""}, {"販売終了日","SellToDate",SICSV_DATE_TYPE}, {"特別価格開始日","SalesFromDate",SICSV_DATE_TYPE}, {"特別価格終了日","SalesToDate",SICSV_DATE_TYPE}, {"予約販売フラグ","RsrvEnableFlg",""}, {"在庫数管理", "AmountFlg", ""}, {"在庫無販売フラグ","NoStockFlg",""}, {"在庫数量","Amount",""}, {"予約可能数","RsrvAmount",""}, {"在庫状況番号","StockStatusCode",""}, {"ラッピングフラグ","WrappingFlg",""}, {"配送種別コード","DeliveryTypeCode",""}, {"ランキング順位","Ranking",""}, {"ランキング集計日時","RankingDateTime",SICSV_DATE_TIME_TYPE}, {"登録日時","InitDateTime",SICSV_DATE_TIME_TYPE} //7.2.0 ST0306 追加 ここから ,{"一括値引フラグ", "DISCOUNTFLG", ""} ,{"特価値引フラグ", "SALESDISCOUNTFLG", ""} ,{"おすすめ表示順", "ADVICEDISPORDER", ""} //7.2.0 ST0306 追加 ここまで }; private final static String[][] SICSV_ORDER_TITLE_NAME = { {"受注番号","OrderCode",""}, {"受注配送先項番","DeliveryCode",""}, {"受注明細項番","DetailCode",""}, {"ショップコード","ShopCode",""}, {"親コード","CmdtyCode",""}, {"在庫コード","IndividualCode",""},//7.3.0 PI-NES0501 追加 {"ショップ名","ShopName",""}, {"商品名","CmdtyName",""}, //7.3.0 PI-NES0501 削除 ここから /* {"規格分類１","StndrdName1",""}, {"規格１","ElementName1",""}, {"規格分類２","StndrdName2",""}, {"規格２","ElementName2",""}, */ //7.3.0 PI-NES0501 削除 ここまで {"数量","Amount",""}, {"本体価格","OrgPrice",""}, {"購入価格","Price",""}, {"本体価格税区分","TaxFlg",""}, {"消費税率","c_TaxRate",""}, {"商品サイズ","CmdtySize",""}, //7.3.0 PI-NES0501 追加 ここから {"個別送料","DeliveryFee",""}, {"送料調整額","DiscountDeliveryFee",""}, {"色コード","ColorCode",""}, {"色名称","ColorName",""}, //7.3.0 PI-NES0501 追加 ここまで //7.3.0 PI-NES0501 削除 ここから /* {"ラッピングコード","WrappingCode",""}, {"ラッピング名","WrappingName",""}, {"ラッピング価格","WrappingPrice",""}, {"ラッピング価格税区分","WrappingTaxFlg",""}, */ //7.3.0 PI-NES0501 削除 ここまで {"顧客コード","CustCode",""}, {"法人フラグ","a_CustCompanyFlg",""}, {"顧客名","CustName",""}, {"顧客名カナ","CustPronName",""}, {"顧客メールアドレス","Email",""}, {"請求書宛名","OrderAddressee",""}, {"顧客郵便番号","a_PostCode",""}, {"顧客住所１","a_Address1",""}, {"顧客住所２","a_Address2",""}, {"顧客住所３","a_Address3",""}, {"顧客会社名","a_CompanyName",""}, {"営業形態","Job",""},//7.3.0 PI-NES0501 追加 {"連絡先電話番号１","StoreTel",""},//7.3.0 PI-NES0501 追加 {"連絡先電話番号２","a_Tel",""}, {"顧客FAX番号","Fax",""}, {"支払方法名","PayMethodName",""}, {"支払区分","PaymentFlg",""}, {"手数料","Fee",""}, //{"手数料消費税区分","FeeTaxFlg",""},2006.4.6調査中 //{"手数料税率","a_TaxRate",""}, {"手数料調整額","DiscountFee",""}, {"値引金額","SumOfDiscount",""}, {"ポイント使用金額","SumByPoint",""}, {"小計","syoukei",""}, {"お支払い合計","goukei",""}, {"受注状態","Status",""}, {"連絡事項","ContactMsg",""}, {"備考","Memo",""}, {"配送先呼称","DeliveryName",""}, {"配送先宛名","DeliveryAddressee",""}, {"自宅フラグ","HomeFlg",""}, {"配送先法人フラグ","b_CustCompanyFlg",""}, {"配送先郵便番号","b_PostCode",""}, {"配送先住所１","b_Address1",""}, {"配送先住所２","b_Address2",""}, {"配送先住所３","b_Address3",""}, {"配送先会社名","b_CompanyName",""}, {"配送先電話番号","b_Tel",""}, //7.3.0 PI-NES0501 削除 ここから /* {"送料","DeliveryFee",""}, {"送料消費税区分","DeliveryTaxFlg",""}, {"送料税率","b_TaxRate",""}, */ //7.3.0 PI-NES0501 削除 ここまで {"配送希望日","DeliveryDate",SICSV_DATE_TYPE}, {"配送時間帯","DeliveryTime",""}, {"配送種別名","DeliveryTypeName",""},//7.2.0 ST0263 修正 {"受注日時","InitDateTime",SICSV_DATE_TIME_TYPE}, {"修正日時","UpdateDateTime",SICSV_DATE_TIME_TYPE}, {"入金日","ReceiptDate",SICSV_DATE_TYPE}, {"出荷日","ShippmentDate",SICSV_DATE_TYPE}, //7.3.0 PI-NES0501 追加 ここから {"支店コード","BranchCode",""}, {"支店名","BranchName",""}, {"担当者コード","ChargeCode",""}, {"担当者名","ChargeName",""}, {"受注経路","OrderRoute",""}, {"加工価格","ProcessingExpence",""}, {"仕入価格","PurchasePrice",""}, //7.3.0 PI-NES0501 追加 ここまで //7.3.0 ST2023 ここから {"修正者ショップコード","UpdateMallShopCode",""}, {"修正者管理者ID","UpdateUserCode",""} //7.3.0 ST2023 ここまで }; private final static String[][] SICSV_SHOP_TITLE_NAME = { {"ショップコード","MallShopCode",""}, {"管理区分","MallShopFlg",""}, {"管理会社名","MallShopName",""}, {"管理会社名カナ","MallShopNameKana",""}, {"管理者ID","AdminName",""}, {"管理者パスワード","AdminPass",""}, {"ショップ名","FrontShopName",""}, {"ショップ略名","AbbvFrontShopName",""}, {"ショップ名カナ","FrontShopNameKana",""}, {"部門名","DepartName",""}, {"郵便番号１","PostCode1",""}, {"郵便番号２","PostCode2",""}, {"住所１","Address1",""}, {"住所２","Address2",""}, {"住所３","Address3",""}, {"電話番号","Tel",""}, {"FAX番号","Fax",""}, {"EMAIL","Email",""}, {"担当者名","ChargeUserName",""}, {"手数料消費税フラグ","FeeTaxFlg",""}, {"送料消費税フラグ","DeliveryTaxFlg",""}, {"ポイント使用フラグ","PointEnableFlg",""}, {"値引期間FROM","DiscountFromDate",""}, {"値引期間TO","DiscountToDate",""}, {"値引率","DiscountRate",""}, {"在庫管理フラグ","InStockFlg",""}, {"商品新着期間","DaysOfNew",""}, {"おすすめ商品数","AmountByAdvice",""}, {"ギフトフラグ","GiftFlg",""}, {"ショップ状態","Status",""}, {"登録日時","InitDateTime",SICSV_DATE_TIME_TYPE}, {"更新日時","UpdateDateTime",SICSV_DATE_TIME_TYPE} }; private final static String[][] SICSV_CUST_TITLE_NAME ={ {"顧客コード","CustCode",""}, //{"法人フラグ","CustCompanyFlg",""}, {"氏名","CustName",""}, {"フリガナ","CustPronName",""}, {"メールアドレス","Email",""}, //{"パスワード","Password",""}, {"PWリマインダ質問","PWQuestion",""}, {"PWリマインダ回答","PWAnswer",""}, {"郵便番号1","PostCode1",""}, {"郵便番号2","PostCode2",""}, {"住所1","Address1",""}, {"住所2","Address2",""}, {"住所3","Address3",""}, {"サロン名","CompanyName",""}, {"会社名","CorporationName",""}, {"連絡先電話番号１","StoreTel",""}, {"連絡先電話番号２","Tel",""}, {"連絡先FAX番号","Fax",""}, //{"お支払い方法","PayMethodCode",""}, //{"生年月日","BirthDate",SICSV_DATE_TYPE}, //{"性別","Sex",""}, {"営業形態","Job",""}, {"従業員数","HowToKnow",""}, //{"その他の施術メニュー","OtherMenu",""}, {"登録経路","RegistRoute",""}, {"新着メール","NewMailFlg",""}, {"前回ログイン日時","LoginDateTime",SICSV_DATE_TIME_TYPE}, {"削除区分","DelFlg",""}, {"削除日時","DelDateTime",SICSV_DATE_TIME_TYPE}, {"ログインエラー回数","LoginErrorCount",""}, {"ログインエラー日時","LoginErrorDateTime",SICSV_DATE_TIME_TYPE}, {"修正者ショップコード","UpdateMallShopCode",""}, {"修正者管理者ID","UpdateUserCode",""}, {"修正日時","UpdateDateTime",SICSV_DATE_TIME_TYPE}, {"契約状況（ポール・シェリー：ボディ）","contract1",""}, {"契約状況（ポール・シェリー：フェイシャル）","contract2",""}, {"契約状況（ポール・シェリー：共通）","contract3",""}, {"契約状況（ピーチポウ）","contract4",""}, {"営業担当者","charge",""}, {"サロンホームページURL","salonUrl",""}, {"取引条件","receivableflgvalue",""}, {"会員種別","MemberLevelName",""}, {"会員種別固定","MemberLevelFixedType",""}, {"購買ポイント付与","NoPointType",""}, {"郵送不可区分","NoDeliveryType",""}, {"登録通知書出力日時","PdfOutputDateTime",SICSV_DATE_TIME_TYPE}, {"昇格通知書出力日時","PdfOutputDateTime2",SICSV_DATE_TIME_TYPE}, {"ゴールド昇格日","RankChangeDate1",SICSV_DATE_TYPE}, {"プラチナ昇格日","RankChangeDate2",SICSV_DATE_TYPE}, {"降格フラグ","RankDownFlg",""}, {"パスワード配信日時","PasswordMailDateTime",""}, {"開業予定","openingType",""}, {"開業予定時期","openingPlanDateTxt",""}, {"開業予定エリア","openingArea",""}, {"サポートメニュー","supportMenu",""} }; private final static String[][] SICSV_POINTMAN_ALL_TITLE_NAME ={ {"ショップコード","MallShopCode",""}, {"ショップ名","FrontShopName",""}, {"顧客コード","CustCode",""}, {"顧客名","CustName",""}, {"発行種別フラグ","IssueFlg",""}, {"発行／使用ポイント数","PointOfIssue",""}, {"有効フラグ","EnableFlg",""}, {"受注番号","OrderCode",""}, {"受注日","InitDateTime",SICSV_DATE_TIME_TYPE}, {"入金日","ReceiptDate",SICSV_DATE_TYPE}, {"レビューコード","ReviewCode",""}, {"ポイント発行日時","IssueDateTime",SICSV_DATE_TIME_TYPE}, {"ポイント付与理由","Comment",""} }; private final static String[][] SICSV_POINTMAN_SHOP_TITLE_NAME ={ {"ショップコード","MallShopCode",""}, {"ショップ名","FrontShopName",""}, {"無効ポイント","totalOfInvalid",""}, {"仮発行ポイント","totalOfTemporary",""}, {"有効ポイント","totalOfEffective",""} }; private final static String[][] SICSV_POINTMAN_CUST_TITLE_NAME ={ {"顧客コード","CustCode",""}, {"顧客名","CustName",""}, {"無効ポイント","totalOfInvalid",""}, {"仮発行ポイント","totalOfTemporary",""}, {"有効ポイント","totalOfEffective",""} }; /* private final static String[][] SICSV_SALE_SHOP_TITLE_NAME ={ {"ショップコード","ShopCode",""}, {"ショップ名","ShopName",""}, {"売上金額","Total",""}, }; 7.2.0 ST0542 削除 */ //7.2.0 ST0542 追加 ここから //ポイント使用額なし（出荷データ集計のとき） private final static String[][] SICSV_SALE_SHOP_TITLE_M_NAME ={ {"ショップコード","ShopCode",""}, {"ショップ名","ShopName",""}, {"売上金額（税込）","InTaxTotal",""}, {"売上金額（税抜）","OutTaxTotal",""}, {"受注件数","OrderTotal",""}, {"客単価","CustUnitPrice",""}, {"送料","TotalOfDeliveryFee",""}, {"ラッピング金額","WrappingPriceIncTax",""}, }; //ポイント使用額あり（受注データ集計のとき） private final static String[][] SICSV_SALE_SHOP_TITLE_S_NAME ={ {"ショップコード","ShopCode",""}, {"ショップ名","ShopName",""}, {"売上金額（税込）","InTaxTotal",""}, {"売上金額（税抜）","OutTaxTotal",""}, {"受注件数","OrderTotal",""}, {"客単価","CustUnitPrice",""}, {"送料","TotalOfDeliveryFee",""}, {"ラッピング金額","WrappingPriceIncTax",""}, {"ポイント使用額","SumByPointTotal",""}, }; //7.2.0 ST0542 追加 ここまで private final static String[][] SICSV_SALE_CMDTY_TITLE_NAME ={ {"ショップコード","ShopCode",""}, {"ショップ名","ShopName",""}, {"商品コード","CmdtyCode",""}, //7.2.0 ST0259 追加 ここから {"規格分類1","StndrdCode1",""}, {"規格1","ElementCode1",""}, {"規格分類2","StndrdCode2",""}, {"規格2","ElementCode2",""}, //7.2.0 ST0259 追加 ここまで {"商品名","CmdtyName",""}, //7.2.0 ST0259 追加 ここから {"規格名1","ElementName1",""}, {"規格名2","ElementName2",""}, //7.2.0 ST0259 追加 ここまで {"数量","Amount",""}, {"売上金額（税込）","InTaxTotal",""},//7.2.0 ST0542 修正 //7.2.0 ST0542 追加 ここから {"売上金額（税抜）","OutTaxTotal",""}, {"受注件数","OrderTotal",""}, {"平均単価","CustUnitPrice",""}, {"ラッピング金額","WrappingPriceTotal",""}, //7.2.0 ST0542 追加 ここまで }; private final static String[][] SICSV_MEMBER_LEVEL_TITLE_NAME ={ {"会員種別コード","MemberLevelCode",""}, {"会員レベル","MemberLevel",""}, {"会員レベル呼称","MemberLevelName",""}, {"値引率","DiscountRate",""}, {"登録日時","InitDateTime",SICSV_DATE_TIME_TYPE}, {"更新日時","UpdateDateTime",SICSV_DATE_TYPE} }; private final static String[][] SICSV_CUST_ATTR_TITLE_NAME ={ {"属性番号","AttrCode",""}, {"属性分類コード","AttrFlag",""}, {"属性名","AttrName",""},//7.2.0 ST0263 修正 {"表示順","DispOrder",""} }; private final static String[][] SICSV_CUST_HOBBY_TITLE_NAME ={ //{"属性番号","HobbyCode",""}, {"顧客コード","CustCode",""}, {"施術メニュー","HobbyName",""} }; private final static String[][] SICSV_CUST_ADDRESS_TITLE_NAME ={ {"顧客コード","CustCode",""}, {"アドレス帳番号","AddressCode",""}, {"法人個人区分","CustCompanyFlg",""}, {"配送先呼称","DeliveryName",""}, {"配送先正式名","DeliveryAddressee",""}, {"郵便番号1","PostCode1",""}, {"郵便番号2","PostCode2",""}, {"住所1","Address1",""}, {"住所2","Address2",""}, {"住所3","Address3",""}, {"サロン名","CompanyName",""}, {"会社名","CorporationName",""}, {"連絡先電話番号","Tel",""}, {"最終配送日","LastDeliveryDate",SICSV_DATE_TYPE}, {"登録日時","InitDateTime",SICSV_DATE_TIME_TYPE}, {"更新日時","UpdateDateTime",SICSV_DATE_TIME_TYPE}, //7.3.0 ST2023 ここから {"修正者ショップコード","UpdateMallShopCode",""}, {"修正者管理者ID","UpdateUserCode",""}, //7.3.0 ST2023 ここまで }; private final static String[][] SICSV_WRAPPING_TITLE_NAME ={ {"ショップコード","ShopCode",""}, {"ラッピングコード","WrappingCode",""}, {"ラッピング名","WrappingName",""},//7.2.0 ST0263 修正 {"説明文","Description",""}, {"価格","Price",""}, {"税区分","TaxFlg",""} }; private final static String[][] SICSV_CMDTY_STNDRD_TITLE_NAME ={ {"商品規格関連コード","CmdtyStndrdCode",""}, {"ショップコード","ShopCode",""}, {"商品コード","CmdtyCode",""}, {"規格コード1","StndrdCode1",""}, {"エレメントコード1","ElementCode1",""}, {"規格コード2","StndrdCode2",""}, {"エレメントコード2","ElementCode2",""}, {"在庫数量","Amount",""} }; private final static String[][] SICSV_STNDRD_NAME_TITLE_NAME ={ {"ショップコード","ShopCode",""}, {"規格コード","StndrdCode",""}, {"規格名","StndrdName",""}//7.2.0 ST0263 修正 }; private final static String[][] SICSV_STNDRD_CONTENT_TITLE_NAME ={ {"ショップコード","ShopCode",""}, {"規格コード","StndrdCode",""}, {"エレメントコード","ElementCode",""}, {"エレメント表示順序","DispOrder",""}, {"エレメント名","ElementName",""}//7.2.0 ST0263 修正 }; private final static String[][] SICSV_ORDER_HEADER_TITLE_NAME ={ {"受注番号","OrderCode",""}, {"顧客コード","CustCode",""}, {"法人フラグ","CustCompanyFlg",""}, {"顧客名","CustName",""}, {"顧客名カナ","CustPronName",""}, {"EMAIL","Email",""}, {"請求書宛名","OrderAddressee",""}, {"郵便番号1","PostCode1",""}, {"郵便番号2","PostCode2",""}, {"請求書住所1","Address1",""}, {"請求書住所2","Address2",""}, {"請求書住所3","Address3",""}, {"会社名","CompanyName",""}, {"電話番号","Tel",""}, {"FAX番号","Fax",""}, {"支払方法名","PayMethodName",""},//7.2.0 ST0263 修正 {"受注日時","InitDateTime",SICSV_DATE_TIME_TYPE}, {"修正日時","UpdateDateTime",SICSV_DATE_TIME_TYPE}, {"先後払いフラグ","PaymentFlg",""}, {"手数料","Fee",""}, {"手数料商品税区分","FeeTaxFlg",""}, {"税率","TaxRate",""}, {"入金日","ReceiptDate",SICSV_DATE_TYPE}, {"値引き合計","SumOfDiscount",""}, {"ポイント使用額","SumByPoint",""}, {"メール送信フラグ","SendMailFlg",""}, {"受注状態","Status",""}, {"連絡事項","ContactMsg",""}, {"備考","Memo",""} }; private final static String[][] SICSV_ORDER_DELIVERY_TITLE_NAME ={ {"受注番号","OrderCode",""}, {"受注配送先項番","DeliveryCode",""}, {"配送先呼称","DeliveryName",""}, {"配送先宛名","DeliveryAddressee",""}, {"個人法人フラグ","CustCompanyFlg",""}, {"EMAIL","Email",""}, {"郵便番号1","PostCode1",""}, {"郵便番号2","PostCode2",""}, {"請求書住所1","Address1",""}, {"請求書住所2","Address2",""}, {"請求書住所3","Address3",""}, {"会社名","CompanyName",""}, {"連絡先電話番号","Tel",""}, {"連絡先FAX番号","Fax",""}, {"送料","DeliveryFee",""}, {"送料商品税区分","DeliveryTaxFlg",""}, {"税率","TaxRate",""}, {"配送希望日","DeliveryDate",SICSV_DATE_TYPE}, {"配送希望時間帯From","DeliveryTimeFrom",""}, {"配送希望時間帯To","DeliveryTimeTo",""}, {"出荷日","ShippmentDate",SICSV_DATE_TYPE}, {"配送種別名","DeliveryTypeName",""}//7.2.0 ST0263 修正 }; private final static String[][] SICSV_ORDER_DETAIL_TITLE_NAME ={ {"受注番号","OrderCode",""}, {"受注配送先項番","DeliveryCode",""}, {"受注明細項番","DetailCode",""}, {"ショップコード","ShopCode",""}, {"ショップ名","ShopName",""}, {"親コード","CmdtyCode",""}, {"商品名","CmdtyName",""}, {"規格コード1","StndrdCode1",""}, {"エレメントコード1","ElementCode1",""}, {"規格コード2","StndrdCode2",""}, {"エレメントコード2","ElementCode2",""}, {"数量","Amount",""}, {"本体価格","OrgPrice",""}, {"購入価格","Price",""}, {"本体価格税区分","TaxFlg",""}, {"消費税率","TaxRate",""}, {"商品サイズ","CmdtySize",""}, {"ラッピングコード","WrappingCode",""}, {"ラッピング名","WrappingName",""}, {"ラッピング価格","WrappingPrice",""}, {"ラッピング価格区分","WrappingTaxFlg",""} }; private final static String[][] SICSV_ACCESS_DATE_TITLE_NAME ={ {"年／月／日","date",""}, {"アクセス数","count",""} }; //7.2.0 ST0546 以後、固定ではないためSIRegAccesslogで設定する private final static String[][] SICSV_ACCESS_TIME_TITLE_NAME ={ {"時間帯","time",""}, {"アクセス数","count",""} }; //7.2.0 ST0546 追加 ここから private final static String[][] SICSV_ACCESS_MONTH_TITLE_NAME ={ {"年","year",""}, {"月","month",""}, {"アクセス数","count",""} }; private final static String[][] SICSV_ACCESS_DAYOFWEEK_TITLE_NAME ={ {"年／月","date",""}, {"日","sunday",""}, {"月","monday",""}, {"火","tuesday",""}, {"水","wednesday",""}, {"木","thursday",""}, {"金","friday",""}, {"土","saturday",""}, {"合計","count",""} }; //7.2.0 ST0546 追加 ここまで private final static String[][] SICSV_RFM_ORDER_TITLE_NAME ={ {"RFM連番","Rfmanalysecode",""}, {"顧客コード","Custcode",""}, {"顧客名","CustName",""}, {"受注番号","OrderCode",""}, {"購入金額","Sumofprice",""}, {"購入商品数","Amount",""}, {"受注日","Initdatetime",SICSV_DATE_TIME_TYPE} }; private final static String[][] SICSV_CMDTY_CTGRY_TITLE_NAME ={ {"ショップコード","ShopCode",""}, {"親コード","CmdtyCode",""}, {"カテゴリコード","CtgryCode",""} }; private final static String[][] SICSV_CONN_CMDTY_TITLE_NAME ={ {"ショップコード","ShopCode",""}, {"親コード","CmdtyCode",""}, {"関連商品ショップコード","ConnShopCode",""}, {"関連商品コード","ConnCmdtyCode",""}, {"表示順序","DispOrder",""} }; private final static String[][] SICSV_STOCK_STATUS_TITLE_NAME ={ {"在庫状況番号","StockStatusCode",""}, {"在庫状況分類名","StockStatusName",""}, {"在庫無コメント","CommentOfNoStock",""}, {"在庫少数量","AmountOfLessStock",""}, {"在庫少コメント","CommentOfLessStock",""}, {"在庫多コメント","CommentOfMoreStock",""} }; private final static String[][] SICSV_STOCK_TITLE_NAME ={ {"仕入先コード","StockCode",""}, {"仕入先名","StockName",""}, {"仕入先名カナ","StockPronName",""}, {"代表者名","PresidentName",""}, {"代表者名カナ","PresidentPronName",""}, {"住所１","Address1",""}, {"住所２","Address2",""}, {"住所３","Address3",""}, {"郵便番号１","PostCode1",""}, {"郵便番号２","PostCode2",""}, {"メールアドレス１","Email",""}, {"メールアドレス２","Email2",""}, {"メールアドレス３","Email3",""}, {"電話番号","Tel",""}, {"FAX番号","Fax",""}, {"営業担当部署","DealerStation",""}, {"営業担当者名","DealerStaff",""}, {"仕入担当者","ChargeCodeName",""}, {"資本金（単位：千円）","Capital",""}, {"設立年月日","EstablishDate",SICSV_DATE_TYPE}, {"決算期","AccountingPeriod",""}, {"取引先金融機関名","FinancialInst",""}, {"金融機関支店名","FinancialBranch",""}, {"口座名義人","AccountHolder",""}, {"口座種別","AccountTypeName",""}, {"口座番号","AccountNumber",""}, {"締め月","CloseTypeName",""}, {"締め日","CloseLimit",""}, {"支払月","PayTypeName",""}, {"支払日","PayLimit",""}, {"使用状態","EnableFlgName",""} }; private final static String[][] SICSV_PAYEE_INFO_TITLE_NAME ={ {"管理コード","MallShopCode",""}, {"支払方法コード","PayMethodCode",""}, {"支払先コード","PayeeCode",""}, {"金融機関コード","BankCode",""}, {"金融機関名","BankName",""}, {"金融機関名カナ","BankNameKana",""}, {"金融機関支店コード","SubBankCode",""}, {"金融機関支店名","SubBankName",""}, {"金融機関支店名カナ","SubBankNameKana",""}, {"口座種類","AccountType",""}, {"口座番号","AccountNo",""}, {"口座名義","AccountName",""} }; private final static String[][] SICSV_PAY_METHOD_TITLE_NAME ={ {"管理コード","MallShopCode",""}, {"支払方法コード","PayMethodCode",""}, {"支払方法名","PayMethodName",""},//7.2.0 ST0263 修正 {"先／後払いフラグ","PaymentFlg",""}, {"手数料","Fee",""} }; private final static String[][] SICSV_PAY_METHOD_FEE_TITLE_NAME ={ {"管理コード","MallShopCode",""}, {"支払方法コード","PayMethodCode",""}, {"購入金額To","PriceTo",""}, {"手数料","Fee",""} }; private final static String[][] SICSV_DELIVERY_TIME_TITLE_NAME ={ {"管理コード","MallShopCode",""}, {"配送種別コード","DeliveryTypeCode",""}, {"時間帯From","DeliveryTimeTo",""}, {"時間帯To","DeliveryTimeFrom",""} }; private final static String[][] SICSV_CTGRY_TITLE_NAME ={ {"カテゴリコード","CtgryCode",""}, {"親カテゴリコード","ParentCtgryCode",""}, {"カテゴリ名","CtgryName",""},//7.2.0 ST0263 修正 {"カテゴリ略称（ソート順）","AbbvCtgryName",""} //7.2.0 ST0306 追加 ここから ,{"関連商品数", "CMDTYAMOUNT", ""} ,{"商品初期表示", "CMDTYFLAG", ""} //7.2.0 ST0306 追加 ここまで }; private final static String[][] SICSV_CMDTY_LIST_TITLE_NAME = { {"ショップコード","ShopCode",""}, {"親コード","cmdtyCode",""}, {"商品名","cmdtyName",""}, {"型式","otherName",""}, //{"JANコード","janCode",""}, {"ブランドコード","makerCode",""}, {"色コード","colorCode",""}, {"M価","newFixedPrice",""}, //{"リンク先アドレス","bannerURL",""}, //{"検索キーワード１","srchKeyName1",""}, //{"検索キーワード２","srchKeyName2",""}, //{"検索キーワード３","srchKeyName3",""}, {"本体価格税区分","taxFlg",""}, {"配送種別コード","deliveryTypeCode",""}, {"商品サイズ","cmdtySize",""}, //{"ランキング順位","ranking",""}, //{"ランキング集計日時","rankingDateTime",""}, {"登録日時","initDateTime",""}, {"死活フラグ","disableFlg",""} }; private final static String[][] SICSV_INDIVIDUAL_LIST_TITLE_NAME = { {"ショップコード","shopCode",""}, {"親コード","cmdtyCode",""}, {"在庫コード","individualCode",""}, {"中古・新品区分","usedNewFlg",""}, {"入荷日","arrivalDate",""}, {"加工費","processingExpence",""}, {"使用年数","tenureofuse",""}, {"販売状況","salesSituationFlg",""}, {"SOLDOUT後表示","soldOutDispFlg",""}, {"キャンペーン特価区分","campaignPriceFlg",""}, {"問合せ区分","inquiryFlg",""}, {"フロント表示","frontDispFlg",""}, //{"顧客コード","custCode",""}, //{"顧客名称","custName",""}, {"コメント","comment",""}, {"BG卸価フロント表示","bgPriceDispFlg",""}, {"委託商品","consignGoodsFlg",""}, {"委託メモ","consignmentMemo",""}, {"商品説明","commodityExplanation",""}, {"仕入先コード","stockCode",""}, {"仕入価格","purchasePrice",""}, {"BG卸価（本体価格）","bgPrice",""}, //{"特別価格","specialPrice",""}, //{"おすすめフラグ","recommendationFlg",""}, //{"商品バナーファイル","commodityBannerFile",""}, {"会員値引フラグ","memberDiscountFlg",""}, //{"販売開始日","sellFromDate",""}, //{"販売終了日設定フラグ","endSellFlg",""}, //{"販売終了日","sellToDate",""}, //{"特別価格開始日","salesFromdate",""}, //{"特別価格終了日","salesToDate",""}, {"予約販売フラグ","rsrvEnableFlg",""}, {"予約可能数","rsrvAmount",""}, //{"在庫無販売フラグ","noStockFlg",""}, //{"在庫数管理フラグ","amountFlg",""}, //{"在庫状況番号","stockStatusCode",""}, {"売切日","soldOutDate",""}, {"保障期間","guaranteedTerm",""}, //{"ラッピングフラグ","wrappingFlg",""}, //{"一括値引フラグ","discountFlg",""}, //{"特価値引フラグ","salesDiscountFlg",""}, //{"おすすめ表示順","adviceDispOrder",""}, {"画像タイトル１","imageName1",""}, {"画像タイトル２","imageName2",""}, {"画像タイトル３","imageName3",""}, {"画像タイトル４","imageName4",""}, {"画像タイトル５","imageName5",""}, {"画像タイトルサムネイル","imageNamet",""}, {"備考","remarks",""}, {"登録日時","initDateTime",""}, {"キャンペーン特価フラグ","SpCampaignFlg",""}, {"通常価格","NomalPrice",""}, {"アラート数量","alertAmount",""}, {"仕入価格（在庫管理なし）","purchasePrice2",""}, {"JANコード","janCodeIndividual",""}, {"検品時／ピッキング時注意事項","setitem1",""}, {"同梱品情報","setItem2",""} }; private final static String[][] SICSV_STOCK_LIST_TITLE_NAME = { {"ショップコード","ShopCode",""}, {"親コード","cmdtyCode",""}, {"在庫コード","individualCode",""}, {"支店コード","branchCode",""}, {"販売優先順位","salesPriorityFlg",""}, {"在庫数量","amount",""}, {"登録日時","initDateTime",""}, {"更新日時","updateDateTime",""} }; private final static String[][] SICSV_INQUIRY_LIST_TITLE_NAME = { {"問合せ番号","ManagementNumber",""}, {"受付日","InitDateTime",SICSV_DATE_TYPE}, {"対応状況","CorrespondingFlg",""}, {"担当者地区","BranchName",""}, {"担当者","ChargeName",""}, {"店名","SalonName",""}, {"依頼者氏名","CustName",""}, {"住所1","Address1",""}, {"商品カテゴリ","CtgryName",""}, {"希望商品","HopeCommodityName",""}, {"数量","HopeAmount",""}, {"納品期限","HopeDeliveryDate",""}, {"連絡先電話番号","StoreTel",""} }; private final static String[][] SICSV_KAITORISTOCK_LIST_TITLE_NAME = { {"在庫コード","IndividualCode",""}, {"入庫番号","StoreNumber",""}, {"入庫日","InitDateTime",SICSV_DATE_TYPE}, {"支店名","BranchName",""}, {"入庫担当者","ChargeName",""}, {"入庫数","Amount",""}, {"仕入総額","PurchasePrice",""}, {"仕入単価","PurchaseUnit",""}, {"加工総額","ProcessingExpence",""}, {"加工単価","ProcessingUnit",""}, {"区分","StoreType",""}, {"商品名","CmdtyName",""} }; private final static String[][] SICSV_INVENTORY_LIST_TITLE_NAME = { {"支店コード","BranchCode",""}, {"支店名","BranchName",""}, {"親コード","CmdtyCode",""}, {"棚番","StockNumber",""}, {"カテゴリ分類","CtgryInitial",""}, {"在庫コード","IndividualCode",""}, {"セグメント","Segment",""}, {"ブランド名","MakerName",""}, {"商品名","CmdtyName",""}, {"色","ColorName",""}, {"原価","Cost",""}, {"EC在庫数","EcAmount",""}, {"キープ数","KeepAmount",""}, {"出荷待ち数","OrderAmount",""}, {"予約割当て数","ReserveAmount",""}, {"未承認出庫","ShipHistoryAmount",""}, {"商品カテゴリ","CtgryName",""}, {"仕入単価","PurchasePrice",""}, {"加工単価","ProcessingExpence",""}, {"帳簿在庫","RealAmount",""}, {"在庫資産額","TotalPrice",""} }; private final static String[][] SICSV_UNAPPROVAL_STORE_LIST_TITLE_NAME = { {"入庫番号","StoreNumber",""}, {"登録日","InitDateTime",SICSV_DATE_TYPE}, {"支店名","BranchName",""}, {"入庫担当者","ChargeName",""}, {"在庫コード","IndividualCode",""}, {"商品名","CmdtyName",""}, {"ブランド","MakerName",""}, {"色","ColorName",""}, {"数量","Amount",""}, {"区分","StoreType",""}, {"備考","Comment",""}, {"JANコード","JanCodeIndividual",""} }; private final static String[][] SICSV_UNAPPROVAL_SHIP_LIST_TITLE_NAME = { {"出庫番号","ShipNumber",""}, {"登録日","InitDateTime",SICSV_DATE_TYPE}, {"支店名","BranchName",""}, {"入庫担当者","ChargeName",""}, {"在庫コード","IndividualCode",""}, {"商品名","CmdtyName",""}, {"ブランド","MakerName",""}, {"色","ColorName",""}, {"数量","Amount",""}, {"区分","ShipType",""}, {"備考","Comment",""} }; private final static String[][] SICSV_KEEP_LIST_TITLE_NAME = { {"キープ番号","KeepNumber",""}, {"担当支店","BranchName",""}, {"担当者","ChargeName",""}, {"キープ日","InitDateTime",SICSV_DATE_TYPE}, {"親コード","CmdtyCode",""}, {"在庫コード","IndividualCode",""}, {"商品名","CmdtyName",""}, {"引当支店","Hikiate",""}, {"数量","Amount",""}, {"見積状態","Mitumori",""}, {"受注状態","Jyutyuu",""}, {"取り置き依頼","Mail",""}, {"一括削除保護","protect",""} }; private final static String[][] SICSV_MIKANSAI_LIST_TITLE_NAME = { {"担当支店","BranchName",""}, {"担当者","ChargeName",""}, {"受注番号","OrderCode",""}, {"顧客名","CustName",""}, {"支払方法","PaymethodName",""}, {"支払金額","Goukei",""}, {"入金金額","Shiharai",""}, {"支払残高","Zandaka",""}, {"受注日","InitDateTime",SICSV_DATE_TYPE}, {"出荷日","LastShippmentDate",SICSV_DATE_TYPE}, {"出荷状況","CompleteFlg",""} }; private final static String[][] SICSV_URIAGE_LIST_TITLE_NAME = { {"支店名","BranchName",""}, {"在庫コード","IndividualCode",""}, {"商品名","CmdtyName",""}, {"色","ColorName",""}, {"３ヶ月前の受注数","OrderLast3",""}, {"２ヶ月前の受注数","OrderLast2",""}, {"先月の受注数","OrderLast1",""}, {"過去３ヶ月の平均受注数","OrderAV",""}, {"３ヶ月前の出荷数","ShipLast3",""}, {"２ヶ月前の出荷数","ShipLast2",""}, {"先月の出荷数","ShipLast1",""}, {"過去３ヶ月の平均出荷数","ShipAV",""}, {"EC販売在庫","Amount",""}, {"在庫管理","AmountFlg",""}, }; private final static String[][] SICSV_LACK_LIST_TITLE_NAME = { {"在庫コード","IndividualCode",""}, {"商品名","CmdtyName",""}, {"ブランド","MakerName",""}, {"カラー","ColorName",""}, {"仕入先","StockName",""}, {"過去1週間の注文数","Order0",""}, {"過去1ヶ月の注文数","Order1",""}, {"1ヶ月前〜2ヶ月前の注文数","Order2",""}, {"2ヶ月前〜3ヶ月前の注文数","Order3",""}, {"帳簿在庫","RealAmount",""}, {"EC在庫（全国）","EcAmount",""}, {"EC在庫（対象支店）","TargetAmount",""}, {"キープ数","KeepAmount",""}, {"予約数","ReserveAmount",""}, {"発注済み未入荷数","HacchuAmount",""}, {"全ての未入荷数","HacchuAmountAll",""}, {"在庫率","StockRate",""}, {"入荷予定コメント","ArrivalScheduleMsg",""}, {"販売単価","UnitPrice",""}, {"仕入単価","PurchasePrice2",""}, {"予定原価","PurchasePrice",""}, {"在庫管理","AmountFlg",""}, {"死活フラグ","DisableFlg",""}, {"フロント表示状況","FrontDisp",""} }; private final static String[][] SICSV_CMDTY_ALLOCATION_LIST_TITLE_NAME = { {"在庫コード","IndividualCode",""}, {"商品名","CmdtyName",""}, {"カラー","ColorName",""}, {"区分","Status",""}, {"数量","Amount",""}, {"番号","Number",""}, {"顧客名","CustName",""}, {"配送先名","DeliveryAddressee"}, {"住所","Address",""}, {"担当支店","Branch",""}, {"担当者","Charge",""}, {"入荷メール","SendMailDateTime",""}, }; private final static String[][] SICSV_SALES_DATA_LIST_TITLE_NAME = { {"カテゴリ名","CtgryName",""}, {"親コード","CmdtyCode",""}, {"在庫コード","IndividualCode",""}, {"商品名","CmdtyName",""}, {"カラー","ColorName",""}, {"ブランド","MakerName",""}, {"数量","Amount",""}, {"売上金額（税抜）","Price",""}, {"粗利（税抜）","Gain",""}, {"粗利率","GainRate",""} }; private final static String[][] SICSV_URIAGE_LIST6_TITLE_NAME = { {"支店名","BranchName",""}, {"在庫コード","IndividualCode",""}, {"商品名","CmdtyName",""}, {"色","ColorName",""}, {"６ヶ月前の受注数","OrderLast6",""}, {"５ヶ月前の受注数","OrderLast5",""}, {"４ヶ月前の受注数","OrderLast4",""}, {"３ヶ月前の受注数","OrderLast3",""}, {"２ヶ月前の受注数","OrderLast2",""}, {"先月の受注数","OrderLast1",""}, {"過去６ヶ月の平均受注数","OrderAV",""}, {"６ヶ月前の出荷数","ShipLast6",""}, {"５ヶ月前の出荷数","ShipLast5",""}, {"４ヶ月前の出荷数","ShipLast4",""}, {"３ヶ月前の出荷数","ShipLast3",""}, {"２ヶ月前の出荷数","ShipLast2",""}, {"先月の出荷数","ShipLast1",""}, {"過去６ヶ月の平均出荷数","ShipAV",""}, {"EC販売在庫","Amount",""}, {"在庫管理","AmountFlg",""}, }; private final static String[][] SICSV_CUST_ADDRESS_VIEW_TITLE_NAME = { {"時期","InitMonth",SICSV_DATE_TYPE}, {"都道府県","Address1",""}, {"件数","CustCount",""} }; private final static String[][] SICSV_CUST_ROUTE_VIEW_TITLE_NAME = { {"時期","InitMonth",SICSV_DATE_TYPE}, {"登録経路","Route",""}, {"件数","CustCount",""} }; private final static String[][] SICSV_CUST_JOB_VIEW_TITLE_NAME = { {"時期","InitMonth",SICSV_DATE_TYPE}, {"営業形態","Job",""}, {"件数","CustCount",""} }; private final static String[][] SICSV_KAITORILATEST_LIST_TITLE_NAME = { {"在庫コード","IndividualCode",""}, {"入庫番号","StoreNumber",""}, {"入庫日","InitDateTime",SICSV_DATE_TYPE}, {"支店名","BranchName",""}, {"入庫担当者","ChargeName",""}, {"入庫数","Amount",""}, {"仕入総額","PurchasePrice",""}, {"仕入単価","UnitPurchase",""}, {"加工総額","ProcessingExpence",""}, {"加工単価","UnitProcess",""}, {"区分","StoreType",""}, {"商品名","CmdtyName",""} }; private final static String[][] SICSV_ORDER_ROUTE_VIEW_TITLE_NAME = { {"時期","InitMonth",SICSV_DATE_TYPE}, {"受注日","InitDate",SICSV_DATE_TIME_TYPE}, {"受注番号","OrderCode",""}, {"受注金額","Total",""}, {"受注経路","OrderRoute",""}, {"会員種別","memberlevel"}, {"受注数カウント","cnt",""} }; private final static String[][] SICSV_URIAGEBASE_LIST_TITLE_NAME = { {"出荷日","Ship",SICSV_DATE_TYPE}, {"受注番号","OrderCode",""}, {"在庫コード","IndividualCode",""}, {"商品名","CmdtyName",""}, {"カラー","ColorName",""}, {"BG卸価","UnitPrice",""}, {"数量","Amount",""}, {"販売合計","TotalOfCmdty",""}, {"送料","DeliveryFee",""}, {"代引手数料","Fee",""}, {"値引金額","SumOfDiscount",""}, {"ポイント使用額","SumByPoint",""}, {"売上金額","TotalOfPriceIncTax",""}, {"売上金額（税抜）","TotalOfPrice",""}, {"原価","TotalOfCostIncTax",""}, {"原価（税抜）","TotalOfCost",""}, {"粗利","TotalOfGainIncTax",""}, {"粗利（税抜）","TotalOfGain",""}, {"受注経路","OrderRoute",""}, {"顧客コード","CustCode",""}, {"営業形態","Job",""}, {"会員種別","memberlevel"}, {"支払区分","PayMethodName",""}, {"担当支店","BranchName",""}, {"担当者","ChargeName",""}, {"中古新品区分","UsedNewFlg",""}, {"ブランド名","MakerName",""}, {"親カテゴリ名","MotherCtgryName",""}, {"子カテゴリ名","CtgryName",""}, {"受注数カウント","OrderCount",""} }; //ポイント基礎データ private final static String[][] SICSV_POINTRECORD_LIST_TITLE_NAME = { {"顧客コード","CustCode",""}, {"データ取得日","InitDateTime",SICSV_DATE_TYPE}, {"有効ポイント","ValidPoint",""}, {"使用ポイント","UsedPoint",""}, {"無効ポイント","InvalidPoint",""}, {"失効ポイント","LostPoint",""}, {"合計ポイント","TotalPoint",""}, {"未確定ポイント","UnconfirmedPoint",""}, {"最終獲得日時","LastIssue",SICSV_DATE_TIME_TYPE}, }; //支払一覧表 private final static String[][] SICSV_HACCHU_PAYMENT_LIST_TITLE_NAME = { {"仕入先コード","StockCode",""}, {"仕入先名称","StockName",""}, {"仕入担当者","ChargeName",""}, {"仕入金額","PurchaseTotal",""}, {"送料","DeliveryTotal",""}, {"支払金額","PaymentTotal",""}, {"支払残高","TotalOfPrice",""}, }; //支払明細表 private final static String[][] SICSV_HACCHU_PAYMENT_DETAIL_LIST_TITLE_NAME = { {"計上日","PaymentDate",SICSV_DATE_TYPE}, {"仕入先コード","StockCode",""}, {"仕入先名称","StockName",""}, {"発注番号","HacchuCode",""}, {"発注担当者","ChargeName",""}, {"在庫コード","IndividualCode",""}, {"商品名","CmdtyName",""}, {"数量","Amount",""}, {"請求金額","PaymentPrice1",""}, {"支払金額","PaymentPrice2",""}, {"備考","memo",""}, }; //発注ステータス private final static String[][] SICSV_HACCHU_STATUS_LIST_TITLE_NAME = { {"計上日","PaymentDate",SICSV_DATE_TYPE}, {"仕入先コード","StockCode",""}, {"仕入先名称","StockName",""}, {"発注番号","HacchuCode",""}, {"発注支店","BranchName",""}, {"発注担当者","ChargeName",""}, {"在庫コード","IndividualCode",""}, {"商品名","CmdtyName",""}, {"ブランド","MakerName",""}, {"数量","Amount",""}, {"仕入単価","PurchasePrice",""}, {"送料","DeliveryFee",""}, {"請求金額","PaymentPriceIncTax",""}, {"請求金額税抜","PaymentPrice",""}, {"受注番号","OrderCode",""}, {"顧客コード","CustCode",""}, {"税率","TaxRate",""}, {"備考","memo",""}, }; //入荷予定チェックリスト private final static String[][] SICSV_ARRIVALSCHEDULEMSG_LIST_TITLE_NAME = { {"在庫コード","individualcode",""}, {"商品名","cmdtyname",""}, {"カラー","colorname",""}, {"ブランド","makername",""}, {"EC在庫","amount",""}, {"死活フラグ","disableflg",""}, {"入荷予定コメント","arrivalschedulemsg",""}, {"フロント表示状況","situation",""} }; //各種入出庫明細表 private final static String[][] SICSV_HISTORY_DETAIL_LIST_TITLE_NAME = { {"入出庫日","calcdatetime",""}, {"入出庫担当者","chargename",""}, {"入出庫支店","branchname",""}, {"在庫コード","individualcode",""}, {"商品名","cmdtyname",""}, {"カラー","colorname",""}, {"セグメント","segment",""}, {"入出庫区分","type",""}, {"入出庫番号","number",""}, {"入出庫数量","amount",""}, {"仕入総額","purchaseprice",""}, {"加工総額","processsingexpence",""}, {"仕入原価","costinctax",""}, {"仕入原価（税抜）","cost",""}, {"受注番号","ordercode",""}, {"コメント","comment",""}, {"データ区分","flg",""} }; //欠品管理リスト（輸入品） private final static String[][] SICSV_LACK_LIST2_TITLE_NAME = { {"仕入先","StockName",""}, {"在庫コード","IndividualCode",""}, {"商品名","CmdtyName",""}, {"カラー","ColorName",""}, {"フロント表示","FrontDispFlg",""}, {"EC在庫","ECAmount",""}, {"帳簿在庫","RealAmount",""}, {"予約数","ReserveAmount",""}, {"先月の注文数","OrderAmount1",""}, {"2ヶ月前の注文数","OrderAmount2",""}, {"3ヶ月前の注文数","OrderAmount3",""}, {"BG卸価","UnitPrice",""}, {"平均原価","PurchasePrice",""}, {"直近発注単価","LastPurchase",""}, {"直近コメント","LastComment",""}, {"最終仕入日","LastShippment",SICSV_DATE_TYPE} }; //予約商品リスト private final static String[][] SICSV_RESERVE_LIST_TITLE_NAME = { {"仕入先","StockName",""}, {"在庫コード","IndividualCode",""}, {"商品名","CmdtyName",""}, {"カラー","ColorName",""}, {"ブランド","MakerName",""}, {"入荷予定コメント","ArrivalSchedulemsg",""}, {"予約数","ReserveAmount",""}, {"先月の出荷数","ShipAmount1",""}, {"2ヶ月前の出荷数","ShipAmount2",""}, {"3ヶ月前の出荷数","ShipAmount3",""} }; private final static String[][] SICSV_INVEST_POINT_LOG_LIST_TITLE_NAME = { {"ポイントコード","pointmancode",""}, {"発行ポイント数","pointofissue",""}, {"顧客コード","custcode",""}, {"受注番号","ordercode",""}, {"ポイント付与理由","comment",""}, {"登録日時","initdatetime",SICSV_DATE_TIME_TYPE}, {"管理ユーザコード","usercode",""}, {"管理ユーザ名","username",""} }; private final static String[][] SICSV_SOLDOUT_LIST_TITLE_NAME = { {"仕入先コード","stockcode",""}, {"仕入先名","stockname",""}, {"在庫コード","individualcode",""}, {"商品名","cmdtyname",""}, {"カラー","colorname",""}, {"ブランド","makername",""}, {"死活フラグ","disableflg",""}, {"販売状況","salessituation",""}, {"今月の出荷数","shippment0",""}, {"先月の出荷数","shippment1",""}, {"2ヶ月前の出荷数","shippment2",""}, {"3ヶ月前の出荷数","shippment3",""} }; private final static String[][] SICSV_CMDTYDATA_LIST_TITLE_NAME = { {"在庫コード","individualcode",""}, {"商品名","cmdtyname",""}, {"カラー","colorname",""}, {"ブランド","makername",""}, {"型式","otherName",""}, {"検品時／ピッキング時注意事項","setItem1",""}, {"同梱品情報","setitem2",""}, {"仕入先","stockname",""}, {"M価","newfixedprice",""}, {"BG卸価","bgprice",""}, {"BG卸価税抜","bgpricewithouttax",""}, {"送料","cmdtysize",""}, {"仕入価格","purchaseprice",""}, {"加工価格","processingexpence",""}, {"発注単価","purchaseprice2",""}, {"保証期間","guaranteedterm",""}, {"在庫管理フラグ","amountflg",""}, {"フロント表示フラグ","frontdispflg",""}, {"死活フラグ","disableflg",""}, {"EC在庫数","amount",""}, {"予約フラグ","rsrvenableflg",""}, {"予約可能数","rsrvamount",""}, {"問合せ区分","inquiryflg",""}, {"BGP在庫数","bgpamount",""}, {"要契約条件","contractflg",""}, {"表示状況","salessituation",""} }; private final static String[][] SICSV_DEADSTOCK_LIST_TITLE_NAME = { {"支店名","branchname",""}, {"セグメント","segment",""}, {"在庫コード","individualcode",""}, {"商品名","cmdtyname",""}, {"数量","amount",""}, {"原価","cost",""}, {"帳簿価格","stockprice",""}, {"滞留期間","period",""}, {"償却率","depreciationrate",""}, {"評価額（税込）","appraisedvalueinctax",""}, {"評価損（税込）","appraisedloseinctax",""}, {"評価損（税抜）","appraisedlose",""}, {"BG卸価","bgprice",""}, {"対象時期の処理予定","latest",""}, {"次回の処理予定","nxt",""}, {"フロント表示","frontdisp",""}, {"最終仕入日","init",SICSV_DATE_TYPE}, {"最終販売日","out",SICSV_DATE_TYPE}, {"最終評価替え日","init2",SICSV_DATE_TYPE}, {"評価開始日","latestdate",SICSV_DATE_TYPE} }; private final static String[][] SICSV_LACK_LIST_RAKUTEN_TITLE_NAME = { {"在庫コード","individualcode",""}, {"商品名","cmdtyname",""}, {"カラー","colorname",""}, {"ブランド","makername",""}, {"仕入先","stockname",""}, {"BG卸価","bgprice",""}, {"仕入価格","purchaseprice",""}, {"加工価格","processingexpence",""}, {"発注単価","purchaseprice2",""}, {"在庫管理フラグ","amountflg",""}, {"フロント表示フラグ","frontdispflg",""}, {"死活フラグ","disableflg",""}, {"状態","status",""}, {"発注数","hacchu",""}, {"EC在庫（楽天）","rakutenamount",""}, {"EC在庫（物流）","centeramount",""}, {"EC在庫（その他）","otheramount",""}, {"EC在庫（合計）","totalamount",""}, {"発注残（楽天）","rakutenhacchu",""}, {"発注残（物流）","centerhacchu",""}, {"発注残（その他）","otherhacchu",""}, {"発注残（合計）","totalhacchu",""}, {"楽天受注数（当月）","order1",""}, {"楽天受注数（1ヶ月前）","order2",""}, {"楽天受注数（2ヶ月前）","order3",""}, {"楽天受注数（3ヶ月前）","order4",""}, {"楽天受注数（月間平均）","orderav1",""}, {"BG受注数（当月）","order5",""}, {"BG受注数（1ヶ月前）","order6",""}, {"BG受注数（2ヶ月前）","order7",""}, {"BG受注数（3ヶ月前）","order8",""}, {"BG受注数（月間平均）","orderav2",""} }; private final static String[][] SICSV_STOCKNUMBER_LIST_TITLE_NAME = { {"在庫コード","individualcode",""}, {"商品名","cmdtyname",""}, {"棚番","stocknumber",""} }; private final static String[][] SICSV_FLAGUPDATELOG_LIST_TITLE_NAME = { {"ログ番号","updatenumber",""}, {"在庫コード","individualcode",""}, {"商品名","cmdtyname",""}, {"更新項目","updateflagname",""}, {"BG卸価（更新後）","updateflagvalue",""}, {"更新ユーザーコード","updateuser",""}, {"更新ユーザー名","username",""}, {"更新日時","initdatetime",SICSV_DATE_TIME_TYPE} }; private final static String[][] SICSV_MAKER_LIST_TITLE_NAME = { {"ブランドコード","makercode",""}, {"ブランド名","makername",""}, {"ブランド名別名１","othername1",""}, {"ブランド名別名２","othername2",""}, {"電話番号","tel",""}, {"URL","url",""}, {"登録日時","initdatetime",SICSV_DATE_TIME_TYPE}, {"更新日時","updatedatetime",SICSV_DATE_TIME_TYPE}, {"フロント表示フラグ","enabledflg",""}, {"要契約フラグ","contractflg",""}, {"問合せ先部署","referencepost",""}, {"問合せ先番号","referencenumber",""}, {"問合せ先メール","referencemail",""}, {"ソート順","sortorder",""}, {"メモ","memo",""} }; private final static String[][] SICSV_OPINION_LIST_TITLE_NAME = { {"ご意見番号","opinionnumber",""}, {"顧客コード","custcode",""}, {"顧客名","custname",""}, {"メールアドレス","email",""}, {"住所","address",""}, {"営業形態","job",""}, {"営業担当者","chargename",""}, {"受注番号","ordercode",""}, {"表題","title",""}, {"コメント","comment",""}, {"登録日時","initdatetime",SICSV_DATE_TIME_TYPE}, {"登録経路","route",""} }; private final static String[][] SICSV_COSTCOMPARE_LIST_TITLE_NAME = { {"在庫コード","individualcode",""}, {"月初在庫数","am1",""}, {"月初仕入単価","pp1",""}, {"月初加工単価","pe1",""}, {"月内仕入総数","am2",""}, {"月内仕入総額","pp2",""}, {"月内加工総額","pe2",""}, {"平均仕入単価","pp3",""}, {"平均加工単価","pe3",""}, {"現在の仕入単価","pp4",""}, {"現在の加工単価","pe4",""}, {"原価変動","checkflg",""} }; private final static String[][] SICSV_HACCHU_DETAIL_LIST_TITLE_NAME = { {"予定納期","arrivalplandate",SICSV_DATE_TYPE}, {"予定時刻","arrivalplantime",""}, {"注文日","hacchuupdatedatetime",""}, {"発注番号","hacchucode",""}, {"仕入先","stockname",""}, {"発注担当者","charge",""}, {"在庫コード","individualcode",""}, {"商品名","cmdtyname",""}, {"ブランド","makername",""}, {"カラー","colorname",""}, {"数量","amount",""}, {"納品先","branchname",""}, {"仕入日","shippmentdate",""}, {"ステータス","status",""}, {"備考","comment",""} }; private final static String[][] SICSV_WAREHOUSE_STORE_LIST_TITLE_NAME = { {"伝票番号","column1",""}, {"伝票区分","column2",""}, {"作成日時","column3",""}, {"入荷予定日","column4",""}, {"発注日時","column5",""}, {"変更前納期","column6",""}, {"仕入先コード","column7",""}, {"仕入先名称１","column8",""}, {"仕入先名称２","column9",""}, {"（予備）","column10",""}, {"（予備）","column11",""}, {"作業番号","column12",""}, {"元伝票番号","column13",""}, {"対応実績伝票番号","column14",""}, {"作業状態","column15",""}, {"差異","column16",""}, {"登録担当者ID","column17",""}, {"登録担当者名","column18",""}, {"摘要","column19",""}, {"（予備）","column20",""}, {"伝票更新日時","column21",""}, {"明細番号","column22",""}, {"（予備）","column23",""}, {"品目コード","column24",""}, {"バーコード","column25",""}, {"ロケーション","column26",""}, {"品目名１","column27",""}, {"品目名２","column28",""}, {"入数","column29",""}, {"箱数","column30",""}, {"数量","column31",""}, {"単位","column32",""}, {"ロット１","column33",""}, {"ロット２","column34",""}, {"在庫状態コード","column35",""}, {"在庫状態名","column36",""}, {"（予備）","column37",""}, {"（予備）","column38",""}, {"備考","column39",""}, {"（予備）","column40",""}, {"（予備）","column41",""}, {"（予備）","column42",""}, {"明細更新日時","column43",""} }; private final static String[][] SICSV_WAREHOUSE_SHIP_LIST_TITLE_NAME = { {"伝票番号","column1",""}, {"伝票区分","column2",""}, {"伝票日付","column3",""}, {"納期","column4",""}, {"出荷予定日","column5",""}, {"作業倉庫コード","column6",""}, {"作業倉庫名","column7",""}, {"出荷先コード","column8",""}, {"出荷先名称１","column9",""}, {"出荷先名称２","column10",""}, {"名称カナ","column11",""}, {"略称","column12",""}, {"担当者名","column13",""}, {"敬称","column14",""}, {"郵便番号","column15",""}, {"住所１","column16",""}, {"住所２","column17",""}, {"TEL","column18",""}, {"FAX","column19",""}, {"共通取引先コード","column20",""}, {"GLN","column21",""}, {"直送先コード","column22",""}, {"直送先名称１","column23",""}, {"直送先名称２","column24",""}, {"直送先カナ","column25",""}, {"略称","column26",""}, {"担当者名","column27",""}, {"敬称","column28",""}, {"郵便番号","column29",""}, {"住所１","column30",""}, {"住所２","column31",""}, {"TEL","column32",""}, {"FAX","column33",""}, {"共通取引先コード","column34",""}, {"GLN","column35",""}, {"対応出荷先コード","column36",""}, {"（予備）","column37",""}, {"（予備）","column38",""}, {"作業番号","column39",""}, {"元伝票番号","column40",""}, {"対応実績伝票番号","column41",""}, {"作業状態","column42",""}, {"差異","column43",""}, {"登録担当者ID","column44",""}, {"登録担当者名","column45",""}, {"摘要","column46",""}, {"（予備）","column47",""}, {"伝票更新日時","column48",""}, {"明細番号","column49",""}, {"（予備）","column50",""}, {"品目コード","column51",""}, {"バーコード","column52",""}, {"ロケーション","column53",""}, {"品目名１","column54",""}, {"品目名２","column55",""}, {"入数","column56",""}, {"箱数","column57",""}, {"数量","column58",""}, {"単位","column59",""}, {"ロット１","column60",""}, {"ロット２","column61",""}, {"在庫状態コード","column62",""}, {"在庫状態名","column63",""}, {"（予備）","column64",""}, {"（予備）","column65",""}, {"備考","column66",""}, {"（予備）","column67",""}, {"（予備）","column68",""}, {"（予備）","column69",""}, {"明細更新日時","column70",""} }; private final static String[][] SICSV_WAREHOUSE_CMDTY_LIST_TITLE_NAME = { {"バーコード","column1",""}, {"品目コード","column2",""}, {"品目名１","column3",""}, {"品目名２","column4",""}, {"品目名カナ","column5",""}, {"略称","column6",""}, {"分類コード","column7",""}, {"推奨ロケーション","column8",""}, {"（予備）","column9",""}, {"単位","column10",""}, {"単価","column11",""}, {"標準原単価","column12",""}, {"発注点","column13",""}, {"入数","column14",""}, {"（予備）","column15",""}, {"明細更新日時","column16",""} }; private final static String[][] SICSV_SHIPPMENT_LIST_TITLE_NAME = { {"受注番号","ordercode",""}, {"受注日時","initdatetime",""}, {"顧客名","custname",""}, {"配送先名称","deliveryaddressee",""}, {"担当支店コード","branchcode",""}, {"担当者コード","chargecode",""}, {"在庫コード","individualcode",""}, {"商品名","cmdtyname",""}, {"数量","amount",""}, {"出荷拠点","shipbranch",""}, {"出荷数","orderallocationnumber",""}, {"入金日","receiptdate",""}, {"出荷日","shippmentdate",""}, {"受注状態","status",""} }; private final static String[][] SICSV_ACTIVEUSER_LIST_TITLE_NAME = { {"時期","season",""}, {"全会員","totalcount",""}, {"購入履歴あり","historycount",""}, {"アクティブユーザ","activecount",""}, {"比率（全会員） ","totalrate",""}, {"比率（履歴有）","historyrate",""} }; private final static String[][] SICSV_NODELIVERY_LIST_TITLE_NAME = { {"受注番号","ordercode",""}, {"在庫コード","individualcode",""}, {"商品名","cmdtyname",""}, {"出荷支店","shipbranch",""}, {"担当支店","branchname",""}, {"担当者","chargename",""}, {"受注日時","initdatetime",""}, {"支払方法","paymethodname",""}, {"入金状況","payment",""}, {"対処結果","comment1",""}, {"備考","comment2",""} }; private final static String[][] SICSV_NOPAYMENT_LIST_TITLE_NAME = { {"支店コード","branchcode",""}, {"担当支店","branchname",""}, {"担当者","ordercharge",""}, {"受注番号","ordercode",""}, {"受注日時","initdatetime",""}, {"支払方法","paymethodname",""}, {"顧客名","custname",""}, {"取引条件","receivableflg",""}, {"営業担当者","chargename",""}, {"受注金額","price",""}, {"支払金額","price2",""}, {"最終出荷日","shippmentdate",""}, {"対処結果","comment1",""}, {"備考","comment2",""} }; private final static String[][] SICSV_BRANCH_DEADSTOCK_LIST_TITLE_NAME = { {"支店名","BranchName",""}, {"在庫コード","IndividualCode",""}, {"商品名","CmdtyName",""}, {"EC在庫","Amount",""}, {"最終入庫日","LastStore",""}, {"滞留期間","Period",""}, {"送料区分","DeliveryType",""}, {"死活フラグ","DisableFlg",""} }; private final static String[][] SICSV_REPEAT_SALES_LIST_TITLE_NAME = { {"在庫コード","IndividualCode",""}, {"商品名","CmdtyName",""}, {"ブランド","MakerName",""}, {"カラー","ColorName",""}, {"仕入先","StockName",""}, {"0〜1ヶ月の新規購入件数","new01",""}, {"0〜1ヶ月のリピート購入件数","rep01",""}, {"1〜2ヶ月の新規購入件数","new12",""}, {"1〜2ヶ月のリピート購入件数","rep12",""}, {"2〜3ヶ月の新規購入件数","new23",""}, {"2〜3ヶ月のリピート購入件数","rep23",""}, {"3〜4ヶ月の新規購入件数","new34",""}, {"3〜4ヶ月のリピート購入件数","rep34",""}, {"4〜5ヶ月の新規購入件数","new45",""}, {"4〜5ヶ月のリピート購入件数","rep45",""}, {"5〜6ヶ月の新規購入件数","new56",""}, {"5〜6ヶ月のリピート購入件数","rep56",""}, {"今までの新規購入件数","new",""}, {"今までのリピート購入件数","rep",""}, }; private final static String[][] SICSV_EG_POINT_LIST_TITLE_NAME = { {"受注番号","OrderCode",""}, {"計上日","ShippmentDate",""}, {"計上ポイント","PointOfIssue",""}, {"ポイント区分","Type",""} }; private final static String[][] SICSV_EYELASH_SALES_LIST_TITLE_NAME = { {"受注番号","OrderCode",""}, {"計上日","ShippmentDate",""}, {"在庫コード","IndividualCode",""}, {"商品名","CmdtyName",""}, {"ブランド名","MakerName",""}, {"数量","Amount",""}, {"単価","Price",""}, {"販売総額","Total",""}, {"原価","Cost",""}, {"原価総額","TotalCost",""}, {"支払額","Payment",""}, {"担当支店名","BranchName",""}, {"担当者名","ChargeName",""} }; private final static String[][] SICSV_UNAPPROVAL_DATA_LIST_TITLE_NAME = { {"在庫コード","IndividualCode",""}, {"商品名","CmdtyName",""}, {"登録日","InitDateTime",SICSV_DATE_TYPE}, {"入出庫番号","Number",""}, {"支店","BranchName",""}, {"担当者","ChargeName",""}, {"数量","Amount",""}, {"仕入価格","PurchasePrice",""}, {"加工価格","ProcessingExpence",""}, {"区分","Type",""}, {"備考","Comment",""} }; private final static String[][] SICSV_RANKING_ANALYSIS_LIST_TITLE_NAME = { {"顧客コード","CustCode",""}, {"顧客名","CustName",""}, {"会員種別","MemberLevelCode",""}, {"営業担当者","ChargeName",""}, {"在庫コード","IndividualCode",""}, {"商品名","CmdtyName",""}, {"ブランド","MakerName",""}, {"カラー","ColorName",""}, {"売上総額","Sales",""}, {"売上総数","Amount",""}, {"注文回数","Count",""} }; private final static String[][] SICSV_CUST_SALES_DATA_LIST_TITLE_NAME = { {"受注番号","OrderCode",""}, {"顧客コード","CustCode",""}, {"顧客名","CustName",""}, {"配送先名称","DeliveryName",""}, {"住所１","Address1",""}, {"住所２","Address2",""}, {"住所３","Address3",""}, {"出荷日","ShippmentDate",""}, {"在庫コード","IndividualCode",""}, {"商品名","CmdtyName",""}, {"単価","Price",""}, {"数量","Amount",""}, {"合計金額","TotalPrice",""}, {"区分","Type",""} }; private final static String[][] SICSV_PURCHASECOMMENT_LIST_TITLE_NAME = { {"記入日","InitDateTime",""}, {"更新日","UpdateDateTime",""}, {"顧客コード","CustCode",""}, {"顧客名","CustName",""}, {"分類","MemoStatus",""}, {"記入者","UserName",""}, {"最終更新者","LastUpdateUserName",""}, {"メモ","Comment",""} }; //各機能別に対するファイル名の先頭語 public final static String[] SIPREFIX_FILE_NAME = { "cmdty_list_",//0.商品 "order_list_",//1.受注 "shop_list_",//2.ショップ "cust_list_",//3.顧客 "pointman_all_",//4.ポイント "pointman_shop_",//5.ポイントショップ "pointman_cust_",//6.ポイント顧客 "sale_shop_",//7.売上一覧、ショップ "sale_cmdty_",//8.売上一覧、商品 "member_level_",//9:会員種別 "cust_attr_",//10:会員属性 "cust_hobby_" ,//11:会員趣味 "cust_address_" ,//12:会員アドレス帳 "wrapping_" ,//13:ラッピング "cmdty_stndrd_" ,//14:商品規格関連 "stndrd_name_" ,//15:規格名称 "stndrd_content_" ,//16:規格内容 "order_header_" ,//17:受注ヘッダ "order_delivery_" , //18:受注配送先 "order_detail_",// 19:受注明細 "access_date_",//20:アクセス分析日付 "access_time_",//21:アクセス分析時間 "rfm_order_",//22:RFM分析 "cmdty_ctgry_",//23:商品カテゴリー "conn_cmdty_",//24:関連商品 "stock_status_",//25:在庫状況 "stock_title_", //26:仕入先 "payee_info_", //27:仕入先情報 "pay_method_", //28:支払方法 "pay_method_fee_", //29:支払方法手数料 "delivery_time_",//30:時間帯 "catgry__",//31:カテゴリ "sale_shop_",//32.売上一覧、ショップ //7.2.0 ST0542 追加 "access_month_",//33:アクセス分析 年月 //7.2.0 ST0546 追加 "access_dayofweek_",//34:アクセス分析 曜日 //7.2.0 ST0546 追加 "cmdty_list_",//35:商品マスタ（親） //7.3.0 PI-NES0501 追加 "individual_list_",//36:商品マスタ（個別） //7.3.0 PI-NES0501 追加 "stock_list_",//37:支店在庫マスタ //7.3.0 PI-NES0501 追加 "inquiry_list_",//38:探してほしいマスタ //7.3.0 PI-NES0501 追加 "kaitori_list_",//39:買取入庫一覧 "inventory_list_",//40:棚卸基礎データ "unapproval_store_list_",//41:未承認入庫データ "unapproval_ship_list_",//42:未承認出庫データ "keep_list_",//43:キープデータ "mikansai_list_",//44:出荷済未完済リスト "uriage_list_",//45:過去3ヶ月売上リスト "lack_list_",//46:欠品管理リスト "cmdty_allocation_",//47:商品引当管理 "sales_data_"//48:販売分析データ ,"uriage_list6_"//49:過去6ヶ月売上リスト ,"custcount_address_"//50:都道府県別顧客登録リスト ,"custcount_route_"//51:登録経路別顧客登録リスト ,"custcount_job_"//52:営業形態別顧客登録リスト ,"kaitorilatest_list_"//53:最新買取一覧 ,"order_route_"//54:受注基礎データ ,"uriagebase_list_"//55:売上基礎データ ,"pointrecord_list_"//56:ポイント基礎データ ,"hacchupayment_list_"//57:支払一覧表 ,"hacchupayment_detail_list_"//58:支払明細表 ,"hacchu_status_list_"//59:支払ステータス ,"arrivalschedulemsg_list_"//60:入荷予定チェックリスト ,"history_detail_list_"//61:各種入出庫明細表 ,"lack_list2_"//62:欠品管理リスト（輸入品） ,"reserve_list_"//63:予約商品リスト ,"invest_point_log_"//64:ポイント付与履歴 ,"soldout_list_"//65:売り切れチェックリスト ,"cmdtydata_list_"//66:商品詳細データリスト ,"deadstock_list_"//67:滞留在庫チェックリスト ,"lack_list_rakuten_"//68:楽天欠品管理表 ,"stocknumber_list_"//69:棚番リスト ,"updatelog_list_"//70:商品マスタ更新履歴 ,"maker_list_"//71:ブランドマスタ ,"opinion_list_"//72:ご意見ボックス ,"costcompare_list_"//73:原価比較 ,"store_list_"//74:納品リスト ,"in_"//75:入荷予定リスト ,"out_"//76:出荷指示リスト ,"warehouse_cmdty_list_"//77:品目台帳データ ,"shippment_list_"//78:出荷管理 ,"activeuser_list_"//79:アクティブユーザCSV ,"nodelivery_list_"//80:未出荷受注リスト ,"nopayment_list_"//81:出荷済未入金受注リスト ,"branch_deadstock_list_"//82:支店滞留在庫リスト ,"repeat_sales_list_"//83:リピート売上リスト ,"eg_point_list_"//84:EGポイントリスト ,"eyelash_sales_list"//85:まつげ商材売上リスト ,"decide_all_list"//86:未承認入出庫（一括決裁） ,"rankig_analysis_list"//87:ランキング分析 ,"cust_sales_data_list"//88:顧客別販売データ ,"purchasecomment_list"//89:特記事項メモ }; //ソート public final static String[][][] SISORT_NAME_LIST = { {{"ShopCode","0"},{"CmdtyCode","0"}}//0.商品 ,{{"",""}}//1.受注 ,{{"MallShopCode","0"}}//2.ショップ ,{{"CustCode","1"}}//3.顧客 ,{{"",""}}//4.ポイント ,{{"",""}}//5.ポイントショップ ,{{"",""}}//6.ポイント顧客 ,{{"",""}}//7.売上一覧、ショップ ,{{"",""}}//8.売上一覧、商品 ,{{"MemberLevelCode","0"}}//9:会員種別 ,{{"AttrCode","0"}}//10:会員属性 ,{{"CustCode","0"},{"HobbyCode","0"}}//11:会員趣味 ,{{"CustCode","0"},{"AddressCode","0"}}//12:会員アドレス帳 ,{{"ShopCode","0"},{"WrappingCode","0"}}//13:ラッピング ,{{"ShopCode","0"},{"CmdtyCode","0"}}//14:商品規格関連 ,{{"ShopCode","0"},{"StndrdCode","0"}}//15:規格名称 ,{{"ShopCode","0"},{"StndrdCode","0"},{"ElementCode","0"}}//16:規格内容 ,{{"OrderCode","0"}}//17:受注ヘッダ ,{{"OrderCode","0"},{"DeliveryCode","0"}}//18:受注配送先 ,{{"OrderCode","0"},{"DeliveryCode","0"},{"DetailCode","0"}}// 19:受注明細 ,{{"",""}}// 20:アクセス分析 ,{{"",""}}// 21:アクセス分析 ,{{"",""}}// 22:RFM分析 ,{{"ShopCode","0"},{"CmdtyCode","0"},{"CtgryCode","0"}}//23:商品カテゴリー ,{{"ShopCode","0"},{"CmdtyCode","0"},{"ConnShopCode","0"},{"ConnCmdtyCode","0"}}//24:関連商品 ,{{"StockStatusCode","0"}}//25:在庫状況 ,{{"ShopCode","0"},{"StockCode","0"}}//26:仕入先 ,{{"MallShopCode","0"},{"PayMethodCode","0"},{"PayeeCode","0"}}//27:仕入先情報 ,{{"MallShopCode","0"},{"PayMethodCode","0"}}//28:支払方法 ,{{"MallShopCode","0"},{"PayMethodCode","0"},{"PriceTo","0"}}//29:支払方法手数料 ,{{"MallShopCode","0"},{"DeliveryTypeCode","0"},{"DeliveryTimeFrom","0"},{"DeliveryTimeTo","0"}}//30:時間帯 ,{{"CtgryCode","0"},{"CtgryName","0"}}//31:カテゴリ ,{{"",""}}// 32:売上一覧 //7.2.0 ST0542 追加 ,{{"",""}}// 33:アクセス分析 年月 //7.2.0 ST0546 追加 ,{{"",""}}// 34:アクセス分析 曜日 //7.2.0 ST0546 追加 ,{{"ShopCode","0"},{"CmdtyCode","0"}}//35.商品(親） ,{{"ShopCode","0"},{"CmdtyCode","0"},{"IndividualCode","0"}}//36.商品(在庫） ,{{"ShopCode","0"},{"CmdtyCode","0"},{"IndividualCode","0"},{"BranchCode","0"}}//37.支店別在庫 ,{{"",""}}//38.探してほしいマスタ ,{{"",""}}//39.買取入庫リスト ,{{"",""}}//40.棚卸基礎データ ,{{"",""}}//41.未承認入庫データ ,{{"",""}}//42.未承認出庫データ ,{{"",""}}//43.キープデータ ,{{"",""}}//44.出荷済未完済リスト ,{{"",""}}//45.過去3ヶ月売上リスト ,{{"",""}}//46.欠品管理リスト ,{{"",""}}//47.商品引当管理 ,{{"",""}}//48.販売分析データ ,{{"",""}}//49.過去6ヶ月売上リスト ,{{"InitMonth","0"}}//50:都道府県別顧客登録リスト ,{{"InitMonth","0"}}//51:登録経路別顧客登録リスト ,{{"InitMonth","0"}}//52:営業形態別顧客登録リスト ,{{"IndividualCode","0"}}//53:最新買取一覧 ,{{"InitDate","0"}}//54:受注基礎データ ,{{"Ship","0"},{"OrderCode","0"},{"IndividualCode","0"}}//55:売上基礎データ ,{{"InitDateTime","0"},{"CustCode","0"}}//56:ポイント基礎データ ,{{"StockCode","0"}}//57:支払一覧表 ,{{"StockCode","0"},{"PaymentDate","0"},{"inx","0"},{"hacchuCode","0"},{"IndividualCode","0"}}//58:支払明細票 ,{{"PaymentDate","0"},{"StockCode","0"},{"inx","0"},{"hacchuCode","0"},{"IndividualCode","0"}}//59:支払ステータス ,{{"individualcode","0"}}//60:入荷予定チェックリスト ,{{"calcdatetime","0"}}//61:各種入出庫明細表 ,{{"",""}}//62:欠品管理リスト（輸入品） ,{{"",""}}//63:予約商品リスト ,{{"initdatetime","0"}}//64:ポイント付与履歴 ,{{"stockcode","0"},{"makername","0"},{"cmdtyname","0"},{"individualcode","0"}}//65:売り切れチェックリスト ,{{"",""}}//66:商品詳細データリスト ,{{"",""}}//67:滞留在庫チェックリスト ,{{"",""}}//68:欠品管理リスト（楽天） ,{{"individualcode","0"}}//69:棚番リスト ,{{"individualcode","0"},{"updatenumber","0"}}//70:商品マスタ更新履歴 ,{{"makercode","1"}}//71:ブランドマスタ ,{{"opinionnumber","1"}}//72:ご意見ボックス ,{{"",""}}//73:原価比較 ,{{"",""}}//74:納品リスト ,{{"",""}}//75:入荷予定リスト ,{{"",""}}//76:出荷指示リスト ,{{"",""}}//77:品目台帳データ ,{{"ordercode","1"}}//78:出荷管理 ,{{"season","0"}}//79:アクティブユーザCSV ,{{"ordercode","0"},{"individualcode","0"}}//80:未出荷受注リスト ,{{"branchcode","0"},{"ordercode","0"}}//81:出荷済未入金受注リスト ,{{"",""}}//82:支店滞留在庫リスト ,{{"",""}}//83:リピート売上リスト ,{{"",""}}//84:EGポイントリスト ,{{"",""}}//85:まつげ商材売上リスト ,{{"",""}}//86:未承認入出庫（一括決裁） ,{{"",""}}//87:ランキング分析 ,{{"",""}}//88:顧客別販売データ ,{{"",""}}//89:特記事項メモ }; //タイトルリスト private final static String[][][] SICSV_TITLE_NAME = { SICSV_CMDTY_TITLE_NAME//0.商品 ,SICSV_ORDER_TITLE_NAME//1.受注 ,SICSV_SHOP_TITLE_NAME//2.ショップ ,SICSV_CUST_TITLE_NAME//3.顧客 ,SICSV_POINTMAN_ALL_TITLE_NAME//4.ポイント ,SICSV_POINTMAN_SHOP_TITLE_NAME//5.ポイントショップ ,SICSV_POINTMAN_CUST_TITLE_NAME//6.ポイント顧客 ,SICSV_SALE_SHOP_TITLE_M_NAME//7.売上一覧、ショップ(モール一括決済用) //7.2.0 ST0542 修正 ,SICSV_SALE_CMDTY_TITLE_NAME//8.売上一覧、商品 ,SICSV_MEMBER_LEVEL_TITLE_NAME //9:会員種別 ,SICSV_CUST_ATTR_TITLE_NAME //10:会員属性 ,SICSV_CUST_HOBBY_TITLE_NAME //11:会員趣味 ,SICSV_CUST_ADDRESS_TITLE_NAME //12:会員アドレス帳 ,SICSV_WRAPPING_TITLE_NAME //13:ラッピング ,SICSV_CMDTY_STNDRD_TITLE_NAME //14:商品規格関連 ,SICSV_STNDRD_NAME_TITLE_NAME //15:規格名称 ,SICSV_STNDRD_CONTENT_TITLE_NAME //16:規格内容 ,SICSV_ORDER_HEADER_TITLE_NAME //17:受注ヘッダ ,SICSV_ORDER_DELIVERY_TITLE_NAME //18:受注配送先 ,SICSV_ORDER_DETAIL_TITLE_NAME //19:受注明細 ,SICSV_ACCESS_DATE_TITLE_NAME //20:アクセス分析日付 ,SICSV_ACCESS_TIME_TITLE_NAME //21:アクセス分析時間 ,SICSV_RFM_ORDER_TITLE_NAME //22:RFM分析 ,SICSV_CMDTY_CTGRY_TITLE_NAME //23:商品カテゴリー ,SICSV_CONN_CMDTY_TITLE_NAME //24:関連商品 ,SICSV_STOCK_STATUS_TITLE_NAME //25:在庫状況 ,SICSV_STOCK_TITLE_NAME //26:仕入先 ,SICSV_PAYEE_INFO_TITLE_NAME //27:仕入先情報 ,SICSV_PAY_METHOD_TITLE_NAME //28:支払方法 ,SICSV_PAY_METHOD_FEE_TITLE_NAME //29:支払方法手数料 ,SICSV_DELIVERY_TIME_TITLE_NAME //30:時間帯 ,SICSV_CTGRY_TITLE_NAME//31:カテゴリ ,SICSV_SALE_SHOP_TITLE_S_NAME//32:売上一覧、ショップ //7.2.0 ST0542 追加 ,SICSV_ACCESS_MONTH_TITLE_NAME//33:アクセス分析、年月　 //7.2.0 ST0546 追加 ,SICSV_ACCESS_DAYOFWEEK_TITLE_NAME//34:アクセス分析、曜日　//7.2.0 ST0546 追加 ,SICSV_CMDTY_LIST_TITLE_NAME//商品マスタ（親） //7.3.0 PI-NES0501 追加 ,SICSV_INDIVIDUAL_LIST_TITLE_NAME//商品マスタ（個別） //7.3.0 PI-NES0501 追加 ,SICSV_STOCK_LIST_TITLE_NAME//支店在庫マスタ //7.3.0 PI-NES0501 追加 ,SICSV_INQUIRY_LIST_TITLE_NAME//探してほしいマスタ //7.3.0 PI-NES0501 追加 ,SICSV_KAITORISTOCK_LIST_TITLE_NAME//買取入庫リスト ,SICSV_INVENTORY_LIST_TITLE_NAME//棚卸基礎データ ,SICSV_UNAPPROVAL_STORE_LIST_TITLE_NAME//未承認入庫データ ,SICSV_UNAPPROVAL_SHIP_LIST_TITLE_NAME//未承認出庫データ ,SICSV_KEEP_LIST_TITLE_NAME//キープデータ ,SICSV_MIKANSAI_LIST_TITLE_NAME//出荷済未完済リスト ,SICSV_URIAGE_LIST_TITLE_NAME//過去3ヶ月売上リスト ,SICSV_LACK_LIST_TITLE_NAME//欠品管理リスト ,SICSV_CMDTY_ALLOCATION_LIST_TITLE_NAME//商品引当管理 ,SICSV_SALES_DATA_LIST_TITLE_NAME//販売分析データ ,SICSV_URIAGE_LIST6_TITLE_NAME//過去6ヶ月売上リスト ,SICSV_CUST_ADDRESS_VIEW_TITLE_NAME//都道府県別顧客登録リスト ,SICSV_CUST_ROUTE_VIEW_TITLE_NAME//登録経路別顧客登録リスト ,SICSV_CUST_JOB_VIEW_TITLE_NAME//営業形態別顧客登録リスト ,SICSV_KAITORILATEST_LIST_TITLE_NAME//最新買取一覧 ,SICSV_ORDER_ROUTE_VIEW_TITLE_NAME//受注基礎データ ,SICSV_URIAGEBASE_LIST_TITLE_NAME//売上基礎データ ,SICSV_POINTRECORD_LIST_TITLE_NAME//ポイント基礎データ ,SICSV_HACCHU_PAYMENT_LIST_TITLE_NAME//支払一覧表 ,SICSV_HACCHU_PAYMENT_DETAIL_LIST_TITLE_NAME//支払明細表 ,SICSV_HACCHU_STATUS_LIST_TITLE_NAME//支払明細表 ,SICSV_ARRIVALSCHEDULEMSG_LIST_TITLE_NAME//入荷予定チェックリスト ,SICSV_HISTORY_DETAIL_LIST_TITLE_NAME//各種入出庫明細表 ,SICSV_LACK_LIST2_TITLE_NAME//欠品管理リスト（輸入品） ,SICSV_RESERVE_LIST_TITLE_NAME//予約商品リスト ,SICSV_INVEST_POINT_LOG_LIST_TITLE_NAME//ポイント付与履歴 ,SICSV_SOLDOUT_LIST_TITLE_NAME//売り切れチェックリスト ,SICSV_CMDTYDATA_LIST_TITLE_NAME//商品詳細データリスト ,SICSV_DEADSTOCK_LIST_TITLE_NAME//滞留在庫チェックリスト ,SICSV_LACK_LIST_RAKUTEN_TITLE_NAME//欠品管理リスト（楽天） ,SICSV_STOCKNUMBER_LIST_TITLE_NAME//棚番リスト ,SICSV_FLAGUPDATELOG_LIST_TITLE_NAME//商品マスタ更新履歴 ,SICSV_MAKER_LIST_TITLE_NAME//ブランドマスタ ,SICSV_OPINION_LIST_TITLE_NAME//ご意見ボックス ,SICSV_COSTCOMPARE_LIST_TITLE_NAME//原価比較 ,SICSV_HACCHU_DETAIL_LIST_TITLE_NAME//納品リスト ,SICSV_WAREHOUSE_STORE_LIST_TITLE_NAME//入荷予定リスト ,SICSV_WAREHOUSE_SHIP_LIST_TITLE_NAME//出荷指示リスト ,SICSV_WAREHOUSE_CMDTY_LIST_TITLE_NAME//品目台帳データ ,SICSV_SHIPPMENT_LIST_TITLE_NAME//出荷管理 ,SICSV_ACTIVEUSER_LIST_TITLE_NAME//アクティブユーザCSV ,SICSV_NODELIVERY_LIST_TITLE_NAME//未出荷受注リスト ,SICSV_NOPAYMENT_LIST_TITLE_NAME//出荷済未入金受注リスト ,SICSV_BRANCH_DEADSTOCK_LIST_TITLE_NAME//支店滞留在庫リスト ,SICSV_REPEAT_SALES_LIST_TITLE_NAME//リピート売上リスト ,SICSV_EG_POINT_LIST_TITLE_NAME//EGポイントリスト ,SICSV_EYELASH_SALES_LIST_TITLE_NAME//まつげ商材売上リスト ,SICSV_UNAPPROVAL_DATA_LIST_TITLE_NAME//未承認入出庫（一括決裁） ,SICSV_RANKING_ANALYSIS_LIST_TITLE_NAME//ランキング分析 ,SICSV_CUST_SALES_DATA_LIST_TITLE_NAME//顧客別販売データ ,SICSV_PURCHASECOMMENT_LIST_TITLE_NAME//特記事項メモ }; public SICSVConf() { } /** * getTitleName * 各機能に対するタイトル名を取得します。 * @param lIndex 各機能を指すindex * @return CSVファイル名 * @throws なし */ public final static String[] getTitleName(int lIndex) { ArrayList lList=new ArrayList(); for (int ii=0;iigetCsvFileName * CSVファイル名を取得します。 * 構成：prefixName+currentDateTime.csv * @param lIndex 各機能を指すindex * @return CSVファイル名 * @throws なし */ public final static String getCsvFileName(int lIndex) { StringBuffer lFileName = new StringBuffer(); lFileName.append(SICSVConf.SIPREFIX_FILE_NAME[lIndex]); lFileName.append(new SIDateTime().getDateTimeString()); lFileName.append("."); lFileName.append(SICSVConf.SICSV_EXTENSION_NAME); return lFileName.toString(); } }