RS_SO_LINE_DTS (SQL Table)	Index Back
SO Line Multiple dates For some resource requests, there are multiple date ranges. This table contains those mulitple date ranges.

RS_SO_LINE_DTS

(SQL Table)

SO Line Multiple dates

For some resource requests, there are multiple date ranges. This table contains those mulitple date ranges.

Parent record: RS_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(15) VARCHAR2(15) NOT NULL Service Order ID

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

4 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
Default Value: 1

5 START_DT Date(10) DATE Start Date

6 END_DT Date(10) DATE End Date

7 SCHEDULED_HRS Signed Number(10,4) DECIMAL(8,4) NOT NULL Scheduled Hours

#	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(15)	VARCHAR2(15) NOT NULL	Service Order ID
3	SO_LINE	Number(3,0)	SMALLINT NOT NULL	Line Number
4	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number Default Value: 1
5	START_DT	Date(10)	DATE	Start Date
6	END_DT	Date(10)	DATE	End Date
7	SCHEDULED_HRS	Signed Number(10,4)	DECIMAL(8,4) NOT NULL	Scheduled Hours