Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/MPP71502
Product: Mekorma Multi-Batch Management (7150)
Series: System
Display Name: MPP Company Batches
Physical Name: MPP71502
Technical Name: MPP_CompanyBatchesSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 MPP_Original_Company_ID 
MPP_Original_Company_ID INT5 Integer 4 2 MPP_Original_User_ID MPP_Original_User_ID STR15_User_ID String 15 3 USERID User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['MPP Company Batches'].USERID AS 'MPP Company Batches-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
MPP71502 AS ['MPP Company Batches']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['MPP Company Batches'].USERID = ['Users Master'].USERID4 INTERID Intercompany ID STR5_IC_ID String 5 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['MPP Company Batches'].INTERID AS 'MPP Company Batches-Intercompany ID'
,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
MPP71502 AS ['MPP Company Batches']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['MPP Company Batches'].INTERID = ['Company Master'].INTERID5 BACHNUMB Batch Number STR15_LBAU String 15 6 BCHSOURC Batch Source STR15 String 15 7 MPP_Printed MPP_Printed CB Boolean 0 8 MPP_Posted MPP_Posted CB Boolean 0 9 MPP_Phase MPP_Phase INT Integer 0 10 NUMOFTRX Number Of TRX LI6_U0 Long Integer 6 11 BCHTOTAL Batch Total DLR19_RBS0_STR$ Currency 19 12 MKTOPROC Marked To Process CB Boolean 0 13 MPP_Batch_Status MPP_Batch_Status INT Integer 0 14 MPPBatchStatusDesc MPP_Batch_Status_Desc STR255 String 255 15 CHEKBKID Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['MPP Company Batches'].CHEKBKID AS 'MPP Company Batches-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
MPP71502 AS ['MPP Company Batches']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['MPP Company Batches'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID16 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['MPP Company Batches'].CURNCYID AS 'MPP Company Batches-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
MPP71502 AS ['MPP Company Batches']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['MPP Company Batches'].CURNCYID = ['Currency Setup'].CURNCYID17 CURRNIDX Currency Index INT3 Integer 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['MPP Company Batches'].CURRNIDX AS 'MPP Company Batches-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
MPP71502 AS ['MPP Company Batches']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['MPP Company Batches'].CURRNIDX = ['Currency Setup'].CURRNIDX18 DOCDATE Document Date DT Date 8 19 MBPB_Criteria_ID MBPB_Criteria_ID STR15_LBAU String 15 20 GLPOSTDT GL Posting Date DT Date 8 21 MPP_EFT_Batch MPP_EFT_Batch Boolean Boolean 0 22 CMPNYNAM Company Name STR64_Company_Name String 64 23 CMPANYID Company ID INT5 Integer 4 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['MPP Company Batches'].CMPANYID AS 'MPP Company Batches-Company ID'
,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
MPP71502 AS ['MPP Company Batches']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['MPP Company Batches'].CMPANYID = ['Company Master'].CMPANYID24 PmtMethod Payment Method GB Integer 0 25 MPP_Posted_Date MPP_Posted_Date DATE Date 6 26 MPP_Printed_Date MPP_Printed_Date DATE Date 6 27 MPP_Printed_User MPP_Printed_User STR15_User_ID String 15 28 MPP_Posted_User MPP_Posted_User STR15_User_ID String 15 29 MPP_Results_ToPrint MPP_Results_To_Print Boolean Boolean 0