VCHR_WTH_UPD_HD (SQL View)	Index Back
Voucher Withholding Update Voucher Withholding update

VCHR_WTH_UPD_HD

(SQL View)

Voucher Withholding Update

Voucher Withholding update

SELECT DISTINCT A.BUSINESS_UNIT , A.VOUCHER_ID , A.INVOICE_ID , A.VENDOR_SETID , A.VENDOR_ID , A.VOUCHER_STYLE , A.VOUCHER_ID_RELATED , A.ENTRY_STATUS , A.VCHR_SRC , A.INVOICE_DT , A.PYMNT_TERMS_CD , A.GROSS_AMT , A.TXN_CURRENCY_CD FROM PS_VOUCHER A WHERE A.ENTRY_STATUS <> 'X' AND A.POST_STATUS_AP = 'U' AND A.VCHR_DRAFT_FLG <> 'Y' AND EXISTS ( SELECT 'X' FROM PS_VOUCHER_LINE LINE WHERE LINE.BUSINESS_UNIT = A.BUSINESS_UNIT AND LINE.VOUCHER_ID = A.VOUCHER_ID AND LINE.WTHD_SW = 'Y') AND NOT EXISTS ( SELECT 'X' FROM PS_PYMNT_VCHR_XREF XREF WHERE XREF.BUSINESS_UNIT = A.BUSINESS_UNIT AND XREF.VOUCHER_ID = A.VOUCHER_ID AND ((XREF.PYMNT_TYPE = 'W') OR (XREF.PYMNT_SELCT_STATUS <> '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_BU_AP_NONVW

2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
Prompt Table: VCHR_WTH_UPD_HD

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

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

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

6 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

7 VOUCHER_ID_RELATED Character(8) VARCHAR2(8) NOT NULL Related Voucher

8 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

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

10 INVOICE_DT Date(10) DATE Invoice Date

11 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_AP_NONVW
2	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID Prompt Table: VCHR_WTH_UPD_HD
3	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
4	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID Default Value: VENDOR.SETID
5	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Prompt Table: VENDOR_PRIM_VW
6	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
7	VOUCHER_ID_RELATED	Character(8)	VARCHAR2(8) NOT NULL	Related Voucher
8	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
9	VCHR_SRC	Character(4)	VARCHAR2(4) NOT NULL	Voucher Source
10	INVOICE_DT	Date(10)	DATE	Invoice Date
11	PYMNT_TERMS_CD	Character(5)	VARCHAR2(5) NOT NULL	Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
12	GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Invoice Amount
13	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency