| # |
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.
Default Value: OPR_DEF_TBL_RB.SETID
Prompt Table:
SP_SETID_NONVW
|
| 2 |
INST_PROD_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
This field is used to represent the installed product ID (key field)
Default Value: NEXT
|
| 3 |
INST_PROD_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
This field is used by the Installed Product component to determine the type of product that is being registered for the Customer, Site, Department or Employee. There are four allowable types: 1) Product, which designates a product assigned to an external customer; 2) Service 3) Asset, which designates a product assigned to an internal employee or department; and 4)Agreement, which designates an Installed Agreement Product (used in Order Capture integration with Agreements).
001=Asset
002=Product
003=Service
004=Agreement
005=Commitment
Default Value: 002
|
| 4 |
ASSET_OWNER |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used by the Installed Product component for product type `Asset� to determine the Owner of the Asset. There are four allowable types: 1) Department, which designates an asset owned by department; 2) Employee, which designates an asset owned by employee, 3) Location, which designates an asset owned by location and 4) None, which designates an asset is created with out any employee/department/location.
D=Department
E=Employee
L=Location
N=None
|
| 5 |
AM_ASSET_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
This field defines the asset types that are available
010=IT Hardware
020=IT Software
030=Plant
040=Equipment
050=Property
060=Fleet
070=Machinery
080=Furniture
090=Facility
100=Intangible
999=Other
|
| 6 |
ASSET_SUBTYPE |
Character(15) |
VARCHAR2(15) NOT NULL |
This field is used in the problem tree in work management.
Prompt Table:
AM_SUBTYPE
|
| 7 |
BO_ID_CUST |
Number(31,0) |
DECIMAL(31) NOT NULL |
This field stores the Business Object ID for the customer.
|
| 8 |
ROLE_TYPE_ID_CUST |
Number(12,0) |
DECIMAL(12) NOT NULL |
Stores ROLE_TYPE_ID for the customer
|
| 9 |
BO_ID_CONTACT |
Number(31,0) |
DECIMAL(31) NOT NULL |
This field indicates the Business Object ID for the contact.
|
| 10 |
ROLE_TYPE_ID_CNTCT |
Number(12,0) |
DECIMAL(12) NOT NULL |
Stores ROLE_TYPE_ID for the contact
|
| 11 |
BO_ID_ASSET_CONT |
Number(31,0) |
DECIMAL(31) NOT NULL |
This field indicates the Business Object ID for the contact.
Prompt Table:
RF_BO_WORKER_VW
|
| 12 |
PRODUCT_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
PRoduct Group
Prompt Table:
RF_PRDGRP_VW
|
| 13 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
Prompt Table:
%EDITTABLE20
|
| 14 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
%EDITTABLE4
|
| 15 |
SERIAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
This field is used to represent the Serial ID of an item or installed product
|
| 16 |
ASSETTAG |
Character(40) |
VARCHAR2(40) NOT NULL |
Asset Tag
|
| 17 |
ORDER_DATE |
Date(10) |
DATE |
Date Initials Issue Description
022701 mv SP2 (F-CJORGENS-3) CSR Desktop
|
| 18 |
SHIP_DATE |
Date(10) |
DATE |
Item Shipping Date
|
| 19 |
INSTALLED_DATE |
Date(10) |
DATE |
Field used for storing Installed Date of Installed product
|
| 20 |
SITE_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Prompt Table:
%EDITTABLE5
|
| 21 |
PERSON_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Person ID
|
| 22 |
NODE_ID |
Number(8,0) |
INTEGER NOT NULL |
Installed Node
|
| 23 |
DEPTID |
Character(15) |
VARCHAR2(15) NOT NULL |
Department
Prompt Table:
RF_DEPT_TBL_VW
|
| 24 |
LOCATION |
Character(15) |
VARCHAR2(15) NOT NULL |
This field stores the Location Code.
Prompt Table:
LOCATION_VW1
|
| 25 |
PROD_OWNERSHIP |
Character(3) |
VARCHAR2(3) NOT NULL |
Product Ownership
L=Leased
P=Purchased
R=Rented
|
| 26 |
LOCN |
Character(70) |
VARCHAR2(70) NOT NULL |
Physical Location
|
| 27 |
DISTRIBUTOR_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Purchased From
|
| 28 |
DISTCONTACT |
Character(15) |
VARCHAR2(15) NOT NULL |
Purchased From Contact
|
| 29 |
SALES_USER_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Sales User ID
Prompt Table:
RF_SUSER_VW
|
| 30 |
INSTALL_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Type of installation that the installed product is used for (beta, demo, etc.).
B=Beta
D=Demo
E=Evaluation
L=Loan
S=Sold
Default Value: S
|
| 31 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
|
| 32 |
CAPTURE_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Field use to store the capture ID in order capture.
|
| 33 |
EXTERNAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
External ID
|
| 34 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
This field represents the integer Order Line Number.
|
| 35 |
BUSINESS_UNIT_OM |
Character(5) |
VARCHAR2(5) NOT NULL |
Order Management Business Unit
|
| 36 |
CONFIG_CODE |
Character(50) |
VARCHAR2(50) NOT NULL |
Product Configurator
|
| 37 |
ENVIRONMENT |
Character(3) |
VARCHAR2(3) NOT NULL |
Environment
DB2=DB2
INF=Informix
MSS=MS SQLServer
ORA=Oracle
SQL=SQL Anywhere
SYB=Sybase
|
| 38 |
PLATFORM |
Character(3) |
VARCHAR2(3) NOT NULL |
Platform
390=IBM S/390
ACN=Acorn
AG4=Apple G4 Server
AIB=Apple iBook
AS4=AS400
DPD=Digital PDP
DVX=Digital VAX
HP3=Hewlett-Packard 3000
HP9=Hewlett-Packard 9000
MAC=Macintosh
PEN=IBM Pentium
SNF=Sun Fire
SNX=Sun Enterprise
|
| 39 |
NETWORK |
Character(3) |
VARCHAR2(3) NOT NULL |
Network
BVN=Banyan Vines
N21=Netware 2.1
N31=Netware 3.1
OTC=Other TCP/IP
TCP=Winsock TCP/IP
|
| 40 |
OS |
Character(3) |
VARCHAR2(3) NOT NULL |
Operating System
390=S/390
DOS=DOS
DUX=Digital Unix
HPU=HP-UX
LNX=Linux
OS2=OS2
SUN=Solaris
VMS=VMS
W2K=Windows 2000
W31=Windows 3.1
W95=Windows 95
W98=Windows 98
WME=Windows ME
WNT=Windows NT
WXP=Windows XP
|
| 41 |
UI |
Character(3) |
VARCHAR2(3) NOT NULL |
User Interface
A08=Apple OS 8
AOX=Apple OS X
MIF=Motif
OS2=OS/2 PM
PM=Presentation Manager
W2K=Windows 2000
W31=Windows 3.1
W95=Windows 95
W98=Windows 98
WNT=Windows NT
|
| 42 |
OS_VERSION |
Character(15) |
VARCHAR2(15) NOT NULL |
Operating System Version
|
| 43 |
MFG_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Key field to represent Manufacturer Identification number
Prompt Table:
MANUFACTURER
|
| 44 |
MODEL |
Character(30) |
VARCHAR2(30) NOT NULL |
Model
|
| 45 |
TOPLEVELPOSITION |
Character(10) |
VARCHAR2(10) NOT NULL |
Top Level Position
|
| 46 |
LEVEL1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Level
|
| 47 |
POSITION |
Character(70) |
VARCHAR2(70) NOT NULL |
Position
|
| 48 |
ORDERBY1 |
Number(3,0) |
SMALLINT NOT NULL |
Order
|
| 49 |
PARENT_INST_PRODID |
Character(20) |
VARCHAR2(20) NOT NULL |
This field is used to store the installed product ID of the parent installed product
Prompt Table:
%EDITTABLE30
|
| 50 |
TOPLVL_INSTPROD_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Top Level Installed Product Id
|
| 51 |
AUTHCODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Authorization Code
|
| 52 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 53 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 54 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 55 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 56 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 57 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 58 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 59 |
NUM2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Number 2
|
| 60 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat Reference
WW=House Trailer Reference
|
| 61 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 62 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 63 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 64 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 65 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
%EDIT_STATE
|
| 66 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 67 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 68 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit
Default Value: Y
|
| 69 |
ADDRESS1_AC |
Character(55) |
VARCHAR2(55) NOT NULL |
ADDRESS1_AC
|
| 70 |
ADDRESS2_AC |
Character(55) |
VARCHAR2(55) NOT NULL |
ADDRESS2_AC
|
| 71 |
ADDRESS3_AC |
Character(55) |
VARCHAR2(55) NOT NULL |
ADDRESS3_AC
|
| 72 |
ADDRESS4_AC |
Character(55) |
VARCHAR2(55) NOT NULL |
Alternate Character Address 4.
|
| 73 |
CITY_AC |
Character(30) |
VARCHAR2(30) NOT NULL |
CITY_AC
|
| 74 |
REGISTERED_DATE |
Date(10) |
DATE |
Date of registration for installed products.
|
| 75 |
COMMENTS254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Shorter comment field (i.e. shorter than a long character) for situations where the longer field size is not necessary (especially if there's already another Long Char field in the record)
|
| 76 |
RBTACCTID |
Character(15) |
VARCHAR2(15) NOT NULL |
Unique service account indentifier
|
| 77 |
RBTPARENTACCTID |
Character(15) |
VARCHAR2(15) NOT NULL |
Parent Account Id
|
| 78 |
RBTSPONSOREDACCTID |
Character(15) |
VARCHAR2(15) NOT NULL |
Sponsored Account Id
|
| 79 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
This field stores the Currency Code value.
|
| 80 |
RECUR_PRICE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Recurring Price
|
| 81 |
PRICE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
This is price per unit for calculating the service charge.
|
| 82 |
RBTEXTERNAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Tis field has been used for COM service management. It captures the external id which has been used in upgrade purpose.
|
| 83 |
RBTLINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
rbtline_nbr
|
| 84 |
RF_IPRD_CRT_SRC |
Character(3) |
VARCHAR2(3) NOT NULL |
This field contains the installed product creation source.
001=Manage Material
002=Online Transaction
003=Order Capture Order
004=Service Management
005=Product Registration
006=Asset Management
007=External Service Operation
Default Value: 002
|
| 85 |
SVC_END_DATE |
Date(10) |
DATE |
This field is used by the Installed Product component to designate the date that the Service was terminated or suspended.
|
| 86 |
SCHEDULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Schedule for integration with Contracts.
Prompt Table:
RF_SCHED_TBL_VW
|
| 87 |
AGREEMENT_CODE |
Character(30) |
VARCHAR2(30) NOT NULL |
This field represents the agreement code (name) for an agreement
|
| 88 |
CONTRACT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
This field is used to determine the contract ID of the inventory item.
|
| 89 |
CONTRACT_LINE_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Contract Line Num
|
| 90 |
BO_ID_PTNR_CMP |
Signed Number(32,0) |
DECIMAL(31) NOT NULL |
Partner Company Business Object ID.
Prompt Table:
RF_PTNR_SRCH_VW
|
| 91 |
BO_ID_PTNR_CNT |
Signed Number(32,0) |
DECIMAL(31) NOT NULL |
Partner Contact Business Object ID.
Prompt Table:
RF_PTNR_REPS_VW
|
| 92 |
ROLETYPE_PTNR_CMP |
Number(12,0) |
DECIMAL(12) NOT NULL |
Role Type Partner Company
|
| 93 |
ROLETYPE_PTNR_CNT |
Number(12,0) |
DECIMAL(12) NOT NULL |
Role Type Partner Contact
|
| 94 |
TMP_SERVICE |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates if the Service is temporary
Default Value: N
|
| 95 |
RESUME_DATE |
Date(10) |
DATE |
Temporary Suspension Resumption date
|
| 96 |
RBTNUMBER |
Character(15) |
VARCHAR2(15) NOT NULL |
Number For Telco
|
| 97 |
PHONE_TEMP |
Character(24) |
VARCHAR2(24) NOT NULL |
Temporary phone number used when transferring service
|
| 98 |
PAC_CODE |
Character(9) |
VARCHAR2(9) NOT NULL |
PAC Code issues by wireless carriers for transferring phone numbers.
|
| 99 |
PAC_DATE |
Date(10) |
DATE |
PAC Date for wireless carriers for transferring phone numbers.
|
| 100 |
PORTIN_DATE |
Date(10) |
DATE |
PortIn Date for wireless carriers for transferring phone numbers.
|
| 101 |
DISCONNECT_DATE |
Date(10) |
DATE |
Disconnect Date
|
| 102 |
SUSPEND_DATE |
Date(10) |
DATE |
Suspend Date
|
| 103 |
DISC_CAPTURE_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Field used to save the Capture ID for the Disconnect for a Temporary Service
|
| 104 |
RES_CAPTURE_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Field used to store the Resume Capture ID for Suspend/Resume
|
| 105 |
ORIGINAL_PROD_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Original product id
|
| 106 |
MARKET |
Character(3) |
VARCHAR2(3) NOT NULL |
Market
|
| 107 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
| 108 |
ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who added the row.
|
| 109 |
ROW_LASTMANT_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time that the row was last updated.
|
| 110 |
ROW_LASTMANT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who last modified the row.
|
| 111 |
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.
|
| 112 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|