RM Customer Intrastat MSTR (VAT10101)

azurecurveProductsMicrosoft Dynamics GP (0)SalesRM Customer Intrastat MSTR (VAT10101)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/VAT10101

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: RM Customer Intrastat MSTR
Physical Name: VAT10101
Technical Name: RM_Customer_Intrastat_MSTR

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

Click to show/hide

SELECT
       ['RM Customer Intrastat MSTR'].CUSTNMBR AS 'RM Customer Intrastat MSTR-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       VAT10101 AS ['RM Customer Intrastat MSTR']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['RM Customer Intrastat MSTR'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2ADRSCODE SearchAddress CodeStringSTR15_Address_Code15
3TXRGNNUM SearchTax Registration NumberStringSTR2525
4CCode SearchCountry CodeStringSTR6_VAT6
Key to the VAT Country Code MSTR (VAT10001).

Click to show/hide

SELECT
       ['RM Customer Intrastat MSTR'].CCode AS 'RM Customer Intrastat MSTR-Country Code'
       ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
       VAT10101 AS ['RM Customer Intrastat MSTR']
INNER JOIN
       VAT10001 AS ['VAT Country Code MSTR']
              ON
                     ['RM Customer Intrastat MSTR'].CCode = ['VAT Country Code MSTR'].CCode
5TMCODE SearchTransport Mode CodeStringSTR6_VAT6
6TRANSNATURE SearchTransaction NatureStringSTR6_VAT6
7TCC SearchTax Commodity CodeStringSTR30_VAT30
8PRT SearchPortStringSTR6_VAT6
9RGN SearchRegionStringSTR6_VAT6
10PRCDRRGM SearchProcedure/RegimeStringSTR6_VAT6
11INCTRMS SearchIncotermsStringSTR6_VAT6
azurecurveProductsMicrosoft Dynamics GP (0)SalesRM Customer Intrastat MSTR (VAT10101)

Leave a Reply

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