Forum Discussion

Johnny's avatar
Johnny
New Contributor II
3 years ago

Location of ConsId field Name / Description Table in Database

I am building a data adapter utilizing the SQL command type. In my query, I reference the ConsId field. What database table can I join to for the Name/Description fields for the ConsId field on my pr...
Methodology
NicoleBruno's avatar
NicoleBruno
Valued Contributor

Hello! 

We have a journal entry report built that doesn't reference a table for the cons but lists this instead. Hopefully it's useful: 

(CASE
When jl.ConsID = 176 Then 'USD'
When jl.ConsID = 57 Then 'EUR'
When jl.ConsID = 62 Then 'GBP'
When jl.ConsID = 27 Then 'CAD'
When jl.ConsID = 81 Then 'INR'
When jl.ConsID = 8 Then 'AUD'
When jl.ConsID = 121 Then 'MXN'
When jl.ConsID = 21 Then 'BRL'
When jl.ConsID = 196 Then 'ZAR'
Else 'Unknown'
End) as 'Currency',

Johnny's avatar
Johnny
New Contributor II
3 years ago

Thank you, Nicole! This was my backup plan. Thankfully the currency dimensions will not change.