VENDOR

(SQL Table)
 Index Back

Supplier Header Table

Supplier Header Table

  • Related Language Record: VENDOR_LANG

  • Parent Record Of BIDDER_ID_NBRS BID_ID_NBRS_HST PO_SSVNADDR_SCR PO_SSVNCNTC_SCR SAC_SSVN_AS_VW SAC_SSVN_CS_VW SAC_SSVN_LS_VW SCR_VND_INV_VW SPF_VEND_TAO SUPOB_ID_NBR_WK VAT_AP_OPT_SBR VAT_OPT_SBR VAT_OPT_SBR2 VENDOR_CONVER VENDOR_ID_NBRS VENDOR_INVOICE VENDOR_SPRO VNDRADDR_SES_VW VNDRADD_SES_LVW VNDRLOCSCROL_LG VNDRLOCSCR_E_LG VNDR_ADDRS2_LVW VNDR_ADDR_EF_VW VNDR_ADDR_S2_VW VNDR_ADDR_SCROL VNDR_ADDR_SR_EF VNDR_CATG_PURP VNDR_CNTCT_SCR VNDR_CNTC_SR_EF VNDR_LOC_SCROL VNDR_LOC_SR_EF VNDR_NAME_HST VNDR_NAME_HS_LN VNDR_OTHID

    • # 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: VENDOR_CUST_VW

    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.
    63 SES_LAST_DTTM DateTime(26) TIMESTAMP PTSF Last Modified DateTimestamp

    Default Value: %datetime

    64 SES_VN_ATTR_L_DTTM DateTime(26) TIMESTAMP PTSF Last Modified DateTime specific for vendor attributes such as vendor name, vendor location, vendor phone and vendor contact.

    Default Value: %DATETIME

    65 SUPPLIER_RATING Character(1) VARCHAR2(1) NOT NULL Supplier Rating
    E=Excellent
    F=Fair
    G=Good
    N=None
    P=Poor

    Default Value: N

    66 COMMENTS_2000 Long Character CLOB Comment Text
    67 SUPPAUDIT_FLG Character(1) VARCHAR2(1) NOT NULL Used to mention 'Default' or 'Specify' on the Vendor Page
    D=Default
    S=Specify

    Default Value: D

    68 VNDR_AUDIT_FLG Character(1) VARCHAR2(1) NOT NULL Supplier Audit

    Y/N Table Edit

    Default Value: N

    69 TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Project Template

    Prompt Table: VNDR_AUDIT_TMPL