When building an export definition after adding the date field under Revenue>Revenue Details>Date the column order is thrown into what appears to be a miscellaneous order opposed to numerically.
We’re currently evaluating this issue for a fix in a service pack.
Steps to Duplicate
1. Go to Marketing Export Definitions. 2. Click the Add button. 3. Add a Direct Marketing Export Definition 4. Add the following fields to the export: a. Constituent>Households Belong To>Household Constituent> Lookup ID b. Revenue >Application details>Amount> c. Revenue Details> Date. 5. Before adding the date field notice that the Column order is correct, after adding the date field it gets thrown out of numerical order.