TR_DRILL_SEC_VW (SQL View)	Index Back
TR DRILL VIEW SHOWS A VIEW OF THE GL ACCOUNTING LINE DRILL DOWN TO TR ACCOUNTING ENTRY.

TR_DRILL_SEC_VW

(SQL View)

TR DRILL VIEW

SHOWS A VIEW OF THE GL ACCOUNTING LINE DRILL DOWN TO TR ACCOUNTING ENTRY.

SELECT L.BUSINESS_UNIT_GL , L.JOURNAL_LINE , L.JOURNAL_ID , L.JOURNAL_DATE , L.ACCOUNTING_ID , L.ACCOUNTING_LINE , L.APPL_JRNL_ID , L.ACCOUNT , L.ALTACCT , L.DEPTID , L.ACCOUNTING_DT , H.TRA_SOURCE_CD , H.SEQ_NBR , L.CURRENCY_CD , L.DESCR60 , L.STATISTIC_AMOUNT , L.STATISTICS_CODE , L.LEDGER , L.LEDGER_GROUP , L.FOREIGN_AMOUNT , L.FOREIGN_CURRENCY , L.FISCAL_YEAR , L.MONETARY_AMOUNT , %Substring(H.EVENT_ID,1,12) , H.EVENT_ID , H.EVENT_ID , H.BANK_ACCOUNT_NUM , H.TRAN_REF_ID , %Substring(H.EVENT_ID,1,12) , %Substring(H.EVENT_ID,1,10) , %Substring(H.EVENT_ID,1,12) , %subrec(CF14_AN_SBR,L) , L.PROJECT_ID , L.GL_DISTRIB_STATUS , L.RATE_MULT , L.RATE_DIV FROM PS_TRA_ACCTG_LINE L , PS_TRA_ACCTG_HDR H WHERE L.BUSINESS_UNIT = H.BUSINESS_UNIT AND L.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 JOURNAL_LINE Number(9,0) DECIMAL(9) NOT NULL Uniquely identifies a journal line with a sequence number. Within a single journal entry, the line sequence begins with 1 and automatically increments by 1 for each succeeding journal line. There can be any number of lines associated with a journal header.

3 JOURNAL_ID Character(10) VARCHAR2(10) NOT NULL Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.

4 JOURNAL_DATE Date(10) DATE Specifies the date the journal was created.

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

6 ACCOUNTING_LINE Number(5,0) INTEGER NOT NULL The specific unique numeric identifier that distinguishes debit and credits for a given treasury accounting ent

7 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template

8 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

9 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account

10 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

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

12 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

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

14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

15 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description

16 STATISTIC_AMOUNT Signed Number(17,2) DECIMAL(15,2) NOT NULL Specifies the amount associated with a statistical account on a journal line or a distribution line. It represents a quantity rather than a monetary amount and is qualified by the Unit of Measure associated with the STATISTICS_CODE or statistics ACCOUNT.

17 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code

18 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger

19 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group

20 FOREIGN_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.

21 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code

22 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

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

24 TREAS_HEADER_ID Character(12) VARCHAR2(12) NOT NULL The unique key identifier for a given deal transaction.

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

26 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.

27 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.

28 TRAN_REF_ID Character(20) VARCHAR2(20) NOT NULL Represents the unique transaction identifier in bank reconciliation processing.

29 BAX_TRANSFER_ID Character(12) VARCHAR2(12) NOT NULL An unique key identifier that represents a bank transfer transaction.

30 FCLTY_ID Character(12) VARCHAR2(12) NOT NULL A unique key identifier that represents a given counterparty facility.

31 TR_SOURCE_ID Character(12) VARCHAR2(12) NOT NULL An internal work field that represents a unique identifier for records depicting a given treasury po

32 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
Prompt Table: OPERUNT_NB_VW

33 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
Prompt Table: PRODUCT_NB_VW

34 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
Prompt Table: FUND_NB_VW

35 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
Prompt Table: CLASS_CF_NB_VW

36 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
Prompt Table: PROGRAM_NB_VW

37 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
Prompt Table: BUD_REF_NB_VW

38 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
Prompt Table: AFFILIATE_VW

39 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
Prompt Table: %EDIT_INTRA01

40 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
Prompt Table: %EDIT_INTRA02

41 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
Prompt Table: CF1_NB_VW

42 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
Prompt Table: CF2_NB_VW

43 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
Prompt Table: CF3_NB_VW

44 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
Prompt Table: BANK_CF_PROJ_VW

45 GL_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL Distribution Status
C=Available to Contracts
D=Distributed
G=Generated
H=Hold
I=Ignored
J=Creating Journals
M=Modified
N=None
P=To be processed
X=Waiting for Reversal

46 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

47 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	JOURNAL_LINE	Number(9,0)	DECIMAL(9) NOT NULL	Uniquely identifies a journal line with a sequence number. Within a single journal entry, the line sequence begins with 1 and automatically increments by 1 for each succeeding journal line. There can be any number of lines associated with a journal header.
3	JOURNAL_ID	Character(10)	VARCHAR2(10) NOT NULL	Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
4	JOURNAL_DATE	Date(10)	DATE	Specifies the date the journal was created.
5	ACCOUNTING_ID	Character(10)	VARCHAR2(10) NOT NULL	Represents the unique alphanumeric identifier for treasury-specific accounting entries.
6	ACCOUNTING_LINE	Number(5,0)	INTEGER NOT NULL	The specific unique numeric identifier that distinguishes debit and credits for a given treasury accounting ent
7	APPL_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Journal Template
8	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
9	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
10	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
11	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
12	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
13	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
14	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
15	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description
16	STATISTIC_AMOUNT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Specifies the amount associated with a statistical account on a journal line or a distribution line. It represents a quantity rather than a monetary amount and is qualified by the Unit of Measure associated with the STATISTICS_CODE or statistics ACCOUNT.
17	STATISTICS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Statistics Code
18	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
19	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
20	FOREIGN_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.
21	FOREIGN_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Foreign Currency Code
22	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
23	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.
24	TREAS_HEADER_ID	Character(12)	VARCHAR2(12) NOT NULL	The unique key identifier for a given deal transaction.
25	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).
26	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
27	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
28	TRAN_REF_ID	Character(20)	VARCHAR2(20) NOT NULL	Represents the unique transaction identifier in bank reconciliation processing.
29	BAX_TRANSFER_ID	Character(12)	VARCHAR2(12) NOT NULL	An unique key identifier that represents a bank transfer transaction.
30	FCLTY_ID	Character(12)	VARCHAR2(12) NOT NULL	A unique key identifier that represents a given counterparty facility.
31	TR_SOURCE_ID	Character(12)	VARCHAR2(12) NOT NULL	An internal work field that represents a unique identifier for records depicting a given treasury po
32	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPERUNT_NB_VW
33	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_NB_VW
34	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_NB_VW
35	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASS_CF_NB_VW
36	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_NB_VW
37	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_NB_VW
38	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
39	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
40	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
41	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CF1_NB_VW
42	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CF2_NB_VW
43	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CF3_NB_VW
44	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: BANK_CF_PROJ_VW
45	GL_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Distribution Status C=Available to Contracts D=Distributed G=Generated H=Hold I=Ignored J=Creating Journals M=Modified N=None P=To be processed X=Waiting for Reversal
46	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
47	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor