Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/DDEU020
Product: Direct Debits & Refunds (8811)
Series: Sales
Display Name: RM Open DUPE File
Physical Name: DDEU020
Technical Name: DD_RM_OPEN_DUPESeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CUSTNMBR 
Customer Number STR15_RM_Customer_Number String 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['RM Open DUPE File'].CUSTNMBR AS 'RM Open DUPE File-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
DDEU020 AS ['RM Open DUPE File']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['RM Open DUPE File'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR2 CPRCSTNM Corporate Customer Number STR15_RM_Customer_Number String 15 3 DOCNUMBR Document Number STR20_Document_Number String 20 4 CHEKNMBR Check Number STR20_Document_Number String 20 5 BACHNUMB Batch Number STR15_LBAU String 15 6 BCHSOURC Batch Source STR15 String 15 7 TRXSORCE TRX Source STR13 String 13 8 RMDTYPAL RM Document Type-All INT2 Integer 2 Document Type records the type of document.
Click to show/hide the Document Types
0 Balance Carried Forward
1 Sales / Invoice
2 Scheduled Payments
3 Debit Memo
4 Finance Charge
5 Service Repairs
6 Warranties
7 Credit Memo
8 Returns
9 Payments9 CSHRCTYP Cash Receipt Type GB Integer 0 10 CBKIDCRD Checkbook ID Credit Card STR15_Checkbook_ID String 15 11 CBKIDCSH Checkbook ID Cash STR15_Checkbook_ID String 15 12 CBKIDCHK Checkbook ID Check STR15_Checkbook_ID String 15 13 DUEDATE Due Date DT Date 8 14 DOCDATE Document Date DT Date 8 15 POSTDATE Post Date DT_Date Date 6 16 PSTUSRID Post User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['RM Open DUPE File'].PSTUSRID AS 'RM Open DUPE File-Post User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
DDEU020 AS ['RM Open DUPE File']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['RM Open DUPE File'].PSTUSRID = ['Users Master'].USERID17 GLPOSTDT GL Posting Date DT Date 8 18 LSTEDTDT Last Edit Date DT_Date Date 6 19 LSTUSRED Last User to Edit STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['RM Open DUPE File'].LSTUSRED AS 'RM Open DUPE File-Last User to Edit'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
DDEU020 AS ['RM Open DUPE File']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['RM Open DUPE File'].LSTUSRED = ['Users Master'].USERID20 ORTRXAMT Original Trx Amount DLR17_RBS0_STR$ Currency 17 21 CURTRXAM Current Trx Amount DLR17_RBS0_UTR$ Currency 17 22 SLSAMNT Sales Amount DLR19_RBSO_UTR$ Currency 19 23 COSTAMNT Cost Amount DLR19_RBSO_UTR$ Currency 19 24 FRTAMNT Freight Amount DLR17_RBS0_UTR$ Currency 17 25 MISCAMNT Misc Amount DLR17_RBS0_UTR$ Currency 17 26 TAXAMNT Tax Amount DLR17_RBS0_UTR$ Currency 17 27 COMDLRAM Commission Dollar Amount DLR17_RBSO_STR$ Currency 17 28 CASHAMNT Cash Amount DLR19_RBS0_UTR$ Currency 19 29 DISTKNAM Discount Taken Amount DLR17_RBS0_UTR$ Currency 17 30 DISAVAMT Discount Available Amount DLR17_RBS0_UTR$ Currency 17 31 DISAVTKN Discount Available Taken DLR17_RBS0_UTR$ Currency 17 32 DISCRTND Discount Returned DLR17_RBS0_STR$ Currency 17 33 DISCDATE Discount Date DT Date 8 34 DSCDLRAM Discount Dollar Amount DLR11_RBS0_UTR$ Currency 11 35 DSCPCTAM Discount Percent Amount INT5_%2 Integer 5 36 WROFAMNT Write Off Amount DLR17_RBS0_STR$ Currency 17 37 TRXDSCRN Transaction Description STR30 String 30 38 CSPORNBR Customer Purchase Order Number Document_Number String 20 39 SLPRSNID Salesperson ID STR15_Salesperson_ID String 15 Key to the RM Salesperson Master (RM00301).
Click to show/hide
SELECT
['RM Open DUPE File'].SLPRSNID AS 'RM Open DUPE File-Salesperson ID'
,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
DDEU020 AS ['RM Open DUPE File']
INNER JOIN
RM00301 AS ['RM Salesperson Master']
ON
['RM Open DUPE File'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID40 SLSTERCD Sales Territory Code STR15 String 15 41 DINVPDOF Date Invoice Paid Off DT Date 8 42 PPSAMDED PPS Amount Deducted DLR17_RBS0_UTR$ Currency 17 43 GSTDSAMT GST Discount Amount DLR17_RBS0_STR$ Currency 17 44 DELETE1 Delete YN Boolean 0 45 AGNGBUKT Aging Bucket INT1_U0 Integer 1 46 VOIDSTTS Void Status INT Integer 0 47 VOIDDATE Void Date DT Date 8 48 TAXSCHID Tax Schedule ID STR15_Tax_Schedule_ID String 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['RM Open DUPE File'].TAXSCHID AS 'RM Open DUPE File-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
DDEU020 AS ['RM Open DUPE File']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['RM Open DUPE File'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID49 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['RM Open DUPE File'].CURNCYID AS 'RM Open DUPE File-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
DDEU020 AS ['RM Open DUPE File']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['RM Open DUPE File'].CURNCYID = ['Currency Setup'].CURNCYID50 PYMTRMID Payment Terms ID STR20_Payment_Terms_ID String 20 Key to the Payment Terms Master (SY03300).
Click to show/hide
SELECT
['RM Open DUPE File'].PYMTRMID AS 'RM Open DUPE File-Payment Terms ID'
,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
DDEU020 AS ['RM Open DUPE File']
INNER JOIN
SY03300 AS ['Payment Terms Master']
ON
['RM Open DUPE File'].PYMTRMID = ['Payment Terms Master'].PYMTRMID51 SHIPMTHD Shipping Method STR15_Shipping_Method String 15 Key to the Shipping Methods Master (SY03000).
Click to show/hide
SELECT
['RM Open DUPE File'].SHIPMTHD AS 'RM Open DUPE File-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
DDEU020 AS ['RM Open DUPE File']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['RM Open DUPE File'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD52 TRDISAMT Trade Discount Amount DLR17_RBS0_UTR$ Currency 17 53 SLSCHDID Sales Schedule ID STR15_LBU String 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['RM Open DUPE File'].SLSCHDID AS 'RM Open DUPE File-Sales Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
DDEU020 AS ['RM Open DUPE File']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['RM Open DUPE File'].SLSCHDID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID54 FRTSCHID Freight Schedule ID STR15_LBAU String 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['RM Open DUPE File'].FRTSCHID AS 'RM Open DUPE File-Freight Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
DDEU020 AS ['RM Open DUPE File']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['RM Open DUPE File'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID55 MSCSCHID Misc Schedule ID STR15_LBAU String 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['RM Open DUPE File'].MSCSCHID AS 'RM Open DUPE File-Misc Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
DDEU020 AS ['RM Open DUPE File']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['RM Open DUPE File'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID56 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['RM Open DUPE File'].NOTEINDX AS 'RM Open DUPE File-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
DDEU020 AS ['RM Open DUPE File']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['RM Open DUPE File'].NOTEINDX = ['Record Notes Master'].NOTEINDX57 Tax_Date Tax Date DT Date 8 58 APLYWITH Apply Withholding Boolean Boolean 0 59 SALEDATE Sale Date DT Date 8 60 CORRCTN Correction CB_Correction Boolean 0 61 SIMPLIFD Simplified CB_Simplified Boolean 0 62 Electronic Electronic CB_Electronic Boolean 0 63 ECTRX EC Transaction CB_EC_Transaction Boolean 0 The field is set to true for each VAT Line Analysis record, if the user marks the transaction as being an EC Transaction.
Click to show/hide Document Printed flag
0 Not an EU Transaction.
1 EU Transaction.64 BKTSLSAM Backout Sales Amount DLR19_RBS0_UTR$ Currency 19 65 BKTFRTAM Backout Freight Amount DLR19_RBS0_UTR$ Currency 19 66 BKTMSCAM Backout Misc Amount DLR19_RBS0_UTR$ Currency 19 67 BackoutTradeDisc Backout Trade Discount Amount DLR19_RBS0_UTR$ Currency 19 68 Factoring Factoring boolean Boolean 0 69 DIRECTDEBIT Direct Debit CB_DirectDebit Boolean 0