VCHR_MM_PO_VW

(SQL View)
 Index Back

Match Manager PO View


SELECT DISTINCT A.BUSINESS_UNIT_AP , A.VOUCHER_ID , A.VOUCHER_LINE_NUM , A.BUSINESS_UNIT , A.PO_ID , A.LINE_NBR , A.SCHED_NBR , E.PYMNT_TERMS_CD , E.VENDOR_SETID , E.VENDOR_ID , E.VNDR_LOC , D.ITM_SETID , D.INV_ITEM_ID , D.QTY_VCHR , A.UOM_VCHR , A.UNIT_PRICE , E.TXN_CURRENCY_CD , A.MERCH_AMT_VCHR , B.PYMNT_TERMS_CD , B.VENDOR_SETID , B.VENDOR_ID , B.VNDR_LOC , C.ITM_SETID , C.INV_ITEM_ID , A.QTY_PO , C.UNIT_OF_MEASURE , A.PRICE_PO , B.CURRENCY_CD , A.MERCH_AMT_PO , B.PO_DT , B.MATCH_STATUS_PO , B.BUYER_ID , C.RECV_REQ , B.MATCH_CNTRL_ID , C.INSPECT_CD , E.ACCOUNTING_DT , E.DUE_DT , E.ENTERED_DT , E.INVOICE_DT , E.INVOICE_ID , E.MATCH_STATUS_VCHR , F.VENDOR_NAME_SHORT , E.VOUCHER_STYLE , C.AMT_ONLY_FLG FROM PS_PO_LINE_MATCHED A , PS_PO_HDR_FS B , PS_PO_LINE C , PS_VOUCHER_LINE D , PS_VOUCHER E , PS_VENDOR F WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PO_ID = B.PO_ID AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.PO_ID = C.PO_ID AND A.LINE_NBR = C.LINE_NBR AND A.BUSINESS_UNIT_AP = D.BUSINESS_UNIT AND A.VOUCHER_ID = D.VOUCHER_ID AND A.VOUCHER_LINE_NUM = D.VOUCHER_LINE_NUM AND A.BUSINESS_UNIT_AP = E.BUSINESS_UNIT AND A.VOUCHER_ID = E.VOUCHER_ID AND E.VENDOR_SETID = F.SETID AND E.VENDOR_ID = F.VENDOR_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
3 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
4 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
5 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
6 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
7 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
8 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
9 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
10 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
11 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
12 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
13 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
14 QTY_VCHR Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Vouchered
15 UOM_VCHR Character(3) VARCHAR2(3) NOT NULL Unit Of Measure Voucher
16 UNIT_PRICE Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price
17 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
18 MERCH_AMT_VCHR Signed Number(28,3) DECIMAL(26,3) NOT NULL Voucher Merchandise Amount
19 PYMNT_TERMS_CD_PO Character(5) VARCHAR2(5) NOT NULL PO Payment Terms
20 VNDR_SETID_PO Character(5) VARCHAR2(5) NOT NULL Supplier setid PO
21 VENDOR_PO Character(10) VARCHAR2(10) NOT NULL Supplier ID PO
22 VNDR_LOC_PO Character(10) VARCHAR2(10) NOT NULL Supplier Location PO
23 ITM_SETID_PO Character(5) VARCHAR2(5) NOT NULL Item setid PO
24 INV_ITEM_ID_PO Character(18) VARCHAR2(18) NOT NULL Item Number PO
25 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
26 UOM_PO Character(3) VARCHAR2(3) NOT NULL Unit Of Measure PO
27 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price
28 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

29 MERCH_AMT_PO Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amount
30 PO_DT Date(10) DATE Date
31 MATCH_STATUS_PO Character(1) VARCHAR2(1) NOT NULL Match Status
M=Matched
N=Not Required
P=Partially Matched
T=To Match
32 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
33 RECV_REQ Character(1) VARCHAR2(1) NOT NULL Receiving Required
N=Optional
X=Do Not
Y=Required
34 MATCH_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Match Rule
35 INSPECT_CD Character(1) VARCHAR2(1) NOT NULL Inspection Required
N=No
Y=Yes
36 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
37 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
38 ENTERED_DT Date(10) DATE Entered on
39 INVOICE_DT Date(10) DATE Invoice Date
40 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
41 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
42 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
43 VOUCHER_STYLE Character(4) VARCHAR2(4) NOT NULL Voucher Style
ADJ=Adjustments
AMR=Amortization Voucher
CLBK=Claim Voucher
CORR=Reversal Voucher
JRNL=Journal Voucher
PPAY=Prepaid Voucher
REG=Regular Voucher
RGTR=Register Voucher
SGLP=Single Payment Voucher
THRD=Third Party Voucher
TMPL=Template Voucher
44 AMT_ONLY_FLG Character(1) VARCHAR2(1) NOT NULL Amount Only
N=No
Y=Yes