Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVRMA306
Product: WennSoft Products (131)
Series: Sales
Display Name: RM Tax History File Archive
Physical Name: SVRMA306
Technical Name: RM_Tax_History_ArchiveSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 BACHNUMB 
Batch Number STR15_LBAU String 15 2 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 Payments3 DOCNUMBR Document Number STR20_Document_Number String 20 4 CUSTNMBR Customer Number STR15_RM_Customer_Number String 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['RM Tax History File Archive'].CUSTNMBR AS 'RM Tax History File Archive-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
SVRMA306 AS ['RM Tax History File Archive']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['RM Tax History File Archive'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR5 TRXSORCE TRX Source STR13 String 13 6 TAXDTLID Tax Detail ID STR15_Tax_Detail_ID String 15 Key to the Sales/Purchases Tax Master (TX00201).
Click to show/hide
SELECT
['RM Tax History File Archive'].TAXDTLID AS 'RM Tax History File Archive-Tax Detail ID'
,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
SVRMA306 AS ['RM Tax History File Archive']
INNER JOIN
TX00201 AS ['Sales/Purchases Tax Master']
ON
['RM Tax History File Archive'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID7 ACTINDX Account Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['RM Tax History File Archive'].ACTINDX AS 'RM Tax History File Archive-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
SVRMA306 AS ['RM Tax History File Archive']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['RM Tax History File Archive'].ACTINDX = ['Account Index Master'].ACTINDX8 TAXAMNT Tax Amount DLR17_RBS0_UTR$ Currency 17 9 ORTAXAMT Originating Tax Amount DLR17_RBS0_UTR$ Currency 17 10 STAXAMNT Sales Tax Amount DLR19_RBSO_UTR$ Currency 19 11 ORSLSTAX Originating Sales Tax Amount DLR19_RBSO_UTR$ Currency 19 12 FRTTXAMT Freight Tax Amount DLR19_RBSO_UTR$ Currency 19 13 ORFRTTAX Originating Freight Tax Amount DLR19_RBSO_UTR$ Currency 19 14 MSCTXAMT Misc Tax Amount DLR19_RBSO_UTR$ Currency 19 15 ORMSCTAX Originating Misc Tax Amount DLR19_RBSO_UTR$ Currency 19 16 TAXDTSLS Tax Detail Total Sales DLR19_RBS0_UTR$ Currency 19 17 ORTOTSLS Originating Total Sales DLR19_RBSO_UTR$ Currency 19 18 TDTTXSLS Tax Detail Total Taxable Sales DLR19_RBS0_UTR$ Currency 19 19 ORTXSLS Originating Total Taxable Sales DLR19_RBSO_UTR$ Currency 19 20 POSTED Posted True/False Boolean 0 21 SEQNUMBR Sequence Number LI_Sequence_Number Long Integer 10 22 CURRNIDX Currency Index INT3 Integer 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['RM Tax History File Archive'].CURRNIDX AS 'RM Tax History File Archive-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
SVRMA306 AS ['RM Tax History File Archive']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['RM Tax History File Archive'].CURRNIDX = ['Currency Setup'].CURRNIDX