DEMAND_CNCRS_VW

(SQL View)
 Index Back

Demand Cancel Reserved View

06/18/04 SLG Changed SCHED_LINE_NO --> SCHED_LINE_NBR 09/15/04 TW 8.9 Data model change.

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.AUTO_TYPE , A.DEMAND_DATE , A.REQUEST_DATE , A.CANCEL_DTTM , %DatePart(A.SCHED_DTTM) , %TimePart(A.SCHED_DTTM) , %DatePart(A.ORIG_SCHED_DTTM) , %TimePart(A.ORIG_SCHED_DTTM) , A.SCHED_ARRV_DTTM , A.ORIG_BU , A.DESTIN_BU , A.TRANSFER_YIELD , A.DATE_LAST_MAINT , A.LAST_MAINT_OPRID , A.SHIP_TYPE_ID , %DatePart(A.SHIP_EARLY_DTTM) , %TimePart(A.SHIP_EARLY_DTTM) , %DatePart(A.SHIP_LATE_DTTM) , %TimePart(A.SHIP_LATE_DTTM) , A.FREIGHT_TERMS , A.PRIORITY_NBR , A.DISTRIB_TYPE , A.PICK_BATCH_ID , A.PICKLIST_LINE_NO , A.REQ_ID , A.REQ_LINE_NBR , A.REQ_SCHED_NBR , A.REQ_DISTRIB_NBR , A.PRODUCT_ID , A.PARENT_PROD_ID , A.KIT_LINE_NBR , A.CNTRCT_ID , A.INTERUNIT_ID , A.INTERUNIT_FLG , A.INV_ITEM_ALIAS , A.PRICE_MARKUP_PCT , 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.TAX_EXEMPT_FLG , A.EXP_RETURN_DATE , A.ORIG_OPRID , A.TRANSFER_COST , A.PACKAGING_CD , A.CURRENCY_CD , A.QTY_REQUESTED , A.QTY_REQUESTED_BASE , A.QTY_ALLOCATED , A.QTY_PICKED , A.QTY_BACKORDER , A.QTY_BACKORDER_BASE , A.QTY_PACK_BASE , A.FULFILL_FLAG , A.RESERVE_STATUS , A.CONFIRMED_FLAG , A.APPROVED_FLAG , A.SHIP_PRIOR_FLG , A.BCKORDR_CNCL_FLAG , A.BCKORDER_FLAG , A.CHARGE_FLAG , A.FERC_CD , A.QTY_ALLOC_BASE , A.CHARGE_CODE , A.HARD_ALLOC_FLAG , A.LOT_ALLOC_FLG , A.LAST_PROCESS_INST , A.CUSTODIAN , A.DISTRIB_FLAG , A.PARTIAL_QTY_FLAG , A.PARTIAL_ORDER_FLAG , A.FROZEN_FLG , A.PICKLIST_PRINTED , A.UNIT_OF_MEASURE , A.DT_TIMESTAMP , A.CONFIG_CODE , A.DIRECT_INVOICING , A.HOLD_FLAG , A.HOLD_CD , A.CARTON_PRINTED , A.SHIPPING_PRINTED , A.ROUTE_CD , A.ROUTE_STOP_NBR , A.PICK_RELEASE_ID , A.QTY_PICK_OVRIDE , A.BUDGET_DT , A.EXPORT , A.REPLACEMENT_FLG , A.IST_RETURN_FLG_IUT , A.IST_TXN_FLG , A.ORIG_INV_ITEM_ID , A.ORIG_UOM , A.ALLOW_SUB_ITEM_FLG , A.FRT_CHRG_OVERRIDE , A.FRT_CHRG_METHOD , A.FRT_RULE_CD , A.SHIP_ID_EST , A.NET_UNIT_PRICE , A.ALLOW_OVERPICK_FLG , A.MAX_PICK_TOLERANCE , A.SINGLE_SHIP_FLAG , A.SHIP_ID , A.SHIP_LINE_NO , %DatePart(A.SHIP_DTTM) , %TimePart(A.SHIP_DTTM) , A.BILL_OF_LADING , A.PRO_NUMBER , A.EXT_REF_NBR , A.EXT_REF_LN_NBR , A.TRANSFER_CALC_TYPE , A.TMS_EXT_REF_ID , A.TMS_EXT_REF_LN_NBR , A.TMS_PROCESS_FLG , A.TMS_LOAD_STP_NBR , A.UPDATE_RESTRCT_LVL , A.IN_FULFILL_STATE , A.SCHED_DTTM , A.SHIP_DTTM , A.IN_PRIOR_STATE , A.IN_PROCESS_DATE , A.INTERUNIT_STAT , A.FSS_ACTIVITY_DT FROM PS_IN_DEMAND A WHERE A.IN_FULFILL_STATE IN ('30','40')

# 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: BU_ITM_INV_VW2

8 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
9 AUTO_TYPE Character(3) VARCHAR2(3) NOT NULL Number Type
10 DEMAND_DATE Date(10) DATE Demand Date
11 REQUEST_DATE Date(10) DATE Requested
12 CANCEL_DTTM DateTime(26) TIMESTAMP Dttm demand line was canceled
13 SCHED_DATE Date(10) DATE Schedule Date
14 SCHED_TIME Time(15) TIMESTAMP Schedule Time
15 ORIG_SCHED_DATE Date(10) DATE Orig Sched Date
16 ORIG_SCHED_TIME Time(15) TIMESTAMP Original Schedule Time
17 SCHED_ARRV_DTTM DateTime(26) TIMESTAMP Schedule Arrival Dt/Tm
18 ORIG_BU Character(5) VARCHAR2(5) NOT NULL Original Business Unit
19 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit
20 TRANSFER_YIELD Number(5,1) DECIMAL(4,1) NOT NULL Transfer Yield
21 DATE_LAST_MAINT Date(10) DATE Date Last Maintained
22 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
23 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code

Prompt Table: SHIP_METHOD

24 SHIP_EARLY_DATE Date(10) DATE Earliest Ship Date
25 SHIP_EARLY_TIME Time(15) TIMESTAMP Earliest Ship Time
26 SHIP_LATE_DATE Date(10) DATE Latest Ship Date
27 SHIP_LATE_TIME Time(15) TIMESTAMP Latest Ship Time
28 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code

Prompt Table: FREIGHT_TERMS

29 PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority
30 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type

Prompt Table: CM_DISTR_TYPE

31 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID
32 PICKLIST_LINE_NO Number(7,0) INTEGER NOT NULL Pick List Sorting Line Number
33 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
34 REQ_LINE_NBR Number(5,0) INTEGER NOT NULL Requisition Line Number
35 REQ_SCHED_NBR Number(3,0) SMALLINT NOT NULL Requisition Schedule Number
36 REQ_DISTRIB_NBR Number(5,0) INTEGER NOT NULL Requisition Distrib Number
37 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
38 PARENT_PROD_ID Character(18) VARCHAR2(18) NOT NULL Parent Product Id
39 KIT_LINE_NBR Number(3,0) SMALLINT NOT NULL Kit Line Number
40 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
41 INTERUNIT_ID Character(10) VARCHAR2(10) NOT NULL InterUnit Order ID
42 INTERUNIT_FLG Character(1) VARCHAR2(1) NOT NULL InterUnit
N=No
Y=Yes

Y/N Table Edit

Default Value: N

43 INV_ITEM_ALIAS Character(18) VARCHAR2(18) NOT NULL Item Alias
44 PRICE_MARKUP_PCT Signed Number(16,2) DECIMAL(14,2) NOT NULL Price Markup %
45 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
46 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.
47 CUST_NAME Character(40) VARCHAR2(40) NOT NULL Name
48 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
49 SHIP_CUST_NAME1 Character(40) VARCHAR2(40) NOT NULL Ship To Name
50 SHIP_CUST_NAME2 Character(40) VARCHAR2(40) NOT NULL Ship To Name 2
51 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
52 TAX_EXEMPT_FLG Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag

Y/N Table Edit

53 EXP_RETURN_DATE Date(10) DATE Return Date
54 ORIG_OPRID Character(30) VARCHAR2(30) NOT NULL User ID
55 TRANSFER_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Transfer Price
56 PACKAGING_CD Character(4) VARCHAR2(4) NOT NULL Packaging Code
57 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
58 QTY_REQUESTED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested
59 QTY_REQUESTED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested Base
60 QTY_ALLOCATED Signed Number(17,4) DECIMAL(15,4) NOT NULL Allocated quantity
61 QTY_PICKED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Picked
62 QTY_BACKORDER Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Qty
63 QTY_BACKORDER_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Base Qty
64 QTY_PACK_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity Packed
65 FULFILL_FLAG Character(1) VARCHAR2(1) NOT NULL OK to Pick

Y/N Table Edit

Default Value: N

66 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
67 CONFIRMED_FLAG Character(1) VARCHAR2(1) NOT NULL Confirm
68 APPROVED_FLAG Character(1) VARCHAR2(1) NOT NULL Approved
B=Both
N=No
Y=Yes

Y/N Table Edit

Default Value: N

69 SHIP_PRIOR_FLG Character(1) VARCHAR2(1) NOT NULL Ship Prior to Sched Date

Y/N Table Edit

70 BCKORDR_CNCL_FLAG Character(1) VARCHAR2(1) NOT NULL Cancel Backorder
N=Cancel Backorder No
Y=Cancel Backorder Yes

Y/N Table Edit

71 BCKORDER_FLAG Character(1) VARCHAR2(1) NOT NULL Backorder Flag
N=No
Y=Yes
72 CHARGE_FLAG Character(1) VARCHAR2(1) NOT NULL Charged Out

Y/N Table Edit

73 FERC_CD Character(10) VARCHAR2(10) NOT NULL FERC Code

Prompt Table: FERC_CD_TBL

74 QTY_ALLOC_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity allocation
75 CHARGE_CODE Character(20) VARCHAR2(20) NOT NULL Charge Code
76 HARD_ALLOC_FLAG Character(1) VARCHAR2(1) NOT NULL Hard Allocate

Y/N Table Edit

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

Y/N Table Edit

Default Value: N

78 LAST_PROCESS_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance
79 CUSTODIAN Character(30) VARCHAR2(30) NOT NULL Custodian
80 DISTRIB_FLAG Character(1) VARCHAR2(1) NOT NULL GL Distribution

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

82 PARTIAL_ORDER_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Orders Can Ship
N=No
Y=Yes

Y/N Table Edit

Default Value: N

83 FROZEN_FLG Character(1) VARCHAR2(1) NOT NULL Frozen Flag
B=Both
N=No
Y=Yes

Y/N Table Edit

84 PICKLIST_PRINTED Character(1) VARCHAR2(1) NOT NULL Picklist Printed

Default Value: N

85 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: INV_ORDR_UOM_VW

86 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
87 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
88 DIRECT_INVOICING Character(1) VARCHAR2(1) NOT NULL Direct Invoicing

Y/N Table Edit

Default Value: N

89 HOLD_FLAG Character(1) VARCHAR2(1) NOT NULL Hold
N=Hold
Y=Hold

Y/N Table Edit

Default Value: N

90 HOLD_CD Character(6) VARCHAR2(6) NOT NULL Hold Code

Prompt Table: HOLD_CD

91 CARTON_PRINTED Character(1) VARCHAR2(1) NOT NULL Carton Print Flag

Y/N Table Edit

Default Value: N

92 SHIPPING_PRINTED Character(1) VARCHAR2(1) NOT NULL Shipping Container Print Flag

Y/N Table Edit

Default Value: N

93 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.
94 ROUTE_STOP_NBR Number(5,0) INTEGER NOT NULL An identifier used to sequence customer addresses/location for a given route.
95 PICK_RELEASE_ID Number(10,0) DECIMAL(10) NOT NULL Pick Release ID
96 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.
97 BUDGET_DT Date(10) DATE Budget Date
98 EXPORT Character(1) VARCHAR2(1) NOT NULL Export Analytic Instance
N=No
Y=Yes

Y/N Table Edit

Default Value: N

99 REPLACEMENT_FLG Character(2) VARCHAR2(2) NOT NULL Replacement Flag
NA=Not Applicable
RN=Replace Goods Not Returned
RR=Replacement of Returned Goods

Default Value: NA

100 IST_RETURN_FLG_IUT Character(1) VARCHAR2(1) NOT NULL Intrastat InterUnit Returns

Y/N Table Edit

Default Value: N

101 IST_TXN_FLG Character(1) VARCHAR2(1) NOT NULL Intrastat Transaction Flag
N=No
Y=Yes

Default Value: N

102 ORIG_INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Used to identify the original item ordered, in case an item substitution has taken place.
103 ORIG_UOM Character(3) VARCHAR2(3) NOT NULL Original Unit of Measure
104 ALLOW_SUB_ITEM_FLG Character(1) VARCHAR2(1) NOT NULL Used to indicate whether item substitutions are allowed on the order schedule.

Y/N Table Edit

Default Value: N

105 FRT_CHRG_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Freight Charge Override
106 FRT_CHRG_METHOD Character(2) VARCHAR2(2) NOT NULL Freight Charge Method
01=Order Value
02=Weight
03=Volume
04=Order Quantity
107 FRT_RULE_CD Character(10) VARCHAR2(10) NOT NULL Freight Rule Code
108 SHIP_ID_EST Character(10) VARCHAR2(10) NOT NULL Estimated Ship ID
109 NET_UNIT_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price
110 ALLOW_OVERPICK_FLG Character(1) VARCHAR2(1) NOT NULL Used to indicate whether or not overpicking is allowed for a customer or business unit.
111 MAX_PICK_TOLERANCE Number(6,2) DECIMAL(5,2) NOT NULL Used to indicate the allowable percentage of overshipment for a customer or business unit.
112 SINGLE_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Single Ship Flag
N=No
Y=Yes
113 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID
114 SHIP_LINE_NO Number(10,2) DECIMAL(9,2) NOT NULL Ship Line No
115 SHIP_DATE Date(10) DATE Item Shipping Date
116 SHIP_TIME Time(15) TIMESTAMP Ship Time
117 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
118 PRO_NUMBER Character(40) VARCHAR2(40) NOT NULL Pro Number
119 EXT_REF_NBR Number(10,0) DECIMAL(10) NOT NULL External Reference Number
120 EXT_REF_LN_NBR Number(5,0) INTEGER NOT NULL External Reference Line Number
121 TRANSFER_CALC_TYPE Character(1) VARCHAR2(1) NOT NULL Holds information regarding when the transfer price is calculated.
0=Calculate Cost at Depletions
1=Transfer at Zero Cost

Default Value: 0

122 TMS_EXT_REF_ID Character(10) VARCHAR2(10) NOT NULL TMS Reference ID
123 TMS_EXT_REF_LN_NBR Number(7,0) INTEGER NOT NULL TMS Line Number
124 TMS_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL TMS Process Flag

Default Value: N

125 TMS_LOAD_STP_NBR Number(5,0) INTEGER NOT NULL Load Stop Number
126 UPDATE_RESTRCT_LVL Character(1) VARCHAR2(1) NOT NULL This is a translate field that indicates the restriction level and is checked by online processes when the row is being updated by a background process.
127 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
128 SCHED_DTTM DateTime(26) TIMESTAMP 08/16/01 JNW (CN#PL900-1.0): Added
129 SHIP_DTTM DateTime(26) TIMESTAMP Ship Date/Time
130 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
131 IN_PROCESS_DATE Date(10) DATE Process Date
132 INTERUNIT_STAT Character(1) VARCHAR2(1) NOT NULL InterUnit Status
C=Cancelled
I=In-Transit
O=Open
P=Picked
R=Received
133 FSS_ACTIVITY_DT Date(10) DATE EGS 03/02/06: Created