Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/MPP71504
Product: Mekorma Multi-Batch Management (7150)
Series: System
Display Name: MPP Company Batches History
Physical Name: MPP71504
Technical Name: MPP_CompanyBatches_HISTSeq 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 History'].USERID AS 'MPP Company Batches History-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
MPP71504 AS ['MPP Company Batches History']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['MPP Company Batches History'].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 History'].INTERID AS 'MPP Company Batches History-Intercompany ID'
,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
MPP71504 AS ['MPP Company Batches History']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['MPP Company Batches History'].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 MPP_Batch_Status MPP_Batch_Status INT Integer 0 13 MPPBatchStatusDesc MPP_Batch_Status_Desc STR255 String 255 14 CHEKBKID Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['MPP Company Batches History'].CHEKBKID AS 'MPP Company Batches History-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
MPP71504 AS ['MPP Company Batches History']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['MPP Company Batches History'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID15 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['MPP Company Batches History'].CURNCYID AS 'MPP Company Batches History-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
MPP71504 AS ['MPP Company Batches History']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['MPP Company Batches History'].CURNCYID = ['Currency Setup'].CURNCYID16 MPP_EFT_Batch MPP_EFT_Batch Boolean Boolean 0 17 CURRNIDX Currency Index INT3 Integer 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['MPP Company Batches History'].CURRNIDX AS 'MPP Company Batches History-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
MPP71504 AS ['MPP Company Batches History']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['MPP Company Batches History'].CURRNIDX = ['Currency Setup'].CURRNIDX18 MBPB_Criteria_ID MBPB_Criteria_ID STR15_LBAU String 15 19 CMPNYNAM Company Name STR64_Company_Name String 64 20 CMPANYID Company ID INT5 Integer 4 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['MPP Company Batches History'].CMPANYID AS 'MPP Company Batches History-Company ID'
,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
MPP71504 AS ['MPP Company Batches History']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['MPP Company Batches History'].CMPANYID = ['Company Master'].CMPANYID21 PmtMethod Payment Method GB Integer 0 22 MPP_Printed_Date MPP_Printed_Date DATE Date 6 23 MPP_Posted_Date MPP_Posted_Date DATE Date 6 24 MPP_Printed_User MPP_Printed_User STR15_User_ID String 15 25 MPP_Posted_User MPP_Posted_User STR15_User_ID String 15