Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CB900020
Product: Cashbook (1058)
Series: Financial
Display Name: Bank Transfers Reports Table
Physical Name: CB900020
Technical Name: CB_Bank_Transfers_ReportSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 INTERID 
Intercompany ID STR5_IC_ID String 5 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['Bank Transfers Reports Table'].INTERID AS 'Bank Transfers Reports Table-Intercompany ID'
,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
CB900020 AS ['Bank Transfers Reports Table']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['Bank Transfers Reports Table'].INTERID = ['Company Master'].INTERID2 CB_Intercompany_ID CB_Intercompany_ID STR5_IC_ID String 5 3 CB_Check_Amount CB_Check_Amount DLR19_RBS0_UTR$ Currency 19 4 CB_Check_Amount_Cash CB_Check_Amount_Cash DLR19_RBS0_UTR$ Currency 19 5 CB_Func_Amount CB_Func_Amount DLR19_RBS0_UTR$ Currency 19 6 CB_Func_Amount_Cash CB_Func_Amount_Cash DLR19_RBS0_UTR$ Currency 19 7 CB_Multiply_Divide CB_Multiply_Divide STR15 String 15 8 CB_Multiply_Divide_Cash CB_Multiply_Divide_Cash STR15 String 15 9 CB_Trans_Amount_2 CB_Trans_Amount_2 DLR19_RBS0_STR$ Currency 19 10 CB_Currency_Index1 CB_Currency_Index1 INT3 Integer 3 11 CB_Currency_Index2 CB_Currency_Index2 INT3 Integer 3 12 CB_Printed CB_Printed boolean Boolean 0 13 CB_Transfer_No CB_Transfer_No STR20 String 20 14 CB_Checkbook_Currency CB_Checkbook_Currency STR15_Currency_ID String 15 15 CB_Currency_ID1 CB_Currency_ID1 STR15_Currency_ID String 15 16 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 Reports Table'].EXGTBLID AS 'Bank Transfers Reports Table-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
CB900020 AS ['Bank Transfers Reports Table']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['Bank Transfers Reports Table'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID17 RATECALC Rate Calc Method INT Integer 0 18 EXCHDATE Exchange Date DT_Date Date 6 19 XCHGRATE Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 20 TIME1 Time TM6 Time 6 21 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 Reports Table'].RATETPID AS 'Bank Transfers Reports Table-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
CB900020 AS ['Bank Transfers Reports Table']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['Bank Transfers Reports Table'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID22 EXPNDATE Expiration Date DT_Date Date 6 23 CB_Exchange_Rate CB_Exchange_Rate DLR14_Exchange_Rate Currency (Variable) 14 24 CB_Exchange_Rate_2 CB_Exchange_Rate_2 DLR14_Exchange_Rate Currency (Variable) 14 25 CB_Rate_Calc_Method CB_Rate_Calc_Method INT Integer 0 26 CB_Rate_Calc_Method_2 CB_Rate_Calc_Method_2 INT Integer 0 27 DATE1 Date DT6 Date 6 28 CB_Trans_Amount CB_Trans_Amount CB_DLR19 Currency 19 29 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['Bank Transfers Reports Table'].CURNCYID AS 'Bank Transfers Reports Table-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
CB900020 AS ['Bank Transfers Reports Table']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Bank Transfers Reports Table'].CURNCYID = ['Currency Setup'].CURNCYID30 CURRNIDX Currency Index INT3 Integer 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['Bank Transfers Reports Table'].CURRNIDX AS 'Bank Transfers Reports Table-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
CB900020 AS ['Bank Transfers Reports Table']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Bank Transfers Reports Table'].CURRNIDX = ['Currency Setup'].CURRNIDX31 CHEKBKID Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['Bank Transfers Reports Table'].CHEKBKID AS 'Bank Transfers Reports Table-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
CB900020 AS ['Bank Transfers Reports Table']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['Bank Transfers Reports Table'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID32 CBKIDCSH Checkbook ID Cash STR15_Checkbook_ID String 15 33 ACTINDX Account Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Bank Transfers Reports Table'].ACTINDX AS 'Bank Transfers Reports Table-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
CB900020 AS ['Bank Transfers Reports Table']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Bank Transfers Reports Table'].ACTINDX = ['Account Index Master'].ACTINDX34 ACTNUMBR_1 Account Number:Account_Segment_Pool1 Account_Segment_Pool1 String 6 35 ACTNUMBR_2 Account Number:Account_Segment_Pool2 Account_Segment_Pool2 String 6 36 ACTNUMBR_3 Account Number:Account_Segment_Pool3 Account_Segment_Pool3 String 6 37 ACTNUMBR_4 Account Number:Account_Segment_Pool4 Account_Segment_Pool4 String 6 38 ACTNUMBR_5 Account Number:Account_Segment_Pool5 Account_Segment_Pool5 String 6 39 ACTNUMBR_6 Account Number:Account_Segment_Pool6 Account_Segment_Pool6 String 6 40 ACTNUMBR_7 Account Number:Account_Segment_Pool7 Account_Segment_Pool7 String 6 41 ACTNUMBR_8 Account Number:Account_Segment_Pool8 Account_Segment_Pool8 String 6 42 ACTNUMBR_9 Account Number:Account_Segment_Pool9 Account_Segment_Pool9 String 6 43 ACTNUMBR_10 Account Number:Account_Segment_Pool10 Account_Segment_Pool10 String 6 44 CB_Cash_Account_Index CB_Cash_Account_Index LI_14 Long Integer 14 45 CB_Cash_Account_Number_1 CB_Cash_Account_Number:Account_Segment_Pool1 Account_Segment_Pool1 String 6 46 CB_Cash_Account_Number_2 CB_Cash_Account_Number:Account_Segment_Pool2 Account_Segment_Pool2 String 6 47 CB_Cash_Account_Number_3 CB_Cash_Account_Number:Account_Segment_Pool3 Account_Segment_Pool3 String 6 48 CB_Cash_Account_Number_4 CB_Cash_Account_Number:Account_Segment_Pool4 Account_Segment_Pool4 String 6 49 CB_Cash_Account_Number_5 CB_Cash_Account_Number:Account_Segment_Pool5 Account_Segment_Pool5 String 6 50 CB_Cash_Account_Number_6 CB_Cash_Account_Number:Account_Segment_Pool6 Account_Segment_Pool6 String 6 51 CB_Cash_Account_Number_7 CB_Cash_Account_Number:Account_Segment_Pool7 Account_Segment_Pool7 String 6 52 CB_Cash_Account_Number_8 CB_Cash_Account_Number:Account_Segment_Pool8 Account_Segment_Pool8 String 6 53 CB_Cash_Account_Number_9 CB_Cash_Account_Number:Account_Segment_Pool9 Account_Segment_Pool9 String 6 54 CB_Cash_Account_Number_10 CB_Cash_Account_Number:Account_Segment_Pool10 Account_Segment_Pool10 String 6