TRA_FISCPRD_AET(SQL Table) |
Index Back |
|---|---|
TR Acctg Fiscal Period CacheCache record for TRA_FISCPRD AEapplication library. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | AS_OF_DATE | Date(10) | DATE | As of Date |
| 3 | RUN_DT | Date(10) | DATE | Run Date |
| 4 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 5 | ACCOUNTING_PERIOD | Number(3,0) | SMALLINT NOT NULL | Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table. |
| 6 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 7 | 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 |
| 8 | 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 |
| 9 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 10 | TRANSACTION_LINE | Number(3,0) | SMALLINT NOT NULL | The separate and distinct base instrument type components of a given deal transaction. |
| 11 | 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 |
| 12 | ORIG_DISCPR_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents the original discount/premium amount deducted from the par price of a given deal transaction such as a bond. |
| 13 | DISCPR_END_DT | Date(10) | DATE | The end date up through which accounting accruals will be calculated for a given deal transaction. |
| 14 | DISCPR_ACCR_TO_DT | Date(10) | DATE | The date up through which accounting accruals have been calculated for a given deal transaction. |
| 15 | DISCPR_ACCR_TO_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amortized discount/premium amount. |
| 16 | PER_ACCR_DISCPR | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents the discount/premiun amount accrued during this fiscal period. |
| 17 | INT_ACCR_END_DT | Date(10) | DATE | The end date up through which accounting accruals will be calculated for a given deal transaction. |
| 18 | INT_ACCR_TO_DT | Date(10) | DATE | The date up through which accounting accruals have been calculated for a given deal transaction. |
| 19 | INT_ACCR_TO_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amortized interest amount. |
| 20 | PER_ACCR_INTEREST | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents the interest amount accrued during this fiscal period. |
| 21 | PRINCIPAL_BALANCE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The notional principal balance of a given deal transaction at commencement. |
| 22 | PRINCIPAL_PAYMENT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Payment that goes towards paying the principal. |
| 23 | INTEREST_PAYMENT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Payment that goes towards paying the interest. |
| 24 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 25 | AMOUNT_1 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount Work Field |
| 26 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 27 | INSTRMNT_BASE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Instrument base type used as a building block for Treasury deals
01=Interest Rate Physical 02=Interest Rate Swap 03=FX Deal Physical 04=Option 05=Option - Binary Payoff 06=Futures Contract 07=Commodity 08=Generic Instrument 09=Equity |
| 28 | TRANSACTION_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The nominal or actual deal transaction amount. |
| 29 | TRANSACTION_AMT_2 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The nominal transaction amount for the second leg of a deal transacation. |
| 30 | TRANSACT_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | "The nominal |
| 31 | TRANS_CURRENCY_2 | Character(3) | VARCHAR2(3) NOT NULL | "The nominal |
| 32 | NBR_OF_CONTRACTS | Signed Number(18,4) | DECIMAL(16,4) NOT NULL | This is the number of future contracts associated with a deal |
| 33 | QUANTITY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Interface |
| 34 | TRANS_LEG | Number(1,0) | SMALLINT NOT NULL | The separate and distinct business positions of a given deal transaction line. |
| 35 | EVENT_DT | Date(10) | DATE | The date upon which an accounting event is scheduled to be processed and converted into corresponding accounting |
| 36 | AE_DO_WHEN | Character(1) | VARCHAR2(1) NOT NULL | When |