Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CBABR10
Product: Cashbook (1058)
Series: Financial
Display Name: Statement Transactions Master Table
Physical Name: CBABR10
Technical Name: SAB_STATEMENT_TRANSACTIONS_MSTRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CB_ABR_DR_CR_Indicator 
CB_ABR_DR_CR_Indicator STR5 String 5 2 Checkbook_ID SAB_CHECKBOOK_ID STR15_Checkbook_ID String 15 3 Statement_Date SAB_STATEMENT_DATE DT Date 8 4 Statement_Number SAB_STATEMENT_NUMBER STR6 String 6 5 Trx_Date SAB_TRX_DATE DT6 Date 6 6 Trx_Amount SAB_TRX_AMOUNT DLR19_RBS0_UTR$ Currency 19 7 Trx_Reference SAB_TRX_REFERENCE STR20 String 20 8 Trx_Description SAB_TRX_DESCRIPTION STR40 String 40 9 Trx_Recno SAB_TRX_RECNO DLR_Document_Number Currency 19 10 SAB_CHECKBOX SAB_CHECKBOX CB Boolean 0 11 CHEKBKID Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['Statement Transactions Master Table'].CHEKBKID AS 'Statement Transactions Master Table-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
CBABR10 AS ['Statement Transactions Master Table']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['Statement Transactions Master Table'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID12 CB_Recon_Trans_Type CB_Recon_Trans_Type INT Integer 0 13 DOCNUMBR Document Number STR20_Document_Number String 20