SCR_LOC_SIC_VW

(SQL View)
 Index Back

Supplier Industry Class. Codes

Supplier Industry Class. Codes - Record

SELECT A.SETID , A.VENDOR_ID , A.VNDR_LOC ,A.SIC_CD_QUAL ,A.SIC_CODE , A.EFFDT ,A.EFFDT ,A.SIC_CD_QUAL ,A.SIC_CODE , 'N' FROM PS_VNDR_IND_CLASS A , PS_SCR_LOC_SCRL_VW 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

    Prompt Table: SETID_TBL

    2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    3 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
    4 SIC_CD_QUAL Character(3) VARCHAR2(3) NOT NULL SIC Code Type
    ANZ=Australia-New Zealand SIC Code
    CAN=Canadian NAICS Codes
    GER=German SIC Codes
    NAF=French SIC Codes
    SIC=US SIC Codes
    UK=UK 92 SIC Codes
    USA=US - NAICS Codes
    USE=NAICS Exception Codes
    USP=Primary NAICS Codes
    5 SIC_CODE Character(10) VARCHAR2(10) NOT NULL Standard Industry Code
    6 SCR_EFFDT Date(10) DATE Approved Changes Take Effect

    Default Value: %Date

    7 EFFDT Date(10) DATE Effective Date

    Default Value: %DATE

    8 SCR_SIC_CD_QUAL Character(3) VARCHAR2(3) NOT NULL SIC Code Type
    ANZ=Australia-New Zealand SIC Code
    CAN=Canadian NAICS Codes
    GER=German SIC Codes
    NAF=French SIC Codes
    SIC=US SIC Codes
    UK=UK 92 SIC Codes
    USA=US - NAICS Codes
    USE=NAICS Exception Codes
    USP=Primary NAICS Codes
    9 SCR_SIC_CODE Character(10) VARCHAR2(10) NOT NULL Standard Industry Code

    Prompt Table: SIC_CODE_VW2

    10 SCR_REMOVE Character(1) VARCHAR2(1) NOT NULL Remove Contact

    Y/N Table Edit

    Default Value: N