DD Transaction Rollback (DDEU019)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/DDEU019

Product: Direct Debits & Refunds (8811)
Series: Sales

Display Name: DD Transaction Rollback
Physical Name: DDEU019
Technical Name: DD_Trx_Rollback

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1AUDITTRAIL SearchAudit Trail CodeSTR13_LBAUString1413
2USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['DD Transaction Rollback'].USERID AS 'DD Transaction Rollback-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       DDEU019 AS ['DD Transaction Rollback']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['DD Transaction Rollback'].USERID = ['Users Master'].USERID
3BACHNUMB SearchBatch NumberSTR15_LBAUString1615
4CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['DD Transaction Rollback'].CUSTNMBR AS 'DD Transaction Rollback-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       DDEU019 AS ['DD Transaction Rollback']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['DD Transaction Rollback'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
5DOCNUMBR SearchDocument NumberSTR20_Document_NumberString2220
6GLBCHNBR SearchGL Batch NumberSTR15_LBAUString1615
7RMDOCNUM SearchRM Document NumberSTR20_Document_NumberString2220
8ROLLTYPE SearchRollback TypeINT1Integer21
9DDSTEPDO SearchDD_Steps_DoneINT2Integer22
10DATE1 SearchDateDT6Date46
11DOCAMNT SearchDocument AmountDLR19_RBSO_UTR$Currency1019
12DDCRAPAM SearchDD_Cr_Apply_AmountDLR19_$S2Currency1019
13DDDRAPAM SearchDD_Dr_Apply_AmountDLR19_$S2Currency1019
14DDMCRAAM SearchDD_MC_Cr_Apply_AmountDLR19_$S2Currency1019
15DDMDAPAM SearchDD_MC_Dr_Apply_AmountDLR19_$S2Currency1019
16CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
Key to the CM Checkbook Master (CM00100).

Click to show/hide

SELECT
       ['DD Transaction Rollback'].CHEKBKID AS 'DD Transaction Rollback-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       DDEU019 AS ['DD Transaction Rollback']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['DD Transaction Rollback'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
17CB_Recon_Trans_Type SearchCB_Recon_Trans_TypeINTInteger20
18CBDOCNUM SearchCB_Document_NumberSTR20_Document_NumberString2220
19CMRECNUM SearchRecord NumberDLR_Document_NumberCurrency1019
20EFTType SearchEFT TypeDDL_EFTTypeInteger20
21EFTDOCNU SearchEFT_Document_ NumberSTR20_Document_NumberString2220
22DOCTYPE SearchDocument TypeDDL_Document_TypeInteger20
23DDRMDOTY SearchDD_RM_Document_TypeDDL_Document_TypeInteger20
24JRNENTRY SearchJournal EntryLI8_U0Long Integer48
25DDRMSUPA SearchDD_RM_SUM_Pay_AmountDLR19_$S2Currency1019
26DDRMSUDA SearchDD_RM_SUM_Pay_DateDATEDate46
27DISCAMNT SearchDiscount AmountDLR17_RBS0_STR$Currency1017
28ORDISTKN SearchOriginating Discount Taken AmountDLR17_RBS0_UTR$Currency1017
29DISAMTAV SearchDiscount Amount AvailableDLR17_RBS0_UTR$Currency1017
30WROFAMNT SearchWrite Off AmountDLR17_RBS0_STR$Currency1017
31DDAPTXSO SearchDD_Apply_Trx_SourceSTR13String1413
32CHEKAMNT SearchCheck AmountDLR19_RBS0_UTR$Currency1019

Leave a Reply

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