IN_DMD_VWD

(SQL View)
 Index Back

IN View of Demand_Inf_Inv

Used for updated Demand_Inf_Inv in Stock Request Change panel.

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 , a.orig_sched_dttm , a.sched_arrv_dttm , a.sched_dttm , a.load_id , a.carrier_id , a.ship_type_id , a.ship_early_dttm , a.ship_late_dttm , a.freight_terms , a.priority_nbr , a.distrib_type , a.pick_batch_id , a.picklist_line_no , a.product_id , a.parent_prod_id , a.kit_line_nbr , a.charge_flag , a.cntrct_id , a.destin_gl_bu , a.ferc_cd , a.interunit_id , a.interunit_line , a.interunit_stat , a.interunit_flg , a.inv_item_alias , a.price_markup_pct , a.cust_id , a.cust_name , a.ship_to_cust_id , a.ship_cust_name1 , a.ship_cust_name2 , a.location , a.address_seq_num , a.tax_exempt_flg , a.exp_return_date , a.transfer_cost , a.packaging_cd , a.currency_cd , a.qty_requested , a.qty_requested_base , a.qty_allocated , a.qty_alloc_base , a.qty_backorder , a.qty_backorder_base , a.qty_pick_ovride , a.ship_prior_flg , a.bckordr_cncl_flag , a.bckorder_flag , a.partial_qty_flag , a.partial_order_flag , a.frozen_flg , a.unit_of_measure , a.lot_alloc_flg , a.config_code , a.direct_invoicing , a.route_cd , a.route_stop_nbr , 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.allow_overpick_flg , a.max_pick_tolerance , A.SINGLE_SHIP_FLAG , A.REASON_CD FROM PS_IN_DEMAND a , ps_ord_schedule c , ps_ord_line L , ps_ordent_pitem_vw p , ps_set_cntrl_rec sc WHERE c.business_unit = a.source_bus_unit AND a.order_no = c.order_no AND a.business_unit = c.ship_from_bu AND a.order_int_line_no = c.order_int_line_no AND a.sched_line_nbr = c.sched_line_nbr AND L.business_unit = c.business_unit AND L.order_no = c.order_no AND L.order_int_line_no = c.order_int_line_no AND p.product_id = L.product_id AND p.inventory_item = 'Y' AND p.setid = sc.setid AND sc.setcntrlvalue = l.business_unit AND sc.recname = 'PROD_ITEM'

# 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

Prompt Table: SP_BU_FS_NONVW

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 AUTO_TYPE Character(3) VARCHAR2(3) NOT NULL Number Type
10 DEMAND_DATE Date(10) DATE Demand Date

Default Value: %date

11 REQUEST_DATE Date(10) DATE Requested

Default Value: %date

12 CANCEL_DTTM DateTime(26) TIMESTAMP Dttm demand line was canceled
13 ORIG_SCHED_DTTM DateTime(26) TIMESTAMP Original Schedule Date/Time
14 SCHED_ARRV_DTTM DateTime(26) TIMESTAMP Schedule Arrival Dt/Tm
15 SCHED_DTTM DateTime(26) TIMESTAMP 08/16/01 JNW (CN#PL900-1.0): Added
16 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID

Prompt Table: LOAD_INV_OPN_VW

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

Prompt Table: CARRIER_ID

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

Prompt Table: SHIP_METHOD

19 SHIP_EARLY_DTTM DateTime(26) TIMESTAMP Earliest Ship Date/Time
20 SHIP_LATE_DTTM DateTime(26) TIMESTAMP Latest Ship Date/Time
21 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code

Prompt Table: FREIGHT_TERMS

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

Default Value: 999

23 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type

Prompt Table: CM_DISTR_TYPE

24 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID
25 PICKLIST_LINE_NO Number(7,0) INTEGER NOT NULL Pick List Sorting Line Number
26 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
27 PARENT_PROD_ID Character(18) VARCHAR2(18) NOT NULL Parent Product Id
28 KIT_LINE_NBR Number(3,0) SMALLINT NOT NULL Kit Line Number
29 CHARGE_FLAG Character(1) VARCHAR2(1) NOT NULL Charged Out

Y/N Table Edit

Default Value: N

30 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
31 DESTIN_GL_BU Character(5) VARCHAR2(5) NOT NULL Destination GL Business Unit

Prompt Table: SP_BU_GL_NONVW

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

Prompt Table: FERC_CD_TBL

33 INTERUNIT_ID Character(10) VARCHAR2(10) NOT NULL InterUnit Order ID
34 INTERUNIT_LINE Number(5,0) INTEGER NOT NULL InterUnit Order Line
35 INTERUNIT_STAT Character(1) VARCHAR2(1) NOT NULL InterUnit Status
C=Cancelled
I=In-Transit
O=Open
P=Picked
R=Received

Default Value: O

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

Y/N Table Edit

Default Value: N

37 INV_ITEM_ALIAS Character(18) VARCHAR2(18) NOT NULL Item Alias
38 PRICE_MARKUP_PCT Signed Number(16,2) DECIMAL(14,2) NOT NULL Price Markup %
39 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.

Prompt Table: %EDITTABLE

40 CUST_NAME Character(40) VARCHAR2(40) NOT NULL Name
41 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

Prompt Table: %EDITTABLE2

42 SHIP_CUST_NAME1 Character(40) VARCHAR2(40) NOT NULL Ship To Name
43 SHIP_CUST_NAME2 Character(40) VARCHAR2(40) NOT NULL Ship To Name 2
44 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: %EDITTABLE4

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

Prompt Table: %EDITTABLE3

46 TAX_EXEMPT_FLG Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag

Y/N Table Edit

Default Value: Y

47 EXP_RETURN_DATE Date(10) DATE Return Date
48 TRANSFER_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Transfer Price
49 PACKAGING_CD Character(4) VARCHAR2(4) NOT NULL Packaging Code

Prompt Table: PACKAGNG_CD_INV

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

Prompt Table: CURRENCY_CD_TBL

51 QTY_REQUESTED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested
52 QTY_REQUESTED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested Base
53 QTY_ALLOCATED Signed Number(17,4) DECIMAL(15,4) NOT NULL Allocated quantity
54 QTY_ALLOC_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity allocation
55 QTY_BACKORDER Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Qty
56 QTY_BACKORDER_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Base Qty
57 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.
58 SHIP_PRIOR_FLG Character(1) VARCHAR2(1) NOT NULL Ship Prior to Sched Date

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: Y

64 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

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

Y/N Table Edit

Default Value: N

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

Prompt Table: CP_CONFIG_VW

67 DIRECT_INVOICING Character(1) VARCHAR2(1) NOT NULL Direct Invoicing

Y/N Table Edit

Default Value: N

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

Prompt Table: ROUTE_INV_VW

69 ROUTE_STOP_NBR Number(5,0) INTEGER NOT NULL An identifier used to sequence customer addresses/location for a given route.
70 EXPORT Character(1) VARCHAR2(1) NOT NULL Export Analytic Instance
N=No
Y=Yes

Y/N Table Edit

Default Value: N

71 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

72 IST_RETURN_FLG_IUT Character(1) VARCHAR2(1) NOT NULL Intrastat InterUnit Returns
73 IST_TXN_FLG Character(1) VARCHAR2(1) NOT NULL Intrastat Transaction Flag
N=No
Y=Yes

Default Value: N

74 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.
75 ORIG_UOM Character(3) VARCHAR2(3) NOT NULL Original Unit of Measure
76 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

77 ALLOW_OVERPICK_FLG Character(1) VARCHAR2(1) NOT NULL Used to indicate whether or not overpicking is allowed for a customer or business unit.
78 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.
79 SINGLE_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Single Ship Flag
N=No
Y=Yes

Y/N Table Edit

Default Value: N

80 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code