RX_REP_REG_TBL

(SQL Table)
 Index Back

Self-service representative

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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.

Prompt Table: RX_CUST_VW

2 RX_CUST_REP_PSWD Character(32) VARCHAR2(32) NOT NULL Password for self-service representative to register.
3 SOLD_TO Character(1) VARCHAR2(1) NOT NULL Sold To

Y/N Table Edit

Default Value: Y

4 PRIMARY_SOLD_TO Character(1) VARCHAR2(1) NOT NULL Primary Sold To

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: Y

6 PRIMARY_SHIP_TO Character(1) VARCHAR2(1) NOT NULL Primary Ship To

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: Y

8 PRIMARY_BILL_TO Character(1) VARCHAR2(1) NOT NULL Primary Bill To

Y/N Table Edit

Default Value: N