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_BuildBatchSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 BACHNUMB 
Batch Number STR15_LBAU String 15 2 BATTYPE Batch Type GB Integer 0 3 DOCNUMBR Document Number STR20_Document_Number String 20 4 DOCTYPE Document Type DDL_Document_Type Integer 0 5 CUSTNMBR Customer Number STR15_RM_Customer_Number String 15 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'].CUSTNMBR6 PAYMENT_AMOUNT Payment Amount DLR19_RBSO_UTR$ Currency 19 7 OriginatingPaymentAmt OriginatingPaymentAmt DLR19_RBSO_UTR$ Currency 19 8 DISTKNAM Discount Taken Amount DLR17_RBS0_UTR$ Currency 17 9 ORDISTKN Originating Discount Taken Amount DLR17_RBS0_UTR$ Currency 17 10 DDWRIPER1 DD_PymntPer INT1 Integer 1 11 IsApplied IsApplied Boolean Boolean 0 12 ApplyDate ApplyDate DT6 Date 6 13 NonQualifyingDiscounts Non Qualifying Discounts CB_Non_Qualifying_Discounts Boolean 0 14 MARKED Marked Boolean Boolean 0 15 XCHGRATE Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 16 EXCHDATE Exchange Date DT_Date Date 6 17 EXGTBLID Exchange Table ID STR15_Exchange_Table_ID String 15 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'].EXGTBLID18 RATECALC Rate Calc Method INT Integer 0 19 RATETPID Rate Type ID STR15_Rate_Type_ID String 15 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'].RATETPID20 TIME1 Time TM6 Time 6 21 EXPNDATE Expiration Date DT_Date Date 6 22 DENXRATE Denomination Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 23 MCTRXSTT MC Transaction State INT1 Integer 1