Arden 110 Air
From UG
(→Movement Type) |
(→Terms / Incoterms) |
||
Line 224: | Line 224: | ||
* '''item#''' s | * '''item#''' s | ||
* '''map:''' [[CT#Shipping Terms]] | * '''map:''' [[CT#Shipping Terms]] | ||
- | * '''EDI:''' B314 | + | * '''EDI:''' B314; send 3 digit code, see [[#Codes for Terms]] |
=== Carrier Name === | === Carrier Name === |
Revision as of 18:20, 3 September 2013
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. This list can be found in section #Original Ardens List at the end of this wiki.
- #Additional Fields - fields that Jaguar added to above list for the first release
- #Future Fields - possible additional options
Format
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
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
- Rel# 1.0
- item # b
- map: SI#Invoice Number
- EDI: B302
Bill Of Lading Number
- Rel# 1.0
- item # c
- map: CT#HAWB
- EDI: L502
- notes:
- per Jaguar - for Air we pass HAWB
Load Number
- Rel# 1.0
- item# d
- map: CT#CT Number
- EDI: B303
- notes: TBC
- per Arden - required for inbound only.
- 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
- Rel# 1.0
- 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
- Rel# 1.0
- 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
- Rel# 1.0
- item# h
- map: CT#Airport Of Destination
- EDI: R105
- notes:
- Per Arden - only required air / ocean int. shipments
Port of Departure
- Rel# 1.0
- item# i
- map: CT#Airport Of Departure
- EDI: R103
- notes:
- Per Arden - only required air / ocean int. shipments
Delivery Date
- Rel# 1.0
- item# j
- map: CT#Estimated Delivery Date
- EDI: B309
- notes: TBC w/ Dawn (estimated is OK? destination door date and not port is OK?)
Ship Date
- Rel# 1.0
- item# k
- map: CT#Actual Pick Up Date
- EDI: P102 Pick-up Date
- notes:
Invoice Date
- Rel# 1.0
- item# l
- map: SI#Issuing Date
- EDI: B36
- notes:
Total # of pieces
- Rel# 1.0
- item# m
- map: Commodity#plts
- EDI: L013
- notes: TBC w/ Dawn if need to include loose as well into count
Total Weight
- Rel# 1.0
- item# n
- map: Commodity#Grand Total: Gross Kg
- EDI: L0_4 (TBC) is wrong?, L3_1 (Weight) is correct?
- notes: in kg
Billed Weight
- Rel# 1.1
- item# o
- map: CT#Chargeable Weight
- EDI: TBC with Brandon
- notes:
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
- Rel# 1.0
- 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.
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
- Rel# 1.1
- item# s
- map: CT#Shipping Terms
- EDI: B314; send 3 digit code, see #Codes for Terms
Carrier Name
- Rel# 1.0
- item# t
- map: CT#Airline
- EDI: R104
- note: sending code to be translated
Pro#
- Rel# n/a
- item# u
- map:
- EDI:
- notes: UNUSED for Air and Ocean, 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
- 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
- Rel# 1.0
- Map: value CA(cancel bill) or CO(Correction)?
- EDI spec: B308 202 Correction Indicator O ID 2/2
- TBC w/ d2l
Method of Payment
- Rel# 1.0
- Map: value CC (Collect) for all shipments
- EDI spec: B304 146 Shipment Method of Payment M ID 2/2
- TBC w/ d2l
Invoice Amount
- Rel# 1.0
- Map: SI#Total Invoice
- EDI spec: B3_7, L3_5
- Notes: From Jaguar - this field is obviously required on invoice but was missing from Original Fields List so we added it.
Invoice Currency
- Rel# 1.0
- 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
- Rel# 1.0
- 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
- Rel# 1.0
- 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:
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
- Rel# 1.0
- Map: SI#CC
- EDI spec: L1_8
Charge Amount
- Rel# 1.0
- Map: SI#CC Amount
- EDI spec: L1_4
Charge Currency
- Rel# 1.0
- Map: SI#CC Currency
- EDI spec: L1_20
Future Fields
Some of these fields were inspired by pdf version of invoice.
All Shippers
Name / address for all shippers in case of CT group.
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
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
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
See Also
- Sales Invoices EDI - master wiki for this project