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

      품목BOM (Untitled3)