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