Contract Info File
When creating a scenario for new business analysis, you will be asked for a contract info file for the customer contract you want to analyze. This is a flat file (a tab-delimited or comma-delimited file) that contains detailed information about a new contract with a customer. In order to provide the proper input for analysis, ensure that the sequence of the fields in your file are as follows:
• Product Code/Name
• Quantity
• Location Name
• Postal Code
• On Site Required (Y/N)
• Customer Site Code/Name
• Replenishment Source
• Response Time (in minutes)
• DS
• Replenishment Length
• Contract Value
The order of these fields must be strictly followed. If no value is available for a field, you must still include a delimiter (tab or comma) to identify the field.
EXAMPLE
Here is an example of a row of data you might find in a contract info file:
Prod1,10,Profit-C,,N,CSC1,F,120,100,15,7
Each entry corresponds with a field in the order they are listed (Product Code/Name = Prod1, Quantity = 10, Location Name = Profit-C, Postal Code = [blank or null value], and so on). Note that if there is no value for a field, the file leaves the value blank, but includes a comma so that Servigistics understands that the field is blank.