Bank Import Import Setup table (CBABR98)

azurecurveProductsCashbook (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 NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1CB_ABR_Ref1_FN SearchCB_ABR_Ref1_FNINT3Integer23
2CB_ABR_Trans_Ref1_From SearchCB_ABR_Trans_Ref1_FromINT5Integer24
3CB_ABR_Trans_Ref1_To SearchCB_ABR_Trans_Ref1_ToINT5Integer24
4CB_ABR_Leading_Trim_Dep SearchCB_ABR_Leading_Trim_DepSTR30String3230
5CB_ABR_Leading_Trim_Pay SearchCB_ABR_Leading_Trim_PaySTR30String3230
6CB_ABR_Date_Range SearchCB_ABR_Date_RangeINT3Integer23
7CB_ABR_Deposit_Date SearchCB_ABR_Deposit_DateCB_Match_Date_DDLInteger20
8CB_Transaction_Fields_RG SearchCB_Transaction_Fields_RGCB_RGInteger20
9CB_ABR_Amount2_FN SearchCB_ABR_Amount2_FNINT3Integer23
10CB_ABR_Amount2_Formula SearchCB_ABR_Amount2_FormulaCBBoolean20
11CB_ABR_Dep_Match_By SearchCB_ABR_Dep_Match_ByCB_Dep_Match_DDLInteger20
12CB_ABR_Dep_Ref_FN SearchCB_ABR_Dep_Ref_FNINT3Integer23
13CB_ABR_Dep_Trans_Ref_Fro SearchCB_ABR_Dep_Trans_Ref_FromINT5Integer24
14CB_ABR_Dep_Trans_Ref_To SearchCB_ABR_Dep_Trans_Ref_ToINT5Integer24
15CB_ABR_DR_CR_FN SearchCB_ABR_DR_CR_FNINT3Integer23
16CB_ABR_DR_CR_Formula SearchCB_ABR_DR_CR_FormulaCBBoolean20
17CB_ABR_DR_CR_Indicator_F SearchCB_ABR_DR_CR_Indicator_FromINT5Integer24
18CB_ABR_DR_CR_Indicator_T SearchCB_ABR_DR_CR_Indicator_ToINT5Integer24
19CB_ABR_Pay_Match_By SearchCB_ABR_Pay_Match_ByCB_Pay_Match_DDLInteger20
20CB_ABR_Trans_Amount2_Fro SearchCB_ABR_Trans_Amount2_FromINT5Integer24
21CB_ABR_Trans_Amount2_To SearchCB_ABR_Trans_Amount2_ToINT5Integer24
22CB_File_Type_DDL SearchCB_File_Type_DDLCB_File_Type_DDLInteger20
23CB_ABR_Amount_FN SearchCB_ABR_Amount_FNINT3Integer23
24CB_ABR_CBID_FN SearchCB_ABR_CBID_FNINT3Integer23
25CB_ABR_Check_Digit_FN SearchCB_ABR_Check_Digit_FNINT3Integer23
26CB_ABR_Date_FN SearchCB_ABR_Date_FNINT3Integer23
27CB_ABR_Desc_FN SearchCB_ABR_Desc_FNINT3Integer23
28CB_ABR_Ref_FN SearchCB_ABR_Ref_FNINT3Integer23
29CB_ABR_Date_Formula SearchCB_ABR_Date_FormulaCBBoolean20
30CB_ABR_Date_From SearchCB_ABR_Date_FromINT5Integer24
31CB_ABR_Date_To SearchCB_ABR_Date_ToINT5Integer24
32CB_ABR_Check_Digit_2 SearchCB_ABR_Check_Digit_2STR10String1210
33CBABRAMOUNTFORMULA SearchCB_ABR_Amount_FormulaCBBoolean20
34CB_ABR_Check_Digit SearchCB_ABR_Check_DigitSTR10String1210
35CB_ABR_Check_Digit_From SearchCB_ABR_Check_Digit_FromINT5Integer24
36CB_ABR_Check_Digit_To SearchCB_ABR_Check_Digit_ToINT5Integer24
37CB_ABR_Check_From SearchCB_ABR_Check_FromINT5Integer24
38CB_ABR_Check_To SearchCB_ABR_Check_ToINT5Integer24
39CB_ABR_Import_Name SearchCB_ABR_Import_NameSTR30String3230
40CB_ABR_Trans_Amount_From SearchCB_ABR_Trans_Amount_FromINT5Integer24
41CB_ABR_Trans_Amount_To SearchCB_ABR_Trans_Amount_ToINT5Integer24
42CB_ABR_DD_From SearchCB_ABR_DD_FromINT5Integer24
43CB_ABR_DD_To SearchCB_ABR_DD_ToINT5Integer24
44CB_ABR_MM_From SearchCB_ABR_MM_FromINT5Integer24
45CB_ABR_MM_To SearchCB_ABR_MM_ToINT5Integer24
46CB_ABR_YY_From SearchCB_ABR_YY_FromINT5Integer24
47CB_ABR_YY_To SearchCB_ABR_YY_ToINT5Integer24
48CB_ABR_Trans_Description SearchCB_ABR_Trans_Description_FromINT5Integer24
49CB_ABR_Trans_DescTo SearchCB_ABR_Trans_Description_ToINT5Integer24
50CB_ABR_Trans_Ref_From SearchCB_ABR_Trans_Ref_FromINT5Integer24
51CB_ABR_Trans_Ref_To SearchCB_ABR_Trans_Ref_ToINT5Integer24
52CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
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
azurecurveProductsCashbook (1058)FinancialBank Import Import Setup table (CBABR98)

Leave a Reply

Your email address will not be published. Required fields are marked *