Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/IV40702
Product: Microsoft Dynamics GP (0)
Series: Inventory
Display Name: Site Intrastat Setup Group Display Name: Inventory Site Setup
Physical Name: IV40702
Technical Name: ivLocationIntrastatMstr
Group Technical Name: Inventory Site Setup
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | LOCNCODE  | Location Code | String | STR10_Location_Code | 10 | |
Key to the Site Setup (IV40700).
Click to show/hideSELECT
['Site Intrastat Setup'].LOCNCODE AS 'Site Intrastat Setup-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
IV40702 AS ['Site Intrastat Setup']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['Site Intrastat Setup'].LOCNCODE = ['Site Setup'].LOCNCODE | ||||||
| 2 | TXRGNNUM | Tax Registration Number | String | STR25 | 25 | |
| 3 | CCode | Country Code | String | STR6_VAT | 6 | |
Key to the VAT Country Code MSTR (VAT10001).
Click to show/hideSELECT
['Site Intrastat Setup'].CCode AS 'Site Intrastat Setup-Country Code'
,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
IV40702 AS ['Site Intrastat Setup']
INNER JOIN
VAT10001 AS ['VAT Country Code MSTR']
ON
['Site Intrastat Setup'].CCode = ['VAT Country Code MSTR'].CCode | ||||||
| 4 | TMCODE | Transport Mode Code | String | STR6_VAT | 6 | |
| 5 | TRANSNATURE | Transaction Nature | String | STR6_VAT | 6 | |
| 6 | PRCDRRGM | Procedure/Regime | String | STR6_VAT | 6 | |
| 7 | INCTRMS | Incoterms | String | STR6_VAT | 6 | |
| 8 | PRT | Port | String | STR6_VAT | 6 | |
| 9 | RGN | Region | String | STR6_VAT | 6 | |
| 10 | CNTRYORGN | Country Origin | String | STR6_VAT | 6 | |