ORDENT_CNTCT_VW (SQL View)	Index Back
Customer Contact Detail Date Init. Issue # Description 10/09/01 JJM F-CJORGENS-6 Updated SQL to use "new" tables

ORDENT_CNTCT_VW

(SQL View)

Customer Contact Detail

Date Init. Issue # Description 10/09/01 JJM F-CJORGENS-6 Updated SQL to use "new" tables

SELECT CC.CUSTOMER_SETID , CC.CUST_ID , CC.CNTCT_SEQ_NUM , CC.EFFDT , CC.EFF_STATUS , CT.NAME1 , CT.TITLE , CC.ADDRESS_SEQ_NUM , CT.LANGUAGE_PREF , CT.EMAILID , CT.COMM_METHOD , CT.SALUTATION_CD , CT.SALUTATION , CT.SETID , CT.CONTACT_ID FROM PS_CONTACT CT , PS_CONTACT_CUST CC WHERE %Join(COMMON_KEYS, CONTACT CT, CONTACT_CUST CC) AND CT.EFF_STATUS = 'A' AND CC.EFF_STATUS = 'A'

Related Language Record: ORDENT_CNTCTLVW

Parent record: CUST_CNTCT_SEQ

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL 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.

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

4 EFFDT Date(10) DATE NOT NULL Effective Date

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

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

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

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

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

13 SALUTATION Character(30) VARCHAR2(30) NOT NULL Salutation

14 CONTACT_SETID Character(5) VARCHAR2(5) NOT NULL Contact SetID

15 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	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.
3	CNTCT_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Contact Sequence Number
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date
5	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
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
9	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
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
12	SALUTATION_CD	Character(6)	VARCHAR2(6) NOT NULL	Salutation Code
13	SALUTATION	Character(30)	VARCHAR2(30) NOT NULL	Salutation
14	CONTACT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Contact SetID
15	CONTACT_ID	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts