Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CB900058
Product: Cashbook (1058)
Series: Financial
Display Name: Lockbox Holding
Physical Name: CB900058
Technical Name: CB_Lockbox_HoldingSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CB_Posting 
CB_Posting boolean Boolean 0 2 RMDTYPAL RM Document Type-All INT2 Integer 2 Document Type records the type of document.
Click to show/hide the Document Types
0 Balance Carried Forward
1 Sales / Invoice
2 Scheduled Payments
3 Debit Memo
4 Finance Charge
5 Service Repairs
6 Warranties
7 Credit Memo
8 Returns
9 Payments3 BACHNUMB Batch Number STR15_LBAU String 15 4 CB_User_ID CB_User_ID STR15_User_ID String 15 5 CB_Sales_Type CB_Sales_Type INT1 Integer 1 6 CB_Sales_Number CB_Sales_Number STR30 String 30 7 CB_Type_Enquiry CB_Type_Enquiry INT2 Integer 2 8 DSCRIPTN Description STR30 String 30 9 CUSTNAME Customer Name STR64_Customer_Name String 64 10 CHEKBKID Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['Lockbox Holding'].CHEKBKID AS 'Lockbox Holding-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
CB900058 AS ['Lockbox Holding']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['Lockbox Holding'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID11 CHEKNMBR Check Number STR20_Document_Number String 20 12 RcpType Receipt Type DDL_Document_Type Integer 0 13 DATE1 Date DT6 Date 6 14 DOCNUMBR Document Number STR20_Document_Number String 20 15 CB_Trans_Amount CB_Trans_Amount CB_DLR19 Currency 19 16 RcvdFrom Received From STR30 String 30 17 CUSTNMBR Customer Number STR15_RM_Customer_Number String 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['Lockbox Holding'].CUSTNMBR AS 'Lockbox Holding-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
CB900058 AS ['Lockbox Holding']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['Lockbox Holding'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR18 BANKNAME Bank Name STR30 String 30 19 BNKBRNCH Bank Branch STR20 String 20 20 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['Lockbox Holding'].CURNCYID AS 'Lockbox Holding-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
CB900058 AS ['Lockbox Holding']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Lockbox Holding'].CURNCYID = ['Currency Setup'].CURNCYID21 CB_Check_Deposit CB_Check_Deposit CB_Check_Deposit Boolean 0