Available Data Fields

This topic reviews all types of data that can be imported, and gives specific information about the *.DEF file's syntax. If a field is required, and its syntax is not provided in the *.DEF file (the field reference), Import will be terminated. In certain instances, if a field is not required and no data is present in any record to be imported for the field, you cannot leave it undefined. You must REM out or delete the line in the *.DEF file.

Field sizes are values and they are not necessarily those that apply to the organization being imported. The Administrator can see an organization's user defined values, using the Organization>Organization Information>Field Lengths tab.

Note: We recommend limiting your data to strictly alphabetic characters (A through Z) or numeric characters (0 through 9), and avoiding the use of symbols.

Click one of the following links to see a module's list of data field tables:

• General Ledger
• Accounts Payable
• Accounts Receivable
• Bank Reconciliation
• Fixed Assets
• Multicurrency
• Payroll
• Purchase Orders