VNDR_HDR_IND_CL

(SQL Table)
Index Back

Supplier Header Ind Class. Cod

Supplier Header Ind Class. Codes

  • Parent record: VENDOR_LOC
  • # 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 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
    4 SIC_CODE Character(10) VARCHAR2(10) NOT NULL Standard Industry Code

    Prompt Table: SIC_CODE_VW2