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