Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/GL30001
Product: HITB Report (5597)
Series:
Display Name: GL BBF Translation Hist
Physical Name: GL30001
Technical Name: glBBFTranslationHistSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 TranslationCurrencyID 
Translation Currency ID String STR15_Currency_ID 15 2 HSTYEAR History Year Integer INT4_S0 4 3 JRNENTRY Journal Entry Long Integer LI8_U0 8 4 SOURCDOC Source Document String STR10_Source_Document 10 Key to the Source Document Master (SY00900).
Click to show/hide
SELECT
['GL BBF Translation Hist'].SOURCDOC AS 'GL BBF Translation Hist-Source Document'
,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
GL30001 AS ['GL BBF Translation Hist']
INNER JOIN
SY00900 AS ['Source Document Master']
ON
['GL BBF Translation Hist'].SOURCDOC = ['Source Document Master'].SOURCDOC5 REFRENCE Reference String STR30 30 6 TRXDATE TRX Date Date DT_Date 6 7 TRXSORCE TRX Source String STR13 13 8 ACTINDX Account Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['GL BBF Translation Hist'].ACTINDX AS 'GL BBF Translation Hist-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
GL30001 AS ['GL BBF Translation Hist']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['GL BBF Translation Hist'].ACTINDX = ['Account Index Master'].ACTINDX9 SEQNUMBR Sequence Number Long Integer LI_Sequence_Number 10 10 PERIODID Period ID Integer INT3 3 11 Ledger_ID Ledger ID Integer INT2 2 12 CURNCYID Currency ID String STR15_Currency_ID 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['GL BBF Translation Hist'].CURNCYID AS 'GL BBF Translation Hist-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
GL30001 AS ['GL BBF Translation Hist']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['GL BBF Translation Hist'].CURNCYID = ['Currency Setup'].CURNCYID13 Original_Exchange_Rate Original Exchange Rate Currency (Variable) DLR14_Exchange_Rate 14 14 ORGNTSRC Originating Source String STR15 15 15 CRDTAMNT Credit Amount Currency DLR19_$S2 19 16 DEBITAMT Debit Amount Currency DLR19_$S2 19 17 ORCRDAMT Originating Credit Amount Currency DLR19_$S2 19 18 ORDBTAMT Originating Debit Amount Currency DLR19_$S2 19 19 TranslationCreditAmount Translation Credit Amount Currency DLR19_$S2 19 20 TranslationDebitAmount Translation Debit Amount Currency DLR19_$S2 19 21 CURRNIDX Currency Index Integer INT3 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['GL BBF Translation Hist'].CURRNIDX AS 'GL BBF Translation Hist-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
GL30001 AS ['GL BBF Translation Hist']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['GL BBF Translation Hist'].CURRNIDX = ['Currency Setup'].CURRNIDX22 DECPLCUR Decimal Places Currency Integer DDL_Decimal_Places_Dollars 0 23 RATETPID Rate Type ID String STR15_Rate_Type_ID 15 Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hide
SELECT
['GL BBF Translation Hist'].RATETPID AS 'GL BBF Translation Hist-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
GL30001 AS ['GL BBF Translation Hist']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['GL BBF Translation Hist'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID24 EXGTBLID Exchange Table ID String STR15_Exchange_Table_ID 15 Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hide
SELECT
['GL BBF Translation Hist'].EXGTBLID AS 'GL BBF Translation Hist-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
GL30001 AS ['GL BBF Translation Hist']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['GL BBF Translation Hist'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID25 XCHGRATE Exchange Rate Currency (Variable) DLR14_Exchange_Rate 14 26 EXCHDATE Exchange Date Date DT_Date 6 27 TIME1 Time Time TM6 6 28 RTCLCMTD Rate Calculation Method Integer GB 0 29 DENXRATE Denomination Exchange Rate Currency (Variable) DLR14_Exchange_Rate 14 30 MCTRXSTT MC Transaction State Integer INT1 1 31 CurrencyTranslationType Currency Translation Type Integer DDL_CurrencyTranslationType 0 32 Identity_Column Identity Column Long Integer Identity Column 0