Demand Forecasting Import Format

NOTE For general information on using imports, see Imports FAQ.

The following table lists the format for importing a record in Demand Forecasting Import.

Field	Starting Position	Ending Position	Maximum Length	Format	Required	Description
Requisition Number	1	7	7	Character	Yes	Enter the requisition number. This field is used to keep a group of line numbers on a single purchase order.
Line Number	8	11	4	Character	Yes	Enter the line number.
Product Code	12	39	28	Character	Yes	Enter a valid product code.
Supplier Code	40	48	9	Character	Yes	Enter a valid supplier code.
Location Prefix	49	53	5	Character	Yes	Enter a valid location prefix.
Item Description	54	83	30	Character	No	Enter the item description.
Unit of Measure	84	87	4	Character	Yes	Enter a valid unit of measure.
Unit Cost	88	99	12	->>>,>>>,>>9.9999	Yes	Enter the unit cost.
Order Quantity	100	106	7	->>>,>>>,>>9.9999	Yes	Enter the order quantity.

Prerequisites

Before using this import, the following must be set up:

The line numbers need to be unique for each requisition number, but not for the entire import file.

Example Requisition 1 has line numbers 1,2,3; Requisition 2 has line numbers 1,2,3.