RS_SRCH_SOHD_VW (SQL View)	Index Back
Service Order Header

RS_SRCH_SOHD_VW

(SQL View)

Service Order Header

SELECT A.BUSINESS_UNIT , A.SO_ID , A.SO_DATE , A.SO_SOURCE , A.CUST_SETID , A.CUST_ID , A.CONTRACT_NUM , A.CONTR_LN_NBR , A.ALLOW_NONBILL_FLG , A.BID_FLAG , A.ENTERED_BY , A.ASSIGNED_TO , A.PROJECT_ID , A.DESCR60 , A.LASTUPDOPRID , A.LASTUPDDTTM FROM %Table(RS_SO_HDR) A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_PC_NONVW

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

3 SO_DATE Date(10) DATE Service Order Date

4 SO_SOURCE Character(1) VARCHAR2(1) NOT NULL Service Order Source
C=Contract
P=Project
S=SRS
T=Template

5 CUST_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID

6 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Prompt Table: RS_CUSTOMER_VW

7 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
Default Value: NEXT

8 CONTR_LN_NBR Number(3,0) SMALLINT NOT NULL Contract Line Number

9 ALLOW_NONBILL_FLG Character(1) VARCHAR2(1) NOT NULL Nonbillable Assignment Allowed
Y/N Table Edit
Default Value: N

10 BID_FLAG Character(1) VARCHAR2(1) NOT NULL Worker Bids Accepted
Y/N Table Edit
Default Value: N

11 ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered by
Default Value: OPR_DEF_TBL_FS.OPRID
Prompt Table: OPRID_VW

12 ASSIGNED_TO Character(30) VARCHAR2(30) NOT NULL Assigned To
Prompt Table: RS_OPR_NAME_VW

13 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

14 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description

15 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

16 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	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_PC_NONVW
2	SO_ID	Character(15)	VARCHAR2(15) NOT NULL	Service Order ID
3	SO_DATE	Date(10)	DATE	Service Order Date
4	SO_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Service Order Source C=Contract P=Project S=SRS T=Template
5	CUST_SETID	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID
6	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. Prompt Table: RS_CUSTOMER_VW
7	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Default Value: NEXT
8	CONTR_LN_NBR	Number(3,0)	SMALLINT NOT NULL	Contract Line Number
9	ALLOW_NONBILL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Nonbillable Assignment Allowed Y/N Table Edit Default Value: N
10	BID_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Worker Bids Accepted Y/N Table Edit Default Value: N
11	ENTERED_BY	Character(30)	VARCHAR2(30) NOT NULL	Entered by Default Value: OPR_DEF_TBL_FS.OPRID Prompt Table: OPRID_VW
12	ASSIGNED_TO	Character(30)	VARCHAR2(30) NOT NULL	Assigned To Prompt Table: RS_OPR_NAME_VW
13	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
14	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description
15	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
16	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.