ORD_SLD_PROD_VW (SQL View)	Index Back
Order lines to copy Date Initials Issue Description 011503 dms F-CJORGENS-43 Copy of ord_sld_line_vw to include product catalogs

ORD_SLD_PROD_VW

(SQL View)

Order lines to copy

Date Initials Issue Description 011503 dms F-CJORGENS-43 Copy of ord_sld_line_vw to include product catalogs

SELECT L.BUSINESS_UNIT , L.ORDER_NO , L.ORDER_INT_LINE_NO , L.PROD_ID_ENTERED , L.QTY_ORDERED , L.UNIT_OF_MEASURE , L.PRICE , L.CURRENCY_CD , L.ORD_LINE_TAG , H.SOLD_TO_CUST_ID , C.SETID , CST.SETID , C.EFF_STATUS , L.PRODUCT_ID , L.PROD_ID_SRC , L.CONFIG_CODE FROM PS_ORD_LINE L , PS_PROD_ITEM C , PS_ORD_HEADER H , PS_CUSTOMER CST WHERE 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 L.ORD_LINE_STATUS IN ('O','C','P') AND H.BUSINESS_UNIT = L.BUSINESS_UNIT AND H.ORDER_NO = L.ORDER_NO AND CST.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC S WHERE S.SETCNTRLVALUE = H.BUSINESS_UNIT AND S.RECNAME = 'CUSTOMER') AND CST.CUST_ID = H.SOLD_TO_CUST_ID

# 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 PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL This is price per unit for calculating the service charge.

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

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

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

11 SETID_PRODUCT Character(5) VARCHAR2(5) NOT NULL Product SetID

12 SETID_CUSTOMER Character(5) VARCHAR2(5) NOT NULL Customer SetID

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

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

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

16 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	PRICE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	This is price per unit for calculating the service charge.
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
9	ORD_LINE_TAG	Number(5,0)	INTEGER NOT NULL	Order Line tag line nbr
10	SOLD_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Sold To Customer
11	SETID_PRODUCT	Character(5)	VARCHAR2(5) NOT NULL	Product SetID
12	SETID_CUSTOMER	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID
13	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
14	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
15	PROD_ID_SRC	Character(1)	VARCHAR2(1) NOT NULL	Product Source C=Customer P=UPC S=System U=Universal
16	CONFIG_CODE	Character(50)	VARCHAR2(50) NOT NULL	Product Configurator