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 TypeLength
1CB_User_ID SearchCB_User_IDSTR15_User_IDString15
2CB_Audit_Trail SearchCB_Audit_TrailSTR15String15
3CURRNIDX SearchCurrency IndexINT3Integer3
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_TypeINT1Integer1
5CB_Sales_Number SearchCB_Sales_NumberSTR30String30
6CB_Type_Enquiry SearchCB_Type_EnquiryINT2Integer2
7CB_Amount_Cash SearchCB_Amount_CashDLR19_RBS0_STR$Currency19
8CB_Amount_Cheques SearchCB_Amount_ChequesDLR19_RBS0_STR$Currency19
9CB_Amount_Coin SearchCB_Amount_CoinDLR19_RBS0_STR$Currency19
10CB_Amount_Credit SearchCB_Amount_CreditDLR19_RBS0_STR$Currency19
11CB_No_Cash SearchCB_No_CashINT3Integer3
12CB_No_Cheques SearchCB_No_ChequesINT3Integer3
13CB_No_Credit SearchCB_No_CreditINT3Integer3
14CB_No_Receipts SearchCB_No_ReceiptsINT4Integer4
15DEPDATE SearchDeposit DateDTDate8
16depositnumber SearchDeposit NumberSTR20_Document_NumberString20
17DSCRIPTN SearchDescriptionSTR30String30
18USERID SearchUser IDSTR15_User_IDString15
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_PrintedbooleanBoolean0
20CUSTNAME SearchCustomer NameSTR64_Customer_NameString64
21CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString15
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_NumberString20
23RcpType SearchReceipt TypeDDL_Document_TypeInteger0
24DATE1 SearchDateDT6Date6
25DOCNUMBR SearchDocument NumberSTR20_Document_NumberString20
26CB_Trans_Amount SearchCB_Trans_AmountCB_DLR19Currency19
27RcvdFrom SearchReceived FromSTR30String30
28CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
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 NameSTR30String30
30BNKBRNCH SearchBank BranchSTR20String20
31CURNCYID SearchCurrency IDSTR15_Currency_IDString15
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_DepositBoolean0
azurecurveProductsCashbook (1058)FinancialHistory Build Deposits (CB550008)

Leave a Reply

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