CSH_FCST_MAP_IDEFFDTDefault Value: %date
SEQNUMFIELDNAME_TOPrompt Table: POS_FLD_GRP_VW
Prompt Table: %EDITTABLE
CSH_FCST_GRP_BY(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 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 4 | FIELDNAME_TO |
Character(18) | VARCHAR2(18) NOT NULL | Destination Field |
| 5 | ALIAS_NAME | Character(30) | VARCHAR2(30) NOT NULL |
"A user defined synonym
Prompt Table: POS_FLD_GRP_VW |
| 6 | DEFAULT_VALUE | Character(40) | VARCHAR2(40) NOT NULL |
Default Value
Prompt Table: %EDITTABLE |