Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EDCEI015
Product: Enhanced Intrastat (2788)
Series:
Display Name: Inventory Intrastat Shipping
Physical Name: EDCEI015
Technical Name: ivIntrastatShippingSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 IVDOCNBR 
IV Document Number String STR17_IV_Document_Number 17 2 IVDOCTYP IV Document Type Integer DDL_IV_Document_Type 0 3 LOCNCODE Location Code String STR10_Location_Code 10 Key to the Site Setup (IV40700).
Click to show/hide
SELECT
['Inventory Intrastat Shipping'].LOCNCODE AS 'Inventory Intrastat Shipping-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
EDCEI015 AS ['Inventory Intrastat Shipping']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['Inventory Intrastat Shipping'].LOCNCODE = ['Site Setup'].LOCNCODE4 NAME Name String STR30 30 5 ADRCNTCT Address Contact String STR60 60 6 ADDRESS1 Address 1 String STR60 60 7 ADDRESS2 Address 2 String STR60 60 8 ADDRESS3 Address 3 String STR60 60 9 CITY City String STR35 35 10 STATE State String STR30_State 29 11 ZIPCODE Zip Code String STR10 10 12 COUNTY County String STR60 60 13 COUNTRY Country String STR60 60 14 BRNCHIDENTF Branch Identifier String STR20 20 15 PHONE1 Phone 1 String Phone_Number 14 16 PHONE2 Phone 2 String Phone_Number 14 17 FAX Fax String STR14_FAX 14 18 SHIPMTHD Shipping Method String STR15_Shipping_Method 15 Key to the Shipping Methods Master (SY03000).
Click to show/hide
SELECT
['Inventory Intrastat Shipping'].SHIPMTHD AS 'Inventory Intrastat Shipping-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
EDCEI015 AS ['Inventory Intrastat Shipping']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['Inventory Intrastat Shipping'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD19 TRANREGDTL1 Transport Registration Details 1 String STR30 30 20 TRANREGDTL2 Transport Registration Details 2 String STR30 30 21 TRANREGDTL3 Transport Registration Details 3 String STR30 30 22 DATE1 Date Date DT6 6 23 TIME1 Time Time TM6 6