Supported Fields for Item Demand Plan Imports
Each CSV file used for an import should include data for only one type of time period, either monthly, weekly, or daily. Also, it is strongly encouraged that your CSV file use the preferred format for each type, because these preferred formats support automatic mapping of data in the Import Assistant. Other formats are also supported but are more difficult to use.
The following table lists standard fields available for item demand plan imports:
Field |
Mapping Required? |
Notes |
---|---|---|
Body Fields |
||
External ID |
No |
— |
Internal ID |
No |
Available for updates only |
Item |
Yes |
Item must have a value of Time Phased for the Replenishment Method field to be valid for this field. |
Location |
Yes, if Multi-Location Inventory enabled |
— |
Memo |
No |
— |
Month |
No |
Redundant of Plan Start Date, Plan End Data fields |
Plan End Date |
Yes |
Can set default on Import Assistant mapping page instead of setting value in CSV file |
Plan Start Date |
Yes |
Can set default on Import Assistant mapping page instead of setting value in CSV file |
Subsidiary |
Yes, if OneWorld account |
— |
Unit of Measure |
No |
Available when Multiple Units of Measure is enabled |
View |
Yes |
Default value automatically set based on “Monthly Quantity”, “Weekly Quantity”, or “Daily Quantity” keywords, when preferred format used If not inferred from keywords in preferred format, valid values are as follows (case-insensitive):
|
Year |
No |
Redundant of Plan Start Date, Plan End Data fields |
Sublist Fields |
||
Day of the Week |
Yes, for Daily demand plans only |
Day of the week Value automatically set, based on date provided in CSV file, when preferred format used If not inferred from date provided in preferred format, can be name of day, such as Sunday (case-insensitive) |
Quantity |
Yes |
Represents either quantity per month, per week, or per day |
Start Date |
Yes |
Default value automatically set when preferred format used |
You shouldn't enable the Overwrite Sublists option for item demand plan imports. Enabling this option may result in errors when imported sublist data overwrites existing sublist values driven by body field values such as View.
The Import Assistant is available at Setup > Import/Export > Import Tasks > Import CSV Records. After you select the record type for import, you choose the import character encoding. For more information, see Select a Record Type for Import and Choose Import Character Encoding.