ㄹㄷㄹㄷ
Tables (4)
TB_PDCT_GDS_WRHS_BASI (생산 제품 입고 기본)
- comp_cd (회사코드) — Primary key — NOT NULL
- jobodr_no (작업지시_번호) — Primary key — NOT NULL
- jobodr_line_no (작업지시_행_번호) — Primary key — NOT NULL
- acrs_line_no (실적_행_번호) — Primary key — NOT NULL
- wrhs_no (입고번호) — Primary key — NOT NULL
- jobodr_stat_cd (작업지시_상태_코드)
- work_stat_cd (작업_상태_코드)
- invr_work_stat_cd (재고_작업_상태_코드)
TB_PDCT_INVR_MOVE_BASI (생산 재고 이동 기본)
- comp_cd (회사코드) — Primary key — NOT NULL
- jobodr_no (작업지시_번호) — Primary key — NOT NULL
- jobodr_line_no (작업지시_행_번호) — Primary key — NOT NULL
- acrs_line_no (실적_행_번호) — Primary key — NOT NULL
- move_no (이동 번호) — Primary key — NOT NULL
- jobodr_stat_cd (작업지시_상태_코드)
- work_stat_cd (작업_상태_코드)
- invr_work_stat_cd (재고_작업_상태_코드)
TB_PDCT_INVR_MOVE_DTL (생산 재고 이동 내역)
- comp_cd (회사코드) — Foreign key → TB_PDCT_INVR_MOVE_BASI.comp_cd — NOT NULL
- jobodr_no (작업지시_번호) — Foreign key → TB_PDCT_INVR_MOVE_BASI.jobodr_no — NOT NULL
- jobodr_line_no (작업지시_행_번호) — Foreign key → TB_PDCT_INVR_MOVE_BASI.jobodr_line_no — NOT NULL
- acrs_line_no (실적_행_번호) — Foreign key → TB_PDCT_INVR_MOVE_BASI.acrs_line_no — NOT NULL
- move_no (이동 번호) — Foreign key → TB_PDCT_INVR_MOVE_BASI.move_no — NOT NULL
- move_line_no (이동_행_번호) — NOT NULL
TB_PDCT_MTRL_USE_DTL (생산 자재 사용 내역)
- comp_cd (회사코드) — Foreign key → TB_PDCT_GDS_WRHS_BASI.comp_cd — NOT NULL
- jobodr_no (작업지시_번호) — Foreign key → TB_PDCT_GDS_WRHS_BASI.jobodr_no — NOT NULL
- jobodr_line_no (작업지시_행_번호) — Foreign key → TB_PDCT_GDS_WRHS_BASI.jobodr_line_no — NOT NULL
- acrs_line_no (실적_행_번호) — Foreign key → TB_PDCT_GDS_WRHS_BASI.acrs_line_no — NOT NULL
- wrhs_no (입고번호) — Foreign key → TB_PDCT_GDS_WRHS_BASI.wrhs_no — NOT NULL
- rls_line_no (출고_행_번호) — NOT NULL