Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/GL40401
Product: Microsoft Dynamics GP (0)
Series: Financial
Display Name: General Ledger Reconcile Module
Physical Name: GL40401
Technical Name: glReconcileModuleSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Reconciliation_Number 
Reconciliation Number Long Integer LI8_U0 8 2 Reconciliation_Date Reconciliation Date Date DT 8 3 MODULE1 Module Integer DDL 0 4 fileName fileName String STR255 255 5 SubledgerBegBalance Subledger Beginning Balance Currency DLR19_$S2 19 6 SubledgerEndingBalance Subledger Ending Balance Currency DLR19_$S2 19 7 GL_Beginning_Balance GL Beginning Balance Currency DLR19_$S2 19 8 GL_Ending_Balance GL Ending Balance Currency DLR19_$S2 19 9 From_Date From Date Date DATE 6 10 TODATE To Date Date DATE 6 11 CHEKBKID Checkbook ID String STR15_Checkbook_ID 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['General Ledger Reconcile Module'].CHEKBKID AS 'General Ledger Reconcile Module-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
GL40401 AS ['General Ledger Reconcile Module']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['General Ledger Reconcile Module'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID12 Status Status Integer INT 0