VCHR_MM_RECV_VW

(SQL View)
 Index Back

Match Manager Recv View


SELECT DISTINCT A.BUSINESS_UNIT_AP , A.VOUCHER_ID , A.VOUCHER_LINE_NUM , A.BUSINESS_UNIT , A.RECEIVER_ID , A.RECV_LN_NBR , A.RECV_SHIP_SEQ_NBR , E.VENDOR_SETID , E.VENDOR_ID , E.VNDR_LOC , D.ITM_SETID , D.INV_ITEM_ID , A.QTY_VCHR , A.UOM_VCHR , A.UNIT_PRICE , A.TXN_CURRENCY_CD , A.MERCH_AMT_VCHR , B.VENDOR_SETID , B.VENDOR_ID , B.VNDR_LOC , C.ITM_SETID , C.INV_ITEM_ID , c.QTY_SH_ACCPT , C.RECEIVE_UOM , C.PRICE_PO , A.TXN_CURRENCY_PO , A.MERCH_AMT_RECV , B.RECEIPT_DT , B.MATCH_STATUS_RECV , B.MATCH_CNTRL_ID , C.INSPECT_CD , C.INSPECT_STATUS , 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_RECV_VCHR_MTCH A , PS_RECV_HDR_FS B , PS_RECV_LN_SHIP C , PS_VOUCHER_LINE D , PS_VOUCHER E , PS_VENDOR F WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.RECEIVER_ID = B.RECEIVER_ID AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.RECEIVER_ID = C.RECEIVER_ID AND A.RECV_LN_NBR = C.RECV_LN_NBR AND A.RECV_SHIP_SEQ_NBR = C.RECV_SHIP_SEQ_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_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
5 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
6 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
7 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
8 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
9 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
10 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
11 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
12 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
13 QTY_VCHR Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Vouchered
14 UOM_VCHR Character(3) VARCHAR2(3) NOT NULL Unit Of Measure Voucher
15 UNIT_PRICE Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price
16 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
17 MERCH_AMT_VCHR Signed Number(28,3) DECIMAL(26,3) NOT NULL Voucher Merchandise Amount
18 VNDR_SETID_RECV Character(5) VARCHAR2(5) NOT NULL Supplier Setid Receiver
19 VENDOR_RECV Character(10) VARCHAR2(10) NOT NULL Supplier ID
20 VNDR_LOC_RECV Character(10) VARCHAR2(10) NOT NULL Supplier Location Receiver
21 ITM_SETID_RECV Character(5) VARCHAR2(5) NOT NULL Item Setid Receiver
22 INV_ITEM_ID_RECV Character(18) VARCHAR2(18) NOT NULL Item Number
23 QTY_SH_ACCPT Number(16,4) DECIMAL(15,4) NOT NULL Qty Accepted in Receipt UOM
24 RECEIVE_UOM Character(3) VARCHAR2(3) NOT NULL Receipt Unit of Measure
25 PRICE_PO_RECV Signed Number(17,5) DECIMAL(15,5) NOT NULL Non-PO Price
26 TXN_CURRENCY_PO Character(3) VARCHAR2(3) NOT NULL Transaction Currency
27 MERCH_AMT_RECV Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amount Received
28 RECEIPT_DT Date(10) DATE Received Date
29 MATCH_STATUS_RECV Character(1) VARCHAR2(1) NOT NULL Match Status
M=Matched
N=Not Matched
P=Partially Matched
T=To Match
V=Vouchered
30 MATCH_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Match Rule
31 INSPECT_CD Character(1) VARCHAR2(1) NOT NULL Inspection Required
N=No
Y=Yes
32 INSPECT_STATUS Character(1) VARCHAR2(1) NOT NULL Inspection Status
C=Complete
I=Incomplete
33 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
34 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.
35 ENTERED_DT Date(10) DATE Entered on
36 INVOICE_DT Date(10) DATE Invoice Date
37 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
38 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
39 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
40 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
41 AMT_ONLY_FLG Character(1) VARCHAR2(1) NOT NULL Amount Only
N=No
Y=Yes