CUST_NAME_VW_AR (SQL View)	Index Back
Customer Name view Used for Direct Debit Search for Review by Unit. This view selects the customer name from CUSTOMER table based on setid and customer id for direct debits

CUST_NAME_VW_AR

(SQL View)

Customer Name view

Used for Direct Debit Search for Review by Unit. This view selects the customer name from CUSTOMER table based on setid and customer id for direct debits

SELECT DISTINCT C.SETID , C.CUST_ID , C.NAMESHORT FROM PS_CUSTOMER C , PS_DD_CONTROL DD WHERE C.CUST_ID = DD.CUST_ID

Related Language Record: CUST_NAME_LVW

# 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 NAMESHORT Character(10) VARCHAR2(10) NOT NULL Short Name

#	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	NAMESHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Name