CASHFLWNET_TEO3(SQL Table) |
Index Back |
|---|---|
CCU TEO temp tableCCU temporary table for CASH_FLOW_NET |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | ACCT_BUS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | The general ledger business unit associated with a given bank/counterparty account. |
| 3 | AS_OF_DATE | Date(10) | DATE | As of Date |
| 4 | 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 |
| 5 | BUSINESS_DATE | Date(10) | DATE | Represents a date upon which business is conducted within a given company in a given country. |
| 6 | 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 |
| 7 | SOURCE_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Source Bus Unit |
| 8 | CF_SOURCE_REF_ID | Character(40) | VARCHAR2(40) NOT NULL | Reference identifier for a treasury system cash flow. |
| 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 | CASH_FLOW_LEG | Number(1,0) | SMALLINT NOT NULL | A sequential number that indicates the relationship between a cash flow and its corresponding deal transaction leg |
| 11 | CASH_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Represents the type of cash flow stored in the Treasury database.
01=Actual 02=Provisional 03=Sample 04=Deactivated |
| 12 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 13 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 14 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
Prompt Table: BANK_SETID_VW |
| 15 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table: BANK_CD_TBL |
| 16 | BANK_ACCT_KEY | Character(4) | VARCHAR2(4) NOT NULL |
A user defined unique identifier that facilitates the identification of a given account with a given bank
Prompt Table: BANK_ACCT_DEFN |
| 17 | BNK_ID_NBR | Character(20) | VARCHAR2(20) NOT NULL |
A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
Prompt Table: BANK_ID_VW |
| 18 | BANK_ACCOUNT_NUM | Character(35) | VARCHAR2(35) NOT NULL |
The literal unique identifier associated with a given bank/counterparty account.
Prompt Table: BANK_ACCTKEY_VW |
| 19 | TOTAL_RCV_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | An internal work field in the settlements module that contains a summary of all inbound transacti |
| 20 | TOTAL_PAY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | An internal work field in the settlements module that contains a summary of all outbound transact |
| 21 | TOTAL_FLOWS | Number(5,0) | INTEGER NOT NULL | Number of associated cash flows for a deal transaction. |
| 22 | SETTLEMENT_ID | Character(5) | VARCHAR2(5) NOT NULL | A unique key identifier that represents the settlement instructions for a given bank/counterparty and acc |
| 23 | BANK_CD_CUST | Character(5) | VARCHAR2(5) NOT NULL | Represents the customer bank or counterparty in a relationship that pairs differing sets of b |
| 24 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |