RFM_CUSTIPRD_VW

(SQL View)
 Index Back

Cust. Inst. Product FS Mobile

Installed Product by Product by Customer (Field Service Mobile)

SELECT A.BO_ID_CUST , A.PRODUCT_ID , A.SETID , A.INST_PROD_ID , A.SERIAL_ID , A.SYNCID , A.SYNCDTTM FROM PS_RF_INST_PROD A WHERE A.BO_ID_CUST <> 0

  • Parent record: RFM_CUST_PRD_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
    2 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    3 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
    4 INST_PROD_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the installed product ID (key field)
    5 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the Serial ID of an item or installed product
    6 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.
    7 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time