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