Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EDCEI021
Product: Enhanced Intrastat (2788)
Series:
Display Name: EI_VAT_INTRA_WORK1
Physical Name: EDCEI021
Technical Name: EI_VAT_INTRA_WORK1Seq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 SERIES 
Series Integer DDL_Series 0 2 DOCTYPE Document Type Integer DDL_Document_Type 0 3 DOCNUMBR Document Number String STR20_Document_Number 20 4 SQNCLINE Sequence Line Currency DLR19_$S2 19 5 CUSTNMBR Customer Number String STR15_RM_Customer_Number 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['EI_VAT_INTRA_WORK1'].CUSTNMBR AS 'EI_VAT_INTRA_WORK1-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
EDCEI021 AS ['EI_VAT_INTRA_WORK1']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['EI_VAT_INTRA_WORK1'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR6 CCode Country Code String STR6_VAT 6 Key to the VAT Country Code MSTR (VAT10001).
Click to show/hide
SELECT
['EI_VAT_INTRA_WORK1'].CCode AS 'EI_VAT_INTRA_WORK1-Country Code'
,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
EDCEI021 AS ['EI_VAT_INTRA_WORK1']
INNER JOIN
VAT10001 AS ['VAT Country Code MSTR']
ON
['EI_VAT_INTRA_WORK1'].CCode = ['VAT Country Code MSTR'].CCode7 TXRGNNUM Tax Registration Number String STR25 25 8 TCC Tax Commodity Code String STR30_VAT 30 9 NUMASS Net Unit Mass Currency DLR17_QTY_RBS0_UTR 17 10 QUANTITY QTY Currency DLR17_QTY_RBS0_STR 17 11 LMASS Line Mass Currency DLR17_QTY_RBS0_UTR 17 12 TMCODE Transport Mode Code String STR6_VAT 6 13 TRANSNATURE Transaction Nature String STR6_VAT 6 14 SUPPUNITS Supplementary Units Currency DLR17_QTY_RBS0_UTR 17 15 TRADREF Traders Reference String STR20 20 16 GOODSVALUE Goods Value Currency DLR19_RBS0_UTR$ 19 17 TAXAMNT Tax Amount Currency DLR17_RBS0_UTR$ 17 18 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['EI_VAT_INTRA_WORK1'].NOTEINDX AS 'EI_VAT_INTRA_WORK1-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
EDCEI021 AS ['EI_VAT_INTRA_WORK1']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['EI_VAT_INTRA_WORK1'].NOTEINDX = ['Record Notes Master'].NOTEINDX19 DOCDATE Document Date Date DT 8 20 Tax_Date Tax Date Date DT 8 21 Reference_Date Reference Date Date DT 8 22 POSTED Posted Boolean True/False 0 23 VOIDSTTS Void Status Integer INT 0 24 ORGDSVAL Originating Goods Value Currency DLR19_RBSO_UTR$ 19 25 ORTAXAMT Originating Tax Amount Currency DLR17_RBS0_UTR$ 17 26 CURRNIDX Currency Index Integer INT3 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['EI_VAT_INTRA_WORK1'].CURRNIDX AS 'EI_VAT_INTRA_WORK1-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
EDCEI021 AS ['EI_VAT_INTRA_WORK1']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['EI_VAT_INTRA_WORK1'].CURRNIDX = ['Currency Setup'].CURRNIDX27 ITEMNMBR Item Number String STR30_Item_Number 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['EI_VAT_INTRA_WORK1'].ITEMNMBR AS 'EI_VAT_INTRA_WORK1-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
EDCEI021 AS ['EI_VAT_INTRA_WORK1']
INNER JOIN
IV00101 AS ['Item Master']
ON
['EI_VAT_INTRA_WORK1'].ITEMNMBR = ['Item Master'].ITEMNMBR28 ITEMDESC Item Description String STR100 100 29 PRT Port String STR6_VAT 6 30 RGN Region String STR6_VAT 6 31 CNTRYORGN Country Origin String STR6_VAT 6 32 PRCDRRGM Procedure/Regime String STR6_VAT 6 33 INCTRMS Incoterms String STR6_VAT 6 34 STTSTCLVL Statistical Value Currency DLR19_RBSO_UTR$ 19 35 ORGNTNGSTTSTCLVL Originating Statistical Value Currency DLR19_RBSO_UTR$ 19 36 Included_On_Return Included On Return Boolean Boolean 0 37 INTRSTTRTRNID Intrastat Return ID String STR20_LBAU 20 38 DECLID Declarant ID String STR15_Address_Code 15 39 LOCNCODE Location Code String STR10_Location_Code 10 Key to the Site Setup (IV40700).
Click to show/hide
SELECT
['EI_VAT_INTRA_WORK1'].LOCNCODE AS 'EI_VAT_INTRA_WORK1-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
EDCEI021 AS ['EI_VAT_INTRA_WORK1']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['EI_VAT_INTRA_WORK1'].LOCNCODE = ['Site Setup'].LOCNCODE40 ARRDISP Arrival/Despatch String STR1 1 41 PERIOD Period String STR5_GPA 5 42 AUDITTRAIL Audit Trail Code String STR13_LBAU 13