History Build Deposits (CB550008)

azurecurveProductsCashbook (1058)FinancialHistory Build Deposits (CB550008)

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

Product: Cashbook (1058)
Series: Financial

Display Name: History Build Deposits
Physical Name: CB550008
Technical Name: CB_History_History_Cash_Dep

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1CB_User_ID SearchCB_User_IDSTR15_User_IDString1615
2CB_Audit_Trail SearchCB_Audit_TrailSTR15String1615
3CURRNIDX SearchCurrency IndexINT3Integer23
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['History Build Deposits'].CURRNIDX AS 'History Build Deposits-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       CB550008 AS ['History Build Deposits']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['History Build Deposits'].CURRNIDX = ['Currency Setup'].CURRNIDX
4CB_Sales_Type SearchCB_Sales_TypeINT1Integer21
5CB_Sales_Number SearchCB_Sales_NumberSTR30String3230
6CB_Type_Enquiry SearchCB_Type_EnquiryINT2Integer22
7CB_Amount_Cash SearchCB_Amount_CashDLR19_RBS0_STR$Currency1019
8CB_Amount_Cheques SearchCB_Amount_ChequesDLR19_RBS0_STR$Currency1019
9CB_Amount_Coin SearchCB_Amount_CoinDLR19_RBS0_STR$Currency1019
10CB_Amount_Credit SearchCB_Amount_CreditDLR19_RBS0_STR$Currency1019
11CB_No_Cash SearchCB_No_CashINT3Integer23
12CB_No_Cheques SearchCB_No_ChequesINT3Integer23
13CB_No_Credit SearchCB_No_CreditINT3Integer23
14CB_No_Receipts SearchCB_No_ReceiptsINT4Integer24
15DEPDATE SearchDeposit DateDTDate48
16depositnumber SearchDeposit NumberSTR20_Document_NumberString2220
17DSCRIPTN SearchDescriptionSTR30String3230
18USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['History Build Deposits'].USERID AS 'History Build Deposits-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       CB550008 AS ['History Build Deposits']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['History Build Deposits'].USERID = ['Users Master'].USERID
19CB_Printed SearchCB_PrintedbooleanBoolean20
20CUSTNAME SearchCustomer NameSTR64_Customer_NameString6664
21CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['History Build Deposits'].CHEKBKID AS 'History Build Deposits-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       CB550008 AS ['History Build Deposits']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['History Build Deposits'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
22CHEKNMBR SearchCheck NumberSTR20_Document_NumberString2220
23RcpType SearchReceipt TypeDDL_Document_TypeInteger20
24DATE1 SearchDateDT6Date46
25DOCNUMBR SearchDocument NumberSTR20_Document_NumberString2220
26CB_Trans_Amount SearchCB_Trans_AmountCB_DLR19Currency1019
27RcvdFrom SearchReceived FromSTR30String3230
28CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['History Build Deposits'].CUSTNMBR AS 'History Build Deposits-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       CB550008 AS ['History Build Deposits']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['History Build Deposits'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
29BANKNAME SearchBank NameSTR30String3230
30BNKBRNCH SearchBank BranchSTR20String2220
31CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['History Build Deposits'].CURNCYID AS 'History Build Deposits-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       CB550008 AS ['History Build Deposits']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['History Build Deposits'].CURNCYID = ['Currency Setup'].CURNCYID
32CB_Check_Deposit SearchCB_Check_DepositCB_Check_DepositBoolean20
azurecurveProductsCashbook (1058)FinancialHistory Build Deposits (CB550008)

Leave a Reply

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