REQ_INQ_IUT_VW

(SQL View)
 Index Back

SELECT DISTINCT A.BUSINESS_UNIT , B.INTERUNIT_ID , B.INTERUNIT_LINE , A.INV_RECV_STATUS , A.RECEIPT_TYPE , B.RECEIVER_ID , B.RECV_LN_NBR , B.INV_ITEM_ID , B.INV_RECVLN_STATUS , B.QTY_INV_RECV , B.QTY_STD , B.UNIT_OF_MEASURE FROM PS_INV_RECV_HDR A , PS_INV_RECV_LN B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.RECEIVER_ID = B.RECEIVER_ID AND A.RECEIPT_TYPE = 'IUT'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 INTERUNIT_ID Character(10) VARCHAR2(10) NOT NULL InterUnit Order ID
3 INTERUNIT_LINE Number(5,0) INTEGER NOT NULL InterUnit Order Line
4 INV_RECV_STATUS Character(1) VARCHAR2(1) NOT NULL Receipt Status
C=Closed
O=Open
P=Pending
5 RECEIPT_TYPE Character(4) VARCHAR2(4) NOT NULL Receipt Type
IUT=Interunit Transfer
RMA=Return Material Authorization
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_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
9 INV_RECVLN_STATUS Character(1) VARCHAR2(1) NOT NULL Receipt Line Status
C=Closed
O=Open
P=Pending
10 QTY_INV_RECV Number(16,4) DECIMAL(15,4) NOT NULL Quantity Received
11 QTY_STD Number(16,4) DECIMAL(15,4) NOT NULL Standard Quantity
12 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage