Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EDCEI013
Product: Enhanced Intrastat (2788)
Series:
Display Name: Intrastat Header
Physical Name: EDCEI013
Technical Name: ivIntrastatHDRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 IVDOCTYP 
IV Document Type Integer DDL_IV_Document_Type 0 2 IVDOCNBR IV Document Number String STR17_IV_Document_Number 17 3 LOCNCODE1 From Location Code String STR10_Location_Code 10 4 LOCNCODE2 To Location Code String STR10_Location_Code 10 5 PRINTDOC PrintDoc Boolean CB_PrintDoc 0 6 COMMNTID Comment ID String STR15_Comment_ID 15 Key to the Comment Master (SY04200).
Click to show/hide
SELECT
['Intrastat Header '].COMMNTID AS 'Intrastat Header -Comment ID'
,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
EDCEI013 AS ['Intrastat Header ']
INNER JOIN
SY04200 AS ['Comment Master']
ON
['Intrastat Header '].COMMNTID = ['Comment Master'].COMMNTID7 ECTRX EC Transaction Boolean CB_EC_Transaction 0 The field is set to true for each VAT Line Analysis record, if the user marks the transaction as being an EC Transaction.
Click to show/hide Document Printed flag
0 Not an EU Transaction.
1 EU Transaction.8 PRINTED Printed Boolean CB 0 Click to show/hide Printed flag
0 Record has not been printed.
1 Record has been printed.9 SUBMITTED Submitted Boolean Boolean 0 10 BACHNUMB Batch Number String STR15_LBAU 15 11 BCHSOURC Batch Source String STR15 15 12 DOCDATE Document Date Date DT 8 13 ARRDSP Arr/Disp Integer INT1 1