재경 테이블 통합

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