| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 AUDIT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
The OPRID of the user who made the changes audited on an audit record.
|
| 2 |
AUDIT_STAMP |
DateTime(26) |
TIMESTAMP |
Date and Time Stamp
|
| 3 |
AUDIT_ACTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
|
| 4 |
AUDIT_RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Name of the record definition audited.
AUDIT_RECNAME is used in User-Defined Audit Record Definitions.
|
| 5 |
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
|
| 6 |
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
|
| 7 |
ASSET_SUBTYPE |
Character(15) |
VARCHAR2(15) NOT NULL |
This field is used in the problem tree in work management.
Prompt Table:
AM_SUBTYPE
|
| 8 |
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
|
| 9 |
LOCATION |
Character(15) |
VARCHAR2(15) NOT NULL |
This field stores the Location Code.
Prompt Table:
LOCATION_VW1
|
| 10 |
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
|
| 11 |
MFG_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Key field to represent Manufacturer Identification number
Prompt Table:
MANUFACTURER
|
| 12 |
MODEL |
Character(30) |
VARCHAR2(30) NOT NULL |
Model
|
| 13 |
TOPLVL_INSTPROD_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Top Level Installed Product Id
|
| 14 |
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
|
| 15 |
INSPRD_PMSO_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Preventive Maintenance SO Status
CAN=Canceled
CMP=Completed
CRT=Created
INP=In Progress
PND=Pending
|
| 16 |
SERVICE_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Service ID
|
| 17 |
SETID_SERVICE |
Character(5) |
VARCHAR2(5) NOT NULL |
This field is used to represent the SETID of the Service
|
| 18 |
SO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Service Order ID
|
| 19 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_RFPMNONVW
|
| 20 |
SO_DATE |
Date(10) |
DATE |
Stores the Service Order creation date.
|
| 21 |
CREATE_DATE |
Date(10) |
DATE |
Creation Date
|
| 22 |
AGREEMENT_LINE |
Character(10) |
VARCHAR2(10) NOT NULL |
This field records the value for the agreement line number
Prompt Table:
RF_INSP_AGR2_VW
|
| 23 |
AGR_RENEWAL_NUM |
Number(4,0) |
SMALLINT NOT NULL |
This field represents the agreement renewal number (agreements begin at a value of one and the number is incremented with every renewal)
Prompt Table:
RF_INSP_AGR1_VW
|
| 24 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 25 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
|
| 26 |
INST_PROD_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
This field is used to represent the installed product ID (key field)
|
| 27 |
PRODUCT_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
PRoduct Group
|
| 28 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
Prompt Table:
RF_PROD_ITEM_VW
|
| 29 |
SERIAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
This field is used to represent the Serial ID of an item or installed product
|
| 30 |
ASSETTAG |
Character(40) |
VARCHAR2(40) NOT NULL |
Asset Tag
|
| 31 |
CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer ID
|
| 32 |
BO_ID_CUST |
Number(31,0) |
DECIMAL(31) NOT NULL |
This field stores the Business Object ID for the customer.
|
| 33 |
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.
|
| 34 |
PERSON_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Person ID
|
| 35 |
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
|
| 36 |
INST_PROD_STATUS |
Character(4) |
VARCHAR2(4) NOT NULL |
Status of an installed product.
|
| 37 |
QUANTITY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Interface
|
| 38 |
ROLE_TYPE_ID_CUST |
Number(12,0) |
DECIMAL(12) NOT NULL |
Stores ROLE_TYPE_ID for the customer
|
| 39 |
BO_ID_CONTACT |
Number(31,0) |
DECIMAL(31) NOT NULL |
This field indicates the Business Object ID for the contact.
|
| 40 |
ROLE_TYPE_ID_CNTCT |
Number(12,0) |
DECIMAL(12) NOT NULL |
Stores ROLE_TYPE_ID for the contact
|
| 41 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 42 |
ORDER_DATE |
Date(10) |
DATE |
Date Initials Issue Description
022701 mv SP2 (F-CJORGENS-3) CSR Desktop
|
| 43 |
SHIP_DATE |
Date(10) |
DATE |
Item Shipping Date
|
| 44 |
INSTALLED_DATE |
Date(10) |
DATE |
Field used for storing Installed Date of Installed product
|
| 45 |
DEPTID |
Character(15) |
VARCHAR2(15) NOT NULL |
Department
|
| 46 |
NODE_ID |
Number(8,0) |
INTEGER NOT NULL |
Installed Node
|
| 47 |
PROD_OWNERSHIP |
Character(3) |
VARCHAR2(3) NOT NULL |
Product Ownership
L=Leased
P=Purchased
R=Rented
|
| 48 |
LOCN |
Character(70) |
VARCHAR2(70) NOT NULL |
Physical Location
|
| 49 |
DISTRIBUTOR_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Purchased From
|
| 50 |
DISTCONTACT |
Character(15) |
VARCHAR2(15) NOT NULL |
Purchased From Contact
|
| 51 |
SALES_USER_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Sales User ID
|
| 52 |
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
|
| 53 |
BO_ID |
Signed Number(32,0) |
DECIMAL(31) NOT NULL |
Business Object ID
|
| 54 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
|
| 55 |
CAPTURE_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Field use to store the capture ID in order capture.
|
| 56 |
EXTERNAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
External ID
|
| 57 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
This field represents the integer Order Line Number.
|
| 58 |
BUSINESS_UNIT_OM |
Character(5) |
VARCHAR2(5) NOT NULL |
Order Management Business Unit
|
| 59 |
CONFIG_CODE |
Character(50) |
VARCHAR2(50) NOT NULL |
Product Configurator
|
| 60 |
ENVIRONMENT |
Character(3) |
VARCHAR2(3) NOT NULL |
Environment
DB2=DB2
INF=Informix
MSS=MS SQLServer
ORA=Oracle
SQL=SQL Anywhere
SYB=Sybase
|
| 61 |
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
|
| 62 |
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
|
| 63 |
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
|
| 64 |
OS_VERSION |
Character(15) |
VARCHAR2(15) NOT NULL |
Operating System Version
|
| 65 |
TOPLEVELPOSITION |
Character(10) |
VARCHAR2(10) NOT NULL |
Top Level Position
|
| 66 |
LEVEL1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Level
|
| 67 |
POSITION |
Character(70) |
VARCHAR2(70) NOT NULL |
Position
|
| 68 |
ORDERBY1 |
Number(3,0) |
SMALLINT NOT NULL |
Order
|
| 69 |
PARENT_INST_PRODID |
Character(20) |
VARCHAR2(20) NOT NULL |
This field is used to store the installed product ID of the parent installed product
|
| 70 |
AUTHCODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Authorization Code
|
| 71 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 72 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 73 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 74 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 75 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 76 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 77 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 78 |
NUM2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Number 2
|
| 79 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat Reference
WW=House Trailer Reference
|
| 80 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 81 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 82 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 83 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 84 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
%EDIT_STATE
|
| 85 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 86 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 87 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit
Default Value: Y
|
| 88 |
ADDRESS1_AC |
Character(55) |
VARCHAR2(55) NOT NULL |
ADDRESS1_AC
|
| 89 |
ADDRESS2_AC |
Character(55) |
VARCHAR2(55) NOT NULL |
ADDRESS2_AC
|
| 90 |
ADDRESS3_AC |
Character(55) |
VARCHAR2(55) NOT NULL |
ADDRESS3_AC
|
| 91 |
ADDRESS4_AC |
Character(55) |
VARCHAR2(55) NOT NULL |
Alternate Character Address 4.
|
| 92 |
CITY_AC |
Character(30) |
VARCHAR2(30) NOT NULL |
CITY_AC
|
| 93 |
REGISTERED_DATE |
Date(10) |
DATE |
Date of registration for installed products.
|
| 94 |
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)
|
| 95 |
RBTACCTID |
Character(15) |
VARCHAR2(15) NOT NULL |
Unique service account indentifier
|
| 96 |
RBTPARENTACCTID |
Character(15) |
VARCHAR2(15) NOT NULL |
Parent Account Id
|
| 97 |
RBTSPONSOREDACCTID |
Character(15) |
VARCHAR2(15) NOT NULL |
Sponsored Account Id
|
| 98 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
This field stores the Currency Code value.
|
| 99 |
RECUR_PRICE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Recurring Price
|
| 100 |
PRICE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
This is price per unit for calculating the service charge.
|
| 101 |
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.
|
| 102 |
RBTLINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
rbtline_nbr
|
| 103 |
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.
|
| 104 |
SCHEDULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Schedule for integration with Contracts.
Prompt Table:
RO_SCHEDULE_VW
|
| 105 |
AGREEMENT_CODE |
Character(30) |
VARCHAR2(30) NOT NULL |
This field represents the agreement code (name) for an agreement
|
| 106 |
CONTRACT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
This field is used to determine the contract ID of the inventory item.
|
| 107 |
CONTRACT_LINE_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Contract Line Num
|
| 108 |
BO_ID_PTNR_CMP |
Signed Number(32,0) |
DECIMAL(31) NOT NULL |
Partner Company Business Object ID.
|
| 109 |
BO_ID_PTNR_CNT |
Signed Number(32,0) |
DECIMAL(31) NOT NULL |
Partner Contact Business Object ID.
|
| 110 |
ROLETYPE_PTNR_CMP |
Number(12,0) |
DECIMAL(12) NOT NULL |
Role Type Partner Company
|
| 111 |
ROLETYPE_PTNR_CNT |
Number(12,0) |
DECIMAL(12) NOT NULL |
Role Type Partner Contact
|
| 112 |
TMP_SERVICE |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates if the Service is temporary
|
| 113 |
RESUME_DATE |
Date(10) |
DATE |
Temporary Suspension Resumption date
|
| 114 |
RBTNUMBER |
Character(15) |
VARCHAR2(15) NOT NULL |
Number For Telco
|
| 115 |
PHONE_TEMP |
Character(24) |
VARCHAR2(24) NOT NULL |
Temporary phone number used when transferring service
|
| 116 |
PAC_CODE |
Character(9) |
VARCHAR2(9) NOT NULL |
PAC Code issues by wireless carriers for transferring phone numbers.
|
| 117 |
PAC_DATE |
Date(10) |
DATE |
PAC Date for wireless carriers for transferring phone numbers.
|
| 118 |
PORTIN_DATE |
Date(10) |
DATE |
PortIn Date for wireless carriers for transferring phone numbers.
|
| 119 |
DISCONNECT_DATE |
Date(10) |
DATE |
Disconnect Date
|
| 120 |
SUSPEND_DATE |
Date(10) |
DATE |
Suspend Date
|
| 121 |
DISC_CAPTURE_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Field used to save the Capture ID for the Disconnect for a Temporary Service
|
| 122 |
RES_CAPTURE_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Field used to store the Resume Capture ID for Suspend/Resume
|
| 123 |
ORIGINAL_PROD_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Original product id
|