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 Group Display Name: Receivables Class Master Files
Physical Name: VAT10100
Technical Name: RM_Class_Intrastat_MSTR
Group Technical Name: RM_Class_MSTR_Logical_File
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | CLASSID  | Class ID | String | STR15_LBAU | 15 | |
| 2 | CCode | Country Code | String | STR6_VAT | 6 | |
Key to the VAT Country Code MSTR (VAT10001).
Click to show/hideSELECT
['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 | ||||||
| 3 | TMCODE | Transport Mode Code | String | STR6_VAT | 6 | |
| 4 | TRANSNATURE | Transaction Nature | String | STR6_VAT | 6 | |
| 5 | TCC | Tax Commodity Code | String | STR30_VAT | 30 | |
| 6 | PRT | Port | String | STR6_VAT | 6 | |
| 7 | RGN | Region | String | STR6_VAT | 6 | |
| 8 | PRCDRRGM | Procedure/Regime | String | STR6_VAT | 6 | |
| 9 | INCTRMS | Incoterms | String | STR6_VAT | 6 | |