Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVRMA301
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: Receivables GL Distribution History Archive
Physical Name: SVRMA301
Technical Name: RM_Distribution_History_ArchiveSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 TRXSORCE 
TRX Source STR13 String 13 2 POSTEDDT Posted Date DATE Date 6 3 DOCNUMBR Document Number STR20_Document_Number String 20 4 DISTTYPE Distribution Type DDL Integer 0 5 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 Payments6 SEQNUMBR Sequence Number LI_Sequence_Number Long Integer 10 7 CUSTNMBR Customer Number STR15_RM_Customer_Number String 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['Receivables GL Distribution History Archive'].CUSTNMBR AS 'Receivables GL Distribution History Archive-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
SVRMA301 AS ['Receivables GL Distribution History Archive']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['Receivables GL Distribution History Archive'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR8 DSTINDX Distribution Account Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Receivables GL Distribution History Archive'].DSTINDX AS 'Receivables GL Distribution History Archive-Distribution Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
SVRMA301 AS ['Receivables GL Distribution History Archive']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Receivables GL Distribution History Archive'].DSTINDX = ['Account Index Master'].ACTINDX9 DEBITAMT Debit Amount DLR19_$S2 Currency 19 10 CRDTAMNT Credit Amount DLR19_$S2 Currency 19 11 PROJCTID Project ID STR15 String 15 12 USERID User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['Receivables GL Distribution History Archive'].USERID AS 'Receivables GL Distribution History Archive-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SVRMA301 AS ['Receivables GL Distribution History Archive']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Receivables GL Distribution History Archive'].USERID = ['Users Master'].USERID13 CATEGUSD Category Used INT Integer 0 14 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['Receivables GL Distribution History Archive'].CURNCYID AS 'Receivables GL Distribution History Archive-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
SVRMA301 AS ['Receivables GL Distribution History Archive']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Receivables GL Distribution History Archive'].CURNCYID = ['Currency Setup'].CURNCYID15 CURRNIDX Currency Index INT3 Integer 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['Receivables GL Distribution History Archive'].CURRNIDX AS 'Receivables GL Distribution History Archive-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
SVRMA301 AS ['Receivables GL Distribution History Archive']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Receivables GL Distribution History Archive'].CURRNIDX = ['Currency Setup'].CURRNIDX16 ORCRDAMT Originating Credit Amount DLR19_$S2 Currency 19 17 ORDBTAMT Originating Debit Amount DLR19_$S2 Currency 19 18 DistRef Distribution Reference STR30 String 30