Data Mapping Worksheet                      
New Changes 
New Changes 04/26/2007
New Changes 04/27/2007
Mapping Definitions (copy an existing row to permit recording your mappings)
  SOURCE SOURCE Source Destination
  IDOC - /SAPSLL/CCECUS01 (350 INTO GTS) IDOC - EVMSTA02 (350 INTO SCEM) SCEM/GTS[1] SAP Idoc SHPMNT05[2]   Sourcing Condition[3] Valid Values[4] Nullable?
(N or Y or leave blank)[5]		 Field Usage / Remarks[6]
Item Table[7] Field DATA TYPE Length Table[8] Field DATA TYPE Length Table Name[9] Field Name[10] Description DATA TYPE Length Table Name[11] Field Name[12] Data Type Field Length Business Rule Logic / Conversion Logic / Default[13]
eg[14]                 Shipments         Shipment STATE     Default = "OH" when a shipment order is aproved   No  
eg                 Shipments                          
                                             
                                             
1         E1EVMPAR IF PARAM_NAME = "TRANS_MODE",  GET THE PARAM_VALUE Char 32 / 20 SAPTRX/EH_CNTRL/
(04/09/2007 Jerry)
(04/19/2007 Eduardo)		 TRANS_MODE Mode of transportation
 CHAR 5 E1EDL24 POSNR CHAR 6   1. SELECT EH_GUID FROM /SAPTRX/EH_HDR WHERE
    TRACKINGIDTYPE = 'SHNR' AND
    TRACKINGID = 'E1EVMTID (SEGMENT)-TRXID

2.  SELECT PARAM_VALUE FROM COLUMN 'J' WHERE
     EH_GUID = EH_GUID FROM STEP 1 ABOVE AND
     PARAM_NAME = COLUMN 'K' AND
     SEQ_		 SCEM  vs. GIS
Ocean = 10
Air = 40		   Values should be converted to numeric entries when passed to GIS
2         E1EVMPAR IF PARAM_NAME = "ORIGIN_CTRY",  GET THE PARAM_VALUE Char 32 / 20 /saptrx/eh_cntrl/ ORIGIN_CTRY Port of Lading UN Codes[15] CHAR 2 E1EDL24 
CHARG		 CHAR 10   1. SELECT EH_GUID FROM /SAPTRX/EH_HDR WHERE
    TRACKINGIDTYPE = 'SHNR' AND
    TRACKINGID = 'E1EVMTID (SEGMENT)-TRXID

2.  SELECT PARAM_VALUE FROM COLUMN 'J' WHERE
     EH_GUID = EH_GUID FROM STEP 1 ABOVE AND
     PARAM_NAME = COLUMN 'K' AND
     SEQ_		      
4         E1EVMPAR IF PARAM_NAME = "VESSEL_NAME",  GET THE PARAM_VALUE Char 32 / 20 /SAPTRX/EH_CNTRL VESSEL_NAME Ocean Vessel Name CHAR 20 E1EDL24  ORKTX : Description of Article Entered  CHAR 40   1. SELECT EH_GUID FROM /SAPTRX/EH_HDR WHERE
    TRACKINGIDTYPE = 'SHNR' AND
    TRACKINGID = 'E1EVMTID (SEGMENT)-TRXID

2.  SELECT PARAM_VALUE FROM COLUMN 'J' WHERE
     EH_GUID = EH_GUID FROM STEP 1 ABOVE AND
     PARAM_NAME = COLUMN 'K' AND
     SEQ_		 Either VESSEL_NAME  or AIR_CARRIER_NAME    
5           IF PARAM_NAME = "CARRIER",  GET THE PARAM_VALUE     /SAPTRX/EH_CNTRL CARRIER_ID Air Carrier IATA Code CHAR 3 E1EDT20 SIGNI CHAR 20   1. SELECT EH_GUID FROM /SAPTRX/EH_HDR WHERE
    TRACKINGIDTYPE = 'SHNR' AND
    TRACKINGID = 'E1EVMTID (SEGMENT)-TRXID

2.  SELECT PARAM_VALUE FROM COLUMN 'J' WHERE
     EH_GUID = EH_GUID FROM STEP 1 ABOVE AND
     PARAM_NAME = COLUMN 'K' AND
     SEQ_		 Either SCAC or CARRIER    
6           IF PARAM_NAME = "AIR_CARRIER_NAME",  GET THE PARAM_VALUE     /SAPTRX/EH_INFO/ AIR_CARRIER_NAME Air Carrier Name CHAR 20 E1EDL24  ORKTX : Description of Article Entered  CHAR 40   1. SELECT EH_GUID FROM /SAPTRX/EH_HDR WHERE
    TRACKINGIDTYPE = 'SHNR' AND
    TRACKINGID = 'E1EVMTID (SEGMENT)-TRXID

2.  SELECT PARAM_VALUE FROM COLUMN 'J' WHERE
     EH_GUID = EH_GUID FROM STEP 1 ABOVE AND
     PARAM_NAME = COLUMN 'K' AND
     SEQ_		 Either VESSEL_NAME  or AIR_CARRIER_NAME    
7         E1EVMPAR IF PARAM_NAME = "ARRIVING_FLIGHT_NUMBER",  GET THE PARAM_VALUE Char 32 / 20 /SAPTRX/EH_INFO/ ARRIVING_FLIGHT_NUMBER  Air Flight Number CHAR 20 E1EDL24  ARKTX : Short text for sales order item  CHAR 40   1. SELECT EH_GUID FROM /SAPTRX/EH_HDR WHERE
    TRACKINGIDTYPE = 'SHNR' AND
    TRACKINGID = 'E1EVMTID (SEGMENT)-TRXID

2.  SELECT PARAM_VALUE FROM COLUMN 'J' WHERE
     EH_GUID = EH_GUID FROM STEP 1 ABOVE AND
     PARAM_NAME = COLUMN 'K' AND
     SEQ_N		      
8         ? ?     /SAPSLL/LEGDOC
PAPTY = ZDC002		 PAPNO Customs Entry Number CHAR 35 E1EDL24  MFRPN : Manufacturer part number  CHAR 40   SCEM: -
1. SELECT EH_GUID FROM /SAPTRX/EH_HDR WHERE
    TRACKINGIDTYPE = 'SHNR' AND
    TRACKINGID = 'E1EVMTID (SEGMENT)-TRXID

2.  SELECT PARAM_VALUE FROM /SAPTRX/EH_INFO WHERE
     EH_GUID = EH_GUID FROM STEP 1 ABOVE AND
     PARAM_NAME = 'HAWBFCR' AN		 1A (Available for Processing), 2A (Processing Blocked - Awaiting Reply from Authorities), 3A (Processing Restricted - Document Registered with Authorities) or 3B (Processing Restricted - Document Completed)    
9         E1EVMPAR IF PARAM_NAME = "TDP_QTY_TOTAL_CTN" or "DP_QTY_TOTAL_CTN",  GET THE PARAM_VALUE Char 32 / 20 /SAPTRX/EH_INFO SHIPMENT_CTNS  Carton Count CHAR 13 E1EDL24  LFIMG : Actual quantity delivered (in sales units)  CHAR 13   1  SELECT GUID AOT
   FROM TABLE /SAPTRX/EH_HDR
   WHERE TrackingIDType = HAWBFCR &
                 TrackingID = EVMSTA02-E1EVMTID-TRXID

   IF(AOType = SHIPMENT_OCEAN_INT,   
2.1     SELECT DP_QTY_TOTAL_CTN
             FROM /SAPTRX/EH_INFO
         		      
10         ? ?     /SAPSLL/LEGDOC
PAPTY = ZFL001		 PAPNO  Live Entry Flag CHAR 35 E1EDL24  KDMAT35 : Article belonging to the customer  CHAR 35   SCEM: -
1. SELECT EH_GUID FROM /SAPTRX/EH_HDR WHERE
    TRACKINGIDTYPE = 'SHNR' AND
    TRACKINGID = 'E1EVMTID (SEGMENT)-TRXID

2.  SELECT PARAM_VALUE FROM /SAPTRX/EH_INFO WHERE
     EH_GUID = EH_GUID FROM STEP 1 ABOVE AND
     PARAM_NAME = 'HAWBFCR' AN		      
11         E1EVMPAR IF PARAM_NAME = "CUSTOMS_DISTRICT_ID",  GET THE PARAM_VALUE Char 32 / 20 EVMSTA02-E1EVMPAR
WHEN PARAM_NAME =
CUSTOMS_DISTRICT_ID		 PARAM_VALUE Customs District CHAR 30 E1EDL24  USR04 CHAR 35   IF EVMSTA02-E1EVMPAR-PARAM_NAME = "CUSTOMS_DISTRICT_ID"
THEN GET EVMSTA02-E1EVMPAR-PARAM_VALUE 		      
12         E1EVMPAR IF PARAM_NAME = "PORT_OF_ENTRY_ETA_DATE",  GET THE PARAM_VALUE Char 32 / 20 /SAPTRX/EH_INFO/ PORT_OF_ENTRY_ETA_DATE  ETA Date CHAR 8 E1EDL24  VFDAT : Shelf Life Expiration Date DATS 8   1. SELECT EH_GUID FROM /SAPTRX/EH_HDR WHERE
    TRACKINGIDTYPE = 'SHNR' AND
    TRACKINGID = 'E1EVMTID (SEGMENT)-TRXID

2.  SELECT PARAM_VALUE FROM COLUMN 'J' WHERE
     EH_GUID = EH_GUID FROM STEP 1 ABOVE AND
     PARAM_NAME = COLUMN 'K' AND
     SEQ_		      
13         E1EVMHDR02 ` Char 35 ZZEVNTDESC ZZ_EVT_DESC Event Description CHAR 30 E1EDL24  MATWA_EXTERNAL CHAR 40 E1EDL24 repeats for each event code. Z table dedtails found below. (Z-table to be built in GTS)
1. SELECT EH_GUID FROM /SAPTRX/EH_HDR WHERE
    TRACKINGIDTYPE = 'SHNR' AND
    TRACKINGID = 'E1EVMTID (SEGMENT)-TRXID

2.  SELECT PARAM_VALUE FROM COLUMN 'J' WHERE
     EH_GUID = EH_GUID FROM S		     Z-table to be built in GTS
14         E1EVMHDR02 EVTDAT DATE 8 /SAPSLL/LEGDOC
PAPTY = ZDT030		 PAPDT Customs Export Date DATE 8 E1EDL24  ABRDT : Delivery Schedule Date  DATS 8   SCEM: -
1. SELECT EH_GUID FROM /SAPTRX/EH_HDR WHERE
    TRACKINGIDTYPE = 'SHNR' AND
    TRACKINGID = 'E1EVMTID (SEGMENT)-TRXID

2.  SELECT PARAM_VALUE FROM /SAPTRX/EH_INFO WHERE
     EH_GUID = EH_GUID FROM STEP 1 ABOVE AND
     PARAM_NAME = 'HAWBFCR' AN		      
15                 /SAPSLL/LEGDOC
PAPTY = ZDT030		 PAPAD Customs Export Time & Time Zone CHAR 26 E1EDL24 USR01 CHAR 35          
16         E1EVMHDR02 EVTDAT DATE 8 /SAPSLL/LEGDOC
PAPTY = ZDT031		 PAPDT Customs IT Date[16] CHAR 8 E1EDL24  ABRDT : Delivery Schedule Date  DATS 8   SCEM: -
1. SELECT EH_GUID FROM /SAPTRX/EH_HDR WHERE
    TRACKINGIDTYPE = 'SHNR' AND
    TRACKINGID = 'E1EVMTID (SEGMENT)-TRXID

2.  SELECT PARAM_VALUE FROM /SAPTRX/EH_INFO WHERE
     EH_GUID = EH_GUID FROM STEP 1 ABOVE AND
     PARAM_NAME = 'HAWBFCR' AN		      
17                 /SAPSLL/LEGDOC
PAPTY = ZDT031		 PAPAD Customs IT Time & Time Zone CHAR 26 E1EDL24 USR01 CHAR 35          
18         E1EVMHDR02 EVTDAT DATE 8 /SAPSLL/LEGDOC
PAPTY = ZDT032		 PAPDT Customs File Open Date CHAR 8 E1EDL24  ABRDT : Delivery Schedule Date  DATS 8   SCEM: -
1. SELECT EH_GUID FROM /SAPTRX/EH_HDR WHERE
    TRACKINGIDTYPE = 'SHNR' AND
    TRACKINGID = 'E1EVMTID (SEGMENT)-TRXID

2.  SELECT PARAM_VALUE FROM /SAPTRX/EH_INFO WHERE
     EH_GUID = EH_GUID FROM STEP 1 ABOVE AND
     PARAM_NAME = 'HAWBFCR' AN		      
19                 /SAPSLL/LEGDOC
PAPTY = ZDT032		 PAPAD Customs File Open Time & Time Zone CHAR 26 E1EDL24 USR01 CHAR 35          
20         E1EVMHDR02 EVTDAT DATE 8 /SAPSLL/LEGDOC
PAPTY = ZDT056		 PAPDT Customs Missing Documents Notification Date CHAR 8 E1EDL24  ABRDT : Delivery Schedule Date  DATS 8   SCEM: -
1. SELECT EH_GUID FROM /SAPTRX/EH_HDR WHERE
    TRACKINGIDTYPE = 'SHNR' AND
    TRACKINGID = 'E1EVMTID (SEGMENT)-TRXID

2.  SELECT PARAM_VALUE FROM /SAPTRX/EH_INFO WHERE
     EH_GUID = EH_GUID FROM STEP 1 ABOVE AND
     PARAM_NAME = 'HAWBFCR' AN		     File opened & if missing docs. text, provide the File opened date.
/SAPSLL/LEGDOC-PAPTY=ZDT032 = 120 File Opened Date + If V902-106 = '120' and N903-369 not blank, 

IF ZDT056 is available, but no DATE, TIME or TIME ZONE has been provided, provide the D
21                 /SAPSLL/LEGDOC
PAPTY = ZDT056		 PAPAD Customs Missing Documents Notification Time & Time Zone CHAR 26 E1EDL24 USR01 CHAR 35         File opened & if missing docs. text, provide the File opened date.
/SAPSLL/LEGDOC-PAPTY=ZDT032 = 120 File Opened Date + If V902-106 = '120' and N903-369 not blank, 

IF ZDT056 is available, but no DATE, TIME or TIME ZONE has been provided, provide the D
22         E1EVMHDR02 EVTDAT DATE 8 /SAPSLL/LEGDOC
PAPTY = ZDT033		 PAPDT Customs Documents Received Date CHAR 8 E1EDL24  ABRDT : Delivery Schedule Date  DATS 8   SCEM: -
1. SELECT EH_GUID FROM /SAPTRX/EH_HDR WHERE
    TRACKINGIDTYPE = 'SHNR' AND
    TRACKINGID = 'E1EVMTID (SEGMENT)-TRXID

2.  SELECT PARAM_VALUE FROM /SAPTRX/EH_INFO WHERE
     EH_GUID = EH_GUID FROM STEP 1 ABOVE AND
     PARAM_NAME = 'HAWBFCR' AND		      
23                 /SAPSLL/LEGDOC
PAPTY = ZDT033		 PAPAD Customs Documents Received Time & Time Zone CHAR 26 E1EDL24 USR01 CHAR 35          
24         E1EVMHDR02 EVTDAT DATE 8 /SAPSLL/LEGDOC
PAPTY = ZDT034		 PAPDT Documents to Customs Date CHAR 8 E1EDL24  ABRDT : Delivery Schedule Date  DATS 8   SCEM: -
1. SELECT EH_GUID FROM /SAPTRX/EH_HDR WHERE
    TRACKINGIDTYPE = 'SHNR' AND
    TRACKINGID = 'E1EVMTID (SEGMENT)-TRXID

2.  SELECT PARAM_VALUE FROM /SAPTRX/EH_INFO WHERE
     EH_GUID = EH_GUID FROM STEP 1 ABOVE AND
     PARAM_NAME = 'HAWBFCR' AND		      
25                 /SAPSLL/LEGDOC
PAPTY = ZDT034		 PAPAD Documents to Customs Time & Time Zone CHAR 26 E1EDL24 USR01 CHAR 35          
26         E1EVMHDR02 EVTDAT DATE 8 /SAPSLL/LEGDOC
PAPTY = ZDT058		 PAPDT Customs Missing Documents Date CHAR 8 E1EDL24  ABRDT : Delivery Schedule Date  DATS 8   SCEM: -
1. SELECT EH_GUID FROM /SAPTRX/EH_HDR WHERE
    TRACKINGIDTYPE = 'SHNR' AND
    TRACKINGID = 'E1EVMTID (SEGMENT)-TRXID

2.  SELECT PARAM_VALUE FROM /SAPTRX/EH_INFO WHERE
     EH_GUID = EH_GUID FROM STEP 1 ABOVE AND
     PARAM_NAME = 'HAWBFCR' AN		     Complete documentation received by customs & if missing docs. text, provide the complete docs received by customs date.
/SAPSLL/LEGDOC-PAPTY=ZDT034 = 135 Complete documentation received by customs (MAST) + If V902-106 = '135' and N903-369 not blank, 

I
27                 /SAPSLL/LEGDOC
PAPTY = ZDT058		 PAPAD Customs Missing Documents Time & Time Zone CHAR 26 E1EDL24 USR01 CHAR 35         Complete documentation received by customs & if missing docs. text, provide the complete docs received by customs date.
/SAPSLL/LEGDOC-PAPTY=ZDT034 = 135 Complete documentation received by customs (MAST) + If V902-106 = '135' and N903-369 not blank, 

I
28         E1EVMHDR02 EVTDAT DATE 8 /SAPSLL/LEGDOC
PAPTY = ZDT036		 PAPDT Customs Entry ABI Date CHAR 8 E1EDL24  ABRDT : Delivery Schedule Date  DATS 8   SCEM: -
1. SELECT EH_GUID FROM /SAPTRX/EH_HDR WHERE
    TRACKINGIDTYPE = 'SHNR' AND
    TRACKINGID = 'E1EVMTID (SEGMENT)-TRXID

2.  SELECT PARAM_VALUE FROM /SAPTRX/EH_INFO WHERE
     EH_GUID = EH_GUID FROM STEP 1 ABOVE AND
     PARAM_NAME = 'HAWBFCR' AN		      
29                 /SAPSLL/LEGDOC
PAPTY = ZDT036		 PAPAD Customs Entry ABI Time & Time Zone CHAR 26 E1EDL24 USR01 CHAR 35          
30         E1EVMHDR02 EVTDAT DATE 8 /SAPSLL/LEGDOC
PAPTY = ZDT037		 PAPDT Customs Exam Ordered Date CHAR 8 E1EDL24  ABRDT : Delivery Schedule Date  DATS 8   SCEM: -
1. SELECT EH_GUID FROM /SAPTRX/EH_HDR WHERE
    TRACKINGIDTYPE = 'SHNR' AND
    TRACKINGID = 'E1EVMTID (SEGMENT)-TRXID

2.  SELECT PARAM_VALUE FROM /SAPTRX/EH_INFO WHERE
     EH_GUID = EH_GUID FROM STEP 1 ABOVE AND
     PARAM_NAME = 'HAWBFCR' AN		      
31                 /SAPSLL/LEGDOC
PAPTY = ZDT037		 PAPAD Customs Exam Ordered Time & Time Zone CHAR 26 E1EDL24 USR01 CHAR 35          
32         E1EVMHDR02 EVTDAT DATE 8 /SAPSLL/LEGDOC
PAPTY = ZDT038		 PAPDT Customs Transfer Order Exam Date CHAR 8 E1EDL24  ABRDT : Delivery Schedule Date  DATS 8   SCEM: -
1. SELECT EH_GUID FROM /SAPTRX/EH_HDR WHERE
    TRACKINGIDTYPE = 'SHNR' AND
    TRACKINGID = 'E1EVMTID (SEGMENT)-TRXID

2.  SELECT PARAM_VALUE FROM /SAPTRX/EH_INFO WHERE
     EH_GUID = EH_GUID FROM STEP 1 ABOVE AND
     PARAM_NAME = 'HAWBFCR' AN		      
33                 /SAPSLL/LEGDOC
PAPTY = ZDT038		 PAPAD Customs Transfer Order Exam Time & Time Zone CHAR 26 E1EDL24 USR01 CHAR 35          
34         E1EVMHDR02 EVTDAT DATE 8 /SAPSLL/LEGDOC
PAPTY = ZDT039		 PAPDT Customs Conditional Release Date CHAR 8 E1EDL24  ABRDT : Delivery Schedule Date  DATS 8   SCEM: -
1. SELECT EH_GUID FROM /SAPTRX/EH_HDR WHERE
    TRACKINGIDTYPE = 'SHNR' AND
    TRACKINGID = 'E1EVMTID (SEGMENT)-TRXID

2.  SELECT PARAM_VALUE FROM /SAPTRX/EH_INFO WHERE
     EH_GUID = EH_GUID FROM STEP 1 ABOVE AND
     PARAM_NAME = 'HAWBFCR' AN		      
35                 /SAPSLL/LEGDOC
PAPTY = ZDT039		 PAPAD Customs Conditional Release Time & Time Zone CHAR 26 E1EDL24 USR01 CHAR 35          
36         E1EVMHDR02 EVTDAT DATE 8 /SAPSLL/LEGDOC
PAPTY = ZDT040		 PAPDT Customs Release Date CHAR 8 E1EDL24  ABRDT : Delivery Schedule Date  DATS 8   SCEM: -
1. SELECT EH_GUID FROM /SAPTRX/EH_HDR WHERE
    TRACKINGIDTYPE = 'SHNR' AND
    TRACKINGID = 'E1EVMTID (SEGMENT)-TRXID

2.  SELECT PARAM_VALUE FROM /SAPTRX/EH_INFO WHERE
     EH_GUID = EH_GUID FROM STEP 1 ABOVE AND
     PARAM_NAME = 'HAWBFCR' AN		      
37                 /SAPSLL/LEGDOC
PAPTY = ZDT040		 PAPAD Customs Release Time & Time Zone CHAR 26 E1EDL24 USR01 CHAR 35          
38         E1EVMHDR02 EVTDAT DATE 8 /SAPSLL/LEGDOC
PAPTY = ZDT041		 PAPDT Customs Entry Release Packet Date CHAR 8 E1EDL24  ABRDT : Delivery Schedule Date  DATS 8   SCEM: -
1. SELECT EH_GUID FROM /SAPTRX/EH_HDR WHERE
    TRACKINGIDTYPE = 'SHNR' AND
    TRACKINGID = 'E1EVMTID (SEGMENT)-TRXID

2.  SELECT PARAM_VALUE FROM /SAPTRX/EH_INFO WHERE
     EH_GUID = EH_GUID FROM STEP 1 ABOVE AND
     PARAM_NAME = 'HAWBFCR' AN		      
39                 /SAPSLL/LEGDOC
PAPTY = ZDT041		 PAPAD Customs Entry Release Packet Time & Time Zone CHAR 26 E1EDL24 USR01 CHAR 35          
40         E1EVMHDR02 EVTDAT DATE 8 /SAPSLL/LEGDOC
PAPTY = ZDT042		 PAPDT Customs OGA File Date CHAR 8 E1EDL24  ABRDT : Delivery Schedule Date  DATS 8   SCEM: -
1. SELECT EH_GUID FROM /SAPTRX/EH_HDR WHERE
    TRACKINGIDTYPE = 'SHNR' AND
    TRACKINGID = 'E1EVMTID (SEGMENT)-TRXID

2.  SELECT PARAM_VALUE FROM /SAPTRX/EH_INFO WHERE
     EH_GUID = EH_GUID FROM STEP 1 ABOVE AND
     PARAM_NAME = 'HAWBFCR' AN		      
41                 /SAPSLL/LEGDOC
PAPTY = ZDT042		 PAPAD Customs OGA File Time & Time Zone CHAR 26 E1EDL24 USR01 CHAR 35          
42         E1EVMHDR02 EVTDAT DATE 8 /SAPSLL/LEGDOC
PAPTY = ZDT043		 PAPDT Customs OGA Inspection Date CHAR 8 E1EDL24  ABRDT : Delivery Schedule Date  DATS 8   SCEM: -
1. SELECT EH_GUID FROM /SAPTRX/EH_HDR WHERE
    TRACKINGIDTYPE = 'SHNR' AND
    TRACKINGID = 'E1EVMTID (SEGMENT)-TRXID

2.  SELECT PARAM_VALUE FROM /SAPTRX/EH_INFO WHERE
     EH_GUID = EH_GUID FROM STEP 1 ABOVE AND
     PARAM_NAME = 'HAWBFCR' AN		      
43                 /SAPSLL/LEGDOC
PAPTY = ZDT043		 PAPAD Customs OGA Inspection Time & Time Zone CHAR 26 E1EDL24 USR01 CHAR 35          
44         E1EVMHDR02 EVTDAT DATE 8 /SAPSLL/LEGDOC
PAPTY = ZDT044		 PAPDT Customs OGA Release Date CHAR 8 E1EDL24  ABRDT : Delivery Schedule Date  DATS 8   SCEM: -
1. SELECT EH_GUID FROM /SAPTRX/EH_HDR WHERE
    TRACKINGIDTYPE = 'SHNR' AND
    TRACKINGID = 'E1EVMTID (SEGMENT)-TRXID

2.  SELECT PARAM_VALUE FROM /SAPTRX/EH_INFO WHERE
     EH_GUID = EH_GUID FROM STEP 1 ABOVE AND
     PARAM_NAME = 'HAWBFCR' AN		      
45                 /SAPSLL/LEGDOC
PAPTY = ZDT044		 PAPAD Customs OGA Release Time & Time Zone CHAR 26 E1EDL24 USR01 CHAR 35          
46         E1EVMHDR02 EVTDAT DATE 8 /SAPSLL/LEGDOC
PAPTY = ZDT045		 PAPDT Customs DO Issue Date CHAR 8 E1EDL24  ABRDT : Delivery Schedule Date  DATS 8   SCEM: -
1. SELECT EH_GUID FROM /SAPTRX/EH_HDR WHERE
    TRACKINGIDTYPE = 'SHNR' AND
    TRACKINGID = 'E1EVMTID (SEGMENT)-TRXID

2.  SELECT PARAM_VALUE FROM /SAPTRX/EH_INFO WHERE
     EH_GUID = EH_GUID FROM STEP 1 ABOVE AND
     PARAM_NAME = 'HAWBFCR' AN		      
47                 /SAPSLL/LEGDOC
PAPTY = ZDT045		 PAPAD Customs DO Issue Time & Time Zone CHAR 26 E1EDL24 USR01 CHAR 35          
48         ? ?     /SAPSLL/LEGDOC
PAPTY = ZDT042
ZDC022
(Eduardo 04/19/2007)		 PAPNO OGA Code CHAR 35 E1EDL24  KANNR CHAR 35   SCEM: -
1. SELECT EH_GUID FROM /SAPTRX/EH_HDR WHERE
    TRACKINGIDTYPE = 'SHNR' AND
    TRACKINGID = 'E1EVMTID (SEGMENT)-TRXID

2.  SELECT PARAM_VALUE FROM /SAPTRX/EH_INFO WHERE
     EH_GUID = EH_GUID FROM STEP 1 ABOVE AND
     PARAM_NAME = 'HAWBFCR' AN		      
49         E1EVMPAR IF PARAM_NAME = "CPO",  GET THE PARAM_VALUE     /saptrx/eh_trkid/
/SAPTRX/EH_INFO		 CPO_NUMBER CPO Number CHAR 30 E1EDL24  MATWA_GUID CHAR 32   1. SELECT EH_GUID FROM /SAPTRX/EH_HDR WHERE
    TRACKINGIDTYPE = 'SHNR' AND
    TRACKINGID = 'E1EVMTID (SEGMENT)-TRXID

2.  SELECT PARAM_VALUE FROM COLUMN 'J' WHERE
     EH_GUID = EH_GUID FROM STEP 1 ABOVE AND
     PARAM_NAME = COLUMN 'K' AND
     SEQ_		      
50                 /SAPTRX/EH_INFO/ SCAC Ocean Carrier SCAC/Vessel Code CHAR 4 E1EDT20 SIGNI CHAR 20      SELECT GUID
   FROM TABLE /SAPTRX/EH_HDR
   WHERE TrackingIDType = SHNR (Shipment Project Number in PO EH)
                 TrackingID = 'E1EVMTID (SEGMENT)-TRXID 
                 AOType = SHIPMENT_OCEAN_INT ; If Event Code = 3 (AS Ocean Shipment)
 		      
51         E1EVMPAR IF PARAM_NAME = "OBOL",  GET THE PARAM_VALUE Char 32 / 20 /SAPTRX/EH_TRKID/
/SAPTRX/EH_CNTRL		 OBOL Ocean OBOL CHAR 30 E1EDL20 BOLNR CHAR 35   1. SELECT EH_GUID FROM /SAPTRX/EH_HDR WHERE
    TRACKINGIDTYPE = 'SHNR' AND
    TRACKINGID = 'E1EVMTID (SEGMENT)-TRXID

2.  SELECT PARAM_VALUE FROM COLUMN 'J' WHERE
     EH_GUID = EH_GUID FROM STEP 1 ABOVE AND
     PARAM_NAME = COLUMN 'K' AND
     SEQ_		      
52         E1EVMPAR IF PARAM_NAME = "MAWB",  GET THE PARAM_VALUE Char 32 / 20 /SAPTRX/EH_TRKID/
/SAPTRX/EH_CNTRL		 MAWB Air MAWB CHAR 20 E1EDL20 BOLNR CHAR 35   1. SELECT EH_GUID FROM /SAPTRX/EH_HDR WHERE
    TRACKINGIDTYPE = 'SHNR' AND
    TRACKINGID = 'E1EVMTID (SEGMENT)-TRXID

2.  SELECT PARAM_VALUE FROM COLUMN 'J' WHERE
     EH_GUID = EH_GUID FROM STEP 1 ABOVE AND
     PARAM_NAME = COLUMN 'K' AND
     SEQ_		      
53         E1EVMTID TRXCOD Char 20 EVMSTA02-E1EVMTID TRXID Air HAWB CHAR 20 E1EDL20 LIFEX CHAR 35   If EVMSTA02-E1EVMTID-TRXCOD = "HAWBFCR"
Then Get EVMSTA02-E1EVMTID-TRXID		      
54         E1EVMTID TRXCOD Char 20 EVMSTA02-E1EVMTID TRXID FCR CHAR 20 E1EDL20 LIFEX CHAR 35   If EVMSTA02-E1EVMTID-TRXCOD = "HAWBFCR"
Then Get EVMSTA02-E1EVMTID-TRXID		      
55         E1EVMPAR IF PARAM_NAME = "CONTAINER_NUMBER",  GET THE PARAM_VALUE Char 32 / 20 /SAPTRX/EH_CNTRL CONTAINER_NUMBER Ocean Container SCAC & Number CHAR 20 E1EDL24  ZUDAT CHAR 20   Logic is required on the GIS side to parse the information accordingly
First 4 chars = SCAC
5th character until 15th = Container Number		      
56         ? ?     /SAPSLL/LEGDOC
PAPTY = ZDT001		 PAPNO IT Number[17] CHAR 35 E1EDL24  USR02 : Additional data field 2 for delivery schedules  CHAR 35   SCEM: -
1. SELECT EH_GUID FROM /SAPTRX/EH_HDR WHERE
    TRACKINGIDTYPE = 'SHNR' AND
    TRACKINGID = 'E1EVMTID (SEGMENT)-TRXID

2.  SELECT PARAM_VALUE FROM COLUMN 'J' WHERE
     EH_GUID = EH_GUID FROM STEP 1 ABOVE AND
     PARAM_NAME = 'HAWBFCR' AND
  		      
57         ? ?     /SAPSLL/LEGDOC PAPNO HTS Number CHAR 35 E1EDL24  USR03 : Additional data field 3 for delivery schedules  CHAR 35   See Mapping Logic in the Getting HTS Number in GTS tab      
58         ? ?     /SAPSLL/LEGDOC
PAPTY = ZDT006		 PAPNO Broker File Number CHAR 35 E1EDL24  MATNR_EXTERNAL : Article Number  CHAR 40   SCEM: -
1. SELECT EH_GUID FROM /SAPTRX/EH_HDR WHERE
    TRACKINGIDTYPE = 'SHNR' AND
    TRACKINGID = 'E1EVMTID (SEGMENT)-TRXID

2.  SELECT PARAM_VALUE FROM COLUMN 'J' WHERE
     EH_GUID = EH_GUID FROM STEP 1 ABOVE AND
     PARAM_NAME = 'HAWBFCR' AND
  		      
59         ? ? ? ? /SAPSLL/LEGTPR NODAR Port of Unlading Code CHAR 4 E1EDT20 TKNUM CHAR 10   SCEM: -
1. SELECT EH_GUID FROM /SAPTRX/EH_HDR WHERE
    TRACKINGIDTYPE = 'SHNR' AND
    TRACKINGID = 'E1EVMTID (SEGMENT)-TRXID

2.  SELECT PARAM_VALUE FROM COLUMN 'J' WHERE
     EH_GUID = EH_GUID FROM STEP 1 ABOVE AND
     PARAM_NAME = 'HAWBFCR' AND
  		      
60         ? ? ? ? /SAPSLL/LEGDOC
PAPTY = ZDC001		 PAPNO Location of Goods/Location Identifier CHAR 30 E1EDL24  MATNR_GUID CHAR 32   /SAPSLL/E1CCEIDO-QALDOC='PDOC' (Presented Document)
/SAPSLL/E1CCEIDO-PAPTY='ZDC006' 
/SAPSLL/E1CCEIDO-PAPNO = N902		      
61                 /SAPTRX/EH_INFO VOYAGE Ocean Voyage Number CHAR 10 E1EDL23: Deliv.Header Addit.Data Descriptions TRSPG_BEZ: Description of reason for shipment block CHAR 10          
62                 /SAPTRX/EH_INFO PORT_OF_ENTRY_ETA_TIME ETA Port of Entry Time TIMS 6 E1EDL24 USR05 CHAR 10          
63                 /SAPTRX/EH_INFO PORT_OF_ENTRY_ETA_TZONE ETA Port of Entry Time Zone CHAR 6 E1EDL24 POSEX CHAR 6          
65                 EDIDC  ARCKEY EDI Archive Key CHAR 70 EDIDC  ARCKEY CHAR 70          
   
[1]
Aaron Rorstrom:
"Required"
Record the name of the source system
[2]
Aaron Rorstrom:
"Required"
Record the name of the destination system
[3]
Aaron Rorstrom:
"Required" if applicable
Record the condition, if any, in which the source will upate the destination.
[4]
Aaron Rorstrom:
"Required" if applicable
Record the list of acceptable values or a document that specifies the accaptable values.
[5]
Aaron Rorstrom:
"Required" if applicable
[6]
Aaron Rorstrom:
"Optional"
[7]
Aaron Rorstrom:
"Required"
A field name recorded in this column should be defined on one of the DB & Fld Defs worksheets.
[8]
Aaron Rorstrom:
"Required"
A field name recorded in this column should be defined on one of the DB & Fld Defs worksheets.
[9]
Aaron Rorstrom:
"Required"
[10]
Aaron Rorstrom:
"Required"
A field name recorded in this column should be defined on one of the DB & Fld Defs worksheets.
[11]
Aaron Rorstrom:
"Required"
[12]
Aaron Rorstrom:
"Required"
A field name recorded in this column should be defined on one of the DB & Fld Defs worksheets.
[13]
Aaron Rorstrom:
"Optional"
[14]
Aaron Rorstrom:
This row is an example.
[15]
LTS User:
Do we want to do the translation from existing codes when it's in GIS?
[16]
LTS User:
In Transit Number Date
[17]
LTS User:
In Transit Number