솔루에타-운송의뢰
테이블 (8)
UTB_DISPATCH_ORDER
- DISPATCH_ORDER_ID — varchar(50) — NOT NULL
- CLIENT_ID — varchar(50)
- DEV_PLACE_ID — varchar(50)
- DISPATCH_ORDER_WAY — varchar(50)
- DISPATCH_CAR — varchar(50)
- DISPATCH_ORDER_YN — varchar(1)
- DISPATCH_ORDER_START_DTTM — datetime
- DISPATCH_ORDER_END_DTTM — datetime
- DISPATCH_ORDER_SUCCESS — varchar(1)
- ORDER_STATUS — int
- REMARK — varchar(255)
- CREATE_BY — varchar(50)
- CREATE_DTTM — datetime
- SAVE_BY — varchar(50)
- SAVE_DTTM — datetime
- ROW_STAMP — int
UTB_DISPATCH_ORDER_DETAIL
- DISPATCH_ORDER_ID — VARCHAR(50) — 기본 키 — NOT NULL
- DEV_ORDER_ID — VARCHAR(50) — 기본 키 — NOT NULL
- PART_ID — VARCHAR(50) — 기본 키 — NOT NULL
- LOT_NO — VARCHAR(50)
- INIT_QTY — FLOAT
- INPUT_INIT_QTY — FLOAT
- PALETTE_QTY — VARCHAR(50)
- REMARK — VARCHAR(255)
- CREATE_BY — VARCHAR(50)
- CREATE_DTTM — DATETIME
- SAVE_BY — VARCHAR(50)
- SAVE_DTTM — DATETIME
- ROW_STAMP — INT
UTB_TRANSIT_ORDER
- TRANSIT_ORDER_ID — VARCHAR(50) — NOT NULL
- ORDER_STATUS — INT
- REMARK — VARCHAR(255)
- CREATE_BY — VARCHAR(50)
- CREATE_DTTM — DATETIME
- SAVE_BY — VARCHAR(50
- SAVE_DTTM — DATETIME
UTB_TRANSIT_ORDER_ADDR
- Key (ADDR_ID) — VARCHAR(50) — 기본 키 — NOT NULL
- Field (ADDR_NAME) — VARCHAR(50)
- Field (ADDR_TYPE) — VARCHAR(50)
- Field (VALID) — INT
- Field (CREATE_BY) — VARCHAR(50)
- Field (CREATE_DTTM) — DATETIME
- Field (SAVE_BY) — VARCHAR(50)
- Field (SAVE_DTTM) — DATETIME
UTB_TRANSIT_ORDER_ADDR_CAR_COST
- Key (CLIENT_ID) — VARCHAR(50) — 기본 키 — NOT NULL
- Key (DEV_PLACE_ID) — VARCHAR(50) — 기본 키 — NOT NULL
- Field (ADDR_NAME) — VARCHAR(255)
- Field (ADDR1) — VARCHAR(50)
- Field (ADDR2) — VARCHAR(50)
- Field (CAR) — VARCHAR(50)
- Field (DELIVERY_GROUP) — VARCHAR(50)
- Field (COST) — FLOAT
- Field (CREATE_BY) — VARCHAR(50)
- Field (CREATE_DTTM) — DATETIME
- Field (SAVE_BY) — VARCHAR(50)
- Field (SAVE_DTTM) — DATETIME
UTB_TRANSIT_ORDER_CODE
- Key (GROUP_ID) — VARCHAR(50) — 기본 키 — NOT NULL
- Field (GROUP_NAME) — VARCHAR(50)
- Field (ADDR_CAR_USE) — INT
- Field (BASE_TYPE) — INT
- Field (VALID) — INT
- Field (CREATE_BY) — VARCHAR(50)
- Field (CREATE_DTTM) — DATETIME
- Field (SAVE_BY) — VARCHAR(50)
- Field (SAVE_DTTM) — DATETIME
UTB_TRANSIT_ORDER_CODE_VALUE
- Key (CODE) — VARCHAR(50) — 기본 키 — NOT NULL
- Key (GROUP_ID) — VARCHAR(50) — 외래 키 → UTB_TRANSIT_ORDER_CODE.Key — NOT NULL
- Field (CODE_NAME) — VARCHAR(50)
- Field (COST) — FLOAT
- Field (COST2) — FLOAT
- Field (VALID) — INT
- Field (CREATE_BY) — VARCHAR(50)
- Field (CREATE_DTTM) — DATETIME
- Field (SAVE_BY) — VARCHAR(50)
- Field (SAVE_DTTM) — DATETIME
UTB_TRANSIT_ORDER_DETAIL
- TRANSIT_ORDER_ID — VARCHAR(50) — NOT NULL
- DISPATCH_ORDER_ID — VARCHAR(50) — NOT NULL
- CLIENT_ID — VARCHAR(50)
- CLIENT_ADDR — VARCHAR(100)
- DEV_PLACE_ID — VARCHAR(50)
- DEV_PLACE_ADDR — VARCHAR(100)
- TRANSIT_COST — INT
- ADD_COST — INT
- ORDER_STATUS — INT
- REMARK — VARCHAR(255)
- CREATE_BY — VARCHAR(50)
- CREATE_DTTM — DATETIME
- SAVE_BY — VARCHAR(50
- SAVE_DTTM — DATETIME