VCHR_LN_PO_VW

(SQL View)
 Index Back

PO Line Vouchered View

Date Initials Reference# Description 09/15/2011 JAMANI 12675275 Added an new qty invoiced field so that quantity invoiced is shown correctly on purchase order activity summary page. 20/12/2011 SRINI 13028239 The quantity invoiced and amount invoiced is shown correctly on purchase order activity summary page. 01/25/2012 JAMANI 13545345 Ensured that the quantity invoiced is converted into purchase order UOM in Activity summary page. 01/12/2022 Nash 32304591 We ensured that PO Activity Summary is accounting for closed vouchers. Added a field CLOSE_STATUS

SELECT L.BUSINESS_UNIT_PO , L.PO_ID , L.LINE_NBR , L.SCHED_NBR , L.BUSINESS_UNIT_RECV , L.RECEIVER_ID , L.RECV_LN_NBR , L.RECV_SHIP_SEQ_NBR , L.BUSINESS_UNIT , L.VOUCHER_ID , L.VOUCHER_LINE_NUM , %Round(L.QTY_VCHR, 2) , L.UNIT_OF_MEASURE , L.MERCHANDISE_AMT , L.TXN_CURRENCY_CD , V.INVOICE_ID , V.INVOICE_DT , L.CURRENCY_CD , L.QTY_VCHR , L.MERCH_AMT_BSE , V.CLOSE_STATUS FROM PS_VOUCHER_LINE L , PS_VOUCHER V WHERE V.BUSINESS_UNIT = L.BUSINESS_UNIT AND V.VOUCHER_ID = L.VOUCHER_ID AND L.BUSINESS_UNIT_PO <> ' ' AND L.PO_ID <> ' ' AND V.ENTRY_STATUS <> 'X' AND V.VOUCHER_STYLE <> 'THRD' AND (V.MANUAL_CLOSE_DT IS NULL OR EXISTS ( SELECT 'X' FROM PS_PYMNT_VCHR_XREF X WHERE X.BUSINESS_UNIT = V.BUSINESS_UNIT AND X.VOUCHER_ID = V.VOUCHER_ID AND X.PYMNT_SELCT_STATUS <> 'X'))

# 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 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving 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 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
9 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit
10 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
11 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
12 QTY_INVOICED Signed Number(16,2) DECIMAL(14,2) NOT NULL Quantity Invoiced
13 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Prompt Table: UNITS_TBL

14 AMT_INVOICED Number(27,3) DECIMAL(26,3) NOT NULL Amount Invoiced
15 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
16 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
17 INVOICE_DT Date(10) DATE Invoice Date
18 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
19 INVOICED_QTY_PO Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Invoiced
20 MERCH_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Merchandise Amount
21 CLOSE_STATUS Character(1) VARCHAR2(1) NOT NULL Close Status Indicator
C=Closed
O=Open