Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CM00002
Product: Microsoft Dynamics GP (0)
Series: Financial
Display Name: CM Unreconciled TEMP
Physical Name: CM00002
Technical Name: CM_Unreconciled_TEMPSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CMRECNUM 
Record Number Currency DLR_Document_Number 19 2 RECONUM Reconcile Number Currency DLR_Document_Number 19 3 CMTrxNum CM Trx Number String STR20_Document_Number 20 4 CMTrxType CM Trx Type Integer DDL 0 5 CMLinkID CMLinkID String STR15_LBU 15 6 TRXDATE TRX Date Date DT_Date 6 7 TRXAMNT TRX Amount Currency DLR19_$S2 19 8 clearedate Cleared Date Date DT 8 9 ClrdAmt Cleared Amount Currency DLR19_$S2 19 10 CURNCYID Currency ID String STR15_Currency_ID 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['CM Unreconciled TEMP'].CURNCYID AS 'CM Unreconciled TEMP-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
CM00002 AS ['CM Unreconciled TEMP']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['CM Unreconciled TEMP'].CURNCYID = ['Currency Setup'].CURNCYID11 paidtorcvdfrom Paid ToRcvd From String STR64 64 12 DSCRIPTN Description String STR30 30 13 DEPTYPE Deposit Type Integer DDL_Document_Type 0 14 SOURCDOC Source Document String STR10_Source_Document 10 Key to the Source Document Master (SY00900).
Click to show/hide
SELECT
['CM Unreconciled TEMP'].SOURCDOC AS 'CM Unreconciled TEMP-Source Document'
,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
CM00002 AS ['CM Unreconciled TEMP']
INNER JOIN
SY00900 AS ['Source Document Master']
ON
['CM Unreconciled TEMP'].SOURCDOC = ['Source Document Master'].SOURCDOC15 SRCDOCTYP Source Doc Type Integer INT 0 16 SRCDOCNUM Source Doc Number String STR20 20 17 UPDATED Updated Boolean Boolean 0 18 RECONFLG ReconcileFlag Boolean Boolean 0 19 CHGFLAG ChangedFlag Boolean Boolean 0 20 MARKED Marked Boolean Boolean 0 21 USERID User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['CM Unreconciled TEMP'].USERID AS 'CM Unreconciled TEMP-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
CM00002 AS ['CM Unreconciled TEMP']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['CM Unreconciled TEMP'].USERID = ['Users Master'].USERID22 CHEKBKID Checkbook ID String STR15_Checkbook_ID 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['CM Unreconciled TEMP'].CHEKBKID AS 'CM Unreconciled TEMP-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
CM00002 AS ['CM Unreconciled TEMP']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['CM Unreconciled TEMP'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID23 PAYMENT_AMOUNT Payment Amount Currency DLR19_RBSO_UTR$ 19 24 DepAmt Deposit Amount Currency DLR19_RBS0_STR$ 19