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_MatchSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 TAXSCHID 
Tax Schedule ID STR15_Tax_Schedule_ID String 15 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'].TAXSCHID2 CB_Exc_Inc_DDL CB_Exc_Inc_DDL CB_Exclusive_Inclusive_Drop_Down_List Integer 0 3 CB_Checkbook_Currency CB_Checkbook_Currency STR15_Currency_ID String 15 4 CB_Deposit_Import_Name CB_Deposit_Import_Name STR15_LBU String 15 5 CHEKBKID Checkbook ID STR15_Checkbook_ID String 15 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'].CHEKBKID6 CB_Checkbook_ID_File CB_Checkbook_ID_File STR30 String 30 7 CURNCYID Currency ID STR15_Currency_ID String 15 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