PeopleSoft 9.0
Cash Management

Table Name CASH_FLOW_TR_CF

Table Description
CASH_FLOW_TR_CF
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
BANK_SETID CHAR(5) No No
BANK_CD_CUST CHAR(5) No No
BANK_CD CHAR(5) No No
BANK_ACCT_KEY CHAR(4) No No
ACCT_BUS_UNIT_GL CHAR(5) No No
BNK_ID_NBR CHAR(20) No No
BANK_ACCOUNT_NUM CHAR(17) No No
OPERATING_UNIT CHAR(8) No No
PRODUCT CHAR(6) No No
FUND_CODE CHAR(5) No No
CLASS_FLD CHAR(5) No No
PROGRAM_CODE CHAR(5) No No
BUDGET_REF CHAR(8) No No
AFFILIATE CHAR(5) No No
AFFILIATE_INTRA1 CHAR(10) No No
AFFILIATE_INTRA2 CHAR(10) No No
CHARTFIELD1 CHAR(10) No No
CHARTFIELD2 CHAR(10) No No
CHARTFIELD3 CHAR(10) No No
PROJECT_ID CHAR(15) No No
DEPTID CHAR(10) No No
Index
Name Type Unique Member
PS_CASH_FLOW_TR_CF PK Yes
Member(s) of "PS_CASH_FLOW_TR_CF" Index
TR_SOURCE_CD
SOURCE_BUS_UNIT
TR_SOURCE_ID
BUSINESS_DATE
CASH_FLOW_LINE
CASH_FLOW_LEG

Published April 30, 2007