HSCP

테이블 (11)

HSCP C_VENDOR_MA (Untitled5)

  • VENDOR_CD (업체코드) — 기본 키 — NOT NULL
  • VENDOR_NM (업체이름)
  • VENDOR_CITY (업체위치)
  • VENDOR_COUNTY (업체국가)
  • VENDOR_ADDR (업체주소)
  • VENDOR_TEL (업체번호)
  • VENDOR_TEL2 (업체번호2)
  • FAX (Field7)
  • BUSSINESS_NO (비지니스번호)
  • CEO (대표자)
  • MANAGER (담당자)
  • E_MAIL (이메일주소)
  • USE_YN (사용여부)
  • REG_DATE (등록일자)
  • REG_USER (등록자)
  • UPDATE_DATE (수정일자)
  • UPDATE_USER (수정자)

HSCP C_VENDOR_ITEM(테이블) (Untitled4)

  • VENDOR_CD (업체코드) — 기본 키 — NOT NULL
  • ITEM_CD (아이템코드) — 기본 키 — NOT NULL
  • ITEM_NM (아이템이름)
  • ITEM_MDL (모듈이름)
  • ITEM_QTY (Field3)
  • ITEM_CTNR (?)
  • INBOX_QTY (1박스수량)
  • WHS_CD (창고코드)
  • ITEM_UNIT (단위)
  • INSP_YN (Field8)
  • FAI_YN (Field9)
  • USE_YN (Field10)
  • REG_DATE (등록날짜)
  • REG_USER (등록자)
  • UPDATE_DATE (수정날짜)
  • UPDATE_USER (수정자)

HSCP View_BOM(뷰테이블) (Untitled3)

  • VENDOR_CD (업체코드)
  • VENDOR_NM (업체이름)
  • ABSCODE (최상위품번)
  • ABSName (최상위품명)
  • F_Code (최상위품번2)
  • F_NAME (최상위품명2)
  • ITEM_CD (자재코드)
  • ITEM_NM (자재이름)
  • UsageQty (자재소요량)

PWC_View_GoodsReceiptRawData (Untitled7)

  • DocDate (Field)
  • CardCode (업체코드)
  • CardName (업체이름)
  • ItemCode (품목코드)
  • ItemName (품목명)
  • WhsCode (창고코드)
  • Quantity (수량)
  • comments (코멘트)

PWC_View_IfGoodsReceiptRawData (Untitled6)

  • DocDate (Field)
  • CardCode (업체코드)
  • CardName (업체이름)
  • ItemCode (품목코드)
  • ItemName (품목명)
  • WhsCode (창고코드)
  • Quantity (수량)
  • IFStatus (상태값)
  • PONum (ponum)
  • PODate (podate)

Pwc_View_GoodsReturnRawData (Untitled8)

  • DocDate (반품일자)
  • CarCode (공급업체)
  • CarName (공급업체명)
  • ItemCode (품목코드)
  • ItemName (품목명)
  • WhsCode (창고)
  • Quantity (수량)
  • Comments (비고)

Pwc_View_InvnOnHand (CopyOfUntitled3)

  • CardCode (업체코드)
  • CardName (업체명)
  • ItemCode (품목코드)
  • ItemName (품목명)
  • WhsCode (창고)
  • OnHand (현재고)
  • ConStock (위탁재고)

Pwc_View_OtherInOutRawData (CopyOfUntitled8)

  • DocDate (입출고일자)
  • ItemCode (품목코드)
  • ItemName (품목명)
  • WhsCode (창고)
  • Quantity (수량)
  • TransType (입출고유형)
  • CarCode (공급업체)
  • CarName (공급업체명)

Pwc_View_ProdPlanRawDate (Untitled)

  • DocDate (생산계획일자) — 생산계획일자
  • WorkType (주/야 구분)
  • LineSeq (순번)
  • LineName (작업장명)
  • ABSCODE (최상위품번)
  • Code (모품번)
  • ITEMCODE (자품번)
  • PlanQty (계획수량)
  • Qty (계획소요량)
  • Confrm YN (확정처리여부)
  • CardCode (업체코드)
  • CardName (업체이름)

Pwc_View_ProdReceiptRawDate (Untitled2)

  • DocDate (실적일자)
  • ItemCode (품목코드)
  • Dscription (품목명)
  • WhsCode (창고코드)
  • Quantity (수량)

Pwc_View_Stock_InvCnt (CopyOfCopyOfUntitled3)

  • DocDate (날짜)
  • Warehouse (창고)
  • ItemCode (품목코드)
  • InvQty (수량)