Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CB991115
Product: Cashbook (1058)
Series: Financial
Display Name: Payments Report
Physical Name: CB991115
Technical Name: CB_Payments_ReportSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CUSTNAME 
Customer Name STR64_Customer_Name String 64 2 CB_Trans_Option CB_Trans_Option CB_DDL_Option Integer 0 3 payment_method payment method payment mothod Integer 0 4 INTERID Intercompany ID STR5_IC_ID String 5 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['Payments Report'].INTERID AS 'Payments Report-Intercompany ID'
,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
CB991115 AS ['Payments Report']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['Payments Report'].INTERID = ['Company Master'].INTERID5 CB_Audit_Trail CB_Audit_Trail STR15 String 15 6 USERID User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['Payments Report'].USERID AS 'Payments Report-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
CB991115 AS ['Payments Report']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Payments Report'].USERID = ['Users Master'].USERID7 CURRNIDX Currency Index INT3 Integer 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['Payments Report'].CURRNIDX AS 'Payments Report-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
CB991115 AS ['Payments Report']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Payments Report'].CURRNIDX = ['Currency Setup'].CURRNIDX8 CB_Checkbook_Currency_In CB_Checkbook_Currency_Index INT5 Integer 4 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
['Payments Report'].CURNCYID AS 'Payments Report-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
CB991115 AS ['Payments Report']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Payments Report'].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
['Payments Report'].EXGTBLID AS 'Payments Report-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
CB991115 AS ['Payments Report']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['Payments Report'].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
['Payments Report'].RATETPID AS 'Payments Report-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
CB991115 AS ['Payments Report']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['Payments Report'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID25 CB_Type_Description CB_Type_Description STR30 String 30 26 CB_Line_No CB_Line_No STR10 String 10 27 ACTNUMST Account Number String STR128_LBU String 128 28 CB_Exchange_Rate CB_Exchange_Rate DLR14_Exchange_Rate Currency (Variable) 14 29 CB_Rate_Calc_Method CB_Rate_Calc_Method INT Integer 0 30 CB_Check_Total CB_Check_Total DLR19_RBS0_UTR$ Currency 19 31 CB_Functional_Dist CB_Functional_Dist DLR19_RBS0_STR$ Currency 19 32 CB_Functional_Tax CB_Functional_Tax DLR19_RBS0_STR$ Currency 19 33 CB_Check_Dist CB_Check_Dist DLR19_RBS0_STR$ Currency 19 34 CB_Check_Tax CB_Check_Tax DLR19_RBS0_STR$ Currency 19 35 CB_Transaction_Dist CB_Transaction_Dist DLR19_RBS0_STR$ Currency 19 36 CB_Transaction_Tax CB_Transaction_Tax DLR19_RBS0_STR$ Currency 19 37 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
['Payments Report'].TAXSCHID AS 'Payments Report-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
CB991115 AS ['Payments Report']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['Payments Report'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID38 CHEKBKID Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['Payments Report'].CHEKBKID AS 'Payments Report-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
CB991115 AS ['Payments Report']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['Payments Report'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID39 BACHNUMB Batch Number STR15_LBAU String 15