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