SCR_LSIC_ORG_VW

(SQL View)
Index Back

Supplier Industry Class. Codes

Supplier Industry Class. Codes - Record

SELECT A.SETID , A.VENDOR_ID , A.VNDR_LOC , A.EFFDT ,A.SIC_CD_QUAL ,A.SIC_CODE 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 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    5 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
    6 SIC_CODE Character(10) VARCHAR2(10) NOT NULL Standard Industry Code