E
테이블 (18)
PKG
- Key (ID_PKG) — uniqueidentifier — 기본 키 — NOT NULL
- Field
거래처마스터 (Untitled2)
반품+송장 (RARVSCH_INVOICE)
- Key (ID_RARVSCH_INVOICE) — uniqueidentifier — 기본 키 — NOT NULL
- Key (ID_RARVSCH) — uniqueidentifier — 외래 키 → 반품입고예약정보.Key — NOT NULL
- Key (ID_INVOICE) — uniqueidentifier — 외래 키 → 송장.Key — NOT NULL
- Field (REG_ID) — nvarchar(50)
- Field (REG_DTM) — datetime
- Field2 (UPD_ID) — nvarchar(50)
- Field3 (UPD_DTM) — datetime
반품입고예약정보 (RARVSCH)
- Key (ID_RARVSCH) — uniqueidentifier — 기본 키 — NOT NULL
- Field (IFSEQ)
- Field (DOCNUM)
- Field (REDOCNUM)
- Field (CRTTP)
- Field (CRTDT)
- Field (CRTTM)
- Field (DOCDT)
- Field (CARDCD)
- Field (CARDNM)
- Field (COMMENT)
- Field (CUSTNM)
- Field (ITEMCD)
- Field (QTY)
- Field (PRICE)
- Field (AMT)
- Field (VAT)
- Field (VOS)
- Field (FWHSCD)
- Field (FWHSNM)
- Field (TWHSCD)
- Field (TWHSNM)
- Field (IFYN)
- Field (ERRCD)
- Field (ERRMSG)
- Field (CANYN)
- Field (ORDERENTR)
- Field (ORDERDOCN)
- Field (OWTRENTR)
- Field (OWTRDOCN)
- Field (OWTRTP)
- Field (CREATEDATE1)
반품입고예약정보 (I_RARVSCH)
- Key (ID_I_RARVSCH) — uniqueidentifier — 기본 키 — NOT NULL
- Field (IFSEQ)
- Field (DOCNUM)
- Field (REDOCNUM)
- Field (CRTTP)
- Field (CRTDT)
- Field (CRTTM)
- Field (DOCDT)
- Field (CARDCD)
- Field (CARDNM)
- Field (COMMENT)
- Field (CUSTNM)
- Field (ITEMCD)
- Field (QTY)
- Field (PRICE)
- Field (AMT)
- Field (VAT)
- Field (VOS)
- Field (FWHSCD)
- Field (FWHSNM)
- Field (TWHSCD)
- Field (TWHSNM)
- Field (IFYN)
- Field (ERRCD)
- Field (ERRMSG)
- Field (CANYN)
- Field (ORDERENTR)
- Field (ORDERDOCN)
- Field (OWTRENTR)
- Field (OWTRDOCN)
- Field (OWTRTP)
- Field (CREATEDATE1)
반품입고예약정보이력 (H_RARVSCH)
- Key (ID_H_RARVSCH) — uniqueidentifier — 기본 키 — NOT NULL
- Field (IFSEQ)
- Field (DOCNUM)
- Field (REDOCNUM)
- Field (CRTTP)
- Field (CRTDT)
- Field (CRTTM)
- Field (DOCDT)
- Field (CARDCD)
- Field (CARDNM)
- Field (COMMENT)
- Field (CUSTNM)
- Field (ITEMCD)
- Field (QTY)
- Field (PRICE)
- Field (AMT)
- Field (VAT)
- Field (VOS)
- Field (FWHSCD)
- Field (FWHSNM)
- Field (TWHSCD)
- Field (TWHSNM)
- Field (IFYN)
- Field (ERRCD)
- Field (ERRMSG)
- Field (CANYN)
- Field (ORDERENTR)
- Field (ORDERDOCN)
- Field (OWTRENTR)
- Field (OWTRDOCN)
- Field (OWTRTP)
- Field (CREATEDATE1)
송장 (INVOICE)
- Key (ID_INVOICE) — uniqueidentifier — 기본 키 — NOT NULL
- Field — nvarchar(20)
- Field2
- Field3
- Field4
- Field5 (REG_ID) — nvarchar(50)
- Field5 (REG_DTM) — datetime
- Field5 (UPD_ID) — nvarchar(50)
- Field5 (UPD_DTM) — datetime
시점재고 (H_DAYILY_STOCK)
- ID (ID_DAYILY_STOCK) — 기본 키 — NOT NULL
- 장소구분 (SITE_CD)
- 위치구분 (ZON_CD)
- 품목코드 (ITM_CD)
- 유통기한 (Field)
- 제조번호 (Field2)
- 수량 (Field3)
- 등록일시 (REG_DTM)
- 등록ID (REG_ID)
- 수정일시 (UPD_DTM)
- 수정ID (UPD_ID)
식품이력보고이력 (H_RPT)
- ID (ID_H_RPT) — 기본 키 — NOT NULL
- 식품이력관리번호 (FOOD_HISTORY_SEQ)
- 품목코드 (ITM_CD)
- 제조번호 (Field)
- 유통기한 (Field2)
- 검사유무 (Field3)
- 시작위치 (Field4)
- 종료위치 (Field5)
- 등록일시 (REG_DTM)
- 등록ID (REG_ID)
- 수정일시 (UPD_DTM)
- 수정ID (UPD_ID)
식품이력보고자료 (RPT)
- ID (ID_RPT) — 기본 키 — NOT NULL
- 식품이력관리번호 (FOOD_HISTORY_SEQ)
- 품목코드 (ITM_CD)
- 제조번호 (Field)
- 유통기한 (Field2)
- 검사유무 (Field3)
- 시작위치 (Field4)
- 종료위치 (Field5)
- 등록일시 (REG_DTM)
- 등록ID (REG_ID)
- 수정일시 (UPD_DTM)
- 수정ID (UPD_ID)
창고마스터 (Untitled)
출하+송장 (SHPSHC_INVOICE)
- Key (ID_SHPSCH_INVOICE) — uniqueidentifier — 기본 키 — NOT NULL
- Key (ID_SHPSCH) — uniqueidentifier — 외래 키 → 출하지시.Key — NOT NULL
- Key (ID_INVOICE) — uniqueidentifier — 외래 키 → 송장.Key — NOT NULL
- Key (ID_SHPZON) — uniqueidentifier — 외래 키 → 출하라인.Key — NOT NULL
- Field (REG_ID) — nvarchar(50)
- Field2 (REG_DTM) — datetime
- Field (UPD_ID) — nvarchar(50)
- Field (UPD_DTM) — datetime
출하라인 (SHPZON)
- Key (ID_SHPZON) — uniqueidentifier — 기본 키 — NOT NULL
- Field (ID_SHPSCH) — uniqueidentifier
- Field (LINE_NO)
- Field (LINE_NME)
- Field (REG_ID) — nvarchar(50)
- Field (REG_DTM) — datetime
- Field2 (UPD_ID) — nvarchar(50)
- Field (UPD_DTM) — datetime
출하작업 (SHPWRK)
- Key (ID_SHPWRK) — uniqueidentifier — 기본 키 — NOT NULL
- Key (ID_PKG) — uniqueidentifier — 외래 키 → PKG.Key — NOT NULL
- Key (ID_SHPSCH) — uniqueidentifier — 외래 키 → 출하지시.Key — NOT NULL
- Field (REG_ID) — nvarchar(50)
- Field (REG_DTM) — datetime
- Field (UPD_ID) — nvarchar(50)
- Field (UPD_DTM) — datetime
출하지시 (SHPSCH)
- Key (ID_SHPSCH) — uniqueidentifier — 기본 키 — NOT NULL
- Field (NO) — nvarchar(20)
- Field2 (TFWH_ORD_DD) — nvarchar(8)
- Field (OMS_NEW_ORDG_NO) — nvarchar(30)
- Field (ORDG_DIV_CD) — nvarchar(20)
- Field (SABN_BCNC_NM) — nvarchar(20)
- Field (OMS_DGRE) — nvarchar(3)
- Field (ORDG_STA_CD) — nvarchar(20)
- Field (BCNC_GDS_CD) — nvarchar(20)
- Field (BCNC_GDS_NM) — nvarchar(200)
- Field (QTY) — int
- Field (OPTN) — nvarchar(200)
- Field (ODRR_FLNM) — nvarchar(50)
- Field (ODRR_CNPL_1) — nvarchar(15)
- Field (ODRR_CNPL_2) — nvarchar(15)
- Field (QICK_DVCD) — nvarchar(20)
- Field (DVEX_PYT_MTHD_CD) — nvarchar(20)
- Field (RECVR) — nvarchar(50)
- Field (RECVR_CNPL_1) — nvarchar(15)
- Field (RECVR_CNPL_2) — nvarchar(15)
- Field (RECVR_ZPCD) — nvarchar(6)
- Field (RECVR_BSIC_ADDR) — nvarchar(400)
- Field (RECVR_DTL_ADDR) — nvarchar(200)
- Field (QICK_MSG) — text
- Field (SNGLN_GDS_CD) — nvarchar(100)
- Field (SET_GDS_CD) — nvarchar(30)
- Field (SET_GDS_QTY) — int
- Field (SET_TOTAL_QTY) — int
- Field (BCNC_CD) — nvarchar(20)
- Field (STOS_CD) — nvarchar(20)
- Field (HMDLCO_CD) — nvarchar(20)
- Field (REG_ID) — nvarchar(50)
- Field (REG_DTM) — datetime
- Field (UPD_ID) — nvarchar(50)
- Field (UPD_DTM) — datetime
출하지시 (I_SHPSCH)
- Key (ID_I_SHPSCH) — uniqueidentifier — 기본 키 — NOT NULL
- Field (NO) — nvarchar(20)
- Field2 (TFWH_ORD_DD) — nvarchar(8)
- Field (OMS_NEW_ORDG_NO) — nvarchar(30)
- Field (ORDG_DIV_CD) — nvarchar(20)
- Field (SABN_BCNC_NM) — nvarchar(20)
- Field (OMS_DGRE) — nvarchar(3)
- Field (ORDG_STA_CD) — nvarchar(20)
- Field (BCNC_GDS_CD) — nvarchar(20)
- Field (BCNC_GDS_NM) — nvarchar(200)
- Field (QTY) — int
- Field (OPTN) — nvarchar(200)
- Field (ODRR_FLNM) — nvarchar(50)
- Field (ODRR_CNPL_1) — nvarchar(15)
- Field (ODRR_CNPL_2) — nvarchar(15)
- Field (QICK_DVCD) — nvarchar(20)
- Field (DVEX_PYT_MTHD_CD) — nvarchar(20)
- Field (RECVR) — nvarchar(50)
- Field (RECVR_CNPL_1) — nvarchar(15)
- Field (RECVR_CNPL_2) — nvarchar(15)
- Field (RECVR_ZPCD) — nvarchar(6)
- Field (RECVR_BSIC_ADDR) — nvarchar(400)
- Field (RECVR_DTL_ADDR) — nvarchar(200)
- Field (QICK_MSG) — text
- Field (SNGLN_GDS_CD) — nvarchar(100)
- Field (SET_GDS_CD) — nvarchar(30)
- Field (SET_GDS_QTY) — int
- Field (SET_TOTAL_QTY) — int
- Field (BCNC_CD) — nvarchar(20)
- Field (STOS_CD) — nvarchar(20)
- Field (HMDLCO_CD) — nvarchar(20)
- Field (REG_ID) — nvarchar(50)
- Field (REG_DTM) — datetime
- Field (UPD_ID) — nvarchar(50)
- Field (UPD_DTM) — datetime
출하지시이력 (H_SHPSCH)
- Key (ID_H_SHPSCH) — uniqueidentifier — 기본 키 — NOT NULL
- Field (NO) — nvarchar(20)
- Field2 (TFWH_ORD_DD) — nvarchar(8)
- Field (OMS_NEW_ORDG_NO) — nvarchar(30)
- Field (ORDG_DIV_CD) — nvarchar(20)
- Field (SABN_BCNC_NM) — nvarchar(20)
- Field (OMS_DGRE) — nvarchar(3)
- Field (ORDG_STA_CD) — nvarchar(20)
- Field (BCNC_GDS_CD) — nvarchar(20)
- Field (BCNC_GDS_NM) — nvarchar(200)
- Field (QTY) — int
- Field (OPTN) — nvarchar(200)
- Field (ODRR_FLNM) — nvarchar(50)
- Field (ODRR_CNPL_1) — nvarchar(15)
- Field (ODRR_CNPL_2) — nvarchar(15)
- Field (QICK_DVCD) — nvarchar(20)
- Field (DVEX_PYT_MTHD_CD) — nvarchar(20)
- Field (RECVR) — nvarchar(50)
- Field (RECVR_CNPL_1) — nvarchar(15)
- Field (RECVR_CNPL_2) — nvarchar(15)
- Field (RECVR_ZPCD) — nvarchar(6)
- Field (RECVR_BSIC_ADDR) — nvarchar(400)
- Field (RECVR_DTL_ADDR) — nvarchar(200)
- Field (QICK_MSG) — text
- Field (SNGLN_GDS_CD) — nvarchar(100)
- Field (SET_GDS_CD) — nvarchar(30)
- Field (SET_GDS_QTY) — int
- Field (SET_TOTAL_QTY) — int
- Field (BCNC_CD) — nvarchar(20)
- Field (STOS_CD) — nvarchar(20)
- Field (HMDLCO_CD) — nvarchar(20)
- Field (REG_ID) — nvarchar(50)
- Field (REG_DTM) — datetime
- Field (UPD_ID) — nvarchar(50)
- Field (UPD_DTM) — datetime