RB_BUS_CMCNT_VW

(SQL View)
 Index Back

Status for a Business Object

This view returns the status of the company for Company SES.

SELECT A.BO_ID , A.CUST_ID , B.XLATLONGNAME FROM PS_BC A , PSXLATITEM B WHERE B.FIELDNAME='CUST_STATUS' AND B.FIELDVALUE=A.CUST_STATUS

  • Related Language Record: RB_BUS_CMCT_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
    2 CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer ID
    3 STATUS_DESC Character(20) VARCHAR2(20) NOT NULL Status description. Used in Call Center actions framework for displaying the related object status.