VNDR_CNTC_SR_EF

(SQL View)
 Index Back

Supplier Contact Effdt Srch VW


SELECT a.setid , a.vendor_id , a.cntct_seq_num , a.effdt , a.eff_status , a.contact_name , a.contact_type , a.contact_title , a.url , a.emailid , b.descr , b.ccr_addr_type FROM PS_VENDOR_CNTCT a , PS_VNDR_CNTCT_SCR b WHERE a.effdt = ( SELECT MAX(i.effdt) FROM PS_VENDOR_CNTCT i WHERE i.setid = a.setid AND i.vendor_id = a.vendor_id AND i.cntct_seq_num = a.cntct_seq_num AND i.eff_status = 'A' AND i.effdt <= %CurrentDateIn) AND a.setid = b.setid AND a.vendor_id = b.vendor_id AND a.cntct_seq_num = b.cntct_seq_num

  • Parent record: VENDOR

    • # 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 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    6 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL The individual contact name associated with a given bank/counterparty.
    7 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
    8 CONTACT_TITLE Character(35) VARCHAR2(35) NOT NULL The professional title for a given bank/counterparty contact person.
    9 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
    10 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
    11 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    12 CCR_ADDR_TYPE Character(3) VARCHAR2(3) NOT NULL SAM Address Type