VCHR_SRCHERR_VW

(SQL View)

SELECT a.business_unit , a.voucher_id , a.invoice_id , a.gross_amt , a.invoice_dt , a.vendor_setid , b.vendor_name_short , a.vendor_id , b.name1 , a.voucher_style , a.txn_currency_cd , a.entry_status FROM PS_VOUCHER a , ps_vendor b WHERE a.vendor_setid = b.setid AND a.vendor_id = b.vendor_id AND (a.entry_status = 'R' OR a.error_flag = 'Y' OR a.match_status_vchr = 'E')

# 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
Default Value: NEXT

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 INVOICE_DT Date(10) DATE Invoice Date

6 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
Default Value: VENDOR.SETID

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

8 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
Default Value: VENDOR_SHRT_VW.VENDOR_ID
Prompt Table: VENDOR_PRIM_VW

9 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

10 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
Default Value: REG

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

12 ENTRY_STATUS_SRH Character(1) VARCHAR2(1) NOT NULL Entry Status
P=Postable
R=Recycle
T=Template Voucher

#	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 Default Value: NEXT
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	INVOICE_DT	Date(10)	DATE	Invoice Date
6	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID Default Value: VENDOR.SETID
7	VENDOR_NAME_SHORT	Character(14)	VARCHAR2(14) NOT NULL	Short Vendor Name
8	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Default Value: VENDOR_SHRT_VW.VENDOR_ID Prompt Table: VENDOR_PRIM_VW
9	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
10	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 Default Value: REG
11	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
12	ENTRY_STATUS_SRH	Character(1)	VARCHAR2(1) NOT NULL	Entry Status P=Postable R=Recycle T=Template Voucher