TRA_EVENT_D_VW(SQL View) |
Index Back |
|---|---|
Treas. Acctg Event Calendar VwTreasury Accounting Event View - This view has 'Deals' and 'Deal Fees' Source Codes. This has Master ID in it. This helps in Partial Sell/Buyback. |
| SELECT C.BUSINESS_UNIT ,C.TR_SOURCE_CD ,C.EVENT_ID ,C.EVENT_DT ,C.TRANSACTION_LINE ,C.SEQ_NBR ,C.TRANSACTION_LEG ,C.ACCTG_EVENT_TYPE ,H.TREAS_MASTER_ID ,C.CASH_FLOW_LINE ,C.ACCTG_TMPL_ID ,C.ACCRUED_UP_TO_AMT ,C.CURRENCY_CD ,C.ACCRUED_UP_TO_AMT2 ,C.CURRENCY_CD_2 ,C.ACCRUED_UP_TO_DT ,C.END_DT ,C.GAIN_LOSS ,C.ACCRUED_AMT_BSE ,C.TRA_PROCESS_STATUS ,C.PROCESS_INSTANCE FROM PS_TRX_HEADER_TR H , PS_TRA_EVENT_CAL C WHERE C.BUSINESS_UNIT = H.BUSINESS_UNIT AND C.TR_SOURCE_CD IN ('D', 'E') AND C.EVENT_ID = H.TREAS_HEADER_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | TR_SOURCE_CD |
Character(1) | VARCHAR2(1) NOT NULL |
Note: Changes to Translate Values must also be made to TRA_SOURCE_CD and SOURCE_TYPE. These 3 fields must be kept in sync.
Values that are inactive are for use in TR Accounting 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 |
| 3 | 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). |
| 4 | EVENT_DT |
Date(10) | DATE NOT NULL | The date upon which an accounting event is scheduled to be processed and converted into corresponding accounting |
| 5 | TRANSACTION_LINE |
Number(3,0) | SMALLINT NOT NULL | The separate and distinct base instrument type components of a given deal transaction. |
| 6 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 7 | 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 |
| 8 | ACCTG_EVENT_TYPE |
Character(2) | VARCHAR2(2) NOT NULL | Accounting types for deal capture and hedging |
| 9 | TREAS_MASTER_ID | Character(12) | VARCHAR2(12) NOT NULL | Master ID for a given deal header. |
| 10 | CASH_FLOW_LINE | Number(15,0) | DECIMAL(15) NOT NULL | A sequential number that indicates the time order sequence of a given deal transaction's cash flows. |
| 11 | ACCTG_TMPL_ID | Character(15) | VARCHAR2(15) NOT NULL |
A unique key identifier that represents a predefined accounting template, that is a set of rules used to generate debits and credits.
Prompt Table: %EDIT_ACCT_TMPL |
| 12 | ACCRUED_UP_TO_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | "An internal work field utilized for calculating the interest |
| 13 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 14 | ACCRUED_UP_TO_AMT2 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | "An internal work field utilized for calculating the interest |
| 15 | CURRENCY_CD_2 | Character(3) | VARCHAR2(3) NOT NULL | Currency code 2 |
| 16 | ACCRUED_UP_TO_DT | Date(10) | DATE | The terminal date upon which accounting accruals have been calculated for a given deal transaction. |
| 17 | END_DT | Date(10) | DATE | End Date |
| 18 | GAIN_LOSS | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gain or Loss |
| 19 | ACCRUED_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Accrued Amount in Base Currency |
| 20 | TRA_PROCESS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
The processing status for a given accounting entry build.
A=Accruing D=Deactivated E=Error I=In Process N=Not Processed P=Processed T=Temporary Hold |
| 21 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |