DEM_INF_INV2_VW

(SQL View)
 Index Back

Inventory Demand Interface VW

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 , %DatePart(a.orig_sched_dttm) , %TimePart(a.orig_sched_dttm) , %DatePart(a.sched_dttm) , %TimePart(a.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.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.charge_flag , a.cntrct_id , a.destin_gl_bu , a.ferc_cd , 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_alloc_base , a.qty_backorder , a.qty_backorder_base , a.qty_pick_ovride , a.fulfill_flag , a.reserve_status , a.approved_flag , a.ship_prior_flg , a.bckordr_cncl_flag , a.bckorder_flag , a.custodian , a.charge_code , a.partial_qty_flag , a.partial_order_flag , a.unit_of_measure , a.lot_alloc_flg , a.last_process_inst , a.carrier_id , a.frozen_flg , a.interunit_line , a.interunit_stat , a.load_id , a.picklist_line_no , a.config_code , a.dt_timestamp , a.direct_invoicing , a.hold_flag , a.hold_cd , a.route_cd , a.route_stop_nbr , a.reserved_dttm , 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.REASON_CD , A.TRANSFER_CALC_TYPE , A.UPDATE_RESTRCT_LVL FROM PS_IN_DEMAND A WHERE A.IN_FULFILL_STATE = '20'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
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
8 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No

Default Value: 1

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 ORIG_SCHED_DATE Date(10) DATE Orig Sched Date
13 ORIG_SCHED_TIME Time(15) TIMESTAMP Original Schedule Time
14 SCHED_DATE Date(10) DATE NOT NULL Schedule Date
15 SCHED_TIME Time(15) TIMESTAMP Schedule Time
16 SCHED_ARRV_DTTM DateTime(26) TIMESTAMP Schedule Arrival Dt/Tm
17 ORIG_BU Character(5) VARCHAR2(5) NOT NULL Original Business Unit
18 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit
19 TRANSFER_YIELD Number(5,1) DECIMAL(4,1) NOT NULL Transfer Yield
20 DATE_LAST_MAINT Date(10) DATE Date Last Maintained
21 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
22 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code

Prompt Table: SHIP_METHOD

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

Prompt Table: FREIGHT_TERMS

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

Prompt Table: CM_DISTR_TYPE
Set Control Field: SETCNTRLVALUE

30 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID
31 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
32 REQ_LINE_NBR Number(5,0) INTEGER NOT NULL Requisition Line Number
33 REQ_SCHED_NBR Number(3,0) SMALLINT NOT NULL Requisition Schedule Number
34 REQ_DISTRIB_NBR Number(5,0) INTEGER NOT NULL Requisition Distrib Number
35 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
36 PARENT_PROD_ID Character(18) VARCHAR2(18) NOT NULL Parent Product Id
37 KIT_LINE_NBR Number(3,0) SMALLINT NOT NULL Kit Line Number
38 CHARGE_FLAG Character(1) VARCHAR2(1) NOT NULL Charged Out

Y/N Table Edit

Default Value: N

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

Prompt Table: SP_BU_GL_NONVW

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

Prompt Table: FERC_CD_TBL

42 INTERUNIT_ID Character(10) VARCHAR2(10) NOT NULL InterUnit Order ID
43 INTERUNIT_FLG Character(1) VARCHAR2(1) NOT NULL InterUnit
N=No
Y=Yes

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

54 EXP_RETURN_DATE Date(10) DATE Return Date
55 ORIG_OPRID Character(30) VARCHAR2(30) NOT NULL User ID
56 TRANSFER_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Transfer Price
57 PACKAGING_CD Character(4) VARCHAR2(4) NOT NULL Packaging Code

Prompt Table: PACKAGNG_CD_INV

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

Prompt Table: CURRENCY_CD_TBL

59 QTY_REQUESTED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested
60 QTY_REQUESTED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested Base
61 QTY_ALLOCATED Signed Number(17,4) DECIMAL(15,4) NOT NULL Allocated quantity
62 QTY_ALLOC_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity allocation
63 QTY_BACKORDER Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Qty
64 QTY_BACKORDER_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Base Qty
65 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.
66 FULFILL_FLAG Character(1) VARCHAR2(1) NOT NULL OK to Pick
67 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
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

Default Value: N

70 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

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

Y/N Table Edit

Default Value: N

72 CUSTODIAN Character(30) VARCHAR2(30) NOT NULL Custodian
73 CHARGE_CODE Character(20) VARCHAR2(20) NOT NULL Charge Code
74 PARTIAL_QTY_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Qtys Can Ship

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

76 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

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

Y/N Table Edit

78 LAST_PROCESS_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance
79 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID

Prompt Table: CARRIER_ID

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

Y/N Table Edit

81 INTERUNIT_LINE Number(5,0) INTEGER NOT NULL InterUnit Order Line
82 INTERUNIT_STAT Character(1) VARCHAR2(1) NOT NULL InterUnit Status
C=Cancelled
I=In-Transit
O=Open
P=Picked
R=Received
83 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID

Prompt Table: LOAD_INV

84 PICKLIST_LINE_NO Number(7,0) INTEGER NOT NULL Pick List Sorting Line Number
85 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
86 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
87 DIRECT_INVOICING Character(1) VARCHAR2(1) NOT NULL Direct Invoicing

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Prompt Table: HOLD_CD

90 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

91 ROUTE_STOP_NBR Number(5,0) INTEGER NOT NULL An identifier used to sequence customer addresses/location for a given route.
92 RESERVED_DTTM DateTime(26) TIMESTAMP Reserved Date/Time
93 BUDGET_DT Date(10) DATE Budget Date
94 EXPORT Character(1) VARCHAR2(1) NOT NULL Export Analytic Instance
N=No
Y=Yes

Y/N Table Edit

Default Value: N

95 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

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

Y/N Table Edit

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

Default Value: N

98 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.
99 ORIG_UOM Character(3) VARCHAR2(3) NOT NULL Original Unit of Measure
100 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

101 FRT_CHRG_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Freight Charge Override
102 FRT_CHRG_METHOD Character(2) VARCHAR2(2) NOT NULL Freight Charge Method
01=Order Value
02=Weight
03=Volume
04=Order Quantity
103 FRT_RULE_CD Character(10) VARCHAR2(10) NOT NULL Freight Rule Code
104 SHIP_ID_EST Character(10) VARCHAR2(10) NOT NULL Estimated Ship ID
105 NET_UNIT_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price
106 ALLOW_OVERPICK_FLG Character(1) VARCHAR2(1) NOT NULL Used to indicate whether or not overpicking is allowed for a customer or business unit.

Y/N Table Edit

Default Value: N

107 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.
108 SINGLE_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Single Ship Flag
N=No
Y=Yes

Y/N Table Edit

Default Value: N

109 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code
110 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

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