Таблица: MP95 - «Forecasts». Маска имени таблицы: «MP95%cc00»
| Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
| MP95001 | NCHAR | STRING | 2 | 0 | 2 | Type | Type | 0 - Stock item forecast
1 - Distribution group forecast 11 - Stock item budget 12 - Distribution group budget |
1 | Да |
| MP95002 | NCHAR | STRING | 4 | 0 | 4 | ForecastNo | Forecast Number | 2 | Да | |
| MP95003 | NCHAR | STRING | 10 | 0 | 10 | Section | Segment Code | 3 | Да | |
| MP95004 | NCHAR | STRING | 35 | 0 | 35 | StockCode | Stock Item Code/Group Number | 4 | Да | |
| MP95005 | NCHAR | STRING | 6 | 0 | 6 | YearMonth | Date Needed (Year and Month) | 5 | Да | |
| MP95006 | NCHAR | STRING | 8 | 0 | 8 | NeedDate | Date Needed | 6 | Да | |
| MP95007 | NCHAR | STRING | 1 | 0 | 1 | DayWekMntYer | Date Unit | Defines the type of date that is entered in the Date Needed (MP95006):
0 - Day (YYYYMMDD) 1 - Week (YYYYWW) 2 - Month (YYYYMM) 3 - Year (YYYY) |
7 | Да |
| MP95008 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Quantity | Quantity | |||
| MP95009 | NCHAR | SWITCH | 1 | 0 | 1 | Distributer | Distributed | |||
| MP95010 | INT | INTEGER | 0 | 0 | 1 | DisFrWeekMon | Distributed Unit | 0 - Month based distribution
1 - Week based distribution 2 - Day based distribution |
||
| MP95011 | NVARCHAR | VSTRING | 6 | 0 | 6 | DisMonthList | Distribution List Month | |||
| MP95012 | NVARCHAR | VSTRING | 6 | 0 | 6 | DisWeekList | Distribution List Week | |||
| MP95013 | NVARCHAR | VSTRING | 6 | 0 | 6 | DisDayList | Distribution List Day | |||
| MP95014 | NVARCHAR | VSTRING | 4 | 0 | 4 | GroupNumber | Distribution Group |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR2 - 2.03.10355 | Material Production Control | Forecasts
/* */