APOD_HLDVCHR_MV (SQL View)	Index Back
Voucher on Hold Detail MV Vouchers on Hold Detail MV

APOD_HLDVCHR_MV

(SQL View)

Voucher on Hold Detail MV

Vouchers on Hold Detail MV

SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.INVOICE_ID , A.INVOICE_DT , A.ENTERED_DT , A.GROSS_AMT , A.TXN_CURRENCY_CD , A.VENDOR_SETID , A.VENDOR_ID , A.VCHR_SRC , A.VOUCHER_STYLE , A.ENTRY_STATUS , A.ORIGIN , A.POST_STATUS_AP , XREF.PYMNT_HOLD_REASON FROM %Table(APOP_INVOICE_MV) A , %Table(APOP_PVCHXRF_MV) XREF WHERE XREF.BUSINESS_UNIT = A.BUSINESS_UNIT AND XREF.VOUCHER_ID = A.VOUCHER_ID AND XREF.PYMNT_HOLD = 'Y' AND XREF.PYMNT_CNT = ( SELECT MIN(XREF2.PYMNT_CNT) FROM %Table(APOP_PVCHXRF_MV) XREF2 WHERE XREF2.BUSINESS_UNIT = XREF.BUSINESS_UNIT AND XREF2.VOUCHER_ID = XREF.VOUCHER_ID AND XREF2.PYMNT_HOLD = 'Y' )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

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

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

4 INVOICE_DT Date(10) DATE Invoice Date

5 ENTERED_DT Date(10) DATE Entered on

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

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

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

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

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

11 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

12 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

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

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

15 PYMNT_HOLD_REASON Character(3) VARCHAR2(3) NOT NULL Hold Reason
ACC=Accounting in Dispute
ACV=Federal Supplier Inactive
ALC=Agency Location Code Required
AMT=Amount in Dispute
CCR=CCR Expired
CRT=Contract Retention
EFT=EFT incomplete or not Prenoted
FNS=Financial Sanctions
GDS=Goods in Dispute
GNV=G-Invoicing Hold
IPC=Inbound IPAC Required
OTH=Other
QTY=Quantity in Dispute
SAM=SAM Expired
WTH=Withholding Hold

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
3	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
4	INVOICE_DT	Date(10)	DATE	Invoice Date
5	ENTERED_DT	Date(10)	DATE	Entered on
6	GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Invoice Amount
7	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
8	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
9	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
10	VCHR_SRC	Character(4)	VARCHAR2(4) NOT NULL	Voucher Source
11	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
12	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
13	ORIGIN	Character(3)	VARCHAR2(3) NOT NULL	Origin
14	POST_STATUS_AP	Character(1)	VARCHAR2(1) NOT NULL	Post Status N=Payment Not Applied P=Posted U=Unposted
15	PYMNT_HOLD_REASON	Character(3)	VARCHAR2(3) NOT NULL	Hold Reason ACC=Accounting in Dispute ACV=Federal Supplier Inactive ALC=Agency Location Code Required AMT=Amount in Dispute CCR=CCR Expired CRT=Contract Retention EFT=EFT incomplete or not Prenoted FNS=Financial Sanctions GDS=Goods in Dispute GNV=G-Invoicing Hold IPC=Inbound IPAC Required OTH=Other QTY=Quantity in Dispute SAM=SAM Expired WTH=Withholding Hold