| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PERSON_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Person ID
|
| 2 |
RSFM_SV_PREF_FGRPH |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales Viewer Preference - Forecast Graph
Y/N Table Edit
|
| 3 |
RSFM_SV_PREF_LEADS |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales Viewer Preference
Y/N Table Edit
|
| 4 |
RSFM_SV_COUNT_LEAD |
Number(5,0) |
INTEGER NOT NULL |
Number of Leads to Display, used by Mobile Sales application.
|
| 5 |
RSFM_SV_SORT_LEAD |
Character(4) |
VARCHAR2(4) NOT NULL |
Lead sort preference
ADDT=Date/Time Created
CONT=Contact
LEAD=Lead Name
RATI=Lead Rating
REV=Estimated Revenue
STAT=Lead Status
UPDT=Date/Time Modified
|
| 6 |
SORT_ORDER_LEAD |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort Order
A=Ascending
D=Descending
|
| 7 |
RSFM_SV_PREF_OPPY |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales Viewer Preference
Y/N Table Edit
|
| 8 |
RSFM_SV_COUNT_OPPY |
Number(5,0) |
INTEGER NOT NULL |
Number of Opportunities to Display, used by Mobile Sales application.
|
| 9 |
RSFM_SV_SORT_OPPY |
Character(4) |
VARCHAR2(4) NOT NULL |
Lead sort preference
ADDT=Date/Time Created
DATE=Est. Close Date
NAME=Contact
OPPY=Opportunity Name
REV=Estimated Revenue
STAT=Oppy. Status
UPDT=Date/Time Modified
|
| 10 |
SORT_ORDER_OPPY |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort Order
A=Ascending
D=Descending
|
| 11 |
RSFM_SV_PREF_FCAST |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales Viewer Preference - Forecast
Y/N Table Edit
|
| 12 |
RSFM_SV_COUNT_FCST |
Number(5,0) |
INTEGER NOT NULL |
Number of Forecast to Display, used by Mobile Sales application.
|
| 13 |
RSFM_SV_SORT_FCAST |
Character(4) |
VARCHAR2(4) NOT NULL |
Lead sort preference
FCST=Forecast
TFRM=Time Frame
TOTL=Total
|
| 14 |
SORT_ORDER_FCAST |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort Order
A=Ascending
D=Descending
|
| 15 |
RSFM_SV_PREF_TASKS |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales Viewer Preference - Tasks
Y/N Table Edit
|
| 16 |
RSFM_SV_COUNT_TASK |
Number(5,0) |
INTEGER NOT NULL |
Number of Tasks to Display, used by Mobile Sales application.
|
| 17 |
RSFM_SV_SORT_TASK |
Character(4) |
VARCHAR2(4) NOT NULL |
Task sort preference
DATE=Start Date
OWNR=Owner
STAT=Task Status
TIME=Start Time
TTYP=Task Type
|
| 18 |
SORT_ORDER_TASK |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort Order
A=Ascending
D=Descending
|
| 19 |
RSFM_FCAST_GRAPH |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Graph with Table, used by Mobile Sales application.
Y/N Table Edit
Default Value: N
|
| 20 |
FORECAST_SORT |
Character(4) |
VARCHAR2(4) NOT NULL |
For selection of data summing display. First variable to sort by.
ADJ=Adjusted By
CONF=Confidence %
CURR=Local Currency
CUST=Customer
DIM1=Revenue Dimension 1
DIM2=Revenue Dimension 2
EDT=Estimated Close Date
FTYP=Forecast Type
IND=Industry
OPP=Opportunity
OSTS=Opportunity Status
PGRP=Product Group
PRD=Product
RCRR=Recurring Revenue
REGN=Region
REVT=Revenue Type
ROLE=Customer Role Type
SMOD=Sales Model
SSTG=Sales Stage
STG=Stage % Close
TERR=Territory
TREE=Tree Name
TTER=Territory in Tree
UNIT=Business Unit
USER=Sales User
|
| 21 |
FORECAST_SORT2 |
Character(4) |
VARCHAR2(4) NOT NULL |
For selection of data summing display. Second variable to sort by.
ADJ=Adjusted By
CONF=Confidence %
CURR=Local Currency
CUST=Customer
DIM1=Revenue Dimension 1
DIM2=Revenue Dimension 2
EDT=Estimated Close Date
FTYP=Forecast Type
IND=Industry
OPP=Opportunity
OSTS=Opportunity Status
PGRP=Product Group
PRD=Product
RCRR=Recurring Revenue
REGN=Region
REVT=Revenue Type
SMOD=Sales Model
SSTG=Sales Stage
STG=Stage % Close
TERR=Territory
TREE=Tree Name
TTER=Territory in Tree
UNIT=Business Unit
USER=Sales User
|
| 22 |
RSFM_SV_PREF_QUOTE |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales Viewer Preference
Y/N Table Edit
|
| 23 |
RSFM_SV_COUNT_QUOT |
Number(5,0) |
INTEGER NOT NULL |
Number of Quotes to Display, used by Mobile Sales application.
|
| 24 |
RSFM_SV_SORT_QUOTE |
Character(4) |
VARCHAR2(4) NOT NULL |
Task sort preference
CONT=Contact
DATE=Capture Date
NAME=Customer
ORID=Order Id
STAT=Status
TYPE=Type
|
| 25 |
SORT_ORDER_QUOTE |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort Order
A=Ascending
D=Descending
|
| 26 |
RSFM_SV_PREF_ACCTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales Viewer Preference - Tasks
Y/N Table Edit
|
| 27 |
RSFM_SV_COUNT_ACCT |
Number(5,0) |
INTEGER NOT NULL |
Number of Accounts to Display, used by Mobile Sales application.
|
| 28 |
RSFM_SV_SORT_ACCT |
Character(4) |
VARCHAR2(4) NOT NULL |
Task sort preference
ACTN=Account Name
ACTO=Account Owner
PARN=Parent Name
|
| 29 |
SORT_ORDER_ACCT |
Character(1) |
VARCHAR2(1) NOT NULL |
Account Sort Order
A=Ascending
D=Descending
|
| 30 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
| 31 |
ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who added the row.
|
| 32 |
ROW_LASTMANT_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time that the row was last updated.
|
| 33 |
ROW_LASTMANT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who last modified the row.
|
| 34 |
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.
|
| 35 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|