CSH_FCST_MAP_IDEFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
CSH_FCST_GROUP(SQL Table) |
Index Back |
|---|---|
Cash Forecast Group By MappingMap Alias Name fields to generic Group By Fields to report cash forecasting numbers. These are user defined values in addition to the system defined Business Unit, Bank Account and Currency groupings. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CSH_FCST_MAP_ID |
Character(20) | VARCHAR2(20) NOT NULL | Uniquely identifies a Cash Forecasting Mapping. |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCRLONG | Long Character | CLOB | Long Description |