Inventory Intrastat Shipping (EDCEI015)

azurecurveProductsEnhanced Intrastat (2788)InventoryInventory Intrastat Shipping (EDCEI015)

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: ivIntrastatShipping

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1IVDOCNBR SearchIV Document NumberStringSTR17_IV_Document_Number17
2IVDOCTYP SearchIV Document TypeIntegerDDL_IV_Document_Type0
3LOCNCODE SearchLocation CodeStringSTR10_Location_Code10
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'].LOCNCODE
4NAME SearchNameStringSTR3030
5ADRCNTCT SearchAddress ContactStringSTR6060
6ADDRESS1 SearchAddress 1StringSTR6060
7ADDRESS2 SearchAddress 2StringSTR6060
8ADDRESS3 SearchAddress 3StringSTR6060
9CITY SearchCityStringSTR3535
10STATE SearchStateStringSTR30_State29
11ZIPCODE SearchZip CodeStringSTR1010
12COUNTY SearchCountyStringSTR6060
13COUNTRY SearchCountryStringSTR6060
14BRNCHIDENTF SearchBranch IdentifierStringSTR2020
15PHONE1 SearchPhone 1StringPhone_Number14
16PHONE2 SearchPhone 2StringPhone_Number14
17FAX SearchFaxStringSTR14_FAX14
18SHIPMTHD SearchShipping MethodStringSTR15_Shipping_Method15
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'].SHIPMTHD
19TRANREGDTL1 SearchTransport Registration Details 1StringSTR3030
20TRANREGDTL2 SearchTransport Registration Details 2StringSTR3030
21TRANREGDTL3 SearchTransport Registration Details 3StringSTR3030
22DATE1 SearchDateDateDT66
23TIME1 SearchTimeTimeTM66
azurecurveProductsEnhanced Intrastat (2788)InventoryInventory Intrastat Shipping (EDCEI015)

Leave a Reply

Your email address will not be published. Required fields are marked *