PO_SSVCNTCT_VW1

(SQL View)
 Index Back

Future Supplier Contact Detail


SELECT A.SETID , A.VENDOR_ID , A.CNTCT_SEQ_NUM , A.EFFDT , A.ADDRESS_SEQ_NUM , A.EFF_STATUS , A.CONTACT_NAME , A.CONTACT_TYPE , A.CONTACT_TITLE , A.PREFERRED_LANGUAGE , A.URL , A.DESCR , A.EMAILID , A.OPRID_EXT , A.EXT_VIEW_ACCESS , A.EXT_PRIMARY_OWNER , A.CS_SIGNER_FLG , A.CS_SIGN_NBR , A.CS_SIGN_VISIBLE FROM PS_VENDOR_CNTCT A WHERE A.EFFDT > %CurrentDateIn

  • Parent record: VNDR_CNTCT_SCR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    3 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number
    4 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    5 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

    Prompt Table: VENDOR_ADDR_VW

    6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    7 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL The individual contact name associated with a given bank/counterparty.
    8 CONTACT_TYPE Character(1) VARCHAR2(1) NOT NULL An attribute that describes the specific purpose of a given bank/counterparty contact person.
    B=Billing Contact
    C=Contract Collaborator
    D=Commercial Paper Contact
    E=External Contact
    F=Cash Forecast
    G=General
    I=Internal Corporate Contact
    L=Line of Credit Contact
    M=Executive Management
    O=Investment Pool Contact
    P=Accounts Payable
    R=Broker
    S=Sales Contact
    V=Service Contact
    W=Warehousing/Shipping Contact
    9 CONTACT_TITLE Character(35) VARCHAR2(35) NOT NULL The professional title for a given bank/counterparty contact person.
    10 PREFERRED_LANGUAGE Character(3) VARCHAR2(3) NOT NULL Preferred Language
    ARA=Arabic
    CFR=Canadian French
    CZE=Czech
    DAN=Danish
    DUT=Dutch
    E=English
    ENG=English
    ESP=Spanish
    F=French
    FIN=Finnish
    FRA=French
    GER=German
    HUN=Hungarian
    INE=International English
    ITA=Italian
    JPN=Japanese
    KOR=Korean
    NOR=Norwegian
    POL=Polish
    POR=Portuguese
    RUS=Russian
    SVE=Swedish
    THA=Thai
    UKE=UK English
    ZHS=Simplified Chinese
    ZHT=Traditional Chinese
    11 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
    12 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    13 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
    14 OPRID_EXT Character(30) VARCHAR2(30) NOT NULL External user
    15 EXT_VIEW_ACCESS Character(1) VARCHAR2(1) NOT NULL Document access bu external users

    Y/N Table Edit

    Default Value: N

    16 EXT_PRIMARY_OWNER Character(1) VARCHAR2(1) NOT NULL Primary owner for external collaboration

    Y/N Table Edit

    Default Value: N

    17 CS_SIGNER_FLG Character(1) VARCHAR2(1) NOT NULL Contract Signer

    Y/N Table Edit

    Default Value: N

    18 CS_SIGN_NBR Number(3,0) SMALLINT NOT NULL Order of signatures

    Default Value: 0

    19 CS_SIGN_VISIBLE Character(1) VARCHAR2(1) NOT NULL Visibile/invisible digital signatures

    Y/N Table Edit

    Default Value: N