Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CBABR98
Product: Cashbook (1058)
Series: Financial
Display Name: Bank Import Import Setup table
Physical Name: CBABR98
Technical Name: CB_ABR_Import_SetupSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CB_ABR_Ref1_FN 
CB_ABR_Ref1_FN INT3 Integer 3 2 CB_ABR_Trans_Ref1_From CB_ABR_Trans_Ref1_From INT5 Integer 4 3 CB_ABR_Trans_Ref1_To CB_ABR_Trans_Ref1_To INT5 Integer 4 4 CB_ABR_Leading_Trim_Dep CB_ABR_Leading_Trim_Dep STR30 String 30 5 CB_ABR_Leading_Trim_Pay CB_ABR_Leading_Trim_Pay STR30 String 30 6 CB_ABR_Date_Range CB_ABR_Date_Range INT3 Integer 3 7 CB_ABR_Deposit_Date CB_ABR_Deposit_Date CB_Match_Date_DDL Integer 0 8 CB_Transaction_Fields_RG CB_Transaction_Fields_RG CB_RG Integer 0 9 CB_ABR_Amount2_FN CB_ABR_Amount2_FN INT3 Integer 3 10 CB_ABR_Amount2_Formula CB_ABR_Amount2_Formula CB Boolean 0 11 CB_ABR_Dep_Match_By CB_ABR_Dep_Match_By CB_Dep_Match_DDL Integer 0 12 CB_ABR_Dep_Ref_FN CB_ABR_Dep_Ref_FN INT3 Integer 3 13 CB_ABR_Dep_Trans_Ref_Fro CB_ABR_Dep_Trans_Ref_From INT5 Integer 4 14 CB_ABR_Dep_Trans_Ref_To CB_ABR_Dep_Trans_Ref_To INT5 Integer 4 15 CB_ABR_DR_CR_FN CB_ABR_DR_CR_FN INT3 Integer 3 16 CB_ABR_DR_CR_Formula CB_ABR_DR_CR_Formula CB Boolean 0 17 CB_ABR_DR_CR_Indicator_F CB_ABR_DR_CR_Indicator_From INT5 Integer 4 18 CB_ABR_DR_CR_Indicator_T CB_ABR_DR_CR_Indicator_To INT5 Integer 4 19 CB_ABR_Pay_Match_By CB_ABR_Pay_Match_By CB_Pay_Match_DDL Integer 0 20 CB_ABR_Trans_Amount2_Fro CB_ABR_Trans_Amount2_From INT5 Integer 4 21 CB_ABR_Trans_Amount2_To CB_ABR_Trans_Amount2_To INT5 Integer 4 22 CB_File_Type_DDL CB_File_Type_DDL CB_File_Type_DDL Integer 0 23 CB_ABR_Amount_FN CB_ABR_Amount_FN INT3 Integer 3 24 CB_ABR_CBID_FN CB_ABR_CBID_FN INT3 Integer 3 25 CB_ABR_Check_Digit_FN CB_ABR_Check_Digit_FN INT3 Integer 3 26 CB_ABR_Date_FN CB_ABR_Date_FN INT3 Integer 3 27 CB_ABR_Desc_FN CB_ABR_Desc_FN INT3 Integer 3 28 CB_ABR_Ref_FN CB_ABR_Ref_FN INT3 Integer 3 29 CB_ABR_Date_Formula CB_ABR_Date_Formula CB Boolean 0 30 CB_ABR_Date_From CB_ABR_Date_From INT5 Integer 4 31 CB_ABR_Date_To CB_ABR_Date_To INT5 Integer 4 32 CB_ABR_Check_Digit_2 CB_ABR_Check_Digit_2 STR10 String 10 33 CBABRAMOUNTFORMULA CB_ABR_Amount_Formula CB Boolean 0 34 CB_ABR_Check_Digit CB_ABR_Check_Digit STR10 String 10 35 CB_ABR_Check_Digit_From CB_ABR_Check_Digit_From INT5 Integer 4 36 CB_ABR_Check_Digit_To CB_ABR_Check_Digit_To INT5 Integer 4 37 CB_ABR_Check_From CB_ABR_Check_From INT5 Integer 4 38 CB_ABR_Check_To CB_ABR_Check_To INT5 Integer 4 39 CB_ABR_Import_Name CB_ABR_Import_Name STR30 String 30 40 CB_ABR_Trans_Amount_From CB_ABR_Trans_Amount_From INT5 Integer 4 41 CB_ABR_Trans_Amount_To CB_ABR_Trans_Amount_To INT5 Integer 4 42 CB_ABR_DD_From CB_ABR_DD_From INT5 Integer 4 43 CB_ABR_DD_To CB_ABR_DD_To INT5 Integer 4 44 CB_ABR_MM_From CB_ABR_MM_From INT5 Integer 4 45 CB_ABR_MM_To CB_ABR_MM_To INT5 Integer 4 46 CB_ABR_YY_From CB_ABR_YY_From INT5 Integer 4 47 CB_ABR_YY_To CB_ABR_YY_To INT5 Integer 4 48 CB_ABR_Trans_Description CB_ABR_Trans_Description_From INT5 Integer 4 49 CB_ABR_Trans_DescTo CB_ABR_Trans_Description_To INT5 Integer 4 50 CB_ABR_Trans_Ref_From CB_ABR_Trans_Ref_From INT5 Integer 4 51 CB_ABR_Trans_Ref_To CB_ABR_Trans_Ref_To INT5 Integer 4 52 CHEKBKID Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['Bank Import Import Setup table'].CHEKBKID AS 'Bank Import Import Setup table-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
CBABR98 AS ['Bank Import Import Setup table']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['Bank Import Import Setup table'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID