C360_CUS_LVL_PG (SQL Table)	Index Back
Comprehensive Customer View

C360_CUS_LVL_PG

(SQL Table)

Comprehensive Customer View

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 C360_CUST_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID

3 C360_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer ID

4 CUST_LEVEL_QRY Character(1) VARCHAR2(1) NOT NULL Customer Level
C=Corporate
N=No Relationship
P=Correspondence
R=Remit From

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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	C360_CUST_SETID	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID
3	C360_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer ID
4	CUST_LEVEL_QRY	Character(1)	VARCHAR2(1) NOT NULL	Customer Level C=Corporate N=No Relationship P=Correspondence R=Remit From
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.