VCHR_LOG_RCV_VW

(SQL View)
Index Back

Match Log Exceptions


SELECT DISTINCT A.PROCESS_INSTANCE , A.BUSINESS_UNIT , A.VOUCHER_ID , A.VOUCHER_LINE_NUM , A.BUSINESS_UNIT_RECV , A.RECEIVER_ID , A.RECV_LN_NBR , A.RECV_SHIP_SEQ_NBR , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , A.ITM_SETID , A.INV_ITEM_ID , A.QTY_VCHR , A.UOM_VCHR , A.QTY_VCHR_CNVT , A.UNIT_PRICE , A.TXN_CURRENCY_CD , A.MERCH_AMT_VCHR , A.VNDR_SETID_RECV , A.VENDOR_RECV , A.VNDR_LOC_RECV , A.ITM_SETID_RECV , A.INV_ITEM_ID_RECV , A.QTY_ENTERED , A.QTY_ACCEPTED_CNVT , A.UOM_PO , A.QTY_ENTERED_CNVT , A.PRICE_PO , A.TXN_CURRENCY_PO , A.MERCH_AMT_RECV , D.RECEIPT_DT , D.MATCH_STATUS_RECV , A.MATCH_CNTRL_ID , A.INSPECT_CD , A.INSPECT_STATUS , A.QTY_INSPECTED_CNVT , A.BILLED_AMT_RECV , A.BILLED_QTY_RECV , A.TOTAL_RECV_ENT , A.AMT_ONLY_FLG_RECV FROM PS_VCHR_MTCH_DETLS A , PS_AP_MTCH_EXCPTN C , PS_RECV_HDR_FS D WHERE A.PROCESS_INSTANCE = C.PROCESS_INSTANCE AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.VOUCHER_ID = C.VOUCHER_ID AND A.VOUCHER_LINE_NUM = C.VOUCHER_LINE_NUM AND A.BUSINESS_UNIT_RECV = D.BUSINESS_UNIT AND A.RECEIVER_ID = D.RECEIVER_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
4 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line 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 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 QTY_VCHR_CNVT Signed Number(17,4) DECIMAL(15,4) NOT NULL Voucher Qty Converted
17 UNIT_PRICE Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price
18 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
19 MERCH_AMT_VCHR Signed Number(28,3) DECIMAL(26,3) NOT NULL Voucher Merchandise Amount
20 VNDR_SETID_RECV Character(5) VARCHAR2(5) NOT NULL Supplier Setid Receiver
21 VENDOR_RECV Character(10) VARCHAR2(10) NOT NULL Supplier ID
22 VNDR_LOC_RECV Character(10) VARCHAR2(10) NOT NULL Supplier Location Receiver
23 ITM_SETID_RECV Character(5) VARCHAR2(5) NOT NULL Item Setid Receiver
24 INV_ITEM_ID_RECV Character(18) VARCHAR2(18) NOT NULL Item Number
25 QTY_ENTERED Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Entered
26 QTY_ACCEPTED_CNVT Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Accepted Cnvt
27 UOM_PO Character(3) VARCHAR2(3) NOT NULL Unit Of Measure PO
28 QTY_ENTERED_CNVT Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Entered Converted
29 PRICE_PO_RECV Signed Number(17,5) DECIMAL(15,5) NOT NULL Non-PO Price
30 TXN_CURRENCY_PO Character(3) VARCHAR2(3) NOT NULL Transaction Currency
31 MERCH_AMT_RECV Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amount Received
32 RECEIPT_DT Date(10) DATE Received Date
33 MATCH_STATUS_RECV Character(1) VARCHAR2(1) NOT NULL Match Status
M=Matched
N=Not Matched
P=Partially Matched
T=To Match
V=Vouchered
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 INSPECT_STATUS Character(1) VARCHAR2(1) NOT NULL Inspection Status
C=Complete
I=Incomplete
37 QTY_INSPECTED_CNVT Signed Number(17,4) DECIMAL(15,4) NOT NULL Inspected Qty in Supplier UOM
38 BILLED_AMT_RECV Signed Number(28,3) DECIMAL(26,3) NOT NULL Billed Amount Receiver
39 BILLED_QTY_RECV Signed Number(17,4) DECIMAL(15,4) NOT NULL Billed quantity receiver
40 TOTAL_RECV_ENT Signed Number(17,4) DECIMAL(15,4) NOT NULL Total Received Quantity Ent
41 AMT_ONLY_FLG_RECV Character(1) VARCHAR2(1) NOT NULL Amount Only Receiver