v11 – Extender Multicurrency Settings (EXT40000)

azurecurveProductsExtender (3107)Projectv11 - Extender Multicurrency Settings (EXT40000)

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_Settings

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1Extender_Type SearchExtender TypeINT5Integer24
2Extender_ID SearchExtender IDSTR15_LBAUString1615
3Multicurrency_CB SearchMulticurrency CBMulticurrency CBBoolean20
4Currency_Default_Field_1 SearchCurrency Default Field:Record TypeINT1Integer21
5Currency_Default_Field_2 SearchCurrency Default Field:Window NumberINT5Integer24
6Currency_Default_Field_3 SearchCurrency Default Field:Field NumberINT2Integer22
7Currency_Default_Field_4 SearchCurrency Default Field:Field TypeLong IntLong Integer48
8Currency_Default_Field_5 SearchCurrency Default Field:Lookup NumberLong_10ULong Integer410
9Currency_Default_Method SearchCurrency Default MethodCurrency Default MethodInteger20
10Currency_Field_1 SearchCurrency Field:Record TypeINT1Integer21
11Currency_Field_2 SearchCurrency Field:Window NumberINT5Integer24
12Currency_Field_3 SearchCurrency Field:Field NumberINT2Integer22
13Currency_Field_4 SearchCurrency Field:Field TypeLong IntLong Integer48
14Currency_Field_5 SearchCurrency Field:Lookup NumberLong_10ULong Integer410
15RATETPID SearchRate Type IDSTR15_Rate_Type_IDString1615
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
azurecurveProductsExtender (3107)Projectv11 - Extender Multicurrency Settings (EXT40000)

Leave a Reply

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