The first row in the import file is interpreted as the header row. The header row is used to define which fields will be imported (as such, they are referred to as field-definition columns). The first three columns of the header row should contain the following captions, in order: “Cost Estimate Identifier”, “COST_ESTIMATE!ASSIGNMENT_ID”, and “COST_ESTIMATE!TEMPLATE_ID”.
The fourth column of the header row is the first “field-definition” column. Each field to be imported shall occupy one column. There should be at least one such column, and there is no upper limit to the number of columns. Every such column should be unique within the header row (no duplicate columns).
The format for each field-definition column is <table name>!<field name>. For example, in order to update the AMOUNT_YEAR1 field of a COST_ESTIMATE_LINE_ITEM record, the field-definition column should be COST_ESTIMATE_LINE_ITEM! AMOUNT_YEAR1. Note there are special fields, that are not actually directly associated to a table/field; these do not follow the <table name>!<field name> naming convention.