SETIDRA_LIST_IDRA_LIST_REC_IDF=Female
M=Male
U=Unknown
Y/N Table Edit
Default Value: N
RA_LIST_REC_800(SQL Table) |
Index Back |
|---|---|
Marketing UpgradeMarketing Upgrade work records for 800 |
| # | 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 | RA_LIST_ID |
Character(15) | VARCHAR2(15) NOT NULL | Audience ID |
| 3 | RA_LIST_REC_ID |
Number(18,0) | DECIMAL(18) NOT NULL | List Record ID |
| 4 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 5 | CUST_SETID | Character(5) | VARCHAR2(5) NOT NULL | Customer Setid |
| 6 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Customer ID |
| 7 | NAME1 | Character(50) | VARCHAR2(50) NOT NULL | Generic 50 character name field for storing names. |
| 8 | INDUSTRY_ID | Character(30) | VARCHAR2(30) NOT NULL | Industry ID. |
| 9 | ADDRESS_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Address Sequence Number from Supply Chain Management. Field size increased from 3 to 5 in CRM 8.95, as Supply Chain Management has increased the size to 5 in SCM 8.9 release. |
| 10 | CR_ADDRESS_ID | Character(15) | VARCHAR2(15) NOT NULL | This field stores the Address ID of a Customer. |
| 11 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 12 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 13 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 14 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 15 | COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
| 16 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 17 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 18 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 19 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 20 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 21 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 22 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender of the person.
F=Female M=Male U=Unknown |
| 23 | BIRTHDATE | Date(10) | DATE | Birthdate of the person. |
| 24 | COUNTRY_CODE | Character(3) | VARCHAR2(3) NOT NULL | This field stores the Country Code values. |
| 25 | WORK_PHONE | Character(24) | VARCHAR2(24) NOT NULL | Work Phone |
| 26 | EXTENSION | Character(6) | VARCHAR2(6) NOT NULL | This field stores the Phone extension. |
| 27 | HOME_PHONE | Character(24) | VARCHAR2(24) NOT NULL | Home Phone |
| 28 | CELL_PHONE | Character(24) | VARCHAR2(24) NOT NULL | Cell Phone |
| 29 | FAX | Character(24) | VARCHAR2(24) NOT NULL | This is the fax number field. |
| 30 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email address to store the address of email. |
| 31 | DELETED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Deleted Flag Field
Y/N Table Edit Default Value: N |
| 32 | BO_ID | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 33 | ROLE_TYPE_ID | Number(12,0) | DECIMAL(12) NOT NULL | Role Type ID |
| 34 | CM_ID_ADDRESS | Number(31,0) | DECIMAL(31) NOT NULL | Contact Method ID |
| 35 | CM_ID_EMAIL | Number(31,0) | DECIMAL(31) NOT NULL | CM_ID_EMAIL |
| 36 | CM_ID_PHONE | Number(31,0) | DECIMAL(31) NOT NULL | CM_ID_PHONE |
| 37 | CM_ID | Number(31,0) | DECIMAL(31) NOT NULL | Contact Method ID |
| 38 | REL_TYPE_ID | Number(12,0) | DECIMAL(12) NOT NULL | Relationship Type ID |
| 39 | BO_ID_2 | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID 2 |
| 40 | ROLE_TYPE_ID_2 | Number(12,0) | DECIMAL(12) NOT NULL | Role Type ID |