Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CB880004
Product: Cashbook (1058)
Series: Financial
Display Name: History Bank Transfers Table
Physical Name: CB880004
Technical Name: CB_History_Bank_TransferSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CB_Audit_Trail 
CB_Audit_Trail STR15 String 15 2 CB_Transfer_No CB_Transfer_No STR20 String 20 3 DATE1 Date DT6 Date 6 4 CB_Trans_Amount CB_Trans_Amount CB_DLR19 Currency 19 5 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['History Bank Transfers Table'].CURNCYID AS 'History Bank Transfers Table-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
CB880004 AS ['History Bank Transfers Table']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['History Bank Transfers Table'].CURNCYID = ['Currency Setup'].CURNCYID6 CURRNIDX Currency Index INT3 Integer 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['History Bank Transfers Table'].CURRNIDX AS 'History Bank Transfers Table-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
CB880004 AS ['History Bank Transfers Table']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['History Bank Transfers Table'].CURRNIDX = ['Currency Setup'].CURRNIDX7 CHEKBKID Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['History Bank Transfers Table'].CHEKBKID AS 'History Bank Transfers Table-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
CB880004 AS ['History Bank Transfers Table']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['History Bank Transfers Table'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID8 CBKIDCSH Checkbook ID Cash STR15_Checkbook_ID String 15 9 ACTINDX Account Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['History Bank Transfers Table'].ACTINDX AS 'History Bank Transfers Table-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
CB880004 AS ['History Bank Transfers Table']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['History Bank Transfers Table'].ACTINDX = ['Account Index Master'].ACTINDX10 ACTNUMBR_1 Account Number:Account_Segment_Pool1 Account_Segment_Pool1 String 6 11 ACTNUMBR_2 Account Number:Account_Segment_Pool2 Account_Segment_Pool2 String 6 12 ACTNUMBR_3 Account Number:Account_Segment_Pool3 Account_Segment_Pool3 String 6 13 ACTNUMBR_4 Account Number:Account_Segment_Pool4 Account_Segment_Pool4 String 6 14 ACTNUMBR_5 Account Number:Account_Segment_Pool5 Account_Segment_Pool5 String 6 15 ACTNUMBR_6 Account Number:Account_Segment_Pool6 Account_Segment_Pool6 String 6 16 ACTNUMBR_7 Account Number:Account_Segment_Pool7 Account_Segment_Pool7 String 6 17 ACTNUMBR_8 Account Number:Account_Segment_Pool8 Account_Segment_Pool8 String 6 18 ACTNUMBR_9 Account Number:Account_Segment_Pool9 Account_Segment_Pool9 String 6 19 ACTNUMBR_10 Account Number:Account_Segment_Pool10 Account_Segment_Pool10 String 6 20 CB_Cash_Account_Index CB_Cash_Account_Index LI_14 Long Integer 14 21 CB_Cash_Account_Number_1 CB_Cash_Account_Number:Account_Segment_Pool1 Account_Segment_Pool1 String 6 22 CB_Cash_Account_Number_2 CB_Cash_Account_Number:Account_Segment_Pool2 Account_Segment_Pool2 String 6 23 CB_Cash_Account_Number_3 CB_Cash_Account_Number:Account_Segment_Pool3 Account_Segment_Pool3 String 6 24 CB_Cash_Account_Number_4 CB_Cash_Account_Number:Account_Segment_Pool4 Account_Segment_Pool4 String 6 25 CB_Cash_Account_Number_5 CB_Cash_Account_Number:Account_Segment_Pool5 Account_Segment_Pool5 String 6 26 CB_Cash_Account_Number_6 CB_Cash_Account_Number:Account_Segment_Pool6 Account_Segment_Pool6 String 6 27 CB_Cash_Account_Number_7 CB_Cash_Account_Number:Account_Segment_Pool7 Account_Segment_Pool7 String 6 28 CB_Cash_Account_Number_8 CB_Cash_Account_Number:Account_Segment_Pool8 Account_Segment_Pool8 String 6 29 CB_Cash_Account_Number_9 CB_Cash_Account_Number:Account_Segment_Pool9 Account_Segment_Pool9 String 6 30 CB_Cash_Account_Number_10 CB_Cash_Account_Number:Account_Segment_Pool10 Account_Segment_Pool10 String 6