IN_SW_ORDP_2_VW (SQL View)	Index Back
FW: Order Pool DIF DEMAND_INF_INV

IN_SW_ORDP_2_VW

(SQL View)

FW: Order Pool DIF

DEMAND_INF_INV

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.DEMAND_LINE_NO ,A.IN_FULFILL_STATE ,A.PRIORITY_NBR ,'EA' ,A.QTY_REQUESTED_BASE ,A.QTY_ALLOC_BASE ,A.QTY_BACKORDER_BASE ,A.QTY_PROMISED_BASE ,0 ,A.QTY_PICK_OVR_BASE ,A.UNIT_OF_MEASURE ,A.QTY_REQUESTED ,A.QTY_ALLOCATED ,A.QTY_BACKORDER ,0 ,A.QTY_PICK_OVRIDE ,A.SHIP_ID ,A.CARRIER_ID ,A.SHIP_TYPE_ID ,A.ROUTE_CD ,A.LOAD_ID ,A.LOCATION ,A.DESTIN_BU ,A.CUST_ID ,A.CUST_NAME ,A.SHIP_TO_CUST_ID ,A.ADDRESS_SEQ_NUM ,A.VMI_DESTIN_SHIPTO ,A.PICK_BATCH_ID ,A.PICKLIST_LINE_NO ,A.TMS_EXT_REF_ID ,A.TMS_EXT_REF_LN_NBR ,A.EXT_REF_NBR ,A.EXT_REF_LN_NBR ,A.INTERUNIT_FLG ,'N' ,A.SCHED_DTTM ,A.HARD_ALLOC_FLAG ,A.LOT_ALLOC_FLG ,A.RESERVE_STATUS ,A.IN_LINE_BO_RULE ,A.FULFILL_FLAG ,A.APPROVED_FLAG ,A.BACKORDER_CREATED ,A.LAST_MAINT_OPRID ,A.DT_TIMESTAMP ,A.SHIP_ID_EST ,A.PARENT_PROD_ID ,A.PRODUCT_ID ,0 ,A.PEG_STATUS ,A.RESERVED_DTTM ,A.IN_LINE_RESV_RULE , A.IN_LN_RESV_BO_RULE , A.IN_ORDER_RESV_RULE ,A.OPTIONAL_SHIP ,0 ,0 ,A.PARTIAL_QTY_FLAG ,A.IN_PRIOR_STATE ,A.IN_ZERO_PICKED_FLG ,A.QTY_SHIP_BASE ,A.QTY_SHIPPED ,' ' ,' ' ,A.CONFIG_CODE ,A.QTY_PACK_BASE ,A.BCKORDER_FLAG , A.DELIVERY_ID FROM PS_IN_DEMAND A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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
Prompt Table: BU_ITM_INV_VW2

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 PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority

11 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure

12 QTY_REQUESTED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested Base

13 QTY_ALLOC_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity allocation

14 QTY_BACKORDER_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Base Qty

15 QTY_PROMISED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Promised Base

16 QTY_OPEN_STD Number(16,4) DECIMAL(15,4) NOT NULL Quantity Open Standard UOM

17 QTY_PICK_OVR_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Field used to override the net requested quantity in standard uom when printing the pick play for non-soft reservation items.

18 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Prompt Table: %EDITTABLE

19 QTY_REQUESTED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested

20 QTY_ALLOCATED Signed Number(17,4) DECIMAL(15,4) NOT NULL Allocated quantity

21 QTY_BACKORDER Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Qty

22 QTY_OPEN_DEMAND Signed Number(16,3) DECIMAL(14,3) NOT NULL Open Demand Qty

23 QTY_PICK_OVRIDE Signed Number(17,4) DECIMAL(15,4) NOT NULL Field used to override the net requested quantity when printing the pick play for non-soft reservation items.

24 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID

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

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

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

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

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

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

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

32 CUST_NAME Character(40) VARCHAR2(40) NOT NULL Name

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

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

35 VMI_DESTIN_SHIPTO Character(15) VARCHAR2(15) NOT NULL Ship To Customer

36 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID

37 PICKLIST_LINE_NO Number(7,0) INTEGER NOT NULL Pick List Sorting Line Number

38 TMS_EXT_REF_ID Character(10) VARCHAR2(10) NOT NULL TMS Reference ID

39 TMS_EXT_REF_LN_NBR Number(7,0) INTEGER NOT NULL TMS Line Number

40 EXT_REF_NBR Number(10,0) DECIMAL(10) NOT NULL External Reference Number

41 EXT_REF_LN_NBR Number(5,0) INTEGER NOT NULL External Reference Line Number

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

43 SOFT_ALLOC_FLG Character(1) VARCHAR2(1) NOT NULL Soft Reserve

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

45 HARD_ALLOC_FLAG Character(1) VARCHAR2(1) NOT NULL Hard Allocate

46 LOT_ALLOC_FLG Character(1) VARCHAR2(1) NOT NULL Allow Lot Allocation

47 RESERVE_STATUS Character(2) VARCHAR2(2) NOT NULL Reservation Status
10=Pending
11=Unreserved
12=Shortage, Rules Not Met
15=Reserved, Rules Not Met
21=Shortage, Line Rule Met
22=Reserved, Line Rule Met
31=Shortage, All Rules Met
32=Reserved, All Rules Met
40=Reserve Run
99=Invalid

48 IN_LINE_BO_RULE Character(10) VARCHAR2(10) NOT NULL Line Backorder Rule

49 FULFILL_FLAG Character(1) VARCHAR2(1) NOT NULL OK to Pick

50 APPROVED_FLAG Character(1) VARCHAR2(1) NOT NULL Approved
B=Both
N=No
Y=Yes

51 BACKORDER_CREATED Character(1) VARCHAR2(1) NOT NULL Backorder Created Flag

52 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID

53 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp

54 SHIP_ID_EST Character(10) VARCHAR2(10) NOT NULL Estimated Ship ID

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

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

57 QTY_PEGGED Signed Number(17,4) DECIMAL(15,4) NOT NULL 06/16/04 EGS: Created.

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

59 RESERVED_DTTM DateTime(26) TIMESTAMP Reserved Date/Time

60 IN_LINE_RESV_RULE Character(10) VARCHAR2(10) NOT NULL Line Reservation Rule

61 IN_LN_RESV_BO_RULE Character(10) VARCHAR2(10) NOT NULL Line Reservation - Backorder

62 IN_ORDER_RESV_RULE Character(10) VARCHAR2(10) NOT NULL Order Reservation Rule

63 OPTIONAL_SHIP Character(1) VARCHAR2(1) NOT NULL OK to Ship Without

64 QTY_PRE_ALLOC Number(16,4) DECIMAL(15,4) NOT NULL Quantity Open Standard UOM

65 QTY_PRE_ALLOC_BASE Number(16,4) DECIMAL(15,4) NOT NULL Quantity Open Standard UOM

66 PARTIAL_QTY_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Qtys Can Ship

67 IN_PRIOR_STATE Character(2) VARCHAR2(2) NOT NULL Inventory Fulfillment State at the time the demand line was cancelled
10=Pending
20=Unfulfilled
30=Releasable
40=Released
50=Picking Confirmed
60=Shipped
70=Depleted
90=Canceled

68 IN_ZERO_PICKED_FLG Character(1) VARCHAR2(1) NOT NULL Zero Picked

69 QTY_SHIP_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Ship Base

70 QTY_SHIPPED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped

71 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code
Prompt Table: IN_SW_RESCD_VW

72 COMMENTS_254 Character(254) VARCHAR2(254) NOT NULL EDI Comments

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

74 QTY_PACK_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity Packed

75 BCKORDER_FLAG Character(1) VARCHAR2(1) NOT NULL Backorder Flag
N=No
Y=Yes

76 DELIVERY_ID Character(10) VARCHAR2(10) NOT NULL Delivery ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BUIN_NONVW
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 Prompt Table: BU_ITM_INV_VW2
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	PRIORITY_NBR	Number(3,0)	SMALLINT NOT NULL	Priority
11	UNIT_MEASURE_STD	Character(3)	VARCHAR2(3) NOT NULL	Standard Unit of Measure
12	QTY_REQUESTED_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Requested Base
13	QTY_ALLOC_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity allocation
14	QTY_BACKORDER_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Backorder Base Qty
15	QTY_PROMISED_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Promised Base
16	QTY_OPEN_STD	Number(16,4)	DECIMAL(15,4) NOT NULL	Quantity Open Standard UOM
17	QTY_PICK_OVR_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Field used to override the net requested quantity in standard uom when printing the pick play for non-soft reservation items.
18	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: %EDITTABLE
19	QTY_REQUESTED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Requested
20	QTY_ALLOCATED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Allocated quantity
21	QTY_BACKORDER	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Backorder Qty
22	QTY_OPEN_DEMAND	Signed Number(16,3)	DECIMAL(14,3) NOT NULL	Open Demand Qty
23	QTY_PICK_OVRIDE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Field used to override the net requested quantity when printing the pick play for non-soft reservation items.
24	SHIP_ID	Character(10)	VARCHAR2(10) NOT NULL	Shipping ID
25	CARRIER_ID	Character(10)	VARCHAR2(10) NOT NULL	Carrier ID
26	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code
27	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.
28	LOAD_ID	Character(10)	VARCHAR2(10) NOT NULL	Load ID
29	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
30	DESTIN_BU	Character(5)	VARCHAR2(5) NOT NULL	Destination Unit
31	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.
32	CUST_NAME	Character(40)	VARCHAR2(40) NOT NULL	Name
33	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer
34	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
35	VMI_DESTIN_SHIPTO	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer
36	PICK_BATCH_ID	Number(10,0)	DECIMAL(10) NOT NULL	Pick Batch ID
37	PICKLIST_LINE_NO	Number(7,0)	INTEGER NOT NULL	Pick List Sorting Line Number
38	TMS_EXT_REF_ID	Character(10)	VARCHAR2(10) NOT NULL	TMS Reference ID
39	TMS_EXT_REF_LN_NBR	Number(7,0)	INTEGER NOT NULL	TMS Line Number
40	EXT_REF_NBR	Number(10,0)	DECIMAL(10) NOT NULL	External Reference Number
41	EXT_REF_LN_NBR	Number(5,0)	INTEGER NOT NULL	External Reference Line Number
42	INTERUNIT_FLG	Character(1)	VARCHAR2(1) NOT NULL	InterUnit N=No Y=Yes
43	SOFT_ALLOC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Soft Reserve
44	SCHED_DTTM	DateTime(26)	TIMESTAMP	08/16/01 JNW (CN#PL900-1.0): Added
45	HARD_ALLOC_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Hard Allocate
46	LOT_ALLOC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Allow Lot Allocation
47	RESERVE_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Reservation Status 10=Pending 11=Unreserved 12=Shortage, Rules Not Met 15=Reserved, Rules Not Met 21=Shortage, Line Rule Met 22=Reserved, Line Rule Met 31=Shortage, All Rules Met 32=Reserved, All Rules Met 40=Reserve Run 99=Invalid
48	IN_LINE_BO_RULE	Character(10)	VARCHAR2(10) NOT NULL	Line Backorder Rule
49	FULFILL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	OK to Pick
50	APPROVED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Approved B=Both N=No Y=Yes
51	BACKORDER_CREATED	Character(1)	VARCHAR2(1) NOT NULL	Backorder Created Flag
52	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID
53	DT_TIMESTAMP	DateTime(26)	TIMESTAMP	Date Timestamp
54	SHIP_ID_EST	Character(10)	VARCHAR2(10) NOT NULL	Estimated Ship ID
55	PARENT_PROD_ID	Character(18)	VARCHAR2(18) NOT NULL	Parent Product Id
56	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
57	QTY_PEGGED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	06/16/04 EGS: Created.
58	PEG_STATUS	Character(2)	VARCHAR2(2) NOT NULL	07/21/04 EGS: Created 10=Open 20=Completed 30=Canceled 40=Not Pegged
59	RESERVED_DTTM	DateTime(26)	TIMESTAMP	Reserved Date/Time
60	IN_LINE_RESV_RULE	Character(10)	VARCHAR2(10) NOT NULL	Line Reservation Rule
61	IN_LN_RESV_BO_RULE	Character(10)	VARCHAR2(10) NOT NULL	Line Reservation - Backorder
62	IN_ORDER_RESV_RULE	Character(10)	VARCHAR2(10) NOT NULL	Order Reservation Rule
63	OPTIONAL_SHIP	Character(1)	VARCHAR2(1) NOT NULL	OK to Ship Without
64	QTY_PRE_ALLOC	Number(16,4)	DECIMAL(15,4) NOT NULL	Quantity Open Standard UOM
65	QTY_PRE_ALLOC_BASE	Number(16,4)	DECIMAL(15,4) NOT NULL	Quantity Open Standard UOM
66	PARTIAL_QTY_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Partial Qtys Can Ship
67	IN_PRIOR_STATE	Character(2)	VARCHAR2(2) NOT NULL	Inventory Fulfillment State at the time the demand line was cancelled 10=Pending 20=Unfulfilled 30=Releasable 40=Released 50=Picking Confirmed 60=Shipped 70=Depleted 90=Canceled
68	IN_ZERO_PICKED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Zero Picked
69	QTY_SHIP_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Ship Base
70	QTY_SHIPPED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Shipped
71	REASON_CD	Character(10)	VARCHAR2(10) NOT NULL	Reason Code Prompt Table: IN_SW_RESCD_VW
72	COMMENTS_254	Character(254)	VARCHAR2(254) NOT NULL	EDI Comments
73	CONFIG_CODE	Character(50)	VARCHAR2(50) NOT NULL	Product Configurator
74	QTY_PACK_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Base Quantity Packed
75	BCKORDER_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Backorder Flag N=No Y=Yes
76	DELIVERY_ID	Character(10)	VARCHAR2(10) NOT NULL	Delivery ID