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

TRA_ACCTG_SRCH

(SQL View)

Acctg Line Header Search View

Treasury Accounting Header Search View

SELECT BUSINESS_UNIT , ACCOUNTING_ID , TRA_SOURCE_CD , EVENT_ID , ACCOUNTING_DT , ACCTG_STATUS , BUILD_ACCOUNTING , PROCESS_INSTANCE FROM PS_TRA_ACCTG_HDR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_FS_NONVW

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

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

8 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_FS_NONVW
2	ACCOUNTING_ID	Character(10)	VARCHAR2(10) NOT NULL	Represents the unique alphanumeric identifier for treasury-specific accounting entries. Prompt Table: TRA_ACCTG_HDR
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
8	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance