IN_DMD_MPEG_VW

(SQL View)
 Index Back

Pegging Table

06/16/04 EGS: Created.

SELECT C.HASH_KEY , C.BUSINESS_UNIT , C.DEMAND_SOURCE , C.SOURCE_BUS_UNIT , C.ORDER_NO , C.ORDER_INT_LINE_NO , C.SCHED_LINE_NBR , C.INV_ITEM_ID , C.DEMAND_LINE_NO , MIN(B.PEG_STATUS) FROM PS_IN_PEGGING B , PS_IN_DEMAND_HASH C WHERE B.DEMAND_HASH = C.HASH_KEY AND B.DMD_ORDER_TYPE IN ('070', '090', '030') GROUP BY C.HASH_KEY, C.BUSINESS_UNIT, C.DEMAND_SOURCE, C.SOURCE_BUS_UNIT, C.ORDER_NO, C.ORDER_INT_LINE_NO, C.SCHED_LINE_NBR, C.INV_ITEM_ID, C.DEMAND_LINE_NO

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HASH_KEY Character(28) VARCHAR2(28) NOT NULL 08/11/04 EGS: Created
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 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
4 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
5 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
6 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
7 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
8 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
9 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
10 PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Not Pegged

Default Value: 10