CWB_CONTACT_LVW

(SQL View)
Index Back

CWB Customer Contacts

Collections Workbench Customer Contacts Related Language View

SELECT A.SETID , A.CUST_ID , A.CNTCT_SEQ_NUM , C.CONTACT_ID , B.NAME1 , A.LANGUAGE_CD FROM PS_CUST_CNTCT_LANG A , PS_CONTACT_LANG B , PS_CONTACT_CUST C WHERE %Join(COMMON_KEYS, CUST_CNTCT_LANG A, CONTACT_LANG B) AND %Join(COMMON_KEYS, CUST_CNTCT_LANG A, CONTACT_CUST C) AND %Join(COMMON_KEYS, CONTACT_LANG B, CONTACT_CUST C) AND %EffdtCheck(CUST_CNTCT_LANG X, A, %currentdatein) AND %EffdtCheck(CONTACT_LANG Y, B, %currentdatein) AND %EffdtCheck(CONTACT_CUST Z, C, %currentdatein)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
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.
3 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number
4 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
5 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code