EM_MTRCBH_NONVW

(SQL View)

SELECT BUSINESS_UNIT , OPRID , 'I' , GROSS_AMT , TXN_CURRENCY_CD , COUNT(*) FROM PS_EM_VCHR_SRCH GROUP BY BUSINESS_UNIT , OPRID , GROSS_AMT , TXN_CURRENCY_CD

# 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 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

3 EM_INV_PYMNT_STAT Character(1) VARCHAR2(1) NOT NULL Field used to display the various statuses of invoices and payments that a Buyer would need to review. Used on charts.
B=Invoice Balance
D=Invoices in Dispute
E=Review Exceptions
I=Invoices Pending Approval
M=Invoices to Approve
O=Past Due
P=Payments to Approve
S=Supplier - Dispute
V=Invoices to Verify
X=Discount Proposals
Y=Discount Offers
Z=Pending Messages

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

5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

6 INVOICE_COUNT Number(12,0) DECIMAL(12) NOT NULL Invoice Count

#	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	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	EM_INV_PYMNT_STAT	Character(1)	VARCHAR2(1) NOT NULL	Field used to display the various statuses of invoices and payments that a Buyer would need to review. Used on charts. B=Invoice Balance D=Invoices in Dispute E=Review Exceptions I=Invoices Pending Approval M=Invoices to Approve O=Past Due P=Payments to Approve S=Supplier - Dispute V=Invoices to Verify X=Discount Proposals Y=Discount Offers Z=Pending Messages
4	GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Invoice Amount
5	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
6	INVOICE_COUNT	Number(12,0)	DECIMAL(12) NOT NULL	Invoice Count