REV_POOL_VW (SQL View)	Index Back
Reversal Acctg Pool View Prompt for Investment Pool accounting entries. Used by Reverse Accounting Request run control. PeopleCode: REV_ACCTG_REQ.TRA_SOURCE_CD - FieldChange and RowInit

REV_POOL_VW

(SQL View)

Reversal Acctg Pool View

Prompt for Investment Pool accounting entries. Used by Reverse Accounting Request run control. PeopleCode: REV_ACCTG_REQ.TRA_SOURCE_CD - FieldChange and RowInit

SELECT DISTINCT BUSINESS_UNIT , EVENT_ID FROM PS_TRA_ACCTG_HDR WHERE TRA_SOURCE_CD = 'P' AND ERROR_STATUS = '1'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 EVENT_ID Character(20) VARCHAR2(20) NOT NULL The unique key identifier that enumerates Treasury accounting events. Accounting events are transaction events that have been created by the Treasury sources (deals, fees, bank transfers, EFTs, etc).

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	EVENT_ID	Character(20)	VARCHAR2(20) NOT NULL	The unique key identifier that enumerates Treasury accounting events. Accounting events are transaction events that have been created by the Treasury sources (deals, fees, bank transfers, EFTs, etc).