Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/IERMTRXI
Product: Microsoft Dynamics GP (0)
Series: Financial
Display Name: ieTrxRMImport
Physical Name: IERMTRXI
Technical Name: ieTrxRMImportSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CMRECNUM 
Record Number Currency DLR_Document_Number 19 2 SEQUENCE1 Sequence Currency DLR19_$S2 19 3 RMDNUMWK RM Document Number-WORK String STR17_LBAU 17 4 CUSTNMBR Customer Number String STR15_RM_Customer_Number 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['ieTrxRMImport'].CUSTNMBR AS 'ieTrxRMImport-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
IERMTRXI AS ['ieTrxRMImport']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['ieTrxRMImport'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR5 CUSTNAME Customer Name String STR64_Customer_Name 64 6 DOCDATE Document Date Date DT 8 7 DOCTYPE Document Type Integer DDL_Document_Type 0 8 DOCDESCR Document Description String STR30 30 9 DOCAMNT Document Amount Currency DLR19_RBSO_UTR$ 19 10 SLSAMNT Sales Amount Currency DLR19_RBSO_UTR$ 19 11 TRDISAMT Trade Discount Amount Currency DLR17_RBS0_UTR$ 17 12 FRTAMNT Freight Amount Currency DLR17_RBS0_UTR$ 17 13 MSCCHAMT Misc Charges Amount Currency DLR17_RBS0_UTR$ 17 14 TAXAMNT Tax Amount Currency DLR17_RBS0_UTR$ 17 15 PYMTRMID Payment Terms ID String STR20_Payment_Terms_ID 20 Key to the Payment Terms Master (SY03300).
Click to show/hide
SELECT
['ieTrxRMImport'].PYMTRMID AS 'ieTrxRMImport-Payment Terms ID'
,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
IERMTRXI AS ['ieTrxRMImport']
INNER JOIN
SY03300 AS ['Payment Terms Master']
ON
['ieTrxRMImport'].PYMTRMID = ['Payment Terms Master'].PYMTRMID16 SHIPMTHD Shipping Method String STR15_Shipping_Method 15 Key to the Shipping Methods Master (SY03000).
Click to show/hide
SELECT
['ieTrxRMImport'].SHIPMTHD AS 'ieTrxRMImport-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
IERMTRXI AS ['ieTrxRMImport']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['ieTrxRMImport'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD17 ADRSCODE Address Code String STR15_Address_Code 15 18 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
['ieTrxRMImport'].TAXSCHID AS 'ieTrxRMImport-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
IERMTRXI AS ['ieTrxRMImport']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['ieTrxRMImport'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID