IN_SDWC_MPA1_VW (SQL View)	Index Back
Overdue Par - IN Demand No security

IN_SDWC_MPA1_VW

(SQL View)

Overdue Par - IN Demand

No security

SELECT 'IN_SDWC_PAR_ALERT' ,'SUP_DMD_ALERTS' , '00' , %subrec(IN_DMD_NKEY_SBR, D) , D.CONFIG_CODE , D.PRIORITY_NBR , D.PRODUCT_ID , D.PARENT_PROD_ID , D.SHIP_TO_CUST_ID , D.SHIP_CUST_NAME1 , D.ADDRESS_SEQ_NUM , D.LOCATION , %DatePart(D.SCHED_DTTM) , D.SCHED_DTTM , D.IN_FULFILL_STATE , D.CARRIER_ID , D.SHIP_TYPE_ID , D.LOAD_ID , D.ROUTE_CD , D.ROUTE_STOP_NBR , D.SINGLE_SHIP_FLAG , D.QTY_REQUESTED - D.QTY_BACKORDER , D.QTY_REQUESTED_BASE - D.QTY_BACKORDER_BASE , D.UNIT_OF_MEASURE , D.QTY_REQUESTED - D.QTY_BACKORDER , D.QTY_SHIPPED_CONV , D.QTY_SHIP_BASE , 0 , 0 , D.CURRENCY_CD , D.CURRENCY_CD , D.INTERUNIT_FLG , D.DESTIN_BU , C.CART_GROUP , 0 , ' ' , D.PEG_STATUS , ' ' , ' ' , ' ' , ' ' , %DateNull , ' ' , ' ' , ' ' , 0 , 0 , 0 , C.INV_CART_ID , C.ORDER_BU , C.SHIPTO_ID , D.ORDER_NO , 0 FROM PS_IN_DEMAND D , PS_CART_ATTRIB_INV C WHERE D.IN_PROCESS_DATE IS NOT NULL AND D.IN_FULFILL_STATE < '60' AND %DatePart(D.SCHED_DTTM) < %CurrentDateIn AND C.BUSINESS_UNIT = D.SOURCE_BUS_UNIT AND C.ORDER_BU = D.BUSINESS_UNIT AND C.LOCATION = D.LOCATION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EOEN_PRCS_NAME Character(30) VARCHAR2(30) NOT NULL EOEN Process Name

2 EOEN_CATEGORY Character(30) VARCHAR2(30) NOT NULL EOEN Category

3 IN_SDWC_DOC_TYPE Character(2) VARCHAR2(2) NOT NULL Document Type
00=MSR
10=Requisition
20=Purchase Order

4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BUIN_NONVW

5 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

6 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
Prompt Table: SP_BU_FS_NONVW

7 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

8 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line

9 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number

10 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

11 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No

12 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

13 PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority

14 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

15 PARENT_PROD_ID Character(18) VARCHAR2(18) NOT NULL Parent Product Id

16 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

17 SHIP_CUST_NAME1 Character(40) VARCHAR2(40) NOT NULL Ship To Name

18 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

19 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

20 SCHED_SHIP_DATE Date(10) DATE Scheduled Ship Date

21 SCHED_DTTM DateTime(26) TIMESTAMP 08/16/01 JNW (CN#PL900-1.0): Added

22 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

23 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID

24 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code

25 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID

26 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.

27 ROUTE_STOP_NBR Number(5,0) INTEGER NOT NULL An identifier used to sequence customer addresses/location for a given route.

28 SINGLE_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Single Ship Flag
N=No
Y=Yes

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 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label

36 MERCH_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Merchandise Amount

37 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

38 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency

39 INTERUNIT_FLG Character(1) VARCHAR2(1) NOT NULL InterUnit
N=No
Y=Yes

40 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit

41 CART_GROUP Character(5) VARCHAR2(5) NOT NULL Par Location Group

42 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line

43 DISTRIB_LN_STATUS Character(1) VARCHAR2(1) NOT NULL Distribution Line Status
C=Closed
M=Mass Liquidated
O=Open
P=Unavailable for Sourcing
X=Canceled

44 PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Not Pegged

45 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

46 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

47 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

48 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

49 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.

50 REQ_STATUS Character(4) VARCHAR2(4) NOT NULL Req status
A=Approved
C=Complete
D=Denied
I=Initial
LA=Line Approved
O=Open
P=Pending Approval
V=Preview
X=Canceled

51 PO_STATUS Character(2) VARCHAR2(2) NOT NULL PO Status
A=Approved
C=Complete
D=Dispatched
DA=Denied
I=Initial
LD=Line Denied
O=Open
PA=Pending Approval/Approved
PX=Pending Cancel
X=Canceled

52 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID

53 REQ_LINE_NBR Number(5,0) INTEGER NOT NULL Requisition Line Number

54 REQ_SCHED_NBR Number(3,0) SMALLINT NOT NULL Requisition Schedule Number

55 REQ_DISTRIB_NBR Number(5,0) INTEGER NOT NULL Requisition Distrib Number

56 INV_CART_ID Character(15) VARCHAR2(15) NOT NULL Par Location ID

57 ORDER_BU Character(5) VARCHAR2(5) NOT NULL Par Loc Order Business Unit

58 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location

59 DOCUMENT_ID Character(12) VARCHAR2(12) NOT NULL Document

60 ROWNBR Number(7,0) INTEGER NOT NULL Row number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EOEN_PRCS_NAME	Character(30)	VARCHAR2(30) NOT NULL	EOEN Process Name
2	EOEN_CATEGORY	Character(30)	VARCHAR2(30) NOT NULL	EOEN Category
3	IN_SDWC_DOC_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Document Type 00=MSR 10=Requisition 20=Purchase Order
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BUIN_NONVW
5	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
6	SOURCE_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Source Bus Unit Prompt Table: SP_BU_FS_NONVW
7	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
8	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
9	SCHED_LINE_NBR	Number(6,0)	INTEGER NOT NULL	Schedule Line Number
10	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
11	DEMAND_LINE_NO	Number(4,0)	SMALLINT NOT NULL	Demand Line No
12	CONFIG_CODE	Character(50)	VARCHAR2(50) NOT NULL	Product Configurator
13	PRIORITY_NBR	Number(3,0)	SMALLINT NOT NULL	Priority
14	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
15	PARENT_PROD_ID	Character(18)	VARCHAR2(18) NOT NULL	Parent Product Id
16	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer
17	SHIP_CUST_NAME1	Character(40)	VARCHAR2(40) NOT NULL	Ship To Name
18	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
19	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
20	SCHED_SHIP_DATE	Date(10)	DATE	Scheduled Ship Date
21	SCHED_DTTM	DateTime(26)	TIMESTAMP	08/16/01 JNW (CN#PL900-1.0): Added
22	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
23	CARRIER_ID	Character(10)	VARCHAR2(10) NOT NULL	Carrier ID
24	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code
25	LOAD_ID	Character(10)	VARCHAR2(10) NOT NULL	Load ID
26	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.
27	ROUTE_STOP_NBR	Number(5,0)	INTEGER NOT NULL	An identifier used to sequence customer addresses/location for a given route.
28	SINGLE_SHIP_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Single Ship Flag N=No Y=Yes
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	MERCHANDISE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
36	MERCH_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Merchandise Amount
37	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
38	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
39	INTERUNIT_FLG	Character(1)	VARCHAR2(1) NOT NULL	InterUnit N=No Y=Yes
40	DESTIN_BU	Character(5)	VARCHAR2(5) NOT NULL	Destination Unit
41	CART_GROUP	Character(5)	VARCHAR2(5) NOT NULL	Par Location Group
42	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
43	DISTRIB_LN_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Distribution Line Status C=Closed M=Mass Liquidated O=Open P=Unavailable for Sourcing X=Canceled
44	PEG_STATUS	Character(2)	VARCHAR2(2) NOT NULL	07/21/04 EGS: Created 10=Open 20=Completed 30=Canceled 40=Not Pegged
45	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer
46	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
47	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
48	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
49	DUE_DT	Date(10)	DATE	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
50	REQ_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Req status A=Approved C=Complete D=Denied I=Initial LA=Line Approved O=Open P=Pending Approval V=Preview X=Canceled
51	PO_STATUS	Character(2)	VARCHAR2(2) NOT NULL	PO Status A=Approved C=Complete D=Dispatched DA=Denied I=Initial LD=Line Denied O=Open PA=Pending Approval/Approved PX=Pending Cancel X=Canceled
52	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
53	REQ_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Requisition Line Number
54	REQ_SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Requisition Schedule Number
55	REQ_DISTRIB_NBR	Number(5,0)	INTEGER NOT NULL	Requisition Distrib Number
56	INV_CART_ID	Character(15)	VARCHAR2(15) NOT NULL	Par Location ID
57	ORDER_BU	Character(5)	VARCHAR2(5) NOT NULL	Par Loc Order Business Unit
58	SHIPTO_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship To Location
59	DOCUMENT_ID	Character(12)	VARCHAR2(12) NOT NULL	Document
60	ROWNBR	Number(7,0)	INTEGER NOT NULL	Row number