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