Arden 110 Air

From UG

(Difference between revisions)
Jump to: navigation, search
(Original Ardens List)
(Charge Rate)
 
(164 intermediate revisions not shown)
Line 1: Line 1:
-
[[Category:Ops]]
+
[[Category:SI EDI]]
-
== About ==
+
== Intro ==
-
This wiki defines fields required for EDI 110 (Air) transmission from JaguarFreight to Elizabeth Arden through Data2Logistics.
+
* This wiki defines fields required for EDI transmission of '''Air (110)''' Sales Invoices.
-
==Original Ardens List ==
+
* '''Item''' represents item# on original Arden's list - see [[SI_EDI_Misc#Original_Ardens_List]].
-
Each section below corresponds to one field from '''Required List Of Fields''' we received from Arden through Data2Logistics at the beginning of the project.  
+
* [[#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]].
-
For each field below Jaguar added some additional information.
+
* [[#Additional Fields A]] - fields that Jaguar added to above list for the first release.
-
'''Item''' represents item# on original Arden's list.
+
== Protocol ==
-
'''Map''' provides info about internal mapping into CT2 fields.  
+
See [[Media:4010 110.pdf]]
-
'''EDI''' represents relevant EDI protocol info (segment, element, required or not, format, etc).
+
== Original Fields ==
-
 
+
-
'''Notes''' supply some additional in most cases business analysis related info. Fields that are self explanatory and well understood contain no notes.
+
-
 
+
-
=== Ultimate Consignee ===  
+
-
 
+
-
* '''item #''' a
+
-
* '''map:''' [[#Consignee]]
+
-
* '''EDI:''':
+
-
* '''notes:''' 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.
+
=== Invoice Number ===
=== Invoice Number ===
* '''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 ===
* '''item #''' c
* '''item #''' c
-
* '''map:''' [[CT#HAWB]]
+
* '''map:''' [[CT#HAWB]] for CT and CT group cases
-
* '''EDI:'''
+
* '''EDI:''' L502
-
* '''notes:''' per Jaguar - for Air we pass HAWB, which in most cases will be a CT#
+
* '''notes:'''
 +
** per Jaguar - for Air we pass HAWB
=== Load Number ===  
=== Load Number ===  
* '''item#''' d
* '''item#''' d
-
* '''map:''' [[CT#Smallest CT]]
+
* '''map:''' [[CT#CT Number]] for CT and CT group cases
-
* '''EDI:'''
+
* '''EDI:''' B303
-
* '''notes:''' per Arden - required for inbound only. Per Jaguar - we pass smallest CT# in the CT group or CT# if there is no CT group. Alternative is to pass group number (GRP#).
+
* '''notes:'''  
 +
** per Arden - confirmed w/ Dawn
-
* e. Shipper Acct #
+
=== Shipper Info ===
-
(only required for small package carriers)
+
* '''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]]
-
* f. Shipper info including address (city, state, zip and county code)
+
=== Consignee Info ===
-
* g. Consignee Info including address (city, state, zip and county code)
+
* '''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]]
-
* h. Port of Entry (only required air / ocean int. shipments)
+
=== Port of Entry ===
-
* i. Port of Departure (only required air / ocean int. shipments)
+
* '''item#''' h
 +
* '''map:''' [[CT#Airport Of Destination]] for CT and CT group cases
 +
* '''EDI:''' R105
 +
* '''notes:'''
 +
** Per Arden - only required air / ocean int. shipments
-
* j. Delivery Date
+
=== Port of Departure ===
-
* k. Ship Date
+
* '''item#''' i
 +
* '''map:''' [[CT#Airport Of Departure]] for CT and CT group cases
 +
* '''EDI:''' R103
 +
* '''notes:'''
 +
** Per Arden - only required air / ocean int. shipments
-
* l. Invoice Date
+
=== Delivery Date ===
-
* m. Total # of pieces
+
* '''item#''' j
 +
* '''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
-
* n. Total Weight
+
=== Ship Date ===
-
* o. Billed Weight
+
* '''item#''' k
 +
* '''map:''' [[CT#Origin Port Actual Departure Date]] for CT and CT group cases
 +
* '''EDI:'''  P102 Pick-up Date
 +
* '''notes:'''
-
* p. Mileage
+
=== Invoice Date ===
-
* q. Movement Type (Mode and any expedited options)
+
* '''item#''' l
 +
* '''map:'''  [[SI#Issuing Date]] for CT and CT group cases
 +
* '''EDI:''' B306
 +
* '''notes:'''
-
* r. Container Size (20, 40, 40HC, LCL) (only required air / ocean int. shipments)
+
=== Total # of pieces ===
-
* s. Terms / Incoterms
+
* '''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
-
* t. Carrier Name
+
=== Total Weight ===
-
* u. Pro#
+
* '''item#''' n
 +
* '''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:04 ; also set L0:05=N  (stands for  Actual Net Weight)
 +
* send in lb
-
* v. Freight Cost
+
=== Billed Weight ===
-
* w. Accessorial costs
+
* '''item#''' o
 +
* '''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:01; also set L3:02 = B (stands for  Billed Weight)
 +
* * send in lb
-
== Jaguars List ==
+
=== Movement Type ===
-
== Future List ==
+
* '''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.
-
=== Invoice Number ===
+
=== Terms / Incoterms ===
-
* '''Map:''' [[SI#Invoice Number]]  
+
* '''item#''' s
-
* '''EDI spec''': B302
+
* '''map:''' [[CT#Shipping Terms]] for CT and CT group cases
-
* '''Notes''':
+
* '''EDI:''' B314; send 3 digit code, see [[#Codes for Terms]]
-
=== Invoice Issuing Date ===
+
=== Carrier Name ===
-
* '''Map:'''  [[SI#Issuing Date]]  
+
* '''item#''' t
-
* '''EDI spec''': B302
+
* '''map:''' [[CT#Airline]] or CT and CT group cases
-
* '''Notes''':  
+
* '''EDI:''' R104
 +
** note: sending code to be translated
 +
 
 +
=== 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
 +
 
 +
== Additional Fields A ==
 +
 
 +
=== Correction Indicator ===
 +
 
 +
* '''Map:''' value CO per Brandon
 +
* '''EDI spec''': B308 202 Correction Indicator O  ID  2/2
 +
 
 +
=== 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
 +
 
 +
=== 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.
 +
 
 +
=== 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.
=== Invoice Bill To Company Name ===
=== Invoice Bill To Company Name ===
Line 106: Line 174:
* '''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
-
* '''Notes''':
+
* '''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.
=== Invoice Bill To Address ===
=== Invoice Bill To Address ===
*  '''Map:''' [[SI#Bill To Address]]  
*  '''Map:''' [[SI#Bill To Address]]  
-
* '''EDI spec''':   
+
* '''EDI spec''':  N3, N4 (BT)
-
* '''Notes''':  
+
* '''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.
-
=== Invoice Amount ===
+
=== Table Of Charges Fields ===
-
*  '''Map:''' [[SI#Total Invoice]]  
+
This corresponds to the following two Items on the [[#Original Fields]] List:
-
* '''EDI spec''': 
+
-
* '''Notes''':  
+
-
=== Invoice Currency ===
+
* v. Freight Cost
 +
* w. Accessorial costs
-
*  '''Map:''' [[SI#Total Invoice Currency]]  
+
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:
-
* '''EDI spec''':
+
 
-
* '''Notes''':
+
* [[#Charge Code]]
 +
* [[#Charge Amount]]
 +
* [[#Charge Currency]]
 +
 
 +
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.
 +
 
 +
==== Charge Code ====
 +
 
 +
*  '''Map:''' [[SI#CC]]  
 +
* '''EDI spec''': L108
 +
 
 +
==== Charge Amount ====
-
== Table Of Charges ==
+
*  '''Map:''' [[SI#CC Amount]]
 +
* '''EDI spec''': L104
-
A-List:
+
==== Charge Currency ====
-
- v. Freight Cost;
+
-
- w. Accessorial costs
+
-
For every line in TOC we are sending this set of fields:
+
*  '''Map:''' [[SI#CC Currency]]
 +
* '''EDI spec''': L120
-
=== Charge Code ===
+
==== Charge Rate ====
-
=== Charge Amount ===
+
*  '''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
-
=== Charge Currency ===
+
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~
-
== Other Shipment Fields ==
+
== Misc ==
-
* CT# // c. Bill of Lading number //
+
=== Codes for Terms ===
-
* Shipper Company and Address // f. Shipper info //
+
-
* Consignee Company and Address // g. Consignee Info //
+
-
* MOT // q. Movement Type //
+
001 / CFR
-
* Airline or Shipping Line or Pick Up Trucker // t. Carrier Name
+
-
* Gen Tab. 14. Shipping Terms // s. Terms / Incoterms
+
-
* Cont Tab // r. Container Size
+
-
* GRP# // d. LOAD NUMBER
+
002 / CIF
-
== Shipment Commodity Info ==
+
003 / CIP
-
* ?? // m. Total # of pieces //
+
004 / CPT
-
* TTl GW // n. Total Weight and o. Billed Weight //  
+
-
== Shipment Locations ==
+
005 / DAP
-
* Port of Loading // h. Port of Entry
+
006 / DDP
-
* Port Of Discharge // i. Port of Departure
+
-
== Shipment Dates ==
+
007 / DDU
-
* Actual for Destination Door // j. Delivery Date
+
008 / DEQ
-
* Actual for Origin Door // k. Ship Date
+
-
===== Additional Ardens List fields =====
+
009 / EXW
-
* na? // e. Shipper Acct # (only required for small package carriers) //
+
010 / FCA
-
* optional // u. Pro#
+
-
* optional // p. Mileage
+
-
* same as Consignee // a. Ultimate Consignee //
+
011 / FOB
-
===== Data2Log fields =====
+
012 / LDP
-
* ISA Qualifier: *ZZ*
+
== Example ==
-
* ISA Receiver ID: ELARUS
+
-
* GS Receiver ID: ELARUS
+
-
== Future options ==
+
<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>
-
=== Invoice Comments ===
+
[[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