Arden 110 Air

From UG

(Difference between revisions)
Jump to: navigation, search
(Total Weight)
(Charge Rate)
 
(44 intermediate revisions not shown)
Line 1: Line 1:
-
[[Category:Ops]]
+
[[Category:SI EDI]]
== Intro ==
== Intro ==
-
This wiki defines fields required for EDI transmission of '''Air (110)''' Sales Invoices from JaguarFreight (3PL) to Elizabeth Arden (Client) through Data2Logistics (EDI partner).
+
* This wiki defines fields required for EDI transmission of '''Air (110)''' Sales Invoices.
-
There are 3 lists of fields here:
+
* '''Item''' represents item# on original Arden's list - see [[SI_EDI_Misc#Original_Ardens_List]].
-
* [[#Original Fields]] - '''Required List Of Fields''' Jaguar received from Arden through Data2Logistics at the beginning of the project. This list can be found in section [[#Original Ardens List]] at the end of this wiki.
+
* [[#Original Fields]] - '''Required List Of Fields''' Jaguar received from Arden through Data2Logistics at the beginning of the project - see [[SI_EDI_Misc#Original_Ardens_List]].
-
* [[#Additional Fields]] - fields that Jaguar added to above list for the first release
+
* [[#Additional Fields A]] - fields that Jaguar added to above list for the first release.
-
* [[#Future Fields]] - possible additional options
+
== Protocol ==
-
=== Format ===
+
See [[Media:4010 110.pdf]]
-
 
+
-
For each field Jaguar added the following information - see below.
+
-
 
+
-
'''Rel#''' represents Release number. See also [[#Release Schedule]].
+
-
 
+
-
'''Item''' represents item# on original Arden's list.
+
-
 
+
-
'''Map''' provides info about internal mapping into CT2 fields.
+
-
 
+
-
'''EDI''' represents relevant EDI protocol info (segment, element, required or not, format, etc).
+
-
 
+
-
'''Notes''' supply some additional in most cases business analysis related info. Fields that are self explanatory and well understood contain no notes.
+
-
 
+
-
=== Tags ===
+
-
 
+
-
Each field could be tagged with these values:
+
-
 
+
-
* UNUSED - if it will not be used for some reason. See "notes" section for reasons.
+
-
 
+
-
* TBC - if any aspect of use of this field is yet To Be Confirmed
+
-
 
+
-
=== Credit Notes vs Invoices ===
+
-
 
+
-
Credit Notes will be transmitted with the same set of fields as invoices. To distinguish between Invoice and Credit Note:
+
-
 
+
-
* there is indicator in B3 segment
+
-
:* nothing for Sales Invoice
+
-
:* '''CA''' ''(Cancelled Bill)'' for Credit Note
+
-
* and also "-" sign before amount
+
-
 
+
-
=== Group Logic ===
+
-
 
+
-
In case Invoice/Credit Note is issued against the group of CTs (GRP) same logic as we have had for paper (pdf) based versions will be applied.
+
-
 
+
-
=== Release Schedule ===
+
-
 
+
-
* Rel 1.0 - estimated: Sept 6
+
-
* Rel 1.1 - estimated: Sept 27
+
== Original Fields ==
== Original Fields ==
-
 
-
=== Ultimate Consignee ===
 
-
 
-
* '''Rel#''' n/a
 
-
* '''item #''' a
 
-
* '''map:''' [[#Consignee]]
 
-
* '''EDI:'''
 
-
* '''notes:''' UNUSED, TBC
 
-
** Per Arden - must be captured for International Shipments.
 
-
** Per D2L - this is in the event of a stop off scenario. Otherwise this is just the consignee.
 
-
** Per Jaguar - based on above we use [[#Consignee Info]] instead
 
=== Invoice Number ===
=== Invoice Number ===
-
* '''Rel#''' 1.0
 
* '''item #''' b
* '''item #''' b
-
* '''map:''' [[SI#Invoice Number]]  
+
* '''map:''' [[SI#Invoice Number]] for CT and CT group cases
-
* '''EDI:''' B302
+
* '''EDI:''' GS:04 UPDATED sep 4
=== Bill Of Lading Number ===
=== Bill Of Lading Number ===
-
* '''Rel#''' 1.0
 
* '''item #''' c
* '''item #''' c
-
* '''map:''' [[CT#HAWB]]
+
* '''map:''' [[CT#HAWB]] for CT and CT group cases
* '''EDI:''' L502
* '''EDI:''' L502
* '''notes:'''   
* '''notes:'''   
Line 84: Line 33:
=== Load Number ===  
=== Load Number ===  
-
* '''Rel#''' 1.0
 
* '''item#''' d
* '''item#''' d
-
* '''map:''' [[CT#CT Number]]
+
* '''map:''' [[CT#CT Number]] for CT and CT group cases
* '''EDI:''' B303
* '''EDI:''' B303
-
* '''notes:''' TBC
+
* '''notes:'''  
-
** per Arden - required for inbound only.
+
** per Arden - confirmed w/ Dawn
-
** Per Jaguar - We pass CT#. in case of CT group we can also pass CT list in the [[#Invoice Comments]] field
+
-
 
+
-
=== Shipper Acct Number ===
+
-
 
+
-
* '''Rel#''' n/a
+
-
* '''item#''' e
+
-
* '''map:'''
+
-
* '''EDI:'''
+
-
* '''notes:''' UNUSED, TBC
+
-
** Per Arden - only required for small package carriers.
+
-
** Per Jaguar - this is irrelevant to this project
+
=== Shipper Info ===
=== Shipper Info ===
-
* '''Rel#''' 1.0
 
* '''item#''' f
* '''item#''' f
-
* '''map:''' [[CT#Shipper]] and [[CT#Shipper Address]]
+
* '''map:''' [[CT#Shipper]] and [[CT#Shipper Address]] for CT and CT group cases
* '''EDI:''' N1, N3, N4 (SH)
* '''EDI:''' N1, N3, N4 (SH)
* '''notes:'''  
* '''notes:'''  
Line 114: Line 50:
=== Consignee Info ===
=== Consignee Info ===
-
* '''Rel#''' 1.0
 
* '''item#''' g
* '''item#''' g
-
* '''map:''' [[CT#Consignee]] and [[CT#Consignee Address]]
+
* '''map:''' [[CT#Consignee]] and [[CT#Consignee Address]] for CT and CT group cases
* '''EDI:''' N1, N3, N4 (CN)
* '''EDI:''' N1, N3, N4 (CN)
* '''notes:'''  
* '''notes:'''  
Line 124: Line 59:
=== Port of Entry ===
=== Port of Entry ===
-
* '''Rel#''' 1.0
 
* '''item#''' h
* '''item#''' h
-
* '''map:''' [[CT#Airport Of Destination]]
+
* '''map:''' [[CT#Airport Of Destination]] for CT and CT group cases
* '''EDI:''' R105
* '''EDI:''' R105
* '''notes:'''
* '''notes:'''
Line 133: Line 67:
=== Port of Departure ===
=== Port of Departure ===
-
* '''Rel#''' 1.0
 
* '''item#''' i
* '''item#''' i
-
* '''map:''' [[CT#Airport Of Departure]]
+
* '''map:''' [[CT#Airport Of Departure]] for CT and CT group cases
* '''EDI:''' R103
* '''EDI:''' R103
* '''notes:'''  
* '''notes:'''  
Line 142: Line 75:
=== Delivery Date ===
=== Delivery Date ===
-
* '''Rel#''' 1.0
 
* '''item#''' j
* '''item#''' j
-
* '''map:''' [[CT#Estimated Delivery Date]]
+
* '''map:''' [[CT#Destination Port Actual Arrival Date]] for CT and CT group cases
 +
* if actual dates are not available then send equivalent estimated dates
* '''EDI:''' B309
* '''EDI:''' B309
-
* '''notes:''' TBC w/ Dawn (estimated is OK? destination door date and not port is OK?)
 
=== Ship Date ===
=== Ship Date ===
-
* '''Rel#''' 1.0
 
* '''item#''' k
* '''item#''' k
-
* '''map:''' [[CT#Actual Pick Up Date]]
+
* '''map:''' [[CT#Origin Port Actual Departure Date]] for CT and CT group cases
* '''EDI:'''  P102 Pick-up Date
* '''EDI:'''  P102 Pick-up Date
-
* '''notes:'''  
+
* '''notes:'''
=== Invoice Date ===
=== Invoice Date ===
-
* '''Rel#''' 1.0
 
* '''item#''' l
* '''item#''' l
-
* '''map:'''  [[SI#Issuing Date]]  
+
* '''map:'''  [[SI#Issuing Date]] for CT and CT group cases
-
* '''EDI:''' B36
+
* '''EDI:''' B306
* '''notes:'''
* '''notes:'''
=== Total # of pieces ===
=== Total # of pieces ===
-
* '''Rel#''' 1.0
 
* '''item#''' m
* '''item#''' m
-
* '''map:''' [[Commodity#plts]]
+
* '''map:''' [[Commodity#plts]] for CT and sum of all [[Commodity#plts]]  across all CTs selected for invoice in CT group case
* '''EDI:''' L013
* '''EDI:''' L013
* '''notes:''' TBC w/ Dawn if need to include loose as well into count
* '''notes:''' TBC w/ Dawn if need to include loose as well into count
Line 174: Line 103:
=== Total Weight ===
=== Total Weight ===
-
* '''Rel#''' 1.0
 
* '''item#''' n
* '''item#''' n
-
* '''map:''' [[Commodity#Grand Total: Gross Kg]]
+
* '''map:''' [[Commodity#Grand Total: Gross Lb]] for CT and sum of all [[Commodity#Grand Total: Gross Lb]]  across all CTs selected for invoice in CT group case
-
* '''EDI:''' L0_4 confirmed
+
* '''EDI:''' L0:04 ; also set L0:05=N  (stands for Actual Net Weight)
-
* '''notes:''' in kg
+
* send in lb
=== Billed Weight ===
=== Billed Weight ===
-
* '''Rel#''' 1.1
 
* '''item#''' o
* '''item#''' o
-
* '''map:''' [[CT#Chargeable Weight]]
+
* '''map:''' [[CT#Chargeable Weight]] for CT and sum of all [[Commodity#Chargeable Weight]]  across all CTs selected for invoice in CT group case
-
* '''EDI:'''   L3_1 confirmed w/ Brandon
+
* '''EDI:'''   L3:01; also set L3:02 = B (stands for Billed Weight)
-
 
+
* * send in lb
-
=== Mileage ===
+
-
 
+
-
* '''Rel#''' n/a
+
-
* '''item#''' p
+
-
* '''map:'''
+
-
* '''EDI:'''
+
-
* '''notes:''' UNUSED, TBC
+
-
** Per D2L - this should be included in the L7:11 field for both Ocean and Air ''when available''.
+
-
** Per Jaguar - we do not have this information available now in our system. Since it is optional we can include it into the future releases.
+
=== Movement Type ===
=== Movement Type ===
-
* '''Rel#''' 1.0
 
* '''item#''' q
* '''item#''' q
-
* '''map:''' [[CT#Transport Mode Type]]
+
* '''map:''' [[CT#Transport Mode Type]] for CT and CT group cases
* '''EDI:''' GS_3 (ELARUS1,ELARUS2, ELARUS3) confirmed by Brandon
* '''EDI:''' GS_3 (ELARUS1,ELARUS2, ELARUS3) confirmed by Brandon
* '''notes:'''
* '''notes:'''
Line 207: Line 124:
** Per D2L(Brandon) - this is referencing any special service levels – Examples – 1 day Air, 2 day air, air priority, etc.
** Per D2L(Brandon) - this is referencing any special service levels – Examples – 1 day Air, 2 day air, air priority, etc.
** Per Jaguar - best match for this requirement is our Transport Mode Type field. It has 3 options: Air, Ocean, Truck.
** Per Jaguar - best match for this requirement is our Transport Mode Type field. It has 3 options: Air, Ocean, Truck.
-
 
-
=== Container Size ===
 
-
 
-
* '''Rel#''' n/a
 
-
* '''item#''' r
 
-
* '''map:'''
 
-
* '''EDI:'''
 
-
* '''notes:''' UNUSED
 
-
** per Arden: (20, 40, 40HC, LCL) (only required air / ocean int. shipments)
 
-
** per Jaguar - we do not have this info for Air in the system
 
=== Terms / Incoterms ===
=== Terms / Incoterms ===
-
* '''Rel#''' 1.1
 
* '''item#''' s
* '''item#''' s
-
* '''map:''' [[CT#Shipping Terms]]
+
* '''map:''' [[CT#Shipping Terms]] for CT and CT group cases
* '''EDI:''' B314; send 3 digit code, see [[#Codes for Terms]]
* '''EDI:''' B314; send 3 digit code, see [[#Codes for Terms]]
=== Carrier Name ===
=== Carrier Name ===
-
* '''Rel#''' 1.0
 
* '''item#''' t
* '''item#''' t
-
* '''map:''' [[CT#Airline]]
+
* '''map:''' [[CT#Airline]] or CT and CT group cases
* '''EDI:''' R104
* '''EDI:''' R104
** note: sending code to be translated
** note: sending code to be translated
Line 235: Line 140:
=== Pro# ===
=== Pro# ===
-
* '''Rel#''' n/a
 
* '''item#''' u
* '''item#''' u
-
* '''map:'''
+
* '''map:''' per Dawn map to [[CT#HAWB]] or CT and CT group cases
-
* '''EDI:'''
+
* '''EDI:''' per Brandon should be included in a N9:03 field with a ‘PO’ qualifier in the N9:02 field. N9:01
-
* '''notes:''' UNUSED for Air and Ocean, TBC
+
** TBC
-
** Per D2L - should be included in a N9:03 field with a ‘PO’ qualifier in the N9:02 field.
+
-
** Per Jaguar - we do not have this info in our system for Air/Ocean
+
-
=== Freight Cost ===
+
== Additional Fields A ==
-
 
+
-
* '''Rel#''' 1.0
+
-
* '''item#''' v
+
-
* '''map:'''
+
-
* '''EDI:''' n/a
+
-
* '''notes:''' 
+
-
** see [[#Table Of Charges Fields]] section.
+
-
** Per D2L - these can be the codes from your system but we require a list of these codes and their definitions to define them within our system.
+
-
 
+
-
=== Accessorial costs ===
+
-
 
+
-
* '''Rel#''' 1.0
+
-
* '''item#''' w
+
-
* '''map:'''
+
-
* '''EDI:''' n/a
+
-
* '''notes:''' 
+
-
** see [[#Table Of Charges Fields]] section instead
+
-
 
+
-
== Additional Fields ==
+
=== Correction Indicator ===
=== Correction Indicator ===
-
* '''Rel#''' 1.0
+
* '''Map:''' value CO per Brandon
-
* '''Map:''' value CA(cancel bill) or CO(Correction)?
+
* '''EDI spec''': B308 202 Correction Indicator  O  ID  2/2
* '''EDI spec''': B308 202 Correction Indicator  O  ID  2/2
-
* TBC w/ d2l
 
=== Method of Payment ===
=== Method of Payment ===
-
* '''Rel#''' 1.0
+
* '''Map:''' set as "TP" for all shipments (per Dawn)
-
* '''Map:''' value CC (Collect) for all shipments  
+
* '''EDI spec''': B304 146 Shipment Method of Payment M ID 2/2
* '''EDI spec''': B304 146 Shipment Method of Payment M ID 2/2
-
* TBC w/ d2l
+
** per Brandon we set up to have 3 options: CC (Collect), PP prepaid , TP 3rd party
-
**per Brandon we set up to have 3 options: CC (Collect), PP prepaid , TP 3rd party
+
=== Invoice Amount ===
=== Invoice Amount ===
-
* '''Rel#''' 1.0
 
*  '''Map:''' [[SI#Total Invoice]]  
*  '''Map:''' [[SI#Total Invoice]]  
-
* '''EDI spec''':  B3_7, L3_5  
+
* '''EDI spec''':  B3_7, L3_5 why use these 2 segments??? can we use just B307 for all MOTs??
* '''Notes''': From Jaguar - this field is obviously required on invoice but was missing from Original Fields List so we added it.
* '''Notes''': From Jaguar - this field is obviously required on invoice but was missing from Original Fields List so we added it.
=== Invoice Currency ===
=== Invoice Currency ===
-
* '''Rel#''' 1.0
 
*  '''Map:''' [[SI#Total Invoice Currency]]  
*  '''Map:''' [[SI#Total Invoice Currency]]  
* '''EDI spec''':  C3_1
* '''EDI spec''':  C3_1
Line 295: Line 172:
=== Invoice Bill To Company Name ===
=== Invoice Bill To Company Name ===
-
* '''Rel#''' 1.0
 
* '''Map:'''  [[SI#Bill To]]  
* '''Map:'''  [[SI#Bill To]]  
* '''EDI spec''': N102; AN; 1/60; use with N101=BT
* '''EDI spec''': N102; AN; 1/60; use with N101=BT
Line 302: Line 178:
=== Invoice Bill To Address ===
=== Invoice Bill To Address ===
-
* '''Rel#''' 1.0
 
*  '''Map:''' [[SI#Bill To Address]]  
*  '''Map:''' [[SI#Bill To Address]]  
* '''EDI spec''':  N3, N4 (BT)
* '''EDI spec''':  N3, N4 (BT)
Line 326: Line 201:
==== Charge Code ====
==== Charge Code ====
-
* '''Rel#''' 1.0
 
*  '''Map:''' [[SI#CC]]  
*  '''Map:''' [[SI#CC]]  
-
* '''EDI spec''': L1_8
+
* '''EDI spec''': L108
==== Charge Amount ====
==== Charge Amount ====
-
* '''Rel#''' 1.0
 
*  '''Map:''' [[SI#CC Amount]]  
*  '''Map:''' [[SI#CC Amount]]  
-
* '''EDI spec''': L1_4
+
* '''EDI spec''': L104
==== Charge Currency ====
==== Charge Currency ====
-
* '''Rel#''' 1.0
 
*  '''Map:''' [[SI#CC Currency]]  
*  '''Map:''' [[SI#CC Currency]]  
-
* '''EDI spec''': L1_20
+
* '''EDI spec''': L120
-
== Future Fields ==
+
==== Charge Rate ====
-
Some of these fields were inspired by pdf version of invoice.
+
*  '''Map:''' [[SI#CC Rate]]
 +
* '''EDI spec''': L1:02
 +
* this was added by D2L, they wanted just Freight Rate, but it is easier to send for all charges and they pull waterer they want
-
=== All Shippers ===
+
Implementation details as of Oct-2016:
-
 
+
Trucking example (''charge amount''):  L1*1*'''246.0'''**24600****1505************USD~
-
Name / address for all shippers in case of CT group.
+
  Non-Trucking example (''charge rate''): L1*11*'''13.0'''**975****1504************USD~
-
 
+
-
=== All Consignees ===
+
-
 
+
-
Name / address for all consignees in case of CT group.
+
-
 
+
-
=== Invoice Comments ===
+
-
 
+
-
* edi: NTE352 Note/Special Instructions Description
+
-
 
+
-
=== File Ref Num ===
+
-
 
+
-
=== Notify Party ===
+
-
 
+
-
=== PO numbers ===
+
-
 
+
-
=== Customer ref ===
+
-
 
+
-
=== Flight number ===
+
-
 
+
-
=== Volume ===
+
== Misc ==
== Misc ==
-
 
-
=== Original Ardens List ===
 
-
 
-
* a. Ultimate Consignee must be captured for International Shipments
 
-
* b. Invoice Number
 
-
* c. Bill of Lading number
 
-
* d. LOAD NUMBER (required for inbound only)
 
-
* e. Shipper Acct # (only required for small package carriers)
 
-
* f. Shipper info including address (city, state, zip and county code)
 
-
* g. Consignee Info including address (city, state, zip and county code)
 
-
* h. Port of Entry (only required air / ocean int. shipments)
 
-
* i. Port of Departure (only required air / ocean int. shipments)
 
-
* j. Delivery Date
 
-
* k. Ship Date
 
-
* l. Invoice Date
 
-
* m. Total # of pieces
 
-
* n. Total Weight
 
-
* o. Billed Weight
 
-
* p. Mileage
 
-
* q. Movement Type (Mode and any expedited options)
 
-
* r. Container Size (20, 40, 40HC, LCL) (only required air / ocean int. shipments)
 
-
* s. Terms / Incoterms
 
-
* t. Carrier Name
 
-
* u. Pro#
 
-
* v. Freight Cost
 
-
* w. Accessorial costs
 
-
 
-
=== 110 Segments ===
 
-
 
-
<pre>
 
-
ISA InterchangeControlHeader..................................................................................
 
-
GS FunctionalGroupHeader.....................................................................................
 
-
ST TransactionSetHeader........................................................................................
 
-
 
-
B3 BeginningSegmentforCarrier'sInvoice...................................................................
 
-
B3A InvoiceType.....................................................................................................
 
-
C2 BankID...........................................................................................................
 
-
C3 Currency..........................................................................................................
 
-
ITD TermsofSale/DeferredTermsofSale......................................................................
 
-
 
-
N1 LoopN1...........................................................................................................
 
-
N1 Name..............................................................................................................
 
-
N2 AdditionalNameInformation.................................................................................
 
-
N3 AddressInformation...........................................................................................
 
-
N4 GeographicLocation...........................................................................................
 
-
N9 ReferenceIdentification.......................................................................................
 
-
 
-
PER AdministrativeCommunicationsContact..................................................................
 
-
LX LoopLX...........................................................................................................
 
-
LX AssignedNumber...............................................................................................
 
-
N1 LoopN1...........................................................................................................
 
-
N1 Name..............................................................................................................
 
-
N2 AdditionalNameInformation.................................................................................
 
-
N3 AddressInformation...........................................................................................
 
-
N4 GeographicLocation...........................................................................................
 
-
N9 ReferenceIdentification.......................................................................................
 
-
 
-
PER AdministrativeCommunicationsContact..................................................................
 
-
P1 Pick-up............................................................................................................
 
-
R1 RouteInformation(Air)........................................................................................
 
-
POD Proof of Delivery. . . . . . . . . . . . . . . . .
 
-
V9 EventDetail......................................................................................................
 
-
RMT Remittance Advice . . . . . . . . . . . . . . .
 
-
G47 StatementIdentification.......................................................................................
 
-
NTE Note/SpecialInstruction.......................................................................................
 
-
 
-
L5 LoopL5...........................................................................................................
 
-
L5 Description,MarksandNumbers............................................................................
 
-
L0 LineItem-QuantityandWeight..............................................................................
 
-
L4 Measurement....................................................................................................
 
-
L10 Weight............................................................................................................
 
-
S
 
-
L1 TariffReference.................................................................................................
 
-
L1 LoopL1...........................................................................................................
 
-
L1 RateandCharges...............................................................................................
 
-
C3 Currency..........................................................................................................
 
-
 
-
L3 TotalWeightandCharges....................................................................................
 
-
ACS AncillaryCharges...............................................................................................
 
-
NTE Note/SpecialInstruction.......................................................................................
 
-
 
-
SE TransactionSetTrailer........................................................................................
 
-
GE FunctionalGroupTrailer......................................................................................
 
-
IEA InterchangeControlTrailer
 
-
 
-
</pre>
 
=== Codes for Terms ===
=== Codes for Terms ===
-
 
-
Codes for Terms:
 
001 / CFR
001 / CFR
Line 486: Line 252:
012 / LDP
012 / LDP
-
== See Also ==
+
== Example ==
 +
 
 +
<pre>
 +
ISA*00*          *00*          *02*JAFR          *ZZ*ELARUS        *131018*0343*U*00401*000000001*0*T*>~
 +
GS*IM*JAFR*ELARUS1*20131018*034056*108340*X*004010~
 +
ST*110*0001~
 +
B3**US46513*CT455353*TP*L*20130918*2032360**20130919*035*JAFR***  ~
 +
C3*USD~
 +
N9*PO*455353~
 +
N1*BT*ELIZABETH ARDEN~
 +
N3*1751 BLUE HILLS DR.  N.E.~
 +
N4*ROANOKE*VA*24012*US~
 +
N1*SH*ELIZABETH ARDEN~
 +
N3*1751 BLUE HILLS DRIVE~
 +
N4*ROANOKE*VA*24012*US~
 +
N1*CN*CEPL COIGNIERES~
 +
N3*ZI DU MARAIS~
 +
N4*COIGNIERES**78310*FR~
 +
LX*1~
 +
P1**20130918*370~
 +
R1***IAD*057*CDG~
 +
L5*1*455353~
 +
L0*1***399.02*N********1~
 +
L1*1*10.0**222460****101************USD~
 +
L1*2*100.0**1809900****102************USD~
 +
L3*490.43*B***2032360*******L~
 +
SE*22*0001~
 +
GE*000001*108340~
 +
IEA*1*000000001~
 +
</pre>
-
* [[Sales Invoices EDI]] - master wiki for this project
+
[[File:D2l invoice.png | 900px]]

Current revision as of 12:59, 7 October 2016


Contents

[edit] Intro

  • This wiki defines fields required for EDI transmission of Air (110) Sales Invoices.

[edit] Protocol

See Media:4010 110.pdf

[edit] Original Fields

[edit] Invoice Number

[edit] Bill Of Lading Number

  • item # c
  • map: CT#HAWB for CT and CT group cases
  • EDI: L502
  • notes:
    • per Jaguar - for Air we pass HAWB

[edit] Load Number

  • item# d
  • map: CT#CT Number for CT and CT group cases
  • EDI: B303
  • notes:
    • per Arden - confirmed w/ Dawn

[edit] Shipper Info

  • item# f
  • map: CT#Shipper and CT#Shipper Address for CT and CT group cases
  • EDI: N1, N3, N4 (SH)
  • notes:
    • per Arden - info including address (city, state, zip and county code)
    • per Jaguar - only one Shipper will be passed in case of CT group. See also #All Shippers

[edit] Consignee Info

  • item# g
  • map: CT#Consignee and CT#Consignee Address for CT and CT group cases
  • EDI: N1, N3, N4 (CN)
  • notes:
    • Per Arden - includes address (city, state, zip and county code)
    • Per Jaguar - only one Consignee will be passed in case of CT group. See also #All Consignees

[edit] Port of Entry

  • item# h
  • map: CT#Airport Of Destination for CT and CT group cases
  • EDI: R105
  • notes:
    • Per Arden - only required air / ocean int. shipments

[edit] Port of Departure

  • item# i
  • map: CT#Airport Of Departure for CT and CT group cases
  • EDI: R103
  • notes:
    • Per Arden - only required air / ocean int. shipments

[edit] Delivery Date

[edit] Ship Date

[edit] Invoice Date

[edit] Total # of pieces

  • item# m
  • map: Commodity#plts for CT and sum of all Commodity#plts across all CTs selected for invoice in CT group case
  • EDI: L013
  • notes: TBC w/ Dawn if need to include loose as well into count

[edit] Total Weight

[edit] Billed Weight

[edit] Movement Type

  • item# q
  • map: CT#Transport Mode Type for CT and CT group cases
  • EDI: GS_3 (ELARUS1,ELARUS2, ELARUS3) confirmed by Brandon
  • notes:
    • Per Arden - this is mode and any expedited options.
    • Per D2L(Brandon) - this is referencing any special service levels – Examples – 1 day Air, 2 day air, air priority, etc.
    • Per Jaguar - best match for this requirement is our Transport Mode Type field. It has 3 options: Air, Ocean, Truck.

[edit] Terms / Incoterms

[edit] Carrier Name

  • item# t
  • map: CT#Airline or CT and CT group cases
  • EDI: R104
    • note: sending code to be translated

[edit] Pro#

  • item# u
  • map: per Dawn map to CT#HAWB or CT and CT group cases
  • EDI: per Brandon should be included in a N9:03 field with a ‘PO’ qualifier in the N9:02 field. N9:01
    • TBC

[edit] Additional Fields A

[edit] Correction Indicator

  • Map: value CO per Brandon
  • EDI spec: B308 202 Correction Indicator O ID 2/2

[edit] Method of Payment

  • Map: set as "TP" for all shipments (per Dawn)
  • EDI spec: B304 146 Shipment Method of Payment M ID 2/2
    • per Brandon we set up to have 3 options: CC (Collect), PP prepaid , TP 3rd party

[edit] Invoice Amount

  • Map: SI#Total Invoice
  • EDI spec: B3_7, L3_5 why use these 2 segments??? can we use just B307 for all MOTs??
  • Notes: From Jaguar - this field is obviously required on invoice but was missing from Original Fields List so we added it.

[edit] Invoice Currency

  • Map: SI#Total Invoice Currency
  • EDI spec: C3_1
  • Notes: From Jaguar - this field is obviously required on invoice but was missing from Original Fields List so we added it.

[edit] Invoice Bill To Company Name

  • Map: SI#Bill To
  • EDI spec: N102; AN; 1/60; use with N101=BT
  • Notes: From Jaguar - this was one of the key fields on pdf version of Jaguar invoices to Arden so we added it to EDI version as well.

[edit] Invoice Bill To Address

  • Map: SI#Bill To Address
  • EDI spec: N3, N4 (BT)
  • Notes: From Jaguar - this was one of the key fields on pdf version of Jaguar invoices to Arden so we added it to EDI version as well.

[edit] Table Of Charges Fields

This corresponds to the following two Items on the #Original Fields List:

  • v. Freight Cost
  • w. Accessorial costs

To cover information above we usually has been sending to Arden in the past (in pdf form) these three pieces of information for each type of cost (a.k.a. charge) in one set:

Note that the number of sets (table lines) differ from invoice to invoice.

Please also note that Data2Logistics will be doing translation of #Charge Code into Charge Description for Arden based on mapping table that we provided.

[edit] Charge Code

  • Map: SI#CC
  • EDI spec: L108

[edit] Charge Amount

[edit] Charge Currency

[edit] Charge Rate

  • Map: SI#CC Rate
  • EDI spec: L1:02
  • this was added by D2L, they wanted just Freight Rate, but it is easier to send for all charges and they pull waterer they want
Implementation details as of Oct-2016:
Trucking example (charge amount):  L1*1*246.0**24600****1505************USD~
Non-Trucking example (charge rate): L1*11*13.0**975****1504************USD~

[edit] Misc

[edit] Codes for Terms

001 / CFR

002 / CIF

003 / CIP

004 / CPT

005 / DAP

006 / DDP

007 / DDU

008 / DEQ

009 / EXW

010 / FCA

011 / FOB

012 / LDP

[edit] Example

ISA*00*          *00*          *02*JAFR           *ZZ*ELARUS         *131018*0343*U*00401*000000001*0*T*>~
GS*IM*JAFR*ELARUS1*20131018*034056*108340*X*004010~
ST*110*0001~
B3**US46513*CT455353*TP*L*20130918*2032360**20130919*035*JAFR***   ~
C3*USD~
N9*PO*455353~
N1*BT*ELIZABETH ARDEN~
N3*1751 BLUE HILLS DR.  N.E.~
N4*ROANOKE*VA*24012*US~
N1*SH*ELIZABETH ARDEN~
N3*1751 BLUE HILLS DRIVE~
N4*ROANOKE*VA*24012*US~
N1*CN*CEPL COIGNIERES~
N3*ZI DU MARAIS~
N4*COIGNIERES**78310*FR~
LX*1~
P1**20130918*370~
R1***IAD*057*CDG~
L5*1*455353~
L0*1***399.02*N********1~
L1*1*10.0**222460****101************USD~
L1*2*100.0**1809900****102************USD~
L3*490.43*B***2032360*******L~
SE*22*0001~
GE*000001*108340~
IEA*1*000000001~

Personal tools