PeopleSoft 9.0
Cash Management

Table Name BNK_RCN_TRAN

Table Description
BNK_RCN_TRAN
Columns
Name Datatype Is PK Is FK
BNK_ID_NBR CHAR(20) Yes No
BANK_ACCOUNT_NUM CHAR(17) Yes No
TRAN_REF_ID CHAR(20) Yes No
TRAN_DT PSDATE Yes No
BUSINESS_UNIT CHAR(5) No Yes
TRAN_AMT DECIMAL(26,3) No No
CURRENCY_CD CHAR(3) No No
TRAN_DESCR CHAR(60) No No
RECON_TRANS_CODE CHAR(3) No No
RECON_TYPE CHAR(1) No No
RECON_STATUS CHAR(3) No No
RECONCILE_DT PSDATE No No
RECONCILE_OPRID CHAR(30) No No
RECON_CYCLE_NBR DECIMAL(10) No No
RECORD_SEQ_NUMBER DECIMAL(10) No No
STTLMNT_DT_ACTUAL PSDATE No No
ACCTG_TMPL_ID CHAR(15) No No
BUILD_ACCTG_STATUS CHAR(1) No No
TRA_PROCESS_STATUS CHAR(1) No No
PROCESS_INSTANCE DECIMAL(10) No No
OPRID CHAR(30) No No
DTTM_ENTERED PSDATETIME No No
RECON_RUN_ID CHAR(15) No No
BANK_ACCT_RVL_AMT DECIMAL(26,3) No No
DOC_TYPE CHAR(8) No No
Index
Name Type Unique Member
PS_BNK_RCN_TRAN PK Yes
Member(s) of "PS_BNK_RCN_TRAN" Index
BNK_ID_NBR
BANK_ACCOUNT_NUM
TRAN_REF_ID
TRAN_DT

Published April 30, 2007