CCR_CUST_VW

(SQL View)

SELECT XREF.DUNS_NUMBER , XREF.CCR_DUNS_PLUS4 , XREF.CUSTOMER_SETID , XREF.CUST_ID , CUST.CUST_STATUS , CUST.NAME1 FROM PS_CCR_CUST_XREF XREF , PS_CUSTOMER CUST WHERE XREF.CUSTOMER_SETID = CUST.SETID AND XREF.CUST_ID = CUST.CUST_ID AND XREF.SOURCE_SYSTEM = 'FED' AND XREF.CUST_OBJ_TYPE = 'CUST'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DUNS_NUMBER Character(9) VARCHAR2(9) NOT NULL DUNS Number

2 CCR_DUNS_PLUS4 Character(4) VARCHAR2(4) NOT NULL DUNS Suffix

3 SETID Character(5) VARCHAR2(5) NOT NULL SetID

4 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.

5 CUST_STATUS Character(1) VARCHAR2(1) NOT NULL Customer Status
A=Active
I=Inactive
T=Template

6 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DUNS_NUMBER	Character(9)	VARCHAR2(9) NOT NULL	DUNS Number
2	CCR_DUNS_PLUS4	Character(4)	VARCHAR2(4) NOT NULL	DUNS Suffix
3	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
4	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.
5	CUST_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Customer Status A=Active I=Inactive T=Template
6	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1