SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
SCENARIODefault Value: 1
F=Following
M=Modified Following
N=Modified Previous
P=Previous
Default Value: 0
Default Value: 0
Default Value: 0
POS_HISFR_RULES(SQL Table) |
Index Back |
|---|---|
Historical Forecasting HeaderThe header record for historical forecasticing. |
| # | 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 | SCENARIO |
Character(10) | VARCHAR2(10) NOT NULL | A unique key identifier that allows a treasury to classify distinct revaluation events as varying and divergent ca |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | WEIGHTING | Signed Number(10,5) | DECIMAL(8,5) NOT NULL |
Used for applying a weighting to totals.
e.g. Limit Utilisation totals
Default Value: 1 |
| 5 | BUSINESS_DT_RULE | Character(1) | VARCHAR2(1) NOT NULL |
How to change a date when it isn't a Business Day (when its a holiday), either:
Following,
Modified Following,
Previous,
Modified Previous
F=Following M=Modified Following N=Modified Previous P=Previous |
| 6 | POS_SHIFT_YEARS | Signed Number(4,0) | DECIMAL(3) NOT NULL |
Represents the number of years by which a cash position worksheet may be copied forward.
Default Value: 0 |
| 7 | POS_SHIFT_MONTHS | Signed Number(4,0) | DECIMAL(3) NOT NULL |
Represents the number of months by which a cash position worksheet may be copied forward.
Default Value: 0 |
| 8 | POS_SHIFT_DAYS | Signed Number(4,0) | DECIMAL(3) NOT NULL |
Represents the number of days by which a cash position worksheet may be copied forward.
Default Value: 0 |