TRCOLLFOR_TEO3(SQL Table) |
Index Back |
---|---|
CCU TEO temp tableCCU temporary table for TR_COLL_FOR |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
3 | COLLATERAL_ID | Character(12) | VARCHAR2(12) NOT NULL | Collateral ID number. auto generated but can be overridden. |
4 | TR_SOURCE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Type of source, to which any collateral is pledged. Could a deal or a letter of credit or anything else like cash, etc.
D=Deal ID L=Letter of Credit ID O=Other P=Portfolio ID |
5 | SOURCE_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Source Bus Unit |
6 | 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).
Prompt Table:
%EDITTABLE
|
7 | PERCENTAGE_SHARE | Number(6,2) | DECIMAL(5,2) NOT NULL | Percentage of the deal that is pledged to the collateral. |
8 | AMOUNT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
9 | MTM_ACCTG_VALUE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The Fair Value (Mark to Market) of a Treasury Deal, or the Fair Value or Cash Flows of a hedged item |
10 | COLLAT_ALLOCATED | Date(10) | DATE | Date Collateral is removed from free inventory; segregated. |
11 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
12 | COLLAT_RELEASE | Date(10) | DATE | Date Collateral is expected to be released back into free inventory; unsegregated |
13 | DESCR20_MIXED | Character(20) | VARCHAR2(20) NOT NULL | Description 20 characters, mixed case |
14 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |