EX_CA_LN_AW_VW2 (SQL View)	Index Back
Cash Advance Line Cash Advance Line additional information.

EX_CA_LN_AW_VW2

(SQL View)

Cash Advance Line

Cash Advance Line additional information.

SELECT A.ADVANCE_ID , A.LINE_NBR , B.DESCR , A.DESCR , A.MONETARY_AMOUNT , A.CURRENCY_CD FROM PS_EX_ADV_HLN_VW A , PS_EX_ADV_SRC_TBL B WHERE A.SETID = B.SETID AND B.ADVANCE_SOURCE = A.ADVANCE_SOURCE AND B.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_EX_ADV_SRC_TBL X WHERE X.SETID = B.SETID AND X.ADVANCE_SOURCE = B.ADVANCE_SOURCE AND X.EFF_STATUS = 'A' AND X.EFFDT <= %CurrentDateIn)

# 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 ADV_SOURCE_DESC Character(30) VARCHAR2(30) NOT NULL Advance Source

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

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

6 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	ADV_SOURCE_DESC	Character(30)	VARCHAR2(30) NOT NULL	Advance Source
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	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.
6	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code