TRA_EVENT_CAL(SQL Table) |
Index Back |
|---|---|
Treas. Acctg Event CalendarTreas. Acctg Event Calendar |
| # | 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 | 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. |
| 10 | 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 |
| 11 | ACCRUED_UP_TO_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | "An internal work field utilized for calculating the interest |
| 12 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 13 | ACCRUED_UP_TO_AMT2 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | "An internal work field utilized for calculating the interest |
| 14 | CURRENCY_CD_2 | Character(3) | VARCHAR2(3) NOT NULL | Currency code 2 |
| 15 | ACCRUED_UP_TO_DT | Date(10) | DATE | The terminal date upon which accounting accruals have been calculated for a given deal transaction. |
| 16 | END_DT | Date(10) | DATE | End Date |
| 17 | GAIN_LOSS | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gain or Loss |
| 18 | ACCRUED_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Accrued Amount in Base Currency |
| 19 | 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 |
| 20 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 21 | DOC_TYPE | Character(8) | VARCHAR2(8) NOT NULL |
Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
Prompt Table: DOC_TYPE_TBL |