| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 MOBILE_DEFAULT_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
MOBILE_DEFAULT_ID
|
| 2 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 3 |
RIM_THIRD_PARTY |
Character(1) |
VARCHAR2(1) NOT NULL |
Third party Vendor flag for Blackberry application.
A=1
S=2
|
| 4 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Prompt Table:
SP_SETID2_NONVW
|
| 5 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Default Value: INSTALLATION.COUNTRY
Prompt Table:
COUNTRY_TBL
|
| 6 |
RELATIONSHIP_VIEW |
Character(1) |
VARCHAR2(1) NOT NULL |
RELATIONSHIP_VIEW
Y/N Table Edit
Default Value: Y
|
| 7 |
SPIDER_OUT_REL |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag in setup for spider out relationship (mobile).
Y/N Table Edit
Default Value: N
|
| 8 |
ALLOW_TRANSFER_REL |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Transfer From Rel. View
Y/N Table Edit
Default Value: Y
|
| 9 |
CM_PURP_TYPE_ADDR |
Number(6,0) |
INTEGER NOT NULL |
Used by PIM_PREFERENCE for PIM Configuration
Prompt Table:
CM_PURP_ADR_VW
|
| 10 |
THREE_SIXTY_VIEW |
Character(1) |
VARCHAR2(1) NOT NULL |
THREE_SIXTY_VIEW
Y/N Table Edit
Default Value: Y
|
| 11 |
ALLOW_TRANSFER_360 |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Transfer From 360 View
Y/N Table Edit
Default Value: Y
|
| 12 |
CM_PURP_TYPE_MAIL |
Number(6,0) |
INTEGER NOT NULL |
CP Purp Type Mail
Prompt Table:
CM_PURP_EML_VW
|
| 13 |
CM_PURP_TYPE_PAGE |
Number(6,0) |
INTEGER NOT NULL |
CP Purp Type Page
Prompt Table:
CM_PURP_PAG_VW
|
| 14 |
CM_PURP_TYPE_PHON |
Number(6,0) |
INTEGER NOT NULL |
Used by PIM_PREFERENCE for PIM Configuration
Prompt Table:
CM_PURP_PHN_VW
|
| 15 |
BILL_TO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
A boolean that flags whether or not the customer is a valid Bill To customer.
Y/N Table Edit
Default Value: N
|
| 16 |
SHIP_TO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag indicating that the customer or address is a valid Ship To customer or address.
Y/N Table Edit
Default Value: N
|
| 17 |
SOLD_TO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
A boolean that flags whether or not the customer is a valid Sold To customer.
Y/N Table Edit
Default Value: N
|
| 18 |
ADD_ACTION |
Character(4) |
VARCHAR2(4) NOT NULL |
Default Action for Adding Person
4=Go to New Worker Record
8=Go to New Contact Record
88=Go to New POI Record
9=Go to New Consumer Record
Default Value: 8
|
| 19 |
VIEW_ACTION |
Character(4) |
VARCHAR2(4) NOT NULL |
Default action for viewing Person if the Person has multiple application roles, such as Contact, Consumer, or Worker.
4=View worker details
8=View contact details
88=View POI details
9=View consumer details
Default Value: 8
|
| 20 |
READONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Read Only
Default Value: N
|
| 21 |
RIM_LVL1_OBJ_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Level 1 Collection Object Type for Blackberry Setup Options
CALL=Call Reports
CONT=Company Notes
CRNT=Call Report Notes
LENT=Lead Notes
LORD=Lead Quotes
LPRD=Lead Products
OORD=Opportunity Quotes
OPNT=Opportunity Notes
OPRD=Opportunity Products
PRNT=Contact Notes
TSNT=Task Notes
|
| 22 |
RIM_DATE_RANGE |
Character(4) |
VARCHAR2(4) NOT NULL |
RIM Date Range Field for the Blackberry Setup Option Page
FORW=Forward
PREV=Prior
|
| 23 |
RIM_SYNC_COUNT |
Number(3,0) |
SMALLINT NOT NULL |
Configurable dynamic refresh count on Blackberry setup page for Leads and Opportunities search record.
|
| 24 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
| 25 |
ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who added the row.
|
| 26 |
ROW_LASTMANT_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time that the row was last updated.
|
| 27 |
ROW_LASTMANT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who last modified the row.
|
| 28 |
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.
|
| 29 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|