RS_XS_SO_LINES

(SQL View)

%Sql(RS_XS_SO_LINES_SEL,'RS')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SOID Character(29) VARCHAR2(29) NOT NULL Service Order Line Key

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID

4 SO_LINE Number(3,0) SMALLINT NOT NULL Line Number

5 ASSIGNED_TO Character(30) VARCHAR2(30) NOT NULL Assigned To

6 FO_JOBTITLE Character(9) VARCHAR2(9) NOT NULL Job Title Code

7 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SOID	Character(29)	VARCHAR2(29) NOT NULL	Service Order Line Key
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	SO_ID	Character(15)	VARCHAR2(15) NOT NULL	Service Order ID
4	SO_LINE	Number(3,0)	SMALLINT NOT NULL	Line Number
5	ASSIGNED_TO	Character(30)	VARCHAR2(30) NOT NULL	Assigned To
6	FO_JOBTITLE	Character(9)	VARCHAR2(9) NOT NULL	Job Title Code
7	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.