ERD

Tables (19)

b_bizarea (사업장)

  • bizarea_cd (사업장코드) — varchar(50) — Primary key — NOT NULL
  • co_cd (법인코드) — varchar(50) — Foreign key → b_co.co_cd — NOT NULL
  • bizarea_nm (사업장이름) — varchar(50)
  • bizarea_shnm (사업장약명) — varchar(20)
  • biz_no (사업자번호) — varchar(50)
  • biz_rpr (대표자) — varchar(50)
  • str_dt (개시일) — timestamp
  • unitcur_id (국가코드) — int(11) — cur, cn
  • unitcn_id (기준통화코드) — int(11) — cur, cn
  • usage_fg (사용여부) — char(1)
  • insrt_id (생성자) — int(11)
  • insrt_dt (생성일) — timestamp
  • updt_id (수정자) — int(11)
  • updt_dt (수정일) — timestamp

b_bizpartner (거래처)

  • bizpartner_cd (거래처코드) — varchar(50) — Primary key — NOT NULL
  • co_cd (법인코드) — varchar(50) — Foreign key → b_co.co_cd — NOT NULL
  • bizunit_cd (사업부코드) — varchar(50) — Foreign key → b_bizunit.bizunit_cd — NOT NULL
  • bizpartner_type (거래처형태) — varchar(20)
  • biz_nm (사업자명) — varchar(50)
  • bizpartner_nm (거래처명) — varchar(50)
  • unitcur_id (기준통화코드) — int(11)
  • bizpartner_stat (거래처상태) — varchar(20)
  • unit_id (단위코드) — int(11)
  • usage_fg (사용여부) — char(1)
  • insrt_id (생성자) — int(11)
  • insrt_dt (생성일) — timestamp
  • updt_id (수정자) — int(11)
  • updt_dt (수정일) — timestamp

b_bizunit (사업부)

  • bizunit_cd (사업부코드) — varchar(50) — Primary key — NOT NULL
  • bizunit_nm (사업부명) — varchar(50)
  • bizunit_rmrk (비고) — varchar(50)
  • usage_fg (사용여부) — char(1)
  • insrt_id (생성자) — int(11)
  • insrt_dt (생성일) — timestamp
  • updt_id (수정자) — int(11)
  • updt_dt (수정일) — timestamp

b_bom (BOM)

  • bom_cd (BOM코드) — int(11) — Primary key — NOT NULL
  • item_cd (품목코드) — varchar(50) — Foreign key → b_item.item_cd — NOT NULL
  • bom_type (BOM유형) — varchar(20)
  • top_id — int(11)
  • parent_id (모품목번호) — int(11)
  • bom_order — int(11)
  • bom_level — int(11)
  • leaf_fg (자식유무여부) — varchar(10)
  • moitem_base — float
  • jaitem_base — float
  • unit_product — varchar(20)
  • free_fg — varchar(10)
  • loss_product (로스율) — float
  • demand_amt — float
  • start_dt (시작일) — varchar(8)
  • end_dt (종료일) — varchar(8)
  • register_dt — datetime
  • usage_fg (사용여부) — char(1)
  • insrt_id (생성자) — int(11)
  • updt_id (수정자) — int(11)

b_co (법인정보)

  • co_cd (법인코드) — varchar(50) — Primary key — NOT NULL
  • co_nm (법인명) — varchar(50)
  • co_shnm (법인약명) — varchar(50)
  • co_rpr (법인대표) — varchar(20)
  • co_type (법인유형) — varchar(20)
  • co_div (법인구분) — varchar(20)
  • co_estdt (법인설립일) — timestamp
  • co_strdt (법인개시일) — timestamp
  • unitcn_id (국가코드) — int(11)
  • unitcur_id (기준통화코드) — int(11)
  • usage_fg (사용여부) — char(1)
  • insrt_id (생성자) — int(11)
  • insrt_dt (생성일) — timestamp
  • updt_id (수정자) — int(11)
  • updt_dt (수정일) — timestamp

b_costeleaccnt (원가요소 계정)

  • accnt_cd (원가요소계정코드) — varchar(50) — Primary key — NOT NULL
  • placcnt_cd (손익원가코드) — varchar(50) — Primary key — NOT NULL — 손익원가코드
  • placcnt_nm (손익원가명) — varchar(50) — 손익원가명
  • fv_div (고정변동유무) — varchar(1) — 고정변동유무
  • accnt_nm (원가요소계정명) — varchar(50) — 계정이름
  • costeleaccnt_rmrk (비고) — varchar(255) — 비고
  • usage_fg (사용여부) — char(1)

b_factory (공장)

  • factory_cd (공장코드) — varchar(50) — Primary key — NOT NULL
  • factory_nm (공장명) — varchar(50)
  • factory_rmrk (비고) — varchar(50)
  • usage_fg (사용여부) — char(1)
  • insrt_id (생성자) — int(11)
  • insrt_dt (생성일) — timestamp
  • updt_id (수정자) — int(11)
  • updt_dt (수정일) — timestamp

b_item (품목)

  • item_cd (품목코드) — varchar(50) — Primary key — NOT NULL
  • factory_cd (공장코드) — varchar(20) — Foreign key → b_factory.factory_cd — NOT NULL
  • itemaccnt_cd (품모계정코드) — varchar(50) — Foreign key → b_itemaccnt.itemaccnt_cd — NOT NULL
  • itemgrp_cd (품목그룹) — varchar(50) — Foreign key → b_itemgrp.itemgrp_cd — NOT NULL
  • unit_id (단위코드) — int(11)
  • item_nm (품명) — varchar(50)
  • item_spec (규격) — varchar(50)
  • phantom_div — char(1) — 1 or 0 활성화
  • bom_fg — varchar(8)
  • usage_fg (사용여부) — char(1)
  • insrt_id (생성자) — int(11)
  • insrt_dt (생성일) — timestamp
  • updt_id (수정자) — int(11)
  • updt_dt (수정일) — timestamp

b_itemaccnt (품목계정)

  • itemaccnt_cd (품목계정코드) — varchar(50) — Primary key — NOT NULL
  • itemaccnt_nm (품목계정명) — varchar(50)
  • usage_fg (사용여부) — char(1)
  • insrt_id (생성자) — int(11)
  • insrt_dt (생성일) — timestamp
  • updt_id (수정자) — int(11)
  • updt_dt (수정일) — timestamp

b_itemgrp (품목그룹)

  • itemgrp_cd (품목그룹코드) — varchar(50) — Primary key — NOT NULL
  • itemgrp_nm (품목그룹명) — varchar(50)
  • usage_fg (사용여부) — char(1)
  • insrt_id (생성자) — int(11)
  • insrt_dt (생성일) — timestamp
  • updt_id (수정자) — int(11)
  • updt_dt (수정일) — timestamp

b_version (버전 정보)

  • version_cd (버전코드) — varchar(50) — Primary key — NOT NULL
  • version_dt (버전날짜) — varchar(8)
  • insrt_id (생정자) — int(11)

b_workcenter (작업장)

  • workcenter_cd (작업장코드) — varchar(50) — Primary key — NOT NULL
  • co_cd (법인코드) — varchar(50) — Foreign key → cb_cost_center.co_cd — NOT NULL
  • bizarea_cd (사업장코드) — varchar(50) — Foreign key → cb_cost_center.bizarea_cd — NOT NULL
  • workcenter_nm (작업장명) — varchar(50)
  • usage_fg (사용여부) — char(1)
  • insrt_id (생성자) — int(11)
  • insrt_dt (생성일) — timestamp
  • updt_id (수정자) — int(11)
  • updt_dt (수정일) — timestamp

ca_prediction (모델 분석 결과 값)

  • prediction_id — int(11) — Primary key — NOT NULL — 모델생성시 자동생성
  • costbill_id — int(11) — Foreign key → cc_costbill.costbill_id — NOT NULL
  • ipm_id — int(11) — Foreign key → cc_costbill.ipm_id — NOT NULL — ID (입력x)
  • mc_id — int(11) — Foreign key → cc_costbill.mc_id — NOT NULL — ID (입력x)
  • materialcost_id — int(11) — Foreign key → cc_costbill.materialcost_id — NOT NULL — ID (입력x)
  • pcp_id — int(11) — Foreign key → cc_costbill.pcp_id — NOT NULL — ID (입력x)
  • bizarea_cd (사업장코드) — varchar(50) — Foreign key → cc_costbill.bizarea_cd — NOT NULL
  • prediction1_cost (첫째 달 예측 매출액) — int(255) — 첫째 달 예측 매출액
  • prediction2_cost (둘째 달 예측 매출액) — int(255) — 둘째 달 예측 매출액
  • prediction3_cost (셋째 달 예측 매출액) — int(255) — 셋째 달 예측 매출액
  • prediction4_cost (넷째 달 예측 매출액) — int(255)
  • periodym1_cd (yyyymm(첫째달)) — int(6) — 첫째달
  • periodym2_cd (yyyymm(둘째달)) — int(6) — 둘째달
  • periodym3_cd (yyyymm(셋째달)) — int(6) — 셋째달
  • periodym4_cd (yyyymm(넷째달)) — int(6)
  • variableperc_cost (변동비%) — float — 변동비%
  • fixedperc_cost (고정비%) — float — 고정비%
  • materialperc_cost (재료비%) — float — 재료비%
  • prediction1_max (첫째달 예측 최댓값) — int(255)
  • prediction2_max (둘째달 예측 최댓값) — int(255)
  • prediction3_max (셋째달 예측 최댓값) — int(255)
  • prediction4_max (넷째달 예측 최댓값) — int(255)
  • prediction1_min (첫째달 예측 최솟값) — int(255)
  • prediction2_min (둘째달 예측 최솟값) — int(255)
  • prediction3_min (셋째달 예측 최솟값) — int(255)
  • prediction4_min (넷째달 예측 최솟값) — int(255)

cb_cost_center (코스트센터)

  • cstctr_cd (코스트센터코드) — varchar(50) — Primary key — NOT NULL
  • bizunit_cd (사업부코드) — varchar(50) — Foreign key → b_bizunit.bizunit_cd — NOT NULL
  • factory_cd (공장코드) — varchar(50) — Foreign key → b_factory.factory_cd — NOT NULL
  • co_cd (법인코드) — varchar(50) — Foreign key → b_bizarea.co_cd — NOT NULL
  • bizarea_cd (사업장코드) — varchar(50) — Foreign key → b_bizarea.bizarea_cd — NOT NULL
  • cstctr_nm (코스트센터명) — varchar(50)
  • cstctr_type (코스트센터타입) — varchar(50)
  • cstctr_dir_div (코스트센터직/간접구분) — varchar(50)
  • usage_fg (사용여부) — char(1)
  • insrt_id (생성자) — int(11)
  • insrt_dt (생성일) — datetime
  • updt_id (수정자) — int(11)
  • updt_dt (수정일) — timestamp

cc_costbill (원가계산서)

  • costbill_id — int(11) — Primary key — NOT NULL
  • ipm_id — int(11) — Foreign key → cc_itempermanucost_if.ipm_id — NOT NULL — ID (입력x)
  • mc_id — int(11) — Foreign key → cc_manucost_if.mc_id — NOT NULL — ID (입력x)
  • materialcost_id — int(11) — Foreign key → cc_materialcost_if.materialcost_id — NOT NULL — ID (입력x)
  • pcp_id — int(11) — Foreign key → cc_productcostpayment_if.pcp_id — NOT NULL — ID (입력x)
  • bizarea_cd (사업장코드) — varchar(50) — Foreign key → cc_manucost_if.bizarea_cd — NOT NULL
  • 기초재공품_재료비 — int(255)
  • 타계정대체_재료비 — int(255)
  • 기말재공품_재료비 — int(255)
  • 기말재공품_노무비 — int(255)
  • 기말재공품_제조경비 — int(255)
  • 당기투입_직전변동_고정비 — int(255)
  • 당기투입_직접고정_기타 — int(255)
  • 당기투입_직접고정_상각비 — int(255)
  • 당기투입_직접변동_노무비 — int(255)
  • 당기투입_직접변동_제조경비 — int(255)
  • 당기투입_간접_노무비 — int(255)
  • 당기투입_간접_제조경비 — int(255)
  • 생산량 — int(255)
  • 배부기준_단위당_생산액 — int(255)
  • 당기투입 — 재료비`
  • 당기사용_표준재료비 — int(255)
  • 당기사용_직접노무비 — int(255)
  • 당기사용_간접노무비 — int(255)
  • 당기사용_간접제조경비 — int(255)
  • 당기사용_직접제조경비 — int(255)
  • 통화환율 — float
  • 투입비율 — float

cc_itempermanucost_if (품목별제조비용)

  • ipm_id — int(11) — Primary key — NOT NULL — ID (입력x)
  • version_cd (버전코드) — varchar(50) — Foreign key → b_version.version_cd — NOT NULL
  • accnt_cd (원가요소계정코드) — varchar(50) — Foreign key → b_costeleaccnt.accnt_cd — NOT NULL
  • bom_cd (BOM코드) — int(11) — Foreign key → b_bom.bom_cd — NOT NULL
  • co_cd (법인코드) — varchar(50) — Foreign key → b_co.co_cd — NOT NULL
  • ipmc_ym (년월 (yyyymm)) — int(6) — 년월 ex) 200001
  • ipmc_cost (금액) — int(255) — 금액

cc_manucost_if (제조비용)

  • mc_id — int(11) — Primary key — NOT NULL — ID (입력x)
  • version_cd (버전코드) — varchar(50) — Foreign key → b_version.version_cd — NOT NULL
  • accnt_cd (원가요소계정코드) — varchar(50) — Foreign key → b_costeleaccnt.accnt_cd — NOT NULL
  • co_cd (법인코드) — varchar(50) — Foreign key → b_co.co_cd — NOT NULL
  • cstctr_cd (코스트센터코드) — varchar(50) — Foreign key → cb_cost_center.cstctr_cd — NOT NULL
  • bizarea_cd (사업장코드) — varchar(50) — Foreign key → cb_cost_center.bizarea_cd — NOT NULL
  • periodym_cd (년월 (yyyymm)) — varchar(6) — NOT NULL — 년월 ex) 200001
  • manucost_price (금액) — int(255) — NOT NULL — 금액
  • mngmt_1 (관리항목) — varchar(50) — NOT NULL — 관리항목

cc_materialcost_if (재료비)

  • materialcost_id — int(11) — Primary key — NOT NULL — ID (입력x)
  • version_cd (버전코드) — varchar(50) — Foreign key → b_version.version_cd — NOT NULL
  • accnt_cd (원가요소계정코드) — varchar(50) — Foreign key → b_costeleaccnt.accnt_cd — NOT NULL
  • co_cd (법인코드) — varchar(50) — Foreign key → b_co.co_cd — NOT NULL
  • factory_cd (공장코드) — varchar(50) — Foreign key → b_factory.factory_cd — NOT NULL
  • bom_cd (BOM코드) — int(11) — Foreign key → b_bom.bom_cd — NOT NULL
  • workcenter_cd (작업장코드) — varchar(50) — Foreign key → b_workcenter.workcenter_cd — NOT NULL
  • bizarea_cd (사업장코드) — varchar(50) — Foreign key → b_workcenter.bizarea_cd — NOT NULL
  • periodym_cd (년월 (yyyymm)) — varchar(6) — 년월 ex) 200001
  • mc_amount (수량) — int(255) — 수량
  • mc_price (금액) — int(255) — 금액

cc_productcostpayment_if (제품원가수불)

  • pcp_id — int(11) — Primary key — NOT NULL — ID (입력x)
  • version_cd (버전코드) — varchar(50) — Foreign key → b_version.version_cd — NOT NULL
  • item_cd (품목코드) — varchar(50) — Foreign key → b_bom.item_cd — NOT NULL
  • accnt_cd (원가요소계정코드) — varchar(50) — Foreign key → b_costeleaccnt.accnt_cd — NOT NULL
  • basisicstoc_amt (기초재고수량) — int(255) — 기초재고수량
  • basisicstoc_price (기초재고금액) — int(255) — 기초재고금액
  • productionreceipt_amt (생산입고수량) — int(255) — 생산입고수량
  • productionreceipt_price (생산입고금액) — int(255) — 생산입고금액
  • sell_amt (판매출고수량) — int(255) — 판매출고수량
  • sell_cost (판매출고금액) — int(255) — 판매출고금액
  • loss_amt (로스출고수량) — int(255) — LOSS출고수량
  • loss_cost (로스출고금액) — int(255) — LOSS출고금액
  • development_amt (개발출고수량) — int(255) — 개발출고수량
  • development_cost (개발출고금액) — int(255) — 개발출고금액
  • endingstock_amt (기말재고수량) — int(255) — 기말재고수량
  • endingstock_cost (기말재고금액) — int(255) — 기말재고금액
  • pcp_dt (년월 (yyyymm)) — varchar(6) — 년월 ex) 200001