롯데 SFA2.5 고도화 프로젝트
테이블 (11)
TB_COM_PUSH_MESSAGE (푸시 메시지)
- Key (PUSH_SEQ) — NUMBER — 기본 키 — NOT NULL
- Field (PUSH_MESSAGE_SEQ) — NUMBER
- Field (PUSH_CATEGORY_CD) — VARCHAR(10)
- Field (PUSH_CATEGORY_NM) — VARCHAR(100)
- Field (SEND_DATE) — VARCHAR(8)
- Field (SEND_TIME) — VARCHAR(6)
- Field (PUSH_TITLE) — VARCHAR(4000)
- Field (PUSH_MESSAGE) — VARCHAR(4000)
- Field (READ_YN) — CHAR(1)
- Field (SEND_EMP_ID) — VARCHAR(8)
- Field (RECEIVE_EMP_ID) — VARCHAR(8)
- Field (REG_ID) — VARCHAR(20)
- Field (REG_DATE) — DATE
- Field (MOD_ID) — VARCHAR(20)
- Field (MOD_DATE) — DATE
- Field (MESSAGE_PAYLOAD) — VARCHAR(4000)
- Field (SEND_SYSTEM) — VARCHAR(50)
TB_SAL_CUST_MEMO_CHECKLIST (거래처 메모장 체크리스트)
- Key (CUST_CD) — VARCHAR(10) — 기본 키 — NOT NULL
- Field (MULTI_STORE_CHAIN) — VARCHAR(1)
- Field (ORDER_CONSULT_CHARGE) — VARCHAR(9)
- Field (OPEN_HOURS) — VARCHAR(1)
- Field (DELIVERY_TIME) — VARCHAR(7)
- Field (DEADLINE) — VARCHAR(1)
- Field (COLLECTION_CYCLE) — VARCHAR(1)
- Field (COLLECTION_TYPE) — VARCHAR(9)
- Field (VISIT_CYCLE) — VARCHAR(1)
- Field (COMMERCIAL_DISTRICT) — VARCHAR(26)
- Field (REG_ID) — VARCHAR(20)
- Field (REG_DATE) — DATE
- Field (MOD_ID) — VARCHAR(20)
- Field (MOD_DATE) — DATE
TB_SAL_CUST_MEMO_HISTORY (거래처 메모 히스토리)
- Key (HISTORY_SEQ) — NUMBER — 기본 키 — NOT NULL
- Field (CUST_CD) — VARCHAR(10)
- Field (HISTORY_DATE) — CHAR(8)
- Field (MEMO) — VARCHAR(1000)
- Field (REG_ID) — VARCHAR(20)
- Field (REG_DATE) — DATE
- Field (MOD_ID) — VARCHAR(20)
- Field (MOD_DATE) — DATE
TB_SAL_CUST_MST (거래처 마스터)
- Key (CUST_CD) — VARCHAR(10) — 기본 키 — NOT NULL
- Field (CUST_NM) — VARCHAR(100)
TB_SAL_CUST_UNIQUE (거래처 특이사항)
- Key (UNIQUE_SEQ) — NUMBER(15) — 기본 키 — NOT NULL
- Field (CUST_CD) — VARCHAR(10)
- Field (UNIQUE_IMG_PATH) — VARCHAR(200)
- Field (REMARK) — VARCHAR(100)
- Field (REG_ID) — VARCHAR(20)
- Field (REG_DATE) — DATE
- Field (MOD_ID) — VARCHAR(20)
- Field (MOD_DATE) — DATE
TB_SAL_RTM_ACT_FILE (활동관리 파일)
- Key (ACT_FILE_SEQ) — NUMBER — 기본 키 — NOT NULL
- Field (CUST_CD) — VARCHAR(10)
- Field (ACT_DATE) — VARCHAR(8)
- Field (UPLOAD_DATE) — VARCHAR(14)
- Field (UPLOAD_EMP_ID) — VARCHAR(20)
- Field (FILE_SE_CD) — VARCHAR(10)
- Field (ORG_FILE_NM) — VARCHAR(100)
- Field (SRV_FILE_NM) — VARCHAR(100)
- Field (FILE_TYPE) — VARCHAR(20)
- Field (ORDER_NUM) — NUMBER
- Field (REG_ID) — VARCHAR(20)
- Field (REG_DATE) — DATE
- Field (MOD_ID) — VARCHAR(20)
- Field (MOD_DATE) — DATE
- Field (DATA_USE_FLAG) — CHAR(1)
- Field (NOTE) — VARCHAR(100)
- Field (CATEGORY) — VARCHAR(20)
TB_SAL_RTM_ACT_MST (활동관리 마스터)
- Key (CUST_CD) — VARCHAR(10) — 기본 키 — NOT NULL
- Key (ACT_DATE) — CHAR(8) — 기본 키 — NOT NULL
- Field (BRANCH_CD) — VARCHAR(3)
- Field (ROUTE_NO) — VARCHAR(3)
- Field (CUST_NM) — VARCHAR(100)
- Field (CHANNEL_CD) — CHAR(6)
- Field (CHANNEL_NM) — CHAR(50)
- Field (SALE_TABLE_YN) — CHAR(5)
- Field (WAREHOUSE_YN) — CHAR(5)
- Field (DISPLAY_YN) — CHAR(5)
- Field (ACT_RECORD) — VARCHAR(2000)
- Field (FEEDBACK_YN) — CHAR(1)
- Field (REG_ID) — VARCHAR(20)
- Field (REG_DATE) — DATE
- Field (MOD_ID) — VARCHAR(20)
- Field (MOD_DATE) — DATE
- Field (CHECK_YN) — CHAR(1)
- Field (BEST_YN) — CHAR(1)
- Field (FEEDBACK_RES_YN) — CHAR(1)
- Field (PROMO_YN) — CHAR(1)
- Field (MAIN_SALE_ACT) — VARCHAR(9)
- Field (EVENT_NICHE) — VARCHAR(9)
- Field (SALES_ACT) — VARCHAR(9)
- Field (STR_OWNER_INTER) — VARCHAR(9)
- Field (MAIN_MAKEUP_DISPLAY_YN) — VARCHAR(1)
- Field (MAIN_PRICE_TAG_YN) — VARCHAR(1)
- Field (MAIN_DISPLAY_LOC_CHG_YN) — VARCHAR(1)
- Field (MAIN_DISPLAY_LINE_ENLARGE_YN) — VARCHAR(1)
- Field (MAIN_NEW_PRD_DISPLAY_YN) — VARCHAR(1)
- Field (EVENT_MAKEUP_DISPLAY_YN) — VARCHAR(1)
- Field (EVENT_PRICE_TAG_YN) — VARCHAR(1)
- Field (EVENT_POSM_IMPROVE_YN) — VARCHAR(1)
- Field (EVENT_POS_MOVE_YN) — VARCHAR(1)
- Field (EVENT_NEW_SHELP_INSTALL_YN) — VARCHAR(1)
- Field (SALES_EQUIP_INSPECT_YN) — VARCHAR(1)
- Field (SALES_INVENTORY_YN) — VARCHAR(1)
- Field (SALES_PRD_DISPLAY_YN) — VARCHAR(1)
- Field (SALES_BAS_PROMOTION_YN) — VARCHAR(1)
- Field (SALES_CLAIMS_PROCESS_YN) — VARCHAR(1)
- Field (STR_COLLECTION_CLOSE_YN) — VARCHAR(1)
- Field (STR_ACT_EVENT_YN) — VARCHAR(1)
- Field (STR_ESTIMATE_YN) — VARCHAR(1)
- Field (STR_SALE_CONSULT_YN) — VARCHAR(1)
- Field (STR_OTHER_ACT_YN) — VARCHAR(1)
TB_SAL_SHIPPING_UNIQUE (배송특이사항)
- Key (UNIQUE_SEQ) — NUMBER(15) — 기본 키 — NOT NULL
- Field (BRANCH_CD) — VARCHAR(3)
- Field (ROUTE_NO) — VARCHAR(3)
- Field (CUST_CD) — VARCHAR(10)
- Field (ORDER_NO) — VARCHAR(10)
- Field (SHIPPING_UNIQUE) — VARCHAR(1000)
- Field (REG_ID) — VARCHAR(20)
- Field (REG_DATE) — DATE
- Field (MOD_ID) — VARCHAR(20)
- Field (MOD_DATE) — DATE
TB_WINE_CHECK_STOCK (매장재고 실사)
- Key (CHECK_STOCK_SEQ) — NUMBER(15) — 기본 키 — NOT NULL
- Field (CHECK_MONTH) — CHAR(6)
- Field (ROUTE_CD) — VARCHAR(10)
- Field (CHECK_DATE) — CHAR(8)
- Field (REG_ID) — VARCHAR(20)
- Field (REG_DATE) — DATE
- Field (MOD_ID) — VARCHAR(20)
- Field (MOD_DATE) — DATE
- Field (SHOP_CD) — VARCHAR(10)
- Field (MODIFY_YN) — CHAR(1)
TB_WINE_CHECK_STOCK_DETAIL (매장재고 실사 상세)
- Key (CHECK_STOCK_SEQ) — NUMBER(15) — 기본 키 — NOT NULL
- Key (ITEM_CD) — VARCHAR(18) — 기본 키 — NOT NULL
- Field (ITEM_AMT) — NUMBER(15)
- Field (STOCK_CNT) — NUMBER(15)
- Field (CHECK_STOCK_CNT) — NUMBER(15)
- Field (GAP_CNT) — NUMBER(15)
- Field (GAP_REASON) — VARCHAR(100)
- Field (REG_ID) — VARCHAR(20)
- Field (REG_DATE) — DATE
- Field (MOD_ID) — VARCHAR(20)
- Field (MOD_DATE) — DATE
- Field (CHECK_YN) — CHAR(1)
- Field (BARCODE_READING_STOCK_CNT) — NUMBER(15)
- Field (WAREHOUSE1_STOCK_CNT) — NUMBER(15)
- Field (WAREHOUSE2_STOCK_CNT) — NUMBER(15)
- Field (WAREHOUSE3_STOCK_CNT) — NUMBER(15)
TB_WINE_CHECK_STOCK_DETAIL_TMP (매장재고 실사 상세 임시저장)
- Key (SHOP_CD) — VARCHAR(10) — 기본 키 — NOT NULL
- Key (SAVE_DATE) — CHAR(8) — 기본 키 — NOT NULL
- Key (ITEM_CD) — VARCHAR(18) — 기본 키 — NOT NULL
- Field (ITEM_AMT) — NUMBER(15)
- Field (STOCK_CNT) — NUMBER(15)
- Field (CHECK_STOCK_CNT) — NUMBER(15)
- Field (BARCODE_READING_STOCK_CNT) — NUMBER(15)
- Field (WAREHOUSE1_STOCK_CNT) — NUMBER(15)
- Field (WAREHOUSE2_STOCK_CNT) — NUMBER(15)
- Field (WAREHOUSE3_STOCK_CNT) — NUMBER(15)
- Field (CHECK_YN) — CHAR(1)
- Field (GAP_CNT) — NUMBER(15)
- Field (GAP_REASON) — VARCHAR(100)
- Field (REG_ID) — VARCHAR(20)
- Field (REG_DATE) — DATE
- Field (MOD_ID) — VARCHAR(20)
- Field (MOD_DATE) — DATE