DMD_REL_INV_VW

(SQL View)
 Index Back

Demand Order Release View

This view is used by the Order Release secondary panel to initially fetch all rows meeting the selection criteria on the picking plan run control panel. NOTE: There is a Sybase version of the viewtext associated with this record. If it is modified, please be sure to modify the platform-specific viewtext for Sybase.

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.SCHED_DTTM , A.DESTIN_BU , A.CARRIER_ID , A.LOAD_ID , A.SHIP_TYPE_ID , A.LOCATION , A.CUST_ID , A.CUST_NAME , A.SHIP_TO_CUST_ID , A.SHIP_CUST_NAME1 , A.SHIP_CUST_NAME2 , A.ADDRESS_SEQ_NUM , A.EXPORT , A.QTY_REQUESTED , A.QTY_REQUESTED_BASE , A.QTY_ALLOCATED , A.QTY_ALLOC_BASE , A.UNIT_OF_MEASURE , A.QTY_PICKED , A.QTY_PICK_OVRIDE , A.QTY_PICK_OVR_BASE , A.QTY_BACKORDER , A.QTY_BACKORDER_BASE , A.IN_FULFILL_STATE , A.FULFILL_FLAG , A.RESERVE_STATUS , A.CONFIRMED_FLAG , A.PICK_RELEASE_ID , A.ROUTE_CD , A.ROUTE_STOP_NBR , A.TMS_EXT_REF_ID , A.TMS_PROCESS_FLG , A.PICK_BATCH_ID , A.RELEASE_INSTANCE , A.HOLD_FLAG , A.PICKLIST_PRINTED , A.APPROVED_FLAG , A.PEG_STATUS , A.DT_TIMESTAMP , A.IN_ZERO_PICKED_FLG , A.PRODUCT_ID , A.PARENT_PROD_ID , A.PRIORITY_NBR , A.SHIP_ID , A.LAST_PROCESS_INST , 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

Prompt Table: DEMAND_PICK_VW

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: MST_ITM_PRPT_VW

8 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
9 SCHED_DTTM DateTime(26) TIMESTAMP 08/16/01 JNW (CN#PL900-1.0): Added
10 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit
11 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
12 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID
13 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code

Prompt Table: SHIP_METHOD

14 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
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 CUST_NAME Character(40) VARCHAR2(40) NOT NULL Name
17 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
18 SHIP_CUST_NAME1 Character(40) VARCHAR2(40) NOT NULL Ship To Name
19 SHIP_CUST_NAME2 Character(40) VARCHAR2(40) NOT NULL Ship To Name 2
20 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
21 EXPORT Character(1) VARCHAR2(1) NOT NULL Export Analytic Instance
N=No
Y=Yes
22 QTY_REQUESTED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested
23 QTY_REQUESTED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested Base
24 QTY_ALLOCATED Signed Number(17,4) DECIMAL(15,4) NOT NULL Allocated quantity
25 QTY_ALLOC_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity allocation
26 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
27 QTY_PICKED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Picked
28 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.
29 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.
30 QTY_BACKORDER Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Qty
31 QTY_BACKORDER_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Base Qty
32 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
33 FULFILL_FLAG Character(1) VARCHAR2(1) NOT NULL OK to Pick

Y/N Table Edit

Default Value: N

34 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
35 CONFIRMED_FLAG Character(1) VARCHAR2(1) NOT NULL Confirm
36 PICK_RELEASE_ID Number(10,0) DECIMAL(10) NOT NULL Pick Release ID
37 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.
38 ROUTE_STOP_NBR Number(5,0) INTEGER NOT NULL An identifier used to sequence customer addresses/location for a given route.
39 TMS_EXT_REF_ID Character(10) VARCHAR2(10) NOT NULL TMS Reference ID
40 TMS_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL TMS Process Flag
41 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID
42 RELEASE_INSTANCE Number(10,0) DECIMAL(10) NOT NULL 08/2004 rcw: Order Release Instance
43 HOLD_FLAG Character(1) VARCHAR2(1) NOT NULL Hold
N=Hold
Y=Hold
44 PICKLIST_PRINTED Character(1) VARCHAR2(1) NOT NULL Picklist Printed
45 APPROVED_FLAG Character(1) VARCHAR2(1) NOT NULL Approved
B=Both
N=No
Y=Yes
46 PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Not Pegged
47 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
48 IN_ZERO_PICKED_FLG Character(1) VARCHAR2(1) NOT NULL Zero Picked
49 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
50 PARENT_PROD_ID Character(18) VARCHAR2(18) NOT NULL Parent Product Id
51 PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority
52 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID
53 LAST_PROCESS_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance
54 DELIVERY_ID Character(10) VARCHAR2(10) NOT NULL Delivery ID