PM Class Intrastat MSTR (VAT10200)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/VAT10200

Product: Microsoft Dynamics GP (0)
Series: Purchasing

Display Name: PM Class Intrastat MSTR
Physical Name: VAT10200
Technical Name: PM_Class_Intrastat_MSTR

Group Display Name: Payables Vendor Master Logical File
Group Technical Name: PM_Vendor_Master_Logical_File

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1CLASSID SearchClass IDSTR15_LBAUString15
2CCode SearchCountry CodeSTR6_VATString6
Key to the VAT Country Code MSTR (VAT10001).

Click to show/hide

SELECT
       ['PM Class Intrastat MSTR'].CCode AS 'PM Class Intrastat MSTR-Country Code'
       ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
       VAT10200 AS ['PM Class Intrastat MSTR']
INNER JOIN
       VAT10001 AS ['VAT Country Code MSTR']
              ON
                     ['PM Class Intrastat MSTR'].CCode = ['VAT Country Code MSTR'].CCode
3TMCODE SearchTransport Mode CodeSTR6_VATString6
4TRANSNATURE SearchTransaction NatureSTR6_VATString6
5TCC SearchTax Commodity CodeSTR30_VATString30
6PRT SearchPortSTR6_VATString6
7RGN SearchRegionSTR6_VATString6
8CNTRYORGN SearchCountry OriginSTR6_VATString6
9PRCDRRGM SearchProcedure/RegimeSTR6_VATString6
10INCTRMS SearchIncotermsSTR6_VATString6
11DEX_ROW_ID Searchintint10

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

Leave a Reply

Your email address will not be published. Required fields are marked *