Click or drag to resize

Forecast Data

This Option allows the Forecast Data to be sent to Ultriva. The fields marked as bold are required. Required fields must always have non-empty data.

Forecast Orders Flat File Field Definition

The following table defines the fields in Forecast Data file. The fields marked as bold are required. Required fields must always have non-empty data.

Note Note

Forecast supports Kanban parts also.

The Forecasts for kanban parts can only be viewed and cannot be released.

Forecast Data File for Planned Orders and exception Codes(inbound to Ultriva)

Field Name

Data Type

Length

Required

Nullable

Description

PlantCode

STRING

32

Y

N

Plant Code

ItemNo

STRING

32

Y

N

Item No.

VendorCode

STRING

32

Y

N

Supplier Code. Send Blank

DaysOffset

INTEGER

N/A

Y

N

Days Offset for Expediting/Defering open orders

ExceptionCode

STRING

32

Y

N

Defined Exception Code. Ordrs will be placed/Expedited/Deferred/Recalled based on that

QtySuggested

INTEGER

N/A

Y

N

Order Qty

OrderNum

STRING

64

Y

N

Order No.

OrderLineNum.

INTEGER

N/A

Y

N

Order Line No

OrderDate

DATETIME

N/A

Y

N

Current Order Date

StartDate

DATETIME

N/A

Y

N

Order Start Date

DueDate

DATETIME

N/A

Y

N

Order Due Date

CARDGID

STRING

32

Y

N

CardGID for already Open Order.

Forecast Data File for Gross Requirements(inbound to Ultriva)

Field Name

Data Type

Length

Required

Nullable

Description

PlantCode

STRING

32

Y

N

Plant Code

ItemNo

STRING

32

Y

N

Item No.

VendorCode

STRING

32

Y

N

Supplier Code. Send Blank if Not available.

DaysOffset

INTEGER

N/A

Y

N

Not Applicable. Send 0.

ExceptionCode

STRING

32

Y

N

Send "$GrossRequirements"

QtySuggested

INTEGER

N/A

Y

N

Forecast Qty

OrderNum

STRING

64

Y

N

Order No. if any. Send blank if None

OrderLineNum.

INTEGER

N/A

Y

N

Order Line No. if any. Send 0 of none

OrderDate

DATETIME

N/A

Y

N

Not Applicable. Send Blank

StartDate

DATETIME

N/A

Y

N

Not Applicable. Send Blank

DueDate

DATETIME

N/A

Y

N

Order Due Date