VENDOR_HIR_VW

(SQL View)
Index Back

Supplier Header PTSF view


SELECT A.SETID , A.VENDOR_ID , A.VENDOR_NAME_SHORT , A.VNDR_NAME_SHRT_USR , A.NAME1 , A.NAME2 , A.VENDOR_STATUS , A.VENDOR_CLASS , A.VENDOR_PERSISTENCE , A.REMIT_SETID , A.REMIT_VENDOR , A.CORPORATE_SETID , A.CORPORATE_VENDOR , A.CUST_SETID , A.CUST_ID , A.ENTERED_BY , A.AR_NUM , A.OLD_VENDOR_ID , A.WTHD_SW , A.VAT_SW , A.VNDR_STATUS_PO , A.NAME1_AC , A.NAME2_AC , A.PRIMARY_VENDOR , A.LAST_ACTIVITY_DT , A.WITHHOLD_LOC , A.HUB_ZONE , A.EEO_CERTIF_DT , A.HRMS_CLASS , A.INTERUNIT_VNDR_FLG , A.VNDR_AFFILIATE , A.BUSINESS_UNIT , A.CREATED_DTTM , A.CREATED_BY_USER , A.LAST_MODIFIED_DATE , %subrec(vndr_usr_sbr,A) , A.VNDR_CCR_STATUS , A.OFAC_STATUS , A.OFAC_STATUS_DT , A.OFAC_MOD_USER , A.OFAC_LAG_DAYS , A.OFAC_SKIP_VAL , A.SDN_PUBLISH_DATE FROM PS_VENDOR A

  • Related Language Record: VNDR_HIR_VWLG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID_INQ Character(5) VARCHAR2(5) NOT NULL SetID
    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 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    6 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2
    7 VENDOR_STATUS Character(1) VARCHAR2(1) NOT NULL Vendor Status
    A=Approved
    D=Denied
    E=Unapproved
    I=Inactive
    X=To Be Archived
    8 VENDOR_CLASS Character(1) VARCHAR2(1) NOT NULL Vendor Classification
    A=Attorney
    E=Employee
    H=HCM
    R=Outside Party

    Default Value: R

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

    Default Value: R

    10 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID

    Default Value: VENDOR.SETID

    11 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor
    12 CORPORATE_SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: VENDOR.SETID

    Prompt Table: SETID_TBL

    13 CORPORATE_VENDOR Character(10) VARCHAR2(10) NOT NULL Corporate Vendor

    Default Value: VENDOR.VENDOR_ID

    Prompt Table: VNDR_VALCORP_VW

    14 CUST_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID

    Default Value: VENDOR.SETID

    Prompt Table: SETID_TBL

    15 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

    Prompt Table: VENDOR_CUST_VW

    16 ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered by
    17 AR_NUM Character(15) VARCHAR2(15) NOT NULL Our Customer Number
    18 OLD_VENDOR_ID Character(15) VARCHAR2(15) NOT NULL Old Vendor ID
    19 WTHD_SW Character(1) VARCHAR2(1) NOT NULL Withholding Applicable Flag
    B=Global and 1099
    G=Global
    T=1099

    Y/N Table Edit

    Default Value: N

    20 VAT_SW Character(1) VARCHAR2(1) NOT NULL Display VAT Flag
    H=Hide VAT checkbox
    N=Display VAT checkbox off
    Y=Display VAT checkbox on

    Y/N Table Edit

    Default Value: VENDOR_CONTROL.VAT_SW

    21 VNDR_STATUS_PO Character(1) VARCHAR2(1) NOT NULL Open For Ordering
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: Y

    22 NAME1_AC Character(40) VARCHAR2(40) NOT NULL Name 1 Alternate Char Set
    23 NAME2_AC Character(40) VARCHAR2(40) NOT NULL Name 2 Alternate Char Set
    24 PRIMARY_VENDOR Character(10) VARCHAR2(10) NOT NULL Primary Supplier
    25 LAST_ACTIVITY_DT Date(10) DATE Last Activity Date
    26 WITHHOLD_LOC Character(10) VARCHAR2(10) NOT NULL Withholding Location
    27 HUB_ZONE Character(1) VARCHAR2(1) NOT NULL HUB Zone
    N=No
    Y=Yes

    Y/N Table Edit

    28 EEO_CERTIF_DT Date(10) DATE EEO Certification Date
    29 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
    30 INTERUNIT_VNDR_FLG Character(1) VARCHAR2(1) NOT NULL InterUnit Vendor
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    31 VNDR_AFFILIATE Character(5) VARCHAR2(5) NOT NULL Vendor Affiliate

    Prompt Table: SP_BU_GL_NONVW

    32 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    33 CREATED_DTTM DateTime(26) TIMESTAMP Created Date and time
    34 CREATED_BY_USER Character(30) VARCHAR2(30) NOT NULL Created By
    35 LAST_MODIFIED_DATE DateTime(26) TIMESTAMP Last modified date
    36 VNDR_FIELD_C30_A Character(30) VARCHAR2(30) NOT NULL User Defined Vendor Field C30 A
    37 VNDR_FIELD_C30_B Character(30) VARCHAR2(30) NOT NULL User Defined Vendor Field C30 B
    38 VNDR_FIELD_C30_C Character(30) VARCHAR2(30) NOT NULL User Defined Vendor Field C30 S
    39 VNDR_FIELD_C30_D Character(30) VARCHAR2(30) NOT NULL User Defined Vendor Field C30 D
    40 VNDR_FIELD_C30_E Character(30) VARCHAR2(30) NOT NULL User Defined Vendor Field C30 E
    41 VNDR_FIELD_C30_F Character(30) VARCHAR2(30) NOT NULL User Defined Vendor Field C30 F
    42 VNDR_FIELD_C30_G Character(30) VARCHAR2(30) NOT NULL User Defined Vendor Field C30 G
    43 VNDR_FIELD_C30_H Character(30) VARCHAR2(30) NOT NULL User Defined Vendor Field C30 H
    44 VNDR_FIELD_C30_I Character(30) VARCHAR2(30) NOT NULL User Defined Vendor Field C30 I
    45 VNDR_FIELD_C30_J Character(30) VARCHAR2(30) NOT NULL User Defined Vendor Field C30 J
    46 VNDR_CCR_STATUS Character(1) VARCHAR2(1) NOT NULL SAM Status of a Vendor
    A=Active
    E=Expired
    U=Unregistered
    X=Exempt

    Default Value: X

    47 OFAC_STATUS Character(1) VARCHAR2(1) NOT NULL OFAC Status
    B=Blocked
    C=Cleared
    R=Review
    V=Valid

    Default Value: V

    48 OFAC_STATUS_DT Date(10) DATE Financial Sanctions Status Date
    49 OFAC_MOD_USER Character(30) VARCHAR2(30) NOT NULL Financial Sanctions Status Last Update User
    50 OFAC_LAG_DAYS Number(3,0) SMALLINT NOT NULL Financial Sanctions List Lag Days
    51 OFAC_SKIP_VAL Character(1) VARCHAR2(1) NOT NULL Financial Sanctions Skip Validation switch

    Y/N Table Edit

    Default Value: N

    52 SDN_PUBLISH_DATE Date(10) DATE Publish date given on the loaded Financial Sanction list.