RO_CUSTOMER_VW (SQL View)	Index Back
Current Effective Flat Tree This view is used to get the customer details like customerid, name, boid, etc.

RO_CUSTOMER_VW

(SQL View)

Current Effective Flat Tree

This view is used to get the customer details like customerid, name, boid, etc.

SELECT BC.SETID , BC.CUST_ID , BO.BO_NAME , BO.BO_NAME , BC.CUST_ID , BO.BO_NAME , BC.BO_ID , BC.BO_ID , BC.BO_ID , COMP.CUSTOMER_TYPE , 2 , 8 FROM PS_BC BC , PS_BO BO , PS_RD_COMPANY COMP WHERE BC.BO_ID = BO.BO_ID AND BC.CUSTOMER_IND = 'Y' AND BO.BO_TYPE_ID = 2 AND COMP.BO_ID = BC.BO_ID AND COMP.BO_ID = BO.BO_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

2 CUSTOMER_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 NAME1_PARENT Character(50) VARCHAR2(50) NOT NULL Customer Parent Name

4 NAME1 Character(50) VARCHAR2(50) NOT NULL Generic 50 character name field for storing names.

5 CUST_ID_DIRECT 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.

6 NAME1_DIRECT Character(50) VARCHAR2(50) NOT NULL Customer Name

7 BO_ID_PARENT Number(31,0) DECIMAL(31) NOT NULL Business Object ID of the Parent Company.

8 BO_ID_DIRECT Number(31,0) DECIMAL(31) NOT NULL Parent BO_ID

9 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

10 CUSTOMER_TYPE Character(1) VARCHAR2(1) NOT NULL Customer Type
1=User 1
2=User 2
3=User 3
4=User 4

11 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer

12 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
2	CUSTOMER_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	NAME1_PARENT	Character(50)	VARCHAR2(50) NOT NULL	Customer Parent Name
4	NAME1	Character(50)	VARCHAR2(50) NOT NULL	Generic 50 character name field for storing names.
5	CUST_ID_DIRECT	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.
6	NAME1_DIRECT	Character(50)	VARCHAR2(50) NOT NULL	Customer Name
7	BO_ID_PARENT	Number(31,0)	DECIMAL(31) NOT NULL	Business Object ID of the Parent Company.
8	BO_ID_DIRECT	Number(31,0)	DECIMAL(31) NOT NULL	Parent BO_ID
9	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
10	CUSTOMER_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Customer Type 1=User 1 2=User 2 3=User 3 4=User 4
11	ROLE_TYPE_ID_CUST	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the customer
12	ROLE_TYPE_ID_CNTCT	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the contact