2410_Samsung S.LSI

Tables (17)

?????

  • SALES_CD — VARCHAR2(40) — NOT NULL
  • SP_NO — NUMBER — NOT NULL
  • NCKN — VARCHAR2(30) — NOT NULL
  • BRND_NM — VARCHAR2(50) — NOT NULL
  • MODEL_NM — VARCHAR2(50) — NOT NULL
  • REGN — VARCHAR2(100) — NOT NULL
  • CAMR_TYPE_1ST — VARCHAR2(50)
  • CAMR_TYPE_2ND — VARCHAR2(50)
  • CAMR_TYPE_3RD — VARCHAR2(50)
  • CAMR_TYPE_4TH — VARCHAR2(50)
  • REL_YM — VARCHAR2(50)
  • USE_YN — CHAR(1) — NOT NULL
  • CRT_USER — VARCHAR2(30) — NOT NULL
  • CRT_DTTM — TIMESTAMP — NOT NULL
  • MDFY_USER — VARCHAR2(30) — NOT NULL
  • MDFY_DTTM — TIMESTAMP — NOT NULL

EXTR_SP_SET_MSTR

  • SP_SET_MSTR_ID — NUMBER — NOT NULL
  • STD_COMP_NM — VARCHAR2(100)
  • STD_BRND_NM — VARCHAR2(100)
  • STD_SERS_NM — VARCHAR2(100)
  • STD_FMLY_NM — VARCHAR2(100)
  • STD_MODEL_NM — VARCHAR2(100)
  • STD_REGN_NM — VARCHAR2(100)
  • USE_YN — CHAR(1) — NOT NULL
  • CRT_USER — VARCHAR2(30) — NOT NULL
  • CRT_DTTM — TIMESTAMP — NOT NULL
  • MDFY_USER — VARCHAR2(30) — NOT NULL
  • MDFY_DTTM — TIMESTAMP — NOT NULL

MNLY_PART_DMD_PLAN

  • PART_DMD_PLAN_ID — NUMBER — NOT NULL
  • PLAN_YM — CHAR(6) — NOT NULL
  • RUN_YM — CHAR(6) — NOT NULL
  • SALES_CD — VARCHAR2(40) — NOT NULL
  • QTY — NUMBER(15,4) — NOT NULL
  • CTGR_NM — VARCHAR2(100) — NOT NULL
  • CSTM_CD — VARCHAR2(40)
  • CSTM_NM — VARCHAR2(90)
  • USE_YN — CHAR(1) — NOT NULL
  • CRT_USER — VARCHAR2(30) — NOT NULL
  • CRT_DTTM — TIMESTAMP — NOT NULL
  • MDFY_USER — VARCHAR2(30) — NOT NULL
  • MDFY_DTTM — TIMESTAMP — NOT NULL

NUMBER_PART_MSTR

  • SALES_CD — VARCHAR2(40) — NOT NULL
  • MSTR_CD — VARCHAR2(40) — NOT NULL
  • NCKN — VARCHAR2(30) — NOT NULL
  • PG — VARCHAR2(40)
  • PG1 — VARCHAR2(40)
  • PG2 — VARCHAR2(40)
  • PG3 — VARCHAR2(40)
  • PG4 — VARCHAR2(40)
  • PG5 — VARCHAR2(40)
  • PG6 — VARCHAR2(40)
  • PG7 — VARCHAR2(40)
  • USE_YN — CHAR(1) — NOT NULL
  • CRT_USER — VARCHAR2(30) — NOT NULL
  • CRT_DTTM — TIMESTAMP — NOT NULL
  • MDFY_USER — VARCHAR2(30) — NOT NULL
  • MDFY_DTTM — TIMESTAMP — NOT NULL

PART_INVN_STTN

  • PART_INVN_STTN_ID — NUMBER — NOT NULL
  • INVN_BASE_DT — CHAR(8) — NOT NULL
  • SALES_CD — VARCHAR2(40) — NOT NULL
  • QTY — NUMBER(15,4) — NOT NULL
  • CTGR_NM — VARCHAR2(100) — NOT NULL
  • CSTM_CD — VARCHAR2(40)
  • CSTM_NM — VARCHAR2(90)
  • USE_YN — CHAR(1) — NOT NULL
  • CRT_USER — VARCHAR2(30) — NOT NULL
  • CRT_DTTM — TIMESTAMP — NOT NULL
  • MDFY_USER — VARCHAR2(30) — NOT NULL
  • MDFY_DTTM — TIMESTAMP — NOT NULL

PART_PROD_RSLT

  • PART_PROD_RSLT_ID — NUMBER — NOT NULL
  • RUN_WK — CHAR(6) — NOT NULL
  • RUN_YM — CHAR(6) — NOT NULL
  • RUN_MNTH_WK_NO — NUMBER(1)
  • SALES_CD — VARCHAR2(40) — NOT NULL
  • QTY — NUMBER(15,4) — NOT NULL
  • CTGR_NM — VARCHAR2(100) — NOT NULL
  • CSTM_CD — VARCHAR2(40)
  • CSTM_NM — VARCHAR2(90)
  • USE_YN — CHAR(1) — NOT NULL
  • CRT_USER — VARCHAR2(30) — NOT NULL
  • CRT_DTTM — TIMESTAMP — NOT NULL
  • MDFY_USER — VARCHAR2(30) — NOT NULL
  • MDFY_DTTM — TIMESTAMP — NOT NULL

PART_SALES_RSLT

  • PART_SALES_RSLT_ID — NUMBER — NOT NULL
  • RUN_WK — CHAR(6) — NOT NULL
  • RUN_YM — CHAR(6) — NOT NULL
  • RUN_MNTH_WK_NO — NUMBER(1)
  • SALES_CD — VARCHAR2(40) — NOT NULL
  • QTY — NUMBER(15,4) — NOT NULL
  • CTGR_NM — VARCHAR2(100) — NOT NULL
  • CSTM_CD — VARCHAR2(40)
  • CSTM_NM — VARCHAR2(90)
  • USE_YN — CHAR(1) — NOT NULL
  • CRT_USER — VARCHAR2(30) — NOT NULL
  • CRT_DTTM — TIMESTAMP — NOT NULL
  • MDFY_USER — VARCHAR2(30) — NOT NULL
  • MDFY_DTTM — TIMESTAMP — NOT NULL

PART_SP_SET_MAP

  • SP_SET_MAP_ID — NUMBER — NOT NULL
  • NCKN — VARCHAR2(30) — NOT NULL
  • BOM — NUMBER(3) — NOT NULL
  • USE_YN — CHAR(1) — NOT NULL
  • SALES_CD — VARCHAR2(40) — NOT NULL
  • SP_SET_MSTR_ID — NUMBER — NOT NULL
  • CRT_USER — VARCHAR2(30) — NOT NULL
  • CRT_DTTM — TIMESTAMP — NOT NULL
  • MDFY_USER — VARCHAR2(30) — NOT NULL
  • MDFY_DTTM — TIMESTAMP — NOT NULL

SP_LIST_EXTR_KMVL_RAW

  • SP_NO — NUMBER — NOT NULL
  • DATA_SOURCE — VARCHAR2(20) — NOT NULL
  • BRND_NM — VARCHAR2(50) — NOT NULL
  • MODEL_NM — VARCHAR2(50) — NOT NULL
  • LINK_URL — VARCHAR2(100) — NOT NULL
  • REGN — VARCHAR2(100) — NOT NULL
  • REL_SIN — VARCHAR2(50) — NOT NULL
  • MMRY_SIZE — VARCHAR2(50) — NOT NULL
  • STRG_SIZE — VARCHAR2(50) — NOT NULL
  • MODEL_SIZE — VARCHAR2(20)
  • MODEL_WGHT — VARCHAR2(20)
  • BTTR_PWR — VARCHAR2(10)
  • CRT_USER — VARCHAR2(30) — NOT NULL
  • CRT_DTTM — TIMESTAMP — NOT NULL
  • MDFY_USER — VARCHAR2(30) — NOT NULL
  • MDFY_DTTM — TIMESTAMP — NOT NULL

SP_PRC_EXTR_KMVL_RAW

  • SP_NO — NUMBER — NOT NULL
  • MODEL_NM — VARCHAR2(50) — NOT NULL
  • REGN — VARCHAR2(100) — NOT NULL
  • MMRY_SIZE — VARCHAR2(50) — NOT NULL
  • STRG_SIZE — VARCHAR2(50) — NOT NULL
  • PRC — VARCHAR2(50)
  • CRT_USER — VARCHAR2(30) — NOT NULL
  • CRT_DTTM — TIMESTAMP — NOT NULL
  • MDFY_USER — VARCHAR2(30) — NOT NULL
  • MDFY_DTTM — TIMESTAMP — NOT NULL

SP_PROD_QTLY_EXTR_SGIT_FACT

  • ISSUE_DTTM — VARCHAR2(20)
  • YR — VARCHAR2(10)
  • QTR — VARCHAR2(10)
  • COMP_NM — VARCHAR2(100)
  • BRND_NM — VARCHAR2(100)
  • SERS_NM — VARCHAR2(50)
  • SUB_SERS_NM — VARCHAR2(50)
  • MODEL_NM — VARCHAR2(100)
  • MAIN_DSPL — VARCHAR2(50)
  • MAIN_DSPL_RESOL_SPEC — VARCHAR2(50)
  • MAIN_DSPL_RESOL_SIZE — VARCHAR2(50)
  • PANEL_TYPE — VARCHAR2(20)
  • BACK_PLANE — VARCHAR2(20)
  • BNDG — VARCHAR2(20)
  • FOLD — VARCHAR2(20)
  • FOLD_TYPE — VARCHAR2(20)
  • PANEL_FORM — VARCHAR2(20)
  • PANEL_SPPL — VARCHAR2(100)
  • TP_SPEC — VARCHAR2(100)
  • TP_SPPL — VARCHAR2(100)
  • SUB_DSPL_SIZE — VARCHAR2(100)
  • SUB_DSPL_RESOL_SPEC — VARCHAR2(100)
  • SUB_DSPL_RESOL_SIZE — VARCHAR2(100)
  • SUB_DSPL_PANEL_TYPE — VARCHAR2(100)
  • CHIPSET_SPEC — VARCHAR2(100)
  • CHIPSET_SPPL — VARCHAR2(100)
  • NTWK — VARCHAR2(20)
  • FNGPR_SPEC — VARCHAR2(20)
  • FNGPR_SPPL — VARCHAR2(50)
  • FACE_ID_SPEC — VARCHAR2(50)
  • FACE_ID_SPPL — VARCHAR2(50)
  • CAMR_SPEC_REAR_1ST — VARCHAR2(100)
  • CAMR_SPEC_REAR_2ND — VARCHAR2(100)
  • CAMR_SPEC_REAR_3RD — VARCHAR2(100)
  • CAMR_SPEC_REAR_4TH — VARCHAR2(100)
  • CAMR_SPEC_REAR_5TH — VARCHAR2(100)
  • CAMR_SPPL_REAR_1ST — VARCHAR2(100)
  • CAMR_SPPL_REAR_2ND — VARCHAR2(100)
  • CAMR_SPPL_REAR_3RD — VARCHAR2(100)
  • CAMR_SPPL_REAR_4TH — VARCHAR2(100)
  • CAMR_SPPL_REAR_5TH — VARCHAR2(100)
  • CAMR_SPEC_FRNT — VARCHAR2(100)
  • CAMR_SPPL_FRNT — VARCHAR2(100)
  • DRAM_TYPE — VARCHAR2(20)
  • NAND_TYPE — VARCHAR2(20)
  • MMRY_TYPE — VARCHAR2(100)
  • DRAM_PKG_TYPE — VARCHAR2(100)
  • MMRY_PKG_INTF — VARCHAR2(100)
  • DRAM_NAND_SPEC — VARCHAR2(100)
  • STD_VRSN_PRC_CNY — VARCHAR2(50)
  • PRC_SEG — VARCHAR2(50)
  • LAUNCH_TM — VARCHAR2(50)
  • IDH_ODM — VARCHAR2(50)
  • REGN — VARCHAR2(50)
  • VOL — NUMBER(15,5)
  • CRT_USER — VARCHAR2(30) — NOT NULL
  • CRT_DTTM — TIMESTAMP — NOT NULL
  • MDFY_USER — VARCHAR2(30) — NOT NULL
  • MDFY_DTTM — TIMESTAMP — NOT NULL

SP_SELL_IN_MNLY_EXTR_CNTPT_FACT

  • REGN — VARCHAR2(20)
  • ITEM — VARCHAR2(100)
  • BRND_NM — VARCHAR2(50)
  • BASE_YM — VARCHAR2(6)
  • YM_NO — VARCHAR2(6)
  • QTY — NUMBER(16,5)
  • CRT_USER — VARCHAR2(30) — NOT NULL
  • CRT_DTTM — TIMESTAMP — NOT NULL
  • MDFY_USER — VARCHAR2(30) — NOT NULL
  • MDFY_DTTM — TIMESTAMP — NOT NULL

SP_SELL_IN_QTLY_EXTR_OMDIA_FACT

  • COMP_NM — VARCHAR2(100)
  • BRND_NM — VARCHAR2(100)
  • COMP_ORGN — VARCHAR2(50)
  • MODEL_NM — VARCHAR2(100)
  • SERS_NM — VARCHAR2(50)
  • SERS_NO — VARCHAR2(50)
  • NTWK_GEN — VARCHAR2(20)
  • NOTE — VARCHAR2(100)
  • DSPL_TYPE — VARCHAR2(20)
  • SCRN_SIZE — VARCHAR2(20)
  • SIZE_CTGR — VARCHAR2(20)
  • RESOL — VARCHAR2(50)
  • FORM_FACTOR — VARCHAR2(50)
  • ASPT_RATIO — VARCHAR2(50)
  • RFRSH_RATE — VARCHAR2(50)
  • CHIPSET — VARCHAR2(100)
  • CHIPSET_SERS — VARCHAR2(100)
  • CPU — VARCHAR2(500)
  • CPU_CORE_NO — VARCHAR2(20)
  • GPU — VARCHAR2(100)
  • GPU_SERS — VARCHAR2(20)
  • OS — VARCHAR2(20)
  • RAM — NUMBER(10,3)
  • RAM_DMD — NUMBER(10,3)
  • PRMR_CAMR — VARCHAR2(50)
  • PRMR_CAMR_NO — VARCHAR2(10)
  • SCND_CAMR — VARCHAR2(20)
  • SCND_CAMR_NO — VARCHAR2(10)
  • CAMR_OIS — VARCHAR2(10)
  • FNGPR_SENSOR — VARCHAR2(50)
  • BTTR_MAH — NUMBER(10,0)
  • BTTR_CTGR — VARCHAR2(20)
  • WRLS_CHRG — VARCHAR2(10)
  • YR — NUMBER(10,0)
  • QTR — VARCHAR2(10)
  • YQ — VARCHAR2(20)
  • UNIT_THND — NUMBER(10,3)
  • UNIT_MIL — NUMBER(18,9)
  • PRC_RNG — VARCHAR2(20)
  • PRC_TIER — VARCHAR2(50)
  • PRC_USD — NUMBER(18,9)
  • REVN_MIL — NUMBER(18,9)
  • CRT_USER — VARCHAR2(30) — NOT NULL
  • CRT_DTTM — TIMESTAMP — NOT NULL
  • MDFY_USER — VARCHAR2(30) — NOT NULL
  • MDFY_DTTM — TIMESTAMP — NOT NULL

SP_SELL_THR_MNLY_EXTR_CNTPT_FACT

  • BRND_NM — VARCHAR2(50)
  • MODEL_NM — VARCHAR2(100)
  • MODEL_TYPE — VARCHAR2(50)
  • BASE_YM — VARCHAR2(6)
  • YM_NO — VARCHAR2(6)
  • QTY — NUMBER(16,5)
  • CRT_USER — VARCHAR2(30) — NOT NULL
  • CRT_DTTM — TIMESTAMP — NOT NULL
  • MDFY_USER — VARCHAR2(30) — NOT NULL
  • MDFY_DTTM — TIMESTAMP — NOT NULL

SP_SELL_THR_WKLY_EXTR_CNTPT_FACT

  • REGN — VARCHAR2(20)
  • BRND_NM — VARCHAR2(20)
  • MODEL_NM — VARCHAR2(50)
  • BASE_WK_NO — VARCHAR2(6)
  • YM_NO — VARCHAR2(20)
  • DT_TERM — VARCHAR2(20)
  • WK_NO — NUMBER(10,3)
  • QTY — NUMBER(20,12)
  • CRT_USER — VARCHAR2(30) — NOT NULL
  • CRT_DTTM — TIMESTAMP — NOT NULL
  • MDFY_USER — VARCHAR2(30) — NOT NULL
  • MDFY_DTTM — TIMESTAMP — NOT NULL

SP_SPEC_EXTR_KMVL_RAW

  • SP_NO — NUMBER — NOT NULL
  • DATA_SOURCE — VARCHAR2(20) — NOT NULL
  • BRND_NM — VARCHAR2(50) — NOT NULL
  • MODEL_NM — VARCHAR2(50) — NOT NULL
  • LINK_URL — VARCHAR2(100) — NOT NULL
  • REGN — VARCHAR2(100) — NOT NULL
  • REL_YM — VARCHAR2(50) — NOT NULL
  • OS — VARCHAR2(100) — NOT NULL
  • MODEL_SIZE — VARCHAR2(100)
  • MODEL_WGHT — VARCHAR2(100)
  • RSTS_CTFC — VARCHAR2(100)
  • SCRN_SIZE — VARCHAR2(100)
  • SCRN_TYPE — VARCHAR2(100)
  • SCRN_RATIO — VARCHAR2(100)
  • SCRN_RESOL — VARCHAR2(100)
  • SCRN_DENS — VARCHAR2(100)
  • SCRN_OTHERS — VARCHAR2(1000)
  • PROC_MODEL — VARCHAR2(50)
  • PROC_CPU — VARCHAR2(150)
  • PROC_TYPE — VARCHAR2(50)
  • PROC_NNMT — VARCHAR2(50)
  • PROC_FREQ — VARCHAR2(50)
  • PROC_64BIT — VARCHAR2(50)
  • GPU — VARCHAR2(50)
  • RAM — VARCHAR2(50)
  • RAM_TYPE — VARCHAR2(50)
  • ANTU_SCORE — VARCHAR2(100)
  • STRG_CAPA — VARCHAR2(100)
  • STRG_TYPE — VARCHAR2(100)
  • STRG_SD_SLOT — VARCHAR2(100)
  • AUD — VARCHAR2(100)
  • CAMR_DESC — VARCHAR2(50)
  • CAMR_NO_1ST — VARCHAR2(50)
  • CAMR_KIND_1ST — VARCHAR2(50)
  • CAMR_RESOL_1ST — VARCHAR2(50)
  • CAMR_SENSOR_1ST — VARCHAR2(50)
  • CAMR_TYPE_1ST — VARCHAR2(50)
  • CAMR_APTR_1ST — VARCHAR2(50)
  • CAMR_APTR_1ST_VAL — VARCHAR2(50)
  • CAMR_PIXEL_SIZE_1ST — VARCHAR2(50)
  • CAMR_PIXEL_BINN_1ST — VARCHAR2(50)
  • CAMR_SENSOR_SIZE_1ST — VARCHAR2(50)
  • CAMR_NO_2ND — VARCHAR2(50)
  • CAMR_KIND_2ND — VARCHAR2(50)
  • CAMR_RESOL_2ND — VARCHAR2(50)
  • CAMR_SENSOR_2ND — VARCHAR2(50)
  • CAMR_TYPE_2ND — VARCHAR2(50)
  • CAMR_APTR_2ND — VARCHAR2(50)
  • CAMR_PIXEL_SIZE_2ND — VARCHAR2(50)
  • CAMR_PIXEL_BINN_2ND — VARCHAR2(50)
  • CAMR_SENSOR_SIZE_2ND — VARCHAR2(50)
  • CAMR_NO_3RD — VARCHAR2(50)
  • CAMR_KIND_3RD — VARCHAR2(50)
  • CAMR_RESOL_3RD — VARCHAR2(50)
  • CAMR_SENSOR_3RD — VARCHAR2(50)
  • CAMR_TYPE_3RD — VARCHAR2(50)
  • CAMR_APTR_3RD — VARCHAR2(50)
  • CAMR_PIXEL_SIZE_3RD — VARCHAR2(50)
  • CAMR_PIXEL_BINN_3RD — VARCHAR2(50)
  • CAMR_SENSOR_SIZE_3RD — VARCHAR2(50)
  • … +30

WKLY_PART_DMD_PLAN

  • PART_DMD_PLAN_ID — NUMBER — NOT NULL
  • PLAN_WK — CHAR(6) — NOT NULL
  • PLAN_YM — CHAR(6) — NOT NULL
  • PLAN_MNTH_WK_NO — NUMBER(1)
  • RUN_WK — CHAR(6) — NOT NULL
  • RUN_YM — CHAR(6) — NOT NULL
  • RUN_MNTH_WK_NO — NUMBER(1)
  • SALES_CD — VARCHAR2(40) — NOT NULL
  • QTY — NUMBER(15,4) — NOT NULL
  • CTGR_NM — VARCHAR2(100) — NOT NULL
  • CSTM_CD — VARCHAR2(40)
  • CSTM_NM — VARCHAR2(90)
  • USE_YN — CHAR(1) — NOT NULL
  • CRT_USER — VARCHAR2(30) — NOT NULL
  • CRT_DTTM — TIMESTAMP — NOT NULL
  • MDFY_USER — VARCHAR2(30) — NOT NULL
  • MDFY_DTTM — TIMESTAMP — NOT NULL