PeopleSoft 9.0
Cash Management

Table Name BNK_BALANCE_TBL

Table Description
BNK_BALANCE_TBL
Columns
Name Datatype Is PK Is FK
BNK_ID_NBR CHAR(20) Yes No
BANK_ACCOUNT_NUM CHAR(17) Yes No
BANK_STMT_DT PSDATE Yes No
STMT_BAL_AVAIL DECIMAL(26,3) No No
CURRENCY_CD CHAR(3) No No
STMT_BAL_OPEN DECIMAL(26,3) No No
STMT_BAL_OPEN_DT PSDATE No No
STMT_BAL_CLOSE DECIMAL(26,3) No No
STMT_BAL_CLOSE_DT PSDATE No No
INT_BEARING_BAL DECIMAL(26,3) No No
INTEREST_ACCRUAL DECIMAL(26,3) No No
INT_ACCRD_SINCE_LP DECIMAL(26,3) No No
INTEREST_RECALC_SW CHAR(1) No No
OPRID CHAR(30) No No
DTTM_STAMP_SEC PSDATETIME No No
Index
Name Type Unique Member
PS_BNK_BALANCE_TBL PK Yes
Member(s) of "PS_BNK_BALANCE_TBL" Index
BNK_ID_NBR
BANK_ACCOUNT_NUM
BANK_STMT_DT

Published April 30, 2007