Reconcile Setup (CB600001)

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

Product: Cashbook (1058)
Series: Financial

Display Name: Reconcile Setup
Physical Name: CB600001
Technical Name: CB_Recon_SETP

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
       ['Reconcile Setup'].CHEKBKID AS 'Reconcile Setup-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       CB600001 AS ['Reconcile Setup']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['Reconcile Setup'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
2DSCRIPTN SearchDescriptionSTR30String3230
3CB_Last_Statement_Bal SearchCB_Last_Statement_BalCB_DLR19Currency1019
4CB_Reconciled_Once SearchCB_Reconciled_OnceBooleanBoolean20
5DATE1 SearchDateDT6Date46

Leave a Reply

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