재경 테이블 통합
테이블 (7)
Copy Of MES_DETAILSITEMINFO_TB - 세부 품목정보 관리 테이블(제품) (MDT2)
- DETAILSITEMINFO_SQ (Key) — INT(11) — 기본 키 — NOT NULL
- ITEM_SQ (Key2) — INT(11) — 외래 키 → Copy Of MES_ITEMINFO_TB - 품목정보 관리 테이블(제품).ITEM_SQ — NOT NULL
- LENGTH (Field2) — VARCHAR(30)
- PRICE_GB (Field3) — VARCHAR(30)
- UNIT (Field4) — VARCHAR(7)
- UNIT_GB (Field5) — VARCHAR(30)
- UNIT_M (Field6) — VARCHAR(30)
- UNIT_KG (Field7) — VARCHAR(30)
- MODEL_NM (Field8) — VARCHAR(45)
- WEIGHT (Field9) — VARCHAR(30)
Copy Of MES_ITEMINFO_TB - 품목정보 관리 테이블(제품) (MIIT2)
- ITEM_SQ (Key) — INT(11) — 기본 키 — NOT NULL
- ITEM_NM (Field) — INT(11)
- ITEM_TYPE (Field2) — INT(11)
- CUSTOMER_SQ (Field3) — INT(11)
- STANDARD (Field4) — VARCHAR(30)
- PRODUCT (Field5) — VARCHAR(10)
- ASPECT (Field6) — VARCHAR(30)
- STANDARDUNIT (Field7) — VARCHAR(30)
- MATERIAL (Field8) — VARCHAR(30)
- OUTERDIAMETER (Field9) — VARCHAR(30)
- NTERNALDIAMETER (Field10) — VARCHAR(30)
- THICKNESS (Field11) — VARCHAR(30)
- WEIGHT (Field12) — VARCHAR(30)
- UNITUSE (Field13) — VARCHAR(3)
- VIGO (Field14) — VARCHAR(50)
- VERTICAL (Field15) — DOUBLE
- HORIZONTAL (Field16) — DOUBLE
MES_CUSTOMERINFO_TB - 거래처정보 관리 테이블 (MCT)
- MES_CUSTOMERINFO_TB (Key) — INT(11) — 기본 키 — NOT NULL
- CUSTOMER_CD (Field) — INT(11)
- CUSTOMER_NM (Field2) — VARCHAR(50)
- CUSTOMER_SN (Field3) — VARCHAR(50)
- CUSTOMER_TY (Field4) — VARCHAR(20)
- EVENT (Field5) — VARCHAR(20)
- PERSONLNCHARGE_NM (Field6) — VARCHAR(20)
- REPRESENTATIVE_NM (Field7) — VARCHAR(20)
- FIRST_TRADING_DAY (Field8) — VARCHAR(20)
- RESIDENT_REGISTRATION_NO (Field9) — VARCHAR(15)
- BUSINESS_REG_NO (Field10) — VARCHAR(50)
- CORPORATEG_NO (Field11) — VARCHAR(50)
- CUSTOMER_TEL (Field12) — VARCHAR(20)
- FAX_NO (Field13) — VARCHAR(50)
- POST_NO (Field14) — VARCHAR(50)
- ADDRESS_W (Field15) — VARCHAR(200)
- ADDRESS_W2 (Field16) — VARCHAR(200)
- PAYMENT (Field17) — VARCHAR(20)
- VAT_GB (Field18) — VARCHAR(20)
- PUBLICATION (Field19) — VARCHAR(20)
- CUSTOMER_GB (Field20) — VARCHAR(30)
- MAIL_E (Field21) — VARCHAR(50)
- REMARKS (Field22) — VARCHAR(50)
- REG_DT (Field23) — DATE
- EOPTAE (Field24) — VARCHAR(50)
- PERSONINNUMBER (Field25) — VARCHAR(200)
MES_DETAILSITEMINFO_TB - 세부 품목정보 관리 테이블(투입) (MDT)
- DETAILSITEMINFO_SQ (Key) — INT(11) — 기본 키 — NOT NULL
- ITEM_SQ (Key2) — INT(11) — 외래 키 → MES_ITEMINFO_TB - 품목정보 관리 테이블(투입).ITEM_SQ — NOT NULL
- LENGTH (Field2) — VARCHAR(30)
- PRICE_GB (Field3) — VARCHAR(30)
- UNIT (Field4) — VARCHAR(7)
- UNIT_GB (Field5) — VARCHAR(30)
- UNIT_M (Field6) — VARCHAR(30)
- UNIT_KG (Field7) — VARCHAR(30)
- MODEL_NM (Field8) — VARCHAR(45)
- WEIGHT (Field9) — VARCHAR(30)
MES_ITEMINFO_TB - 품목정보 관리 테이블(투입) (MIIT)
- ITEM_SQ (Key) — INT(11) — 기본 키 — NOT NULL
- ITEM_NM (Field) — INT(11)
- ITEM_TYPE (Field2) — INT(11)
- CUSTOMER_SQ (Field3) — INT(11)
- STANDARD (Field4) — VARCHAR(30)
- PRODUCT (Field5) — VARCHAR(10)
- ASPECT (Field6) — VARCHAR(30)
- STANDARDUNIT (Field7) — VARCHAR(30)
- MATERIAL (Field8) — VARCHAR(30)
- OUTERDIAMETER (Field9) — VARCHAR(30)
- NTERNALDIAMETER (Field10) — VARCHAR(30)
- THICKNESS (Field11) — VARCHAR(30)
- WEIGHT (Field12) — VARCHAR(30)
- UNITUSE (Field13) — VARCHAR(3)
- VIGO (Field14) — VARCHAR(50)
- VERTICAL (Field15) — DOUBLE
- HORIZONTAL (Field16) — DOUBLE
MES_POC_TB - POC 테이블 (MPT)
- POC_SQ (Key) — INT(11) — 기본 키 — NOT NULL
- POC_NO (Field) — VARCHAR(30)
- RECEIPT_DT (Field2) — DATE
- INPUT_WHTHR (Field3) — TINYINT(1)
- PRODUCTION_WHTHR (Field4) — TINYINT(1)
- OBTAINORDER_SQ (Field5) — INT(11)
- ITEMCUSTOMERSN_SQ (Key2) — INT(11) — 외래 키 → MES_CUSTOMERINFO_TB - 거래처정보 관리 테이블.MES_CUSTOMERINFO_TB — NOT NULL
- MUTUAL_DETAILSITEMINFO_SQ (Key4) — INT(11) — 외래 키 → Copy Of MES_DETAILSITEMINFO_TB - 세부 품목정보 관리 테이블(제품).DETAILSITEMINFO_SQ — NOT NULL
- MUTUAL_QTY (Field8) — DOUBLE
- INPUTCUSTOMERSN_SQ (Field9) — INT(11)
- INPUT_DETAILSITEMINFO_SQ (Key3) — INT(11) — 외래 키 → MES_DETAILSITEMINFO_TB - 세부 품목정보 관리 테이블(투입).DETAILSITEMINFO_SQ — NOT NULL
- INPUT_QTY (Field11) — DOUBLE
- DUE_DATE (Field12) — DATE
- UNIQUENESS (Field13) — VARCHAR(500)
- PRODUCE_DT (Field14) — DATE
- INPUT_DT (Field15) — DATE
- PLACE (Field16) — VARCHAR(50)
- DIVISION (Field17) — VARCHAR(30)
- OUTER_DMT_TOLERANCE_M (Field18) — FLOAT
- OUTER_DMT_TOLERANCE_P (Field19) — FLOAT
- NTRNL_TOLERANCE_M (Field20) — FLOAT
- NTRNL_TOLERANCE_P (Field21) — FLOAT
- THK_TOLERANCE_M (Field22) — FLOAT
- THK_TOLERANCE_P (Field23) — FLOAT
- POC_DT (Field24) — DATE
- POC_TM (Field25) — TIME
- WORKORDER_DT (Field26) — DATE
- WORK_ST (Field27) — TINYINT(1)
- FACILITY_SQ (Field28) — INT(11)
- INPUT_STOCK_SQ (Field29) — INT(11)
- STOCK_SQ (Field30) — INT(11)
- PRODUCE_WEIGHT (Field31) — DOUBLE
- LOSS (Field32) — VARCHAR(10)
- OUTPOC_NO (Field33) — VARCHAR(30)
- URGENCY (Field34) — TINYINT(1)
- ACCEPT_NAME (Field35) — VARCHAR(50)
- ACCEPT (Field36) — TINYINT(1)
- CLT_PRODUCTION_WHTHR (Field37) — TINYINT(1)
- PURCHASE_DT (Field38) — DATE
- NORMALCUSTOMERSN_SQ (Field39) — INT(11)
- NORMAL_DETAILSITEMINFO_SQ (Field40) — INT(11)
- PRINT_WHTHR (Field41) — TINYINT(1)
- VIGO (Field42) — VARCHAR(45)
생산 통계 테이블 (MWR2)
- SQ (Key) — INT(11) — 기본 키 — NOT NULL
- POC_SQ (Key2) — INT(11) — 외래 키 → MES_POC_TB - POC 테이블.POC_SQ — NOT NULL
- WORKRECORD_SQ (Field2) — INT(11)
- WORK_DATE (Field8) — TIMESTAMP
- STAFF_NM (Field9) — VARCHAR(20)
- LENGTH (Field24) — VARCHAR(50)
- QTY (Field25) — VARCHAR(50)
- WORKEND_TM (Field27) — VARCHAR(10)
- READY_TM (Field28) — VARCHAR(10)
- STOP_TM (Field29) — VARCHAR(10)
- AUTO_READY_TM (Field30) — VARCHAR(10)
- AUTO_WORKEND_TM (Field31) — VARCHAR(10)
- AUTO_STOP_TM (Field32) — VARCHAR(10)
- WORK_RESULT (Field33) — VARCHAR(20)
- SPEED (Field34) — VARCHAR(20)
- PROCESS_CNT (Field35) — VARCHAR(20)
- LENGTH (Field22) — VARCHAR(50)
- PROCESSROUTING_SQ (Field3) — INT(11)
- ORDER_NUMBER (Field36) — INT(11)
- PROCESSROUTING_SQ2 (Field4) — INT(11)
- POC_SQ (Field11) — INT(11)
- DAISEU (Field21) — VARCHAR(50)
- PLUG (Field19) — VARCHAR(50)
- PROCESSDETAIL_THICK (Field20) — VARCHAR(30)
- SEQUENCE (Field26) — TINYINT(1)
- PROCESSROUTING_SQ3 (Field5) — INT(11)
- POC_SQ2 (Field12) — INT(11)
- BEFORE_DAISEU (Field16) — VARCHAR(50)
- BEFORE_PLUG (Field17) — VARCHAR(50)
- BEFORE_PROCESSDETAIL_THICK (Field) — VARCHAR(50)
- FACILITY_SQ (Field6) — INT(11)
- FACILITY_NM (Field7) — VARCHAR(45)
- STOP_CM (Field37) — VARCHAR(50)