Column
|
Data type
|
Required
|
Notes
|
Assignment Number
|
String
|
Yes
|
|
System Template
|
String
|
Yes
|
Possible values: Y, N
|
Cost Estimate Template Name
|
String
|
Yes
|
|
Cost Estimate Template Line Item Name
|
String
|
Yes
|
Cannot exceed 255 characters
|
Cost Estimate Description
|
String
|
Yes
|
Cannot exceed 100 characters
|
Number of Years
|
Integer
|
Yes
|
Possible values: 1,2,3,4,5,6
|
Currency
|
String
|
Yes
|
Currency Code must exist
|
Year1Amount
|
Decimal
|
No
|
|
Year2Amount
|
Decimal
|
No
|
Cannot specify if Number of Years < 2
|
Year3Amount
|
Decimal
|
No
|
Cannot specify if Number of Years < 3
|
Year4Amount
|
Decimal
|
No
|
Cannot specify if Number of Years < 4
|
Year5Amount
|
Decimal
|
No
|
Cannot specify if Number of Years < 5
|
Year6Amount
|
Decimal
|
No
|
Cannot specify if Number of Years < 6
|
Year1Label
|
String
|
Yes
|
Must be a four digit number
|
Possible Errors:
Number of columns is incorrect.
Assignment with specified Assignment Number does not exist.
Incorrect value or no value specified for System Template column.
Cost Estimate Template Name not found.
Cost Estimate Template Line Item Name not found.
Cost Estimate Description greater than 100 characters.
Number of Years missing or invalid value.
Currency does not exist.
Year X Amount specified when Number of Years is less than X.