VCHR_MM_VCHR_VW(SQL View) |
Index Back |
|---|---|
Match Manager Voucher View |
| SELECT DISTINCT A.BUSINESS_UNIT , A.VOUCHER_ID , C.VOUCHER_LINE_NUM , A.INVOICE_ID , A.PROCESS_INSTANCE , A.ENTRY_STATUS , A.POST_STATUS_AP , A.MATCH_ACTION , A.ORIGIN FROM PS_VOUCHER A , PS_PO_LINE_MATCHED C WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT_AP AND A.VOUCHER_ID = C.VOUCHER_ID AND A.MATCH_ACTION IN ('Y', 'E') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT_AP |
Character(5) | VARCHAR2(5) NOT NULL | AP 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 | INVOICE_ID | Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |
| 5 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 6 | ENTRY_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
If translate values are added or changed, modify the following code to make sure the values appear accurately in the dropdown list in the search dialog: VCHR_SRCH_DEL.ENTRY_STATUS.SearchInit. Template Voucher status should not be visibile in the drop down.
C=Complete D=Through batch defaults E=Edited by Batch Voucher Module L=Reviewed through Maintenance M=Modified O=Open P=Postable R=Recycle S=Scheduled for Payment T=Template Voucher X=Deleted |
| 7 | POST_STATUS_AP | Character(1) | VARCHAR2(1) NOT NULL |
Post Status
N=Payment Not Applied P=Posted U=Unposted |
| 8 | MATCH_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Match Action
N=No Match Y=Standard |
| 9 | ORIGIN | Character(3) | VARCHAR2(3) NOT NULL | Origin |