Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CB990114
Product: Cashbook (1058)
Series: Financial
Display Name: MC Deposit Report table
Physical Name: CB990114
Technical Name: CB_Deposit_ReportSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CUSTNAME 
Customer Name STR64_Customer_Name String 64 2 INTERID Intercompany ID STR5_IC_ID String 5 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['MC Deposit Report table'].INTERID AS 'MC Deposit Report table-Intercompany ID'
,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
CB990114 AS ['MC Deposit Report table']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['MC Deposit Report table'].INTERID = ['Company Master'].INTERID3 CB_Audit_Trail CB_Audit_Trail STR15 String 15 4 USERID User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['MC Deposit Report table'].USERID AS 'MC Deposit Report table-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
CB990114 AS ['MC Deposit Report table']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['MC Deposit Report table'].USERID = ['Users Master'].USERID5 CURRNIDX Currency Index INT3 Integer 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['MC Deposit Report table'].CURRNIDX AS 'MC Deposit Report table-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
CB990114 AS ['MC Deposit Report table']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['MC Deposit Report table'].CURRNIDX = ['Currency Setup'].CURRNIDX6 CB_Checkbook_Currency_In CB_Checkbook_Currency_Index INT5 Integer 4 7 depositnumber Deposit Number STR20_Document_Number String 20 8 CB_Ref_No CB_Ref_No CB_STR15NoNegative String 15 9 BCHTOTAL Batch Total DLR19_RBS0_STR$ Currency 19 10 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['MC Deposit Report table'].CURNCYID AS 'MC Deposit Report table-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
CB990114 AS ['MC Deposit Report table']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['MC Deposit Report table'].CURNCYID = ['Currency Setup'].CURNCYID11 CB_Checkbook_Currency CB_Checkbook_Currency STR15_Currency_ID String 15 12 BACHDATE Batch Date DT Date 8 13 BCHCOMNT Batch Comment STR60 String 60 14 RATECALC Rate Calc Method INT Integer 0 15 CB_Cancelled_Check CB_Cancelled_Check CB_Canceled_Check Boolean 0 16 CHEKNMBR Check Number STR20_Document_Number String 20 17 CB_Type CB_Type CB_DDL_Type2 Integer 0 18 CB_Payee CB_Payee STR40 String 40 19 DSCRIPTN Description STR30 String 30 20 DATE1 Date DT6 Date 6 21 EXCHDATE Exchange Date DT_Date Date 6 22 EXGTBLID Exchange Table ID STR15_Exchange_Table_ID String 15 Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hide
SELECT
['MC Deposit Report table'].EXGTBLID AS 'MC Deposit Report table-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
CB990114 AS ['MC Deposit Report table']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['MC Deposit Report table'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID23 XCHGRATE Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 24 RATETPID Rate Type ID STR15_Rate_Type_ID String 15 Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hide
SELECT
['MC Deposit Report table'].RATETPID AS 'MC Deposit Report table-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
CB990114 AS ['MC Deposit Report table']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['MC Deposit Report table'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID25 CB_Type_Description CB_Type_Description STR30 String 30 26 ACTNUMST Account Number String STR128_LBU String 128 27 CB_Exchange_Rate CB_Exchange_Rate DLR14_Exchange_Rate Currency (Variable) 14 28 CB_Rate_Calc_Method CB_Rate_Calc_Method INT Integer 0 29 CB_Deposit_Total CB_Deposit_Total DLR19_RBS0_STR$ Currency 19 30 CB_Functional_Dist CB_Functional_Dist DLR19_RBS0_STR$ Currency 19 31 CB_Functional_Tax CB_Functional_Tax DLR19_RBS0_STR$ Currency 19 32 CB_Check_Dist CB_Check_Dist DLR19_RBS0_STR$ Currency 19 33 CB_Check_Tax CB_Check_Tax DLR19_RBS0_STR$ Currency 19 34 CB_Transaction_Dist CB_Transaction_Dist DLR19_RBS0_STR$ Currency 19 35 CB_Transaction_Tax CB_Transaction_Tax DLR19_RBS0_STR$ Currency 19 36 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
['MC Deposit Report table'].TAXSCHID AS 'MC Deposit Report table-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
CB990114 AS ['MC Deposit Report table']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['MC Deposit Report table'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID37 CHEKBKID Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['MC Deposit Report table'].CHEKBKID AS 'MC Deposit Report table-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
CB990114 AS ['MC Deposit Report table']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['MC Deposit Report table'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID38 BACHNUMB Batch Number STR15_LBAU String 15