FO_RSRCH_SOLINE

(SQL View)
Index Back

SELECT A.BUSINESS_UNIT , A.SO_ID , A.SO_LINE , B.OWNERSHIP_ID , A.CUST_ID , A.START_DT , A.SALARY_RANGE_MIN , A.SALARY_RANGE_MAX FROM %Table(RS_SO_LINE) A , %Table(RS_SO_HDR) B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SO_ID = B.SO_ID

# 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 OWNERSHIP_ID Character(30) VARCHAR2(30) NOT NULL Owning Organization
5 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.
6 START_DT Date(10) DATE Start Date
7 SALARY_RANGE_MIN Number(11,2) DECIMAL(10,2) NOT NULL Salary Range
8 SALARY_RANGE_MAX Number(11,2) DECIMAL(10,2) NOT NULL Maximum Salary Range