Intrastat Requirement Setup (EIRS1000)

azurecurveProductsEnhanced Intrastat (2788)CompanyIntrastat Requirement Setup (EIRS1000)

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

Product: Enhanced Intrastat (2788)
Series:

Display Name: Intrastat Requirement Setup
Physical Name: EIRS1000
Technical Name: EI_Requirement_Setup

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1CMPADRSCODE SearchCompAddrCodeStringSTR15_Address_Code15
2CCode SearchCountry CodeStringSTR6_VAT6
Key to the VAT Country Code MSTR (VAT10001).

Click to show/hide

SELECT
       ['Intrastat Requirement Setup'].CCode AS 'Intrastat Requirement Setup-Country Code'
       ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
       EIRS1000 AS ['Intrastat Requirement Setup']
INNER JOIN
       VAT10001 AS ['VAT Country Code MSTR']
              ON
                     ['Intrastat Requirement Setup'].CCode = ['VAT Country Code MSTR'].CCode
3ISREQD_1 SearchISRequired[1]BooleanBoolean0
4ISREQD SearchISRequiredBooleanBoolean0
5ISREQD_2 SearchISRequired[2]BooleanBoolean0
6ISREQD_3 SearchISRequired[3]BooleanBoolean0
7ISREQD_4 SearchISRequired[4]BooleanBoolean0
8ISREQD_5 SearchISRequired[5]BooleanBoolean0
9ISREQD_6 SearchISRequired[6]BooleanBoolean0
10ISREQD_7 SearchISRequired[7]BooleanBoolean0
11ISREQD_8 SearchISRequired[8]BooleanBoolean0
12ISREQD_9 SearchISRequired[9]BooleanBoolean0
13ISREQD_10 SearchISRequired[10]BooleanBoolean0
14ISREQD_11 SearchISRequired[11]BooleanBoolean0
15ISREQD_12 SearchISRequired[12]BooleanBoolean0
16ISREQD_13 SearchISRequired[13]BooleanBoolean0
17ISREQD_14 SearchISRequired[14]BooleanBoolean0
18ISREQD_15 SearchISRequired[15]BooleanBoolean0
19ISREQD_16 SearchISRequired[16]BooleanBoolean0
20ISREQD_17 SearchISRequired[17]BooleanBoolean0
21ISREQD_18 SearchISRequired[18]BooleanBoolean0
azurecurveProductsEnhanced Intrastat (2788)CompanyIntrastat Requirement Setup (EIRS1000)

Leave a Reply

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