RX_REP_REG_VW (SQL View)	Index Back
Self-service representative This record contains all fields required to authenticate the representative registration through self-service.

RX_REP_REG_VW

(SQL View)

Self-service representative

This record contains all fields required to authenticate the representative registration through self-service.

SELECT A.RX_CUST_KEY , A.BO_ID_CUST , B.RX_CUST_REP_PSWD , C.BO_NAME , B.RX_PSWD_INIT_COUNT , B.RX_PSWD_CURR_COUNT , B.SOLD_TO , B.SHIP_TO , B.BILL_TO FROM PS_RX_REP_REG_CUST A , PS_RX_REP_REG_PSWD B , PS_BO C WHERE A.RX_CUST_KEY = B.RX_CUST_KEY AND A.BO_ID_CUST = C.BO_ID

Parent record: RX_REP_REG_CUST

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RX_CUST_KEY Character(12) VARCHAR2(12) NOT NULL Password for self-service representative to register.

2 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.

3 RX_CUST_REP_PSWD Character(32) VARCHAR2(32) NOT NULL Password for self-service representative to register.

4 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object

5 RX_PSWD_INIT_COUNT Number(3,0) SMALLINT NOT NULL Initial count of how many self-service representatives can register using the company rep password

6 RX_PSWD_CURR_COUNT Number(3,0) SMALLINT NOT NULL Current count of how many self-service representatives can still register using the company rep password

7 SOLD_TO Character(1) VARCHAR2(1) NOT NULL Sold To

8 SHIP_TO Character(1) VARCHAR2(1) NOT NULL A boolean that flags whether or not the customer is a valid Ship To customer.

9 BILL_TO Character(1) VARCHAR2(1) NOT NULL Bill To

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RX_CUST_KEY	Character(12)	VARCHAR2(12) NOT NULL	Password for self-service representative to register.
2	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
3	RX_CUST_REP_PSWD	Character(32)	VARCHAR2(32) NOT NULL	Password for self-service representative to register.
4	BO_NAME	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object
5	RX_PSWD_INIT_COUNT	Number(3,0)	SMALLINT NOT NULL	Initial count of how many self-service representatives can register using the company rep password
6	RX_PSWD_CURR_COUNT	Number(3,0)	SMALLINT NOT NULL	Current count of how many self-service representatives can still register using the company rep password
7	SOLD_TO	Character(1)	VARCHAR2(1) NOT NULL	Sold To
8	SHIP_TO	Character(1)	VARCHAR2(1) NOT NULL	A boolean that flags whether or not the customer is a valid Ship To customer.
9	BILL_TO	Character(1)	VARCHAR2(1) NOT NULL	Bill To