CUST_CNCT_EF2VW

(SQL View)
 Index Back

Customer Contact Detail

This is used for the CUSTOMER_FULLSYNC_EFF message. The effective status selection criteria is not selected in this view.

SELECT A.SETID , A.CUST_ID , A.CNTCT_SEQ_NUM , A.EFFDT , A.EFF_STATUS , A.NAME1 , A.TITLE , A.ADDRESS_SEQ_NUM , A.LANGUAGE_CD , A.EMAILID , A.COMM_METHOD , A.SALUTATION_CD , A.SALUTATION , A.LAST_MAINT_OPRID , A.DATE_LAST_MAINT , A.AUTHORIZATION_ID FROM PS_CUST_CONTACT A WHERE %EffdtCheck(cust_contact, A, %currentdatein)

  • Parent record: CUST_CNTCT_SEQ

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

    2 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

    3 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number

    Prompt Table: CUST_CONTACT

    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

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

    Default Value: A

    6 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    7 TITLE Character(35) VARCHAR2(35) NOT NULL Title
    8 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

    Default Value: CUSTOMER.ADDRESS_SEQ_NUM

    Prompt Table: CUST_ADDR_EF_VW

    9 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

    Default Value: PSOPTIONS.LANGUAGE_CD

    10 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
    11 COMM_METHOD Character(1) VARCHAR2(1) NOT NULL Preferred Communication
    A=Email Invoice as Attachment
    C=Call
    E=Email only
    F=Fax
    I=XML only
    M=Standard Mail
    N=Email Notification
    P=Email & Print
    R=XML & Print

    Default Value: C

    12 SALUTATION_CD Character(6) VARCHAR2(6) NOT NULL Salutation Code

    Prompt Table: SALUTATION_TBL

    13 SALUTATION Character(30) VARCHAR2(30) NOT NULL Salutation
    14 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
    15 DATE_LAST_MAINT Date(10) DATE Date Last Maintained
    16 AUTHORIZATION_ID Character(10) VARCHAR2(10) NOT NULL Authorization ID