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 TypeSQL DB LengthKeyable Length
1AUDITTRAIL SearchAudit Trail CodeSTR13_LBAUString1413
2GLPOSTDT SearchGL Posting DateDTDate48
3BCHSOURC SearchBatch SourceSTR15String1615
4BACHNUMB SearchBatch NumberSTR15_LBAUString1615
5BATCHTYPEINT SearchBatch Type IntINT1Integer21
6SERIES SearchSeriesDDL_SeriesInteger20
7MKDTOPST SearchMarked To PostCBBoolean20
8NUMOFTRX SearchNumber Of TRXLI6_U0Long Integer46
9RECPSTGS SearchRecurring PostingsINT3_U0Integer23
10DELBACH SearchDelete BatchYNBoolean20
11MSCBDINC SearchMisc Batch Days To IncrementINT3_U0Integer23
12BACHFREQ SearchBatch FrequencyDDL_FrequencyInteger20
13RCLPSTDT SearchRecurring Last Posted DateDTDate48
14NOFPSTGS SearchNumber of PostingsINT3_S0Integer23
15BCHCOMNT SearchBatch CommentSTR60String6260
16BRKDNALL SearchBreak Down AllocCB_Break_Down_AllocBoolean20
17CHKSPRTD SearchChecks PrintedTrue/FalseBoolean20
18RVRSBACH SearchReverse BatchCBBoolean20
19USERID SearchUser IDSTR15_User_IDString1615
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_IDString1615
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$Currency1019
22BCHEMSG1 SearchBatch Error Messages 1ML_Batch_Error_Messages_1Long Integer40
23BCHEMSG2 SearchBatch Error Messages 2ML_Batch_Error_Messages_2Long Integer40
24BACHDATE SearchBatch DateDTDate48
25BCHSTRG1 SearchBatch String 1STR20String2220
26BCHSTRG2 SearchBatch String 2STR20String2220
27POSTTOGL SearchPost To GLCBBoolean20
28MODIFDT SearchModified DateDTDate48
29CREATDDT SearchCreated DateDTDate48
30NOTEINDX SearchNote IndexDLR14Currency1014
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_IDString1615
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 StatusINTInteger20
33CNTRLTRX SearchControl TRX CountLI6_U0Long Integer46
34CNTRLTOT SearchControl TotalDLR19_RBS0_UTR$Currency1019
35PETRXCNT SearchPosting Error TRX CountINT5_U0Integer25
36APPROVL SearchApprovalCB_ApprovalBoolean20
37APPRVLDT SearchApproval DateDATEDate46
38APRVLUSERID SearchApproval User IDSTR15_User_IDString1615
39ORIGIN SearchOriginDDLInteger20
40ERRSTATE SearchError StateLong IntLong Integer48
41GLBCHVAL SearchGL Batch ValidML_GL_Batch_ValidLong Integer40
42Computer_Check_Doc_Date SearchComputer Check Document DateDTDate48
43Sort_Checks_By SearchSort Checks ByINTInteger20
44SEPRMTNC SearchSeperate RemittanceCB_Seperate_RemittanceBoolean20
45REPRNTED SearchReprintedINT2Integer22
46CHKFRMTS SearchCheck FormatsDDL_Check_FormatsInteger20
47TRXSORCE SearchTRX SourceSTR13String1413
48PmtMethod SearchPayment MethodGBInteger20
49EFTFileFormat SearchEFT File FormatDDL_EFTFileFormatInteger20

Leave a Reply

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