VAT_ADDR_MSTR (VAT00300)

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
Physical Name: VAT00300
Technical Name: VAT_ADDR_MSTR

Group Display Name: Intrastat
Group Technical Name: Intrastat

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1ECRECTYPE SearchEC Record TypeIntegerINT44
2CUSTNMBR SearchCustomer NumberStringSTR15_RM_Customer_Number15
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['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
3ADRSCODE SearchAddress CodeStringSTR15_Address_Code15
4TCC SearchTax Commodity CodeStringSTR30_VAT30
5CCode SearchCountry CodeStringSTR6_VAT6
Key to the VAT Country Code MSTR (VAT10001).

Click to show/hide

SELECT
       ['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
6ECFLAG SearchEC Member FlagBooleanCB_EC_MEMBER0
7TXRGNNUM SearchTax Registration NumberStringSTR2525
8NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['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

Leave a Reply

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