PeopleSoft 9.0
Cash Management

Table Name CASH_FLOW_TR

Table Description
CASH_FLOW_TR
Columns
Name Datatype Is PK Is FK
TR_SOURCE_CD CHAR(1) Yes Yes
SOURCE_BUS_UNIT CHAR(5) Yes Yes
TR_SOURCE_ID CHAR(12) Yes Yes
BUSINESS_DATE PSDATE Yes Yes
CASH_FLOW_LINE DECIMAL(15) Yes Yes
CASH_FLOW_LEG SMALLINT Yes Yes
PAY_DOC_SEQ INT No No
CASH_TYPE CHAR(2) No No
AMOUNT DECIMAL(26,3) No No
CURRENCY_CD CHAR(3) No No
BANK_SETID char(5) No Yes
BANK_CD_CUST CHAR(5) No No
BANK_CD CHAR(5) No Yes
BANK_ACCT_KEY CHAR(4) No Yes
ACCT_BUS_UNIT_GL CHAR(5) No No
BNK_ID_NBR CHAR(20) No No
BANK_ACCOUNT_NUM CHAR(17) No No
TRANSACTION_LINE SMALLINT No No
RECONCILE_DT PSDATE No No
RECONCILE_OPRID CHAR(30) No No
RECON_TYPE CHAR(1) No No
RECON_STATUS CHAR(3) No No
RECON_CYCLE_NBR DECIMAL(10) No No
RECORD_SEQ_NUMBER DECIMAL(10) No No
STTLMNT_DT_ACTUAL PSDATE No No
NET_STATUS CHAR(1) No No
SELECTED_OPRID CHAR(30) No No
SELECTED_DTTM PSDATETIME No No
APPROVAL_OPRID CHAR(30) No No
APPROVAL_DTTM PSDATETIME No No
CPTY_REFERENCE CHAR(15) No No
NET_REF_ID CHAR(12) No Yes
CF_SOURCE_REF_ID CHAR(40) No No
CP_NETTOR CHAR(30) No No
PYMNT_METHOD CHAR(3) No No
SETTLEMENT_ID CHAR(5) No No
PYMNT_SELCT_STATUS CHAR(1) No No
APPROVAL_FLG_TR CHAR(1) No No
APPROV_SUBMITTED CHAR(1) No No
PYMNT_ID CHAR(10) No No
CURRENCY_CD_BASE CHAR(3) No No
BASE_AMT DECIMAL(26,3) No No
BASE_CURRENCY_BNK CHAR(3) No No
BNK_RATE_DIV DECIMAL(15,8) No No
BNK_RATE_MULT DECIMAL(15,8) No No
CUR_RT_TYPE_BNK CHAR(5) No No
CURRENCY_PYMNT CHAR(3) No No
PAID_AMT DECIMAL(26,3) No No
PAID_AMT_BNK_BSE DECIMAL(26,3) No No
PAID_AMT_BSE DECIMAL(26,3) No No
PYMNT_RATE_DIV DECIMAL(15,8) No No
PYMNT_RATE_MULT DECIMAL(15,8) No No
PAY_CYCLE CHAR(6) No No
PAY_CYCLE_SEQ_NUM INT No No
BANK_STMT_DT PSDATE No No
RECON_RUN_ID CHAR(15) No No
BANK_ACCT_RVL_AMT DECIMAL(26,3) No No
STL_THROUGH CHAR(2) No No
EVENT_TRACKING_ID DECIMAL(10) No No
REPETITVE_TRNFR_CD CHAR(15) No No
DRAWDOWN_FLG CHAR(1) No No
PMT_ID CHAR(15) No No
PMT_STATUS CHAR(2) No No
FORMAT_ID CHAR(10) No No
TRP_BUSINESS_UNIT CHAR(5) No No
POOL_ID CHAR(10) No No
Index
Name Type Unique Member
PS_CASH_FLOW_TR PK Yes
PSACASH_FLOW_TR IE1 No
PSBCASH_FLOW_TR IE2 No
PSCCASH_FLOW_TR IE3 No
Member(s) of "PS_CASH_FLOW_TR" Index
TR_SOURCE_CD
SOURCE_BUS_UNIT
TR_SOURCE_ID
BUSINESS_DATE
CASH_FLOW_LINE
CASH_FLOW_LEG
Member(s) of "PSACASH_FLOW_TR" Index
TR_SOURCE_CD
SOURCE_BUS_UNIT
TR_SOURCE_ID
BUSINESS_DATE
TRANSACTION_LINE
CASH_FLOW_LEG
Member(s) of "PSBCASH_FLOW_TR" Index
NET_REF_ID
CF_SOURCE_REF_ID
TR_SOURCE_ID
Member(s) of "PSCCASH_FLOW_TR" Index
BNK_ID_NBR
BANK_ACCOUNT_NUM
CPTY_REFERENCE
BUSINESS_DATE

Published April 30, 2007