ABR BAI Currencies (NCABR319)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NCABR319

Product: Advanced Bank Reconciliation (2440)
Series: Financial

Display Name: ABR BAI Currencies
Physical Name: NCABR319
Technical Name: NC_BAI_Curr

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1NC_BAI_Curr SearchNC_BAI_CurrSTR10String10
2CURNCYID SearchCurrency IDSTR15_Currency_IDString15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['ABR BAI Currencies'].CURNCYID AS 'ABR BAI Currencies-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       NCABR319 AS ['ABR BAI Currencies']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['ABR BAI Currencies'].CURNCYID = ['Currency Setup'].CURNCYID

Leave a Reply

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