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_DepSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CB_User_ID 
CB_User_ID STR15_User_ID String 15 2 CB_Audit_Trail CB_Audit_Trail STR15 String 15 3 CURRNIDX Currency Index INT3 Integer 3 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'].CURRNIDX4 CB_Sales_Type CB_Sales_Type INT1 Integer 1 5 CB_Sales_Number CB_Sales_Number STR30 String 30 6 CB_Type_Enquiry CB_Type_Enquiry INT2 Integer 2 7 CB_Amount_Cash CB_Amount_Cash DLR19_RBS0_STR$ Currency 19 8 CB_Amount_Cheques CB_Amount_Cheques DLR19_RBS0_STR$ Currency 19 9 CB_Amount_Coin CB_Amount_Coin DLR19_RBS0_STR$ Currency 19 10 CB_Amount_Credit CB_Amount_Credit DLR19_RBS0_STR$ Currency 19 11 CB_No_Cash CB_No_Cash INT3 Integer 3 12 CB_No_Cheques CB_No_Cheques INT3 Integer 3 13 CB_No_Credit CB_No_Credit INT3 Integer 3 14 CB_No_Receipts CB_No_Receipts INT4 Integer 4 15 DEPDATE Deposit Date DT Date 8 16 depositnumber Deposit Number STR20_Document_Number String 20 17 DSCRIPTN Description STR30 String 30 18 USERID User ID STR15_User_ID String 15 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'].USERID19 CB_Printed CB_Printed boolean Boolean 0 20 CUSTNAME Customer Name STR64_Customer_Name String 64 21 CHEKBKID Checkbook ID STR15_Checkbook_ID String 15 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'].CHEKBKID22 CHEKNMBR Check Number STR20_Document_Number String 20 23 RcpType Receipt Type DDL_Document_Type Integer 0 24 DATE1 Date DT6 Date 6 25 DOCNUMBR Document Number STR20_Document_Number String 20 26 CB_Trans_Amount CB_Trans_Amount CB_DLR19 Currency 19 27 RcvdFrom Received From STR30 String 30 28 CUSTNMBR Customer Number STR15_RM_Customer_Number String 15 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'].CUSTNMBR29 BANKNAME Bank Name STR30 String 30 30 BNKBRNCH Bank Branch STR20 String 20 31 CURNCYID Currency ID STR15_Currency_ID String 15 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'].CURNCYID32 CB_Check_Deposit CB_Check_Deposit CB_Check_Deposit Boolean 0