SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
CSH_FCST_RULE_IDPrompt Table: CSH_FCST_RULES
DATE_RULES_VW(SQL View) |
Index Back |
|---|---|
Cash Forecast Rules ViewView over Cash Forecast Rules. Select only Date rules. FCST_RULE_TYPE equal to '02' or '03'. |
| SELECT SETID , CSH_FCST_RULE_ID FROM PS_CSH_FCST_RULES WHERE FCST_RULE_TYPE IN ('02', '03') |
| # | 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 |