SHIP_A_KIT_VW2

(SQL View)
Index Back

Demand_Inv Kit View

This is a summary view over DEMAND_INV for Kit Processing. It selects demand lines for kits summed to the schedule level where the same keys do not exist in SHIP_INF_INV. 08/04/04 PWF Data Model Change: Change to IN_DEMAND

SELECT A.BUSINESS_UNIT , A.DEMAND_SOURCE , A.SOURCE_BUS_UNIT , A.ORDER_NO , A.ORDER_INT_LINE_NO , A.SCHED_LINE_NBR , A.INV_ITEM_ID , A.PARENT_PROD_ID , A.PRODUCT_ID , %DatePart(A.ORIG_SCHED_DTTM) , A.UNIT_OF_MEASURE , (SUM(A.QTY_REQUESTED) - SUM(A.QTY_BACKORDER)) , SUM(A.QTY_PICKED) , 0 , 0 , 0 , 0 , SUM(A.QTY_BACKORDER) FROM PS_IN_DEMAND A WHERE A.PARENT_PROD_ID <> ' ' AND A.IN_FULFILL_STATE IN ('30','40') GROUP BY A.BUSINESS_UNIT, A.DEMAND_SOURCE, A.SOURCE_BUS_UNIT, A.ORDER_NO, A.ORDER_INT_LINE_NO, A.SCHED_LINE_NBR, A.INV_ITEM_ID, A.PARENT_PROD_ID, A.PRODUCT_ID, A.ORIG_SCHED_DTTM, A.UNIT_OF_MEASURE

# 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 PARENT_PROD_ID Character(18) VARCHAR2(18) NOT NULL Parent Product Id
9 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
10 ORIG_SCHED_DATE Date(10) DATE Orig Sched Date
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_PICKED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Picked
14 QTY_PICK_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Pick Base
15 QTY_SHIPPED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
16 QTY_SHIP_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Ship Base
17 QTY_SHIPPED_CONV Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
18 QTY_BACKORDER Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Qty