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