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 Group Display Name: Payables Vendor Master Logical File
Physical Name: VAT10200
Technical Name: PM_Class_Intrastat_MSTR
Group Technical Name: PM_Vendor_Master_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
['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 | ||||||
| 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 | CNTRYORGN | Country Origin | String | STR6_VAT | 6 | |
| 9 | PRCDRRGM | Procedure/Regime | String | STR6_VAT | 6 | |
| 10 | INCTRMS | Incoterms | String | STR6_VAT | 6 | |