VENDOR_M

(SQL Table)
Index Back

Supplier Header Table

  • Parent Record Of VNDR_ADDR_SCR_M VNDR_CNTCT_S_M VNDR_LOC_SCR_M
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SETID_TBL

    2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    3 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    4 VNDR_NAME_SHRT_USR Character(10) VARCHAR2(10) NOT NULL Short Vendor Name
    5 VNDR_NAME_SEQ_NUM Number(5,0) INTEGER NOT NULL Sequence Number
    6 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    7 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2
    8 VENDOR_STATUS Character(1) VARCHAR2(1) NOT NULL Vendor Status
    A=Approved
    D=Denied
    E=Unapproved
    I=Inactive
    X=To Be Archived
    9 VENDOR_CLASS Character(1) VARCHAR2(1) NOT NULL Vendor Classification
    A=Attorney
    E=Employee
    H=HCM
    R=Outside Party

    Default Value: R

    10 VENDOR_PERSISTENCE Character(1) VARCHAR2(1) NOT NULL Persistence
    O=One Time
    P=Permanent
    R=Regular
    S=Single Payment Supplier

    Default Value: R

    11 ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered by
    12 DEFAULT_LOC Character(10) VARCHAR2(10) NOT NULL Default Location
    13 HRMS_CLASS Character(1) VARCHAR2(1) NOT NULL Human Resources Classification
    D=General Deduction
    G=Garn Payee
    H=National Health Serv Provider
    I=Industrial Ins Board Provider
    M=Imp Partner Provider
    P=General Provider
    T=Tax Collector