CDT_SCHEDULE_VW (SQL View)	Index Back
Order Schedule Line This record is the child of ORD_LINE. It holds all the delivery information for the order line. It also allows multiple schedules per order line so that an order line quantity may be broken out into multiple shipments on different dates, to different destinations from different warehouses.

CDT_SCHEDULE_VW

(SQL View)

Order Schedule Line

This record is the child of ORD_LINE. It holds all the delivery information for the order line. It also allows multiple schedules per order line so that an order line quantity may be broken out into multiple shipments on different dates, to different destinations from different warehouses.

SELECT BUSINESS_UNIT , ORDER_NO , ORDER_INT_LINE_NO , SCHED_LINE_NBR , SHIP_TO_CUST_ID , CANCEL_DATE , CURRENCY_CD , CURRENCY_CD_BASE , %Round(%DecMult(NET_UNIT_PRICE, QTY_SCHEDULED), 4) , ORD_SCH_STATUS , QTY_SCHEDULED , SHIP_FROM_BU FROM PS_ORD_SCHEDULE

# 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: 1

4 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number

5 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

6 CANCEL_DATE Date(10) DATE Cancel Date

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

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

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

10 ORD_SCH_STATUS Character(1) VARCHAR2(1) NOT NULL Schedule Status
C=Closed
O=Open
P=Pending
X=Canceled

11 QTY_SCHEDULED Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Scheduled

12 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU

#	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: 1
4	SCHED_LINE_NBR	Number(6,0)	INTEGER NOT NULL	Schedule Line Number
5	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer
6	CANCEL_DATE	Date(10)	DATE	Cancel Date
7	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
8	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
9	EXTENDED_NET_PRICE	Signed Number(29,4)	DECIMAL(27,4) NOT NULL	Ext Net Amount
10	ORD_SCH_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Schedule Status C=Closed O=Open P=Pending X=Canceled
11	QTY_SCHEDULED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity Scheduled
12	SHIP_FROM_BU	Character(5)	VARCHAR2(5) NOT NULL	Ship from INV BU