CM_APSUMRT_VW (SQL View)	Index Back
CM/GL Summation CM lines This record will sum all the costing entries in the CM_GLRECN_TBL to the receiver line.

CM_APSUMRT_VW

(SQL View)

CM/GL Summation CM lines

This record will sum all the costing entries in the CM_GLRECN_TBL to the receiver line.

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 , SUM(a.monetary_amount) FROM PS_CM_APRECN_TBL a WHERE a.cm_ap_error_ok = 'N' 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.currency_cd

# 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_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.

#	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_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.