RA_INST_PROD_VW

(SQL View)
 Index Back

Installed Product

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

SELECT A. SETID , A.INST_PROD_ID , A.BO_ID_CUST , A.ROLE_TYPE_ID_CUST , A.BO_ID_CONTACT , A.ROLE_TYPE_ID_CNTCT , A.PRODUCT_ID , B.DESCR , A.INV_ITEM_ID , A.SERIAL_ID , A.ASSETTAG , H.INST_PROD_STATUS , A.ORDER_DATE , A.SHIP_DATE , A.INSTALLED_DATE , A.SITE_ID , A.PERSON_ID , A.NODE_ID , A.DEPTID , A.PROD_OWNERSHIP , A.LOCN , A.DISTRIBUTOR_ID , A.DISTCONTACT , A.SALES_USER_ID , A.INSTALL_TYPE , A.PO_ID , H.QUANTITY , A.CAPTURE_ID , A.EXTERNAL_ID , A.LINE_NBR , A.BUSINESS_UNIT_OM , A.CONFIG_CODE , A.ENVIRONMENT , A.PLATFORM , A.NETWORK , A.OS , A.UI , A.OS_VERSION , A.TOPLEVELPOSITION , A.LEVEL1 , A.POSITION , A.ORDERBY1 , A.PARENT_INST_PRODID , A.AUTHCODE , A.COUNTRY , A.ADDRESS1 , A.ADDRESS2 , A.ADDRESS3 , A.ADDRESS4 , A.CITY , A.NUM1 , A.NUM2 , A.HOUSE_TYPE , A.ADDR_FIELD1 , A.ADDR_FIELD2 , A.ADDR_FIELD3 , A.COUNTY , A.STATE , A.POSTAL , A.GEO_CODE , A.IN_CITY_LIMIT , A.ADDRESS1_AC , A.ADDRESS2_AC , A.ADDRESS3_AC , A.ADDRESS4_AC , A.CITY_AC , A.REGISTERED_DATE , A.COMMENTS254 FROM PS_RF_INST_PROD A , PS_PROD_ITEM B , PS_SET_CNTRL_REC SC , PS_RF_INST_PROD_ST H WHERE A.SETID = SC.SETCNTRLVALUE AND SC.RECNAME = 'PROD_ITEM' AND SC.SETID = B.SETID AND A.PRODUCT_ID = B.PRODUCT_ID AND H.SETID = A.SETID AND H.INST_PROD_ID = A.INST_PROD_ID

  • 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 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
    4 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer
    5 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
    6 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact
    7 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

    Prompt Table: RF_PROD_PMPT_VW

    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    9 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

    Prompt Table: %EDITTABLE4

    10 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the Serial ID of an item or installed product
    11 ASSETTAG Character(40) VARCHAR2(40) NOT NULL Asset Tag
    12 INST_PROD_STATUS Character(4) VARCHAR2(4) NOT NULL Status of an installed product.
    13 ORDER_DATE Date(10) DATE Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
    14 SHIP_DATE Date(10) DATE Item Shipping Date
    15 INSTALLED_DATE Date(10) DATE Field used for storing Installed Date of Installed product
    16 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

    17 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
    18 NODE_ID Number(8,0) INTEGER NOT NULL Installed Node
    19 DEPTID Character(15) VARCHAR2(15) NOT NULL Department

    Prompt Table: DEPT_TBL

    20 PROD_OWNERSHIP Character(3) VARCHAR2(3) NOT NULL Product Ownership
    L=Leased
    P=Purchased
    R=Rented
    21 LOCN Character(70) VARCHAR2(70) NOT NULL Physical Location
    22 DISTRIBUTOR_ID Character(30) VARCHAR2(30) NOT NULL Purchased From
    23 DISTCONTACT Character(15) VARCHAR2(15) NOT NULL Purchased From Contact
    24 SALES_USER_ID Character(15) VARCHAR2(15) NOT NULL Sales User ID

    Prompt Table: RF_SUSER_VW

    25 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

    26 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
    27 QUANTITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Interface
    28 CAPTURE_ID Character(20) VARCHAR2(20) NOT NULL Field use to store the capture ID in order capture.
    29 EXTERNAL_ID Character(20) VARCHAR2(20) NOT NULL External ID
    30 LINE_NBR Number(5,0) INTEGER NOT NULL This field represents the integer Order Line Number.
    31 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit
    32 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
    33 ENVIRONMENT Character(3) VARCHAR2(3) NOT NULL Environment
    DB2=DB2
    INF=Informix
    MSS=MS SQLServer
    ORA=Oracle
    SQL=SQL Anywhere
    SYB=Sybase
    34 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
    35 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
    36 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
    37 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
    38 OS_VERSION Character(15) VARCHAR2(15) NOT NULL Operating System Version
    39 TOPLEVELPOSITION Character(10) VARCHAR2(10) NOT NULL Top Level Position
    40 LEVEL1 Character(10) VARCHAR2(10) NOT NULL Level
    41 POSITION Character(70) VARCHAR2(70) NOT NULL Position
    42 ORDERBY1 Number(3,0) SMALLINT NOT NULL Order
    43 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: RF_IPRD_CUST_VW

    44 AUTHCODE Character(10) VARCHAR2(10) NOT NULL Authorization Code
    45 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    46 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    47 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    48 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    49 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    50 CITY Character(30) VARCHAR2(30) NOT NULL City
    51 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    52 NUM2 Character(4) VARCHAR2(4) NOT NULL Number 2
    53 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    54 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    55 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    56 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    57 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    58 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: %EDIT_STATE

    59 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    60 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    61 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    Default Value: Y

    62 ADDRESS1_AC Character(55) VARCHAR2(55) NOT NULL ADDRESS1_AC
    63 ADDRESS2_AC Character(55) VARCHAR2(55) NOT NULL ADDRESS2_AC
    64 ADDRESS3_AC Character(55) VARCHAR2(55) NOT NULL ADDRESS3_AC
    65 ADDRESS4_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 4.
    66 CITY_AC Character(30) VARCHAR2(30) NOT NULL CITY_AC
    67 REGISTERED_DATE Date(10) DATE Date of registration for installed products.
    68 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)