EX_SHDST_SUM_VW (SQL View)	Index Back
Sum non DST amounts on AcctLn Sum non DST amounts on Acctg Line

EX_SHDST_SUM_VW

(SQL View)

Sum non DST amounts on AcctLn

Sum non DST amounts on Acctg Line

SELECT A.EX_DOC_ID , A.LINE_NBR , A.DISTRIB_LINE_NUM , A.APPL_JRNL_ID , A.UNPOST_SEQ , SUM(A.FOREIGN_AMOUNT) , A.FOREIGN_CURRENCY , SUM(A.MONETARY_AMOUNT) , A.CURRENCY_CD FROM PS_EX_ACCTG_LINE A WHERE A.EX_DOC_TYPE = 'S' AND A.DST_ACCT_TYPE IN ('DST', 'VIB', 'VIN', 'VIR') GROUP BY A.EX_DOC_ID , A.LINE_NBR , A.DISTRIB_LINE_NUM , A.APPL_JRNL_ID, A.UNPOST_SEQ, A.FOREIGN_CURRENCY , A.CURRENCY_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SHEET_ID Character(10) VARCHAR2(10) NOT NULL Report ID

2 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

3 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line

4 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template

5 UNPOST_SEQ Number(2,0) SMALLINT NOT NULL Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1".

6 FOREIGN_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.

7 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SHEET_ID	Character(10)	VARCHAR2(10) NOT NULL	Report ID
2	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
3	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
4	APPL_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Journal Template
5	UNPOST_SEQ	Number(2,0)	SMALLINT NOT NULL	Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1".
6	FOREIGN_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.
7	FOREIGN_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Foreign Currency Code
8	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.
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code