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)