Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CB990019
Product: Cashbook (1058)
Series: Financial
Display Name: History Bank Transfers To Table
Physical Name: CB990019
Technical Name: CB_History_Bank_Transfers_ToSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CB_BT_CHG_Void_Date 
CB_BT_CHG_Void_Date DATE Date 6 2 CB_BT_CHG_Voided CB_BT_CHG_Voided boolean Boolean 0 3 CB_BT_CHG_Func_Amount CB_BT_CHG_Func_Amount DLR19_RBS0_STR$ Currency 19 4 CB_BT_CHG_Den_Ex CB_BT_CHG_Den_Ex_Rate DLR14_Exchange_Rate Currency (Variable) 14 5 CB_BT_CHG_Exchange_Date CB_BT_CHG_Exchange_Date DT_Date Date 6 6 CB_BT_CHG_Exchange_Rate CB_BT_CHG_Exchange_Rate DLR14_Exchange_Rate Currency (Variable) 14 7 CB_BT_CHG_Exchange_Table CB_BT_CHG_Exchange_Table_ID STR15_Exchange_Table_ID String 15 8 CB_BT_CHG_Expiration_Dat CB_BT_CHG_Expiration_Date DT_Date Date 6 9 CB_BT_CHG_MC_Trans_State CB_BT_CHG_MC_Trans_State INT1 Integer 1 10 CB_BT_CHG_Rate_Calc_Meth CB_BT_CHG_Rate_Calc_Method INT Integer 0 11 CB_BT_CHG_Rate_Type_ID CB_BT_CHG_Rate_Type_ID STR15_Rate_Type_ID String 15 12 CB_BT_CHG_Time CB_BT_CHG_Time TM6 Time 6 13 CB_BT_CHG_Account_Index CB_BT_CHG_Account_Index LI_14 Long Integer 14 14 CB_BT_CHG_Amount CB_BT_CHG_Amount CB_DLR19 Currency 19 15 CB_BT_CHG_Number CB_BT_CHG_Number STR20_Document_Number String 20 16 CB_Intercompany_ID CB_Intercompany_ID STR5_IC_ID String 5 17 CBKIDCSH Checkbook ID Cash STR15_Checkbook_ID String 15 18 CB_Exchange_Rate_2 CB_Exchange_Rate_2 DLR14_Exchange_Rate Currency (Variable) 14 19 CB_Rate_Calc_Method_2 CB_Rate_Calc_Method_2 INT Integer 0 20 CB_Currency_ID1 CB_Currency_ID1 STR15_Currency_ID String 15 21 CB_Currency_Index2 CB_Currency_Index2 INT3 Integer 3 22 ACTINDX Account Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['History Bank Transfers To Table'].ACTINDX AS 'History Bank Transfers To Table-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
CB990019 AS ['History Bank Transfers To Table']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['History Bank Transfers To Table'].ACTINDX = ['Account Index Master'].ACTINDX23 ACTNUMBR_1 Account Number:Account_Segment_Pool1 Account_Segment_Pool1 String 6 24 ACTNUMBR_2 Account Number:Account_Segment_Pool2 Account_Segment_Pool2 String 6 25 ACTNUMBR_3 Account Number:Account_Segment_Pool3 Account_Segment_Pool3 String 6 26 ACTNUMBR_4 Account Number:Account_Segment_Pool4 Account_Segment_Pool4 String 6 27 ACTNUMBR_5 Account Number:Account_Segment_Pool5 Account_Segment_Pool5 String 6 28 ACTNUMBR_6 Account Number:Account_Segment_Pool6 Account_Segment_Pool6 String 6 29 ACTNUMBR_7 Account Number:Account_Segment_Pool7 Account_Segment_Pool7 String 6 30 ACTNUMBR_8 Account Number:Account_Segment_Pool8 Account_Segment_Pool8 String 6 31 ACTNUMBR_9 Account Number:Account_Segment_Pool9 Account_Segment_Pool9 String 6 32 ACTNUMBR_10 Account Number:Account_Segment_Pool10 Account_Segment_Pool10 String 6 33 CB_Company_ID CB_Company_ID INT5 Integer 4 34 CB_Transfer_No CB_Transfer_No STR20 String 20 35 CB_Trans_Amount_2 CB_Trans_Amount_2 DLR19_RBS0_STR$ Currency 19 36 CHEKBKID Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['History Bank Transfers To Table'].CHEKBKID AS 'History Bank Transfers To Table-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
CB990019 AS ['History Bank Transfers To Table']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['History Bank Transfers To Table'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID