OSCWMS

테이블 (3)

CM_CAR

  • SITE_CD — VARCHAR2 — 기본 키 — NOT NULL
  • STORE_CD — VARCHAR2 — 기본 키 — NOT NULL
  • DRIVER_CD — VARCHAR2 — 기본 키 — NOT NULL
  • DRIVER_NM — VARCHAR2
  • HP_NO — VARCHAR2
  • CAR_NO — VARCHAR2
  • DRCOM_CD — VARCHAR2
  • CAR_TYPE — VARCHAR2
  • PREFER_ROUTE — VARCHAR2 — NOT NULL
  • START_TIME — VARCHAR2
  • TRAVEL_TIME1 — NUMBER
  • TRAVEL_TIME2 — NUMBER
  • SERVICE_TIME — NUMBER
  • MEMO — VARCHAR2
  • USE_AT — CHAR
  • RGT_DATE — DATE
  • RGTER — VARCHAR2
  • UPT_DATE — DATE
  • UPTER — VARCHAR2

거래처 (CUST)

  • SITE_CD (사이트코드) — VARCHAR(2) — 기본 키 — NOT NULL
  • CUST (거래처) — VARCHAR(20) — 기본 키 — NOT NULL
  • PLACE (착지) — VARCHAR(5) — 기본 키 — NOT NULL
  • SDF (Field)
  • Field2
  • Field3
  • Field4
  • Field5
  • Field6
  • Field7

상품 (CM_SKU)

  • Key — 기본 키 — NOT NULL
  • 거래처코드 (SITE_CD) — VARCHAR2 — 기본 키 — NOT NULL
  • 상품코드 (SKU_CD) — VARCHAR2 — 기본 키 — NOT NULL
  • CONCAT_CD — NUMBER — NOT NULL
  • SKU_NM — VARCHAR2
  • SKU_TYPE — VARCHAR2
  • SKU_BRAND — VARCHAR2
  • SACOM_CD — VARCHAR2
  • VECOM_CD — VARCHAR2
  • STORE_CD — VARCHAR2
  • SKU_BARCODE — VARCHAR2
  • LEAD_DAY — NUMBER
  • ORGIN_CD — VARCHAR2
  • MAKER_CD — VARCHAR2
  • MEMO — VARCHAR2
  • USE_AT — CHAR
  • STANDARD — VARCHAR2
  • SKU_DESC — CLOB
  • STOCK_LIMIT_YN — CHAR
  • BIND_YN — CHAR
  • IO_UNIT — VARCHAR2
  • DELIVERY_FEE — NUMBER
  • ATCH_FILE_ID1 — VARCHAR2
  • ATCH_FILE_ID2 — VARCHAR2
  • ATCH_FILE_ID3 — VARCHAR2
  • ATCH_FILE_ID4 — VARCHAR2
  • READ_CNT — NUMBER
  • FRST_REGIST_PNTTM — DATE
  • FRST_REGISTER_ID — VARCHAR2
  • LAST_UPDT_PNTTM — DATE
  • LAST_UPDUSR_ID — VARCHAR2
  • VAT_AT — CHAR
  • MAIN_MENU_STORE — CHAR
  • MAIN_VIEW_STORE — CHAR
  • SEARCH_KEYWORD — VARCHAR2
  • DISPLAY_AT — CHAR
  • Field