DD Batch Headers (DDEU006)

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_Headers

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

Leave a Reply

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