DD Batch Headers History (DDEU007)

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_History

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1AUDITTRAIL SearchAudit Trail CodeSTR13_LBAUString13
2GLPOSTDT SearchGL Posting DateDTDate8
3BCHSOURC SearchBatch SourceSTR15String15
4BACHNUMB SearchBatch NumberSTR15_LBAUString15
5BATCHTYPEINT SearchBatch Type IntINT1Integer1
6SERIES SearchSeriesDDL_SeriesInteger0
7MKDTOPST SearchMarked To PostCBBoolean0
8NUMOFTRX SearchNumber Of TRXLI6_U0Long Integer6
9RECPSTGS SearchRecurring PostingsINT3_U0Integer3
10DELBACH SearchDelete BatchYNBoolean0
11MSCBDINC SearchMisc Batch Days To IncrementINT3_U0Integer3
12BACHFREQ SearchBatch FrequencyDDL_FrequencyInteger0
13RCLPSTDT SearchRecurring Last Posted DateDTDate8
14NOFPSTGS SearchNumber of PostingsINT3_S0Integer3
15BCHCOMNT SearchBatch CommentSTR60String60
16BRKDNALL SearchBreak Down AllocCB_Break_Down_AllocBoolean0
17CHKSPRTD SearchChecks PrintedTrue/FalseBoolean0
18RVRSBACH SearchReverse BatchCBBoolean0
19USERID SearchUser IDSTR15_User_IDString15
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'].USERID
20CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString15
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'].CHEKBKID
21BCHTOTAL SearchBatch TotalDLR19_RBS0_STR$Currency19
22BCHEMSG1 SearchBatch Error Messages 1ML_Batch_Error_Messages_1Long Integer0
23BCHEMSG2 SearchBatch Error Messages 2ML_Batch_Error_Messages_2Long Integer0
24BACHDATE SearchBatch DateDTDate8
25BCHSTRG1 SearchBatch String 1STR20String20
26BCHSTRG2 SearchBatch String 2STR20String20
27POSTTOGL SearchPost To GLCBBoolean0
28MODIFDT SearchModified DateDTDate8
29CREATDDT SearchCreated DateDTDate8
30NOTEINDX SearchNote IndexDLR14Currency14
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'].NOTEINDX
31CURNCYID SearchCurrency IDSTR15_Currency_IDString15
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'].CURNCYID
32BCHSTTUS SearchBatch StatusINTInteger0
33CNTRLTRX SearchControl TRX CountLI6_U0Long Integer6
34CNTRLTOT SearchControl TotalDLR19_RBS0_UTR$Currency19
35PETRXCNT SearchPosting Error TRX CountINT5_U0Integer5
36APPROVL SearchApprovalCB_ApprovalBoolean0
37APPRVLDT SearchApproval DateDATEDate6
38APRVLUSERID SearchApproval User IDSTR15_User_IDString15
39ORIGIN SearchOriginDDLInteger0
40ERRSTATE SearchError StateLong IntLong Integer8
41GLBCHVAL SearchGL Batch ValidML_GL_Batch_ValidLong Integer0
42Computer_Check_Doc_Date SearchComputer Check Document DateDTDate8
43Sort_Checks_By SearchSort Checks ByINTInteger0
44SEPRMTNC SearchSeperate RemittanceCB_Seperate_RemittanceBoolean0
45REPRNTED SearchReprintedINT2Integer2
46CHKFRMTS SearchCheck FormatsDDL_Check_FormatsInteger0
47TRXSORCE SearchTRX SourceSTR13String13
48PmtMethod SearchPayment MethodGBInteger0
49EFTFileFormat SearchEFT File FormatDDL_EFTFileFormatInteger0

Leave a Reply

Your email address will not be published. Required fields are marked *