Planned Volume field specifications

This table lists the field-column specifications in the Planned Volume 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 from the SO_SCHEDULE_GROUP table.
2 PLNVOL_DATE* Date yyyy-MM-dd HH:mm:ss The date to which the planned volume corresponds.
3 PLNVOL_TIME Date yyyy-MM-dd HH:mm:ss The time for the planned volume.
4 PLNVOL_VOLUME* Number 22 The planned volume for the interval.
5 INVTYP_ID* Number 22 The Interval Type ID from the SO_INTERVAL_TYPE table. Takes the following values:
  • 1: Daily
  • 2: 60 Minutes
  • 3: 30 Minutes
  • 4: 15 Minutes
  • 5: Weekly