Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EDCEI022
Product: Enhanced Intrastat (2788)
Series: Sales
Display Name: VAT_INTRA_WORK_ESL 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.
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 STR6_VAT String 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'].CCode
2 TXRGNNUM Tax Registration Number STR25 String 25 3 GOODSVALUE Goods Value DLR19_RBS0_UTR$ Currency 19 4 PRCDRRGM Procedure/Regime STR6_VAT String 6 5 Number_of_Records Number of Records LI_Sequence_Number Long Integer 10 6 USERID User ID STR15_User_ID String 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'].USERID
7 PAGENMBR Page Number INT Integer 0 8 DEX_ROW_ID int int 10