EM_RECV_VCHR_VW

(SQL View)
 Index Back

Receipt Invoice View

This view is used to display all relevant invoice information in regards to an a particular Receipt. It is used by the Market Pay Module

SELECT B.BUSINESS_UNIT_RECV , B.RECEIVER_ID , B.RECV_LN_NBR , B.RECV_SHIP_SEQ_NBR , A.INVOICE_ID , A.VOUCHER_ID , B.VOUCHER_LINE_NUM , A.MATCH_STATUS_VCHR , B.QTY_VCHR , B.UNIT_OF_MEASURE , B.UNIT_PRICE , B.MERCHANDISE_AMT , B.TXN_CURRENCY_CD FROM PS_VOUCHER A , PS_VOUCHER_LINE B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
3 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
4 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
5 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
6 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
7 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
8 MATCH_STATUS_VCHR Character(1) VARCHAR2(1) NOT NULL Match Status
C=Overridden - Credit Note
D=Match Dispute
E=Match Exceptions Exist
M=Matched
N=Not Applicable
O=Manually Overridden
T=To Be Matched
9 QTY_VCHR Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Vouchered
10 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
11 UNIT_PRICE Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price
12 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
13 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency