EM_PO_VCHR_VW

(SQL View)
Index Back

PO Invoice View

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

SELECT B.BUSINESS_UNIT_PO , B.PO_ID , B.LINE_NBR , B.SCHED_NBR , A.INVOICE_ID , A.BUSINESS_UNIT , 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 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
4 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
5 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
6 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit
7 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
8 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
9 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
10 QTY_VCHR Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Vouchered
11 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
12 UNIT_PRICE Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price
13 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
14 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency