Bank Import Date Amount Formula (CBABR16)

azurecurveProductsCashbook (1058)FinancialBank Import Date Amount Formula (CBABR16)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CBABR16

Product: Cashbook (1058)
Series: Financial

Display Name: Bank Import Date Amount Formula
Physical Name: CBABR16
Technical Name: CB_ABR_DateAmountFormula

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['Bank Import Date Amount Formula'].CHEKBKID AS 'Bank Import Date Amount Formula-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       CBABR16 AS ['Bank Import Date Amount Formula']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['Bank Import Date Amount Formula'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
2CB_ABR_Import_Name SearchCB_ABR_Import_NameSTR30String3230
3CB_ABR_Day_From SearchCB_ABR_Day_FromINT5_RU0Integer25
4CB_ABR_Day_Length SearchCB_ABR_Day_LengthINT5_RU0Integer25
5CB_ABR_Month_From SearchCB_ABR_Month_FromINT5_RU0Integer25
6CB_ABR_Month_Length SearchCB_ABR_Month_LengthINT5_RU0Integer25
7CB_ABR_Year_From SearchCB_ABR_Year_FromINT5_RU0Integer25
8CB_ABR_Year_Length SearchCB_ABR_Year_LengthINT5_RU0Integer25
9CB_ABR_MonthInChar SearchCB_ABR_MonthInCharCBBoolean20
10CB_ABR_Value SearchCB_ABR_ValueINT6_LU0Long Integer46
azurecurveProductsCashbook (1058)FinancialBank Import Date Amount Formula (CBABR16)

Leave a Reply

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