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 |