S&OP
Tables (11)
SN_ACCOUNT
- ACCOUNT_ID — VARCHAR(100) — Primary key — NOT NULL
- SALES_LEVEL_ID — VARCHAR(100) — Foreign key → SN_SALES_LEVEL.SALES_LEVEL_ID — NOT NULL
- ACCOUNT_NAME — NVARCHAR(100) — NOT NULL
SN_AGING
- AGING_ID — VARCHAR(100) — Primary key — NOT NULL
- AGING_NAME — VARCHAR(100)
SN_INVENTORY
- TIME_ID — VARCHAR(8) — Foreign key → SN_TIME.TIME_ID — NOT NULL — 기말 일자
- LOCATION_ID — VARCHAR(100) — Foreign key → SN_LOCATION.LOCATION_ID — NOT NULL — 공급 거점 (PLANT)
- ITEM_ID — VARCHAR(100) — Foreign key → SN_ITEM.ITEM_ID — NOT NULL
- AGING_ID — VARCHAR(100) — Foreign key → SN_AGING.AGING_ID — NOT NULL
- AVAILABLE_QTY — DECIMAL(20, 3) — NOT NULL
SN_ITEM
- ITEM_ID — VARCHAR(100) — Primary key — NOT NULL
- ITEM_LEVEL_ID — VARCHAR(100) — Foreign key → SN_ITEM_LEVEL.ITEM_LEVEL_ID — NOT NULL
- ITEM_NAME — NVARCHAR(100) — NOT NULL
- ITEM_TYPE — VARCHAR(20) — NOT NULL
SN_ITEM_LEVEL
- ITEM_LEVEL_ID — VARCHAR(100) — Primary key — NOT NULL
- ITEM_LEVEL_01 — VARCHAR(100)
- ITEM_LEVEL_02 — VARCHAR(100)
- ITEM_LEVEL_03 — VARCHAR(100)
- ITEM_LEVEL_04 — VARCHAR(100)
- ITEM_LEVEL_05 — VARCHAR(100)
- ITEM_LEVEL_06 — VARCHAR(100)
- ITEM_LEVEL_07 — VARCHAR(100)
- ITEM_LEVEL_08 — VARCHAR(100)
- ITEM_LEVEL_09 — VARCHAR(100)
- ITEM_LEVEL_10 — VARCHAR(100)
SN_LOCATION
- LOCATION_ID — VARCHAR(100) — Primary key — NOT NULL
- COUNTRY — NVARCHAR(100)
- STATE — NVARCHAR(100)
- REGION — NVARCHAR(100)
- CITY — NVARCHAR(100)
- ADDRESS — NVARCHAR(200)
SN_SALES
- ACCOUNT_ID — VARCHAR(100) — Foreign key → SN_ACCOUNT.ACCOUNT_ID — NOT NULL
- LOCATION_ID — VARCHAR(100) — Foreign key → SN_LOCATION.LOCATION_ID — NOT NULL
- TIME_ID — VARCHAR(8) — Foreign key → SN_TIME.TIME_ID — NOT NULL — 20190829
- ITEM_ID — VARCHAR(100) — Foreign key → SN_ITEM.ITEM_ID — NOT NULL
- SALES_PLAN_QTY — DECIMAL(20, 3) — NOT NULL
- SALES_ACTUAL_QTY — DECIMAL(20, 3)
- BUSINESS_PLAN_QTY — DECIMAL(20, 3)
- SALES_PLAN_PRICE — DECIMAL(20, 3)
- SALES_ACTUAL_PRICE — DECIMAL(20, 3)
- BUSINESS_PLAN_PRICE — DECIMAL(20, 3)
- CURRENCY — VARCHAR(10) — KRW
SN_SALES_LEVEL
- SALES_LEVEL_ID — VARCHAR(100) — Primary key — NOT NULL
- SALES_LEVEL_01 — VARCHAR(100)
- SALES_LEVEL_02 — VARCHAR(100)
- SALES_LEVEL_03 — VARCHAR(100)
- SALES_LEVEL_04 — VARCHAR(100)
- SALES_LEVEL_05 — VARCHAR(100)
- SALES_LEVEL_06 — VARCHAR(100)
- SALES_LEVEL_07 — VARCHAR(100)
- SALES_LEVEL_08 — VARCHAR(100)
- SALES_LEVEL_09 — VARCHAR(100)
- SALES_LEVEL_10 — VARCHAR(100)
SN_SUPPLY
- ACCOUNT_ID — NVARCHAR(100) — Foreign key → SN_ACCOUNT.ACCOUNT_ID — NOT NULL
- LOCATION_ID — NVARCHAR(100) — Foreign key → SN_LOCATION.LOCATION_ID — NOT NULL
- TIME_ID — CHAR(8) — Foreign key → SN_TIME.TIME_ID — NOT NULL — 20190829
- ITEM_ID — NVARCHAR(100) — Foreign key → SN_ITEM.ITEM_ID — NOT NULL
- DEMAND_QTY — DECIMAL(20, 3) — NOT NULL
- DEMAND_COUNT — INTEGER
- SUPPLY_QTY — DECIMAL(20, 3) — NOT NULL
- RTF_QTY — DECIMAL(20, 3)
- BOH_QTY — DECIMAL(20, 3)
- INVENTORY_QTY — DECIMAL(20, 3)
- ON_TIME_QTY — DECIMAL(20, 3)
- ON_TIME_COUNT — INTEGER
- SHIPMENT_QTY — DECIMAL(20, 3)
- SHIPMENT_COUNT — INTEGER
SN_SUPPLY_SHORTAGE
- SHORTAGE_GROUP — VARCHAR(10) — Primary key — NOT NULL — SHORT | LATE
- SHORTAGE_TYPE — VARCHAR(20) — Primary key — NOT NULL — CAPACITY | MATERIAL
- ACCOUNT_ID — VARCHAR(100) — Foreign key → SN_ACCOUNT.ACCOUNT_ID — NOT NULL
- LOCATION_ID — VARCHAR(100) — Foreign key → SN_LOCATION.LOCATION_ID — NOT NULL
- ITEM_ID — VARCHAR(100) — Foreign key → SN_ITEM.ITEM_ID — NOT NULL
- TIME_ID — VARCHAR(8) — Foreign key → SN_TIME.TIME_ID — NOT NULL — 20190829
- DEMAND_QTY — DECIMAL(20, 3) — NOT NULL
- DEMAND_COUNT (DEMADN_COUNT) — INTEGER
- SHORTAGE_QTY — DECIMAL(20, 3) — NOT NULL
- SHORTAGE_COUNT — INTEGER
SN_TIME
- TIME_ID — VARCHAR(8) — Primary key — NOT NULL — 20190829
- TIME_DATE — DATE — NOT NULL
- YYYY — VARCHAR(4) — NOT NULL — 2019
- MM — VARCHAR(2) — NOT NULL — 08
- DD — VARCHAR(2) — NOT NULL — 29
- QTR — INTEGER — 1|2|3|4
- WK52 — VARCHAR(2) — 1 ... 52
- PARTWK — VARCHAR(1) — A | B
- DAY_OF_WEEK — INTEGER — 1 ... 7