Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CB999004
Product: Cashbook (1058)
Series: Financial
Display Name: History Recon Cheque Header
Physical Name: CB999004
Technical Name: CB_History_Check_HDRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CB_Audit_Trail 
CB_Audit_Trail STR15 String 15 2 CB_Voided CB_Voided Boolean Boolean 0 3 CB_Cancelled_Check CB_Cancelled_Check CB_Canceled_Check Boolean 0 4 CB_Exchange_Rate CB_Exchange_Rate DLR14_Exchange_Rate Currency (Variable) 14 5 CB_Rate_Calc_Method CB_Rate_Calc_Method INT Integer 0 6 CHEKBKID Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['History Recon Cheque Header'].CHEKBKID AS 'History Recon Cheque Header-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
CB999004 AS ['History Recon Cheque Header']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['History Recon Cheque Header'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID7 CURRNIDX Currency Index INT3 Integer 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['History Recon Cheque Header'].CURRNIDX AS 'History Recon Cheque Header-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
CB999004 AS ['History Recon Cheque Header']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['History Recon Cheque Header'].CURRNIDX = ['Currency Setup'].CURRNIDX8 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['History Recon Cheque Header'].CURNCYID AS 'History Recon Cheque Header-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
CB999004 AS ['History Recon Cheque Header']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['History Recon Cheque Header'].CURNCYID = ['Currency Setup'].CURNCYID9 EXCHDATE Exchange Date DT_Date Date 6 10 XCHGRATE Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 11 RATECALC Rate Calc Method INT Integer 0 12 RATETPID Rate Type ID STR15_Rate_Type_ID String 15 Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hide
SELECT
['History Recon Cheque Header'].RATETPID AS 'History Recon Cheque Header-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
CB999004 AS ['History Recon Cheque Header']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['History Recon Cheque Header'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID13 TIME1 Time TM6 Time 6 14 CB_Line_No CB_Line_No STR10 String 10 15 BACHNUMB Batch Number STR15_LBAU String 15 16 CB_Trans_Option CB_Trans_Option CB_DDL_Option Integer 0 17 payment_method payment method payment mothod Integer 0 18 DOCNUMBR Document Number STR20_Document_Number String 20 19 CHEKNMBR Check Number STR20_Document_Number String 20 20 CB_Deposit_Date CB_Deposit_Date DT Date 8 21 CB_Type CB_Type CB_DDL_Type2 Integer 0 22 CB_Payee CB_Payee STR40 String 40 23 VENDORID Vendor ID STR_15_Vendor_ID String 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['History Recon Cheque Header'].VENDORID AS 'History Recon Cheque Header-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
CB999004 AS ['History Recon Cheque Header']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['History Recon Cheque Header'].VENDORID = ['PM Vendor Master File'].VENDORID24 CUSTNAME Customer Name STR64_Customer_Name String 64 25 DSCRIPTN Description STR30 String 30 26 EXGTBLID Exchange Table ID STR15_Exchange_Table_ID String 15 Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hide
SELECT
['History Recon Cheque Header'].EXGTBLID AS 'History Recon Cheque Header-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
CB999004 AS ['History Recon Cheque Header']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['History Recon Cheque Header'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID27 CB_Check_Amount CB_Check_Amount DLR19_RBS0_UTR$ Currency 19 28 CB_Check_Total CB_Check_Total DLR19_RBS0_UTR$ Currency 19