OM_DELSCHBKT_VW

(SQL View)
 Index Back

Order Entry Est ship totals

Order Entry Est ship totals

SELECT S.SHIP_FROM_BU , 'OM' , S.BUSINESS_UNIT , S.ORDER_NO , S.DELIVERY_ID , C.SETID , SUM(%Round(%DecMult(S.QTY_SCHEDULED, S.NET_UNIT_PRICE), 4)) , S.CURRENCY_CD , SUM(%Round(%DecMult(S.QTY_SCHEDULED, S.NET_UNIT_PRICE_BSE), 4)) , S.CURRENCY_CD_BASE , SUM(%Round(CASE S.SHIPPING_KIT_QTY WHEN 0 THEN S.QTY_SCHEDULED ELSE S.SHIPPING_KIT_QTY END, 2)) , SUM(%Round(CASE S.SHIPPING_KIT_QTY WHEN 0 THEN S.SHIPPING_QTY ELSE S.SHIPPING_KIT_QTY END, 2)) , SUM(%Round(%DecMult(S.SHIPPING_VOLUME, (CASE S.SHIPPING_KIT_QTY WHEN 0 THEN S.SHIPPING_QTY ELSE 1 END)), 4)) , SUM(%Round(%DecMult(S.SHIPPING_WEIGHT, (CASE S.SHIPPING_KIT_QTY WHEN 0 THEN S.SHIPPING_QTY ELSE 1 END)), 4)) , 0 , 0 , L.UNIT_OF_MEASURE , S.UNIT_MEASURE_SHIP , S.UNIT_MEASURE_SHIP , S.UNIT_MEASURE_SHIP , S.UNIT_MEASURE_VOL , S.UNIT_MEASURE_WT , COUNT(*) , S.CUST_PICKUP FROM PS_ORD_LINE L , PS_ORD_SCHEDULE S , PS_SET_CNTRL_REC C WHERE L.BUSINESS_UNIT = S.BUSINESS_UNIT AND L.ORDER_NO = S.ORDER_NO AND L.ORDER_INT_LINE_NO = S.ORDER_INT_LINE_NO AND S.ORD_SCH_STATUS <> 'X' AND S.DEMAND_SENT = 'N' AND C.SETCNTRLVALUE = S.SHIP_FROM_BU AND C.RECNAME = 'MASTER_ITEM_TBL' GROUP BY S.SHIP_FROM_BU, S.BUSINESS_UNIT , S.ORDER_NO , S.DELIVERY_ID , C.SETID, S.CURRENCY_CD, S.CURRENCY_CD_BASE, L.UNIT_OF_MEASURE , S.UNIT_MEASURE_SHIP, S.UNIT_MEASURE_VOL , S.UNIT_MEASURE_WT, S.CUST_PICKUP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
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 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
4 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
5 DELIVERY_ID Character(10) VARCHAR2(10) NOT NULL Delivery ID
6 SETID_INV_ITEM Character(5) VARCHAR2(5) NOT NULL Inv Items SETID
7 EXTENDED_NET_PRICE Signed Number(29,4) DECIMAL(27,4) NOT NULL Ext Net Amount
8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
9 EXT_NET_PRC_BASE Signed Number(29,4) DECIMAL(27,4) NOT NULL Extended Net Price (base)
10 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
11 ORDERING_QTY Signed Number(18,4) DECIMAL(16,4) NOT NULL Ordering Quantity
12 SHIPPING_QTY Number(17,4) DECIMAL(16,4) NOT NULL Shipping Quantity
13 SHIPPING_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Shipping Volume
14 SHIPPING_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Shipping Weight
15 PACKING_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Packing Volume
16 PACKING_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Packing Weight
17 DELIV_UOM_QTY Character(3) VARCHAR2(3) NOT NULL Delivery Order Qty UOM
18 DELIV_SHIP_UOM_QTY Character(3) VARCHAR2(3) NOT NULL Delivery Ship Qty UOM
19 DELIV_UOM_SHIP_VOL Character(3) VARCHAR2(3) NOT NULL Ship UOM for volume conversion
20 DELIV_UOM_SHIP_WT Character(3) VARCHAR2(3) NOT NULL Ship UOM for weight conversion
21 DELIV_UOM_VOL Character(3) VARCHAR2(3) NOT NULL Delivery Volume UOM
22 DELIV_UOM_WT Character(3) VARCHAR2(3) NOT NULL Delivery Weight UOM
23 NBR_DEMAND_LINES Number(4,0) SMALLINT NOT NULL Number of Demand Lines
24 CUST_PICKUP Character(1) VARCHAR2(1) NOT NULL Counter sale customer pickup flag
N=No
Y=Yes