근우_랩투마켓_테스트
테이블 (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)