Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/VAT00300
Product: Microsoft Dynamics GP (0)
Series: Company
Display Name: VAT_ADDR_MSTR Group Display Name: Intrastat
Physical Name: VAT00300
Technical Name: VAT_ADDR_MSTR
Group Technical Name: Intrastat
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | ECRECTYPE  | EC Record Type | Integer | INT4 | 4 | |
| 2 | CUSTNMBR | Customer Number | String | STR15_RM_Customer_Number | 15 | |
Key to the RM Customer MSTR (RM00101).
Click to show/hideSELECT
['VAT_ADDR_MSTR'].CUSTNMBR AS 'VAT_ADDR_MSTR-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
VAT00300 AS ['VAT_ADDR_MSTR']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['VAT_ADDR_MSTR'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR | ||||||
| 3 | ADRSCODE | Address Code | String | STR15_Address_Code | 15 | |
| 4 | TCC | Tax Commodity Code | String | STR30_VAT | 30 | |
| 5 | CCode | Country Code | String | STR6_VAT | 6 | |
Key to the VAT Country Code MSTR (VAT10001).
Click to show/hideSELECT
['VAT_ADDR_MSTR'].CCode AS 'VAT_ADDR_MSTR-Country Code'
,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
VAT00300 AS ['VAT_ADDR_MSTR']
INNER JOIN
VAT10001 AS ['VAT Country Code MSTR']
ON
['VAT_ADDR_MSTR'].CCode = ['VAT Country Code MSTR'].CCode | ||||||
| 6 | ECFLAG | EC Member Flag | Boolean | CB_EC_MEMBER | 0 | |
| 7 | TXRGNNUM | Tax Registration Number | String | STR25 | 25 | |
| 8 | NOTEINDX | Note Index | Currency | DLR14 | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['VAT_ADDR_MSTR'].NOTEINDX AS 'VAT_ADDR_MSTR-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
VAT00300 AS ['VAT_ADDR_MSTR']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['VAT_ADDR_MSTR'].NOTEINDX = ['Record Notes Master'].NOTEINDX | ||||||