Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CB900037
Product: Cashbook (1058)
Series: Financial
Display Name: Check Recurring
Physical Name: CB900037
Technical Name: CB_Check_RecurringSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 EXPNDATE 
Expiration Date DT_Date Date 6 2 CB_Exchange_Rate CB_Exchange_Rate DLR14_Exchange_Rate Currency (Variable) 14 3 CB_Rate_Calc_Method CB_Rate_Calc_Method INT Integer 0 4 CB_Cancelled_Check CB_Cancelled_Check CB_Canceled_Check Boolean 0 5 CHEKBKID Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['Check Recurring'].CHEKBKID AS 'Check Recurring-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
CB900037 AS ['Check Recurring']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['Check Recurring'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID6 CURRNIDX Currency Index INT3 Integer 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['Check Recurring'].CURRNIDX AS 'Check Recurring-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
CB900037 AS ['Check Recurring']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Check Recurring'].CURRNIDX = ['Currency Setup'].CURRNIDX7 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['Check Recurring'].CURNCYID AS 'Check Recurring-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
CB900037 AS ['Check Recurring']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Check Recurring'].CURNCYID = ['Currency Setup'].CURNCYID8 EXCHDATE Exchange Date DT_Date Date 6 9 XCHGRATE Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 10 RATECALC Rate Calc Method INT Integer 0 11 RATETPID Rate Type ID STR15_Rate_Type_ID String 15 Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hide
SELECT
['Check Recurring'].RATETPID AS 'Check Recurring-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
CB900037 AS ['Check Recurring']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['Check Recurring'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID12 TIME1 Time TM6 Time 6 13 CB_Line_No CB_Line_No STR10 String 10 14 BACHNUMB Batch Number STR15_LBAU String 15 15 CB_Trans_Option CB_Trans_Option CB_DDL_Option Integer 0 16 payment_method payment method payment mothod Integer 0 17 DOCNUMBR Document Number STR20_Document_Number String 20 18 CHEKNMBR Check Number STR20_Document_Number String 20 19 CB_Deposit_Date CB_Deposit_Date DT Date 8 20 CB_Type CB_Type CB_DDL_Type2 Integer 0 21 CB_Payee CB_Payee STR40 String 40 22 VENDORID Vendor ID STR_15_Vendor_ID String 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['Check Recurring'].VENDORID AS 'Check Recurring-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
CB900037 AS ['Check Recurring']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['Check Recurring'].VENDORID = ['PM Vendor Master File'].VENDORID23 CUSTNAME Customer Name STR64_Customer_Name String 64 24 DSCRIPTN Description STR30 String 30 25 EXGTBLID Exchange Table ID STR15_Exchange_Table_ID String 15 Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hide
SELECT
['Check Recurring'].EXGTBLID AS 'Check Recurring-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
CB900037 AS ['Check Recurring']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['Check Recurring'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID26 CB_Check_Amount CB_Check_Amount DLR19_RBS0_UTR$ Currency 19 27 CB_Check_Total CB_Check_Total DLR19_RBS0_UTR$ Currency 19 28 CB_Trans_Amount CB_Trans_Amount CB_DLR19 Currency 19 29 CB_Use_Current CB_Use_Current CB Boolean 0 30 CB_Exc_Inc CB_Exc_Inc DDL Integer 0 31 CB_Type_Description CB_Type_Description STR30 String 30 32 Vat_Amount Vat_Amount DLR19_RBS0_UTR$ Currency 19 33 ACTNUMBR_1 Account Number:Account_Segment_Pool1 Account_Segment_Pool1 String 6 34 ACTNUMBR_2 Account Number:Account_Segment_Pool2 Account_Segment_Pool2 String 6 35 ACTNUMBR_3 Account Number:Account_Segment_Pool3 Account_Segment_Pool3 String 6 36 ACTNUMBR_4 Account Number:Account_Segment_Pool4 Account_Segment_Pool4 String 6 37 ACTNUMBR_5 Account Number:Account_Segment_Pool5 Account_Segment_Pool5 String 6 38 ACTNUMBR_6 Account Number:Account_Segment_Pool6 Account_Segment_Pool6 String 6 39 ACTNUMBR_7 Account Number:Account_Segment_Pool7 Account_Segment_Pool7 String 6 40 ACTNUMBR_8 Account Number:Account_Segment_Pool8 Account_Segment_Pool8 String 6 41 ACTNUMBR_9 Account Number:Account_Segment_Pool9 Account_Segment_Pool9 String 6 42 ACTNUMBR_10 Account Number:Account_Segment_Pool10 Account_Segment_Pool10 String 6 43 ACTINDX Account Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Check Recurring'].ACTINDX AS 'Check Recurring-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
CB900037 AS ['Check Recurring']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Check Recurring'].ACTINDX = ['Account Index Master'].ACTINDX44 TAXDTLID Tax Detail ID STR15_Tax_Detail_ID String 15 Key to the Sales/Purchases Tax Master (TX00201).
Click to show/hide
SELECT
['Check Recurring'].TAXDTLID AS 'Check Recurring-Tax Detail ID'
,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
CB900037 AS ['Check Recurring']
INNER JOIN
TX00201 AS ['Sales/Purchases Tax Master']
ON
['Check Recurring'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID45 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
['Check Recurring'].TAXSCHID AS 'Check Recurring-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
CB900037 AS ['Check Recurring']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['Check Recurring'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID46 CB_Vat_Account_Index CB_Vat_Account_Index LI_14 Long Integer 14 47 CB_Vat_Account_Number_1 CB_Vat_Account_Number:Account_Segment_Pool1 Account_Segment_Pool1 String 6 48 CB_Vat_Account_Number_2 CB_Vat_Account_Number:Account_Segment_Pool2 Account_Segment_Pool2 String 6 49 CB_Vat_Account_Number_3 CB_Vat_Account_Number:Account_Segment_Pool3 Account_Segment_Pool3 String 6 50 CB_Vat_Account_Number_4 CB_Vat_Account_Number:Account_Segment_Pool4 Account_Segment_Pool4 String 6 51 CB_Vat_Account_Number_5 CB_Vat_Account_Number:Account_Segment_Pool5 Account_Segment_Pool5 String 6 52 CB_Vat_Account_Number_6 CB_Vat_Account_Number:Account_Segment_Pool6 Account_Segment_Pool6 String 6 53 CB_Vat_Account_Number_7 CB_Vat_Account_Number:Account_Segment_Pool7 Account_Segment_Pool7 String 6 54 CB_Vat_Account_Number_8 CB_Vat_Account_Number:Account_Segment_Pool8 Account_Segment_Pool8 String 6 55 CB_Vat_Account_Number_9 CB_Vat_Account_Number:Account_Segment_Pool9 Account_Segment_Pool9 String 6 56 CB_Vat_Account_Number_10 CB_Vat_Account_Number:Account_Segment_Pool10 Account_Segment_Pool10 String 6 57 INTERID Intercompany ID STR5_IC_ID String 5 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['Check Recurring'].INTERID AS 'Check Recurring-Intercompany ID'
,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
CB900037 AS ['Check Recurring']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['Check Recurring'].INTERID = ['Company Master'].INTERID58 CMPANYID Company ID INT5 Integer 4 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['Check Recurring'].CMPANYID AS 'Check Recurring-Company ID'
,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
CB900037 AS ['Check Recurring']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['Check Recurring'].CMPANYID = ['Company Master'].CMPANYID