VENDOR_MSG_VW

(SQL View)
 Index Back

Supplier Header Table

Supplier Header Table

SELECT a.setid , a.vendor_id , a.vendor_name_short , a.vndr_name_shrt_usr , a.vndr_name_seq_num , a.name1 , a.name2 , a.vendor_status , a.vendor_class , a.vendor_persistence , a.remit_addr_seq_num , a.prim_addr_seq_num , a.addr_seq_num_ordr , 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.remit_loc , a.default_loc , a.name1_ac , a.name2_ac , a.primary_vendor , a.last_activity_dt , a.withhold_loc , a.in_process_flg , a.process_instance , a.hub_zone , a.eeo_certif_dt , a.hrms_class , a.interunit_vndr_flg , a.vndr_affiliate , a.business_unit , a.vndr_tin , a.archived_by , a.created_dttm , a.created_by_user , a.last_modified_date , a.vndr_field_c30_a , a.vndr_field_c30_b , a.vndr_field_c30_c , a.vndr_field_c30_d , a.vndr_field_c30_e , a.vndr_field_c30_f , a.vndr_field_c30_g , a.vndr_field_c30_h , a.vndr_field_c30_i , a.vndr_field_c30_j , 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 WHERE a.vendor_class = 'R' AND a.VENDOR_PERSISTENCE IN ('A','R') AND EXISTS ( SELECT 'X' FROM PS_VENDOR_LOC B WHERE B.SETID = A.SETID AND B.VENDOR_ID = A.VENDOR_ID AND B.EFFDT <= %CurrentDateIn)

  • Related Language Record: VENDOR_LANG

    • # 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 REMIT_ADDR_SEQ_NUM Number(5,0) INTEGER NOT NULL Remitting Location
    12 PRIM_ADDR_SEQ_NUM Number(5,0) INTEGER NOT NULL Invoicing Location
    13 ADDR_SEQ_NUM_ORDR Number(5,0) INTEGER NOT NULL Ordering Location
    14 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID

    Default Value: VENDOR.SETID

    15 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor
    16 CORPORATE_SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: VENDOR.SETID

    Prompt Table: SETID_TBL

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

    Default Value: VENDOR.VENDOR_ID

    Prompt Table: VNDR_VALCORP_VW

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

    Default Value: VENDOR.SETID

    Prompt Table: SETID_TBL

    19 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: CUSTOMER_FS

    20 ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered by
    21 AR_NUM Character(15) VARCHAR2(15) NOT NULL Our Customer Number
    22 OLD_VENDOR_ID Character(15) VARCHAR2(15) NOT NULL Old Vendor ID
    23 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

    24 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

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

    Y/N Table Edit

    Default Value: Y

    26 REMIT_LOC Character(10) VARCHAR2(10) NOT NULL Remit to Location
    27 DEFAULT_LOC Character(10) VARCHAR2(10) NOT NULL Default Location
    28 NAME1_AC Character(40) VARCHAR2(40) NOT NULL Name 1 Alternate Char Set
    29 NAME2_AC Character(40) VARCHAR2(40) NOT NULL Name 2 Alternate Char Set
    30 PRIMARY_VENDOR Character(10) VARCHAR2(10) NOT NULL Primary Supplier
    31 LAST_ACTIVITY_DT Date(10) DATE Last Activity Date
    32 WITHHOLD_LOC Character(10) VARCHAR2(10) NOT NULL Withholding Location
    33 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag

    Default Value: N

    34 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    35 HUB_ZONE Character(1) VARCHAR2(1) NOT NULL HUB Zone
    N=No
    Y=Yes

    Y/N Table Edit

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: SP_BU_GL_NONVW

    40 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    41 VNDR_TIN Character(1) VARCHAR2(1) NOT NULL Vendor Tax Id Number
    42 ARCHIVED_BY Character(30) VARCHAR2(30) NOT NULL Archived By
    43 CREATED_DTTM DateTime(26) TIMESTAMP Created Date and time
    44 CREATED_BY_USER Character(30) VARCHAR2(30) NOT NULL Created By
    45 LAST_MODIFIED_DATE DateTime(26) TIMESTAMP Last modified date
    46 VNDR_FIELD_C30_A Character(30) VARCHAR2(30) NOT NULL User Defined Vendor Field C30 A
    47 VNDR_FIELD_C30_B Character(30) VARCHAR2(30) NOT NULL User Defined Vendor Field C30 B
    48 VNDR_FIELD_C30_C Character(30) VARCHAR2(30) NOT NULL User Defined Vendor Field C30 S
    49 VNDR_FIELD_C30_D Character(30) VARCHAR2(30) NOT NULL User Defined Vendor Field C30 D
    50 VNDR_FIELD_C30_E Character(30) VARCHAR2(30) NOT NULL User Defined Vendor Field C30 E
    51 VNDR_FIELD_C30_F Character(30) VARCHAR2(30) NOT NULL User Defined Vendor Field C30 F
    52 VNDR_FIELD_C30_G Character(30) VARCHAR2(30) NOT NULL User Defined Vendor Field C30 G
    53 VNDR_FIELD_C30_H Character(30) VARCHAR2(30) NOT NULL User Defined Vendor Field C30 H
    54 VNDR_FIELD_C30_I Character(30) VARCHAR2(30) NOT NULL User Defined Vendor Field C30 I
    55 VNDR_FIELD_C30_J Character(30) VARCHAR2(30) NOT NULL User Defined Vendor Field C30 J
    56 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

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

    Default Value: V

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

    Y/N Table Edit

    Default Value: N

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