근우_랩투마켓_테스트

테이블 (3)

TB_PART

  • PART — VARCHAR2(16) — 기본 키
  • PARTNM — VARCHAR2(30)
  • INNER_QTY — NUMBER(7)
  • PACK_QTY — NUMBER(7)
  • UNIT_WGT — NUMBER(10,2)
  • LENGTH — NUMBER(7)
  • WIDTH — NUMBER(7)
  • HEIGHT — NUMBER(7)
  • DIV4_FL — VARCHAR2(1)
  • INSERT_DT — DATE
  • UPDATE_USER — VARCHAR2(10)
  • UPDATE_DT — DATE
  • UNIT_PRICE — NUMBER(9)
  • PBOX_KIND — VARCHAR2(2)
  • BLOCK_FL — VARCHAR2(1)
  • BOX_ID — VARCHAR2(13) — 외래 키 → TB_YBBOX.BOX_ID

TB_YBBOX

  • BOX_ID — VARCHAR2(13) — 기본 키
  • FACTORY_CD — VARCHAR2(1)
  • FLOOR_NO — NUMBER(1)
  • ZONE_CD — NUMBER(1)
  • SUBZONE_CD — VARCHAR2(3)
  • RACK_NO — NUMBER(3)
  • RACK_LEVEL — NUMBER(1)
  • X_POS — NUMBER(1)
  • Y_POS — NUMBER(1)
  • Z_POS — NUMBER(1)
  • BOX_GBN — CHAR(1)
  • SAVE_GBN — CHAR(1)
  • SAVE_FL — VARCHAR2(1)
  • BLOCK_FL — VARCHAR2(1)
  • LAST_POS — NUMBER(3)
  • SCAN_DT — TIMESTAMP
  • IN_STCNO — NUMBER(3)
  • BOX_WGT — NUMBER(10,2)
  • IN_QTY — NUMBER(7)
  • IN_WGT — NUMBER(10,2)
  • ORDERID — VARCHAR2(12)
  • JOBNO — NUMBER(3)
  • JOB_TYPE — NUMBER(3)
  • STS — NUMBER(2)
  • ERR_CODE — NUMBER(3)
  • PROCESS_01_DT — DATE
  • PROCESS_02_DT — DATE
  • PROCESS_03_DT — DATE
  • PROCESS_04_DT — DATE
  • PROCESS_05_DT — DATE
  • PROCESS_06_DT — DATE
  • PROCESS_07_DT — DATE
  • PROCESS_08_DT — DATE
  • PROCESS_09_DT — DATE
  • PROCESS_10_DT — DATE
  • PROCESS_11_DT — DATE
  • PROCESS_12_DT — DATE
  • PROCESS_13_DT — DATE
  • PROCESS_14_DT — DATE
  • PROCESS_15_DT — DATE
  • PROCESS_16_DT — DATE
  • PROCESS_17_DT — DATE
  • PROCESS_18_DT — DATE
  • PROCESS_19_DT — DATE
  • USERID — VARCHAR2(10)
  • INSERT_DT — DATE
  • UPDATE_DT — DATE
  • DIV4_FL — NUMBER(1)

TB_YBBOX_PART

  • SEQ — NUMBER(2) — 기본 키 — NOT NULL
  • BOX_ID (BOX_ID2) — VARCHAR2(13) — 외래 키 → TB_YBBOX.BOX_ID
  • PART (PART2) — VARCHAR2(16) — 외래 키 → TB_PART.PART
  • REC_ID_01 — VARCHAR2(20)
  • REC_ID_02 — VARCHAR2(20)
  • REC_ID_ETC — VARCHAR2(20)
  • VENDER — VARCHAR2(4)
  • IN_QTY — NUMBER(7)
  • QTY — NUMBER(7)
  • USE_QTY — NUMBER(7)
  • OUT_QTY — NUMBER(7)
  • OSD_QTY — NUMBER(7)
  • WEIGHT — NUMBER(10,2)
  • WEIGHT_FL — VARCHAR2(1)
  • INSERT_DT — DATE
  • UPDATE_DT — DATE
  • SSNUM — NUMBER(4)
  • LEADTIME — NUMBER(2)
  • REORDER_PT — VARCHAR2(6)