Forecast Import field specifications
This table lists the field-column specifications in the Forecast Import import interface. Fields with the asterisk (*) symbol are required.
| Col. | Field Name | Type | Size/Format | Description |
|---|---|---|---|---|
| 1 | SKDGRP_ID* | Number | 22 | The schedule group ID number from the SO_SCHEDULE_GROUP table. |
| 2 | FCSTEXT_DATE* | Date | yyyyMMdd | The forecast date. Note: The default for a blank value is
the current date.
|
| 3 | FCSTEXT_TIME* | Date | HH:mm:ss | The forecast hours. |
| 4 | FCSTEXT_VALUE* | Number | 22 |
Note: The default is 0.
|
| 5 | INVTYP_ID* | Number | 22 | The Interval Type ID from the SO_INTERVAL_TYPE table. Takes the following
values:
Note: The default is Daily.
|
| 6 | VOLTYP_ID | Number | 22 | The Volume Type ID number from the SO_VOLUME_TYPE table. |