DD_BuildBatch (DDEU018)

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

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

Display Name: DD_BuildBatch
Physical Name: DDEU018
Technical Name: DD_BuildBatch

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1BACHNUMB SearchBatch NumberSTR15_LBAUString15
2BATTYPE SearchBatch TypeGBInteger0
3DOCNUMBR SearchDocument NumberSTR20_Document_NumberString20
4DOCTYPE SearchDocument TypeDDL_Document_TypeInteger0
5CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['DD_BuildBatch'].CUSTNMBR AS 'DD_BuildBatch-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       DDEU018 AS ['DD_BuildBatch']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['DD_BuildBatch'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
6PAYMENT_AMOUNT SearchPayment AmountDLR19_RBSO_UTR$Currency19
7OriginatingPaymentAmt SearchOriginatingPaymentAmtDLR19_RBSO_UTR$Currency19
8DISTKNAM SearchDiscount Taken AmountDLR17_RBS0_UTR$Currency17
9ORDISTKN SearchOriginating Discount Taken AmountDLR17_RBS0_UTR$Currency17
10DDWRIPER1 SearchDD_PymntPerINT1Integer1
11IsApplied SearchIsAppliedBooleanBoolean0
12ApplyDate SearchApplyDateDT6Date6
13NonQualifyingDiscounts SearchNon Qualifying DiscountsCB_Non_Qualifying_DiscountsBoolean0
14MARKED SearchMarkedBooleanBoolean0
15XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)14
16EXCHDATE SearchExchange DateDT_DateDate6
17EXGTBLID SearchExchange Table IDSTR15_Exchange_Table_IDString15
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['DD_BuildBatch'].EXGTBLID AS 'DD_BuildBatch-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       DDEU018 AS ['DD_BuildBatch']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['DD_BuildBatch'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
18RATECALC SearchRate Calc MethodINTInteger0
19RATETPID SearchRate Type IDSTR15_Rate_Type_IDString15
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['DD_BuildBatch'].RATETPID AS 'DD_BuildBatch-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       DDEU018 AS ['DD_BuildBatch']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['DD_BuildBatch'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
20TIME1 SearchTimeTM6Time6
21EXPNDATE SearchExpiration DateDT_DateDate6
22DENXRATE SearchDenomination Exchange RateDLR14_Exchange_RateCurrency (Variable)14
23MCTRXSTT SearchMC Transaction StateINT1Integer1

Leave a Reply

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