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 |