SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
CSH_FCST_RULE_IDPrompt Table: CSH_FCST_RULES
FCST_RULE_TYPE01=Amount
02=Date
03=Payment Method
04=Worksheet Offset
05=Replacement
CSH_FCST_RUL_VW(SQL View) |
Index Back |
|---|---|
Cash Forecast Rules ViewView over Cash Forecast Rules. |
| SELECT SETID , CSH_FCST_RULE_ID , FCST_RULE_TYPE FROM PS_CSH_FCST_RULES |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | CSH_FCST_RULE_ID |
Character(20) | VARCHAR2(20) NOT NULL |
Uniquely identifies a Cash Forecasting Rule. The identifier is manually entered by the user and not automatically generated by the system.
Prompt Table: CSH_FCST_RULES |
| 3 | FCST_RULE_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Categorizes the cash forecasting rule according to the field the rule processes (e.g. amount or date) or by worksheet offset for the Copy function.
01=Amount 02=Date 03=Payment Method 04=Worksheet Offset 05=Replacement |