Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CB900036
Product: Cashbook (1058)
Series: Financial
Display Name: Partial Recon table
Physical Name: CB900036
Technical Name: CB_Recon_PartialSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CB_Last_Partial_Recon_AM CB_Last_Partial_Recon_AMT DLR19_$S2 Currency 19 2 CB_Trans_Amount CB_Trans_Amount CB_DLR19 Currency 19 3 CB_Recon_Trans_Type CB_Recon_Trans_Type INT Integer 0 4 CB_Document_Number_25 CB_Document_Number_25 CB_Document_Number_25 String 25 5 CB_Current_Period CB_Current_Period boolean Boolean 0 6 CHEKBKID Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['Partial Recon table'].CHEKBKID AS 'Partial Recon table-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
CB900036 AS ['Partial Recon table']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['Partial Recon table'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
7 CB_Unpartial_Current_Per CB_Unpartial_Current_Period boolean Boolean 0