EX_ACCTG_PEX_VW (SQL View)	Index Back
Expenses Accounting Line This record is the Expenses Accounting Line table. All accounting entries that are generated from Expense transactions are written here to be picked up the GL Journal Generator program and subsequently posted to the appropriate ledgers.

EX_ACCTG_PEX_VW

(SQL View)

Expenses Accounting Line

This record is the Expenses Accounting Line table. All accounting entries that are generated from Expense transactions are written here to be picked up the GL Journal Generator program and subsequently posted to the appropriate ledgers.

SELECT A.EX_DOC_ID , A.EX_DOC_TYPE , A.LINE_NBR , A.DISTRIB_LINE_NUM , A.DST_ACCT_TYPE , A.APPL_JRNL_ID , A.UNPOST_SEQ , ' ' , A.BUDGET_HDR_STATUS FROM PS_EX_ACCTG_LINE A WHERE A.EX_DOC_TYPE = 'R' AND A.DST_ACCT_TYPE = 'DST' AND A.BUDGET_HDR_STATUS <> 'V'

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

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

5 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

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

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

8 TRAVEL_AUTH_ID Character(10) VARCHAR2(10) NOT NULL Travel Authorization Identification. Number used to define travel authorizations. Key field on most travel authorization records and exists at level 0 for travel authorization panels.

9 BUDGET_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Checking Header Status
E=Error in Budget Check
I=Document In Processing
N=Not Budget Checked
P=Provisionally Valid
V=Valid

#	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	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
4	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
5	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
6	APPL_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Journal Template
7	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".
8	TRAVEL_AUTH_ID	Character(10)	VARCHAR2(10) NOT NULL	Travel Authorization Identification. Number used to define travel authorizations. Key field on most travel authorization records and exists at level 0 for travel authorization panels.
9	BUDGET_HDR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Budget Checking Header Status E=Error in Budget Check I=Document In Processing N=Not Budget Checked P=Provisionally Valid V=Valid