Lockbox Holding (CB900058)

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_Holding

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1CB_Posting SearchCB_PostingbooleanBoolean20
2RMDTYPAL SearchRM Document Type-AllINT2Integer22
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	Payments
3BACHNUMB SearchBatch NumberSTR15_LBAUString1615
4CB_User_ID SearchCB_User_IDSTR15_User_IDString1615
5CB_Sales_Type SearchCB_Sales_TypeINT1Integer21
6CB_Sales_Number SearchCB_Sales_NumberSTR30String3230
7CB_Type_Enquiry SearchCB_Type_EnquiryINT2Integer22
8DSCRIPTN SearchDescriptionSTR30String3230
9CUSTNAME SearchCustomer NameSTR64_Customer_NameString6664
10CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
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'].CHEKBKID
11CHEKNMBR SearchCheck NumberSTR20_Document_NumberString2220
12RcpType SearchReceipt TypeDDL_Document_TypeInteger20
13DATE1 SearchDateDT6Date46
14DOCNUMBR SearchDocument NumberSTR20_Document_NumberString2220
15CB_Trans_Amount SearchCB_Trans_AmountCB_DLR19Currency1019
16RcvdFrom SearchReceived FromSTR30String3230
17CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
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'].CUSTNMBR
18BANKNAME SearchBank NameSTR30String3230
19BNKBRNCH SearchBank BranchSTR20String2220
20CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
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'].CURNCYID
21CB_Check_Deposit SearchCB_Check_DepositCB_Check_DepositBoolean20

Leave a Reply

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