ㄹㄷㄹㄷ

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