RF_SO_LN_AC_LVW

(SQL View)
 Index Back

Service Order Line Info

This table stores all of the line data for a Field Service Service Order FOR language view.

SELECT DISTINCT A.BUSINESS_UNIT , A.SO_ID , A.SO_LINE , A.LANGUAGE_CD ,RTRIM(SUBSTR(TO_CHAR(A.SO_LINE) ,1 ,3)) || ' (' || RTRIM(SUBSTR(B.DESCR80 ,1 ,74)) || ')' FROM PS_RF_SO_LINE_LANG A , PS_RF_SO_LINE D , PS_RF_ACT_CODE_LNG B , PS_SET_CNTRL_REC C WHERE A.BUSINESS_UNIT=D.BUSINESS_UNIT AND D.BUSINESS_UNIT=B.SETID AND A.SO_ID=D.SO_ID AND A.SO_LINE=D.SO_LINE AND D.ACTIVITY_CODE = B.ACTIVITY_CODE AND B.SETID = C.SETID AND A.BUSINESS_UNIT = C.SETCNTRLVALUE AND C.RECNAME = 'RF_ACT_CODE'

  • Related Language Record for RF_SO_LN_ACT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 SO_ID Character(10) VARCHAR2(10) NOT NULL Service Order ID
    3 SO_LINE Number(3,0) SMALLINT NOT NULL Stores the Service Order line number.
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR80 Character(80) VARCHAR2(80) NOT NULL This generic field stores the description and used used on various tables.