RM Class Intrastat MSTR (VAT10100)

azurecurveProductsMicrosoft Dynamics GP (0)SalesRM Class Intrastat MSTR (VAT10100)

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

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: RM Class Intrastat MSTR
Physical Name: VAT10100
Technical Name: RM_Class_Intrastat_MSTR

Group Display Name: Receivables Class Master Files
Group Technical Name: RM_Class_MSTR_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
       ['RM Class Intrastat MSTR'].CCode AS 'RM Class Intrastat MSTR-Country Code'
       ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
       VAT10100 AS ['RM Class Intrastat MSTR']
INNER JOIN
       VAT10001 AS ['VAT Country Code MSTR']
              ON
                     ['RM 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
8PRCDRRGM SearchProcedure/RegimeSTR6_VATString6
9INCTRMS SearchIncotermsSTR6_VATString6
10DEX_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.

azurecurveProductsMicrosoft Dynamics GP (0)SalesRM Class Intrastat MSTR (VAT10100)

Leave a Reply

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