Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVRMA300
Product: WennSoft Products (131)
Series: Sales
Display Name: RM History File Archive
Physical Name: SVRMA300
Technical Name: RM_HISTORY_ArchiveSeq 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 History File Archive'].CUSTNMBR AS 'RM History File Archive-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
SVRMA300 AS ['RM History File Archive']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['RM History File Archive'].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 DUEDATE Due Date DT Date 8 10 DOCDATE Document Date DT Date 8 11 POSTDATE Post Date DT_Date Date 6 12 PSTUSRID Post User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['RM History File Archive'].PSTUSRID AS 'RM History File Archive-Post User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SVRMA300 AS ['RM History File Archive']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['RM History File Archive'].PSTUSRID = ['Users Master'].USERID13 GLPOSTDT GL Posting Date DT Date 8 14 LSTEDTDT Last Edit Date DT_Date Date 6 15 LSTUSRED Last User to Edit STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['RM History File Archive'].LSTUSRED AS 'RM History File Archive-Last User to Edit'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SVRMA300 AS ['RM History File Archive']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['RM History File Archive'].LSTUSRED = ['Users Master'].USERID16 ORTRXAMT Original Trx Amount DLR17_RBS0_STR$ Currency 17 17 CURTRXAM Current Trx Amount DLR17_RBS0_UTR$ Currency 17 18 SLSAMNT Sales Amount DLR19_RBSO_UTR$ Currency 19 19 COSTAMNT Cost Amount DLR19_RBSO_UTR$ Currency 19 20 FRTAMNT Freight Amount DLR17_RBS0_UTR$ Currency 17 21 MISCAMNT Misc Amount DLR17_RBS0_UTR$ Currency 17 22 TAXAMNT Tax Amount DLR17_RBS0_UTR$ Currency 17 23 COMDLRAM Commission Dollar Amount DLR17_RBSO_STR$ Currency 17 24 CASHAMNT Cash Amount DLR19_RBS0_UTR$ Currency 19 25 DISTKNAM Discount Taken Amount DLR17_RBS0_UTR$ Currency 17 26 DISAVAMT Discount Available Amount DLR17_RBS0_UTR$ Currency 17 27 DISCRTND Discount Returned DLR17_RBS0_STR$ Currency 17 28 DISCDATE Discount Date DT Date 8 29 DSCDLRAM Discount Dollar Amount DLR11_RBS0_UTR$ Currency 11 30 DSCPCTAM Discount Percent Amount INT5_%2 Integer 5 31 WROFAMNT Write Off Amount DLR17_RBS0_STR$ Currency 17 32 TRXDSCRN Transaction Description STR30 String 30 33 CSPORNBR Customer Purchase Order Number Document_Number String 20 34 SLPRSNID Salesperson ID STR15_Salesperson_ID String 15 Key to the RM Salesperson Master (RM00301).
Click to show/hide
SELECT
['RM History File Archive'].SLPRSNID AS 'RM History File Archive-Salesperson ID'
,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
SVRMA300 AS ['RM History File Archive']
INNER JOIN
RM00301 AS ['RM Salesperson Master']
ON
['RM History File Archive'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID35 SLSTERCD Sales Territory Code STR15 String 15 36 DINVPDOF Date Invoice Paid Off DT Date 8 37 PPSAMDED PPS Amount Deducted DLR17_RBS0_UTR$ Currency 17 38 GSTDSAMT GST Discount Amount DLR17_RBS0_STR$ Currency 17 39 DELETE1 Delete YN Boolean 0 40 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 History File Archive'].TAXSCHID AS 'RM History File Archive-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
SVRMA300 AS ['RM History File Archive']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['RM History File Archive'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID41 SLSCHDID Sales Schedule ID STR15_LBU String 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['RM History File Archive'].SLSCHDID AS 'RM History File Archive-Sales Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
SVRMA300 AS ['RM History File Archive']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['RM History File Archive'].SLSCHDID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID42 FRTSCHID Freight Schedule ID STR15_LBAU String 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['RM History File Archive'].FRTSCHID AS 'RM History File Archive-Freight Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
SVRMA300 AS ['RM History File Archive']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['RM History File Archive'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID43 MSCSCHID Misc Schedule ID STR15_LBAU String 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['RM History File Archive'].MSCSCHID AS 'RM History File Archive-Misc Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
SVRMA300 AS ['RM History File Archive']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['RM History File Archive'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID44 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['RM History File Archive'].CURNCYID AS 'RM History File Archive-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
SVRMA300 AS ['RM History File Archive']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['RM History File Archive'].CURNCYID = ['Currency Setup'].CURNCYID45 SHIPMTHD Shipping Method STR15_Shipping_Method String 15 Key to the Shipping Methods Master (SY03000).
Click to show/hide
SELECT
['RM History File Archive'].SHIPMTHD AS 'RM History File Archive-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
SVRMA300 AS ['RM History File Archive']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['RM History File Archive'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD46 PYMTRMID Payment Terms ID STR20_Payment_Terms_ID String 20 Key to the Payment Terms Master (SY03300).
Click to show/hide
SELECT
['RM History File Archive'].PYMTRMID AS 'RM History File Archive-Payment Terms ID'
,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
SVRMA300 AS ['RM History File Archive']
INNER JOIN
SY03300 AS ['Payment Terms Master']
ON
['RM History File Archive'].PYMTRMID = ['Payment Terms Master'].PYMTRMID47 TRDISAMT Trade Discount Amount DLR17_RBS0_UTR$ Currency 17 48 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['RM History File Archive'].NOTEINDX AS 'RM History File Archive-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
SVRMA300 AS ['RM History File Archive']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['RM History File Archive'].NOTEINDX = ['Record Notes Master'].NOTEINDX49 VOIDSTTS Void Status INT Integer 0 50 VOIDDATE Void Date DT Date 8 51 BALFWDNM Balance Forward Number STR20_Document_Number String 20 52 CSHRCTYP Cash Receipt Type GB Integer 0 53 Tax_Date Tax Date DT Date 8 54 APLYWITH Apply Withholding Boolean Boolean 0 55 SALEDATE Sale Date DT Date 8 56 CORRCTN Correction CB_Correction Boolean 0 57 SIMPLIFD Simplified CB_Simplified Boolean 0 58 Electronic Electronic CB_Electronic Boolean 0 59 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.60 BKTSLSAM Backout Sales Amount DLR19_RBS0_UTR$ Currency 19 61 BackoutTradeDisc Backout Trade Discount Amount DLR19_RBS0_UTR$ Currency 19 62 BKTFRTAM Backout Freight Amount DLR19_RBS0_UTR$ Currency 19 63 BKTMSCAM Backout Misc Amount DLR19_RBS0_UTR$ Currency 19 64 Factoring Factoring boolean Boolean 0 65 DIRECTDEBIT Direct Debit CB_DirectDebit Boolean 0