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 |