Microsoft Business Solutions Great Plains 8.0 Integration Manager Set 1

Software Development Kit Resource Descriptions Microsoft SQL Query Analyzer SQL Books Online

SY50000.idx and SY50000.dat SY50100.idx and SY50100.dat SY60000.idx and SY60000.dat SY50001.idx and SY50001.dat

Tab Delimited file SQL database Comma Delimited file All of the Above

Insert New Records ✘ Update Existing Records ✘ Both Insert and Update ✘ Neither, it is a read-only tool ✔

GL00100 GL10000 GL10001 GL00105

Rejected ✘ Converted and truncated ✘ Ignored ✘ Translated based on your setup ✔

Integration Level Field Level Translation Level Source Level

Windows 98/98 SE Windows 95 Windows 2000 Windows XP

Give the spreadsheet a name that matches the query name ✘ Define a named range within the spreadsheet ✘ Format the spreadsheet as a general format ✘ The first Excel row must have column names ✔

No, the Great Plains 8.0 adapter integrates at the table level ✘ Yes, the Great Plains 8.0 adapter is a macro interface integration, thus a user needs permission at thewindow level ✘ No, it depends on the database version you are using ✘ No, any user with rights to Integration Manager has rights to the windows ✔