EX_ADV_HLN_VW (SQL View)	Index Back
Expense Report Header Line Expense Report Header and Line information.

EX_ADV_HLN_VW

(SQL View)

Expense Report Header Line

Expense Report Header and Line information.

SELECT A.ADVANCE_ID , A.LINE_NBR , HDR.SETID , A.ADVANCE_SOURCE , A.DESCR , A.MONETARY_AMOUNT , A.CURRENCY_CD FROM PS_EX_ADV_LINE A , PS_EX_ADV_HDR HDR WHERE HDR.ADVANCE_ID = A.ADVANCE_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ADVANCE_ID Character(10) VARCHAR2(10) NOT NULL Advance ID

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

3 SETID Character(5) VARCHAR2(5) NOT NULL SetID

4 ADVANCE_SOURCE Character(4) VARCHAR2(4) NOT NULL Advance Source

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ADVANCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Advance ID
2	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product] Default Value: 1
3	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
4	ADVANCE_SOURCE	Character(4)	VARCHAR2(4) NOT NULL	Advance Source
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	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.
7	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code