SETOS_PP

Tables (11)

tb_mes_pp000

  • COMPANY — varchar(20) — Primary key — NOT NULL
  • ROUT_CD — varchar(20) — Primary key — NOT NULL
  • CREATED_AT — datetime
  • CREATED_BY — varchar(255)
  • UPDATED_AT — datetime
  • UPDATED_BY — varchar(255)
  • REMARK — varchar(400)
  • ROUT_NM — varchar(200)
  • ROUT_TYPE — varchar(20)
  • USE_YN — varchar(20)
  • QC_YN — varchar(20)
  • CUST_CD — varchar(20)
  • EQUIP_USE_YN — varchar(20)
  • MOLD_USE_YN — varchar(20)
  • OUTSC_FLAG — varchar(20)
  • SORT — bigint(20)
  • TEMP_FILE_CD — varchar(40)
  • WH_CD — varchar(20)

tb_mes_pp010

  • COMPANY — varchar(20) — Primary key — NOT NULL
  • NWRK_SEQ — bigint(20) — Primary key — NOT NULL
  • ROUT_CD — varchar(20) — Primary key — NOT NULL
  • CREATED_AT — datetime
  • CREATED_BY — varchar(255)
  • UPDATED_AT — datetime
  • UPDATED_BY — varchar(255)
  • NWRK_NM — varchar(255)
  • REMARK — varchar(400)
  • USE_YN — varchar(20)

tb_mes_pp020

  • BAD_SEQ — bigint(20) — Primary key — NOT NULL
  • COMPANY — varchar(20) — Primary key — NOT NULL
  • ROUT_CD — varchar(20) — Primary key — NOT NULL
  • CREATED_AT — datetime
  • CREATED_BY — varchar(255)
  • UPDATED_AT — datetime
  • UPDATED_BY — varchar(255)
  • BAD_NM — varchar(255)
  • REMARK — varchar(400)
  • USE_YN — varchar(20)

tb_mes_pp100

  • COMPANY — varchar(20) — Primary key — NOT NULL
  • ROUTING_CD — varchar(20) — Primary key — NOT NULL
  • CREATED_AT — datetime
  • CREATED_BY — varchar(255)
  • UPDATED_AT — datetime
  • UPDATED_BY — varchar(255)
  • ROUTING_NM — varchar(200)
  • USE_YN — varchar(20)
  • REMARK — varchar(400)

tb_mes_pp110

  • COMPANY — varchar(20) — Primary key — NOT NULL
  • REG_SEQ — bigint(20) — Primary key — NOT NULL
  • ROUTING_CD — varchar(20) — Primary key — NOT NULL
  • CREATED_AT — datetime
  • CREATED_BY — varchar(255)
  • UPDATED_AT — datetime
  • UPDATED_BY — varchar(255)
  • EQUIP_CD — varchar(20)
  • LAST_FLAG — varchar(20)
  • REMARK — varchar(400)
  • ROUT_CD — varchar(20)
  • ROUT_SEQ — bigint(20)
  • USE_YN — varchar(20)

tb_mes_pp120

  • COMPANY — varchar(20) — Primary key — NOT NULL
  • ITEM_CD — varchar(50) — Primary key — NOT NULL
  • ROUTING_CD — varchar(20) — Primary key — NOT NULL
  • CREATED_AT — datetime
  • CREATED_BY — varchar(255)
  • UPDATED_AT — datetime
  • UPDATED_BY — varchar(255)
  • USE_YN — varchar(20)

tb_mes_pp200

  • COMPANY — varchar(20) — Primary key — NOT NULL — 사업장
  • WC_CD — varchar(50) — Primary key — NOT NULL — 워크센터코드
  • WC_NM — varchar(255) — NOT NULL — 워크센터명
  • WC_TYPE — varchar(20) — NOT NULL — 워크센터구분
  • DEPT_CD — varchar(50) — 생산부서
  • CAPA_TYPE — varchar(20) — CAPA산정구분
  • CUST_CD — varchar(20) — 외주거래처
  • IN_WH_CD — varchar(20) — 납품창고
  • MTR_WH_CD — varchar(20) — 자재출고창고
  • ON_WH_CD — varchar(20) — 현장창고
  • PRD_WH_CD — varchar(20) — 생산입고창고
  • CC_CD — varchar(20) — 코스트센터
  • START_DT — varchar(10) — 시작일
  • END_DT — varchar(10) — 종료일
  • REMARK — varchar(400)
  • USE_YN — varchar(20)
  • CREATED_AT — datetime
  • CREATED_BY — varchar(255)
  • UPDATED_AT — datetime
  • UPDATED_BY — varchar(255)

tb_mes_pp210

  • COMPANY — varchar(20) — Primary key — NOT NULL — 사업장
  • WC_CD — varchar(50) — Primary key — NOT NULL — 워크센터코드
  • EQUIP_CD — varchar(20) — Primary key — NOT NULL — 설비코드
  • CREATED_AT — datetime
  • CREATED_BY — varchar(255)
  • UPDATED_AT — datetime
  • UPDATED_BY — varchar(255)
  • REMARK — varchar(400)
  • USE_YN — varchar(20)

tb_mes_pp220

  • COMPANY — varchar(20) — Primary key — NOT NULL — 사업장
  • WC_CD — varchar(20) — Primary key — NOT NULL — 워크센터코드
  • USER_CD — varchar(100) — Primary key — NOT NULL — 사용자코드
  • CREATED_AT — datetime
  • CREATED_BY — varchar(255)
  • UPDATED_AT — datetime
  • UPDATED_BY — varchar(255)
  • REMARK — varchar(400)
  • USE_YN — varchar(20)

tb_mes_prc100

  • COMPANY — varchar(20) — Primary key — NOT NULL
  • ITEM_CD — varchar(50) — Primary key — NOT NULL
  • PRC_SEQ — bigint(20) — Primary key — NOT NULL
  • CURRENCY_CD — varchar(20)
  • PRC_TYPE — varchar(20)
  • MM_PRC — decimal(19,2)
  • START_DT — varchar(10)
  • END_DT — varchar(10)
  • REMARK — varchar(20)
  • CREATED_AT — datetime
  • CREATED_BY — varchar(255)
  • UPDATED_AT — datetime
  • UPDATED_BY — varchar(255)

tb_mes_prd100

  • COMPANY — varchar(20) — Primary key — NOT NULL — 회사코드
  • ITEM_CD — varchar(20) — Primary key — NOT NULL — 품목코드
  • PLAN_DT — varchar(10) — Primary key — NOT NULL — 계획일
  • PLAN_YY — varchar(10) — 계획년
  • PLAN_MM — varchar(10) — 계획월
  • PLAN_DD — varchar(10) — 계획일
  • PLAN_QTY — decimal(20, 5) — 계획수량
  • CREATED_AT — datetime
  • CREATED_BY — varchar(255)
  • UPDATED_AT — datetime
  • UPDATED_BY — varchar(255)