CA_CRM_SERV_VW

(SQL View)
 Index Back

CRM Service ID View

Used by Contracts Accounting Rules

SELECT A.SETID , B.SERVICE_TYPE_CD , A.SERVICE_ID ,A.DESCR80 ,A.PRVNT_MNTC_FLAG ,A.WARRANTY_FLAG ,A.AGREEMENT_FLAG ,A.BILLABLE_FLAG ,A.OFF_HOURS_FLAG ,A.ACTIVE_STATUS FROM PS_RF_SERVICE A , PS_RF_SERVICE_TYPE B WHERE A.SETID = B.SETID AND A.SERVICE_TYPE_CD = B.SERVICE_TYPE_CD

  • Related Language Record: CA_CRM_SRV_LANG

    • # 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

    Prompt Table: RF_SERVICE

    4 DESCR80 Character(80) VARCHAR2(80) NOT NULL Description
    5 PRVNT_MNTC_FLAG Character(1) VARCHAR2(1) NOT NULL This field is used to show whether Preventive Maintenance is required or not.
    N=No
    Y=Yes

    Default Value: N

    6 WARRANTY_FLAG Character(1) VARCHAR2(1) NOT NULL Indicates that the agreement is classified as a warranty.
    N=No
    Y=Yes

    Default Value: N

    7 AGREEMENT_FLAG Character(1) VARCHAR2(1) NOT NULL Indicates whether or not the service can be used on an agreement.
    N=No
    Y=Yes

    Default Value: Y

    8 BILLABLE_FLAG Character(1) VARCHAR2(1) NOT NULL This is used to determine of the item under consideration is billable or not.
    N=No
    Y=Yes

    Default Value: N

    9 OFF_HOURS_FLAG Character(1) VARCHAR2(1) NOT NULL Off Hours
    N=No
    Y=Yes

    Default Value: N

    10 ACTIVE_STATUS Character(1) VARCHAR2(1) NOT NULL Transfer Template Status
    A=Active
    I=Inactive

    Default Value: A