PeopleSoft 9.0 Cash Management |
Table Name | CASH_FLW_WK_TBL |
Table Description |
CASH_FLW_WK_TBL |
Columns |
Name | Datatype | Is PK | Is FK |
BUSINESS_UNIT | char(5) | Yes | No |
AS_OF_DATE | datetime | 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 |
NET_STATUS | char(1) | No | No |
APPROVAL_OPRID | char(30) | No | No |
CPTY_REFERENCE | char(15) | No | No |
TRANSACTION_DTTM | PSDATETIME | No | No |
PAY_ACTION_TR | char(8) | No | No |
SETTLEMENT_ID | char(5) | No | No |
BANK_CD_CUST | char(5) | No | No |
Index |
Name | Type | Unique | Member |
PS_CASH_FLW_WK_TBL | PK | Yes |
![]() |
Member(s) of "PS_CASH_FLW_WK_TBL" Index |
BUSINESS_UNIT |
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 |