Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/DDEU007
Product: Direct Debits & Refunds (8811)
Series: Company
Display Name: DD Batch Headers History
Physical Name: DDEU007
Technical Name: DD_Batch_Headers_HistorySeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 AUDITTRAIL 
Audit Trail Code STR13_LBAU String 13 2 GLPOSTDT GL Posting Date DT Date 8 3 BCHSOURC Batch Source STR15 String 15 4 BACHNUMB Batch Number STR15_LBAU String 15 5 BATCHTYPEINT Batch Type Int INT1 Integer 1 6 SERIES Series DDL_Series Integer 0 7 MKDTOPST Marked To Post CB Boolean 0 8 NUMOFTRX Number Of TRX LI6_U0 Long Integer 6 9 RECPSTGS Recurring Postings INT3_U0 Integer 3 10 DELBACH Delete Batch YN Boolean 0 11 MSCBDINC Misc Batch Days To Increment INT3_U0 Integer 3 12 BACHFREQ Batch Frequency DDL_Frequency Integer 0 13 RCLPSTDT Recurring Last Posted Date DT Date 8 14 NOFPSTGS Number of Postings INT3_S0 Integer 3 15 BCHCOMNT Batch Comment STR60 String 60 16 BRKDNALL Break Down Alloc CB_Break_Down_Alloc Boolean 0 17 CHKSPRTD Checks Printed True/False Boolean 0 18 RVRSBACH Reverse Batch CB Boolean 0 19 USERID User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['DD Batch Headers History'].USERID AS 'DD Batch Headers History-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
DDEU007 AS ['DD Batch Headers History']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['DD Batch Headers History'].USERID = ['Users Master'].USERID20 CHEKBKID Checkbook ID STR15_Checkbook_ID String 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['DD Batch Headers History'].CHEKBKID AS 'DD Batch Headers History-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
DDEU007 AS ['DD Batch Headers History']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['DD Batch Headers History'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID21 BCHTOTAL Batch Total DLR19_RBS0_STR$ Currency 19 22 BCHEMSG1 Batch Error Messages 1 ML_Batch_Error_Messages_1 Long Integer 0 23 BCHEMSG2 Batch Error Messages 2 ML_Batch_Error_Messages_2 Long Integer 0 24 BACHDATE Batch Date DT Date 8 25 BCHSTRG1 Batch String 1 STR20 String 20 26 BCHSTRG2 Batch String 2 STR20 String 20 27 POSTTOGL Post To GL CB Boolean 0 28 MODIFDT Modified Date DT Date 8 29 CREATDDT Created Date DT Date 8 30 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['DD Batch Headers History'].NOTEINDX AS 'DD Batch Headers History-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
DDEU007 AS ['DD Batch Headers History']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['DD Batch Headers History'].NOTEINDX = ['Record Notes Master'].NOTEINDX31 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['DD Batch Headers History'].CURNCYID AS 'DD Batch Headers History-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
DDEU007 AS ['DD Batch Headers History']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['DD Batch Headers History'].CURNCYID = ['Currency Setup'].CURNCYID32 BCHSTTUS Batch Status INT Integer 0 33 CNTRLTRX Control TRX Count LI6_U0 Long Integer 6 34 CNTRLTOT Control Total DLR19_RBS0_UTR$ Currency 19 35 PETRXCNT Posting Error TRX Count INT5_U0 Integer 5 36 APPROVL Approval CB_Approval Boolean 0 37 APPRVLDT Approval Date DATE Date 6 38 APRVLUSERID Approval User ID STR15_User_ID String 15 39 ORIGIN Origin DDL Integer 0 40 ERRSTATE Error State Long Int Long Integer 8 41 GLBCHVAL GL Batch Valid ML_GL_Batch_Valid Long Integer 0 42 Computer_Check_Doc_Date Computer Check Document Date DT Date 8 43 Sort_Checks_By Sort Checks By INT Integer 0 44 SEPRMTNC Seperate Remittance CB_Seperate_Remittance Boolean 0 45 REPRNTED Reprinted INT2 Integer 2 46 CHKFRMTS Check Formats DDL_Check_Formats Integer 0 47 TRXSORCE TRX Source STR13 String 13 48 PmtMethod Payment Method GB Integer 0 49 EFTFileFormat EFT File Format DDL_EFTFileFormat Integer 0