Format and fields of the CUM import file

The CUM import file contains the data to retrieve existing single plans, to update the CUM data, and to publish the new plan.

The format and fields of the CUM import file must meet these requirements:

CUM import file requirements	Description
File format	The format of the CUM import file must be CSV.
Field separation	Fields must be separated by a semicolon.
Line separator	Lines are separated by the line separator that is used by the tenant where the application is installed. Normally the line separator is CR/LF.
Numeric fields	Numeric data can contain digits separated by a comma or a dot.
CUM fields	CUM data must be positive numbers.

This table shows the fields that are used to retrieve existing single plans:

Plan fields	Description
PlanAE	The accounting entity of the plan, required
PlanLocation	The location of the plan and the corresponding contract, required
CustomerID	The customer ID of the plan, required
CustomerAE	The accounting entity of the customer, only required if the same customer ID is used in different accounting entities
ShipToID	The ship to ID of the plan, required
ShipToAE	The accounting entity of the ship to ID, only required if the same ship to ID is used in different accounting entities
ItemID	The item ID of the plan, required
ItemAE	The accounting entity of the item, only required if the same item ID is used in different accounting entities
CustomerOrderNo	The customer order number of the plan, only required if plans contain more than one contract line with different customer order numbers

This table shows the fields that are used to import and update CUM data:

CUM fields	Description
ShippedCurrent	The current shipped CUM is required.
ShippedTotal	The total shipped CUM is optional. The default value is the current shipped CUM.
ShippedCurrentLSP	The current shipped CUM LSP is only required for the LSP process.
ShippedTotalLSP	The total shipped CUM LSP is optional and only used for the LSP process. The default value is the current shipped CUM LSP.
ReceivedTotal	The total received CUM is optional and only required if a CUM reset is performed. Otherwise, the total received CUM is preset with the current received CUM from the existing plan.