Bank Transfers Saved table (CB990024)

azurecurveProductsCashbook (1058)FinancialBank Transfers Saved table (CB990024)

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_Saved

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1TIME1 SearchTimeTM6Time46
2EXPNDATE SearchExpiration DateDT_DateDate46
3XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)1014
4EXCHDATE SearchExchange DateDT_DateDate46
5RATETPID SearchRate Type IDSTR15_Rate_Type_IDString1615
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'].RATETPID
6RATECALC SearchRate Calc MethodINTInteger20
7CB_Transfer_No SearchCB_Transfer_NoSTR20String2220
8DATE1 SearchDateDT6Date46
9CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
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'].CURNCYID
10EXGTBLID SearchExchange Table IDSTR15_Exchange_Table_IDString1615
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
azurecurveProductsCashbook (1058)FinancialBank Transfers Saved table (CB990024)

Leave a Reply

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