Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/MPP00002
Product: Mekorma Multi-Batch Management (7150)
Series: System
Display Name: MPP_CompanyBatches_TEMP
Physical Name: MPP00002
Technical Name: MPP_CompanyBatches_TEMPSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 ACTION1 
action INT Integer 0 2 INTERID Intercompany ID STR5_IC_ID String 5 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['MPP_CompanyBatches_TEMP'].INTERID AS 'MPP_CompanyBatches_TEMP-Intercompany ID'
,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
MPP00002 AS ['MPP_CompanyBatches_TEMP']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['MPP_CompanyBatches_TEMP'].INTERID = ['Company Master'].INTERID3 BACHNUMB Batch Number STR15_LBAU String 15 4 BCHSOURC Batch Source STR15 String 15 5 MKTOPROC Marked To Process CB Boolean 0 6 DOCDATE Document Date DT Date 8 7 GLPOSTDT GL Posting Date DT Date 8