BUSINESS_UNIT_GLPrompt Table: SP_BU_GL_NONVW
B=Biweekly
M=Monthly
Q=Quarterly
S=Semimonthly
W=Weekly
1=Sunday
2=Monday
3=Tuesday
4=Wednesday
5=Thursday
6=Friday
7=Saturday
Default Value: 7
BUS_UNIT_TBL_FC(SQL Table) |
Index Back |
|---|---|
FC Business UnitsBusiness Unit Setup for Forecasting |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_GL |
Character(5) | VARCHAR2(5) NOT NULL |
GL Business Unit
Prompt Table: SP_BU_GL_NONVW |
| 2 | FORECAST_FREQUENCY | Character(1) | VARCHAR2(1) NOT NULL |
Forecast Frequency
B=Biweekly M=Monthly Q=Quarterly S=Semimonthly W=Weekly |
| 3 | FORECAST_HORIZON | Number(3,0) | SMALLINT NOT NULL | Forecast Horizon |
| 4 | END_DAY_OF_PERIOD | Character(1) | VARCHAR2(1) NOT NULL |
Ending Day of Period
1=Sunday 2=Monday 3=Tuesday 4=Wednesday 5=Thursday 6=Friday 7=Saturday Default Value: 7 |