Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/MPPCACHE
Product: Mekorma Multi-Batch Management (7150)
Series: System
Display Name: Multi-Batch Memory Cache
Physical Name: MPPCACHE
Technical Name: ME_MemorySeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CALLEDBY 
Called By INT Integer 0 2 MEID ME_ID STR75 String 75 3 INTERID Intercompany ID STR5_IC_ID String 5 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['Multi-Batch Memory Cache'].INTERID AS 'Multi-Batch Memory Cache-Intercompany ID'
,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
MPPCACHE AS ['Multi-Batch Memory Cache']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['Multi-Batch Memory Cache'].INTERID = ['Company Master'].INTERID4 MEINDEX ME_Index INT5 Integer 4 5 MEDESC ME_Description STR100 String 100 6 ME_Path ME_Path STR255 String 255 7 MEARRAYSTR_1 ME_ArrayStr[1] STR50 String 50 8 MEARRAYSTR_2 ME_ArrayStr[2] STR50 String 50 9 MEARRAYSTR_3 ME_ArrayStr[3] STR50 String 50 10 MEARRAYSTR_4 ME_ArrayStr[4] STR50 String 50 11 MEARRAYSTR_5 ME_ArrayStr[5] STR50 String 50 12 MEARRAYSTR_6 ME_ArrayStr[6] STR50 String 50 13 MEARRAYSTR_7 ME_ArrayStr[7] STR50 String 50 14 MEARRAYSTR_8 ME_ArrayStr[8] STR50 String 50 15 MEARRAYSTR_9 ME_ArrayStr[9] STR50 String 50 16 MEARRAYSTR_10 ME_ArrayStr[10] STR50 String 50