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