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 |