PeopleSoft 9.0
Cash Management

Table Name BANK_ACCT_DEFN

Table Description
BANK_ACCT_DEFN
Columns
Name Datatype Is PK Is FK
SETID char(5) Yes Yes
BANK_CD CHAR(5) Yes Yes
BANK_CD_CPTY CHAR(5) Yes No
BANK_ACCT_KEY CHAR(4) Yes No
BANK_ACCOUNT_NUM CHAR(17) No No
ACCT_STATUS CHAR(1) No No
DESCR CHAR(30) No No
DESCRSHORT CHAR(10) No No
BRANCH_NAME CHAR(10) No No
PYMNT_HANDLING_CD CHAR(2) No No
PYMNT_OVRD_AMT DECIMAL(26,3) No No
RECON_TYPE_FLG CHAR(1) No No
RECON_HEADER CHAR(1) No No
CURRENCY_CD CHAR(3) No No
CUR_RT_TYPE CHAR(5) No No
RATE_INDEX CHAR(10) No No
SETTLEMENT_ID CHAR(5) No Yes
BUSINESS_UNIT_GL CHAR(5) No No
LAST_PYMNT_ID_USED DECIMAL(10) No No
PYMNT_ID_REF_LEN SMALLINT No No
FRACT_RTG_NUM CHAR(20) No No
DFI_ID_NUM CHAR(12) No No
DFI_ID_QUAL CHAR(2) No No
NPL_BNK_CHRT_VALUE CHAR(15) No No
IU_PYBL_NPL_ACCT CHAR(10) No No
IU_RCVBL_NPL_ACCT CHAR(10) No No
CSH_PL_CLRG_ACCT CHAR(10) No No
CSH_PL_ACCT CHAR(10) No No
PL_BNK_ACCT_FLG CHAR(1) No No
AR CHAR(1) No No
AP CHAR(1) No No
TR CHAR(1) No No
BI CHAR(1) No No
EX CHAR(1) No No
PP_SW CHAR(1) No No
RCN_ACCTG_SW CHAR(1) No No
ENABLE_WF_SW CHAR(1) No No
DEPOSIT_TYPE CHAR(1) No No
FORECAST CHAR(1) No No
TARGET_BALANCE DECIMAL(26,3) No No
PRE_RECONCILE CHAR(1) No No
CASH_CNTL_USE_FLG CHAR(1) No No
DRAFT_CNTL_USE_FLG CHAR(1) No No
DRAFT_CNTL_AR_FLG CHAR(1) No No
DIT_USE_FLG CHAR(1) No No
CHECK_DIGIT CHAR(2) No No
INT_BASIS CHAR(2) No No
MARGIN_PTS SMALLINT No No
CREATION_DT PSDATE No No
OPRID_ENTERED_BY CHAR(30) No No
OPRID_LAST_UPDT CHAR(30) No No
DEPOSIT_BU CHAR(5) No No
DEBIT_RATE DECIMAL(6,3) No No
CREDIT_RATE DECIMAL(6,3) No No
BANK_ACCT_QUAL CHAR(1) No No
PREFERRED_LANGUAGE CHAR(3) No No
PAYER_ID_NUM CHAR(10) No No
BANK_ACCT_TYPE CHAR(2) No No
DEFAULT_ACCT_SW CHAR(1) No No
CHRG_BANK_CD CHAR(5) No No
CHRG_BANK_ACCT_KEY CHAR(4) No No
CREDIT_RT_INDEX CHAR(10) No No
CREDIT_RT_TYPE CHAR(5) No No
CREDIT_MARGIN_PTS DECIMAL(11,8) No No
DEBIT_RT_INDEX CHAR(10) No No
DEBIT_RT_TYPE CHAR(5) No No
DEBIT_MARGIN_PTS DECIMAL(11,8) No No
SCHEDULE CHAR(10) No No
POOL_ID CHAR(10) No No
INTEREST_SW CHAR(1) No No
BCH_CHRG_PAYEE_FLG CHAR(1) No No
IBAN_CHECK_DIGIT CHAR(2) No No
RFC_CODE CHAR(3) No No
PYCYCL_PAY_LIMIT DECIMAL(26,3) No No
PYCYCL_PAY_LMTCURR CHAR(3) No No
SINGLE_PAY_LIMIT DECIMAL(26,3) No No
SINGLE_PAY_LMTCURR CHAR(3) No No
IPAC_SENDER_DO CHAR(5) No No
BNK_RCN_CONTROL CHAR(1) No No
BNK_STMT_CONTROL CHAR(1) No No
IBAN_ID CHAR(34) No No
Index
Name Type Unique Member
PS_BANK_ACCT_DEFN PK Yes
Member(s) of "PS_BANK_ACCT_DEFN" Index
SETID
BANK_CD
BANK_CD_CPTY
BANK_ACCT_KEY

Published April 30, 2007