Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EDCEI016
Product: Enhanced Intrastat (2788)
Series:
Display Name: Intrastat Work
Physical Name: EDCEI016
Technical Name: syIntrastatWorkSeq 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
['Intrastat Work'].CUSTNMBR AS 'Intrastat Work-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
EDCEI016 AS ['Intrastat Work']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['Intrastat Work'].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
['Intrastat Work'].CCode AS 'Intrastat Work-Country Code'
,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
EDCEI016 AS ['Intrastat Work']
INNER JOIN
VAT10001 AS ['VAT Country Code MSTR']
ON
['Intrastat Work'].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
['Intrastat Work'].NOTEINDX AS 'Intrastat Work-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
EDCEI016 AS ['Intrastat Work']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Intrastat Work'].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
['Intrastat Work'].CURRNIDX AS 'Intrastat Work-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
EDCEI016 AS ['Intrastat Work']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['Intrastat Work'].CURRNIDX = ['Currency Setup'].CURRNIDX27 ITEMNMBR Item Number String STR30_Item_Number 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['Intrastat Work'].ITEMNMBR AS 'Intrastat Work-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
EDCEI016 AS ['Intrastat Work']
INNER JOIN
IV00101 AS ['Item Master']
ON
['Intrastat Work'].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 DCLGDSVAL Declarant Goods Value Currency DLR19_RBS0_UTR$ 19 37 DCLTXAMT Declarant Tax Amount Currency DLR17_RBS0_UTR$ 17 38 DCLSTVAL Declarant Statistical Value Currency DLR19_RBSO_UTR$ 19 39 DECLID Declarant ID String STR15_Address_Code 15 40 LOCNCODE Location Code String STR10_Location_Code 10 Key to the Site Setup (IV40700).
Click to show/hide
SELECT
['Intrastat Work'].LOCNCODE AS 'Intrastat Work-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
EDCEI016 AS ['Intrastat Work']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['Intrastat Work'].LOCNCODE = ['Site Setup'].LOCNCODE41 ARRDISP Arrival/Despatch String STR1 1 42 Included_On_Return Included On Return Boolean Boolean 0 43 INTRSTTRTRNID Intrastat Return ID String STR20_LBAU 20 44 PERIOD Period String STR5_GPA 5 45 AUDITTRAIL Audit Trail Code String STR13_LBAU 13