RF_SOLN_ACT_VW

(SQL View)
Index Back

Service Order Activity View

This is a view of Activities for a Service Order.

SELECT BUSINESS_UNIT , SO_ID , SO_LINE , ACTIVITY_CODE FROM PS_RF_SO_LINE

# 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 ACTIVITY_CODE Character(8) VARCHAR2(8) NOT NULL Activity Code which identifies the specific Activities which will be performed as part of Service Orders.

Prompt Table: RF_SO_LINE_VW3