Date Initials Issue Description 111201 dms 9646001 Add eff_status

ORD_SLD_LINE_VW

(SQL View)

SELECT L.business_unit , L.order_no , L.order_int_line_no , L.prod_id_entered , L.qty_ordered , L.unit_of_measure , H.sold_to_cust_id , L.price , L.currency_cd , L.ord_line_tag , c.eff_status , L.product_id , L.product_id , L.prod_id_src , L.config_code FROM ps_ord_line L , PS_ORD_HEADER H , PS_PROD_ITEM C WHERE L.ord_line_status IN ('O','C','P') AND C.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC S WHERE S.SETCNTRLVALUE = L.BUSINESS_UNIT AND S.RECNAME = 'PROD_ITEM') AND L.PRODUCT_ID = C.PRODUCT_ID AND H.BUSINESS_UNIT = L.BUSINESS_UNIT AND H.ORDER_NO = L.ORDER_NO

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop

3 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line

4 PROD_ID_ENTERED Character(20) VARCHAR2(20) NOT NULL Product ID Entered

5 QTY_ORDERED Signed Number(16,4) DECIMAL(14,4) NOT NULL Order Qty

6 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

7 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer

8 PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL This is price per unit for calculating the service charge.

9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

10 ORD_LINE_TAG Number(5,0) INTEGER NOT NULL Order Line tag line nbr

11 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

12 PRODUCT_ID_TEMP Character(18) VARCHAR2(18) NOT NULL Product Id Temp

13 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

14 PROD_ID_SRC Character(1) VARCHAR2(1) NOT NULL Product Source
C=Customer
P=UPC
S=System
U=Universal

15 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	ORDER_NO	Character(10)	VARCHAR2(10) NOT NULL	Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
3	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
4	PROD_ID_ENTERED	Character(20)	VARCHAR2(20) NOT NULL	Product ID Entered
5	QTY_ORDERED	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Order Qty
6	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
7	SOLD_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Sold To Customer
8	PRICE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	This is price per unit for calculating the service charge.
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
10	ORD_LINE_TAG	Number(5,0)	INTEGER NOT NULL	Order Line tag line nbr
11	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
12	PRODUCT_ID_TEMP	Character(18)	VARCHAR2(18) NOT NULL	Product Id Temp
13	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
14	PROD_ID_SRC	Character(1)	VARCHAR2(1) NOT NULL	Product Source C=Customer P=UPC S=System U=Universal
15	CONFIG_CODE	Character(50)	VARCHAR2(50) NOT NULL	Product Configurator