Cashbook Periods (CB900025)

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

Product: Cashbook (1058)
Series: Financial

Display Name: Cashbook Periods
Physical Name: CB900025
Technical Name: CB_Cashbook_Periods

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

Click to show/hide

SELECT
       ['Cashbook Periods'].CHEKBKID AS 'Cashbook Periods-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       CB900025 AS ['Cashbook Periods']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['Cashbook Periods'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
3CB_Period SearchCB_PeriodSTR10String1210
4CB_Opening_Balance SearchCB_Opening_BalanceDLR19_RBS0_STR$Currency1019
5CB_Closing_Balance SearchCB_Closing_BalanceDLR19_RBS0_STR$Currency1019
6CB_Payments SearchCB_PaymentsDLR19_RBS0_STR$Currency1019
7CB_Deposits SearchCB_DepositsDLR19_RBS0_STR$Currency1019
8CB_Closing_Date SearchCB_Closing_DateDATEDate46
9CB_Opening_Date SearchCB_Opening_DateDATEDate46
10CB_Statement_Balance SearchCB_Statement_BalanceDLR19_RBS0_STR$Currency1019
11CB_Opening_Statement_Bal SearchCB_Opening_Statement_BalanceDLR19_RBS0_STR$Currency1019
12CB_Open_Closed SearchCB_Open_ClosedBooleanBoolean20
13CB_Outstanding_Deposits SearchCB_Outstanding_DepositsDLR19_RBS0_STR$Currency1019
14CB_Outstanding_Payments SearchCB_Outstanding_PaymentsDLR19_RBS0_STR$Currency1019

Leave a Reply

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