IN_IL_ER_DT_EVW

(SQL View)
 Index Back

Internal Location Detail

Internal Location Expected Receipts Detail Stage Record

SELECT A.EIP_CTL_ID ,A.BUSINESS_UNIT , A.LOCATION , A.SHIP_ID , A.SHIP_LINE_NO , A.SETID , A.INV_ITEM_ID , A.DESCR , A.UNIT_OF_MEASURE , A.CURRENCY_CD , A.FREIGHT_TERMS , A.SHIP_TYPE_ID , A.CARRIER_ID , A.REQUEST_DATE , A.ORIG_SCHED_DATE , A.ORIG_SCHED_TIME , A.SCHED_DATE , A.SCHED_TIME , A.LOAD_ID , A.SCHED_ARRV_DTTM , A.QTY_REQUESTED , A.QTY_SHIPPED_CONV , A.QTY_SHIP_BASE , A.UNIT_MEASURE_SHIP , A.DEMAND_SOURCE , A.SOURCE_BUS_UNIT , A.ORDER_NO , A.ORDER_INT_LINE_NO , A.SCHED_LINE_NBR , A.DEMAND_LINE_NO , A.DEMAND_DATE , A.REQ_ID , A.REQ_LINE_NBR , A.REQ_SCHED_NBR , A.REQ_DISTRIB_NBR , A.PRO_NUMBER , A.ORDER_UOM_RATE , A.SHIP_UOM_RATE , A.UNIT_MEASURE_STD FROM PS_IN_IL_ER_DTL_EC A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
4 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID
5 SHIP_LINE_NO Number(10,2) DECIMAL(9,2) NOT NULL Ship Line No
6 SETID Character(5) VARCHAR2(5) NOT NULL SetID
7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
9 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
11 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
12 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
13 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
14 REQUEST_DATE Date(10) DATE Requested
15 ORIG_SCHED_DATE Date(10) DATE Orig Sched Date
16 ORIG_SCHED_TIME Time(15) TIMESTAMP Original Schedule Time
17 SCHED_DATE Date(10) DATE Schedule Date
18 SCHED_TIME Time(15) TIMESTAMP Schedule Time
19 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID
20 SCHED_ARRV_DTTM DateTime(26) TIMESTAMP Schedule Arrival Dt/Tm
21 QTY_REQUESTED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested
22 QTY_SHIPPED_CONV Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
23 QTY_SHIP_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Ship Base
24 UNIT_MEASURE_SHIP Character(3) VARCHAR2(3) NOT NULL Shipment Unit of Measure
25 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
26 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
27 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
28 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
29 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
30 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
31 DEMAND_DATE Date(10) DATE Demand Date
32 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
33 REQ_LINE_NBR Number(5,0) INTEGER NOT NULL Requisition Line Number
34 REQ_SCHED_NBR Number(3,0) SMALLINT NOT NULL Requisition Schedule Number
35 REQ_DISTRIB_NBR Number(5,0) INTEGER NOT NULL Requisition Distrib Number
36 PRO_NUMBER Character(40) VARCHAR2(40) NOT NULL Pro Number
37 ORDER_UOM_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Order UOM Conversion Rate
38 SHIP_UOM_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Order UOM Conversion Rate
39 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure