SAC_SSVN_C_VW

(SQL View)
 Index Back

Supplier Contact Detail

Supplier Contact Detail

SELECT SETID , %Substring(BIDDER_ID, 1, 10) , CONTACT_SEQ_NUM , %CurrentDateIn , ADDR_SEQ_NUM , 'A' , %Substring(%TrimSubstr(FIRST_NAME, 1, 30) %CONCAT ' ' %CONCAT %TrimSubstr(LAST_NAME, 1, 30), 1, 50) , 'G' , %Substring(TITLE, 1, 35) , ' ' , ' ' , ' ' , EMAILID FROM PS_AUC_CONTACT_HDR

  • 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: VNDR_CNTCADR_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