Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CB770006
Product: Cashbook (1058)
Series: Financial
Display Name: History Recon Batch Header
Physical Name: CB770006
Technical Name: CB_History_Batch_HDRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CB_Currency_Index1 
CB_Currency_Index1 INT3 Integer 3 2 CB_Able_To_Post CB_Able_To_Post Boolean Boolean 0 3 Batch_Pay_Vat_Total Batch Pay Vat Total DLR19_RBSO_STR$ Currency 19 4 Batch_Rec_Vat_Total Batch Rec Vat Total DLR19_RBSO_STR$ Currency 19 5 Batch_Payables_Total Batch Payables Total DLR19_RBSO_STR$ Currency 19 6 Batch_Receivables_Total Batch Receivables Total DLR19_RBSO_STR$ Currency 19 7 CURRNIDX Currency Index INT3 Integer 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['History Recon Batch Header'].CURRNIDX AS 'History Recon Batch Header-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
CB770006 AS ['History Recon Batch Header']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['History Recon Batch 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 Batch Header'].CURNCYID AS 'History Recon Batch Header-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
CB770006 AS ['History Recon Batch Header']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['History Recon Batch Header'].CURNCYID = ['Currency Setup'].CURNCYID9 CB_Checkbook_Currency CB_Checkbook_Currency STR15_Currency_ID String 15 10 Batch_Vat_Total Batch Vat Total CB_Amount Currency 0 11 ORIGIN Origin DDL Integer 0 12 BCHTOTAL Batch Total DLR19_RBS0_STR$ Currency 19 13 BACHFREQ Batch Frequency DDL_Frequency Integer 0 14 BCHSOURC Batch Source STR15 String 15 15 BCHCOMNT Batch Comment STR60 String 60 16 BACHNUMB Batch Number STR15_LBAU String 15 17 CHEKBKID Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['History Recon Batch Header'].CHEKBKID AS 'History Recon Batch Header-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
CB770006 AS ['History Recon Batch Header']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['History Recon Batch Header'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID18 CB_Cash_Account_Index CB_Cash_Account_Index LI_14 Long Integer 14 19 ACTNUMBR_1 Account Number:Account_Segment_Pool1 Account_Segment_Pool1 String 6 20 ACTNUMBR_2 Account Number:Account_Segment_Pool2 Account_Segment_Pool2 String 6 21 ACTNUMBR_3 Account Number:Account_Segment_Pool3 Account_Segment_Pool3 String 6 22 ACTNUMBR_4 Account Number:Account_Segment_Pool4 Account_Segment_Pool4 String 6 23 ACTNUMBR_5 Account Number:Account_Segment_Pool5 Account_Segment_Pool5 String 6 24 ACTNUMBR_6 Account Number:Account_Segment_Pool6 Account_Segment_Pool6 String 6 25 ACTNUMBR_7 Account Number:Account_Segment_Pool7 Account_Segment_Pool7 String 6 26 ACTNUMBR_8 Account Number:Account_Segment_Pool8 Account_Segment_Pool8 String 6 27 ACTNUMBR_9 Account Number:Account_Segment_Pool9 Account_Segment_Pool9 String 6 28 ACTNUMBR_10 Account Number:Account_Segment_Pool10 Account_Segment_Pool10 String 6 29 BCHSTTUS Batch Status INT Integer 0 30 Batch_Record_Number Batch Record Number INT Integer 0 31 BACHDATE Batch Date DT Date 8 32 RECPSTGS Recurring Postings INT3_U0 Integer 3 33 MSCBDINC Misc Batch Days To Increment INT3_U0 Integer 3 34 RCLPSTDT Recurring Last Posted Date DT Date 8 35 NOFPSTGS Number of Postings INT3_S0 Integer 3 36 CB_Print_Cheque_Batch CB_Print_Cheque_Batch CB Boolean 0 37 CB_Batch_Printed CB_Batch_Printed boolean Boolean 0