Arden 110 Air

From UG

Revision as of 20:09, 24 September 2013 (edit) Alex (Talk | contribs) (→Total Weight) ← Older edit		Revision as of 20:15, 24 September 2013 (edit) (undo) Alex (Talk | contribs) (→Billed Weight) Newer edit →
Line 141:		Line 141:
	* '''item#''' o		* '''item#''' o
	* '''map:''' [[CT#Chargeable Weight]]		* '''map:''' [[CT#Chargeable Weight]]
-	* '''EDI:'''   L3_1 confirmed w/ Brandon	+	* '''EDI:'''   L3:01; also set L3:02 = B (stands for  Billed Weight)
	=== Movement Type ===		=== Movement Type ===

---

Revision as of 20:15, 24 September 2013

Contents 1 Intro 1.1 Format 1.2 Tags 1.3 Credit Notes vs Invoices 1.4 Group Logic 2 Original Fields 2.1 Invoice Number 2.2 Bill Of Lading Number 2.3 Load Number 2.4 Shipper Info 2.5 Consignee Info 2.6 Port of Entry 2.7 Port of Departure 2.8 Delivery Date 2.9 Ship Date 2.10 Invoice Date 2.11 Total # of pieces 2.12 Total Weight 2.13 Billed Weight 2.14 Movement Type 2.15 Terms / Incoterms 2.16 Carrier Name 2.17 Pro# 3 Additional Fields 3.1 Correction Indicator 3.2 Method of Payment 3.3 Invoice Amount 3.4 Invoice Currency 3.5 Invoice Bill To Company Name 3.6 Invoice Bill To Address 3.7 Table Of Charges Fields 3.7.1 Charge Code 3.7.2 Charge Amount 3.7.3 Charge Currency 3.7.4 Charge Rate 4 Misc 4.1 Codes for Terms 5 See Also

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).

There are 3 lists of fields here:

• #Original Fields - Required List Of Fields Jaguar received from Arden through Data2Logistics at the beginning of the project.

• #Additional Fields - fields that Jaguar added to above list for the first release

Format

For each field Jaguar added the following information - see below.

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.

Original Fields

Invoice Number

• item # b
• map: SI#Invoice Number
• EDI: GS:04 UPDATED sep 4

Bill Of Lading Number

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

Load Number

• item# d
• map: CT#CT Number confirmed w Dawn
• EDI: B303
• notes:
  • per Arden - required for inbound only.

Shipper Info

• item# f
• map: CT#Shipper and CT#Shipper Address
• 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

Consignee Info

• item# g
• map: CT#Consignee and CT#Consignee Address
• 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

Port of Entry

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

Port of Departure

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

Delivery Date

• item# j
• map: CT#Destination Port Actual Arrival Date , if actual dates are not available then send equivalent estimated dates
• EDI: B309

Ship Date

• item# k
• map: CT#Origin Port Actual Departure Date
• EDI: P102 Pick-up Date
• notes:

Invoice Date

• item# l
• map: SI#Issuing Date
• EDI: B306
• notes:

Total # of pieces

• item# m
• map: Commodity#plts
• EDI: L013
• notes: TBC w/ Dawn if need to include loose as well into count

Total Weight

• item# n
• map: Commodity#Grand Total: Gross Kg
• EDI: L0:04 ; also set L0:05=N (stands for Actual Net Weight)
• notes: in kg

Billed Weight

• item# o
• map: CT#Chargeable Weight
• EDI:  L3:01; also set L3:02 = B (stands for Billed Weight)

Movement Type

• item# q
• map: CT#Transport Mode Type
• 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.

Terms / Incoterms

• item# s
• map: CT#Shipping Terms
• EDI: B314; send 3 digit code, see #Codes for Terms

Carrier Name

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

Pro#

• item# u
• map: per Dawn map to CT#HAWB
• 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

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

• 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.

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.

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:

• #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

• Map: SI#CC Amount
• EDI spec: L104

Charge Currency

• Map: SI#CC Currency
• EDI spec: L120

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

Misc

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

See Also

• Sales Invoices EDI - master wiki for this project

• Arden 210

• Arden 310