Saved Build Deposits (CB800088)

azurecurveProductsCashbook (1058)FinancialSaved Build Deposits (CB800088)

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

Product: Cashbook (1058)
Series: Financial

Display Name: Saved Build Deposits
Physical Name: CB800088
Technical Name: CB_Saved_Deposits

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1DEPDATE SearchDeposit DateDTDate48
2DSCRIPTN SearchDescriptionSTR30String3230
3CB_No_Receipts SearchCB_No_ReceiptsINT4Integer24
4CB_No_Cheques SearchCB_No_ChequesINT3Integer23
5CB_No_Credit SearchCB_No_CreditINT3Integer23
6CB_No_Cash SearchCB_No_CashINT3Integer23
7CB_Amount_Cheques SearchCB_Amount_ChequesDLR19_RBS0_STR$Currency1019
8CB_Amount_Credit SearchCB_Amount_CreditDLR19_RBS0_STR$Currency1019
9CB_Amount_Cash SearchCB_Amount_CashDLR19_RBS0_STR$Currency1019
10CB_Amount_Coin SearchCB_Amount_CoinDLR19_RBS0_STR$Currency1019
11DepAmt SearchDeposit AmountDLR19_RBS0_STR$Currency1019
12depositnumber SearchDeposit NumberSTR20_Document_NumberString2220
13CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['Saved Build Deposits'].CHEKBKID AS 'Saved Build Deposits-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       CB800088 AS ['Saved Build Deposits']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['Saved Build Deposits'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
azurecurveProductsCashbook (1058)FinancialSaved Build Deposits (CB800088)

Leave a Reply

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