HIMART_DW
Tables (13)
prc_dw.ai_match_mst
- prd_id — varchar
- goods_no — varchar
- category_2 — varchar
- item_grp_nm — varchar
- pid — varchar
- collect_day — varchar
- match_type — varchar
- model_type — varchar
- ldg_dt — varchar
- format — =
prc_dw.comm_code
- grp_cd — varchar
- cd — varchar
- nm — varchar
- remark — varchar
- format_version — =
- location — =
prc_dw.dict_nvr_attr
- category_code — varchar
- category_v — varchar
- attribute_grp_code — varchar
- attribute_name — varchar
- attribute_code — varchar
- nvr_attr_value — varchar
- hi_opt_grp_cd — varchar
- hi_opt_grp_nm — varchar
- hi_opt_cd — varchar
- hi_opt_val — varchar
- req_attr — varchar
- sys_regr_id — varchar
- sys_reg_dtime — timestamp(6)
- sys_modr_id — varchar
- sys_mod_dtime — timestamp(6)
- format_version — =
- location — =
prc_dw.dict_nvr_attr_color
- attribute_code — varchar
- nvr_attr_color — varchar
- hi_opt_grp_cd — varchar
- hi_opt_grp_nm — varchar
- hi_opt_cd — varchar
- hi_opt_val — varchar
- sys_regr_id — varchar
- sys_reg_dtime — timestamp(6)
- sys_modr_id — varchar
- sys_mod_dtime — timestamp(6)
- format_version — =
- location — =
prc_dw.dict_nvr_attr_range
- category_code — varchar
- category_v — varchar
- attribute_grp_code — varchar
- attribute_name — varchar
- hi_opt_grp_cd — varchar
- hi_opt_grp_nm — varchar
- hi_opt_cd — varchar
- hi_opt_val — varchar
- unit — varchar
- min_value — integer
- max_value — integer
- disp_prio_rnk — integer
- required — varchar
- sys_regr_id — varchar
- sys_reg_dtime — timestamp(6)
- sys_modr_id — varchar
- sys_mod_dtime — timestamp(6)
- format_version — =
- location — =
prc_dw.hi_inv_qty
- std_dt — varchar
- prd_id — varchar
- org_id — varchar
- org_nm — varchar
- inv_qty — decimal(38, 0)
- inv_tp — varchar
- format_version — =
- location — =
prc_dw.hi_nvr_mst
- prd_id — varchar
- goods_no — varchar
- pid — varchar
- match_type — varchar
- collect_day — varchar
- eff_strt_dt — varchar
- eff_end_dt — varchar
- ldg_dt — varchar
- format_version — =
- location — =
prc_dw.hi_nvr_mst_hstr
- prd_id — varchar
- goods_no — varchar
- pid — varchar
- match_type — varchar
- eff_strt_dt — varchar
- collect_day — varchar
- eff_end_dt — varchar
- format_version — =
- location — =
- partitioning — =
prc_dw.hi_off_prd_mst
- prd_id — varchar
- item_id — varchar
- prd_nm_off — varchar
- prd_cd — varchar
- plcgrd_cd — varchar
- online_plcgrd_cd — varchar
- mkr_id — varchar
- rep_mkr_id — varchar
- buy_vndr_id — varchar
- hi_vndr_nm — varchar
- pb_flg — varchar
- s06 — varchar
- hm_lnch_dt — varchar
- p03 — varchar
- org_id — varchar
- mg_org_cd — varchar
- item_grp_dtl_type_cd — varchar
- item_grp_cf_cd — varchar
- item_cd — varchar
- event_flg_off — varchar
- cd_flg — varchar
- format_version — =
- location — =
prc_dw.hi_off_prd_prc
- prd_id — varchar
- std_dt — varchar
- avg_uprc — decimal(38, 15)
- incntv_amt — decimal(38, 15)
- base_prc_off — decimal(38, 15)
- cpn_amt_off — bigint
- csb_amt_off — bigint
- inv_qty — decimal(38, 0)
- lgst_inv_qty — decimal(38, 0)
- amt_off — decimal(38, 15)
- qty_off — decimal(38, 0)
- format_version — =
- location — =
prc_dw.hi_off_prd_snp
- std_dt — varchar
- prd_id — varchar
- item_id — varchar
- prd_nm_off — varchar
- prd_cd — varchar
- plcgrd_cd — varchar
- online_plcgrd_cd — varchar
- mkr_id — varchar
- rep_mkr_id — varchar
- buy_vndr_id — varchar
- hi_vndr_nm — varchar
- pb_flg — varchar
- s06 — varchar
- hm_lnch_dt — varchar
- p03 — varchar
- org_id — varchar
- mg_org_cd — varchar
- item_grp_dtl_type_cd — varchar
- item_grp_cf_cd — varchar
- event_flg_off — varchar
- cd_flg — varchar
- avg_uprc — decimal(38, 15)
- incntv_amt — decimal(38, 15)
- base_prc_off — decimal(38, 15)
- cpn_amt_off — bigint
- csb_amt_off — bigint
- inv_qty — decimal(38, 0)
- lgst_inv_qty — decimal(38, 0)
- amt_off — decimal(38, 15)
- qty_off — decimal(38, 0)
- other_dlv_flg — varchar
- pid — varchar
- rep_goods_no — varchar
- set_flg — varchar
- format_version — =
- location — =
prc_dw.hi_offer_prc_rnk
- query_dt — varchar
- pid — varchar
- prd_id — varchar
- prd_cd — varchar
- goods_no — varchar
- diff_rt — double
- avg_profit_on — decimal(38, 15)
- avg_margin_on — double
- avg_qty_on — decimal(38, 0)
- avg_sale_amt_on — double
- profit_rank — bigint
- format_version — =
- location — =
prc_dw.hi_offer_prc_rt
- query_dt — varchar
- pid — varchar
- goods_no — varchar
- diff_rt — double
- category_code — varchar
- format_version — =
- location — =