IN_IUVMI_DT_EVW

(SQL View)
 Index Back

VMI Expected Receipts Detail

VMI Interunit Expected Receipts Detail Stage Table

SELECT A.EIP_CTL_ID , A.BUSINESS_UNIT , A.DESTIN_BU , A.LOCATION , A.INTERUNIT_ID , A.INTERUNIT_LINE , A.INTERUNIT_STAT , A.SETID , A.INV_ITEM_ID , A.DESCR , %subrec(ADDRESS_SBR,A) , 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.SHIP_ID , A.SHIP_LINE_NO , A.UNIT_MEASURE_SHIP , A.TRANSFER_YIELD , 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 , A.PRODUCT_ID FROM PS_IN_IUVMI_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 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit
4 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
5 INTERUNIT_ID Character(10) VARCHAR2(10) NOT NULL InterUnit Order ID
6 INTERUNIT_LINE Number(5,0) INTEGER NOT NULL InterUnit Order Line
7 INTERUNIT_STAT Character(1) VARCHAR2(1) NOT NULL InterUnit Status
C=Cancelled
I=In-Transit
O=Open
P=Picked
R=Received
8 SETID Character(5) VARCHAR2(5) NOT NULL SetID
9 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
11 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

12 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
13 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
14 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
15 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
16 CITY Character(30) VARCHAR2(30) NOT NULL City
17 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
18 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
19 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer
20 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
21 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
22 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
23 COUNTY Character(30) VARCHAR2(30) NOT NULL County
24 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: %EDIT_STATE

25 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
26 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
27 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

28 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
29 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
30 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
31 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
32 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
33 REQUEST_DATE Date(10) DATE Requested
34 ORIG_SCHED_DATE Date(10) DATE Orig Sched Date
35 ORIG_SCHED_TIME Time(15) TIMESTAMP Original Schedule Time
36 SCHED_DATE Date(10) DATE Schedule Date
37 SCHED_TIME Time(15) TIMESTAMP Schedule Time
38 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID
39 SCHED_ARRV_DTTM DateTime(26) TIMESTAMP Schedule Arrival Dt/Tm
40 QTY_REQUESTED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested
41 QTY_SHIPPED_CONV Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
42 QTY_SHIP_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Ship Base
43 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID
44 SHIP_LINE_NO Number(10,2) DECIMAL(9,2) NOT NULL Ship Line No
45 UNIT_MEASURE_SHIP Character(3) VARCHAR2(3) NOT NULL Shipment Unit of Measure
46 TRANSFER_YIELD Number(5,1) DECIMAL(4,1) NOT NULL Transfer Yield
47 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
48 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
49 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
50 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
51 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
52 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
53 DEMAND_DATE Date(10) DATE Demand Date
54 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
55 REQ_LINE_NBR Number(5,0) INTEGER NOT NULL Requisition Line Number
56 REQ_SCHED_NBR Number(3,0) SMALLINT NOT NULL Requisition Schedule Number
57 REQ_DISTRIB_NBR Number(5,0) INTEGER NOT NULL Requisition Distrib Number
58 PRO_NUMBER Character(40) VARCHAR2(40) NOT NULL Pro Number
59 ORDER_UOM_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Order UOM Conversion Rate
60 SHIP_UOM_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Order UOM Conversion Rate
61 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
62 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID