VMMT_AUTHVCH_VW (SQL View)	Index Back
Vchr Mass Mnt "Auth Vchrs" Vw "Authorized Vouchers" supporting view for deriving all other Voucher Mass Maintenance Search Results "filter" views. Selects vouchers not currently in process and having basic style/status such that the 4 mass maintenance operations (field replace, close, unpost, delete) can be performed on them. (Subsequent views for each of the 4 operations may impose additional style/status restrictions for that operation.)

VMMT_AUTHVCH_VW

(SQL View)

Vchr Mass Mnt "Auth Vchrs" Vw

"Authorized Vouchers" supporting view for deriving all other Voucher Mass Maintenance Search Results "filter" views. Selects vouchers not currently in process and having basic style/status such that the 4 mass maintenance operations (field replace, close, unpost, delete) can be performed on them. (Subsequent views for each of the 4 operations may impose additional style/status restrictions for that operation.)

SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.PROCESS_INSTANCE , A.BUSINESS_UNIT_GL , A.PYMNT_CNT_TOTAL , A.VCHR_LINE_APPR , A.DOC_SEQ_NBR , A.DOC_SEQ_DATE , A.MANUAL_CLOSE_DT , A.VCHR_SRC , A.VAT_ENTITY , A.VCHR_APPRVL_FLG , %subrec(VCHR_MMT_SBR, A) , %subrec(VCHR_MMT_VN_SBR, B) FROM PS_VOUCHER A , PS_VENDOR B WHERE A.IN_PROCESS_FLG IN ('N',' ') AND A.ENTRY_STATUS IN ('L','O','P','R','X') AND A.VOUCHER_STYLE IN ('ADJ','CORR','JRNL','PPAY','REG','RGTR','SGLP','THRD') AND A.VCHR_DRAFT_FLG <> 'Y' AND B.SETID = A.VENDOR_SETID AND B.VENDOR_ID = A.VENDOR_ID AND NOT EXISTS ( SELECT 'X' FROM PS_KK_SHDR_APVCHR K WHERE K.BUSINESS_UNIT = A.BUSINESS_UNIT AND K.VOUCHER_ID = A.VOUCHER_ID AND K.KK_PROCESS_STATUS = 'I')

# 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 MANUAL_CLOSE_DT Date(10) DATE Manual Close Date

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

11 VAT_ENTITY Character(20) VARCHAR2(20) NOT NULL Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.

12 VCHR_APPRVL_FLG Character(1) VARCHAR2(1) NOT NULL Voucher Approval Flag
D=Default from Higher Level
P=Pre-Approved
S=Virtual Approver
W=Approval Framework

13 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

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

15 INVOICE_DT Date(10) DATE Invoice Date

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

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

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

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

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

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

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

23 ENTERED_DT Date(10) DATE Entered on

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

25 DSCNT_DUE_DT Date(10) DATE Discount Due Date

26 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

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

28 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

29 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

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

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

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

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

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

35 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

36 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

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

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

39 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	MANUAL_CLOSE_DT	Date(10)	DATE	Manual Close Date
10	VCHR_SRC	Character(4)	VARCHAR2(4) NOT NULL	Voucher Source
11	VAT_ENTITY	Character(20)	VARCHAR2(20) NOT NULL	Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.
12	VCHR_APPRVL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Voucher Approval Flag D=Default from Higher Level P=Pre-Approved S=Virtual Approver W=Approval Framework
13	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
14	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
15	INVOICE_DT	Date(10)	DATE	Invoice Date
16	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
17	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
18	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
19	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
20	GRP_AP_ID	Character(10)	VARCHAR2(10) NOT NULL	Control Group ID
21	ORIGIN	Character(3)	VARCHAR2(3) NOT NULL	Origin
22	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
23	ENTERED_DT	Date(10)	DATE	Entered on
24	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.
25	DSCNT_DUE_DT	Date(10)	DATE	Discount Due Date
26	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
27	POST_STATUS_AP	Character(1)	VARCHAR2(1) NOT NULL	Post Status N=Payment Not Applied P=Posted U=Unposted
28	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
29	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
30	DUP_INVOICE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Duplicate Invoice Status Y/N Table Edit
31	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.
32	CNTRCT_ID	Character(25)	VARCHAR2(25) NOT NULL	Buying Agreement ID
33	GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Invoice Amount
34	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
35	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
36	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
37	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
38	VENDOR_NAME_SHORT	Character(14)	VARCHAR2(14) NOT NULL	Short Vendor Name
39	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1