Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/VAT10201
Product: Microsoft Dynamics GP (0)
Series: Purchasing
Display Name: PM Vendor Intrastat MSTR
Physical Name: VAT10201
Technical Name: PM_Vendor_Intrastat_MSTRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 VENDORID 
Vendor ID String STR_15_Vendor_ID 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['PM Vendor Intrastat MSTR'].VENDORID AS 'PM Vendor Intrastat MSTR-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
VAT10201 AS ['PM Vendor Intrastat MSTR']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['PM Vendor Intrastat MSTR'].VENDORID = ['PM Vendor Master File'].VENDORID2 ADRSCODE Address Code String STR15_Address_Code 15 3 TXRGNNUM Tax Registration Number String STR25 25 4 CCode Country Code String STR6_VAT 6 Key to the VAT Country Code MSTR (VAT10001).
Click to show/hide
SELECT
['PM Vendor Intrastat MSTR'].CCode AS 'PM Vendor Intrastat MSTR-Country Code'
,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
VAT10201 AS ['PM Vendor Intrastat MSTR']
INNER JOIN
VAT10001 AS ['VAT Country Code MSTR']
ON
['PM Vendor Intrastat MSTR'].CCode = ['VAT Country Code MSTR'].CCode5 TMCODE Transport Mode Code String STR6_VAT 6 6 TRANSNATURE Transaction Nature String STR6_VAT 6 7 TCC Tax Commodity Code String STR30_VAT 30 8 PRT Port String STR6_VAT 6 9 RGN Region String STR6_VAT 6 10 CNTRYORGN Country Origin String STR6_VAT 6 11 PRCDRRGM Procedure/Regime String STR6_VAT 6 12 INCTRMS Incoterms String STR6_VAT 6