VAT_IV_Comm_Code (VAT00200)

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

Product: Microsoft Dynamics GP (0)
Series: Company

Display Name: VAT_IV_Comm_Code
Physical Name: VAT00200
Technical Name: VAT_IV_Comm_Code

Group Display Name: Intrastat
Group Technical Name: Intrastat

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1TCC SearchTax Commodity CodeStringSTR30_VAT30
2NUMASS SearchNet Unit MassCurrencyDLR17_QTY_RBS0_UTR17
3PROTYPECODE SearchProcess Type CodeStringSTR6_VAT6
4PROTYPECODESC SearchProcess Type Code DescriptionStringSTR3030
5NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['VAT_IV_Comm_Code'].NOTEINDX AS 'VAT_IV_Comm_Code-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       VAT00200 AS ['VAT_IV_Comm_Code']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['VAT_IV_Comm_Code'].NOTEINDX = ['Record Notes Master'].NOTEINDX

Leave a Reply

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