It has been requested several times to print a report of the setup of Extender Windows. There isn’t currently a report for all of this, so we have this SQL script to pull this information together.
You will just need to replace TWO in the first line of the script to be the Dynamics GP company database that you want to run the script against to find the window setup. The results will show you the windows that are setup in Extender for the specific company. It is a really long script, so be sure that you have copied the entire thing.
Note: This script is designed to pull in the Extender Window Resources for a standard setup. While we try to make it as accurate as possible, we always recommend you check the results with your setup as we don’t guarantee its results.
_________________________________________________________
USE TWO
SELECT
W.Extender_Window_ID AS [Window ID],
W.Extender_Window_Name AS [Window Name],
CASE W.Extender_Window_Type WHEN 1 THEN ‘Field Entry’ WHEN 2 THEN ‘Note List’ WHEN 3 THEN ‘Window Group’ ELSE ” END AS [Window Type],
W.PRODID AS [Attached Product ID],
W.Long_Form_Name AS [Attached Form Name],
W.Long_Window_Name AS [Attached Window Name],
CASE W.INACTIVE WHEN 0 THEN ‘No’ WHEN 1 THEN ‘Yes’ ELSE ” END AS [Inactive],
W.Extender_Key_Fields_1 AS [Key Field 1],
W.Extender_Key_Fields_2 AS [Key Field 2],
W.Extender_Key_Fields_3 AS [Key Field 3],
W.Extender_Key_Fields_4 AS [Key Field 4],
W.Extender_Key_Fields_5 AS [Key Field 5],
isnull(F1.FIELDNAM,”) as [Field 1 Name], CASE F1.FIELDTYPE WHEN 1 THEN ‘Long String’ WHEN 2 THEN ‘Short String’ WHEN 3 THEN ‘Date’ WHEN 4 THEN ‘Currency’ WHEN 5 THEN ‘Number’ WHEN 6 THEN ‘List’ WHEN 7 THEN ‘Checkbox’ WHEN 8 THEN ‘Lookup’ WHEN 9 THEN ‘Percentage’ WHEN 10 THEN ‘Quantity’ WHEN 11 THEN ‘File’ WHEN 12 THEN ‘Folder’ WHEN 14 THEN ‘Time’ WHEN 15 THEN ‘Account’ WHEN 16 THEN ‘Phone Number’ WHEN 17 THEN ‘Email Address’ WHEN 18 THEN ‘Linked Lookup’ WHEN 20 THEN ‘Label’ WHEN 21 THEN ‘Website’ ELSE ” END AS [Field 1 Type],
isnull(F2.FIELDNAM,”) as [Field 2 Name], CASE F2.FIELDTYPE WHEN 1 THEN ‘Long String’ WHEN 2 THEN ‘Short String’ WHEN 3 THEN ‘Date’ WHEN 4 THEN ‘Currency’ WHEN 5 THEN ‘Number’ WHEN 6 THEN ‘List’ WHEN 7 THEN ‘Checkbox’ WHEN 8 THEN ‘Lookup’ WHEN 9 THEN ‘Percentage’ WHEN 10 THEN ‘Quantity’ WHEN 11 THEN ‘File’ WHEN 12 THEN ‘Folder’ WHEN 14 THEN ‘Time’ WHEN 15 THEN ‘Account’ WHEN 16 THEN ‘Phone Number’ WHEN 17 THEN ‘Email Address’ WHEN 18 THEN ‘Linked Lookup’ WHEN 20 THEN ‘Label’ WHEN 21 THEN ‘Website’ ELSE ” END AS [Field 2 Type],
isnull(F3.FIELDNAM,”) as [Field 3 Name], CASE F3.FIELDTYPE WHEN 1 THEN ‘Long String’ WHEN 2 THEN ‘Short String’ WHEN 3 THEN ‘Date’ WHEN 4 THEN ‘Currency’ WHEN 5 THEN ‘Number’ WHEN 6 THEN ‘List’ WHEN 7 THEN ‘Checkbox’ WHEN 8 THEN ‘Lookup’ WHEN 9 THEN ‘Percentage’ WHEN 10 THEN ‘Quantity’ WHEN 11 THEN ‘File’ WHEN 12 THEN ‘Folder’ WHEN 14 THEN ‘Time’ WHEN 15 THEN ‘Account’ WHEN 16 THEN ‘Phone Number’ WHEN 17 THEN ‘Email Address’ WHEN 18 THEN ‘Linked Lookup’ WHEN 20 THEN ‘Label’ WHEN 21 THEN ‘Website’ ELSE ” END AS [Field 3 Type],
isnull(F4.FIELDNAM,”) as [Field 4 Name], CASE F4.FIELDTYPE WHEN 1 THEN ‘Long String’ WHEN 2 THEN ‘Short String’ WHEN 3 THEN ‘Date’ WHEN 4 THEN ‘Currency’ WHEN 5 THEN ‘Number’ WHEN 6 THEN ‘List’ WHEN 7 THEN ‘Checkbox’ WHEN 8 THEN ‘Lookup’ WHEN 9 THEN ‘Percentage’ WHEN 10 THEN ‘Quantity’ WHEN 11 THEN ‘File’ WHEN 12 THEN ‘Folder’ WHEN 14 THEN ‘Time’ WHEN 15 THEN ‘Account’ WHEN 16 THEN ‘Phone Number’ WHEN 17 THEN ‘Email Address’ WHEN 18 THEN ‘Linked Lookup’ WHEN 20 THEN ‘Label’ WHEN 21 THEN ‘Website’ ELSE ” END AS [Field 4 Type],
isnull(F5.FIELDNAM,”) as [Field 5 Name], CASE F5.FIELDTYPE WHEN 1 THEN ‘Long String’ WHEN 2 THEN ‘Short String’ WHEN 3 THEN ‘Date’ WHEN 4 THEN ‘Currency’ WHEN 5 THEN ‘Number’ WHEN 6 THEN ‘List’ WHEN 7 THEN ‘Checkbox’ WHEN 8 THEN ‘Lookup’ WHEN 9 THEN ‘Percentage’ WHEN 10 THEN ‘Quantity’ WHEN 11 THEN ‘File’ WHEN 12 THEN ‘Folder’ WHEN 14 THEN ‘Time’ WHEN 15 THEN ‘Account’ WHEN 16 THEN ‘Phone Number’ WHEN 17 THEN ‘Email Address’ WHEN 18 THEN ‘Linked Lookup’ WHEN 20 THEN ‘Label’ WHEN 21 THEN ‘Website’ ELSE ” END AS [Field 5 Type],
isnull(F6.FIELDNAM,”) as [Field 6 Name], CASE F6.FIELDTYPE WHEN 1 THEN ‘Long String’ WHEN 2 THEN ‘Short String’ WHEN 3 THEN ‘Date’ WHEN 4 THEN ‘Currency’ WHEN 5 THEN ‘Number’ WHEN 6 THEN ‘List’ WHEN 7 THEN ‘Checkbox’ WHEN 8 THEN ‘Lookup’ WHEN 9 THEN ‘Percentage’ WHEN 10 THEN ‘Quantity’ WHEN 11 THEN ‘File’ WHEN 12 THEN ‘Folder’ WHEN 14 THEN ‘Time’ WHEN 15 THEN ‘Account’ WHEN 16 THEN ‘Phone Number’ WHEN 17 THEN ‘Email Address’ WHEN 18 THEN ‘Linked Lookup’ WHEN 20 THEN ‘Label’ WHEN 21 THEN ‘Website’ ELSE ” END AS [Field 6 Type],
isnull(F7.FIELDNAM,”) as [Field 7 Name], CASE F7.FIELDTYPE WHEN 1 THEN ‘Long String’ WHEN 2 THEN ‘Short String’ WHEN 3 THEN ‘Date’ WHEN 4 THEN ‘Currency’ WHEN 5 THEN ‘Number’ WHEN 6 THEN ‘List’ WHEN 7 THEN ‘Checkbox’ WHEN 8 THEN ‘Lookup’ WHEN 9 THEN ‘Percentage’ WHEN 10 THEN ‘Quantity’ WHEN 11 THEN ‘File’ WHEN 12 THEN ‘Folder’ WHEN 14 THEN ‘Time’ WHEN 15 THEN ‘Account’ WHEN 16 THEN ‘Phone Number’ WHEN 17 THEN ‘Email Address’ WHEN 18 THEN ‘Linked Lookup’ WHEN 20 THEN ‘Label’ WHEN 21 THEN ‘Website’ ELSE ” END AS [Field 7 Type],
isnull(F8.FIELDNAM,”) as [Field 8 Name], CASE F8.FIELDTYPE WHEN 1 THEN ‘Long String’ WHEN 2 THEN ‘Short String’ WHEN 3 THEN ‘Date’ WHEN 4 THEN ‘Currency’ WHEN 5 THEN ‘Number’ WHEN 6 THEN ‘List’ WHEN 7 THEN ‘Checkbox’ WHEN 8 THEN ‘Lookup’ WHEN 9 THEN ‘Percentage’ WHEN 10 THEN ‘Quantity’ WHEN 11 THEN ‘File’ WHEN 12 THEN ‘Folder’ WHEN 14 THEN ‘Time’ WHEN 15 THEN ‘Account’ WHEN 16 THEN ‘Phone Number’ WHEN 17 THEN ‘Email Address’ WHEN 18 THEN ‘Linked Lookup’ WHEN 20 THEN ‘Label’ WHEN 21 THEN ‘Website’ ELSE ” END AS [Field 8 Type],
isnull(F9.FIELDNAM,”) as [Field 9 Name], CASE F9.FIELDTYPE WHEN 1 THEN ‘Long String’ WHEN 2 THEN ‘Short String’ WHEN 3 THEN ‘Date’ WHEN 4 THEN ‘Currency’ WHEN 5 THEN ‘Number’ WHEN 6 THEN ‘List’ WHEN 7 THEN ‘Checkbox’ WHEN 8 THEN ‘Lookup’ WHEN 9 THEN ‘Percentage’ WHEN 10 THEN ‘Quantity’ WHEN 11 THEN ‘File’ WHEN 12 THEN ‘Folder’ WHEN 14 THEN ‘Time’ WHEN 15 THEN ‘Account’ WHEN 16 THEN ‘Phone Number’ WHEN 17 THEN ‘Email Address’ WHEN 18 THEN ‘Linked Lookup’ WHEN 20 THEN ‘Label’ WHEN 21 THEN ‘Website’ ELSE ” END AS [Field 9 Type],
isnull(F10.FIELDNAM,”) as [Field 10 Name], CASE F10.FIELDTYPE WHEN 1 THEN ‘Long String’ WHEN 2 THEN ‘Short String’ WHEN 3 THEN ‘Date’ WHEN 4 THEN ‘Currency’ WHEN 5 THEN ‘Number’ WHEN 6 THEN ‘List’ WHEN 7 THEN ‘Checkbox’ WHEN 8 THEN ‘Lookup’ WHEN 9 THEN ‘Percentage’ WHEN 10 THEN ‘Quantity’ WHEN 11 THEN ‘File’ WHEN 12 THEN ‘Folder’ WHEN 14 THEN ‘Time’ WHEN 15 THEN ‘Account’ WHEN 16 THEN ‘Phone Number’ WHEN 17 THEN ‘Email Address’ WHEN 18 THEN ‘Linked Lookup’ WHEN 20 THEN ‘Label’ WHEN 21 THEN ‘Website’ ELSE ” END AS [Field 10 Type],
isnull(F11.FIELDNAM,”) as [Field 11 Name], CASE F11.FIELDTYPE WHEN 1 THEN ‘Long String’ WHEN 2 THEN ‘Short String’ WHEN 3 THEN ‘Date’ WHEN 4 THEN ‘Currency’ WHEN 5 THEN ‘Number’ WHEN 6 THEN ‘List’ WHEN 7 THEN ‘Checkbox’ WHEN 8 THEN ‘Lookup’ WHEN 9 THEN ‘Percentage’ WHEN 10 THEN ‘Quantity’ WHEN 11 THEN ‘File’ WHEN 12 THEN ‘Folder’ WHEN 14 THEN ‘Time’ WHEN 15 THEN ‘Account’ WHEN 16 THEN ‘Phone Number’ WHEN 17 THEN ‘Email Address’ WHEN 18 THEN ‘Linked Lookup’ WHEN 20 THEN ‘Label’ WHEN 21 THEN ‘Website’ ELSE ” END AS [Field 11 Type],
isnull(F12.FIELDNAM,”) as [Field 12 Name], CASE F12.FIELDTYPE WHEN 1 THEN ‘Long String’ WHEN 2 THEN ‘Short String’ WHEN 3 THEN ‘Date’ WHEN 4 THEN ‘Currency’ WHEN 5 THEN ‘Number’ WHEN 6 THEN ‘List’ WHEN 7 THEN ‘Checkbox’ WHEN 8 THEN ‘Lookup’ WHEN 9 THEN ‘Percentage’ WHEN 10 THEN ‘Quantity’ WHEN 11 THEN ‘File’ WHEN 12 THEN ‘Folder’ WHEN 14 THEN ‘Time’ WHEN 15 THEN ‘Account’ WHEN 16 THEN ‘Phone Number’ WHEN 17 THEN ‘Email Address’ WHEN 18 THEN ‘Linked Lookup’ WHEN 20 THEN ‘Label’ WHEN 21 THEN ‘Website’ ELSE ” END AS [Field 12 Type],
isnull(F13.FIELDNAM,”) as [Field 13 Name], CASE F13.FIELDTYPE WHEN 1 THEN ‘Long String’ WHEN 2 THEN ‘Short String’ WHEN 3 THEN ‘Date’ WHEN 4 THEN ‘Currency’ WHEN 5 THEN ‘Number’ WHEN 6 THEN ‘List’ WHEN 7 THEN ‘Checkbox’ WHEN 8 THEN ‘Lookup’ WHEN 9 THEN ‘Percentage’ WHEN 10 THEN ‘Quantity’ WHEN 11 THEN ‘File’ WHEN 12 THEN ‘Folder’ WHEN 14 THEN ‘Time’ WHEN 15 THEN ‘Account’ WHEN 16 THEN ‘Phone Number’ WHEN 17 THEN ‘Email Address’ WHEN 18 THEN ‘Linked Lookup’ WHEN 20 THEN ‘Label’ WHEN 21 THEN ‘Website’ ELSE ” END AS [Field 13 Type],
isnull(F14.FIELDNAM,”) as [Field 14 Name], CASE F14.FIELDTYPE WHEN 1 THEN ‘Long String’ WHEN 2 THEN ‘Short String’ WHEN 3 THEN ‘Date’ WHEN 4 THEN ‘Currency’ WHEN 5 THEN ‘Number’ WHEN 6 THEN ‘List’ WHEN 7 THEN ‘Checkbox’ WHEN 8 THEN ‘Lookup’ WHEN 9 THEN ‘Percentage’ WHEN 10 THEN ‘Quantity’ WHEN 11 THEN ‘File’ WHEN 12 THEN ‘Folder’ WHEN 14 THEN ‘Time’ WHEN 15 THEN ‘Account’ WHEN 16 THEN ‘Phone Number’ WHEN 17 THEN ‘Email Address’ WHEN 18 THEN ‘Linked Lookup’ WHEN 20 THEN ‘Label’ WHEN 21 THEN ‘Website’ ELSE ” END AS [Field 14 Type],
isnull(F15.FIELDNAM,”) as [Field 15 Name], CASE F15.FIELDTYPE WHEN 1 THEN ‘Long String’ WHEN 2 THEN ‘Short String’ WHEN 3 THEN ‘Date’ WHEN 4 THEN ‘Currency’ WHEN 5 THEN ‘Number’ WHEN 6 THEN ‘List’ WHEN 7 THEN ‘Checkbox’ WHEN 8 THEN ‘Lookup’ WHEN 9 THEN ‘Percentage’ WHEN 10 THEN ‘Quantity’ WHEN 11 THEN ‘File’ WHEN 12 THEN ‘Folder’ WHEN 14 THEN ‘Time’ WHEN 15 THEN ‘Account’ WHEN 16 THEN ‘Phone Number’ WHEN 17 THEN ‘Email Address’ WHEN 18 THEN ‘Linked Lookup’ WHEN 20 THEN ‘Label’ WHEN 21 THEN ‘Website’ ELSE ” END AS [Field 15 Type],
isnull(F16.FIELDNAM,”) as [Field 16 Name], CASE F16.FIELDTYPE WHEN 1 THEN ‘Long String’ WHEN 2 THEN ‘Short String’ WHEN 3 THEN ‘Date’ WHEN 4 THEN ‘Currency’ WHEN 5 THEN ‘Number’ WHEN 6 THEN ‘List’ WHEN 7 THEN ‘Checkbox’ WHEN 8 THEN ‘Lookup’ WHEN 9 THEN ‘Percentage’ WHEN 10 THEN ‘Quantity’ WHEN 11 THEN ‘File’ WHEN 12 THEN ‘Folder’ WHEN 14 THEN ‘Time’ WHEN 15 THEN ‘Account’ WHEN 16 THEN ‘Phone Number’ WHEN 17 THEN ‘Email Address’ WHEN 18 THEN ‘Linked Lookup’ WHEN 20 THEN ‘Label’ WHEN 21 THEN ‘Website’ ELSE ” END AS [Field 16 Type],
isnull(F17.FIELDNAM,”) as [Field 17 Name], CASE F17.FIELDTYPE WHEN 1 THEN ‘Long String’ WHEN 2 THEN ‘Short String’ WHEN 3 THEN ‘Date’ WHEN 4 THEN ‘Currency’ WHEN 5 THEN ‘Number’ WHEN 6 THEN ‘List’ WHEN 7 THEN ‘Checkbox’ WHEN 8 THEN ‘Lookup’ WHEN 9 THEN ‘Percentage’ WHEN 10 THEN ‘Quantity’ WHEN 11 THEN ‘File’ WHEN 12 THEN ‘Folder’ WHEN 14 THEN ‘Time’ WHEN 15 THEN ‘Account’ WHEN 16 THEN ‘Phone Number’ WHEN 17 THEN ‘Email Address’ WHEN 18 THEN ‘Linked Lookup’ WHEN 20 THEN ‘Label’ WHEN 21 THEN ‘Website’ ELSE ” END AS [Field 17 Type],
isnull(F18.FIELDNAM,”) as [Field 18 Name], CASE F18.FIELDTYPE WHEN 1 THEN ‘Long String’ WHEN 2 THEN ‘Short String’ WHEN 3 THEN ‘Date’ WHEN 4 THEN ‘Currency’ WHEN 5 THEN ‘Number’ WHEN 6 THEN ‘List’ WHEN 7 THEN ‘Checkbox’ WHEN 8 THEN ‘Lookup’ WHEN 9 THEN ‘Percentage’ WHEN 10 THEN ‘Quantity’ WHEN 11 THEN ‘File’ WHEN 12 THEN ‘Folder’ WHEN 14 THEN ‘Time’ WHEN 15 THEN ‘Account’ WHEN 16 THEN ‘Phone Number’ WHEN 17 THEN ‘Email Address’ WHEN 18 THEN ‘Linked Lookup’ WHEN 20 THEN ‘Label’ WHEN 21 THEN ‘Website’ ELSE ” END AS [Field 18 Type],
isnull(F19.FIELDNAM,”) as [Field 19 Name], CASE F19.FIELDTYPE WHEN 1 THEN ‘Long String’ WHEN 2 THEN ‘Short String’ WHEN 3 THEN ‘Date’ WHEN 4 THEN ‘Currency’ WHEN 5 THEN ‘Number’ WHEN 6 THEN ‘List’ WHEN 7 THEN ‘Checkbox’ WHEN 8 THEN ‘Lookup’ WHEN 9 THEN ‘Percentage’ WHEN 10 THEN ‘Quantity’ WHEN 11 THEN ‘File’ WHEN 12 THEN ‘Folder’ WHEN 14 THEN ‘Time’ WHEN 15 THEN ‘Account’ WHEN 16 THEN ‘Phone Number’ WHEN 17 THEN ‘Email Address’ WHEN 18 THEN ‘Linked Lookup’ WHEN 20 THEN ‘Label’ WHEN 21 THEN ‘Website’ ELSE ” END AS [Field 19 Type],
isnull(F20.FIELDNAM,”) as [Field 20 Name], CASE F20.FIELDTYPE WHEN 1 THEN ‘Long String’ WHEN 2 THEN ‘Short String’ WHEN 3 THEN ‘Date’ WHEN 4 THEN ‘Currency’ WHEN 5 THEN ‘Number’ WHEN 6 THEN ‘List’ WHEN 7 THEN ‘Checkbox’ WHEN 8 THEN ‘Lookup’ WHEN 9 THEN ‘Percentage’ WHEN 10 THEN ‘Quantity’ WHEN 11 THEN ‘File’ WHEN 12 THEN ‘Folder’ WHEN 14 THEN ‘Time’ WHEN 15 THEN ‘Account’ WHEN 16 THEN ‘Phone Number’ WHEN 17 THEN ‘Email Address’ WHEN 18 THEN ‘Linked Lookup’ WHEN 20 THEN ‘Label’ WHEN 21 THEN ‘Website’ ELSE ” END AS [Field 20 Type],
isnull(F21.FIELDNAM,”) as [Field 21 Name], CASE F21.FIELDTYPE WHEN 1 THEN ‘Long String’ WHEN 2 THEN ‘Short String’ WHEN 3 THEN ‘Date’ WHEN 4 THEN ‘Currency’ WHEN 5 THEN ‘Number’ WHEN 6 THEN ‘List’ WHEN 7 THEN ‘Checkbox’ WHEN 8 THEN ‘Lookup’ WHEN 9 THEN ‘Percentage’ WHEN 10 THEN ‘Quantity’ WHEN 11 THEN ‘File’ WHEN 12 THEN ‘Folder’ WHEN 14 THEN ‘Time’ WHEN 15 THEN ‘Account’ WHEN 16 THEN ‘Phone Number’ WHEN 17 THEN ‘Email Address’ WHEN 18 THEN ‘Linked Lookup’ WHEN 20 THEN ‘Label’ WHEN 21 THEN ‘Website’ ELSE ” END AS [Field 21 Type],
isnull(F22.FIELDNAM,”) as [Field 22 Name], CASE F22.FIELDTYPE WHEN 1 THEN ‘Long String’ WHEN 2 THEN ‘Short String’ WHEN 3 THEN ‘Date’ WHEN 4 THEN ‘Currency’ WHEN 5 THEN ‘Number’ WHEN 6 THEN ‘List’ WHEN 7 THEN ‘Checkbox’ WHEN 8 THEN ‘Lookup’ WHEN 9 THEN ‘Percentage’ WHEN 10 THEN ‘Quantity’ WHEN 11 THEN ‘File’ WHEN 12 THEN ‘Folder’ WHEN 14 THEN ‘Time’ WHEN 15 THEN ‘Account’ WHEN 16 THEN ‘Phone Number’ WHEN 17 THEN ‘Email Address’ WHEN 18 THEN ‘Linked Lookup’ WHEN 20 THEN ‘Label’ WHEN 21 THEN ‘Website’ ELSE ” END AS [Field 22 Type],
isnull(F23.FIELDNAM,”) as [Field 23 Name], CASE F23.FIELDTYPE WHEN 1 THEN ‘Long String’ WHEN 2 THEN ‘Short String’ WHEN 3 THEN ‘Date’ WHEN 4 THEN ‘Currency’ WHEN 5 THEN ‘Number’ WHEN 6 THEN ‘List’ WHEN 7 THEN ‘Checkbox’ WHEN 8 THEN ‘Lookup’ WHEN 9 THEN ‘Percentage’ WHEN 10 THEN ‘Quantity’ WHEN 11 THEN ‘File’ WHEN 12 THEN ‘Folder’ WHEN 14 THEN ‘Time’ WHEN 15 THEN ‘Account’ WHEN 16 THEN ‘Phone Number’ WHEN 17 THEN ‘Email Address’ WHEN 18 THEN ‘Linked Lookup’ WHEN 20 THEN ‘Label’ WHEN 21 THEN ‘Website’ ELSE ” END AS [Field 23 Type],
isnull(F24.FIELDNAM,”) as [Field 24 Name], CASE F24.FIELDTYPE WHEN 1 THEN ‘Long String’ WHEN 2 THEN ‘Short String’ WHEN 3 THEN ‘Date’ WHEN 4 THEN ‘Currency’ WHEN 5 THEN ‘Number’ WHEN 6 THEN ‘List’ WHEN 7 THEN ‘Checkbox’ WHEN 8 THEN ‘Lookup’ WHEN 9 THEN ‘Percentage’ WHEN 10 THEN ‘Quantity’ WHEN 11 THEN ‘File’ WHEN 12 THEN ‘Folder’ WHEN 14 THEN ‘Time’ WHEN 15 THEN ‘Account’ WHEN 16 THEN ‘Phone Number’ WHEN 17 THEN ‘Email Address’ WHEN 18 THEN ‘Linked Lookup’ WHEN 20 THEN ‘Label’ WHEN 21 THEN ‘Website’ ELSE ” END AS [Field 24 Type],
isnull(F25.FIELDNAM,”) as [Field 25 Name], CASE F25.FIELDTYPE WHEN 1 THEN ‘Long String’ WHEN 2 THEN ‘Short String’ WHEN 3 THEN ‘Date’ WHEN 4 THEN ‘Currency’ WHEN 5 THEN ‘Number’ WHEN 6 THEN ‘List’ WHEN 7 THEN ‘Checkbox’ WHEN 8 THEN ‘Lookup’ WHEN 9 THEN ‘Percentage’ WHEN 10 THEN ‘Quantity’ WHEN 11 THEN ‘File’ WHEN 12 THEN ‘Folder’ WHEN 14 THEN ‘Time’ WHEN 15 THEN ‘Account’ WHEN 16 THEN ‘Phone Number’ WHEN 17 THEN ‘Email Address’ WHEN 18 THEN ‘Linked Lookup’ WHEN 20 THEN ‘Label’ WHEN 21 THEN ‘Website’ ELSE ” END AS [Field 25 Type],
isnull(F26.FIELDNAM,”) as [Field 26 Name], CASE F26.FIELDTYPE WHEN 1 THEN ‘Long String’ WHEN 2 THEN ‘Short String’ WHEN 3 THEN ‘Date’ WHEN 4 THEN ‘Currency’ WHEN 5 THEN ‘Number’ WHEN 6 THEN ‘List’ WHEN 7 THEN ‘Checkbox’ WHEN 8 THEN ‘Lookup’ WHEN 9 THEN ‘Percentage’ WHEN 10 THEN ‘Quantity’ WHEN 11 THEN ‘File’ WHEN 12 THEN ‘Folder’ WHEN 14 THEN ‘Time’ WHEN 15 THEN ‘Account’ WHEN 16 THEN ‘Phone Number’ WHEN 17 THEN ‘Email Address’ WHEN 18 THEN ‘Linked Lookup’ WHEN 20 THEN ‘Label’ WHEN 21 THEN ‘Website’ ELSE ” END AS [Field 26 Type],
isnull(F27.FIELDNAM,”) as [Field 27 Name], CASE F27.FIELDTYPE WHEN 1 THEN ‘Long String’ WHEN 2 THEN ‘Short String’ WHEN 3 THEN ‘Date’ WHEN 4 THEN ‘Currency’ WHEN 5 THEN ‘Number’ WHEN 6 THEN ‘List’ WHEN 7 THEN ‘Checkbox’ WHEN 8 THEN ‘Lookup’ WHEN 9 THEN ‘Percentage’ WHEN 10 THEN ‘Quantity’ WHEN 11 THEN ‘File’ WHEN 12 THEN ‘Folder’ WHEN 14 THEN ‘Time’ WHEN 15 THEN ‘Account’ WHEN 16 THEN ‘Phone Number’ WHEN 17 THEN ‘Email Address’ WHEN 18 THEN ‘Linked Lookup’ WHEN 20 THEN ‘Label’ WHEN 21 THEN ‘Website’ ELSE ” END AS [Field 27 Type],
isnull(F28.FIELDNAM,”) as [Field 28 Name], CASE F28.FIELDTYPE WHEN 1 THEN ‘Long String’ WHEN 2 THEN ‘Short String’ WHEN 3 THEN ‘Date’ WHEN 4 THEN ‘Currency’ WHEN 5 THEN ‘Number’ WHEN 6 THEN ‘List’ WHEN 7 THEN ‘Checkbox’ WHEN 8 THEN ‘Lookup’ WHEN 9 THEN ‘Percentage’ WHEN 10 THEN ‘Quantity’ WHEN 11 THEN ‘File’ WHEN 12 THEN ‘Folder’ WHEN 14 THEN ‘Time’ WHEN 15 THEN ‘Account’ WHEN 16 THEN ‘Phone Number’ WHEN 17 THEN ‘Email Address’ WHEN 18 THEN ‘Linked Lookup’ WHEN 20 THEN ‘Label’ WHEN 21 THEN ‘Website’ ELSE ” END AS [Field 28 Type],
isnull(F29.FIELDNAM,”) as [Field 29 Name], CASE F29.FIELDTYPE WHEN 1 THEN ‘Long String’ WHEN 2 THEN ‘Short String’ WHEN 3 THEN ‘Date’ WHEN 4 THEN ‘Currency’ WHEN 5 THEN ‘Number’ WHEN 6 THEN ‘List’ WHEN 7 THEN ‘Checkbox’ WHEN 8 THEN ‘Lookup’ WHEN 9 THEN ‘Percentage’ WHEN 10 THEN ‘Quantity’ WHEN 11 THEN ‘File’ WHEN 12 THEN ‘Folder’ WHEN 14 THEN ‘Time’ WHEN 15 THEN ‘Account’ WHEN 16 THEN ‘Phone Number’ WHEN 17 THEN ‘Email Address’ WHEN 18 THEN ‘Linked Lookup’ WHEN 20 THEN ‘Label’ WHEN 21 THEN ‘Website’ ELSE ” END AS [Field 29 Type],
isnull(F30.FIELDNAM,”) as [Field 30 Name], CASE F30.FIELDTYPE WHEN 1 THEN ‘Long String’ WHEN 2 THEN ‘Short String’ WHEN 3 THEN ‘Date’ WHEN 4 THEN ‘Currency’ WHEN 5 THEN ‘Number’ WHEN 6 THEN ‘List’ WHEN 7 THEN ‘Checkbox’ WHEN 8 THEN ‘Lookup’ WHEN 9 THEN ‘Percentage’ WHEN 10 THEN ‘Quantity’ WHEN 11 THEN ‘File’ WHEN 12 THEN ‘Folder’ WHEN 14 THEN ‘Time’ WHEN 15 THEN ‘Account’ WHEN 16 THEN ‘Phone Number’ WHEN 17 THEN ‘Email Address’ WHEN 18 THEN ‘Linked Lookup’ WHEN 20 THEN ‘Label’ WHEN 21 THEN ‘Website’ ELSE ” END AS [Field 30 Type],
isnull(D1.FIELDNAM,”) AS [Detail Field 1 Name], CASE D1.FIELDTYPE WHEN 1 THEN ‘Long String’ WHEN 2 THEN ‘Short String’ WHEN 3 THEN ‘Date’ WHEN 4 THEN ‘Currency’ WHEN 5 THEN ‘Number’ WHEN 6 THEN ‘List’ WHEN 7 THEN ‘Checkbox’ WHEN 8 THEN ‘Lookup’ WHEN 9 THEN ‘Percentage’ WHEN 10 THEN ‘Quantity’ WHEN 11 THEN ‘File’ WHEN 12 THEN ‘Folder’ WHEN 14 THEN ‘Time’ WHEN 15 THEN ‘Account’ WHEN 16 THEN ‘Phone Number’ WHEN 17 THEN ‘Email Address’ WHEN 18 THEN ‘Linked Lookup’ WHEN 20 THEN ‘Label’ WHEN 21 THEN ‘Website’ ELSE ” END AS [Detail Field 1 Type],
isnull(D2.FIELDNAM,”) AS [Detail Field 2 Name], CASE D2.FIELDTYPE WHEN 1 THEN ‘Long String’ WHEN 2 THEN ‘Short String’ WHEN 3 THEN ‘Date’ WHEN 4 THEN ‘Currency’ WHEN 5 THEN ‘Number’ WHEN 6 THEN ‘List’ WHEN 7 THEN ‘Checkbox’ WHEN 8 THEN ‘Lookup’ WHEN 9 THEN ‘Percentage’ WHEN 10 THEN ‘Quantity’ WHEN 11 THEN ‘File’ WHEN 12 THEN ‘Folder’ WHEN 14 THEN ‘Time’ WHEN 15 THEN ‘Account’ WHEN 16 THEN ‘Phone Number’ WHEN 17 THEN ‘Email Address’ WHEN 18 THEN ‘Linked Lookup’ WHEN 20 THEN ‘Label’ WHEN 21 THEN ‘Website’ ELSE ” END AS [Detail Field 2 Type],
isnull(D3.FIELDNAM,”) AS [Detail Field 3 Name], CASE D3.FIELDTYPE WHEN 1 THEN ‘Long String’ WHEN 2 THEN ‘Short String’ WHEN 3 THEN ‘Date’ WHEN 4 THEN ‘Currency’ WHEN 5 THEN ‘Number’ WHEN 6 THEN ‘List’ WHEN 7 THEN ‘Checkbox’ WHEN 8 THEN ‘Lookup’ WHEN 9 THEN ‘Percentage’ WHEN 10 THEN ‘Quantity’ WHEN 11 THEN ‘File’ WHEN 12 THEN ‘Folder’ WHEN 14 THEN ‘Time’ WHEN 15 THEN ‘Account’ WHEN 16 THEN ‘Phone Number’ WHEN 17 THEN ‘Email Address’ WHEN 18 THEN ‘Linked Lookup’ WHEN 20 THEN ‘Label’ WHEN 21 THEN ‘Website’ ELSE ” END AS [Detail Field 3 Type],
isnull(D4.FIELDNAM,”) AS [Detail Field 4 Name], CASE D4.FIELDTYPE WHEN 1 THEN ‘Long String’ WHEN 2 THEN ‘Short String’ WHEN 3 THEN ‘Date’ WHEN 4 THEN ‘Currency’ WHEN 5 THEN ‘Number’ WHEN 6 THEN ‘List’ WHEN 7 THEN ‘Checkbox’ WHEN 8 THEN ‘Lookup’ WHEN 9 THEN ‘Percentage’ WHEN 10 THEN ‘Quantity’ WHEN 11 THEN ‘File’ WHEN 12 THEN ‘Folder’ WHEN 14 THEN ‘Time’ WHEN 15 THEN ‘Account’ WHEN 16 THEN ‘Phone Number’ WHEN 17 THEN ‘Email Address’ WHEN 18 THEN ‘Linked Lookup’ WHEN 20 THEN ‘Label’ WHEN 21 THEN ‘Website’ ELSE ” END AS [Detail Field 4 Type],
isnull(D5.FIELDNAM,”) AS [Detail Field 5 Name], CASE D5.FIELDTYPE WHEN 1 THEN ‘Long String’ WHEN 2 THEN ‘Short String’ WHEN 3 THEN ‘Date’ WHEN 4 THEN ‘Currency’ WHEN 5 THEN ‘Number’ WHEN 6 THEN ‘List’ WHEN 7 THEN ‘Checkbox’ WHEN 8 THEN ‘Lookup’ WHEN 9 THEN ‘Percentage’ WHEN 10 THEN ‘Quantity’ WHEN 11 THEN ‘File’ WHEN 12 THEN ‘Folder’ WHEN 14 THEN ‘Time’ WHEN 15 THEN ‘Account’ WHEN 16 THEN ‘Phone Number’ WHEN 17 THEN ‘Email Address’ WHEN 18 THEN ‘Linked Lookup’ WHEN 20 THEN ‘Label’ WHEN 21 THEN ‘Website’ ELSE ” END AS [Detail Field 5 Type],
isnull(D21.FIELDNAM,”) AS [Detail Field 6 Name], CASE D21.FIELDTYPE WHEN 1 THEN ‘Long String’ WHEN 2 THEN ‘Short String’ WHEN 3 THEN ‘Date’ WHEN 4 THEN ‘Currency’ WHEN 5 THEN ‘Number’ WHEN 6 THEN ‘List’ WHEN 7 THEN ‘Checkbox’ WHEN 8 THEN ‘Lookup’ WHEN 9 THEN ‘Percentage’ WHEN 10 THEN ‘Quantity’ WHEN 11 THEN ‘File’ WHEN 12 THEN ‘Folder’ WHEN 14 THEN ‘Time’ WHEN 15 THEN ‘Account’ WHEN 16 THEN ‘Phone Number’ WHEN 17 THEN ‘Email Address’ WHEN 18 THEN ‘Linked Lookup’ WHEN 20 THEN ‘Label’ WHEN 21 THEN ‘Website’ ELSE ” END AS [Detail Field 6 Type],
isnull(D22.FIELDNAM,”) AS [Detail Field 7 Name], CASE D22.FIELDTYPE WHEN 1 THEN ‘Long String’ WHEN 2 THEN ‘Short String’ WHEN 3 THEN ‘Date’ WHEN 4 THEN ‘Currency’ WHEN 5 THEN ‘Number’ WHEN 6 THEN ‘List’ WHEN 7 THEN ‘Checkbox’ WHEN 8 THEN ‘Lookup’ WHEN 9 THEN ‘Percentage’ WHEN 10 THEN ‘Quantity’ WHEN 11 THEN ‘File’ WHEN 12 THEN ‘Folder’ WHEN 14 THEN ‘Time’ WHEN 15 THEN ‘Account’ WHEN 16 THEN ‘Phone Number’ WHEN 17 THEN ‘Email Address’ WHEN 18 THEN ‘Linked Lookup’ WHEN 20 THEN ‘Label’ WHEN 21 THEN ‘Website’ ELSE ” END AS [Detail Field 7 Type],
isnull(D23.FIELDNAM,”) AS [Detail Field 8 Name], CASE D23.FIELDTYPE WHEN 1 THEN ‘Long String’ WHEN 2 THEN ‘Short String’ WHEN 3 THEN ‘Date’ WHEN 4 THEN ‘Currency’ WHEN 5 THEN ‘Number’ WHEN 6 THEN ‘List’ WHEN 7 THEN ‘Checkbox’ WHEN 8 THEN ‘Lookup’ WHEN 9 THEN ‘Percentage’ WHEN 10 THEN ‘Quantity’ WHEN 11 THEN ‘File’ WHEN 12 THEN ‘Folder’ WHEN 14 THEN ‘Time’ WHEN 15 THEN ‘Account’ WHEN 16 THEN ‘Phone Number’ WHEN 17 THEN ‘Email Address’ WHEN 18 THEN ‘Linked Lookup’ WHEN 20 THEN ‘Label’ WHEN 21 THEN ‘Website’ ELSE ” END AS [Detail Field 8 Type],
isnull(D24.FIELDNAM,”) AS [Detail Field 9 Name], CASE D24.FIELDTYPE WHEN 1 THEN ‘Long String’ WHEN 2 THEN ‘Short String’ WHEN 3 THEN ‘Date’ WHEN 4 THEN ‘Currency’ WHEN 5 THEN ‘Number’ WHEN 6 THEN ‘List’ WHEN 7 THEN ‘Checkbox’ WHEN 8 THEN ‘Lookup’ WHEN 9 THEN ‘Percentage’ WHEN 10 THEN ‘Quantity’ WHEN 11 THEN ‘File’ WHEN 12 THEN ‘Folder’ WHEN 14 THEN ‘Time’ WHEN 15 THEN ‘Account’ WHEN 16 THEN ‘Phone Number’ WHEN 17 THEN ‘Email Address’ WHEN 18 THEN ‘Linked Lookup’ WHEN 20 THEN ‘Label’ WHEN 21 THEN ‘Website’ ELSE ” END AS [Detail Field 9 Type],
isnull(D25.FIELDNAM,”) AS [Detail Field 10 Name], CASE D25.FIELDTYPE WHEN 1 THEN ‘Long String’ WHEN 2 THEN ‘Short String’ WHEN 3 THEN ‘Date’ WHEN 4 THEN ‘Currency’ WHEN 5 THEN ‘Number’ WHEN 6 THEN ‘List’ WHEN 7 THEN ‘Checkbox’ WHEN 8 THEN ‘Lookup’ WHEN 9 THEN ‘Percentage’ WHEN 10 THEN ‘Quantity’ WHEN 11 THEN ‘File’ WHEN 12 THEN ‘Folder’ WHEN 14 THEN ‘Time’ WHEN 15 THEN ‘Account’ WHEN 16 THEN ‘Phone Number’ WHEN 17 THEN ‘Email Address’ WHEN 18 THEN ‘Linked Lookup’ WHEN 20 THEN ‘Label’ WHEN 21 THEN ‘Website’ ELSE ” END AS [Detail Field 10 Type],
CASE W.AddExtenderWindowDetails WHEN 0 THEN ‘No’ WHEN 1 THEN ‘Yes’ ELSE ” END AS [Detail Window],
CASE W.Expand_Scrolling_Default WHEN 0 THEN ‘No’ WHEN 1 THEN ‘Yes’ ELSE ” END AS [Expand Detail],
CASE W.Show_Total_CB WHEN 0 THEN ‘No’ WHEN 1 THEN ‘Yes’ ELSE ” END AS [Show Detail Totals],
DT.FIELDNAM AS [Detail Totals Field],
CASE W.Auto_Open WHEN 0 THEN ‘No’ WHEN 1 THEN ‘Yes’ ELSE ” END AS [Auto Open],
CASE W.PT_Open_Method1 WHEN 1 THEN ‘Field Entry’ WHEN 2 THEN ‘Field Exit’ WHEN 3 THEN ‘Line Change’ ELSE ” END AS [Open Method],
W.Long_Field_Name AS [Open Field],
CASE W.Auto_Close WHEN 0 THEN ‘No’ WHEN 1 THEN ‘Yes’ ELSE ” END AS [Auto Close],
W.CRUSRID AS [Created By],
W.CREATDDT AS [Created On],
W.MDFUSRID AS [Modified By],
W.MODIFDT AS [Modified On]
FROM EXT20100 W
LEFT JOIN EXT20010 F1 WITH (NOLOCK) ON F1.Field_ID = W.[Extender_Field_IDs_1]
LEFT JOIN EXT20010 F2 WITH (NOLOCK) ON F2.Field_ID = W.[Extender_Field_IDs_2]
LEFT JOIN EXT20010 F3 WITH (NOLOCK) ON F3.Field_ID = W.[Extender_Field_IDs_3]
LEFT JOIN EXT20010 F4 WITH (NOLOCK) ON F4.Field_ID = W.[Extender_Field_IDs_4]
LEFT JOIN EXT20010 F5 WITH (NOLOCK) ON F5.Field_ID = W.[Extender_Field_IDs_5]
LEFT JOIN EXT20010 F6 WITH (NOLOCK) ON F6.Field_ID = W.[Extender_Field_IDs_6]
LEFT JOIN EXT20010 F7 WITH (NOLOCK) ON F7.Field_ID = W.[Extender_Field_IDs_7]
LEFT JOIN EXT20010 F8 WITH (NOLOCK) ON F8.Field_ID = W.[Extender_Field_IDs_8]
LEFT JOIN EXT20010 F9 WITH (NOLOCK) ON F9.Field_ID = W.[Extender_Field_IDs_9]
LEFT JOIN EXT20010 F10 WITH (NOLOCK) ON F10.Field_ID = W.[Extender_Field_IDs_10]
LEFT JOIN EXT20010 F11 WITH (NOLOCK) ON F11.Field_ID = W.[Extender_Field_IDs_11]
LEFT JOIN EXT20010 F12 WITH (NOLOCK) ON F12.Field_ID = W.[Extender_Field_IDs_12]
LEFT JOIN EXT20010 F13 WITH (NOLOCK) ON F13.Field_ID = W.[Extender_Field_IDs_13]
LEFT JOIN EXT20010 F14 WITH (NOLOCK) ON F14.Field_ID = W.[Extender_Field_IDs_14]
LEFT JOIN EXT20010 F15 WITH (NOLOCK) ON F15.Field_ID = W.[Extender_Field_IDs_15]
LEFT JOIN EXT20010 F16 WITH (NOLOCK) ON F16.Field_ID = W.[Extender_Field_IDs_16]
LEFT JOIN EXT20010 F17 WITH (NOLOCK) ON F17.Field_ID = W.[Extender_Field_IDs_17]
LEFT JOIN EXT20010 F18 WITH (NOLOCK) ON F18.Field_ID = W.[Extender_Field_IDs_18]
LEFT JOIN EXT20010 F19 WITH (NOLOCK) ON F19.Field_ID = W.[Extender_Field_IDs_19]
LEFT JOIN EXT20010 F20 WITH (NOLOCK) ON F20.Field_ID = W.[Extender_Field_IDs_20]
LEFT JOIN EXT20010 F21 WITH (NOLOCK) ON F21.Field_ID = W.[Extender_Field_IDs_21]
LEFT JOIN EXT20010 F22 WITH (NOLOCK) ON F22.Field_ID = W.[Extender_Field_IDs_22]
LEFT JOIN EXT20010 F23 WITH (NOLOCK) ON F23.Field_ID = W.[Extender_Field_IDs_23]
LEFT JOIN EXT20010 F24 WITH (NOLOCK) ON F24.Field_ID = W.[Extender_Field_IDs_24]
LEFT JOIN EXT20010 F25 WITH (NOLOCK) ON F25.Field_ID = W.[Extender_Field_IDs_25]
LEFT JOIN EXT20010 F26 WITH (NOLOCK) ON F26.Field_ID = W.[Extender_Field_IDs_26]
LEFT JOIN EXT20010 F27 WITH (NOLOCK) ON F27.Field_ID = W.[Extender_Field_IDs_27]
LEFT JOIN EXT20010 F28 WITH (NOLOCK) ON F28.Field_ID = W.[Extender_Field_IDs_28]
LEFT JOIN EXT20010 F29 WITH (NOLOCK) ON F29.Field_ID = W.[Extender_Field_IDs_29]
LEFT JOIN EXT20010 F30 WITH (NOLOCK) ON F30.Field_ID = W.[Extender_Field_IDs_30]
LEFT JOIN EXT20010 D1 WITH (NOLOCK) ON D1.Field_ID = W.Detail_Field_IDs_1
LEFT JOIN EXT20010 D2 WITH (NOLOCK) ON D2.Field_ID = W.Detail_Field_IDs_2
LEFT JOIN EXT20010 D3 WITH (NOLOCK) ON D3.Field_ID = W.Detail_Field_IDs_3
LEFT JOIN EXT20010 D4 WITH (NOLOCK) ON D4.Field_ID = W.Detail_Field_IDs_4
LEFT JOIN EXT20010 D5 WITH (NOLOCK) ON D5.Field_ID = W.Detail_Field_IDs_5
LEFT JOIN EXT20010 D21 WITH (NOLOCK) ON D21.Field_ID = W.Detail_Field_IDs_2_1
LEFT JOIN EXT20010 D22 WITH (NOLOCK) ON D22.Field_ID = W.Detail_Field_IDs_2_2
LEFT JOIN EXT20010 D23 WITH (NOLOCK) ON D23.Field_ID = W.Detail_Field_IDs_2_3
LEFT JOIN EXT20010 D24 WITH (NOLOCK) ON D24.Field_ID = W.Detail_Field_IDs_2_4
LEFT JOIN EXT20010 D25 WITH (NOLOCK) ON D25.Field_ID = W.Detail_Field_IDs_2_5
LEFT JOIN EXT20010 DT WITH (NOLOCK) ON DT.Field_ID = W.Total_Field_ID