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

TRA_ACCTG_VW

(SQL View)

Acctg Line Header Search View

Treasury Accounting Header Search View

SELECT H1.BUSINESS_UNIT , H1.ACCOUNTING_ID , H1.TRA_SOURCE_CD , H1.EVENT_ID , H1.ACCOUNTING_DT , H1.ACCTG_STATUS , H1.BUILD_ACCOUNTING FROM PS_TRA_ACCTG_HDR H1 WHERE ERROR_STATUS = '1' AND NOT EXISTS ( SELECT 'X' FROM PS_TRA_ACCTG_HDR H2 WHERE H2.BUSINESS_UNIT = H1.BUSINESS_UNIT AND H2.ORIG_ACCOUNTING_ID = H1.ACCOUNTING_ID) AND H1.TRA_SOURCE_CD <> 'B'

# 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_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

7 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_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
7	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