BS_BBAL_PD_EC_C(SQL Table) |
Index Back |
|---|---|
BTF:Bank Acct Statement Bal LnBank Account Statement Bal Ln |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  TEST_CASE |
Character(30) | VARCHAR2(30) NOT NULL | BTF Test Case |
| 2 | COMPARE_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Compare report type
1=Delta (Results v.s Expected) 2=Expected data not in Results 3=Unexpected data in Results |
| 3 | COMPARE_SOURCE |
Character(1) | VARCHAR2(1) NOT NULL |
Compare data source (Actuals or Expected results).
A=Actuals E=Expected |
| 4 | STATEMENT_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Statement ID for bank statements, key on Bank Statement Header |
| 5 | BNK_ID_NBR |
Character(20) | VARCHAR2(20) NOT NULL | A literal alphanumeric attribute that uniquely identifies a given bank or counterparty. |
| 6 | BRANCH_ID |
Character(10) | VARCHAR2(10) NOT NULL | The local branch office identifier associated with a given bank/counterparty. |
| 7 | BANK_ACCOUNT_NUM |
Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |
| 8 | BANK_BALANCE_TYPE |
Character(8) | VARCHAR2(8) NOT NULL | Bank Balance Type code |
| 9 | 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. |
| 10 | BALANCE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Balance |
| 11 | ITEM_COUNT | Number(5,0) | INTEGER NOT NULL | Item Count |
| 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 | IMMEDIATE_BAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Available Balance |
| 14 | FLOAT1 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | One Day Float Balance |
| 15 | FLOAT2 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Two or More Days Float Balance |
| 16 | BSP_STMT_DT | Date(10) | DATE | Bank Statement Date |
| 17 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 18 | VALUE_DT | Date(10) | DATE | Equivalent to a deal transaction's settlement date. |
| 19 | BSP_PRCS_DT | Date(10) | DATE | Bank Statement Process Date |
| 20 | LOADED_SW | Character(1) | VARCHAR2(1) NOT NULL |
An internal work field that indicates whether a given treasury transaction successfully has been imp
Default Value: N |