Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/MBPB78603
Product: Mekorma Multi-Batch Management (7150)
Series: System
Display Name: MBPB Batch Process Detail
Physical Name: MBPB78603
Technical Name: MBPB_Batch_Process_DTLSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 MBS_Process_ID 
MBPB_Process_ID STR15_LBAU String 15 2 INTERID Intercompany ID STR5_IC_ID String 5 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['MBPB Batch Process Detail'].INTERID AS 'MBPB Batch Process Detail-Intercompany ID'
,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
MBPB78603 AS ['MBPB Batch Process Detail']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['MBPB Batch Process Detail'].INTERID = ['Company Master'].INTERID3 SEQUENCE1 Sequence DLR19_$S2 Currency 19 4 CHEKBKID Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['MBPB Batch Process Detail'].CHEKBKID AS 'MBPB Batch Process Detail-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
MBPB78603 AS ['MBPB Batch Process Detail']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['MBPB Batch Process Detail'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID5 MBS_Payment_Method MBPB_Payment_Method INT Integer 0 6 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['MBPB Batch Process Detail'].CURNCYID AS 'MBPB Batch Process Detail-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
MBPB78603 AS ['MBPB Batch Process Detail']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['MBPB Batch Process Detail'].CURNCYID = ['Currency Setup'].CURNCYID7 MBPB_Criteria_ID MBPB_Criteria_ID STR15_LBAU String 15 8 CURRNIDX Currency Index INT3 Integer 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['MBPB Batch Process Detail'].CURRNIDX AS 'MBPB Batch Process Detail-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
MBPB78603 AS ['MBPB Batch Process Detail']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['MBPB Batch Process Detail'].CURRNIDX = ['Currency Setup'].CURRNIDX9 PmtMethod Payment Method GB Integer 0