Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/MPP71503
Product: Mekorma Multi-Batch Management (7150)
Series: System
Display Name: MPP Automation
Physical Name: MPP71503
Technical Name: MPP_AutomationSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 USERID 
User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['MPP Automation'].USERID AS 'MPP Automation-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
MPP71503 AS ['MPP Automation']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['MPP Automation'].USERID = ['Users Master'].USERID2 MPP_Phase MPP_Phase INT Integer 0 3 INTERID Intercompany ID STR5_IC_ID String 5 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['MPP Automation'].INTERID AS 'MPP Automation-Intercompany ID'
,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
MPP71503 AS ['MPP Automation']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['MPP Automation'].INTERID = ['Company Master'].INTERID4 MPP_PrintEFT MPP_PrintEFT Boolean Boolean 0 5 MPP_SendEFT MPP_SendEFT Boolean Boolean 0 6 EMAILADDRESS_I Email Address STR1000 String 100 7 MPP_Show_Errors MPP_Show_Errors Boolean Boolean 0 8 PRTOPRTR Print to Printer CB_Print_to_Printer Boolean 0 9 PRNTOFIL Print to File CB_Print_to_File Boolean 0 10 XPRTFTYP Export File Type DDL_Export_File_Type Integer 0 11 MPP_ViewBy MPP_ViewBy INT Integer 0 12 FILEXPNM File Export Name STR255 String 255 13 MPP_EmailDocument MPP_EmailDocument Boolean Boolean 0 14 MPP_All_or_Range MPP_All_or_Range INT Integer 0 15 MPP_Post_EFT_After_Print MPP_Post_EFT_After_Print Boolean Boolean 0 16 MPP_Options_1 MPP_Options[1] INT2 Integer 2 17 MPP_Options_2 MPP_Options[2] INT2 Integer 2 18 MPP_Options_3 MPP_Options[3] INT2 Integer 2 19 MPP_Options_4 MPP_Options[4] INT2 Integer 2 20 MPP_Options_5 MPP_Options[5] INT2 Integer 2 21 MPP_Options_11 MPP_Options[11] INT2 Integer 2 22 MPP_Options_6 MPP_Options[6] INT2 Integer 2 23 MPP_Options_7 MPP_Options[7] INT2 Integer 2 24 MPP_Options_8 MPP_Options[8] INT2 Integer 2 25 MPP_Options_9 MPP_Options[9] INT2 Integer 2 26 MPP_Options_10 MPP_Options[10] INT2 Integer 2 27 MPP_Options_12 MPP_Options[12] INT2 Integer 2 28 MPP_Options_13 MPP_Options[13] INT2 Integer 2 29 MPP_Options_14 MPP_Options[14] INT2 Integer 2 30 MPP_Options_15 MPP_Options[15] INT2 Integer 2 31 MPP_Options_16 MPP_Options[16] INT2 Integer 2 32 MPP_Options_17 MPP_Options[17] INT2 Integer 2 33 MPP_Options_18 MPP_Options[18] INT2 Integer 2 34 MPP_Options_19 MPP_Options[19] INT2 Integer 2 35 MPP_Options_20 MPP_Options[20] INT2 Integer 2 36 MPP_Options_21 MPP_Options[21] INT2 Integer 2 37 MPP_Options_22 MPP_Options[22] INT2 Integer 2 38 MPP_Options_23 MPP_Options[23] INT2 Integer 2 39 MPP_Options_24 MPP_Options[24] INT2 Integer 2 40 MPP_Options_30 MPP_Options[30] INT2 Integer 2 41 MPP_Options_25 MPP_Options[25] INT2 Integer 2 42 MPP_Options_26 MPP_Options[26] INT2 Integer 2 43 MPP_Options_27 MPP_Options[27] INT2 Integer 2 44 MPP_Options_28 MPP_Options[28] INT2 Integer 2 45 MPP_Options_29 MPP_Options[29] INT2 Integer 2