SCR_LOC_ID_VW

(SQL View)
 Index Back

Supplier Loc ID Numbers

Supplier Location Record

SELECT b.setid , b.vendor_id , b.vndr_loc ,b.STD_ID_NUM_QUAL ,b.STD_ID_NUM ,b.STD_ID_SETID ,b.CREDIT_FLG , b.effdt ,b.effdt ,b.STD_ID_NUM_QUAL , 'N' FROM PS_SCR_LOC_SCRL_VW 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 STD_ID_NUM_QUAL Character(3) VARCHAR2(3) NOT NULL Standard ID Number
    5 STD_ID_NUM Character(35) VARCHAR2(35) NOT NULL ID Number
    6 STD_ID_SETID Character(5) VARCHAR2(5) NOT NULL SetID
    7 CREDIT_FLG Character(1) VARCHAR2(1) NOT NULL Credit Flag
    N=No
    Y=Yes

    Default Value: N

    8 SCR_EFFDT Date(10) DATE Approved Changes Take Effect

    Default Value: %Date

    9 EFFDT Date(10) DATE Effective Date

    Default Value: %Date

    10 SCR_STDID_NUM_QUAL Character(3) VARCHAR2(3) NOT NULL Standard ID Number
    ACN=Company Number - Australia
    BEI=BEI Identifier
    BUS=Business Types
    CCM=Municipal Reg Number - Brazil
    CGC=Comp Tax Reg Number - Brazil
    CID=Company Identification Number
    CPF=Ind Tax Reg Number - Brazil
    CRI=Creditor Identification
    DB=DUNS Number (With Edit)
    DNS=DUNS Number (No Edit)
    DOD=DODAAC Code
    DP4=DUNS+4 Suffix
    EIN=Employer ID Number
    FIC=Fiscal ID - Company - Italy
    FII=Fiscal ID - Indiv - Italy
    GLN=Global Location Number
    IE=State Reg Number - Brazil
    LER=Legal Entity Registration Num
    NIC=NIC Number - France
    NIF=Fiscal ID Number - Spain
    PSC=Public Service Codes
    SBA=SBA Business Types
    SRN=SIREN Number - France
    SRT=SIRET Number - France
    SSN=Social Security Number
    TIN=Tax Identification Number
    W2=W2 Identification Number
    11 SCR_REMOVE Character(1) VARCHAR2(1) NOT NULL Remove Contact

    Y/N Table Edit

    Default Value: N