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