EX_EXC3500_VW (SQL View)	Index Back
GL Balancing Report

EX_EXC3500_VW

(SQL View)

GL Balancing Report

SELECT A.EX_DOC_ID, A.EX_DOC_TYPE, A.DST_ACCT_TYPE, A.APPL_JRNL_ID, A.UNPOST_SEQ, A.LINE_NBR, A.DISTRIB_LINE_NUM, A.ACCOUNTING_DT, A.DOC_TYPE, A.DOC_SEQ_NBR, A.DOC_SEQ_DATE, A.BUSINESS_UNIT_GL, A.EMPLID, A.CURRENCY_CD, SUM(A.MONETARY_AMOUNT) FROM PS_EX_ACCTG_LINE A GROUP BY A.EX_DOC_ID, A.EX_DOC_TYPE, A.DST_ACCT_TYPE, A.APPL_JRNL_ID, A.UNPOST_SEQ, A.LINE_NBR, A.DISTRIB_LINE_NUM, A.ACCOUNTING_DT, A.DOC_TYPE, A.DOC_SEQ_NBR, A.DOC_SEQ_DATE, A.BUSINESS_UNIT_GL, A.EMPLID, A.CURRENCY_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EX_DOC_ID Character(10) VARCHAR2(10) NOT NULL Documentation ID

2 EX_DOC_TYPE Character(1) VARCHAR2(1) NOT NULL Identifies Expenses Document Type
A=Cash Advance
C=Time Report
J=Time Adjustment
M=Accrual - My Wallet
R=Accrual - Expense Report
S=Expense Report
T=Travel Authorization

3 DST_ACCT_TYPE Character(4) VARCHAR2(4) NOT NULL 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment

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 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

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

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

9 DOC_TYPE Character(8) VARCHAR2(8) NOT NULL Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.

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

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

12 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

13 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

15 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	EX_DOC_ID	Character(10)	VARCHAR2(10) NOT NULL	Documentation ID
2	EX_DOC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Identifies Expenses Document Type A=Cash Advance C=Time Report J=Time Adjustment M=Accrual - My Wallet R=Accrual - Expense Report S=Expense Report T=Travel Authorization
3	DST_ACCT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment
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	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
7	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
8	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
9	DOC_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
10	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.
11	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.
12	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
13	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
14	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
15	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.