Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CB330009
Product: Cashbook (1058)
Series: Financial
Display Name: Cashbook Historical Print table
Physical Name: CB330009
Technical Name: CB_Print_History_CashbookSeq 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
['Cashbook Historical Print table'].INTERID AS 'Cashbook Historical Print table-Intercompany ID'
,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
CB330009 AS ['Cashbook Historical Print table']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['Cashbook Historical Print table'].INTERID = ['Company Master'].INTERID2 ACTINDX Account Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Cashbook Historical Print table'].ACTINDX AS 'Cashbook Historical Print table-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
CB330009 AS ['Cashbook Historical Print table']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Cashbook Historical Print table'].ACTINDX = ['Account Index Master'].ACTINDX3 ACTNUMST Account Number String STR128_LBU String 128 4 CB_Print_Cashbook_Key CB_Print_Cashbook_Key STR50 String 50 5 DATE1 Date DT6 Date 6 6 CB_Recon_Source CB_Recon_Source DDL Integer 0 7 CB_Recon_Trans_Type CB_Recon_Trans_Type INT Integer 0 8 CB_Document_Number_25 CB_Document_Number_25 CB_Document_Number_25 String 25 9 CB_Payee CB_Payee STR40 String 40 10 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_Trans_Amount CB_Trans_Amount CB_DLR19 Currency 19 21 CHEKBKID Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['Cashbook Historical Print table'].CHEKBKID AS 'Cashbook Historical Print table-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
CB330009 AS ['Cashbook Historical Print table']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['Cashbook Historical Print table'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID