CM_APSUMR_VW (SQL View)	Index Back
CMAP Sum Unvchrd Rcvrs Sum of unvouchered receivers

CM_APSUMR_VW

(SQL View)

CMAP Sum Unvchrd Rcvrs

Sum of unvouchered receivers

SELECT a.run_cntl_id , a.request_id , a.business_unit_recv , a.receiver_id , a.recv_ln_nbr , a.recv_ship_seq_nbr , a.business_unit_gl , a.inv_item_id , a.currency_cd , 0 , SUM(a.monetary_amount) , SUM(a.monetary_amount) FROM PS_CM_APRECN_TBL a WHERE A.CM_AP_ERROR_OK = 'N' AND NOT EXISTS ( SELECT 'X' FROM PS_CM_APRECN_TBL2 B WHERE A.RUN_CNTL_ID = B.RUN_CNTL_ID AND A.REQUEST_ID = B.REQUEST_ID AND A.BUSINESS_UNIT_RECV = B.BUSINESS_UNIT_RECV AND A.RECEIVER_ID = B.RECEIVER_ID AND A.RECV_LN_NBR = B.RECV_LN_NBR AND A.RECV_SHIP_SEQ_NBR = B.RECV_SHIP_SEQ_NBR ) GROUP BY a.run_cntl_id , a.request_id , a.inv_item_id , a.business_unit_recv , a.receiver_id , a.recv_ln_nbr , a.recv_ship_seq_nbr , a.business_unit_gl,a.account , a.altacct , A.DEPTID, a.currency_cd ,%subrec(cf16_an_sbr, a) , %subrec(pc_cf1_n_sbr, a)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

2 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID

3 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit

4 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number

5 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line

6 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence

7 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
Prompt Table: SP_BUPRCR_NONVW

8 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

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

10 MONETARY_AMT_VCHR Signed Number(28,3) DECIMAL(26,3) NOT NULL Monetary Amount - VCHR BU Base

11 MONETARY_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.

12 DIFFERENCE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Difference Amount

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
2	REQUEST_ID	Character(10)	VARCHAR2(10) NOT NULL	Request ID
3	BUSINESS_UNIT_RECV	Character(5)	VARCHAR2(5) NOT NULL	Receiving Business Unit
4	RECEIVER_ID	Character(10)	VARCHAR2(10) NOT NULL	Receiver number
5	RECV_LN_NBR	Number(5,0)	INTEGER NOT NULL	Receipt Line
6	RECV_SHIP_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Receiver Shipping Sequence
7	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit Prompt Table: SP_BUPRCR_NONVW
8	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
10	MONETARY_AMT_VCHR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Monetary Amount - VCHR BU Base
11	MONETARY_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
12	DIFFERENCE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Difference Amount