Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EXT40150
Product: Extender (3107)
Series: Project
Display Name: v11 - Extender Detail Windows
Physical Name: EXT40150
Technical Name: PT_Extender_Detail_WindowsSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PT_Window_ID 
PT Window ID STR15_Address_Code String 15 2 PT_Window_Description PT Window Description STR64 String 64 3 PRODID Product ID INT4 Integer 4 4 Long_Form_Name Long Form Name STR255 String 255 5 Long_Window_Name Long Window Name STR100 String 100 6 Detail_Prompts_1 Detail Prompts[1] STR64 String 64 7 Detail_Prompts_2 Detail Prompts[2] STR64 String 64 8 Detail_Prompts_3 Detail Prompts[3] STR64 String 64 9 Detail_Prompts_4 Detail Prompts[4] STR64 String 64 10 Detail_Prompts_5 Detail Prompts[5] STR64 String 64 11 Detail_Prompts_6 Detail Prompts[6] STR64 String 64 12 Detail_Prompts_7 Detail Prompts[7] STR64 String 64 13 Detail_Prompts_8 Detail Prompts[8] STR64 String 64 14 Detail_Prompts_9 Detail Prompts[9] STR64 String 64 15 Detail_Prompts_10 Detail Prompts[10] STR64 String 64 16 Detail_Prompts_11 Detail Prompts[11] STR64 String 64 17 Detail_Prompts_12 Detail Prompts[12] STR64 String 64 18 Detail_Prompts_13 Detail Prompts[13] STR64 String 64 19 Detail_Prompts_14 Detail Prompts[14] STR64 String 64 20 Detail_Prompts_15 Detail Prompts[15] STR64 String 64 21 Detail_Prompts_16 Detail Prompts[16] STR64 String 64 22 Detail_Prompts_17 Detail Prompts[17] STR64 String 64 23 Detail_Prompts_18 Detail Prompts[18] STR64 String 64 24 Detail_Prompts_19 Detail Prompts[19] STR64 String 64 25 Detail_Prompts_20 Detail Prompts[20] STR64 String 64 26 Detail_Field_Type_1 Detail Field Type[1] DDL Integer 0 27 Detail_Field_Type_2 Detail Field Type[2] DDL Integer 0 28 Detail_Field_Type_3 Detail Field Type[3] DDL Integer 0 29 Detail_Field_Type_4 Detail Field Type[4] DDL Integer 0 30 Detail_Field_Type_5 Detail Field Type[5] DDL Integer 0 31 Detail_Field_Type_6 Detail Field Type[6] DDL Integer 0 32 Detail_Field_Type_7 Detail Field Type[7] DDL Integer 0 33 Detail_Field_Type_8 Detail Field Type[8] DDL Integer 0 34 Detail_Field_Type_9 Detail Field Type[9] DDL Integer 0 35 Detail_Field_Type_10 Detail Field Type[10] DDL Integer 0 36 Detail_Field_Type_11 Detail Field Type[11] DDL Integer 0 37 Detail_Field_Type_12 Detail Field Type[12] DDL Integer 0 38 Detail_Field_Type_13 Detail Field Type[13] DDL Integer 0 39 Detail_Field_Type_14 Detail Field Type[14] DDL Integer 0 40 Detail_Field_Type_15 Detail Field Type[15] DDL Integer 0 41 Detail_Field_Type_16 Detail Field Type[16] DDL Integer 0 42 Detail_Field_Type_17 Detail Field Type[17] DDL Integer 0 43 Detail_Field_Type_18 Detail Field Type[18] DDL Integer 0 44 Detail_Field_Type_19 Detail Field Type[19] DDL Integer 0 45 Detail_Field_Type_20 Detail Field Type[20] DDL Integer 0 46 Detail_Lookups_1 Detail Lookups[1] DDL Integer 0 47 Detail_Lookups_2 Detail Lookups[2] DDL Integer 0 48 Detail_Lookups_3 Detail Lookups[3] DDL Integer 0 49 Detail_Lookups_4 Detail Lookups[4] DDL Integer 0 50 Detail_Lookups_5 Detail Lookups[5] DDL Integer 0 51 Detail_Lookups_6 Detail Lookups[6] DDL Integer 0 52 Detail_Lookups_7 Detail Lookups[7] DDL Integer 0 53 Detail_Lookups_8 Detail Lookups[8] DDL Integer 0 54 Detail_Lookups_9 Detail Lookups[9] DDL Integer 0 55 Detail_Lookups_10 Detail Lookups[10] DDL Integer 0 56 Detail_Lookups_11 Detail Lookups[11] DDL Integer 0 57 Detail_Lookups_12 Detail Lookups[12] DDL Integer 0 58 Detail_Lookups_13 Detail Lookups[13] DDL Integer 0 59 Detail_Lookups_14 Detail Lookups[14] DDL Integer 0 60 Detail_Lookups_15 Detail Lookups[15] DDL Integer 0 61 Detail_Lookups_16 Detail Lookups[16] DDL Integer 0 62 Detail_Lookups_17 Detail Lookups[17] DDL Integer 0 63 Detail_Lookups_18 Detail Lookups[18] DDL Integer 0 64 Detail_Lookups_19 Detail Lookups[19] DDL Integer 0 65 Detail_Lookups_20 Detail Lookups[20] DDL Integer 0 66 Detail_Required_1 Detail Required[1] CB Boolean 0 67 Detail_Required_2 Detail Required[2] CB Boolean 0 68 Detail_Required_3 Detail Required[3] CB Boolean 0 69 Detail_Required_4 Detail Required[4] CB Boolean 0 70 Detail_Required_5 Detail Required[5] CB Boolean 0 71 Detail_Required_6 Detail Required[6] CB Boolean 0 72 Detail_Required_7 Detail Required[7] CB Boolean 0 73 Detail_Required_8 Detail Required[8] CB Boolean 0 74 Detail_Required_9 Detail Required[9] CB Boolean 0 75 Detail_Required_10 Detail Required[10] CB Boolean 0 76 Detail_Required_11 Detail Required[11] CB Boolean 0 77 Detail_Required_12 Detail Required[12] CB Boolean 0 78 Detail_Required_13 Detail Required[13] CB Boolean 0 79 Detail_Required_14 Detail Required[14] CB Boolean 0 80 Detail_Required_15 Detail Required[15] CB Boolean 0 81 Detail_Required_16 Detail Required[16] CB Boolean 0 82 Detail_Required_17 Detail Required[17] CB Boolean 0 83 Detail_Required_18 Detail Required[18] CB Boolean 0 84 Detail_Required_19 Detail Required[19] CB Boolean 0 85 Detail_Required_20 Detail Required[20] CB Boolean 0 86 Detail_Decimal_Places_1 Detail Decimal Places[1] DDL_Decimal_Places_Dollars Integer 0 87 Detail_Decimal_Places_2 Detail Decimal Places[2] DDL_Decimal_Places_Dollars Integer 0 88 Detail_Decimal_Places_3 Detail Decimal Places[3] DDL_Decimal_Places_Dollars Integer 0 89 Detail_Decimal_Places_4 Detail Decimal Places[4] DDL_Decimal_Places_Dollars Integer 0 90 Detail_Decimal_Places_5 Detail Decimal Places[5] DDL_Decimal_Places_Dollars Integer 0 91 Detail_Decimal_Places_6 Detail Decimal Places[6] DDL_Decimal_Places_Dollars Integer 0 92 Detail_Decimal_Places_7 Detail Decimal Places[7] DDL_Decimal_Places_Dollars Integer 0 93 Detail_Decimal_Places_8 Detail Decimal Places[8] DDL_Decimal_Places_Dollars Integer 0 94 Detail_Decimal_Places_9 Detail Decimal Places[9] DDL_Decimal_Places_Dollars Integer 0 95 Detail_Decimal_Places_10 Detail Decimal Places[10] DDL_Decimal_Places_Dollars Integer 0 96 Detail_Decimal_Places_11 Detail Decimal Places[11] DDL_Decimal_Places_Dollars Integer 0 97 Detail_Decimal_Places_12 Detail Decimal Places[12] DDL_Decimal_Places_Dollars Integer 0 98 Detail_Decimal_Places_13 Detail Decimal Places[13] DDL_Decimal_Places_Dollars Integer 0 99 Detail_Decimal_Places_14 Detail Decimal Places[14] DDL_Decimal_Places_Dollars Integer 0 100 Detail_Decimal_Places_15 Detail Decimal Places[15] DDL_Decimal_Places_Dollars Integer 0 101 Detail_Decimal_Places_16 Detail Decimal Places[16] DDL_Decimal_Places_Dollars Integer 0 102 Detail_Decimal_Places_17 Detail Decimal Places[17] DDL_Decimal_Places_Dollars Integer 0 103 Detail_Decimal_Places_18 Detail Decimal Places[18] DDL_Decimal_Places_Dollars Integer 0 104 Detail_Decimal_Places_19 Detail Decimal Places[19] DDL_Decimal_Places_Dollars Integer 0 105 Detail_Decimal_Places_20 Detail Decimal Places[20] DDL_Decimal_Places_Dollars Integer 0 106 Detail_Row_1 Detail Row[1] INT1 Integer 1 107 Detail_Row_2 Detail Row[2] INT1 Integer 1 108 Detail_Row_3 Detail Row[3] INT1 Integer 1 109 Detail_Row_4 Detail Row[4] INT1 Integer 1 110 Detail_Row_5 Detail Row[5] INT1 Integer 1 111 Detail_Row_6 Detail Row[6] INT1 Integer 1 112 Detail_Row_7 Detail Row[7] INT1 Integer 1 113 Detail_Row_8 Detail Row[8] INT1 Integer 1 114 Detail_Row_9 Detail Row[9] INT1 Integer 1 115 Detail_Row_10 Detail Row[10] INT1 Integer 1 116 Detail_Row_11 Detail Row[11] INT1 Integer 1 117 Detail_Row_12 Detail Row[12] INT1 Integer 1 118 Detail_Row_13 Detail Row[13] INT1 Integer 1 119 Detail_Row_14 Detail Row[14] INT1 Integer 1 120 Detail_Row_15 Detail Row[15] INT1 Integer 1 121 Detail_Row_16 Detail Row[16] INT1 Integer 1 122 Detail_Row_17 Detail Row[17] INT1 Integer 1 123 Detail_Row_18 Detail Row[18] INT1 Integer 1 124 Detail_Row_19 Detail Row[19] INT1 Integer 1 125 Detail_Row_20 Detail Row[20] INT1 Integer 1 126 HotKey PT HotKey STR1 String 1 127 Long_Field_Name Long Field Name STR100 String 100 128 PT_Open_Method PT Open Method PT Open Method Integer 0 129 Auto_Open Auto Open Auto Open CB Boolean 0 130 PT_Auto_Close PT Auto Close Auto Close Boolean 0 131 Show_Total_CB Show Total CB Show Total CB Boolean 0 132 Total_Field Total Field INT5 Integer 4 133 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['v11 - Extender Detail Windows'].NOTEINDX AS 'v11 - Extender Detail Windows-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
EXT40150 AS ['v11 - Extender Detail Windows']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['v11 - Extender Detail Windows'].NOTEINDX = ['Record Notes Master'].NOTEINDX134 MODIFDT Modified Date DT Date 8 135 MDFUSRID Modified User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['v11 - Extender Detail Windows'].MDFUSRID AS 'v11 - Extender Detail Windows-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
EXT40150 AS ['v11 - Extender Detail Windows']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['v11 - Extender Detail Windows'].MDFUSRID = ['Users Master'].USERID136 CREATDDT Created Date DT Date 8 137 CRUSRID Created User ID STR15_User_ID String 15