INV_RSV_DTL_EVW

(SQL View)
Index Back

Inventory Reserve Details

EIP segment containing detail information within a reservations fulfillment request group (such as a line on an order). /* 06/09/2004 pwf Change reference from SCHED_LINE_NO to SCHED_LINE_NBR */

SELECT EIP_TRANS_SRC_SEQ , DEVICE_DTTIME , EXCLUDE_FLG , SL_DEMAND_SOURCE , SL_SOURCE_BUS_UNIT , SL_ORDER_NO , TO_ORDER_NO , SL_ORDER_INT_LINE , TO_ORDER_INT_LINE , SL_SCHED_LINE_NBR , TO_SCHED_LINE_NBR , SL_INV_ITEM_ID , SL_DEMAND_LINE_NO , SL_SHIP_TO_CUST_ID , SL_CUST_ID , SL_ADDRESS_SEQ_NUM , SL_LOCATION , SL_LOAD_ID , SL_SHIP_TYPE_ID , TO_SHIP_TYPE_ID , SL_CARRIER_ID , TO_CARRIER_ID , SL_ROUTE_CD , SL_WAVE_CD , TO_WAVE_CD , SL_PRODUCT_ID , SL_DEMAND_DATE , TO_DEMAND_DATE , SL_SCHED_SHIP_DATE , SL_SCHED_SHIP_TIME , TO_SCHED_SHIP_DATE , TO_SCHED_SHIP_TIME , SL_SHIP_EARLY_DATE , SL_SHIP_EARLY_TIME , TO_SHIP_EARLY_DATE , TO_SHIP_EARLY_TIME , SL_CUSTOMER_PO , SL_CNTRCT_ID , SL_PRIORITY_NBR , TO_PRIORITY_NBR , SL_PARENT_PROD_ID , AUTO_PICK_SEL , AUTO_SHIP_SEL , QTY , UNIT_OF_MEASURE FROM PS_INV_FUL_DTL_EC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EIP_TRANS_SRC_SEQ Number(15,0) DECIMAL(15) NOT NULL Source Transaction Sequence
2 DEVICE_DTTIME DateTime(26) TIMESTAMP Device Date Time
3 EXCLUDE_FLG Character(1) VARCHAR2(1) NOT NULL Indicates a line of a request fed to the Fulfillment Engine should be excluded from the selection instead of included.
4 SL_DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source selection
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Sourced Demand
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order Demand
5 SL_SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Business Unit selection
6 SL_ORDER_NO Character(10) VARCHAR2(10) NOT NULL Order Number selection
7 TO_ORDER_NO Character(10) VARCHAR2(10) NOT NULL Order Number selection
8 SL_ORDER_INT_LINE Number(5,0) INTEGER NOT NULL Order Line selection
9 TO_ORDER_INT_LINE Number(5,0) INTEGER NOT NULL Order Line selection
10 SL_SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL 05/07/04 PWF Added field for new 8.9 data model changes
11 TO_SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL 05/07/04 PWF Added field for 8.9 data model changes
12 SL_INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item selection
13 SL_DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line Number selection
14 SL_SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer selection
15 SL_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer ID selection
16 SL_ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number selection
17 SL_LOCATION Character(10) VARCHAR2(10) NOT NULL Location selection
18 SL_LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load selection
19 SL_SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via selection
20 TO_SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via selection
21 SL_CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier selection
22 TO_CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier selection
23 SL_ROUTE_CD Character(6) VARCHAR2(6) NOT NULL Route selection
24 SL_WAVE_CD Character(6) VARCHAR2(6) NOT NULL Route Group selection
25 TO_WAVE_CD Character(6) VARCHAR2(6) NOT NULL Route Group selection
26 SL_PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product selection
27 SL_DEMAND_DATE Date(10) DATE Demand Date selection
28 TO_DEMAND_DATE Date(10) DATE Demand Date selection
29 SL_SCHED_SHIP_DATE Date(10) DATE Scheduled Ship Date selection
30 SL_SCHED_SHIP_TIME Time(15) TIMESTAMP Scheduled Ship Time
31 TO_SCHED_SHIP_DATE Date(10) DATE Scheduled Ship Date selection
32 TO_SCHED_SHIP_TIME Time(15) TIMESTAMP Scheduled Ship Time selection
33 SL_SHIP_EARLY_DATE Date(10) DATE Ship Early Date selection
34 SL_SHIP_EARLY_TIME Time(15) TIMESTAMP Ship Early Time selection
35 TO_SHIP_EARLY_DATE Date(10) DATE Ship Early Date selection
36 TO_SHIP_EARLY_TIME Time(15) TIMESTAMP Ship Early Time selection
37 SL_CUSTOMER_PO Character(25) VARCHAR2(25) NOT NULL Customer Purchase Order selection
38 SL_CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Contract ID selection
39 SL_PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority
40 TO_PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority
41 SL_PARENT_PROD_ID Character(18) VARCHAR2(18) NOT NULL Parent Product Id
42 AUTO_PICK_SEL Character(1) VARCHAR2(1) NOT NULL The field is used to select the auto pick options for fulfillment.
0=Use Default Values
1=Override to "Yes"
2=Override to "No"
43 AUTO_SHIP_SEL Character(1) VARCHAR2(1) NOT NULL Used to capture the auto ship options for fulfillment.
0=Use Default Values
1=Override to "Yes"
2=Override to "No"
44 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
45 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage