Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EXT00800
Product: Extender (3107)
Series: Project
Display Name: v11 - Extender Exchange Rates
Physical Name: EXT00800
Technical Name: PT_MC_Exchange_RatesSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Extender_Type 
Extender Type INT5 Integer 4 2 Extender_ID Extender ID STR15_LBAU String 15 3 UD_Form_Field_ID UD Form Field ID STR30_LBAU String 30 4 UD_Form_Field_ID_2 UD Form Field ID 2 STR30_LBAU String 30 5 Lookup_Value Lookup Value STR15_LBAU String 15 6 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['v11 - Extender Exchange Rates'].CURNCYID AS 'v11 - Extender Exchange Rates-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
EXT00800 AS ['v11 - Extender Exchange Rates']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['v11 - Extender Exchange Rates'].CURNCYID = ['Currency Setup'].CURNCYID7 RATETPID Rate Type ID STR15_Rate_Type_ID String 15 Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hide
SELECT
['v11 - Extender Exchange Rates'].RATETPID AS 'v11 - Extender Exchange Rates-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
EXT00800 AS ['v11 - Extender Exchange Rates']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['v11 - Extender Exchange Rates'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID8 EXGTBLID Exchange Table ID STR15_Exchange_Table_ID String 15 Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hide
SELECT
['v11 - Extender Exchange Rates'].EXGTBLID AS 'v11 - Extender Exchange Rates-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
EXT00800 AS ['v11 - Extender Exchange Rates']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['v11 - Extender Exchange Rates'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID9 XCHGRATE Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 10 EXCHDATE Exchange Date DT_Date Date 6 11 TIME1 Time TM6 Time 6