Table structure in Tools vs SQL server
When working in a development database it was noticed that the voucher staging table structure in Tools did not always follow the SQL structure in terms of field ordering.
Example: The Lease payment date field was listed in tools at position 7 and and in SQL at position 82. As expected it caused a date to integer insert error when doing a straight wild card insert.
Has anyone else come across this structure issue? We can overcome the insert error but we wanted to be sure the structure was not being changed internally for some other purpose.
Thanks in advance
Sunder
Director Data Analytics