TSE_VCHR_VW3

(SQL View)
Index Back

Payables Voucher Error Logging

Voucher Error Logging

SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.TSE_PROC_INSTANCE , A.TSE_JOBID , A.ORIGIN , A.GRP_AP_ID , A.VENDOR_ID , A.CNTRCT_ID , A.INVOICE_ID , A.INVOICE_DT , A.GROSS_AMT , A.TXN_CURRENCY_CD , A.VCHR_SRC , B.OPRID FROM PS_TSE_VCHR A , PS_VENDOR_USER B WHERE A.VCHR_SRC IN ('SSI', 'XML', 'EXL') AND A.VENDOR_ID = B.VENDOR_ID AND A.TSE_JOBID <> 'AP_MATCH'

# 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 TSE_PROC_INSTANCE Number(10,0) DECIMAL(10) NOT NULL TSE Run ID
4 TSE_JOBID Character(10) VARCHAR2(10) NOT NULL TSE Job Identifier
5 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
6 GRP_AP_ID Character(10) VARCHAR2(10) NOT NULL Control Group ID
7 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
8 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
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

Prompt Table: CURRENCY_CD_TBL

13 VCHR_SRC Character(4) VARCHAR2(4) NOT NULL Voucher Source
14 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).