| # |
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 |
RA_DB_DB_DUNS |
Number(18,0) |
DECIMAL(18) NOT NULL |
D&B D-U-N-S Number
|
| 3 |
RA_DB_NAME |
Character(90) |
VARCHAR2(90) NOT NULL |
Business Name
|
| 4 |
RA_DB_TRDSTY1 |
Character(90) |
VARCHAR2(90) NOT NULL |
Trade Style/Secondary Name
|
| 5 |
RA_DB_REG_ADDR |
Character(1) |
VARCHAR2(1) NOT NULL |
Registered Address Indicator
|
| 6 |
RA_DB_ADDR |
Character(64) |
VARCHAR2(64) NOT NULL |
Physical Address
|
| 7 |
RA_DB_ADDR2 |
Character(64) |
VARCHAR2(64) NOT NULL |
Second Physical Address
|
| 8 |
RA_DB_CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
Physical City
|
| 9 |
RA_DB_STATENM |
Character(30) |
VARCHAR2(30) NOT NULL |
Physical State Name
|
| 10 |
RA_DB_CNTRYNM |
Character(20) |
VARCHAR2(20) NOT NULL |
Physical Country Name
|
| 11 |
RA_DB_CITY_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Physical City Code
|
| 12 |
RA_DB_CNTY_DB |
Character(3) |
VARCHAR2(3) NOT NULL |
County Code
|
| 13 |
RA_DB_STAT_DB |
Character(3) |
VARCHAR2(3) NOT NULL |
State/Province Code
|
| 14 |
RA_DB_STATE |
Character(4) |
VARCHAR2(4) NOT NULL |
State/Province Abbreviation
|
| 15 |
RA_DB_CNTRY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Country Code
|
| 16 |
RA_DB_ZIP |
Character(9) |
VARCHAR2(9) NOT NULL |
Postal Code for Street Address
|
| 17 |
RA_DB_CONT_CD |
Number(18,0) |
DECIMAL(18) NOT NULL |
Continent Code
|
| 18 |
RA_DB_MAILADDR |
Character(32) |
VARCHAR2(32) NOT NULL |
Mailing Address
|
| 19 |
RA_DB_MAILCITY |
Character(30) |
VARCHAR2(30) NOT NULL |
Mailing City Name
|
| 20 |
RA_DB_CNTYDBN |
Character(30) |
VARCHAR2(30) NOT NULL |
Mailing County Name
|
| 21 |
RA_DB_MSTATENM |
Character(30) |
VARCHAR2(30) NOT NULL |
Mailing State/Province Name
|
| 22 |
RA_DB_MCNTRYNM |
Character(20) |
VARCHAR2(20) NOT NULL |
Mailing Country Name
|
| 23 |
RA_DB_MCITY_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Mailing City Code
|
| 24 |
RA_DB_MCNTY_DB |
Character(3) |
VARCHAR2(3) NOT NULL |
Mailing County Code
|
| 25 |
RA_DB_MSTAT_DB |
Character(3) |
VARCHAR2(3) NOT NULL |
Mailing State/Province Code
|
| 26 |
RA_DB_MAILST |
Character(4) |
VARCHAR2(4) NOT NULL |
Mailing State/Province Abbrev
|
| 27 |
RA_DB_MCNTRYCD |
Character(3) |
VARCHAR2(3) NOT NULL |
Mailing Country Code
|
| 28 |
RA_DB_MAILZIP |
Character(9) |
VARCHAR2(9) NOT NULL |
Mailing Postal Code
|
| 29 |
RA_DB_MCONT_CD |
Number(18,0) |
DECIMAL(18) NOT NULL |
Mailing Continent Code
|
| 30 |
RA_DB_NATL_ID |
Character(16) |
VARCHAR2(16) NOT NULL |
National Identification
|
| 31 |
RA_DB_NIS_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
National Identification System
|
| 32 |
RA_DB_PHONE_CD |
Number(18,0) |
DECIMAL(18) NOT NULL |
Country Telephone Access Code
|
| 33 |
RA_DB_PHONE |
Number(18,0) |
DECIMAL(18) NOT NULL |
Telephone Number
|
| 34 |
RA_DB_CABLTELX |
Number(18,0) |
DECIMAL(18) NOT NULL |
Cable/Telex Number
|
| 35 |
RA_DB_FAX |
Number(18,0) |
DECIMAL(18) NOT NULL |
Fax Number
|
| 36 |
RA_DB_CEO_NAME |
Character(60) |
VARCHAR2(60) NOT NULL |
CEO Name
|
| 37 |
RA_DB_CEO_TITL |
Character(60) |
VARCHAR2(60) NOT NULL |
CEO Title
|
| 38 |
RA_DB_LOB |
Character(41) |
VARCHAR2(41) NOT NULL |
Line of Business
|
| 39 |
RA_DB_SIC10 |
Number(18,0) |
DECIMAL(18) NOT NULL |
U.S. 1987 SIC 1
|
| 40 |
RA_DB_SIC20 |
Number(18,0) |
DECIMAL(18) NOT NULL |
U.S. 1987 SIC 2
|
| 41 |
RA_DB_SIC30 |
Number(18,0) |
DECIMAL(18) NOT NULL |
U.S. 1987 SIC 3
|
| 42 |
RA_DB_SIC40 |
Number(18,0) |
DECIMAL(18) NOT NULL |
U.S. 1987 SIC 4
|
| 43 |
RA_DB_SIC50 |
Number(18,0) |
DECIMAL(18) NOT NULL |
U.S. 1987 SIC 5
|
| 44 |
RA_DB_SIC60 |
Number(18,0) |
DECIMAL(18) NOT NULL |
U.S. 1987 SIC 6
|
| 45 |
RA_DB_ACTIV_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Primary Local Activity Code
|
| 46 |
RA_DB_ACTIVIND |
Character(3) |
VARCHAR2(3) NOT NULL |
Activity Indicator
|
| 47 |
RA_DB_YRSTART |
Number(18,0) |
DECIMAL(18) NOT NULL |
Year Started
|
| 48 |
RA_DB_SALE_LOC |
Number(19,0) |
DECIMAL(19) NOT NULL |
Annual Sales Local
|
| 49 |
RA_DB_SALES_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Annual Sales Indicator
|
| 50 |
RA_DB_SALES |
Number(18,0) |
DECIMAL(18) NOT NULL |
Annual Sales in U.S. Dollars
|
| 51 |
RA_DB_CURR_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Currency Code
|
| 52 |
RA_DB_EMPHERE |
Number(18,0) |
DECIMAL(18) NOT NULL |
Employees Here
|
| 53 |
RA_DB_EMPH_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Employees Here Indicator
|
| 54 |
RA_DB_EMPTOTL |
Number(18,0) |
DECIMAL(18) NOT NULL |
Employees Total
|
| 55 |
RA_DB_EMPT_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Employees Total Indicator
|
| 56 |
RA_DB_INC_PRIN |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Principle
|
| 57 |
RA_DB_IMPORT_G |
Character(1) |
VARCHAR2(1) NOT NULL |
Import/Export/Agent Indicator
|
| 58 |
RA_DB_LGL_STAT |
Number(18,0) |
DECIMAL(18) NOT NULL |
Legal Status
|
| 59 |
RA_DB_CNTRLIND |
Number(18,0) |
DECIMAL(18) NOT NULL |
Control Indicator
|
| 60 |
RA_DB_STATUS_G |
Character(1) |
VARCHAR2(1) NOT NULL |
Global Status Code
|
| 61 |
RA_DB_SUBSID |
Number(18,0) |
DECIMAL(18) NOT NULL |
Subsidiary Code
|
| 62 |
RA_DB_PREV_DUN |
Number(18,0) |
DECIMAL(18) NOT NULL |
Previous D&B D-U-N-S Number
|
| 63 |
RA_DB_RPRT_DAT |
Character(8) |
VARCHAR2(8) NOT NULL |
Report Date
|
| 64 |
RA_DB_HQPR_DB_DUNS |
Number(18,0) |
DECIMAL(18) NOT NULL |
Headquarter/Parent D&B D-U-N-S Number
|
| 65 |
RA_DB_HP_NAME |
Character(90) |
VARCHAR2(90) NOT NULL |
Headquarter/Parent Name
|
| 66 |
RA_DB_HP_ADDR |
Character(64) |
VARCHAR2(64) NOT NULL |
Headquarter/Parent Address
|
| 67 |
RA_DB_HP_CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
Headquarter/Parent City
|
| 68 |
RA_DB_HP_STATE |
Character(30) |
VARCHAR2(30) NOT NULL |
Headquarter/Parent State
|
| 69 |
RA_DB_HP_CNAME |
Character(20) |
VARCHAR2(20) NOT NULL |
Headquarter/Parent Country Nam
|
| 70 |
RA_DB_HP_CTYCD |
Character(6) |
VARCHAR2(6) NOT NULL |
Headquarter/Parent City Code
|
| 71 |
RA_DB_HP_CNTCD |
Character(18) |
VARCHAR2(18) NOT NULL |
Headquarter/Parent County Code
|
| 72 |
RA_DB_HP_STABB |
Character(4) |
VARCHAR2(4) NOT NULL |
HDQ/PAR State/Province Abbrev.
|
| 73 |
RA_DB_HDQPARCD |
Character(3) |
VARCHAR2(3) NOT NULL |
HDQ/PARENT Country Code
|
| 74 |
RA_DB_HP_ZIP |
Character(9) |
VARCHAR2(9) NOT NULL |
Headquarter/Parent Postal Code
|
| 75 |
RA_DB_HP_CONCD |
Number(18,0) |
DECIMAL(18) NOT NULL |
HDQ/PARENT Continent Code
|
| 76 |
RA_DB_ULT_DB_DUNSD |
Number(18,0) |
DECIMAL(18) NOT NULL |
Domestic Ultimate D&B D-U-N-S Number
|
| 77 |
RA_DB_DU_NAME |
Character(90) |
VARCHAR2(90) NOT NULL |
Domestic Ultimate Name
|
| 78 |
RA_DB_DU_ADDR |
Character(64) |
VARCHAR2(64) NOT NULL |
Domestic Ultimate Address
|
| 79 |
RA_DB_DU_CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
Domestic Ultimate City
|
| 80 |
RA_DB_DU_STATE |
Character(30) |
VARCHAR2(30) NOT NULL |
Domestic Ultimate State
|
| 81 |
RA_DB_DU_CTYCD |
Character(6) |
VARCHAR2(6) NOT NULL |
Domestic Ultimate City Code
|
| 82 |
RA_DB_DU_CNTCD |
Character(3) |
VARCHAR2(3) NOT NULL |
Domestic Ultimate Country Code
|
| 83 |
RA_DB_DU_STABB |
Character(4) |
VARCHAR2(4) NOT NULL |
Domestic Ultimate State Abbrev
|
| 84 |
RA_DB_DU_ZIP |
Character(9) |
VARCHAR2(9) NOT NULL |
Domestic Ultimate Zip
|
| 85 |
RA_DB_ULT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Global Ultimate Indicator
|
| 86 |
RA_DB_ULT_DB_DUNS |
Number(18,0) |
DECIMAL(18) NOT NULL |
Global Ultimate D&B D-U-N-S Number
|
| 87 |
RA_DB_GU_NAME |
Character(90) |
VARCHAR2(90) NOT NULL |
Global Ultimate Name
|
| 88 |
RA_DB_GU_ADDR |
Character(64) |
VARCHAR2(64) NOT NULL |
Global Ultimate Address
|
| 89 |
RA_DB_GU_CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
Global Ultimate City
|
| 90 |
RA_DB_GU_STATE |
Character(30) |
VARCHAR2(30) NOT NULL |
Global Ultimate State
|
| 91 |
RA_DB_GU_CNAME |
Character(20) |
VARCHAR2(20) NOT NULL |
Global Ultimate Country Name
|
| 92 |
RA_DB_GU_CTYCD |
Character(6) |
VARCHAR2(6) NOT NULL |
Global Ultimate City Code
|
| 93 |
RA_DB_GU_CNTCD |
Character(3) |
VARCHAR2(3) NOT NULL |
Global Ultimate County Code
|
| 94 |
RA_DB_GU_STABB |
Character(4) |
VARCHAR2(4) NOT NULL |
Global Ultimate State Abbrev.
|
| 95 |
RA_DB_UCNTRYCD |
Character(3) |
VARCHAR2(3) NOT NULL |
Global Ultimate Country Code
|
| 96 |
RA_DB_GU_ZIP |
Character(9) |
VARCHAR2(9) NOT NULL |
Global Ultimate Zip Code
|
| 97 |
RA_DB_GU_CONCD |
Number(18,0) |
DECIMAL(18) NOT NULL |
Global Ultimate Continent Code
|
| 98 |
RA_DB_GLFAMMEM |
Character(5) |
VARCHAR2(5) NOT NULL |
Number of Global Family Member
|
| 99 |
RA_DB_DIAS_CDI |
Character(9) |
VARCHAR2(9) NOT NULL |
Global DIAS Code
|
| 100 |
RA_DB_HIERCHYI |
Character(2) |
VARCHAR2(2) NOT NULL |
Global Hierarchy Code
|
| 101 |
RA_DB_FAMUPDTE |
Character(8) |
VARCHAR2(8) NOT NULL |
Family Update Date
|
| 102 |
RA_DB_USERAREA |
Character(16) |
VARCHAR2(16) NOT NULL |
User Area
|
| 103 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
| 104 |
ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who added the row.
|
| 105 |
ROW_LASTMANT_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time that the row was last updated.
|
| 106 |
ROW_LASTMANT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who last modified the row.
|
| 107 |
SYNCID |
Number(10,0) |
DECIMAL(10) NOT NULL |
The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
|
| 108 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|