UNDO_ACCTG_VW (SQL View)	Index Back
Acctg Line Header Search View Treasury Accounting Header Search View

UNDO_ACCTG_VW

(SQL View)

Acctg Line Header Search View

Treasury Accounting Header Search View

SELECT H.BUSINESS_UNIT , H.ACCOUNTING_ID , H.TRA_SOURCE_CD , H.EVENT_ID , H.ACCOUNTING_DT , H.ACCTG_EVENT_TYPE , H.SEQ_NBR , H.TRANSACTION_LEG , H.TRANSACTION_LINE , H.ACCTG_STATUS , H.BUILD_ACCOUNTING FROM PS_TRA_ACCTG_HDR H WHERE H.TRA_SOURCE_CD IN ('D','E') AND NOT EXISTS ( SELECT 'X' FROM PS_TRA_ACCTG_HDR X WHERE X.BUSINESS_UNIT = H.BUSINESS_UNIT AND X.EVENT_ID = H.EVENT_ID AND X. BUILD_ACCOUNTING = 'R' AND X.ORIG_ACCOUNTING_ID = H.ACCOUNTING_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 ACCOUNTING_ID Character(10) VARCHAR2(10) NOT NULL Represents the unique alphanumeric identifier for treasury-specific accounting entries.

3 TRA_SOURCE_CD Character(1) VARCHAR2(1) NOT NULL Note: Changes to Translate Values must also be made to TR_SOURCE_CD and SOURCE_TYPE. These 3 fields must be kept in sync. Values that are inactive are for use in TR Cash Flows only
B=BSP
D=Deals
E=Deal Fees
F=Facility Fees
H=Hedges
I=Interest
M=Deal: Estimated Maturity Accr
N=Netted Deal
O=Other
P=Investment Pools
R=EFT Fees
S=Securities
T=LC Fees
W=EFT Requests
X=Bank Transfers

4 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).

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

6 ACCTG_EVENT_TYPE Character(2) VARCHAR2(2) NOT NULL Accounting types for deal capture and hedging

7 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

8 TRANSACTION_LEG Number(1,0) SMALLINT NOT NULL The separate and distinct business positions of a given deal transaction line.
1=Pay Leg
2=Receive Leg

9 TRANSACTION_LINE Number(3,0) SMALLINT NOT NULL The separate and distinct base instrument type components of a given deal transaction.

10 ACCTG_STATUS Character(1) VARCHAR2(1) NOT NULL Indicates the state of a set of accounting entries.
C=Needs Correction
E=Error
F=Final
P=Provisional

11 BUILD_ACCOUNTING Character(1) VARCHAR2(1) NOT NULL Represents that the accounting build process for a given accounting entry has been completed.
A=Auto Accounting
O=On-Line Accounting
R=Reversal Accounting

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	ACCOUNTING_ID	Character(10)	VARCHAR2(10) NOT NULL	Represents the unique alphanumeric identifier for treasury-specific accounting entries.
3	TRA_SOURCE_CD	Character(1)	VARCHAR2(1) NOT NULL	Note: Changes to Translate Values must also be made to TR_SOURCE_CD and SOURCE_TYPE. These 3 fields must be kept in sync. Values that are inactive are for use in TR Cash Flows only B=BSP D=Deals E=Deal Fees F=Facility Fees H=Hedges I=Interest M=Deal: Estimated Maturity Accr N=Netted Deal O=Other P=Investment Pools R=EFT Fees S=Securities T=LC Fees W=EFT Requests X=Bank Transfers
4	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).
5	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
6	ACCTG_EVENT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Accounting types for deal capture and hedging
7	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
8	TRANSACTION_LEG	Number(1,0)	SMALLINT NOT NULL	The separate and distinct business positions of a given deal transaction line. 1=Pay Leg 2=Receive Leg
9	TRANSACTION_LINE	Number(3,0)	SMALLINT NOT NULL	The separate and distinct base instrument type components of a given deal transaction.
10	ACCTG_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Indicates the state of a set of accounting entries. C=Needs Correction E=Error F=Final P=Provisional
11	BUILD_ACCOUNTING	Character(1)	VARCHAR2(1) NOT NULL	Represents that the accounting build process for a given accounting entry has been completed. A=Auto Accounting O=On-Line Accounting R=Reversal Accounting