솔루에타-운송의뢰

테이블 (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