Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/MPP71502R
Product: Mekorma Multi-Batch Management (7150)
Series: System
Display Name: MPP_CompanyBatches_Report
Physical Name: MPP71502R
Technical Name: MPP_CompanyBatches_ReportSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 INTERID 
Intercompany ID STR5_IC_ID String 5 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['MPP_CompanyBatches_Report'].INTERID AS 'MPP_CompanyBatches_Report-Intercompany ID'
,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
MPP71502R AS ['MPP_CompanyBatches_Report']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['MPP_CompanyBatches_Report'].INTERID = ['Company Master'].INTERID2 USERID User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['MPP_CompanyBatches_Report'].USERID AS 'MPP_CompanyBatches_Report-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
MPP71502R AS ['MPP_CompanyBatches_Report']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['MPP_CompanyBatches_Report'].USERID = ['Users Master'].USERID3 BACHNUMB Batch Number STR15_LBAU String 15 4 BCHSOURC Batch Source STR15 String 15 5 MPP_Printed MPP_Printed CB Boolean 0 6 MPP_Posted MPP_Posted CB Boolean 0 7 MPP_Phase MPP_Phase INT Integer 0 8 NUMOFTRX Number Of TRX LI6_U0 Long Integer 6 9 BCHTOTAL Batch Total DLR19_RBS0_STR$ Currency 19 10 MKTOPROC Marked To Process CB Boolean 0 11 MPP_Batch_Status MPP_Batch_Status INT Integer 0 12 MPPBatchStatusDesc MPP_Batch_Status_Desc STR255 String 255 13 BCHSTTUS Batch Status INT Integer 0 14 DSCRIPTN Description STR30 String 30 15 CHEKBKID Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['MPP_CompanyBatches_Report'].CHEKBKID AS 'MPP_CompanyBatches_Report-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
MPP71502R AS ['MPP_CompanyBatches_Report']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['MPP_CompanyBatches_Report'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID16 ORIGBTCHTOT Originating Batch Total DLR19_RBS0_UTR$ Currency 19 17 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['MPP_CompanyBatches_Report'].CURNCYID AS 'MPP_CompanyBatches_Report-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
MPP71502R AS ['MPP_CompanyBatches_Report']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['MPP_CompanyBatches_Report'].CURNCYID = ['Currency Setup'].CURNCYID18 CURRNIDX Currency Index INT3 Integer 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['MPP_CompanyBatches_Report'].CURRNIDX AS 'MPP_CompanyBatches_Report-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
MPP71502R AS ['MPP_CompanyBatches_Report']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['MPP_CompanyBatches_Report'].CURRNIDX = ['Currency Setup'].CURRNIDX19 DOCDATE Document Date DT Date 8 20 CMPNYNAM Company Name STR64_Company_Name String 64 21 CMPANYID Company ID INT5 Integer 4 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['MPP_CompanyBatches_Report'].CMPANYID AS 'MPP_CompanyBatches_Report-Company ID'
,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
MPP71502R AS ['MPP_CompanyBatches_Report']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['MPP_CompanyBatches_Report'].CMPANYID = ['Company Master'].CMPANYID22 PmtMethod Payment Method GB Integer 0 23 MBPB_Criteria_ID MBPB_Criteria_ID STR15_LBAU String 15 24 MPP_EFT_Batch MPP_EFT_Batch Boolean Boolean 0 25 MPP_Printed_Date MPP_Printed_Date DATE Date 6 26 MPP_Posted_Date MPP_Posted_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