Import Deposit Match (CBDEP003)

azurecurveProductsCashbook (1058)FinancialImport Deposit Match (CBDEP003)

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

Product: Cashbook (1058)
Series: Financial

Display Name: Import Deposit Match
Physical Name: CBDEP003
Technical Name: CB_Import_Deposit_Match

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['Import Deposit Match'].TAXSCHID AS 'Import Deposit Match-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       CBDEP003 AS ['Import Deposit Match']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Import Deposit Match'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
2CB_Exc_Inc_DDL SearchCB_Exc_Inc_DDLCB_Exclusive_Inclusive_Drop_Down_ListInteger20
3CB_Checkbook_Currency SearchCB_Checkbook_CurrencySTR15_Currency_IDString1615
4CB_Deposit_Import_Name SearchCB_Deposit_Import_NameSTR15_LBUString1615
5CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['Import Deposit Match'].CHEKBKID AS 'Import Deposit Match-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       CBDEP003 AS ['Import Deposit Match']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['Import Deposit Match'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
6CB_Checkbook_ID_File SearchCB_Checkbook_ID_FileSTR30String3230
7CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Import Deposit Match'].CURNCYID AS 'Import Deposit Match-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       CBDEP003 AS ['Import Deposit Match']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Import Deposit Match'].CURNCYID = ['Currency Setup'].CURNCYID
azurecurveProductsCashbook (1058)FinancialImport Deposit Match (CBDEP003)

Leave a Reply

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