AI

Tables (11)

CDMS_TBL_MASTER_POS_INVENTORY (2)

  • POS_DATE (날짜) — DATETIME — Primary key — NOT NULL
  • CHANNEL_CODE (채널코드) — NVARCHAR(100) — Primary key
  • PRODUCT_CODE (바코드) — NVARCHAR(100) — Primary key
  • CHANNEL_NAME (채널이름) — NVARCHAR(1000)
  • PRODUCT_NAME (상품명) — NVARCHAR(1000)
  • MATERIAL_CODE (자재코드) — NVARCHAR(100)
  • MATERIAL_NAME (자재이름) — NVARCHAR(1000)
  • INVENTORY_QTY (고객재고) — NUMERIC(36,0)
  • INVENTORY_AMT (Field)
  • DESCRIPTION (Field2)
  • UNIT (Field3)
  • CREATE (Field4)
  • CREATEDBY (Field5)
  • MODIFIED (Field6)
  • MODIFIEDBY (Field7)

CDMS_TBL_MASTER_POS_INVENTORY_STORE (3)

  • POS_DATE (날짜) — DATETIME — Primary key — NOT NULL
  • CHANNEL_CODE (채널코드) — NVARCHAR(100) — Primary key
  • PRODUCT_CODE (바코드) — NVARCHAR(100) — Primary key
  • STORE_CODE (점포코드) — NVARCHAR(100) — Primary key — NOT NULL
  • CHANNEL_NAME (채널이름) — NVARCHAR(1000)
  • STORE_NAME (점포이름) — NVARCHAR(1000)
  • PRODUCT_NAME (상품명) — NVARCHAR(1000)
  • MATERIAL_CODE (자재코드) — NVARCHAR(100)
  • MATERIAL_NAME (자재이름) — NVARCHAR(1000)
  • INVENTORY_QTY (고객재고) — NUMERIC(36,0)

CDMS_TBL_MASTER_POS_SALES (4)

  • POS_DATE (날짜) — DATETIME — Primary key — NOT NULL
  • CHANNEL_CODE (채널코드) — NVARCHAR(100) — Primary key
  • PRODUCT_CODE (바코드) — NVARCHAR(100) — Primary key
  • CHANNEL_NAME (채널이름) — NVARCHAR(1000)
  • PRODUCT_NAME (상품명) — NVARCHAR(1000)
  • MATERIAL_CODE (자재코드) — NVARCHAR(100)
  • MATERIAL_NAME (자재이름) — NVARCHAR(1000)
  • INVENTORY_QTY (고객재고) — NUMERIC(36,0)
  • INVENTORY_AMT (Field)
  • DESCRIPTION (Field2)
  • UNIT (Field3)
  • CREATE (Field4)
  • CREATEDBY (Field5)
  • MODIFIED (Field6)
  • MODIFIEDBY (Field7)

CDMS_TBL_MASTER_POS_SALES_STORE (5)

  • POS_DATE (날짜) — DATETIME — Primary key — NOT NULL
  • CHANNEL_CODE (채널코드) — NVARCHAR(100) — Primary key
  • PRODUCT_CODE (바코드) — NVARCHAR(100) — Primary key
  • STORE_CODE (점포코드) — NVARCHAR(100) — Primary key — NOT NULL
  • CHANNEL_NAME (채널이름) — NVARCHAR(1000)
  • STORE_NAME (점포이름) — NVARCHAR(1000)
  • PRODUCT_NAME (상품명) — NVARCHAR(1000)
  • MATERIAL_CODE (자재코드) — NVARCHAR(100)
  • MATERIAL_NAME (자재이름) — NVARCHAR(1000)
  • INVENTORY_QTY (고객재고) — NUMERIC(36,0)

CDMS_TBL_MASTER_SPI_ALL (1)

  • SPI_DATE (날짜) — VARCHAR(10) — Primary key — NOT NULL
  • MATERIAL_ID (자재코드) — VARCHAR(100) — Primary key — NOT NULL
  • BAGS_PER_C (입수) — VARCHAR
  • SU_PER_CS (Field) — VARCHAR
  • CASE_PER_P (Field2) — VARCHAR
  • OPENING_STOCK (-) — VARCHAR
  • ON_HAND_STOCK (YK재고) — VARCHAR
  • AVERAGE_PRICE (Field4) — VARCHAR
  • SALES_MTD (Field3) — VARCHAR
  • PRODUCT_MTO (Field5) — VARCHAR
  • ATP_QUANTITY (Field6) — VARCHAR
  • IF_DATE (Field7) — DATETIME
  • Field8

MASTER_MATERIAL (Untitled)

  • MATERIAL_ID (자재코드) — VARCHAR(20) — Primary key — NOT NULL
  • MATERIAL_NAME (자재이름) — VARCHAR(100)
  • DIVISION (사업부) — VARCHAR(10)
  • SUB_CATEGORY (서브카테고리) — VARCHAR(10)
  • EAN_ID (바코드(88)) — VARCHAR(20)
  • EAN_BOX (바코드(188)) — VARCHAR(20)
  • EA_CS (입수) — VARCHAR(10)

MASTER_SALES_ORG (Untitled4)

  • SALES_TEAM (채널코드) — VARCHAR(20) — Primary key — NOT NULL
  • SALES_TEAM_NAME (채널이름) — VARCHAR(100)
  • SALES_DIVISION (사업부) — VARCHAR(20)
  • SALES_HQ (최상위채널코드) — VARCHAR(20)
  • SALES_HQ_NAME (최상위채널이름) — VARCHAR(100)
  • SUB_REGION (상위채널코드) — VARCHAR(20)
  • SUB_REGION_NAME (상위채널이름) — VARCHAR(100)

SALES_ACTS (Untitled2)

  • SALES_TEAM (채널코드) — VARCHAR(20) — Primary key — NOT NULL
  • MATERIAL_ID (자재코드) — VARCHAR(20) — Primary key — NOT NULL
  • ACTS_DATE (출고날짜) — VARCHAR(10) — Primary key — NOT NULL
  • ACTS_QTY (출고량) — NUMERIC(18,3)

SALES_ORDER (CopyOfUntitled2)

  • SALES_TEAM (채널코드) — VARCHAR(20) — Primary key — NOT NULL
  • MATERIAL_ID (자재코드) — VARCHAR(20) — Primary key — NOT NULL
  • ORDER_DATE (주문날짜) — VARCHAR(10) — Primary key — NOT NULL
  • ORDER_QTY (주문량) — NUMERIC(18,3)

SALES_PLAN_PROM (Untitled3)

  • SALES_TEAM (채널코드) — VARCHAR(20) — Primary key — NOT NULL
  • MATERIAL_ID (자재코드) — VARCHAR(20) — Primary key — NOT NULL
  • YYYYMM (년월) — VARCHAR(8) — Primary key — NOT NULL
  • YYYYMM_SEQ (주차) — INT — Primary key — NOT NULL
  • PROM_NAME (행사명) — VARCHAR(200)
  • PROM_QTY (행사총량) — NUMERIC(18,3)
  • S_DATE (시작일) — VARCHAR(8)
  • E_DATE (종료일) — VARCHAR(8)
  • FIRST_DUE_DATE (초도일) — VARCHAR(8)
  • FIRST_DUE_QTY (초도량) — NUMERIC(18,3)

Untitled5

  • POS_DATE (날짜) — DATETIME — Primary key — NOT NULL
  • CHANNEL_CODE (채널코드) — VARCHAR(100) — Primary key — NOT NULL
  • CHANNEL_YN (채널유무) — INT — Primary key — NOT NULL
  • STORE_CODE (점포코드) — NVARCHAR(100) — Primary key — NOT NULL
  • STORE_YN (점포유무) — INT — Primary key — NOT NULL
  • EAN_ID (바코드) — VARCHAR(20) — Primary key — NOT NULL
  • MATERIAL_ID (자재코드2) — VARCHAR(20) — Foreign key → MASTER_MATERIAL.MATERIAL_ID — NOT NULL
  • SALES_TEAM (채널코드2) — VARCHAR(20) — Foreign key → SALES_ORDER.SALES_TEAM — NOT NULL
  • MATERIAL_ID (자재코드3) — VARCHAR(20) — Foreign key → SALES_ORDER.MATERIAL_ID — NOT NULL
  • ORDER_DATE (주문날짜) — VARCHAR(10) — Foreign key → SALES_ORDER.ORDER_DATE — NOT NULL
  • SALES_TEAM (채널코드3) — VARCHAR(20) — Foreign key → SALES_ACTS.SALES_TEAM — NOT NULL
  • MATERIAL_ID (자재코드4) — VARCHAR(20) — Foreign key → SALES_ACTS.MATERIAL_ID — NOT NULL
  • ACTS_DATE (출고날짜) — VARCHAR(10) — Foreign key → SALES_ACTS.ACTS_DATE — NOT NULL
  • SALES_TEAM (채널코드4) — VARCHAR(20) — Foreign key → SALES_PLAN_PROM.SALES_TEAM — NOT NULL
  • MATERIAL_ID (자재코드5) — VARCHAR(20) — Foreign key → SALES_PLAN_PROM.MATERIAL_ID — NOT NULL
  • YYYYMM (년월2) — VARCHAR(8) — Foreign key → SALES_PLAN_PROM.YYYYMM — NOT NULL
  • YYYYMM_SEQ (주차2) — INT — Foreign key → SALES_PLAN_PROM.YYYYMM_SEQ — NOT NULL
  • SPI_DATE (날짜2) — VARCHAR(10) — Foreign key → CDMS_TBL_MASTER_SPI_ALL.SPI_DATE — NOT NULL
  • MATERIAL_ID (자재코드6) — VARCHAR(100) — Foreign key → CDMS_TBL_MASTER_SPI_ALL.MATERIAL_ID — NOT NULL
  • CAHNNEL_NAME (채널이름) — VARCHAR(1000)
  • STORE_NAME (점포이름) — VARCHAR(1000)
  • MATERIAL_CODE (자재코드) — VARHCHAR(20)
  • DIVISION (사업부) — VARCHAR(10)
  • SUB_CATEGORY (서브카테고리) — VARCHAR(10)
  • EA_CS (입수) — VARCHAR(10)
  • SALES_QTY (고객판매량) — NUMERIC(36,0)
  • SALES_YN (고객판매량유무) — INT
  • INVENTORY_QTY (고객재고량) — NUMERIC(36,0)
  • INVENTORY_YN (고객재고유무) — INT
  • PROM_YN (행사유무) — INT
  • ORDER_YN (주문유무) — INT
  • ORDER_QTY (주문량) — NUMERIC(36,0)
  • ORDER_INTERVAL (주문간격) — INT
  • ACTS_YN (출고유무) — INT
  • ACTS_QTY (출고량) — NUMERIC(18,0)
  • ON_HAND_STOCK (YK재고) — NUMERIC(18,0)
  • STOCK_OUT (결품유무) — NUMERIC(18,0)
  • WEEKDAY_INDEX (요일지수) — NUMERIC(18,0)
  • SAL_AVG (평균판매량) — NUMERIC(18,3)
  • INV_RATENCY (재고회전일) — INT
  • YYYYMM (년월) — VARCAHR(6)
  • MM (월) — INT
  • DD (일) — INT
  • DW (요일(숫자)) — INT
  • SEQ (주차) — INT
  • HOLIDAY (공휴일유무) — INT
  • BUSINESS_DAY (영업일유무) — INT
  • PROM_NAME (행사명) — VARCHAR(200)
  • PROM_QTY (행사량) — NUMERIC(18,3)
  • S_dATE (행사시작일) — VARCHAR(8)
  • E_DATE (행사종료일) — VARCHAR(8)
  • PROM_DURATION (행사기간) — INT
  • FIRST_DUE_DATE (초도일) — VARCHAR(18,3)
  • FIRST_QTY (초도량) — NUMERIC(18,3)
  • FIRST_YN (초도일여부) — INT