USF_CUST_VW

(SQL View)
 Index Back

Customer Cross Reference View

SAM xref view

SELECT XREF.USF_UEID , XREF.USF_EFT_IND ,XREF.DUNS_NUMBER ,XREF.USF_DUNS_PLUS4 , XREF.CUSTOMER_SETID , XREF.CUST_ID , CUST.CUST_STATUS , CUST.NAME1 , CASE WHEN CUST.CORPORATE_SETID = CUST.SETID THEN CASE WHEN CUST.CORPORATE_CUST_ID = CUST.CUST_ID THEN ' ' ELSE CUST.CORPORATE_SETID END ELSE CUST.CORPORATE_SETID END , CASE WHEN CUST.CORPORATE_SETID = CUST.SETID THEN CASE WHEN CUST.CORPORATE_CUST_ID = CUST.CUST_ID THEN ' ' ELSE CUST.CORPORATE_CUST_ID END ELSE CUST.CORPORATE_CUST_ID END FROM PS_USF_CUST_XREF XREF , PS_CUSTOMER CUST WHERE XREF.CUSTOMER_SETID = CUST.SETID AND XREF.CUST_ID = CUST.CUST_ID AND XREF.CUST_OBJ_TYPE = 'CUST'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 USF_UEID Character(12) VARCHAR2(12) NOT NULL Unique Entity Identifier
2 USF_EFT_IND Character(4) VARCHAR2(4) NOT NULL Entity EFT Indicator
3 DUNS_NUMBER Character(9) VARCHAR2(9) NOT NULL DUNS Number
4 USF_DUNS_PLUS4 Character(4) VARCHAR2(4) NOT NULL DUNS Suffix
5 SETID Character(5) VARCHAR2(5) NOT NULL SetID
6 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.
7 CUST_STATUS Character(1) VARCHAR2(1) NOT NULL Customer Status
A=Active
I=Inactive
T=Template
8 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
9 CORPORATE_SETID Character(5) VARCHAR2(5) NOT NULL SetID
10 CORPORATE_CUST_ID Character(15) VARCHAR2(15) NOT NULL Corporate Customer