IN_SDA_DMDSO_VW

(SQL View)
 Index Back

Sup/Dmd Sales Order Dmd View

Order demand analytic - sales orders only

SELECT D.BUSINESS_UNIT , D.DEMAND_SOURCE , D.SOURCE_BUS_UNIT , D.ORDER_NO , D.ORDER_INT_LINE_NO , D.SCHED_LINE_NBR , D.INV_ITEM_ID , D.DEMAND_LINE_NO , %subrec(IN_SDA_DMD_SBR, D) , D.SCHED_DTTM , %DatePart(D.SCHED_DTTM) , D.QTY_REQUESTED - D.QTY_BACKORDER , D.QTY_REQUESTED_BASE - D.QTY_BACKORDER_BASE , D.UNIT_OF_MEASURE , CASE D.QTY_CODE WHEN 'ORD' THEN 0 ELSE D.QTY_REQUESTED_BASE - D.QTY_BACKORDER_BASE - D.QTY_SHIP_BASE END , CASE D.QTY_CODE WHEN 'ORD' THEN 0 ELSE D.QTY_SHIPPED_CONV END , D.QTY_SHIP_BASE , %Round(%DecMult(S.NET_UNIT_PRICE, S.QTY_SCHEDULED), 0) , %Round(%DecMult(S.NET_UNIT_PRICE_BSE, S.QTY_SCHEDULED), 0) , S.CURRENCY_CD , M.INV_ITEM_GROUP , M.INV_PROD_FAM_CD , M.UNIT_MEASURE_STD FROM PS_IN_DEMAND D , PS_ORD_SCHEDULE S , PS_MASTER_ITEM_TBL M , PS_SET_CNTRL_REC C WHERE D.IN_FULFILL_STATE BETWEEN '10' AND '60' AND D.IN_PROCESS_DATE IS NOT NULL AND D.DEMAND_SOURCE = 'OM' AND D.SOURCE_BUS_UNIT = S.BUSINESS_UNIT AND D.ORDER_NO = S.ORDER_NO AND D.ORDER_INT_LINE_NO = S.ORDER_INT_LINE_NO AND D.SCHED_LINE_NBR = S.SCHED_LINE_NBR AND M.SETID = C.SETID AND C.SETCNTRLVALUE = D.BUSINESS_UNIT AND C.RECNAME = 'MASTER_ITEM_TBL' AND M.INV_ITEM_ID = D.INV_ITEM_ID

# 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 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
6 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
8 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
9 IN_FULFILL_STATE Character(2) VARCHAR2(2) NOT NULL Inventory Fulfillment State
10=Pending
20=Unfulfilled
30=Releasable
40=Released
50=Confirmed
60=Shipped
70=Depleted
90=Canceled
10 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
11 PARENT_PROD_ID Character(18) VARCHAR2(18) NOT NULL Parent Product Id
12 PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority
13 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
14 SHIP_CUST_NAME1 Character(40) VARCHAR2(40) NOT NULL Ship To Name
15 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
16 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
17 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
18 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
19 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID
20 ROUTE_CD Character(6) VARCHAR2(6) NOT NULL A unique identifier assigned to a delivery route. Route codes can be associated with customer addresses for external orders or locations for internal orders. Route codes can be used to identify the appropriate delivery schedule for a customer/location if you are managing product shipments with your own vehicles.
21 ROUTE_STOP_NBR Number(5,0) INTEGER NOT NULL An identifier used to sequence customer addresses/location for a given route.
22 INTERUNIT_FLG Character(1) VARCHAR2(1) NOT NULL InterUnit
N=No
Y=Yes
23 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit
24 SINGLE_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Single Ship Flag
N=No
Y=Yes
25 PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Not Pegged
26 SUP_PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Unpegged
27 SCHED_DTTM DateTime(26) TIMESTAMP 08/16/01 JNW (CN#PL900-1.0): Added
28 SCHED_SHIP_DATE Date(10) DATE Scheduled Ship Date
29 QTY_REQUESTED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested
30 QTY_REQUESTED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested Base
31 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
32 TOTAL_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Total Quantity
33 QTY_SHIPPED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
34 QTY_SHIP_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Ship Base
35 EXTENDED_NET_PRICE Signed Number(29,4) DECIMAL(27,4) NOT NULL Ext Net Amount
36 EXT_NET_PRC_BASE Signed Number(29,4) DECIMAL(27,4) NOT NULL Extended Net Price (base)
37 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
38 INV_ITEM_GROUP1 Character(15) VARCHAR2(15) NOT NULL Item Group
39 INV_PROD_FAM_CD1 Character(10) VARCHAR2(10) NOT NULL Item Family
40 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure