RX_ADR_DFLT_WRK (SQL Table)	Index Back
Cust Primary Info grid work Derived work record for Customer Primary Info grid, must be "Table" because it's the only record referenced in the grid.

RX_ADR_DFLT_WRK

(SQL Table)

Cust Primary Info grid work

Derived work record for Customer Primary Info grid, must be "Table" because it's the only record referenced in the grid.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.

3 PROFILE_CM_SEQ Number(31,0) DECIMAL(31) NOT NULL The Contact Method Profile ID is a key field that is used to reference the details of a Contact Method in various CM tables.

4 CM_ID Number(31,0) DECIMAL(31) NOT NULL Contact Method ID

5 CM_TYPE_ID Number(6,0) INTEGER NOT NULL Contact Method Type ID

6 PRIMARY_TYPE Character(2) VARCHAR2(2) NOT NULL Used to denote what primary info this is: (xlat) 10's - Primary contacts 20's - Primary addresses 30's - Primary phone 40's - Primary fax 50's - Pirmary email
10=Primary Contact
11=Primary Billing Contact
12=Primary Shipping Contact
13=Primary Sold-to Contact
20=Primary Address
21=Primary Billing Address
22=Primary Shipping Address
23=Primary Sold-to Address
30=Primary Phone
40=Primary Email
50=Primary Fax

7 BO_REL_ID Signed Number(32,0) DECIMAL(31) NOT NULL Relationship ID of a Business Object

8 LABEL_NAME Character(30) VARCHAR2(30) NOT NULL Label Name

9 DESCRLONG Long Character CLOB Long Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
2	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.
3	PROFILE_CM_SEQ	Number(31,0)	DECIMAL(31) NOT NULL	The Contact Method Profile ID is a key field that is used to reference the details of a Contact Method in various CM tables.
4	CM_ID	Number(31,0)	DECIMAL(31) NOT NULL	Contact Method ID
5	CM_TYPE_ID	Number(6,0)	INTEGER NOT NULL	Contact Method Type ID
6	PRIMARY_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Used to denote what primary info this is: (xlat) 10's - Primary contacts 20's - Primary addresses 30's - Primary phone 40's - Primary fax 50's - Pirmary email 10=Primary Contact 11=Primary Billing Contact 12=Primary Shipping Contact 13=Primary Sold-to Contact 20=Primary Address 21=Primary Billing Address 22=Primary Shipping Address 23=Primary Sold-to Address 30=Primary Phone 40=Primary Email 50=Primary Fax
7	BO_REL_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Relationship ID of a Business Object
8	LABEL_NAME	Character(30)	VARCHAR2(30) NOT NULL	Label Name
9	DESCRLONG	Long Character	CLOB	Long Description