Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EXT20401
Product: Extender (3107)
Series: Project
Display Name: Extender Event Actions
Physical Name: EXT20401
Technical Name: EXT_Event_ActionsSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Extender_Event_ID 
Extender Event ID Long Int Long Integer 8 2 Action_Number Action Number INT5 Integer 4 3 Action_Order Action Order INT5 Integer 4 4 Action_Type Action Type INT5 Integer 4 5 Action_Description Action Description STR255 String 255 6 INACTIVE Inactive CB_Inactive Boolean 0 7 Extender_Template_ID Extender Template ID Long Int Long Integer 8 8 fileName fileName STR255 String 255 9 Extender_Form_ID Extender Form ID STR15_LBAU String 15 10 PRODID Product ID INT4 Integer 4 11 INTERID Intercompany ID STR5_IC_ID String 5 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['Extender Event Actions'].INTERID AS 'Extender Event Actions-Intercompany ID'
,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
EXT20401 AS ['Extender Event Actions']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['Extender Event Actions'].INTERID = ['Company Master'].INTERID12 Long_Form_Name Long Form Name STR255 String 255 13 Long_Window_Name Long Window Name STR100 String 100 14 Warning_Type Warning Type Warning Type Integer 0 15 Warning_Prompt Warning Prompt STR255 String 255 16 Button_Prompts_1 Button Prompts[1] STR20 String 20 17 Button_Prompts_2 Button Prompts[2] STR20 String 20 18 Button_Prompts_3 Button Prompts[3] STR20 String 20 19 Button_Actions_1 Button Actions[1] INT5 Integer 4 20 Button_Actions_2 Button Actions[2] INT5 Integer 4 21 Button_Actions_3 Button Actions[3] INT5 Integer 4 22 Run_Action_Number Run Action Number INT5 Integer 4 23 Run_Event_ID Run Event ID Long Int Long Integer 8 24 TXTFIELD Text Field TX32000 Text 32000