Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EDCEI022
Product: Enhanced Intrastat (2788)
Series:
Display Name: VAT_INTRA_WORK_ESL
Physical Name: EDCEI022
Technical Name: VAT_INTRA_WORK_ESLSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CCode 
Country Code String STR6_VAT 6 Key to the VAT Country Code MSTR (VAT10001).
Click to show/hide
SELECT
['VAT_INTRA_WORK_ESL'].CCode AS 'VAT_INTRA_WORK_ESL-Country Code'
,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
EDCEI022 AS ['VAT_INTRA_WORK_ESL']
INNER JOIN
VAT10001 AS ['VAT Country Code MSTR']
ON
['VAT_INTRA_WORK_ESL'].CCode = ['VAT Country Code MSTR'].CCode2 TXRGNNUM Tax Registration Number String STR25 25 3 GOODSVALUE Goods Value Currency DLR19_RBS0_UTR$ 19 4 PRCDRRGM Procedure/Regime String STR6_VAT 6 5 Number_of_Records Number of Records Long Integer LI_Sequence_Number 10 6 USERID User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['VAT_INTRA_WORK_ESL'].USERID AS 'VAT_INTRA_WORK_ESL-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
EDCEI022 AS ['VAT_INTRA_WORK_ESL']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['VAT_INTRA_WORK_ESL'].USERID = ['Users Master'].USERID7 PAGENMBR Page Number Integer INT 0