General requirements |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
I DOC Mapping Level: 1 IDOC should be generated for each HAWB# / FCR# and each
status (generate IDOC only when any one of the status codes mentioned in the
Logic section - column H exists in the EDI 350 Transaction) |
|
|
|
|
Filteration Crietia: For GL3; this IDOC should only be created only for the
following Limitedbrands Division Codes: Mast
Industries, BeautyAvenues i.e. when P404 = 'BTA',
or 'BBW', or MST, MFE, MII, MNV |
|
|
|
All values in quotes
(" ") are hard-coded |
|
|
|
Data Mapping |
|
|
|
|
|
|
|
Data Type: [350 U.S.
Customs Status Information] |
|
|
|
|
|
|
|
|
|
|
|
|
|
Source:EDI X12(350V4010) |
|
|
|
|
|
|
Target IDOC:EVMSTA02 |
|
|
|
|
|
|
|
|
|
EDI SEG |
Seg. ID |
Element |
Req.Des. |
Data Type |
Length |
Desc |
IDOC Segment Name |
Row No |
IDOC Field Name |
IDOC Field Description |
Value |
Data Type |
Required or Optional |
Data Format |
# of Char |
Logic |
|
|
|
|
|
|
|
[Data Concept]
Tracking Header |
|
|
|
|
|
|
|
|
|
V9 or logic |
030 |
V902 |
|
String |
25 |
Event |
E1EVMHDR02 |
1 |
EVTID |
Event Code ID |
|
CHAR |
R |
|
50 |
if V9 Segment
Field V902 (Event) = 130 or 135 then EVTID = "COMPLETE_DOC";
if V9 Segment Field V902 (Event) = 140 then EVTID =
"ENTRY_FILED";
if V9 Segment Filed V902 (Event) = 190, then EVTID = "CUSTOMS_CLEARED";
if V9 Segment Field V902 (Event) = 230, t |
V9 / N9
(based on Logic) |
030 / 095 |
V903 / N904 (based on Logic) |
|
Date |
8 |
Event Date |
E1EVMHDR02 |
1 |
EVTDAT |
Event Date |
|
DATE |
R |
CCYYMMDD |
8 |
Date when this
event happened. Segment V9; Field V903 |
V9 / N9
(based on Logic) |
030 / 095 |
V904 / N905 (Based on Logic) |
|
TM |
8 |
Event Time |
E1EVMHDR02 |
1 |
EVTTIM |
Event Time |
|
TIME |
R |
HHMMSS |
6 |
Time when this
event happened. Segment V9; Field V904 |
V9 / N9
(based on Logic) |
030 / 095 |
V913 / N906 (Based on Logic) |
|
ID |
2 |
Time Code |
E1EVMHDR02 |
1 |
EVTZON |
Event Time Zone |
|
CHAR |
R |
|
6 |
Time Zone of
the time in V904 field; V913 (if V902 = 130 or 135 or 140 or 190 or 230 or 150 or 200 or 220
or 120) or N906 (if V902 (Event) = 120 and N901 = "6B" and N904 is
not null) |
Receivng
System date |
|
|
|
|
|
|
E1EVMHDR02 |
1 |
REPDAT |
Reporting Date |
|
DATE |
R |
CCYYMMDD |
8 |
Date when the
EDI transaction is received by the receiving system |
Receivng
System time |
|
|
|
|
|
|
E1EVMHDR02 |
1 |
REPTIM |
Reporting Time |
|
TIME |
R |
HHMMSS |
6 |
Time when the
event is received by the receiving system |
Receiving
System timezone |
|
|
|
|
|
|
E1EVMHDR02 |
1 |
REPZON |
Reporting Time Zone |
|
CHAR |
R |
|
6 |
Time Zone of
the Receiving system |
|
|
|
|
|
|
|
[Data Concept] Tracking ids |
|
|
|
|
|
|
|
|
|
Hard coded
value |
|
|
|
|
|
|
E1EVMTID |
1 |
TRXCOD |
Tracking ID Code
Set |
"HAWBFCR" |
CHAR |
R |
|
20 |
|
N9 |
030 |
N902 |
O |
String |
25 |
Reference Identification |
E1EVMTID |
1 |
TRXID |
Tracking ID |
|
CHAR |
R |
|
50 |
HAWB # / FCR #
from EDI 350 transaction (Field N902 when N901 = "WY") |
|
|
|
|
|
|
|
[Data Concept] Parameters |
|
|
|
|
|
|
|
|
|
Hard coded
value |
|
|
|
|
|
|
E1EVMPAR |
1 |
PARTYP |
Parameter
Type |
"I" |
CHAR |
O |
|
1 |
|
Hard coded
value |
|
|
|
|
|
|
E1EVMPAR |
1 |
PARAM_NAME |
Parameter
Name |
"ACTUAL_CUSTOMS_BROKER" |
CHAR |
O |
|
32 |
|
GS |
002 |
GS02 |
M |
String |
15 |
Sender ID |
E1EVMPAR |
1 |
PARAM_VALUE |
Parameter Value |
|
CHAR |
O |
|
20 |
Customs
Broker; This should be the EDI 350 Sender, In EDI 350 Segment GS Field GS02 |
Hard coded
value |
|
|
|
|
|
|
E1EVMPAR |
1 |
ACTION |
Action
Parameter |
"C" |
CHAR |
O |
|
1 |
|
Hard coded
value |
|
|
|
|
|
|
E1EVMPAR |
2 |
PARTYP |
Parameter
Type |
"I" |
CHAR |
O |
|
1 |
|
Hard coded
value |
|
|
|
|
|
|
E1EVMPAR |
2 |
PARAM_NAME |
Parameter
Name |
"CUSTOMS_DISTRICT_ID" |
CHAR |
O |
|
32 |
|
P401 |
020 |
P401 |
M |
String |
30 |
Location Identifier |
E1EVMPAR |
2 |
PARAM_VALUE |
Parameter Value |
|
CHAR |
O |
|
20 |
Customs
District; According to EDI 350, this value comes from segment P4 Field P401 |
Hard coded
value |
|
|
|
|
|
|
E1EVMPAR |
2 |
ACTION |
Action Parameter |
"C" |
CHAR |
O |
|
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|