Intrastat Exception Report (EDCEI019)

azurecurveProductsEnhanced Intrastat (2788)SalesIntrastat Exception Report (EDCEI019)

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

Product: Enhanced Intrastat (2788)
Series: Sales

Display Name: Intrastat Exception Report
Physical Name: EDCEI019
Technical Name: EI_EXPN_RPT_TEMP

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1SOPNUMBE SearchSOP NumberSTR20_SOP_NumberString2217
2SOPTYPE SearchSOP TypeDDL_SOP_TypeInteger20
3DOCID SearchDocument IDSTR15_LBAUString1615
4BACHNUMB SearchBatch NumberSTR15_LBAUString1615
5DOCDATE SearchDocument DateDTDate48
6EXCHDATE SearchExchange DateDT_DateDate46
7POSTEDDT SearchPosted DateDATEDate46
8CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['Intrastat Exception Report'].CUSTNMBR AS 'Intrastat Exception Report-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       EDCEI019 AS ['Intrastat Exception Report']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['Intrastat Exception Report'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
9CUSTNAME SearchCustomer NameSTR64_Customer_NameString6664
10CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Intrastat Exception Report'].CURNCYID AS 'Intrastat Exception Report-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       EDCEI019 AS ['Intrastat Exception Report']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Intrastat Exception Report'].CURNCYID = ['Currency Setup'].CURNCYID
11CURRNIDX SearchCurrency IndexINT3Integer23
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['Intrastat Exception Report'].CURRNIDX AS 'Intrastat Exception Report-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       EDCEI019 AS ['Intrastat Exception Report']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Intrastat Exception Report'].CURRNIDX = ['Currency Setup'].CURRNIDX
12SUBTOTAL SearchSubtotalDLR17_RBS0_STR$Currency1017
13DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurveProductsEnhanced Intrastat (2788)SalesIntrastat Exception Report (EDCEI019)

Leave a Reply

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