Data Mapping Worksheet (EDI 214 -> GTS IDOC)     EDI 214 will update a corresponding Customs Shipment in GTS using the Master Air Waybill Number and House Air Waybill Number as the matching keys.            
EDI 214 - Air Transportation Carrier Shipment Status Update Message Set 
Mapping Definitions      
  Source       Destination  
  EDI 214 Transportation Carrier Shipment Status Message (AIR)[1]       SAP IDOC /SAPSLL/CCECUS01 [2]     EDI Sourcing Condition[3] Valid Values[4] Nullable?
(N or Y or leave blank)[5]		 Field Usage / Remarks[6]
Item Table Name[7] Field Name[8] Position Number Format Description IDOC Name[9] Description Business Rule Logic / Conversion Logic / Default[10]       Functional Comments
1 214 ST01-143 010 String(3) Transaction Set /SAPSLL/E1CCEHD_CNTRL-CUMES Conversion:
If ST01-143 = '214', /SAPSLL/E1CCEHD_CNTRL-CUMES = 'Z214I'.[11]		   Reject EDI transmission if blank
2 214 L1101-127
B1002-145		 030
020		 String(30) Max 11 Master Air Waybill Number /SAPSLL/E1CCEHDO-PAPNO Master Air Waybill Number  Default:
/SAPSLL/E1CCEHDO-QALDOC='HDOC' (Presented Document)
/SAPSLL/E1CCEHDO-PAPTY= 'ZDC004' (Master Air Waybill Number  / Ocean Bill of Lading Number)[12]		 If L1102-128 (Reference Identification Qualifier) = 'AW' 'MB' (Air Waybill Number), then L1101-127 = Master Air Waybill Number Reject EDI transmission if blank Per Carol, there will only be one House Bill  (HAWB) per Customs Shipment. The HAWB, as well as the Master Airway Bill (MAWB),  will be posted at the header level (Document/Evidence Tab) and will apply for each Customs Shipment item. A Customs Shipment ca
3 214 L1101-127 030 String(30) Max 11 House Air Waybill Number /SAPSLL/E1CCEIDO-PAPNO House Air Waybill Number  Default:
/SAPSLL/E1CCEIDO-QALDOC='PDOC' (Presented Document)
/SAPSLL/E1CCEIDO-PAPTY= 'ZDC008' (House Air Waybill Number/ Forwarder's Cargo Receipt)[13]		 If L1102-128 (Reference Identification Qualifier) = 'AW' (Air Waybill Number), then L1101-127 = House Air Waybill Number Reject EDI transmission if blank 1/3/6 Per Sree Veerapalli,  if L1102-128 (Reference Identification Qualifier) = 'AW', then L1101-127 = House Air Waybill Number.
3 214 L1101-127 030 String(30) Max 11 Reference Identification: In Transit Number /SAPSLL/E1CCEHDO-PAPNO In Transit Number Default:
/SAPSLL/E1CCEHDO-QALDOC='HDOC' (Presented Document)
/SAPSLL/E1CCEHDO-PAPTY='ZDT001' (In Transit Number/Date)[14]		 If L1102-128 (Reference Identification Qualifier) = 'IB' (In Bond Number), then L1103-127 = In Transit Number 8/19/2005 Mapping per Marilyn Magin/Carol Marteney
4 214 AT705
L1104-373
GS04-373
 030 String(8) CCYYMMDD Status Date (In Transit) /SAPSLL/E1CCEHDO-PAPDT In Transit Date Default:
/SAPSLL/E1CCEHDO-QALDOC='HDOC' (Presented Document)
/SAPSLL/E1CCEHDO-PAPTY='ZDT001' (In Transit Number/Date)[15]		 If AT701 = 'BC' (Storage In Transit), then AT705 = In-Transit Date.
If L1102-128 (Reference Identification Qualifier) = 'IB' (In Bond Number), then GS04-373 = In-Transit Date.
If L1102-128 (Reference Identification Qualifier) = 'IB' (In Bond Number), then		 8/19/2005 -Mapping per Marilyn Magin/Carol Marteney
10/25/05 - Per Sree Veerapalli/Steve Valette, use GS04-373 instead of L1104-373 [Sree: "Currently we are using 4010 version for EDI 214 transaction.  L1104 is not a standard element in EDI 4010 version.
5 214 L1101-127 200 String(30) Max 11 FIRMS Code /SAPSLL/E1CCEHDO-PAPNO Location of Goods/G.O. Number (FIRMS code) Default:
/SAPSLL/E1CCEHDO-QALDOC='HDOC' (Presented Document)
/SAPSLL/E1CCEHDO-PAPTY='ZDC001' (Location of Goods (FIRMS Code))[16]		 If L1102-128 (Reference Identification Qualifier) = 'ALC' (Agency Location Code), then L1103-127 = FIRMS Code 8/19/2005 Mapping per Marilyn Magin 
6 214 AT705-373 140 String(8) CCYYMMDD Arrival Date in First US Port of Entry /SAPSLL/E1CCEHDO-PAPDT Import Date Default:
/SAPSLL/E1CCEHDO-QALDOC='HDOC' (Presented Document)
/SAPSLL/E1CCEHDO-PAPTY='ZDT002' (Import Date)[17]		 If AT701-1650 (Shipment Status Code) = 'AW' (Arrival in First US Port of Entry), then AT705-373 = Import Date 8/19/2005 Mapping per Marilyn Magin/Carol Marteney
7 315 AT706 020 String(8) HHMMSS Arrival Time in First US Port of Entry /SAPSLL/E1CCEHDO-PAPAD Import Time See above See above   1/13/2006 Added to mapping per Carol Marteney
8 315 AT707 020 String(2) Arrival Time Zone in First US Port of Entry /SAPSLL/E1CCEHDO-PAPAD *Note: Concatenate with above. Import Time Zone See above See above   1/13/2006 Added to mapping per Carol Marteney
9 214 AT705-373 140 String(8) CCYYMMDD Arrival Notification Date /SAPSLL/E1CCEHDO-PAPDT Actual Arrival Date for Clearance Default:
/SAPSLL/E1CCEHDO-QALDOC='HDOC' (Presented Document)
/SAPSLL/E1CCEHDO-PAPTY='ZDT004' (Actual Arrival Date)[18]		 If AT701-1650 = 'K1' , then AT705-373 = Actual Arrival Date for Clearance purposes.
If AT701-1650 = 'AV' (Arrival Notification Date), then AT705-373 = Actual Arrival Date for Clearance purposes.		 8/16/2005 Mapping per Marilyn Magin
1/13/6 - Per Carol Marteney, use AT705 if AT701 = 'K1' .
10 315 AT706 020 String(8) HHMMSS   /SAPSLL/E1CCEHDO-PAPAD Actual Arrival Time for Clearance See above See above   1/13/2006 Added to mapping per Carol Marteney
11 315 AT707 020 String(2)   /SAPSLL/E1CCEHDO-PAPAD *Note: Concatenate with above. Actual Arrival Time Zone for Clearance See above See above   1/13/2006 Added to mapping per Carol Marteney
12 214 AT705-373 140 String(8) CCYYMMDD Estimated Delivery Date /SAPSLL/E1CCEHDO-PAPDT ETA Date To Port of Entry Default:
/SAPSLL/E1CCEHDO-QALDOC='HDOC' (Presented Document)
/SAPSLL/E1CCEHDO-PAPTY='ZDT005' (Estimated Arrival Date at Port of Entry)[19]		 If AT701-1650  = 'AG' (Estimated Delivery), then AT705-373 = ETA to Port of Entry 1/13/2006 Added to mapping per Carol Marteney
13 315 AT706 020 String(8) HHMMSS Estimated Delivery Time /SAPSLL/E1CCEHDO-PAPAD ETA Time To Port of Entry See above See above   1/13/2006 Added to mapping per Carol Marteney
14 315 AT707 020 String(2) Estimated Delivery Time Zone /SAPSLL/E1CCEHDO-PAPAD *Note: Concatenate with above. ETA Time Zone To Port of Entry See above See above   1/13/2006 Added to mapping per Carol Marteney
Notes:
1. No Division Codes to filter. 1/19/2006
[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"
[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:
"Optional"
[11]
Jan Michael Bundalian:
Structure /SAPSLL/E1CCEHDO has the following fields:
QALDOC - ECC Type of Document
PAPTY - ECC: Type of (Preliminary) Document
PAPNO - ECC: Number of (Preliminary) Document
PAPAD - ECC: Additional (Previous) Document
PAPDT - ECC: Date of (Preliminary) Document
PAPIT - ECC: Item of (Preliminary) Document
PAPPC - ECC: Quantity of (Preliminary) Document

Fields QALDOC, PAPTY and PAPDT are required. Field PAPDT is optional. Default PAPIT & PAPPC to blank.
[12]
Jan Michael Bundalian:
Structure /SAPSLL/E1CCEHDO has the following fields:
QALDOC - ECC Type of Document
PAPTY - ECC: Type of (Preliminary) Document
PAPNO - ECC: Number of (Preliminary) Document
PAPAD - ECC: Additional (Previous) Document
PAPDT - ECC: Date of (Preliminary) Document
PAPIT - ECC: Item of (Preliminary) Document
PAPPC - ECC: Quantity of (Preliminary) Document

Fields QALDOC, PAPTY and PAPDT are required. Field PAPDT is optional. Default PAPIT & PAPPC to blank.
[13]
Jan Michael Bundalian:
Structure /SAPSLL/E1CCEHDO has the following fields:
QALDOC - ECC Type of Document
PAPTY - ECC: Type of (Preliminary) Document
PAPNO - ECC: Number of (Preliminary) Document
PAPAD - ECC: Additional (Previous) Document
PAPDT - ECC: Date of (Preliminary) Document
PAPIT - ECC: Item of (Preliminary) Document
PAPPC - ECC: Quantity of (Preliminary) Document

Fields QALDOC, PAPTY and PAPDT are required. Field PAPDT is optional. Default PAPIT & PAPPC to blank.
[14]
Jan Michael Bundalian:
Structure /SAPSLL/E1CCEHDO has the following fields:
QALDOC - ECC Type of Document
PAPTY - ECC: Type of (Preliminary) Document
PAPNO - ECC: Number of (Preliminary) Document
PAPAD - ECC: Additional (Previous) Document
PAPDT - ECC: Date of (Preliminary) Document
PAPIT - ECC: Item of (Preliminary) Document
PAPPC - ECC: Quantity of (Preliminary) Document

Fields QALDOC, PAPTY and PAPDT are required. Field PAPDT is optional. Default PAPIT & PAPPC to blank.
[15]
Jan Michael Bundalian:
Structure /SAPSLL/E1CCEHDO has the following fields:
QALDOC - ECC Type of Document
PAPTY - ECC: Type of (Preliminary) Document
PAPNO - ECC: Number of (Preliminary) Document
PAPAD - ECC: Additional (Previous) Document
PAPDT - ECC: Date of (Preliminary) Document
PAPIT - ECC: Item of (Preliminary) Document
PAPPC - ECC: Quantity of (Preliminary) Document

Fields QALDOC, PAPTY and PAPDT are required. Field PAPDT is optional. Default PAPIT & PAPPC to blank.
[16]
Jan Michael Bundalian:
Structure /SAPSLL/E1CCEHDO has the following fields:
QALDOC - ECC Type of Document
PAPTY - ECC: Type of (Preliminary) Document
PAPNO - ECC: Number of (Preliminary) Document
PAPAD - ECC: Additional (Previous) Document
PAPDT - ECC: Date of (Preliminary) Document
PAPIT - ECC: Item of (Preliminary) Document
PAPPC - ECC: Quantity of (Preliminary) Document

Fields QALDOC, PAPTY and PAPDT are required. Field PAPDT is optional. Default PAPIT & PAPPC to blank.
[17]
Jan Michael Bundalian:
Structure /SAPSLL/E1CCEHDO has the following fields:
QALDOC - ECC Type of Document
PAPTY - ECC: Type of (Preliminary) Document
PAPNO - ECC: Number of (Preliminary) Document
PAPAD - ECC: Additional (Previous) Document
PAPDT - ECC: Date of (Preliminary) Document
PAPIT - ECC: Item of (Preliminary) Document
PAPPC - ECC: Quantity of (Preliminary) Document

Fields QALDOC, PAPTY and PAPDT are required. Field PAPDT is optional. Default PAPIT & PAPPC to blank.
[18]
Jan Michael Bundalian:
Structure /SAPSLL/E1CCEHDO has the following fields:
QALDOC - ECC Type of Document
PAPTY - ECC: Type of (Preliminary) Document
PAPNO - ECC: Number of (Preliminary) Document
PAPAD - ECC: Additional (Previous) Document
PAPDT - ECC: Date of (Preliminary) Document
PAPIT - ECC: Item of (Preliminary) Document
PAPPC - ECC: Quantity of (Preliminary) Document

Fields QALDOC, PAPTY and PAPDT are required. Field PAPDT is optional. Default PAPIT & PAPPC to blank.
[19]
Jan Michael Bundalian:
Structure /SAPSLL/E1CCEHDO has the following fields:
QALDOC - ECC Type of Document
PAPTY - ECC: Type of (Preliminary) Document
PAPNO - ECC: Number of (Preliminary) Document
PAPAD - ECC: Additional (Previous) Document
PAPDT - ECC: Date of (Preliminary) Document
PAPIT - ECC: Item of (Preliminary) Document
PAPPC - ECC: Quantity of (Preliminary) Document

Fields QALDOC, PAPTY and PAPDT are required. Field PAPDT is optional. Default PAPIT & PAPPC to blank.