AP_WB_OTH_VW (SQL View)	Index Back
Match Workbench Used to retrieve summary information of vouchers that require matching.

AP_WB_OTH_VW

(SQL View)

Match Workbench

Used to retrieve summary information of vouchers that require matching.

SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.GRP_AP_ID , A.ORIGIN , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , B.VENDOR_NAME_SHORT , A.INVOICE_ID , A.INVOICE_DT , A.GROSS_AMT , A.TXN_CURRENCY_CD , A.DUE_DT , A.DSCNT_DUE_DT , A.DSCNT_AMT , A.POST_STATUS_AP , A.CLOSE_STATUS , A.BUDGET_HDR_STATUS , A.MATCH_STATUS_VCHR , A.ACCOUNTING_DT , A.APPR_STATUS , A.DOC_TOL_HDR_STATUS , A.ENTERED_DT , A.ENTRY_STATUS , A.LC_EXTRCT_STATUS , A.MATCH_ACTION , A.PROCESS_INSTANCE , A.VOUCHER_STYLE , A.MATCH_DUE_DT , A.OPRID , A.VCHR_SRC , A.AP_MATCH_TYPE , A.OPRID_LAST_UPDT , A.PACKSLIP_NO , B.OFAC_STATUS FROM PS_VOUCHER A , PS_VENDOR B WHERE A.VENDOR_SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.MATCH_ACTION = 'Y' AND A.ENTRY_STATUS ='P' AND A.MATCH_STATUS_VCHR <> 'T' AND A.CLOSE_STATUS <> 'C' AND A.IN_PROCESS_FLG = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BUS_AP_NONVW

2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

3 GRP_AP_ID Character(10) VARCHAR2(10) NOT NULL Control Group ID

4 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin

5 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

6 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

7 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

8 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name

9 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number

10 INVOICE_DT Date(10) DATE Invoice Date

11 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount

12 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency

13 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.

14 DSCNT_DUE_DT Date(10) DATE Discount Due Date

15 DSCNT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount Amount

16 POST_STATUS_AP Character(1) VARCHAR2(1) NOT NULL Post Status
N=Payment Not Applied
P=Posted
U=Unposted

17 CLOSE_STATUS Character(1) VARCHAR2(1) NOT NULL Close Status Indicator
C=Closed
O=Open

18 BUDGET_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Checking Header Status
E=Error in Budget Check
I=Document In Processing
N=Not Budget Checked
P=Provisionally Valid
V=Valid

19 MATCH_STATUS_VCHR Character(1) VARCHAR2(1) NOT NULL Match Status
C=Overridden - Credit Note
D=Match Dispute
E=Match Exceptions Exist
M=Matched
N=Not Applicable
O=Manually Overridden
T=To Be Matched

20 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

21 APPR_STATUS Character(1) VARCHAR2(1) NOT NULL Approval status flag used on appr_inst_log and derived records to track virtual approver status
A=Approved
D=Denied
P=Pending

22 DOC_TOL_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Document Heade Document Tolerance Status
E=Error
N=Not Checked
R=Reset
V=Valid

23 ENTERED_DT Date(10) DATE Entered on

24 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

25 LC_EXTRCT_STATUS Character(1) VARCHAR2(1) NOT NULL Landed Cost Extract Status

26 MATCH_ACTION Character(1) VARCHAR2(1) NOT NULL Match Action
N=No Match
Y=Standard

27 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

28 VOUCHER_STYLE Character(4) VARCHAR2(4) NOT NULL Voucher Style
ADJ=Adjustments
AMR=Amortization Voucher
CLBK=Claim Voucher
CORR=Reversal Voucher
JRNL=Journal Voucher
PPAY=Prepaid Voucher
REG=Regular Voucher
RGTR=Register Voucher
SGLP=Single Payment Voucher
THRD=Third Party Voucher
TMPL=Template Voucher

29 MATCH_DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.

30 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

31 VCHR_SRC Character(4) VARCHAR2(4) NOT NULL Voucher Source

32 AP_MATCH_TYPE Character(1) VARCHAR2(1) NOT NULL Match Type
C=Matched with Credit Note
D=Matched with Debit Memo
O=Matched with Override
P=Auto - Matched

33 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last User to Update

34 PACKSLIP_NO Character(22) VARCHAR2(22) NOT NULL Packing Slip Number

35 OFAC_STATUS Character(1) VARCHAR2(1) NOT NULL OFAC Status
B=Blocked
C=Cleared
R=Review
V=Valid

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BUS_AP_NONVW
2	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
3	GRP_AP_ID	Character(10)	VARCHAR2(10) NOT NULL	Control Group ID
4	ORIGIN	Character(3)	VARCHAR2(3) NOT NULL	Origin
5	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
6	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
7	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
8	VENDOR_NAME_SHORT	Character(14)	VARCHAR2(14) NOT NULL	Short Vendor Name
9	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
10	INVOICE_DT	Date(10)	DATE	Invoice Date
11	GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Invoice Amount
12	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
13	DUE_DT	Date(10)	DATE	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
14	DSCNT_DUE_DT	Date(10)	DATE	Discount Due Date
15	DSCNT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discount Amount
16	POST_STATUS_AP	Character(1)	VARCHAR2(1) NOT NULL	Post Status N=Payment Not Applied P=Posted U=Unposted
17	CLOSE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Close Status Indicator C=Closed O=Open
18	BUDGET_HDR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Budget Checking Header Status E=Error in Budget Check I=Document In Processing N=Not Budget Checked P=Provisionally Valid V=Valid
19	MATCH_STATUS_VCHR	Character(1)	VARCHAR2(1) NOT NULL	Match Status C=Overridden - Credit Note D=Match Dispute E=Match Exceptions Exist M=Matched N=Not Applicable O=Manually Overridden T=To Be Matched
20	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
21	APPR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Approval status flag used on appr_inst_log and derived records to track virtual approver status A=Approved D=Denied P=Pending
22	DOC_TOL_HDR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Document Heade Document Tolerance Status E=Error N=Not Checked R=Reset V=Valid
23	ENTERED_DT	Date(10)	DATE	Entered on
24	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
25	LC_EXTRCT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Landed Cost Extract Status
26	MATCH_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Match Action N=No Match Y=Standard
27	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
28	VOUCHER_STYLE	Character(4)	VARCHAR2(4) NOT NULL	Voucher Style ADJ=Adjustments AMR=Amortization Voucher CLBK=Claim Voucher CORR=Reversal Voucher JRNL=Journal Voucher PPAY=Prepaid Voucher REG=Regular Voucher RGTR=Register Voucher SGLP=Single Payment Voucher THRD=Third Party Voucher TMPL=Template Voucher
29	MATCH_DUE_DT	Date(10)	DATE	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
30	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
31	VCHR_SRC	Character(4)	VARCHAR2(4) NOT NULL	Voucher Source
32	AP_MATCH_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Match Type C=Matched with Credit Note D=Matched with Debit Memo O=Matched with Override P=Auto - Matched
33	OPRID_LAST_UPDT	Character(30)	VARCHAR2(30) NOT NULL	Last User to Update
34	PACKSLIP_NO	Character(22)	VARCHAR2(22) NOT NULL	Packing Slip Number
35	OFAC_STATUS	Character(1)	VARCHAR2(1) NOT NULL	OFAC Status B=Blocked C=Cleared R=Review V=Valid