Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CB990024
Product: Cashbook (1058)
Series: Financial
Display Name: Bank Transfers Saved table
Physical Name: CB990024
Technical Name: CB_Bank_Transfers_SavedSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 TIME1 
Time TM6 Time 6 2 EXPNDATE Expiration Date DT_Date Date 6 3 XCHGRATE Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 4 EXCHDATE Exchange Date DT_Date Date 6 5 RATETPID Rate Type ID STR15_Rate_Type_ID String 15 Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hide
SELECT
['Bank Transfers Saved table'].RATETPID AS 'Bank Transfers Saved table-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
CB990024 AS ['Bank Transfers Saved table']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['Bank Transfers Saved table'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID6 RATECALC Rate Calc Method INT Integer 0 7 CB_Transfer_No CB_Transfer_No STR20 String 20 8 DATE1 Date DT6 Date 6 9 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['Bank Transfers Saved table'].CURNCYID AS 'Bank Transfers Saved table-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
CB990024 AS ['Bank Transfers Saved table']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Bank Transfers Saved table'].CURNCYID = ['Currency Setup'].CURNCYID10 EXGTBLID Exchange Table ID STR15_Exchange_Table_ID String 15 Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hide
SELECT
['Bank Transfers Saved table'].EXGTBLID AS 'Bank Transfers Saved table-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
CB990024 AS ['Bank Transfers Saved table']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['Bank Transfers Saved table'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID