CA_CRM_SRV_LANG

(SQL View)
 Index Back

CRM Service ID View

Used by Contracts Accounting Rules

SELECT L.SETID , B.SERVICE_TYPE_CD , L.SERVICE_ID , L.LANGUAGE_CD ,L.DESCR80 FROM PS_RF_SERVICE A , PS_RF_SERVICE_TYPE B , PS_RF_SERVICE_LANG L WHERE A.SETID = B.SETID AND A.SERVICE_TYPE_CD = B.SERVICE_TYPE_CD AND A.SETID = L.SETID AND A.SERVICE_ID = L.SERVICE_ID

  • Related Language Record for CA_CRM_SERV_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    2 SERVICE_TYPE_CD Character(8) VARCHAR2(8) NOT NULL User-definable code to classify the type of service.

    Prompt Table: RF_SERVICE_TYPE

    3 SERVICE_ID Character(20) VARCHAR2(20) NOT NULL Service ID

    Default Value: NEXT

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR80 Character(80) VARCHAR2(80) NOT NULL Description