SCR_LID_ORG_VW

(SQL View)
 Index Back

Supplier Loc ID Numbers

Supplier Location Record

SELECT a.setid , a.vendor_id , a.vndr_loc ,a.effdt , %subrec(STD_ID_NUM_SBR,b) FROM PS_VENDOR_LOC a ,PS_VNDR_LOC_ID_NBR b WHERE a.setid = b.setid AND a.vendor_id = b.vendor_id AND a.vndr_loc = b.vndr_loc AND a.effdt = b.effdt

  • Parent record: SCR_LOC_SCRL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    3 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
    4 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    5 STD_ID_NUM_QUAL Character(3) VARCHAR2(3) NOT NULL Standard ID Number
    6 STD_ID_NUM Character(35) VARCHAR2(35) NOT NULL ID Number
    7 STD_ID_SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    8 CREDIT_FLG Character(1) VARCHAR2(1) NOT NULL Credit Flag
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N