CE Reconcile table (CBEU1005)

azurecurveProductsCashbook (1058)FinancialCE Reconcile table (CBEU1005)

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

Product: Cashbook (1058)
Series: Financial

Display Name: CE Reconcile table
Physical Name: CBEU1005
Technical Name: CB_Euro_Reconcile

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1Status SearchStatusINTInteger20
2CB_User_Closing_Balance SearchCB_User_Closing_BalanceCB_DLR19Currency1019
3CB_Period_End_Date SearchCB_Period_End_DateDTDate48
4CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['CE Reconcile table'].CHEKBKID AS 'CE Reconcile table-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       CBEU1005 AS ['CE Reconcile table']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['CE Reconcile table'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
5CB_Statement_No SearchCB_Statement_NoSTR20String2220
6CB_Date_Last_Reconciled SearchCB_Date_Last_ReconciledDTDate48
azurecurveProductsCashbook (1058)FinancialCE Reconcile table (CBEU1005)

Leave a Reply

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