롯데 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