VMMT_REPLACE_VW (SQL View)	Index Back
Vchr Mass Mnt "Replace" View "Vouchers that can be Field Replaced" filter view for Voucher Mass Maintenance Search Results; i.e., selects all eligible vouchers not currently in process with posting/payment statuses such that vouchers can be Field Replaced. (Note: references existing Search view for single voucher delete component, VCHR_SRCH_DEL, as mass maintenance field replacement is subject to same restrictions as single voucher deletion.)

VMMT_REPLACE_VW

(SQL View)

Vchr Mass Mnt "Replace" View

"Vouchers that can be Field Replaced" filter view for Voucher Mass Maintenance Search Results; i.e., selects all eligible vouchers not currently in process with posting/payment statuses such that vouchers can be Field Replaced. (Note: references existing Search view for single voucher delete component, VCHR_SRCH_DEL, as mass maintenance field replacement is subject to same restrictions as single voucher deletion.)

SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.LAST_PROCESS_INST , A.BUSINESS_UNIT_GL , A.PYMNT_CNT_TOTAL , A.VCHR_LINE_APPR , A.DOC_SEQ_NBR , A.DOC_SEQ_DATE , %subrec(VCHR_MMT_SBR, A) , %subrec(VCHR_MMT_VN_SBR, A) FROM PS_VMMT_AUTHVCH_VW A , PS_VCHR_DEL_ELIG B WHERE A.VOUCHER_STYLE IN ('ADJ', 'CORR', 'JRNL', 'PPAY', 'REG', 'RGTR', 'SGLP') AND NOT (A.APPR_STATUS = 'A' AND A.VCHR_APPRVL_FLG <> 'P') AND NOT (A.VCHR_SRC = 'PROC' AND A.VAT_ENTITY <> ' ') AND NOT (A.VOUCHER_STYLE = 'RGTR' AND EXISTS ( SELECT 'X' FROM PS_VCHR_REG_LC I WHERE I.BUSINESS_UNIT = A.BUSINESS_UNIT AND I.VOUCHER_ID = A.VOUCHER_ID AND I.REG_CMPL_FLAG = 'N')) AND NOT EXISTS ( SELECT 'X' FROM PS_GRP_AP J WHERE J.BUSINESS_UNIT = A.BUSINESS_UNIT AND J.GRP_AP_ID = A.GRP_AP_ID AND J.GRP_AP_STATUS = 'V') AND B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.VOUCHER_ID = A.VOUCHER_ID

# 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 LAST_PROCESS_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance

4 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

5 PYMNT_CNT_TOTAL Number(5,0) INTEGER NOT NULL Total Payment Count

6 VCHR_LINE_APPR Character(1) VARCHAR2(1) NOT NULL Invoice Line Approval Status
0=Line Routing Not Required
1=Completed
2=Routed for Approval

7 DOC_SEQ_NBR Character(12) VARCHAR2(12) NOT NULL Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.

8 DOC_SEQ_DATE Date(10) DATE Specifies the date that a document sequence number is assigned to a document or the date the document was created.

9 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

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

11 INVOICE_DT Date(10) DATE Invoice Date

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

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

14 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

15 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

16 GRP_AP_ID Character(10) VARCHAR2(10) NOT NULL Control Group ID

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

18 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

19 ENTERED_DT Date(10) DATE Entered on

20 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.

21 DSCNT_DUE_DT Date(10) DATE Discount Due Date

22 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

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

24 APPR_STATUS Character(1) VARCHAR2(1) NOT NULL Approval status flag used on appr_inst_log and derived records to track virtual approver status
A=Approved
D=Denied
P=Pending

25 MATCH_STATUS_VCHR Character(1) VARCHAR2(1) NOT NULL Match Status
C=Overridden - Credit Note
D=Match Dispute
E=Match Exceptions Exist
M=Matched
N=Not Applicable
O=Manually Overridden
T=To Be Matched

26 DUP_INVOICE_STATUS Character(1) VARCHAR2(1) NOT NULL Duplicate Invoice Status
Y/N Table Edit

27 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.

28 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID

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

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

31 BUDGET_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Checking Header Status
E=Error in Budget Check
I=Document In Processing
N=Not Budget Checked
P=Provisionally Valid
V=Valid

32 BUDGET_MISC_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Checking Misc Status
E=Error in Budget Check
N=Not Budget Checked
P=Provisionally Valid
V=Valid Budget Check

33 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

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

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

#	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	LAST_PROCESS_INST	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
4	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
5	PYMNT_CNT_TOTAL	Number(5,0)	INTEGER NOT NULL	Total Payment Count
6	VCHR_LINE_APPR	Character(1)	VARCHAR2(1) NOT NULL	Invoice Line Approval Status 0=Line Routing Not Required 1=Completed 2=Routed for Approval
7	DOC_SEQ_NBR	Character(12)	VARCHAR2(12) NOT NULL	Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.
8	DOC_SEQ_DATE	Date(10)	DATE	Specifies the date that a document sequence number is assigned to a document or the date the document was created.
9	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
10	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
11	INVOICE_DT	Date(10)	DATE	Invoice Date
12	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
13	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
14	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
15	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
16	GRP_AP_ID	Character(10)	VARCHAR2(10) NOT NULL	Control Group ID
17	ORIGIN	Character(3)	VARCHAR2(3) NOT NULL	Origin
18	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
19	ENTERED_DT	Date(10)	DATE	Entered on
20	DUE_DT	Date(10)	DATE	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
21	DSCNT_DUE_DT	Date(10)	DATE	Discount Due Date
22	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
23	POST_STATUS_AP	Character(1)	VARCHAR2(1) NOT NULL	Post Status N=Payment Not Applied P=Posted U=Unposted
24	APPR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Approval status flag used on appr_inst_log and derived records to track virtual approver status A=Approved D=Denied P=Pending
25	MATCH_STATUS_VCHR	Character(1)	VARCHAR2(1) NOT NULL	Match Status C=Overridden - Credit Note D=Match Dispute E=Match Exceptions Exist M=Matched N=Not Applicable O=Manually Overridden T=To Be Matched
26	DUP_INVOICE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Duplicate Invoice Status Y/N Table Edit
27	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.
28	CNTRCT_ID	Character(25)	VARCHAR2(25) NOT NULL	Buying Agreement ID
29	GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Invoice Amount
30	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
31	BUDGET_HDR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Budget Checking Header Status E=Error in Budget Check I=Document In Processing N=Not Budget Checked P=Provisionally Valid V=Valid
32	BUDGET_MISC_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Budget Checking Misc Status E=Error in Budget Check N=Not Budget Checked P=Provisionally Valid V=Valid Budget Check
33	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
34	VENDOR_NAME_SHORT	Character(14)	VARCHAR2(14) NOT NULL	Short Vendor Name
35	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1