Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EDCEI018
Product: Enhanced Intrastat (2788)
Series:
Display Name: Intrastat Invoice Setup
Physical Name: EDCEI018
Technical Name: EI_SOP_ID_SETPSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 DOCID 
Document ID String STR15_LBAU 15 2 SOPTYPE SOP Type Integer DDL_SOP_Type 0 3 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['Intrastat Invoice Setup'].NOTEINDX AS 'Intrastat Invoice Setup-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
EDCEI018 AS ['Intrastat Invoice Setup']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Intrastat Invoice Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX4 SOPNUMBE SOP Number String STR20_SOP_Number 17 5 SOPSTATUSACTIVE_1 SOP Status Active[1] Boolean CB 0 6 SOPSTATUSACTIVE SOP Status Active CB Boolean 0 7 SOPSTATUSACTIVE_2 SOP Status Active[2] Boolean CB 0 8 SOPSTATUSACTIVE_3 SOP Status Active[3] Boolean CB 0 9 SOPSTATUSACTIVE_4 SOP Status Active[4] Boolean CB 0 10 SOPSTATUSACTIVE_5 SOP Status Active[5] Boolean CB 0 11 SOPSTATUSACTIVE_6 SOP Status Active[6] Boolean CB 0 12 SOPSTATUSACTIVE_7 SOP Status Active[7] Boolean CB 0 13 SOPSTATUSACTIVE_8 SOP Status Active[8] Boolean CB 0 14 SOPSTATUSACTIVE_9 SOP Status Active[9] Boolean CB 0