Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EXT40000
Product: Extender (3107)
Series: Project
Display Name: v11 - Extender Multicurrency Settings
Physical Name: EXT40000
Technical Name: PT_Multicurrency_SettingsSeq 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 Multicurrency_CB Multicurrency CB Multicurrency CB Boolean 0 4 Currency_Default_Field_1 Currency Default Field:Record Type INT1 Integer 1 5 Currency_Default_Field_2 Currency Default Field:Window Number INT5 Integer 4 6 Currency_Default_Field_3 Currency Default Field:Field Number INT2 Integer 2 7 Currency_Default_Field_4 Currency Default Field:Field Type Long Int Long Integer 8 8 Currency_Default_Field_5 Currency Default Field:Lookup Number Long_10U Long Integer 10 9 Currency_Default_Method Currency Default Method Currency Default Method Integer 0 10 Currency_Field_1 Currency Field:Record Type INT1 Integer 1 11 Currency_Field_2 Currency Field:Window Number INT5 Integer 4 12 Currency_Field_3 Currency Field:Field Number INT2 Integer 2 13 Currency_Field_4 Currency Field:Field Type Long Int Long Integer 8 14 Currency_Field_5 Currency Field:Lookup Number Long_10U Long Integer 10 15 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 Multicurrency Settings'].RATETPID AS 'v11 - Extender Multicurrency Settings-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
EXT40000 AS ['v11 - Extender Multicurrency Settings']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['v11 - Extender Multicurrency Settings'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID