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 TypeLength
1CB_Upgrade SearchCB_UpgradebooleanBoolean0
2CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString15
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_PeriodSTR10String10
4CB_Opening_Balance SearchCB_Opening_BalanceDLR19_RBS0_STR$Currency19
5CB_Closing_Balance SearchCB_Closing_BalanceDLR19_RBS0_STR$Currency19
6CB_Payments SearchCB_PaymentsDLR19_RBS0_STR$Currency19
7CB_Deposits SearchCB_DepositsDLR19_RBS0_STR$Currency19
8CB_Closing_Date SearchCB_Closing_DateDATEDate6
9CB_Opening_Date SearchCB_Opening_DateDATEDate6
10CB_Statement_Balance SearchCB_Statement_BalanceDLR19_RBS0_STR$Currency19
11CB_Opening_Statement_Bal SearchCB_Opening_Statement_BalanceDLR19_RBS0_STR$Currency19
12CB_Open_Closed SearchCB_Open_ClosedBooleanBoolean0
13CB_Outstanding_Deposits SearchCB_Outstanding_DepositsDLR19_RBS0_STR$Currency19
14CB_Outstanding_Payments SearchCB_Outstanding_PaymentsDLR19_RBS0_STR$Currency19

Leave a Reply

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