| Data | |||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Mapping Definitions | |||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Inbound IDOC | Source | Destination | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| EVMSTA02 | OV.02.02 - Outbound 214 | SHPMNT04 | Sourcing Condition | Valid Values | Nullable? (N or Y or leave blank) |
Field Usage / Remarks | |||||||||||||||||||||||||||||||||||||||||||||||||
| Item | Segment | Field Name | Data type | Length | Table Name | Field Name | Description | Data Type | Length | Segment | Field Name | Data type | Length | Qualifiers | |||||||||||||||||||||||||||||||||||||||||
| 1 | E1EVMPAR | IF PARAM_NAME = 'CFS_manifest_number', GET PARAM_VALUE | CHAR | 32 / 20 | E1EVMPAR 861(E9) |
PARAM_VALUE
when PARAM_NAME = 'CFS_MANIFEST_NUMBER' |
Pro Number[2] | CHAR | 20 | E1EDT20 | EXT11: External Identification 1 | CHAR | 20 | ||||||||||||||||||||||||||||||||||||||||||
| 2 | E1EVMHDR02 | EVTID | Event ID | CHAR | 12 | E1EDT20 | EXTI2 | CHAR | 20 | CFS_ARRIVAL’ or ‘CFS_SHIPMENT’ |
|||||||||||||||||||||||||||||||||||||||||||||
| 3 | SAPTRX/EH_CNTRL/ | TRANS_MODE | Mode
of transportation |
CHAR | 5 | E1EDT20 | ROUTE | CHAR | 6 | 10
= Ocean, 30 = Truck, and 40 = Air |
|||||||||||||||||||||||||||||||||||||||||||||
| 4 | E1EVMPAR | IF PARAM_NAME = 'TENDER_CARRIER_ID', GET PARAM_VALUE | CHAR | 32 / 20 | /SAPTRX/EH_CNTRL/ | TENDER_CARRIER_ID | Freight Fowarder Consolidator Code | CHAR | 12 | E1EDT22 | ROUTE_BEZ | CHAR | 40 | ||||||||||||||||||||||||||||||||||||||||||
| 5 | E1EVMPAR | IF PARAM_NAME = 'HAWBFCR', GET PARAM_VALUE | CHAR | 32 / 20 | /SAPTRX/EH_CNTRL/ | HAWBFCR |
Air HAWB | CHAR | 20 | E1EDT22 | STTRG_BEZ | CHAR | 20 | ||||||||||||||||||||||||||||||||||||||||||
| 6 | E1EVMPAR | IF PARAM_NAME = 'HAWBFCR', GET PARAM_VALUE | CHAR | 32 / 20 | /SAPTRX/EH_CNTRL/ | HAWBFCR |
Ocean FCR | CHAR | 20 | E1EDT22 | VSBED_BEZ | CHAR | 20 | ||||||||||||||||||||||||||||||||||||||||||
| 7 | E1EVMPAR | IF PARAM_NAME = 'SHIP_TO_PARTY_NAME', GET PARAM_VALUE | CHAR | 32 / 20 | /SAPTRX/EH_INFO | SHIP_TO_PARTY_NAME | Ship To Name | CHAR | 35 | E1ADRM4 | NAME1: Name or address line | CHAR | 40 | Qualifiers: AW Ship-to Party |
PO or TO EV? | ||||||||||||||||||||||||||||||||||||||||
| 8 | E1EVMHDR02 | EVTDAT | CHAR | 8 | E1EVMHDR02 | EVTDAT | Event Date | CHAR | 8 | E1EDT10 | IEDD: Actual execution date | DATS | 8 | qual "001"-Transport planning | |||||||||||||||||||||||||||||||||||||||||
| 9 | E1EVMHDR02 (04/09/2007) |
EVTTIM | Event Time | CHAR | 6 | E1EDT10 | IEDZ | CHAR | 6 | qual "001"-Transport planning | Per A&F IG: Time Format =
HHMM |
||||||||||||||||||||||||||||||||||||||||||||
| 10 | E1EVMHDR02 (04/09/2007) |
EVTON | Event Time Zone | CHAR | 6 | E1EDT10 | TZONE_END | CHAR | 6 | qual "001"-Transport planning | |||||||||||||||||||||||||||||||||||||||||||||
| 13 | E1EVMPAR | IF PARAM_NAME = 'CONTAINER_NUMBER', GET PARAM_VALUE | CHAR | 32 / 20 | /SAPTRX/EH_CNTRL | 1st 4 character of CONTAINER_NUMBER | Ocean Container SCAC | CHAR | 4 | E1EDL20 | VSTEL | CHAR | 4 | ||||||||||||||||||||||||||||||||||||||||||
| 14 | /SAPTRX/EH_CNTRL | 5th chracter onward of CONTAINER_NUMBER | Ocean Container Number | CHAR | 4 | E1EDL20 | TRAID | CHAR | 20 | ||||||||||||||||||||||||||||||||||||||||||||||
| 15 | E1EVMPAR | IF PARAM_NAME = 'TRAILER_NUMBER', GET PARAM_VALUE | CHAR | 32 / 20 | E1EVMPAR 861(E9) |
PARAM_VALUE
when PARAM_NAME = 'TRAILER_NUMBER' |
Trailer Number | CHAR | 40 | E1EDL22 | ROUTE_BEZ | CHAR | 40 | ||||||||||||||||||||||||||||||||||||||||||
| 16 | E1EVMPAR | IF PARAM_NAME = "MAWB", GET THE PARAM_VALUE | Char | 32 / 20 | /SAPTRX/EH_CNTRL | MAWB (AIR) |
Air MAWB | CHAR | 20 | E1EDL20 : Delivery header | BOLNR : Bill of lading | CHAR | 35 | ||||||||||||||||||||||||||||||||||||||||||
| 17 | E1EVMPAR | IF PARAM_NAME = "SCAC", GET THE PARAM_VALUE | Char | 32 / 20 | /SAPTRX/EH_INFO | SCAC (OCEAN) |
Ocean Carrier SCAC | CHAR | 4 | EIEDL49 | XSITD | CHAR | 10 | ||||||||||||||||||||||||||||||||||||||||||
| 18 | E1EVMPAR | IF PARAM_NAME = "OBOL", GET THE PARAM_VALUE | Char | 32 / 20 | /SAPTRX/EH_CNTRL | OBOL (OCEAN) |
Ocean BOL | CHAR | 30 | E1EDL20 : Delivery header | BOLNR : Bill of lading | CHAR | 35 | ||||||||||||||||||||||||||||||||||||||||||
| 19 | E1EVMPAR | IF PARAM_NAME = "CFS_Seal_number", GET THE PARAM_VALUE | Char | 32 / 20 | E1EVMPAR 861(D1)(E9) |
CFS_SEAL_NUMBER | Outbound Seal from the CFS | CHAR | 20 | E1EDL22 | VKORG_BEZ | CHAR | 20 | Map if exist | |||||||||||||||||||||||||||||||||||||||||
| 20 | E1EVMPAR | IF PARAM_NAME = "?????????", GET THE PARAM_VALUE | Char | 32 / 20 | E1EVMPAR 861(D1) |
Sum[PARAM_VALUE]
where PARAM_NAME contains 1st 4th Char = 'OVR_' |
Discrepancy Overage Quantity | CHAR | 30 | E1EDL22 | VSTEL_BEZ | CHAR | 30 | ||||||||||||||||||||||||||||||||||||||||||
| 21 | E1EVMPAR | IF PARAM_NAME = "?????????", GET THE PARAM_VALUE | Char | 32 / 20 | E1EVMPAR 861(D1) |
Sum[PARAM_VALUE]
where PARAM_NAME contains 1st 4th char = 'SRT_' |
Discrepancy Shortage Quantity | CHAR | 30 | E1EDL22 | LSTEL_BEZ | CHAR | 30 | ||||||||||||||||||||||||||||||||||||||||||
| 22 | E1EVMPAR | IF PARAM_NAME = "?????????", GET THE PARAM_VALUE | Char | 32 / 20 | E1EVMPAR 861(D1) |
Sum[PARAM_VALUE]
where PARAM_NAME contains 1st 3 char = 'DG_' |
Discrepancy Damaged Quantity | CHAR | 30 | E1EDL22 | VKBUR_BEZ | CHAR | 30 | ||||||||||||||||||||||||||||||||||||||||||
| 23 | E1EVMPAR | IF PARAM_NAME = "CFS_comments", GET THE PARAM_VALUE | Char | 32 / 20 | E1EVMPAR 861(E91) |
PARAM_VALUE when PARAM_NAME = 'REASON_CODE_TEXT' |
Applicable only when E1EVMHDR02/EVTID = "CFS_Shipment. Special instructions applicable only to shipment | CHAR | 30 | E1TXTH6 | TDOBNAME | CHAR | 70 | ||||||||||||||||||||||||||||||||||||||||||
| 24 | E1EVMPAR | IF PARAM_NAME = "?????????", GET THE PARAM_VALUE | Char | 32 / 20 | /SAPTRX/EH_INFO/ | SHIPMENT_WGT | Gross Weight by FCR or HAWB; will need to sum all of the ship_projects associated with the cited FCR for the shipment. There will be one FCR per Ship_project | CHAR | 3 | E1EDT37 | BRGEW : Gross weight | QUAN | 13 | If "CFS_SHIPMENT" move "0" ; do not use BRGEW | |||||||||||||||||||||||||||||||||||||||||
| 25 | E1EVMPAR | IF PARAM_NAME = "?????????", GET THE PARAM_VALUE | Char | 32 / 20 | SAPTRX/EH_INFO/ | SHIPMENT_WGT | Gross Weight | CHAR | 13 | E1EDL20 | BTGEW | QUAN | 13 | If "CFS_SHIPMENT" move "0"; do not use BRGEW | Will always be in 'KG' UOM. No conversion needed. | ||||||||||||||||||||||||||||||||||||||||
| 26 | /SAPTRX/EH_INFO/ | SHIPMENT_WGT_UNIT | Gross Weight Unit of Measure | CHAR | 3 | E1EDL20 | GEWEI : Weight Unit | UNIT | 3 | Will always be in 'KG' UOM | |||||||||||||||||||||||||||||||||||||||||||||
| 27 | E1EVMPAR | IF PARAM_NAME = "?????????", GET THE PARAM_VALUE | Char | 32 / 20 | E1EVMPAR 861(D1) E1EVMPAR 861(E9) |
Sum[PARAM_VALUE]
where PARAM_NAME contains 'RC_' or Sum[PARAM_VALUE] where PARAM_NAME contains 'SP_' |
Carton Count | CHAR | 13 | E1EDL24 : Delivery Item | LFIMG | QUAN | 13 | ||||||||||||||||||||||||||||||||||||||||||
| 28 | E1EVMPAR | IF PARAM_NAME = "CPO", GET THE PARAM_VALUE | Char | 32 / 20 | /SAPTRX/EH_INFO/ | CPO_NUMBER | CPO Number | CHAR | E1EDL41 : Reference data ordering party | BSTNR : Customer purchase order number | CHAR | 35 | qual "001"-Purchase order data of customer | ||||||||||||||||||||||||||||||||||||||||||
| 29 | EDIDC | ARCKEY | EDI Archive Key | CHAR | 70 | EDIDC | ARCKEY | CHAR | 70 | ||||||||||||||||||||||||||||||||||||||||||||||
| 30 | /SAPTRX/EH_INFO 861(D1) |
CFS_LOCATION | Receiving CFS Warehouse Location | CHAR | 3 | E1EDL24 | MEINS | CHAR | 3 | Parse out the first three charaters of the
CFS_LOCATION (i.e. MIA). Populate when E1EVMHDR02-EVTID = 'CFS_ARRIVAL' |
MIA
- Hellman Miami = Miami, Florida CMH - ODW Columbus = Columbus, Ohio ORD - ODW Chicago = Chicago, Illinois JFK - Cargo Connection New York = New York, New York ATL - Cargo Connection Atlanta = Atlanta, Georgia FAC - FARO Columbus = Columbus, Ohio CDC |
The
EDI map will leverage the 3 digit code in the CFS_LOCATION and use it
to: - report a 3 digit port code - translate the 3 digit code to the city & state. |
|||||||||||||||||||||||||||||||||||||||||||
| 31 | /SAPTRX/EH_INFO 861(E9) |
CFS_SHIPTO | CFS Shipping Destination | CHAR | 3 | E1EDL24 | MEINS | CHAR | 3 | Parse out the first three charaters of the
CFS_SHIPTO (i.e CDC) Populate when E1EVMHDR02-EVTID = 'CFS_SHIPMENT' |
MIA
- Hellman Miami = Miami, Florida CMH - ODW Columbus = Columbus, Ohio ORD - ODW Chicago = Chicago, Illinois JFK - Cargo Connection New York = New York, New York ATL - Cargo Connection Atlanta = Atlanta, Georgia FAC - FARO Columbus = Columbus, Ohio CDC |
The
EDI map will leverage the 3 digit code in the CFS_SHIPTO and use it to: - report a 3 digit port code - translate the 3 digit code to the city & state. |
|||||||||||||||||||||||||||||||||||||||||||