Data Mapping Worksheet                          
                           
Legend <-- New mapping change for 05/17/07                        
                           
  (copy an existing row to permit recording your mappings)                        
Source         Destination            
OV.02.03 - Outbound 861         Idoc - SHPMNT04   Sourcing Condition[1] Valid Values[2] Nullable?
(N or Y or leave blank)[3]		 Field Usage / Remarks[4]  
Table Name Field Name Description Data Type  Field Length   Segment Field Name    
Shipments           Shipment STATE   when a shipment order is aproved   No    
E1EVMTID
TRXID
when TRXCOD = 'HAWBFCR'		 Air HAWB or
Ocean FCR		 CHAR 30   E1EDL20: Delivery header  BOLNR: Bill of lading (CHAR 35) (CHAR 35)          
  Hardcode text:
'Limited Logistics Services'		 Service Provider to whom the shipment was tendered CHAR 32   E1EDT57 TNDR_TRKID Forwarding Agent Tracking ID  (Char 35)          
E1EVMEEM
(E1)
If not found in IDoc, then get data from
/SAPTRX/EH_EXPEV 		  ETXDAT when EVTID = 'OCEAN_DEP' or 'AIR_DEP_PORT'
If not found in IDoc, then get data from

Position 2-9 of EVENT_EXP_DATE where EVENT_CODE = 'OCEAN_DEP' or 'AIR_DEPART_PORT'		 Scheduled Departure Date CHAR 8   E1EDT10
(QUALF = 009)		 ISDD Actual start: Execution (date)  (DATS 8)          
E1EVMEEM
(E1)
If not found in IDoc, then get data from
/SAPTRX/EH_EXPEV 		  ETXTIM when EVTID = 'OCEAN_DEP' or 'AIR_DEP_PORT'
If not found in IDoc, then get data from

Postion 10-15 of EVENT_EXP_DATE where EVENT_CODE = 'OCEAN_DEP' or 'AIR_DEPART_PORT'		 Scheduled Departure Time       E1EDT10
(QUALF = 009)		 ISDZ Actual start: Execution (date)  Char 6          
E1EVMEEM
(E1)
If not found in IDoc, then get data from
/SAPTRX/EH_EXPEV 		 ETXZON when EVTID = 'OCEAN_DEP' or 'AIR_DEP_PORT'
If not found in IDoc, then get data from EVENT_EXP_TZONE where EVENT_CODE = 'OCEAN_DEP' or 'AIR_DEPART_PORT'		 Scheduled Departure Time Zoine       E1EDT10
(QUALF = 009)		 TZONE_BEG Char 6          
 /SAPTRX/EH_HDR Postion 2-9 of (CREATED_DATE) Booking Date CHAR 8   E1EDT10
(QUALF = 009)		 IEDD (Actual finish: Execution (date)  (DATS 8)          
 /SAPTRX/EH_HDR Postion 10-15 of (CREATED_DATE) Booking Time CHAR 6   E1EDT10
(QUALF = 009)		 IEDZ Char 6          
E1EVMPAR
If not found in IDoc, then get data from
/SAPTRX/EH_INFO/
All events		 DOX_RECV_DATE

 Documents Received Date CHAR 8   E1EDT45 (Qualifier) Recommended: (QUALF = 005) ISDD Actual start: Execution (date)  (DATS 8)          
E1EVMPAR
If not found in IDoc, then get data from
/SAPTRX/EH_INFO/
All events		 DOX_RECV_TIME Documents Received Time CHAR 6   E1EDT45
(QUALF = 005)		 ISDZ Char 6          
E1EVMHDR02
856(E1)
If not found in IDoc, then get data from
/SAPTRX/EH_EXPEV		 EVTDAT when EVTID = 'CARGO_RECEIVED'
If not found in IDoc, then get data from
Position 2-9 of EVENT_DATE when EVENT_CODE = 'CARGO_RECEIVED'

 Cargo Received Date CHAR 8   E1EDT45
(QUALF = 005)		 IEDD (DATS 8)          
E1EVMHDR02
856(E1)
If not found in IDoc, then get data from
/SAPTRX/EH_EXPEV		 EVTTIM when EVTID = 'CARGO_RECEIVED'
If not found in IDoc, then get data from
Position 10-15 of EVENT_DATE when EVENT_CODE = 'CARGO_RECEIVED'		 Cargo Received Time CHAR 6   E1EDT45
(QUALF = 005)		 IEDZ Char 6          
E1EVMHDR02
856(E1)
If not found in IDoc, then get data from
/SAPTRX/EH_EXPEV		 EVTZON when EVTID = 'CARGO_RECEIVED'
If not found in IDoc, then get data from
EVENT_TZONE when EVENT_CODE = 'CARGO_RECEIVED'		 Cargo Received Time Zone CHAR 6   E1EDT45
(QUALF = 005)		 VSTGA Char 4          
/SAPTRX/EH_INFO
All events		 CPO_NUMBER CPO Number CHAR 20   E1EDL41 (Qualifier) Recommended: (QUALF = 001) BSTNR ) Customer purchase order number  (Char 30)           
/SAPTRX/EH_INFO SHIPMENT_CTNS Carton Count CHAR 10   E1EDL24 : Delivery Item  MATWA Article entered  (Char 18)           
/SAPTRX/EH_INFO SHIPMENT_WGT Gross Weight CHAR 30   E1EDL24 : Delivery Item  BRGEW : Gross weight  (QUAN 15)          
/SAPTRX/EH_INFO SHIPMENT_WGT_UNIT Gross Weight Unit of Measure CHAR 32   E1EDL24 MEINS Base Unit of Measure  (UNIT 3) 32        
n/a n/a Vendor Name CHAR 35   E1EDL24 ARKTX  Short text for sales order item  (Char 40) MAST INDUSTRIES, INC.'        
ZXPARAMS n/a Vendor ID CHAR 32   E1EDL24 ORKTX Description of Article Entered  (Char 40) Use 1st character of CPO_NUMBER to get value from ZXPARAMS table.
(See mapping of OV.02.01 for working logic)		        
E1EVMEEM
(E4)
If not found in IDoc, then get data from
/SAPTRX/EH_EXPEV 		 ETXDAT when EVTID = 'CFS_ARRIVAL'

If not found in IDoc, then get data from
Postion 2-9 of (EVENT_EXP_DATE)
When EVENT_CODE = "CFS_ARRIVAL"		 Delivery Date to CFS DATS 8   E1EDT13
(QUALF = 005)		 IEDD Char 8          
E1EVMEEM
(E4)
If not found in IDoc, then get data from
/SAPTRX/EH_EXPEV 		 ETXTIM when EVTID = 'CFS_ARRIVAL'

If not found in IDoc, then get data from
Postion 10-15 of (EVENT_EXP_DATE)
When EVENT_CODE = "CFS_ARRIVAL"		 Delivery Time to CFS CHAR 6   E1EDT13
(QUALF = 005)		 IEDZ Char 6          
/SAPTRX/EH_INFO SHIPMENT_VOL Ocean Volume       E1EDT37: Shipping unit header BTVOL QUAN 5
15		        
EDIDC  ARCKEY EDI Archive Key CHAR 70   EDIDC  ARCKEY CHAR 70        
                           
The following fields will be used by the GIS Team to source the Transmission Creation Date & Time                          
                           
                           
EDIDC CREDAT Transmission Creation Date DATS 8                  
EDIDC CRETIM Transmission Creation Time  TIMS 6                  
[1]
Aaron Rorstrom:
"Required" if applicable
Record the condition, if any, in which the source will upate the destination.
[2]
Aaron Rorstrom:
"Required" if applicable
Record the list of acceptable values or a document that specifies the accaptable values.
[3]
Aaron Rorstrom:
"Required" if applicable
[4]
Aaron Rorstrom:
"Optional"