Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CM00001
Product: Microsoft Dynamics GP (0)
Series: Financial
Display Name: CM_DepRcpt_RGLCash_LINE_TEMP
Physical Name: CM00001
Technical Name: CM_DepRcpt_RGLCash_LINE_TEMPSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 depositnumber 
Deposit Number String STR20_Document_Number 20 2 RCPTNMBR Receipt Number String STR20_Document_Number 20 3 CURNCYID Currency ID String STR15_Currency_ID 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['CM_DepRcpt_RGLCash_LINE_TEMP'].CURNCYID AS 'CM_DepRcpt_RGLCash_LINE_TEMP-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
CM00001 AS ['CM_DepRcpt_RGLCash_LINE_TEMP']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['CM_DepRcpt_RGLCash_LINE_TEMP'].CURNCYID = ['Currency Setup'].CURNCYID4 ACTINDX Account Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['CM_DepRcpt_RGLCash_LINE_TEMP'].ACTINDX AS 'CM_DepRcpt_RGLCash_LINE_TEMP-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
CM00001 AS ['CM_DepRcpt_RGLCash_LINE_TEMP']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['CM_DepRcpt_RGLCash_LINE_TEMP'].ACTINDX = ['Account Index Master'].ACTINDX5 SEQNUMBR Sequence Number Long Integer LI_Sequence_Number 10 6 DEBITAMT Debit Amount Currency DLR19_$S2 19 7 CRDTAMNT Credit Amount Currency DLR19_$S2 19 8 DSCRIPTN Description String STR30 30 9 REFRENCE Reference String STR30 30 10 GLPOSTDT GL Posting Date Date DT 8 11 VOIDED Voided Boolean CB 0 12 CURRNIDX Currency Index Integer INT3 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['CM_DepRcpt_RGLCash_LINE_TEMP'].CURRNIDX AS 'CM_DepRcpt_RGLCash_LINE_TEMP-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
CM00001 AS ['CM_DepRcpt_RGLCash_LINE_TEMP']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['CM_DepRcpt_RGLCash_LINE_TEMP'].CURRNIDX = ['Currency Setup'].CURRNIDX13 DECPLACS Decimal Places Integer DDL_Decimal_Places 0 14 MCTRXSTT MC Transaction State Integer INT1 1 MC Transaction State of the transaction. State the transaction was created in. For non multi-currency transactions, this field will be blank.
Click to show/hide MC Transaction States
0 Euro currency is not created or no denomination currencies are enabled.
1 Originating is not a denomination; Functional is not a denomination
2 Originating is not a denomination; Functional is the Euro currency.
3 Originating is not a denomination; Functional is a denomination.
4 Originating is a denomination; Functional is not a denomination.
5 Originating is a denomination; Functional is a denomination.
6 Originating is a denomination; Functional is the Euro currency.
7 Originating is the Euro currency; Functional is a denomination.
8 Originating is the Euro currency; Functional is not a denomination.
15 RATETPID Rate Type ID String STR15_Rate_Type_ID 15 Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hide
SELECT
['CM_DepRcpt_RGLCash_LINE_TEMP'].RATETPID AS 'CM_DepRcpt_RGLCash_LINE_TEMP-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
CM00001 AS ['CM_DepRcpt_RGLCash_LINE_TEMP']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['CM_DepRcpt_RGLCash_LINE_TEMP'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID16 EXGTBLID Exchange Table ID String STR15_Exchange_Table_ID 15 Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hide
SELECT
['CM_DepRcpt_RGLCash_LINE_TEMP'].EXGTBLID AS 'CM_DepRcpt_RGLCash_LINE_TEMP-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
CM00001 AS ['CM_DepRcpt_RGLCash_LINE_TEMP']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['CM_DepRcpt_RGLCash_LINE_TEMP'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID17 CHEKBKID Checkbook ID String STR15_Checkbook_ID 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['CM_DepRcpt_RGLCash_LINE_TEMP'].CHEKBKID AS 'CM_DepRcpt_RGLCash_LINE_TEMP-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
CM00001 AS ['CM_DepRcpt_RGLCash_LINE_TEMP']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['CM_DepRcpt_RGLCash_LINE_TEMP'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID