Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/IEPMTRXI
Product: Microsoft Dynamics GP (0)
Series: Financial
Display Name: ieTrxPMImport
Physical Name: IEPMTRXI
Technical Name: ieTrxPMImportSeq 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 VCHRNMBR Voucher Number String STR20_LBAU 20 4 VENDORID Vendor ID String STR_15_Vendor_ID 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['ieTrxPMImport'].VENDORID AS 'ieTrxPMImport-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
IEPMTRXI AS ['ieTrxPMImport']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['ieTrxPMImport'].VENDORID = ['PM Vendor Master File'].VENDORID5 VENDNAME Vendor Name String STR64_Vendor_Name 64 6 DOCDATE Document Date Date DT 8 7 DOCTYPE Document Type Integer DDL_Document_Type 0 8 VNDDOCNM Vendor Document Number String STR20_Document_Number 20 9 DSCRIPTN Description String STR30 30 10 DOCAMNT Document Amount Currency DLR19_RBSO_UTR$ 19 11 PRCHAMNT Purchases Amount Currency DLR17_RBS0_UTR$ 17 12 TRDISAMT Trade Discount Amount Currency DLR17_RBS0_UTR$ 17 13 FRTAMNT Freight Amount Currency DLR17_RBS0_UTR$ 17 14 MSCCHAMT Misc Charges Amount Currency DLR17_RBS0_UTR$ 17 15 TAXAMNT Tax Amount Currency DLR17_RBS0_UTR$ 17 16 PYMTRMID Payment Terms ID String STR20_Payment_Terms_ID 20 Key to the Payment Terms Master (SY03300).
Click to show/hide
SELECT
['ieTrxPMImport'].PYMTRMID AS 'ieTrxPMImport-Payment Terms ID'
,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
IEPMTRXI AS ['ieTrxPMImport']
INNER JOIN
SY03300 AS ['Payment Terms Master']
ON
['ieTrxPMImport'].PYMTRMID = ['Payment Terms Master'].PYMTRMID17 SHIPMTHD Shipping Method String STR15_Shipping_Method 15 Key to the Shipping Methods Master (SY03000).
Click to show/hide
SELECT
['ieTrxPMImport'].SHIPMTHD AS 'ieTrxPMImport-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
IEPMTRXI AS ['ieTrxPMImport']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['ieTrxPMImport'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD18 ADRSCODE Address Code String STR15_Address_Code 15 19 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
['ieTrxPMImport'].TAXSCHID AS 'ieTrxPMImport-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
IEPMTRXI AS ['ieTrxPMImport']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['ieTrxPMImport'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID