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)