ORD_LINE_DT_VW

(SQL View)
 Index Back

Order Line next schedule dates


SELECT a.business_unit , a.order_no , a.order_int_line_no , a.product_id , a.qty_ordered , a.unit_of_measure , b.list_price , b.net_unit_price , b.priceset_price , %Round(%DecMult(b.net_unit_price, a.qty_ordered), 4) , %Round(%DecMult(b.list_price, a.qty_ordered), 4) , a.ord_line_status , b.req_arrival_dttm , b.sched_arrv_dttm , b.sched_ship_dttm , b.sched_line_nbr , b.ship_from_bu FROM PS_ORD_SCHEDULE b , ps_ord_line a WHERE a.business_unit = b.business_unit AND a.order_no = b.order_no AND a.order_int_line_no = b.order_int_line_no AND b.sched_ship_dttm = ( SELECT MAX(sched_ship_dttm) FROM PS_ORD_SCHEDULE c WHERE c.business_unit = b.business_unit AND c.order_no = b.order_no AND c.order_int_line_no = b.order_int_line_no AND c.sched_ship_dttm <= %CurrentDateTimeIn)

# 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 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
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 LIST_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price
8 NET_UNIT_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price
9 PRICESET_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Price Rule Price
10 EXTENDED_NET_PRICE Signed Number(29,4) DECIMAL(27,4) NOT NULL Ext Net Amount
11 EXTENDED_LIST_PRC Signed Number(29,4) DECIMAL(27,4) NOT NULL Ext List Price
12 ORD_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Line Status
C=Closed
O=Open
P=Pending
X=Canceled
13 REQ_ARRIVAL_DTTM DateTime(26) TIMESTAMP Requested Arrival
14 SCHED_ARRV_DTTM DateTime(26) TIMESTAMP Schedule Arrival Dt/Tm
15 SCHED_SHIP_DTTM DateTime(26) TIMESTAMP Schedule Ship Datetime
16 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
17 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU