Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EDCEI012
Product: Enhanced Intrastat (2788)
Series:
Display Name: Intrastat Inventory Default Site
Physical Name: EDCEI012
Technical Name: ivIntrastatDefSiteSeq 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 LOCNCODE Location Code String STR10_Location_Code 10 Key to the Site Setup (IV40700).
Click to show/hide
SELECT
['Intrastat Inventory Default Site'].LOCNCODE AS 'Intrastat Inventory Default Site-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
EDCEI012 AS ['Intrastat Inventory Default Site']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['Intrastat Inventory Default Site'].LOCNCODE = ['Site Setup'].LOCNCODE4 TXRGNNUM Tax Registration Number String STR25 25 5 CCode Country Code String STR6_VAT 6 Key to the VAT Country Code MSTR (VAT10001).
Click to show/hide
SELECT
['Intrastat Inventory Default Site'].CCode AS 'Intrastat Inventory Default Site-Country Code'
,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
EDCEI012 AS ['Intrastat Inventory Default Site']
INNER JOIN
VAT10001 AS ['VAT Country Code MSTR']
ON
['Intrastat Inventory Default Site'].CCode = ['VAT Country Code MSTR'].CCode6 TMCODE Transport Mode Code String STR6_VAT 6 7 TRANSNATURE Transaction Nature String STR6_VAT 6 8 PRCDRRGM Procedure/Regime String STR6_VAT 6 9 INCTRMS Incoterms String STR6_VAT 6 10 PRT Port String STR6_VAT 6 11 RGN Region String STR6_VAT 6 12 CNTRYORGN Country Origin String STR6_VAT 6 13 TCC Tax Commodity Code String STR30_VAT 30 14 TRADREF Traders Reference String STR20 20 15 PRINTDOC PrintDoc Boolean CB_PrintDoc 0 16 COMMNTID Comment ID String STR15_Comment_ID 15 Key to the Comment Master (SY04200).
Click to show/hide
SELECT
['Intrastat Inventory Default Site'].COMMNTID AS 'Intrastat Inventory Default Site-Comment ID'
,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
EDCEI012 AS ['Intrastat Inventory Default Site']
INNER JOIN
SY04200 AS ['Comment Master']
ON
['Intrastat Inventory Default Site'].COMMNTID = ['Comment Master'].COMMNTID17 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.18 PRINTED Printed Boolean CB 0 Click to show/hide Printed flag
0 Record has not been printed.
1 Record has been printed.19 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['Intrastat Inventory Default Site'].NOTEINDX AS 'Intrastat Inventory Default Site-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
EDCEI012 AS ['Intrastat Inventory Default Site']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Intrastat Inventory Default Site'].NOTEINDX = ['Record Notes Master'].NOTEINDX