PeopleSoft 9.0
Cash Management

Table Name CASH_FLOW_NET

Table Description
CASH_FLOW_NET
Columns
Name Datatype Is PK Is FK
ACCT_BUS_UNIT_GL CHAR(5) Yes No
AS_OF_DATE PSDATE Yes No
TR_SOURCE_CD CHAR(1) Yes Yes
BUSINESS_DATE PSDATE Yes Yes
TR_SOURCE_ID CHAR(12) Yes Yes
SOURCE_BUS_UNIT CHAR(5) Yes Yes
CF_SOURCE_REF_ID CHAR(40) Yes No
CASH_FLOW_LINE DECIMAL(15) Yes Yes
CASH_FLOW_LEG SMALLINT Yes Yes
CASH_TYPE CHAR(2) No No
AMOUNT DECIMAL(26,3) No No
CURRENCY_CD CHAR(3) No No
BANK_SETID CHAR(5) No No
BANK_CD CHAR(5) No No
BANK_ACCT_KEY CHAR(4) No No
BNK_ID_NBR CHAR(20) No No
BANK_ACCOUNT_NUM CHAR(17) No No
TOTAL_RCV_AMT DECIMAL(26,3) No No
TOTAL_PAY_AMT DECIMAL(26,3) No No
TOTAL_FLOWS INT No No
SETTLEMENT_ID CHAR(5) No No
BANK_CD_CUST CHAR(5) No No
Index
Name Type Unique Member
PS_CASH_FLOW_NET PK Yes
Member(s) of "PS_CASH_FLOW_NET" Index
ACCT_BUS_UNIT_GL
AS_OF_DATE
TR_SOURCE_CD
BUSINESS_DATE
TR_SOURCE_ID
SOURCE_BUS_UNIT
CF_SOURCE_REF_ID
CASH_FLOW_LINE
CASH_FLOW_LEG

Published April 30, 2007