EG_SS_ECRVND_VW

(SQL View)
 Index Back

Supplier List by ECRs

Created on 04/09/00 RML View to show suppliers by ECO 06/06/00 ST Added rel lang vw

SELECT DISTINCT a.BUSINESS_UNIT , a.ECR_ID , a.VENDOR_SETID , a.VENDOR_ID , b.NAME1 , a.inv_item_id_last FROM PS_EG_IC_ECRHDR_VW a , PS_VENDOR b WHERE a.VENDOR_SETID = b.SETID AND a.VENDOR_ID = b.VENDOR_ID

  • Related Language Record: EG_SS_ECRVN_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 ECR_ID Character(10) VARCHAR2(10) NOT NULL ECR Number
    3 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    5 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    6 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID