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 (수량)