VCHR_LOG_PO_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_PO , A.PO_ID , A.LINE_NBR , A.SCHED_NBR , A.PYMNT_TERMS_CD , 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.UNIT_PRICE_CNVT_B , A.MERCH_AMT_VCHR , A.MERCH_AMT_VCHR_B , A.PYMNT_TERMS_CD_PO , A.VNDR_SETID_PO , A.VENDOR_PO , A.VNDR_LOC_PO , A.ITM_SETID_PO , A.INV_ITEM_ID_PO , A.QTY_PO , A.UOM_PO , A.PRICE_PO , A.TXN_CURRENCY_PO , A.MERCH_AMT_PO , A.PO_DT , A.BUYER_ID , A.INSPECT_CD , A.INSPECT_STATUS , A.SHIPTO_ID , A.RECV_REQ , A.MATCH_CNTRL_ID , A.UNIT_PRC_TOL , A.UNIT_PRC_TOL_L , (A.PCT_UNIT_PRC_TOL *100) , (A.PCT_UNIT_PRC_TOL_L *100) , A.EXT_PRC_TOL , A.EXT_PRC_TOL_L , (A.PCT_EXT_PRC_TOL * 100) , (A.PCT_EXT_PRC_TOL_L * 100) , A.BILLED_AMT_PO , A.BILLED_QTY_PO , A.INVOICED_AMT_B , A.INVOICED_QTY_CNVT , A.QTY_RECV_TOL_PCT , A.AMT_ONLY_FLG_PO FROM PS_VCHR_MTCH_DETLS A , PS_AP_MTCH_EXCPTN C 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

# 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_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
6 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
7 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
8 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
9 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.
10 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
11 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
12 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
13 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
14 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
15 QTY_VCHR Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Vouchered
16 UOM_VCHR Character(3) VARCHAR2(3) NOT NULL Unit Of Measure Voucher
17 QTY_VCHR_CNVT Signed Number(17,4) DECIMAL(15,4) NOT NULL Voucher Qty Converted
18 UNIT_PRICE Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price
19 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
20 UNIT_PRICE_CNVT_B Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price converted base
21 MERCH_AMT_VCHR Signed Number(28,3) DECIMAL(26,3) NOT NULL Voucher Merchandise Amount
22 MERCH_AMT_VCHR_B Signed Number(28,3) DECIMAL(26,3) NOT NULL Voucher Merchandise Amt base
23 PYMNT_TERMS_CD_PO Character(5) VARCHAR2(5) NOT NULL PO Payment Terms
24 VNDR_SETID_PO Character(5) VARCHAR2(5) NOT NULL Supplier setid PO
25 VENDOR_PO Character(10) VARCHAR2(10) NOT NULL Supplier ID PO
26 VNDR_LOC_PO Character(10) VARCHAR2(10) NOT NULL Supplier Location PO
27 ITM_SETID_PO Character(5) VARCHAR2(5) NOT NULL Item setid PO
28 INV_ITEM_ID_PO Character(18) VARCHAR2(18) NOT NULL Item Number PO
29 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
30 UOM_PO Character(3) VARCHAR2(3) NOT NULL Unit Of Measure PO
31 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price
32 TXN_CURRENCY_PO Character(3) VARCHAR2(3) NOT NULL Transaction Currency
33 MERCH_AMT_PO Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amount
34 PO_DT Date(10) DATE Date
35 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
36 INSPECT_CD Character(1) VARCHAR2(1) NOT NULL Inspection Required
N=No
Y=Yes
37 INSPECT_STATUS Character(1) VARCHAR2(1) NOT NULL Inspection Status
C=Complete
I=Incomplete
38 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
39 RECV_REQ Character(1) VARCHAR2(1) NOT NULL Receiving Required
N=Optional
X=Do Not
Y=Required
40 MATCH_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Match Rule
41 UNIT_PRC_TOL Number(14,5) DECIMAL(13,5) NOT NULL Unit Price Tolerance
42 UNIT_PRC_TOL_L Number(14,5) DECIMAL(13,5) NOT NULL Unit Price Tolerance - Under
43 PCT_UNIT_PRC_TOL Number(6,2) DECIMAL(5,2) NOT NULL % Unit Price Tolerance
44 PCT_UNIT_PRC_TOL_L Number(6,2) DECIMAL(5,2) NOT NULL % Unit Price Tolerance - Under
45 EXT_PRC_TOL Number(14,5) DECIMAL(13,5) NOT NULL Ext Price Tolerance
46 EXT_PRC_TOL_L Number(14,5) DECIMAL(13,5) NOT NULL Ext Price Tolerance - Under
47 PCT_EXT_PRC_TOL Number(6,2) DECIMAL(5,2) NOT NULL % Ext Price Tolerance
48 PCT_EXT_PRC_TOL_L Number(6,2) DECIMAL(5,2) NOT NULL % Ext Price Tolerance - Under
49 BILLED_AMT_PO Signed Number(28,3) DECIMAL(26,3) NOT NULL Billed Amt PO
50 BILLED_QTY_PO Signed Number(17,4) DECIMAL(15,4) NOT NULL Billed quantity PO
51 INVOICED_AMT_B Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoiced Amount base
52 INVOICED_QTY_CNVT Signed Number(17,4) DECIMAL(15,4) NOT NULL Invoiced quantity, PO UOM
53 QTY_RECV_TOL_PCT Number(6,2) DECIMAL(5,2) NOT NULL Qty Rcvd Tolerance %
54 AMT_ONLY_FLG_PO Character(1) VARCHAR2(1) NOT NULL Amount Only PO