RF_INST_MLPB_VW (SQL View)	Index Back
Installed Product Main table to store information for installed products (specific products installed at customer site).

RF_INST_MLPB_VW

(SQL View)

Installed Product

Main table to store information for installed products (specific products installed at customer site).

SELECT inst.setid , inst.inst_prod_id , inst.inst_prod_type , inst.asset_owner , inst.am_asset_type , inst.asset_subtype , inst.bo_id_cust , inst.role_type_id_cust , inst.bo_id_contact , inst.role_type_id_cntct , inst.bo_id_asset_cont , inst.product_group , inst.product_id , inst.inv_item_id , inst.serial_id , inst.assettag , inst.order_date , inst.ship_date , inst.installed_date , inst.site_id , inst.person_id , inst.node_id , inst.deptid , inst.LOCATION , inst.prod_ownership , inst.locn , inst.distributor_id , inst.distcontact , inst.sales_user_id , inst.install_type , inst.po_id , inst.capture_id , inst.external_id , inst.line_nbr , inst.business_unit_om , inst.config_code , inst.environment , inst.platform , inst.network , inst.os , inst.ui , inst.os_version , inst.mfg_id , inst.MODEL , inst.toplevelposition , inst.level1 , inst.POSITION , inst.orderby1 , inst.parent_inst_prodid , inst.toplvl_instprod_id , inst.authcode , inst.country , inst.address1 , inst.address2 , inst.address3 , inst.address4 , inst.city , inst.num1 , inst.num2 , inst.house_type , inst.addr_field1 , inst.addr_field2 , inst.addr_field3 , inst.county , inst.state , inst.postal , inst.geo_code , inst.in_city_limit , inst.address1_ac , inst.address2_ac , inst.address3_ac , inst.address4_ac , inst.city_ac , inst.registered_date , inst.comments254 , inst.rbtacctid , inst.rbtparentacctid , inst.rbtsponsoredacctid , inst.currency_cd , inst.recur_price , inst.price , inst.rbtexternal_id , inst.rbtline_nbr , inst.rf_iprd_crt_src , inst.svc_end_date , inst.schedule , inst.agreement_code , inst.contract_id , inst.contract_line_num , inst.bo_id_ptnr_cmp , inst.bo_id_ptnr_cnt , inst.roletype_ptnr_cmp , inst.roletype_ptnr_cnt , inst.tmp_service , inst.resume_date , inst.rbtnumber , inst.phone_temp , inst.pac_code , inst.pac_date , inst.portin_date , inst.disconnect_date , inst.suspend_date , inst.disc_capture_id , inst.res_capture_id , inst.original_prod_id , inst.market , inst.row_added_dttm , inst.row_added_oprid , inst.row_lastmant_dttm , inst.row_lastmant_oprid , inst.syncid , inst.syncdttm FROM PS_RF_INST_PROD inst , ps_prod_item item WHERE inst.setid = item.setid AND inst.product_id = item.product_id AND item.CFG_KIT_FLAG = 'M'

Audit Record: RF_INST_PROD_AT

# 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

#	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