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.