IN_IUT_RECV_VW

(SQL View)
 Index Back

SELECT L.BUSINESS_UNIT_IN , L.INTERUNIT_ID , L.SOURCE_BUS_UNIT , L.INTERUNIT_LINE , H.BUSINESS_UNIT , H.RECEIVER_ID , L.RECV_LN_NBR , L.INV_RECVLN_STATUS , L.QTY_INV_RECV , L.RECEIPT_DTTM , L.UNIT_OF_MEASURE FROM PS_INV_RECV_HDR H , PS_INV_RECV_LN L WHERE H.BUSINESS_UNIT = L.BUSINESS_UNIT AND H.RECEIVER_ID = L.RECEIVER_ID AND H.RECEIPT_TYPE = 'IUT'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit
2 INTERUNIT_ID Character(10) VARCHAR2(10) NOT NULL InterUnit Order ID
3 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
4 INTERUNIT_LINE Number(5,0) INTEGER NOT NULL InterUnit Order Line
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
6 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
7 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
8 INV_RECVLN_STATUS Character(1) VARCHAR2(1) NOT NULL Receipt Line Status
C=Closed
O=Open
P=Pending
9 QTY_INV_RECV Number(16,4) DECIMAL(15,4) NOT NULL Quantity Received
10 RECEIPT_DTTM DateTime(26) TIMESTAMP Receipt Datetime
11 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage