VCHR_DEL_ELIG (SQL View)	Index Back
AP-Search view for delete

VCHR_DEL_ELIG

(SQL View)

AP-Search view for delete

SELECT a.business_unit , a.voucher_id , a.entry_status , a.invoice_id , a.invoice_dt , a.vendor_setid , a.vendor_id FROM PS_VOUCHER a WHERE ((a.post_status_ap IN ('N','U') AND a.entry_status = 'P') OR (a.post_status_ap = 'U' AND a.entry_status = 'R') OR (a.entry_status = 'X' AND EXISTS ( SELECT 'X' FROM PS_KK_SOURCE_HDR d WHERE D.BUSINESS_UNIT= a.business_unit AND D.VOUCHER_ID = a.VOUCHER_ID))) AND a.in_process_flg = 'N' AND NOT EXISTS ( SELECT 'x' FROM ps_pymnt_vchr_xref c WHERE a.business_unit = c.business_unit AND a.voucher_id = c.voucher_id AND (c.pymnt_selct_status NOT IN ('N','X','C') OR (c.pymnt_selct_status = 'N' AND c.net_selct_status = 'S'))) AND NOT EXISTS ( SELECT 'X' FROM PS_DISTRIB_LINE G WHERE a.business_unit = g.business_unit AND a.voucher_id = g.voucher_id AND g.kk_close_prior = 'Y')

# 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

3 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

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

5 INVOICE_DT Date(10) DATE NOT NULL Invoice Date

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

7 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
Prompt Table: VENDOR_PRIM_VW

#	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
3	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
4	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
5	INVOICE_DT	Date(10)	DATE NOT NULL	Invoice Date
6	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
7	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Prompt Table: VENDOR_PRIM_VW