CDT_LINE_VW (SQL View)	Index Back
Order Line - FS This table is the child of ORD_HEADER. The order line table stores the information as to what products and quantities are required, as well as defaults for the line schedules. This table is the parent of ORD_SCHEDULE. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop

CDT_LINE_VW

(SQL View)

Order Line - FS

This table is the child of ORD_HEADER. The order line table stores the information as to what products and quantities are required, as well as defaults for the line schedules. This table is the parent of ORD_SCHEDULE. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop

SELECT o.business_unit , o.order_no , o.order_int_line_no , o.product_id , o.prod_id_src , p.descr , o.cancel_date , o.currency_cd , o.currency_cd_base , %Round(%DecMult(o.price, o.qty_ordered), 4) , o.ord_line_status , o.qty_ordered , o.unit_of_measure FROM ps_ord_line o , ps_set_cntrl_rec sc , PS_PROD_ITEM p WHERE sc.setcntrlvalue = o.business_unit AND sc.recname = 'PROD_ITEM' AND sc.setid = p.setid AND o.product_id = p.product_id

Related Language Record: CDT_LINE_LVW

# 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
Default Value: BUS_UNIT_TBL_OM.ORD_LINE_INCREMENT

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

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

6 DESCR Character(30) VARCHAR2(30) NOT NULL Description

7 CANCEL_DATE Date(10) DATE Cancel Date

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

9 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency

10 EXTENDED_NET_PRICE Signed Number(29,4) DECIMAL(27,4) NOT NULL Ext Net Amount

11 ORD_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Line Status
C=Closed
O=Open
P=Pending
X=Canceled
Default Value: P

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

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

#	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 Default Value: BUS_UNIT_TBL_OM.ORD_LINE_INCREMENT
4	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
5	PROD_ID_SRC	Character(1)	VARCHAR2(1) NOT NULL	Product Source C=Customer P=UPC S=System U=Universal
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
7	CANCEL_DATE	Date(10)	DATE	Cancel Date
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
9	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
10	EXTENDED_NET_PRICE	Signed Number(29,4)	DECIMAL(27,4) NOT NULL	Ext Net Amount
11	ORD_LINE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Line Status C=Closed O=Open P=Pending X=Canceled Default Value: P
12	QTY_ORDERED	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Order Qty
13	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage