What does the EQ Cost import record layout need to be structured?

How do I setup the EQ Cost import file?

Import record formats

The record may be one line or multiple lines. Although records can be split into two or more lines, an individual field cannot begin on one line and end on the next. These components make up the record format:

• Field Separators
• Spaces and Tabs
• Multiple line Records
• Comment Lines

Notes:

• A line is defined as a string of characters that ends with a carriage return/line feed. If you are manually creating an import file, the carriage return/line feed is generated when you press the [Enter] key.
• Be sure to insert a comma field separator between the last data field in the line and the continuation character. This prevents the import process from considering the + character to be a part of the data field. Also, be sure that the last data field of a record does not end with either a continuation character or a comma field separator.

Import entries cost record layout

If the type column is a check box or date, refer to Import field types for information on how the field can be entered.

The length column specifies the maximum number of significant characters allowed. Fields in the import file do not have to equal the specified length, as long as they contain correct information in the required format. If the field is numeric with decimals, the length column displays the number of allowable digits to the left and right of the decimal point. For example, if a numeric field can contain a monetary amount up to $999,999,999.99, the length will show 9.2. The decimal point must be included if there are decimal digits entered.

Commas are not permitted in numeric fields. For example, $11,349.24 is entered as 1134924. Fields that can contain negative numbers are shown in the table preceded by a minus sign ( - ). Do not enter a plus sign ( + ) for positive numbers. The plus sign is reserved as a continuation character.

The name in the field column will match the name displayed in the Inquiry Column Definition window, unless the name has been changed using File > Company Settings > Custom Descriptions. Some names have been abbreviated to conserve space. The order of fields in a record matches the order displayed in the inquiry list.

A required field is indicated in the comment column.

The following table indicates the number and sequence of each field for the cost record type.

Thank you