DMD_REL_INV_VW2

(SQL View)
 Index Back

Demand Order Release View

This view is used as the detail record for the Order Release panels.

SELECT BUSINESS_UNIT , DEMAND_SOURCE , SOURCE_BUS_UNIT , ORDER_NO , ORDER_INT_LINE_NO , SCHED_LINE_NBR , INV_ITEM_ID , DEMAND_LINE_NO , SCHED_DTTM , DESTIN_BU , CARRIER_ID , LOAD_ID , SHIP_TYPE_ID , LOCATION , CUST_ID , CUST_NAME , SHIP_TO_CUST_ID , SHIP_CUST_NAME1 , SHIP_CUST_NAME2 , ADDRESS_SEQ_NUM , EXPORT , QTY_REQUESTED , QTY_REQUESTED_BASE , QTY_ALLOCATED , QTY_ALLOC_BASE , UNIT_OF_MEASURE , QTY_PICKED , QTY_PICK_OVRIDE , QTY_PICK_OVR_BASE , QTY_BACKORDER , QTY_BACKORDER_BASE , IN_FULFILL_STATE , FULFILL_FLAG , RESERVE_STATUS , CONFIRMED_FLAG , PICK_RELEASE_ID , ROUTE_CD , ROUTE_STOP_NBR , TMS_EXT_REF_ID , TMS_PROCESS_FLG , PICK_BATCH_ID , RELEASE_INSTANCE , HOLD_FLAG , PICKLIST_PRINTED , APPROVED_FLAG , PEG_STATUS , IN_ZERO_PICKED_FLG , PRODUCT_ID , PARENT_PROD_ID , PRIORITY_NBR , SHIP_ID , LAST_PROCESS_INST , DELIVERY_ID FROM PS_DMD_REL_INV_VW

# 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 IN_ZERO_PICKED_FLG Character(1) VARCHAR2(1) NOT NULL Zero Picked
48 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
49 PARENT_PROD_ID Character(18) VARCHAR2(18) NOT NULL Parent Product Id
50 PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority
51 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID
52 LAST_PROCESS_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance
53 DELIVERY_ID Character(10) VARCHAR2(10) NOT NULL Delivery ID