pr_pstrantolog-pr_pstritem_1
Tables (19)
pc_skumst
- sku_cd — varchar(13) — Primary key — NOT NULL
- sku_name — varchar(40)
- recp_name — varchar(20)
- pumbun_type — varchar(1)
- pumbun_cd — varchar(6)
- pummok_cd — varchar(8)
- sku_type — varchar(1)
- style_type — varchar(1)
- plu_flag — varchar(1)
- input_plu_cd — varchar(13)
- model_no — varchar(24)
- sale_unit_cd — varchar(3)
- bas_spec_cd — float8
- bas_spec_unit — varchar(3)
- cmp_spec_cd — float4
- cmp_spec_unit — varchar(3)
- origin_area_cd — varchar(3)
- maker_cd — varchar(6)
- set_yn — varchar(1)
- gift_flag — varchar(1)
- gift_type_cd — varchar(4)
- gift_amt_type — varchar(4)
- remark — varchar(100)
- style_cd — varchar(54)
- color_cd — varchar(3)
- size_cd — varchar(3)
- bottle_cd — varchar(13)
- use_yn — varchar(1)
- reg_date — timestamp
- reg_id — varchar(10)
- mod_date — timestamp
- mod_id — varchar(10)
pc_strpbn
- str_cd — varchar(2) — Primary key — NOT NULL
- pumbun_cd — varchar(6) — Primary key — NOT NULL
- pumbun_name — varchar(40)
- recp_name — varchar(20)
- ven_cd — varchar(6)
- biz_type — varchar(1)
- biz_flag — varchar(2)
- pumbun_type — varchar(1)
- sku_flag — varchar(1)
- sku_type — varchar(1)
- style_type — varchar(1)
- pos_cal_flag — varchar(1)
- char_buyer_cd — varchar(6)
- buy_org_cd — varchar(10)
- char_sm_cd — varchar(6)
- sale_org_cd — varchar(10)
- hall_cd — varchar(2)
- flor_cd — varchar(2)
- buy_hall_cd — varchar(2)
- buy_flor_cd — varchar(2)
- sale_buy_flag — varchar(1)
- chk_yn — varchar(1)
- edi_yn — varchar(1)
- cost_cal_way — varchar(1)
- adv_ord_yn — varchar(1)
- rentb_mgapp_flag — varchar(1)
- low_mg_rate — float4
- add_point_yn — varchar(1)
- evalu_yn — varchar(1)
- area_size — float8
- e_cntr_no — varchar(20)
- sort_no — int2
- ven_mng_flag — varchar(1)
- app_s_dt — varchar(8)
- app_e_dt — varchar(8)
- use_yn — varchar(1)
- reg_date — timestamp
- reg_id — varchar(10)
- mod_date — timestamp
- mod_id — varchar(10)
- sliding_flag — varchar(1)
- mpos_use — varchar(2)
- e_mail — varchar(100)
- tel_no1 — varchar(4)
- tel_no2 — varchar(4)
- tel_no3 — varchar(4)
- biz_cd — varchar(2)
ps_daysku
- sale_dt — varchar(8) — Primary key — NOT NULL
- str_cd — varchar(2) — Primary key — NOT NULL
- sku_cd — varchar(13) — Primary key — NOT NULL
- week — int2
- num_day — int2
- org_cd — varchar(10)
- buy_org_cd — varchar(10)
- pumbun_cd — varchar(6)
- pummok_cd — varchar(8)
- biz_type — varchar(1)
- biz_flag — varchar(2)
- sku_flag — varchar(1)
- buyer_cd — varchar(6)
- maker_cd — varchar(20)
- style_cd — varchar(54)
- color_cd — varchar(3)
- size_cd — varchar(3)
- barcode — varchar(18)
- sale_qty — int4
- tot_sale_amt — int8
- vat_amt — int4
- redu_amt — int8
- dc_amt — int8
- net_sale_amt — int8
- norm_sale_amt — int8
- sale_prof_amt — int8
- cust_cnt — int4
- rep_pumbun_cd — varchar(6)
- char_sm — varchar(6)
- sps_sale_qty — int4
- sps_sale_amt — int4
- sal_cost_prc — int8
- reg_date — timestamp
- reg_id — varchar(10)
- mod_date — timestamp
- mod_id — varchar(10)
ps_disshopbg
- sale_dt — varchar(8) — Primary key — NOT NULL
- str_cd — varchar(2) — Primary key — NOT NULL
- pos_no — varchar(4) — Primary key — NOT NULL
- tran_no — varchar(5) — Primary key — NOT NULL
- seq_no — int2 — Primary key — NOT NULL
- sku_cd — varchar(13) — Primary key — NOT NULL
- appr_flag — varchar(2) — Primary key — NOT NULL
- appr_qty — int8
- appr_amt — int8
- cnt — int2
- reg_date — timestamp
- reg_id — varchar(10)
- mod_date — timestamp
- mod_id — varchar(10)
pt_pbnday
- stk_dt — varchar(8) — Primary key — NOT NULL
- str_cd — varchar(2) — Primary key — NOT NULL
- pumbun_cd — varchar(6) — Primary key — NOT NULL
- event_flag — varchar(2) — Primary key — NOT NULL
- event_rate — varchar(2) — Primary key — NOT NULL
- mg_rate — float4 — Primary key — NOT NULL
- pummok_cd — varchar(8) — Primary key — NOT NULL
- week — varchar(2)
- day_week — varchar(1)
- dept_cd — varchar(2)
- team_cd — varchar(2)
- pc_cd — varchar(2)
- corner_cd — varchar(2)
- buy_dept_cd — varchar(2)
- buy_team_cd — varchar(2)
- buy_pc_cd — varchar(2)
- buy_corner_cd — varchar(2)
- l_cd — varchar(2)
- m_cd — varchar(2)
- s_cd — varchar(2)
- d_cd — varchar(2)
- ven_cd — varchar(6)
- buy_flag — varchar(1)
- buy_qty — float8
- buy_cost_amt — int8
- buy_sale_amt — int8
- rfd_qty — float8
- rfd_cost_amt — int8
- rfd_sale_amt — int8
- borrow_qty — float8
- borrow_cost_amt — int8
- borrow_sale_amt — int8
- lend_qty — float8
- lend_cost_amt — int8
- lend_sale_amt — int8
- stri_qty — float8
- stri_cost_amt — int8
- stri_sale_amt — int8
- stro_qty — float8
- stro_cost_amt — int8
- stro_sale_amt — int8
- sale_prc_up_bf_qty — float8
- sale_prc_up_bf_amt — int8
- sale_prc_down_af_qty — float8
- sale_prc_down_af_amt — int8
- buy_tot_qty — float8
- buy_tot_cost_amt — int8
- buy_tot_sale_amt — int8
- sale_qty — int4
- sale_cost_amt — int8
- sale_sale_amt — int8
- redu_amt — int8
- dc_amt — int8
- net_sale_amt — int8
- stk_adj_qty — float8
- stk_adj_cost_amt — int8
- stk_adj_sale_amt — int8
- reg_date — timestamp
- reg_id — varchar(10)
- mod_date — timestamp
- … +1
pt_pbnday.
- stk_dt — varchar(8) — Primary key — NOT NULL
- str_cd — varchar(2) — Primary key — NOT NULL
- pumbun_cd — varchar(6) — Primary key — NOT NULL
- event_flag — varchar(2) — Primary key — NOT NULL
- event_rate — varchar(2) — Primary key — NOT NULL
- mg_rate — float4 — Primary key — NOT NULL
- pummok_cd — varchar(8) — Primary key — NOT NULL
- week — varchar(2)
- day_week — varchar(1)
- dept_cd — varchar(2)
- team_cd — varchar(2)
- pc_cd — varchar(2)
- corner_cd — varchar(2)
- buy_dept_cd — varchar(2)
- buy_team_cd — varchar(2)
- buy_pc_cd — varchar(2)
- buy_corner_cd — varchar(2)
- l_cd — varchar(2)
- m_cd — varchar(2)
- s_cd — varchar(2)
- d_cd — varchar(2)
- ven_cd — varchar(6)
- buy_flag — varchar(1)
- buy_qty — float8
- buy_cost_amt — int8
- buy_sale_amt — int8
- rfd_qty — float8
- rfd_cost_amt — int8
- rfd_sale_amt — int8
- borrow_qty — float8
- borrow_cost_amt — int8
- borrow_sale_amt — int8
- lend_qty — float8
- lend_cost_amt — int8
- lend_sale_amt — int8
- stri_qty — float8
- stri_cost_amt — int8
- stri_sale_amt — int8
- stro_qty — float8
- stro_cost_amt — int8
- stro_sale_amt — int8
- sale_prc_up_bf_qty — float8
- sale_prc_up_bf_amt — int8
- sale_prc_down_af_qty — float8
- sale_prc_down_af_amt — int8
- buy_tot_qty — float8
- buy_tot_cost_amt — int8
- buy_tot_sale_amt — int8
- sale_qty — int4
- sale_cost_amt — int8
- sale_sale_amt — int8
- redu_amt — int8
- dc_amt — int8
- net_sale_amt — int8
- stk_adj_qty — float8
- stk_adj_cost_amt — int8
- stk_adj_sale_amt — int8
- reg_date — timestamp
- reg_id — varchar(10)
- mod_date — timestamp
- … +1
pt_pbnmonth
- stk_ym — varchar(6) — Primary key — NOT NULL
- str_cd — varchar(2) — Primary key — NOT NULL
- pumbun_cd — varchar(6) — Primary key — NOT NULL
- event_flag — varchar(2) — Primary key — NOT NULL
- event_rate — varchar(2) — Primary key — NOT NULL
- mg_rate — float4 — Primary key — NOT NULL
- pummok_cd — varchar(8) — Primary key — NOT NULL
- l_cd — varchar(2)
- m_cd — varchar(2)
- s_cd — varchar(2)
- d_cd — varchar(2)
- ven_cd — varchar(6)
- cao_qty — float8
- cao_cost_amt — int8
- cao_sale_amt — int8
- buy_flag — varchar(1)
- buy_qty — float8
- buy_cost_amt — int8
- buy_sale_amt — int8
- rfd_qty — float8
- rfd_cost_amt — int8
- rfd_sale_amt — int8
- borrow_qty — float8
- borrow_cost_amt — int8
- borrow_sale_amt — int8
- lend_qty — float8
- lend_sale_amt — int8
- lend_cost_amt — int8
- stri_qty — float8
- stri_cost_amt — int8
- stri_sale_amt — int8
- stro_qty — float8
- stro_cost_amt — int8
- stro_sale_amt — int8
- sale_prc_up_bf_qty — float8
- sale_prc_up_bf_amt — int8
- sale_prc_down_af_qty — float8
- sale_prc_down_af_amt — int8
- buy_tot_qty — float8
- buy_tot_cost_amt — int8
- buy_tot_sale_amt — int8
- sale_qty — float8
- sale_cost_amt — int8
- sale_sale_amt — int8
- redu_amt — int8
- dc_amt — int8
- net_sale_amt — int8
- stk_adj_qty — float8
- stk_adj_cost_amt — int8
- stk_adj_sale_amt — int8
- reg_date — timestamp
- reg_id — varchar(10)
- mod_date — timestamp
- mod_id — varchar(10)
pt_pbnmonth.
- stk_ym — varchar(6) — Primary key — NOT NULL
- str_cd — varchar(2) — Primary key — NOT NULL
- pumbun_cd — varchar(6) — Primary key — NOT NULL
- event_flag — varchar(2) — Primary key — NOT NULL
- event_rate — varchar(2) — Primary key — NOT NULL
- mg_rate — float4 — Primary key — NOT NULL
- pummok_cd — varchar(8) — Primary key — NOT NULL
- l_cd — varchar(2)
- m_cd — varchar(2)
- s_cd — varchar(2)
- d_cd — varchar(2)
- ven_cd — varchar(6)
- cao_qty — float8
- cao_cost_amt — int8
- cao_sale_amt — int8
- buy_flag — varchar(1)
- buy_qty — float8
- buy_cost_amt — int8
- buy_sale_amt — int8
- rfd_qty — float8
- rfd_cost_amt — int8
- rfd_sale_amt — int8
- borrow_qty — float8
- borrow_cost_amt — int8
- borrow_sale_amt — int8
- lend_qty — float8
- lend_sale_amt — int8
- lend_cost_amt — int8
- stri_qty — float8
- stri_cost_amt — int8
- stri_sale_amt — int8
- stro_qty — float8
- stro_cost_amt — int8
- stro_sale_amt — int8
- sale_prc_up_bf_qty — float8
- sale_prc_up_bf_amt — int8
- sale_prc_down_af_qty — float8
- sale_prc_down_af_amt — int8
- buy_tot_qty — float8
- buy_tot_cost_amt — int8
- buy_tot_sale_amt — int8
- sale_qty — float8
- sale_cost_amt — int8
- sale_sale_amt — int8
- redu_amt — int8
- dc_amt — int8
- net_sale_amt — int8
- stk_adj_qty — float8
- stk_adj_cost_amt — int8
- stk_adj_sale_amt — int8
- reg_date — timestamp
- reg_id — varchar(10)
- mod_date — timestamp
- mod_id — varchar(10)
pt_pbnsale
- stk_dt — varchar(8) — Primary key — NOT NULL
- str_cd — varchar(2) — Primary key — NOT NULL
- pumbun_cd — varchar(6) — Primary key — NOT NULL
- pummok_cd — varchar(8) — Primary key — NOT NULL
- event_flag — varchar(2) — Primary key — NOT NULL
- event_rate — varchar(2) — Primary key — NOT NULL
- mg_rate — float4 — Primary key — NOT NULL
- dept_cd — varchar(2)
- team_cd — varchar(2)
- pc_cd — varchar(2)
- corner_cd — varchar(2)
- ven_cd — varchar(6)
- sale_qty — int4
- sale_cost_amt — int8
- sale_sale_amt — int8
- redu_amt — int8
- dc_amt — int8
- net_sale_amt — int8
- reg_date — timestamp
- reg_id — varchar(10)
- mod_date — timestamp
- mod_id — varchar(10)
pt_pbnsale.
- stk_dt — varchar(8) — Primary key — NOT NULL
- str_cd — varchar(2) — Primary key — NOT NULL
- pumbun_cd — varchar(6) — Primary key — NOT NULL
- pummok_cd — varchar(8) — Primary key — NOT NULL
- event_flag — varchar(2) — Primary key — NOT NULL
- event_rate — varchar(2) — Primary key — NOT NULL
- mg_rate — float4 — Primary key — NOT NULL
- dept_cd — varchar(2)
- team_cd — varchar(2)
- pc_cd — varchar(2)
- corner_cd — varchar(2)
- ven_cd — varchar(6)
- sale_qty — int4
- sale_cost_amt — int8
- sale_sale_amt — int8
- redu_amt — int8
- dc_amt — int8
- net_sale_amt — int8
- reg_date — timestamp
- reg_id — varchar(10)
- mod_date — timestamp
- mod_id — varchar(10)
pt_skuday
- stk_dt — varchar(8) — Primary key — NOT NULL
- str_cd — varchar(2) — Primary key — NOT NULL
- sku_cd — varchar(13) — Primary key — NOT NULL
- week — varchar(2)
- day_week — varchar(1)
- dept_cd — varchar(2)
- team_cd — varchar(2)
- pc_cd — varchar(2)
- corner_cd — varchar(2)
- buy_dept_cd — varchar(2)
- buy_team_cd — varchar(2)
- buy_pc_cd — varchar(2)
- buy_corner_cd — varchar(2)
- pumbun_cd — varchar(6)
- pummok_cd — varchar(8)
- l_cd — varchar(2)
- m_cd — varchar(2)
- s_cd — varchar(2)
- d_cd — varchar(2)
- ven_cd — varchar(6)
- buy_flag — varchar(1)
- buy_qty — float8
- buy_cost_amt — int8
- buy_sale_amt — int8
- buy_imp_cost_amt — int8
- buy_expen_amt — int8
- rfd_qty — float8
- rfd_cost_amt — int8
- rfd_sale_amt — int8
- borrow_qty — float8
- borrow_cost_amt — int8
- borrow_sale_amt — int8
- lend_qty — float8
- lend_cost_amt — int8
- lend_sale_amt — int8
- stri_qty — float8
- stri_cost_amt — int8
- stri_sale_amt — int8
- stro_qty — float8
- stro_cost_amt — int8
- stro_sale_amt — int8
- sale_prc_up_bf_qty — float8
- sale_prc_up_bf_amt — int8
- sale_prc_down_af_qty — float8
- sale_prc_down_af_amt — int8
- buy_tot_qty — float8
- buy_tot_cost_amt — int8
- buy_tot_sale_amt — int8
- sale_qty — float8
- sale_cost_amt — int8
- sale_sale_amt — int8
- redu_amt — int8
- dc_amt — int8
- net_sale_amt — int8
- stk_adj_qty — float8
- stk_adj_cost_amt — int8
- stk_adj_sale_amt — int8
- reg_date — timestamp
- reg_id — varchar(10)
- mod_date — timestamp
- … +1
pt_skuday.
- stk_dt — varchar(8) — Primary key — NOT NULL
- str_cd — varchar(2) — Primary key — NOT NULL
- sku_cd — varchar(13) — Primary key — NOT NULL
- week — varchar(2)
- day_week — varchar(1)
- dept_cd — varchar(2)
- team_cd — varchar(2)
- pc_cd — varchar(2)
- corner_cd — varchar(2)
- buy_dept_cd — varchar(2)
- buy_team_cd — varchar(2)
- buy_pc_cd — varchar(2)
- buy_corner_cd — varchar(2)
- pumbun_cd — varchar(6)
- pummok_cd — varchar(8)
- l_cd — varchar(2)
- m_cd — varchar(2)
- s_cd — varchar(2)
- d_cd — varchar(2)
- ven_cd — varchar(6)
- buy_flag — varchar(1)
- buy_qty — float8
- buy_cost_amt — int8
- buy_sale_amt — int8
- buy_imp_cost_amt — int8
- buy_expen_amt — int8
- rfd_qty — float8
- rfd_cost_amt — int8
- rfd_sale_amt — int8
- borrow_qty — float8
- borrow_cost_amt — int8
- borrow_sale_amt — int8
- lend_qty — float8
- lend_cost_amt — int8
- lend_sale_amt — int8
- stri_qty — float8
- stri_cost_amt — int8
- stri_sale_amt — int8
- stro_qty — float8
- stro_cost_amt — int8
- stro_sale_amt — int8
- sale_prc_up_bf_qty — float8
- sale_prc_up_bf_amt — int8
- sale_prc_down_af_qty — float8
- sale_prc_down_af_amt — int8
- buy_tot_qty — float8
- buy_tot_cost_amt — int8
- buy_tot_sale_amt — int8
- sale_qty — float8
- sale_cost_amt — int8
- sale_sale_amt — int8
- redu_amt — int8
- dc_amt — int8
- net_sale_amt — int8
- stk_adj_qty — float8
- stk_adj_cost_amt — int8
- stk_adj_sale_amt — int8
- reg_date — timestamp
- reg_id — varchar(10)
- mod_date — timestamp
- … +1
pt_skuday..
- stk_dt — varchar(8) — Primary key — NOT NULL
- str_cd — varchar(2) — Primary key — NOT NULL
- sku_cd — varchar(13) — Primary key — NOT NULL
- week — varchar(2)
- day_week — varchar(1)
- dept_cd — varchar(2)
- team_cd — varchar(2)
- pc_cd — varchar(2)
- corner_cd — varchar(2)
- buy_dept_cd — varchar(2)
- buy_team_cd — varchar(2)
- buy_pc_cd — varchar(2)
- buy_corner_cd — varchar(2)
- pumbun_cd — varchar(6)
- pummok_cd — varchar(8)
- l_cd — varchar(2)
- m_cd — varchar(2)
- s_cd — varchar(2)
- d_cd — varchar(2)
- ven_cd — varchar(6)
- buy_flag — varchar(1)
- buy_qty — float8
- buy_cost_amt — int8
- buy_sale_amt — int8
- buy_imp_cost_amt — int8
- buy_expen_amt — int8
- rfd_qty — float8
- rfd_cost_amt — int8
- rfd_sale_amt — int8
- borrow_qty — float8
- borrow_cost_amt — int8
- borrow_sale_amt — int8
- lend_qty — float8
- lend_cost_amt — int8
- lend_sale_amt — int8
- stri_qty — float8
- stri_cost_amt — int8
- stri_sale_amt — int8
- stro_qty — float8
- stro_cost_amt — int8
- stro_sale_amt — int8
- sale_prc_up_bf_qty — float8
- sale_prc_up_bf_amt — int8
- sale_prc_down_af_qty — float8
- sale_prc_down_af_amt — int8
- buy_tot_qty — float8
- buy_tot_cost_amt — int8
- buy_tot_sale_amt — int8
- sale_qty — float8
- sale_cost_amt — int8
- sale_sale_amt — int8
- redu_amt — int8
- dc_amt — int8
- net_sale_amt — int8
- stk_adj_qty — float8
- stk_adj_cost_amt — int8
- stk_adj_sale_amt — int8
- reg_date — timestamp
- reg_id — varchar(10)
- mod_date — timestamp
- … +1
pt_skumonth
- stk_ym — varchar(6) — Primary key — NOT NULL
- str_cd — varchar(2) — Primary key — NOT NULL
- sku_cd — varchar(13) — Primary key — NOT NULL
- pumbun_cd — varchar(6)
- pummok_cd — varchar(8)
- l_cd — varchar(2)
- m_cd — varchar(2)
- s_cd — varchar(2)
- d_cd — varchar(2)
- ven_cd — varchar(6)
- cao_qty — float8
- cao_cost_amt — int8
- cao_sale_amt — int8
- buy_flag — varchar(1)
- buy_qty — float8
- buy_cost_amt — int8
- buy_sale_amt — int8
- buy_imp_cost_amt — int8
- buy_expen_amt — int8
- rfd_qty — float8
- rfd_cost_amt — int8
- rfd_sale_amt — int8
- borrow_qty — float8
- borrow_cost_amt — int8
- borrow_sale_amt — int8
- lend_qty — float8
- lend_sale_amt — int8
- lend_cost_amt — int8
- stri_qty — float8
- stri_cost_amt — int8
- stri_sale_amt — int8
- stro_qty — float8
- stro_cost_amt — int8
- stro_sale_amt — int8
- sale_prc_up_bf_qty — float8
- sale_prc_up_bf_amt — int8
- sale_prc_down_af_qty — float8
- sale_prc_down_af_amt — int8
- buy_tot_qty — float8
- buy_tot_cost_amt — int8
- buy_tot_sale_amt — int8
- sale_qty — float8
- sale_cost_amt — int8
- sale_sale_amt — int8
- redu_amt — int8
- dc_amt — int8
- net_sale_amt — int8
- stk_adj_qty — float8
- stk_adj_cost_amt — int8
- stk_adj_sale_amt — int8
- reg_date — timestamp
- reg_id — varchar(10)
- mod_date — timestamp
- mod_id — varchar(10)
pt_skumonth.
- stk_ym — varchar(6) — Primary key — NOT NULL
- str_cd — varchar(2) — Primary key — NOT NULL
- sku_cd — varchar(13) — Primary key — NOT NULL
- pumbun_cd — varchar(6)
- pummok_cd — varchar(8)
- l_cd — varchar(2)
- m_cd — varchar(2)
- s_cd — varchar(2)
- d_cd — varchar(2)
- ven_cd — varchar(6)
- cao_qty — float8
- cao_cost_amt — int8
- cao_sale_amt — int8
- buy_flag — varchar(1)
- buy_qty — float8
- buy_cost_amt — int8
- buy_sale_amt — int8
- buy_imp_cost_amt — int8
- buy_expen_amt — int8
- rfd_qty — float8
- rfd_cost_amt — int8
- rfd_sale_amt — int8
- borrow_qty — float8
- borrow_cost_amt — int8
- borrow_sale_amt — int8
- lend_qty — float8
- lend_sale_amt — int8
- lend_cost_amt — int8
- stri_qty — float8
- stri_cost_amt — int8
- stri_sale_amt — int8
- stro_qty — float8
- stro_cost_amt — int8
- stro_sale_amt — int8
- sale_prc_up_bf_qty — float8
- sale_prc_up_bf_amt — int8
- sale_prc_down_af_qty — float8
- sale_prc_down_af_amt — int8
- buy_tot_qty — float8
- buy_tot_cost_amt — int8
- buy_tot_sale_amt — int8
- sale_qty — float8
- sale_cost_amt — int8
- sale_sale_amt — int8
- redu_amt — int8
- dc_amt — int8
- net_sale_amt — int8
- stk_adj_qty — float8
- stk_adj_cost_amt — int8
- stk_adj_sale_amt — int8
- reg_date — timestamp
- reg_id — varchar(10)
- mod_date — timestamp
- mod_id — varchar(10)
pt_skumonth..
- stk_ym — varchar(6) — Primary key — NOT NULL
- str_cd — varchar(2) — Primary key — NOT NULL
- sku_cd — varchar(13) — Primary key — NOT NULL
- pumbun_cd — varchar(6)
- pummok_cd — varchar(8)
- l_cd — varchar(2)
- m_cd — varchar(2)
- s_cd — varchar(2)
- d_cd — varchar(2)
- ven_cd — varchar(6)
- cao_qty — float8
- cao_cost_amt — int8
- cao_sale_amt — int8
- buy_flag — varchar(1)
- buy_qty — float8
- buy_cost_amt — int8
- buy_sale_amt — int8
- buy_imp_cost_amt — int8
- buy_expen_amt — int8
- rfd_qty — float8
- rfd_cost_amt — int8
- rfd_sale_amt — int8
- borrow_qty — float8
- borrow_cost_amt — int8
- borrow_sale_amt — int8
- lend_qty — float8
- lend_sale_amt — int8
- lend_cost_amt — int8
- stri_qty — float8
- stri_cost_amt — int8
- stri_sale_amt — int8
- stro_qty — float8
- stro_cost_amt — int8
- stro_sale_amt — int8
- sale_prc_up_bf_qty — float8
- sale_prc_up_bf_amt — int8
- sale_prc_down_af_qty — float8
- sale_prc_down_af_amt — int8
- buy_tot_qty — float8
- buy_tot_cost_amt — int8
- buy_tot_sale_amt — int8
- sale_qty — float8
- sale_cost_amt — int8
- sale_sale_amt — int8
- redu_amt — int8
- dc_amt — int8
- net_sale_amt — int8
- stk_adj_qty — float8
- stk_adj_cost_amt — int8
- stk_adj_sale_amt — int8
- reg_date — timestamp
- reg_id — varchar(10)
- mod_date — timestamp
- mod_id — varchar(10)
pt_skusale
- stk_dt — varchar(8) — Primary key — NOT NULL
- str_cd — varchar(2) — Primary key — NOT NULL
- sku_cd — varchar(13) — Primary key — NOT NULL
- dept_cd — varchar(2)
- team_cd — varchar(2)
- pc_cd — varchar(2)
- corner_cd — varchar(2)
- pumbun_cd — varchar(6)
- pummok_cd — varchar(8)
- ven_cd — varchar(6)
- sale_qty — int4
- sale_cost_amt — int8
- sale_sale_amt — int8
- redu_amt — int8
- dc_amt — int8
- net_sale_amt — int8
- cust_cnt — int4
- reg_date — timestamp
- reg_id — varchar(10)
- mod_date — timestamp
- mod_id — varchar(10)
pt_skusale.
- stk_dt — varchar(8) — Primary key — NOT NULL
- str_cd — varchar(2) — Primary key — NOT NULL
- sku_cd — varchar(13) — Primary key — NOT NULL
- dept_cd — varchar(2)
- team_cd — varchar(2)
- pc_cd — varchar(2)
- corner_cd — varchar(2)
- pumbun_cd — varchar(6)
- pummok_cd — varchar(8)
- ven_cd — varchar(6)
- sale_qty — int4
- sale_cost_amt — int8
- sale_sale_amt — int8
- redu_amt — int8
- dc_amt — int8
- net_sale_amt — int8
- cust_cnt — int4
- reg_date — timestamp
- reg_id — varchar(10)
- mod_date — timestamp
- mod_id — varchar(10)
pt_skusale..
- stk_dt — varchar(8) — Primary key — NOT NULL
- str_cd — varchar(2) — Primary key — NOT NULL
- sku_cd — varchar(13) — Primary key — NOT NULL
- dept_cd — varchar(2)
- team_cd — varchar(2)
- pc_cd — varchar(2)
- corner_cd — varchar(2)
- pumbun_cd — varchar(6)
- pummok_cd — varchar(8)
- ven_cd — varchar(6)
- sale_qty — int4
- sale_cost_amt — int8
- sale_sale_amt — int8
- redu_amt — int8
- dc_amt — int8
- net_sale_amt — int8
- cust_cnt — int4
- reg_date — timestamp
- reg_id — varchar(10)
- mod_date — timestamp
- mod_id — varchar(10)