The Full Construct page column order is not always "User Friendly".
On initial observation it looks like the order can be controlled by the Field Priority in Target Design but that is not the case. The attached document based on a specific Target Design configuration illustrates the column order generated for the following:
NOTE: The column order in the Horizontal View is not the same as the DCS Table column order. Also the stTABLE columns are arranged in a third order. None of which is in the same order as the Target Design Field Priority.
Target Design is actually not even the best method of controlling the Page's Column order since any change to the column order would require another Sync To Map action that has other implications. We have implemented a Workaround that utilizes a separate page that allows the developer to configure the column priorities then click a button that updates the Horizontal View.
Column order on the page (web views) is already configurable via priority in Target Design. If you would like to make additional changes without syncing to Map, you should use the Construct Autogen Level feature.
Autoconstruct was meant to be a jumpstart to building DCS pages and is not expected to create perfect pages as you specifically want them on build. It is expected that the user would build when necessary, then manually modify the page as they see fit. In order to prevent those changes from being overwritten, there is a setting called 'Construct Auto Gen Level' on the vertical view of the Full Construction Target Source. I have pasted the DSP Help related to the field below.
Construct Auto Gen Level
This option controls whether the Construct page is updated or overwritten. Values are:
NOTE: This field defaults to Rebuild.
I have attached a screenshot for you to review.