Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/GL50500
Product: HITB Report (5597)
Series:
Display Name: glDivisionalClosingPLTemp
Physical Name: GL50500
Technical Name: glDivisionalClosingPLTempSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 USERID 
User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['glDivisionalClosingPLTemp'].USERID AS 'glDivisionalClosingPLTemp-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
GL50500 AS ['glDivisionalClosingPLTemp']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['glDivisionalClosingPLTemp'].USERID = ['Users Master'].USERID2 ORD Ord Long Integer LI_Sequence_Number 10 3 SGMNTID Segment ID String STR66_Seg_ID 66 4 Ledger_ID Ledger ID Integer INT2 2 5 CURNCYID Currency ID String STR15_Currency_ID 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['glDivisionalClosingPLTemp'].CURNCYID AS 'glDivisionalClosingPLTemp-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
GL50500 AS ['glDivisionalClosingPLTemp']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['glDivisionalClosingPLTemp'].CURNCYID = ['Currency Setup'].CURNCYID6 TranslationCurrencyID Translation Currency ID String STR15_Currency_ID 15 7 CURRNIDX Currency Index Integer INT3 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['glDivisionalClosingPLTemp'].CURRNIDX AS 'glDivisionalClosingPLTemp-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
GL50500 AS ['glDivisionalClosingPLTemp']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['glDivisionalClosingPLTemp'].CURRNIDX = ['Currency Setup'].CURRNIDX8 DECPLCUR Decimal Places Currency Integer DDL_Decimal_Places_Dollars 0 9 RATETPID Rate Type ID String STR15_Rate_Type_ID 15 Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hide
SELECT
['glDivisionalClosingPLTemp'].RATETPID AS 'glDivisionalClosingPLTemp-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
GL50500 AS ['glDivisionalClosingPLTemp']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['glDivisionalClosingPLTemp'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID10 EXGTBLID Exchange Table ID String STR15_Exchange_Table_ID 15 Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hide
SELECT
['glDivisionalClosingPLTemp'].EXGTBLID AS 'glDivisionalClosingPLTemp-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
GL50500 AS ['glDivisionalClosingPLTemp']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['glDivisionalClosingPLTemp'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID11 XCHGRATE Exchange Rate Currency (Variable) DLR14_Exchange_Rate 14 12 RTCLCMTD Rate Calculation Method Integer GB 0 13 DENXRATE Denomination Exchange Rate Currency (Variable) DLR14_Exchange_Rate 14 14 MCTRXSTT MC Transaction State Integer INT1 1 15 CurrencyTranslationType Currency Translation Type Integer DDL_CurrencyTranslationType 0 16 REARNAMT Retained Earnings Amount Currency DLR19_$S2 19 17 ORIGAMT Originating Amount Currency DLR19_$S2 19 18 Translation_Amount Translation Amount Currency DLR19_$S2 19 19 RERINDX Retained Earnings Account Index Long Integer LI_14 14