BCD

Tables (10)

Copy Of TB_BUNDLE_NO_HEADER (CopyOf묶음번호)

  • PLANT_ID (공장) — nvarchar(50) — Primary key — NOT NULL
  • BUNDLE_NO (묶음번호) — nvarchar(50) — Primary key — NOT NULL
  • BUNDLE_DATE (묶음번호 생성일) — nvarchar(8)
  • PART_ID (자재번호) — nvachar(50)
  • REBUNLE_FLAG (재묶음번호 여부) — nvarchar(1)

TB_BARCODE_HIST (바코드이력)

  • BARCODE (바코드번호) — nvachar(50) — Primary key — NOT NULL
  • ROW_STAMP (Key2) — bigint — Primary key — NOT NULL
  • PLANT_ID (공장명) — NVACHAR(50)
  • LOCATION_ID (저장위치) — nvachar(50)
  • PART_ID (자재명) — nvachar(50)
  • WEIGHT (무게) — nvarchar(50)

TB_BUNDLE_NO_DETAIL (묶음번호 상세)

  • BUNDLE_NO (묶음번호) — nvarchar(50)
  • RECORD_INDEX (기록줄) — bigint
  • PART_ID (자재명) — nvarchar(50)
  • REBUNDLE_NO (재묶음번호) — nvarchar(50)
  • PART_TEMP_FLAG (온도조건) — nvarchar(50)

TB_BUNDLE_NO_HEADER (묶음번호)

  • PLANT_ID (공장) — NVACHAR(50) — Primary key — NOT NULL
  • BUNDLE_NO (묶음번호) — nvarchar(50) — Primary key — NOT NULL
  • BUNDLE_DATE (묶음번호 생성일) — nvarchar(8)
  • PART_ID (자재번호) — nvachar(50)
  • REBUNLE_FLAG (재묶음번호 여부) — nvarchar(1)

TB_PORK_RECORD (도체실적(BCD))

  • ROW_STAMP (자동체번줄) — bigint — Primary key — NOT NULL
  • ORDER_NO (구매오더번호) — Nvachar(11)
  • ORDER_NO_DETAIL (품목) — Nvacahr(5)
  • SEQNO (시퀀스번호) — Nvacahr(5)
  • PLANT_ID (공장명) — NVACHAR(4)
  • LOCATION_ID (저장위치) — Nvachar(4)
  • BATCH_NO (배치번호) — Nvachar(15)
  • SLIP_DATE (입고일) — Nvachar(8)
  • BUTCHERY_DATE (도축일) — Nvachar(8)
  • WORK_DATE (가공일) — Nvachar(8)
  • BUNDLE_FLAG (번들여부) — Nvachar(1)
  • MANDT (CLIENT) — Nvacchar(3) — Foreign key → ZTTMBA060.MANDT — NOT NULL
  • TRANS_D (전송일자) — Nvachar(8) — Foreign key → ZTTMBA060.TRANS_D — NOT NULL
  • TRANS_T (전송시간) — Nvachar(6) — Foreign key → ZTTMBA060.TRANS_T — NOT NULL
  • EBLEN (구매오더번호2) — Nvachar(10) — Foreign key → ZTTMBA060.EBLEN — NOT NULL
  • EBELP (품목2) — Nvacahr(5) — Foreign key → ZTTMBA060.EBELP — NOT NULL
  • SEQ (순번) — Nvachar(5) — Foreign key → ZTTMBA060.SEQ — NOT NULL

TB_PP_PLAN (생산계획)

  • ORDER_NO (생산계획) — Nvachar(12) — Primary key — NOT NULL
  • PLANT_ID (공장명) — NVACHAR(13) — Primary key — NOT NULL
  • PART_ID (자재명) — Nvachar(18) — Primary key — NOT NULL
  • PLAN_END_DATE (계획종료일) — Nvachar(8)
  • PLAN_START_DATE (계획시작일) — Nvarchar(8)

TB_PROD_BOX (외포장 실적)

  • ORDER_NO (생산계획) — NVACHAR(13) — Primary key — NOT NULL
  • RESULT_DATE (생산일자) — Nvachar(8) — Primary key — NOT NULL
  • PLANT_ID (공장명) — NVACHAR(4) — Primary key — NOT NULL
  • BARCODE (바코드번호) — nvachar(50) — Primary key — NOT NULL
  • SEQ (시퀀스번호) — nvachar(4)
  • PART_ID (자재명) — nvachar(18)
  • PROD_CNT (계획수량) — decimal(13,3)
  • PROD_UNIT (계획단위) — nvachar(10)
  • REAL_WEIGHT (실제생산수량) — decimal(13,3)
  • REAL_UNIT (수량단위) — nvachar(10)
  • LOCATION_ID (저장위치) — nvachar(4)
  • BUNDLE_NO (이력번호) — nvachar(20)
  • DELETE_FLAG (삭제플래그) — nvachar(10)
  • PALLET_NO (팔레트번호) — nvachar(50)
  • CREATE_DTTM (생산일) — datetime
  • CREATE_BY (만든이) — nvachar(50)

TB_STOCK (재고)

  • BARCODE (바코드) — nvachar(50) — Primary key — NOT NULL
  • PART_ID (자재명) — nvarchar(30) — Primary key — NOT NULL
  • PLANT_ID (공장명) — nvarchar(20)
  • LOCATION_ID (저장위치) — nvarchar(20)
  • STOCK_DATE (재고날짜) — nvarchar(8)

ZTTABC0200 (중계테이블(계획))

  • AUFNR (생산오더) — Nvachar(12) — Primary key — NOT NULL
  • MANDT (CLIENT) — Nvacchar(3) — Primary key — NOT NULL
  • TRANS_D (전송일자) — Nvachar(8) — Primary key — NOT NULL
  • TRANS_T (전송시간) — Nvachar(6) — Primary key — NOT NULL
  • WERKS (플랜트) — Nvachar(4)
  • MATNR (자재) — Nvachar(18)
  • GAMNG (계획수량) — decimal(18,3)
  • MEINS (계획단위) — nvachar(3)
  • GSTRP (생산시작일) — Nvachar(8)
  • GLTRP (생산종료일) — Nvachar(8)
  • KUNNR (주문처) — nvachar(16)
  • ZVBELN (주문번호) — nvachar(10)
  • BSTKD (고객PO) — nvachar(35)
  • DELE (삭제플래그) — nvachar(1)
  • VDATU (납품요청일) — nvachar(8)
  • KWMENG (주문수량) — numeric(13,3)
  • INTERFACE_FLAG (생산계획 수신여부) — char(1)
  • INTERFACE_DATE (인터페이스 일자) — datetime
  • KUNNR2 (납품처) — nvachar(16)

ZTTMBA060 (중계테이블(도체))

  • MANDT (CLIENT) — Nvacchar(3) — Primary key — NOT NULL
  • TRANS_D (전송일자) — Nvachar(8) — Primary key — NOT NULL
  • TRANS_T (전송시간) — Nvachar(6) — Primary key — NOT NULL
  • EBLEN (구매오더번호) — Nvachar(10) — Primary key — NOT NULL
  • EBELP (품목) — Nvacahr(5) — Primary key — NOT NULL
  • SEQ (순번) — Nvachar(5) — Primary key — NOT NULL
  • LIFNR (공급업체) — Nvachar(10)
  • LIFNR_FARM (농장) — Nvachar(10)
  • WERKS (플랜트) — nvarchar(4)
  • LGORT (입고저장위치) — Nvachar(4)
  • CHARG (구매오더번호2) — Nvachar(10)
  • BUDAT (입고일) — datetime
  • D_DATE (도축일) — datetime
  • P_DATE (가공일) — datetime
  • CARNO (차량번호) — nvachar(3)
  • WEIGHT1_T (전체생체중) — decimal(13,3)
  • WEIGHT2_T (전체도체중) — decimal(13,3)
  • KUNNR (거래처명) — nvachar(20)