ORD_SCH_DEM_VW

(SQL View)
 Index Back

Ord Sched Demand Inf View

Ord Sched Demand Inf View

SELECT d.business_unit , d.demand_source , d.order_no , d.inv_item_id , %DatePart(d.sched_dttm) , d.cust_name , d.ship_cust_name1 , 'D' , ' ' , ' ' , d.unit_of_measure , d.qty_requested , d.qty_backorder , u.conversion_rate , ' ' , ' ' , 0 , 0 , 0 FROM PS_IN_DEMAND d , ps_inv_item_uom u WHERE u.setid = ( SELECT setid FROM ps_set_cntrl_rec sc WHERE setcntrlvalue = d.business_unit AND recname = 'INV_ITEM_UOM') AND u.inv_item_id = d.inv_item_id AND u.unit_of_measure = d.unit_of_measure AND d.in_fulfill_state = '20'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BUIN_NONVW

2 DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order
3 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
4 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: MST_ITM_PRPT_VW

5 SCHED_DATE Date(10) DATE NOT NULL Schedule Date
6 CUST_NAME Character(40) VARCHAR2(40) NOT NULL Name
7 SHIP_CUST_NAME1 Character(40) VARCHAR2(40) NOT NULL Ship To Name
8 AVAIL_TYPE Character(1) VARCHAR2(1) NOT NULL Availability Type
D=Demand
S=Supply
9 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
10 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
11 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
12 QTY_REQUESTED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested
13 QTY_BACKORDER Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Qty
14 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate
15 RECV_STATUS Character(1) VARCHAR2(1) NOT NULL Receipt Status
C=Closed Receipt
H=Hold Receipt
M=Moved to Destination
N=PO Not Received
O=Open
P=PO Partially Received
R=Fully Received
X=Canceled
16 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
17 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
18 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
19 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line