Bank Import Import Setup table (CBABR98)

azurecurve Products Cashbook (1058)FinancialBank Import Import Setup table (CBABR98)

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_Setup

Seq 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

azurecurve Products Cashbook (1058)FinancialBank Import Import Setup table (CBABR98)

Click to show/hide

Leave a Reply Cancel reply