v11 – Extender Exchange Rates (EXT00800)

azurecurveProductsExtender (3107)Projectv11 - Extender Exchange Rates (EXT00800)

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_Rates

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1Extender_Type SearchExtender TypeINT5Integer24
2Extender_ID SearchExtender IDSTR15_LBAUString1615
3UD_Form_Field_ID SearchUD Form Field IDSTR30_LBAUString3230
4UD_Form_Field_ID_2 SearchUD Form Field ID 2STR30_LBAUString3230
5Lookup_Value SearchLookup ValueSTR15_LBAUString1615
6CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
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'].CURNCYID
7RATETPID SearchRate Type IDSTR15_Rate_Type_IDString1615
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'].RATETPID
8EXGTBLID SearchExchange Table IDSTR15_Exchange_Table_IDString1615
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'].EXGTBLID
9XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)1014
10EXCHDATE SearchExchange DateDT_DateDate46
11TIME1 SearchTimeTM6Time46
azurecurveProductsExtender (3107)Projectv11 - Extender Exchange Rates (EXT00800)

Leave a Reply

Your email address will not be published. Required fields are marked *