PeopleSoft 9
Account Payables

Table Name BANK_ACCT_DEFN

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