BANK_BALANCES(SQL Table) |
Index Back |
|---|---|
Bank BalancesThis table will store the various types of balances we get on a Bank Statement. Eg; Opening , Closing , Available |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BNK_ID_NBR |
Character(20) | VARCHAR2(20) NOT NULL | A literal alphanumeric attribute that uniquely identifies a given bank or counterparty. |
| 2 | BANK_ACCOUNT_NUM |
Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |
| 3 | RECON_CYCLE_NBR |
Number(10,0) | DECIMAL(10) NOT NULL | The bank statement ID. |
| 4 | BANK_STMT_CODE |
Character(8) | VARCHAR2(8) NOT NULL |
Bank Statement code - used to identify the codes used on the bank statement for different entires of balances and transactions.
Prompt Table: BALANCE_CODE_VW |
| 5 | VALUE_DT | Date(10) | DATE | Equivalent to a deal transaction's settlement date. |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: BNK_RCN_CYC.CURRENCY_CD |
| 7 | BALANCE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Balance |
| 8 | IMMEDIATE_BAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Available Balance |
| 9 | FLOAT1 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | One Day Float Balance |
| 10 | FLOAT2 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Two or More Days Float Balance |
| 11 | BANK_TRANS_CODE | Character(20) | VARCHAR2(20) NOT NULL | A code that describes the type of transaction submitted by the bank via report or flat file. |
| 12 | FUNDS_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Funds Availability Type
0=Immediate Availability 1=One-day Availability 2=Two-or more-day Availability D=Distributed Availability-vary S=Distributed Availability-fixed V=Value Dated Z=unknown |
| 13 | ITEM_COUNT | Number(5,0) | INTEGER NOT NULL | Item Count |