VCHR_LOG_SRCH(SQL View) |
Index Back |
|---|---|
Match Exception Log Search |
| SELECT DISTINCT a.business_unit , a.voucher_id , d.invoice_id , d.gross_amt , f.po_id , f.buyer_id , d.vendor_setid , e.vendor_name_short , d.vendor_id FROM ps_ap_mtch_excptn a , PS_VOUCHER d , ps_vendor e , ps_vchr_mtch_detls f WHERE a.business_unit = d.business_unit AND a.voucher_id = d.voucher_id AND d.vendor_setid = e.setid AND d.vendor_id = e.vendor_id AND f.process_instance = a.process_instance AND f.business_unit = a.business_unit AND f.voucher_id = a.voucher_id AND f.voucher_line_num = a.voucher_line_num AND d.match_status_vchr IN ('E', 'O') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_AP_NONVW |
| 2 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL |
Voucher ID
Prompt Table: MTCH_VCHR_SRCH |
| 3 | INVOICE_ID | Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |
| 4 | GROSS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Invoice Amount |
| 5 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 6 | BUYER_ID | Character(30) | VARCHAR2(30) NOT NULL |
Buyer
Prompt Table: BUYER_TBL_FS |
| 7 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL |
Vendor SetID
Default Value: VENDOR.SETID |
| 8 | VENDOR_NAME_SHORT | Character(14) | VARCHAR2(14) NOT NULL | Short Vendor Name |
| 9 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Default Value: VENDOR_SHRT_VW.VENDOR_ID Prompt Table: VENDOR_PRIM_VW |