ADMIN_ALL_VW

(SQL View)
 Index Back

All Buyer Table

PO0025 - Master Contract Fluid

SELECT A.BUYER_ID ,B.OPRDEFNDESC FROM PS_BUYER_TBL A ,PSOPRDEFN B WHERE A.BUYER_ID = B.OPRID

  • Related Language Record: ADMIN_ALL_LG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

    Prompt Table: ROLEXLATOPR_VW

    2 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user