Arden 110 Air
From UG
(→Table Of Charges Fields) |
|||
Line 7: | Line 7: | ||
There are 3 lists of fields here: | 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 | + | * [[#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 | * [[#Additional Fields]] - fields that Jaguar added to above list for the first release | ||
- | |||
- | |||
- | |||
=== Format === | === Format === | ||
For each field Jaguar added the following information - see below. | For each field Jaguar added the following information - see below. | ||
- | |||
- | |||
'''Item''' represents item# on original Arden's list. | '''Item''' represents item# on original Arden's list. | ||
Line 49: | Line 44: | ||
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. | 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 == | == Original Fields == | ||
Line 59: | Line 49: | ||
=== Invoice Number === | === Invoice Number === | ||
- | |||
* '''item #''' b | * '''item #''' b | ||
* '''map:''' [[SI#Invoice Number]] | * '''map:''' [[SI#Invoice Number]] | ||
Line 66: | Line 55: | ||
=== Bill Of Lading Number === | === Bill Of Lading Number === | ||
- | |||
* '''item #''' c | * '''item #''' c | ||
* '''map:''' [[CT#HAWB]] | * '''map:''' [[CT#HAWB]] | ||
Line 75: | Line 63: | ||
=== Load Number === | === Load Number === | ||
- | |||
* '''item#''' d | * '''item#''' d | ||
* '''map:''' [[CT#CT Number]] confirmed w Dawn | * '''map:''' [[CT#CT Number]] confirmed w Dawn | ||
Line 84: | Line 71: | ||
=== Shipper Info === | === Shipper Info === | ||
- | |||
* '''item#''' f | * '''item#''' f | ||
* '''map:''' [[CT#Shipper]] and [[CT#Shipper Address]] | * '''map:''' [[CT#Shipper]] and [[CT#Shipper Address]] | ||
Line 94: | Line 80: | ||
=== Consignee Info === | === Consignee Info === | ||
- | |||
* '''item#''' g | * '''item#''' g | ||
* '''map:''' [[CT#Consignee]] and [[CT#Consignee Address]] | * '''map:''' [[CT#Consignee]] and [[CT#Consignee Address]] | ||
Line 104: | Line 89: | ||
=== Port of Entry === | === Port of Entry === | ||
- | |||
* '''item#''' h | * '''item#''' h | ||
* '''map:''' [[CT#Airport Of Destination]] | * '''map:''' [[CT#Airport Of Destination]] | ||
Line 113: | Line 97: | ||
=== Port of Departure === | === Port of Departure === | ||
- | |||
* '''item#''' i | * '''item#''' i | ||
* '''map:''' [[CT#Airport Of Departure]] | * '''map:''' [[CT#Airport Of Departure]] | ||
Line 122: | Line 105: | ||
=== Delivery Date === | === Delivery Date === | ||
- | |||
* '''item#''' j | * '''item#''' j | ||
* '''map:''' [[CT#Actual Delivery Date]] and if not available then send [[CT#Estimated Delivery Date]] | * '''map:''' [[CT#Actual Delivery Date]] and if not available then send [[CT#Estimated Delivery Date]] | ||
Line 129: | Line 111: | ||
=== Ship Date === | === Ship Date === | ||
- | |||
* '''item#''' k | * '''item#''' k | ||
* '''map:''' [[CT#Actual Pick Up Date]] | * '''map:''' [[CT#Actual Pick Up Date]] | ||
Line 137: | Line 118: | ||
=== Invoice Date === | === Invoice Date === | ||
- | |||
* '''item#''' l | * '''item#''' l | ||
* '''map:''' [[SI#Issuing Date]] | * '''map:''' [[SI#Issuing Date]] | ||
Line 145: | Line 125: | ||
=== Total # of pieces === | === Total # of pieces === | ||
- | |||
* '''item#''' m | * '''item#''' m | ||
* '''map:''' [[Commodity#plts]] | * '''map:''' [[Commodity#plts]] | ||
Line 153: | Line 132: | ||
=== Total Weight === | === Total Weight === | ||
- | |||
* '''item#''' n | * '''item#''' n | ||
* '''map:''' [[Commodity#Grand Total: Gross Kg]] | * '''map:''' [[Commodity#Grand Total: Gross Kg]] | ||
Line 161: | Line 139: | ||
=== Billed Weight === | === Billed Weight === | ||
- | |||
* '''item#''' o | * '''item#''' o | ||
* '''map:''' [[CT#Chargeable Weight]] | * '''map:''' [[CT#Chargeable Weight]] | ||
Line 168: | Line 145: | ||
=== Movement Type === | === Movement Type === | ||
- | |||
* '''item#''' q | * '''item#''' q | ||
* '''map:''' [[CT#Transport Mode Type]] | * '''map:''' [[CT#Transport Mode Type]] | ||
Line 179: | Line 155: | ||
=== Terms / Incoterms === | === Terms / Incoterms === | ||
- | |||
* '''item#''' s | * '''item#''' s | ||
* '''map:''' [[CT#Shipping Terms]] | * '''map:''' [[CT#Shipping Terms]] | ||
Line 186: | Line 161: | ||
=== Carrier Name === | === Carrier Name === | ||
- | |||
* '''item#''' t | * '''item#''' t | ||
* '''map:''' [[CT#Airline]] | * '''map:''' [[CT#Airline]] | ||
Line 194: | Line 168: | ||
=== Pro# === | === Pro# === | ||
- | |||
* '''item#''' u | * '''item#''' u | ||
* '''map:''' per Dawn map to [[CT#HAWB]] | * '''map:''' per Dawn map to [[CT#HAWB]] | ||
Line 204: | Line 177: | ||
=== Correction Indicator === | === Correction Indicator === | ||
- | |||
* '''Map:''' value CA(cancel bill) or CO(Correction)? | * '''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 | ||
Line 211: | Line 183: | ||
=== Method of Payment === | === Method of Payment === | ||
- | |||
* '''Map:''' set as "TP" for all shipments (per Dawn) | * '''Map:''' set as "TP" for all shipments (per Dawn) | ||
* '''EDI spec''': B304 146 Shipment Method of Payment M ID 2/2 | * '''EDI spec''': B304 146 Shipment Method of Payment M ID 2/2 | ||
Line 218: | Line 189: | ||
=== Invoice Amount === | === Invoice Amount === | ||
- | |||
* '''Map:''' [[SI#Total Invoice]] | * '''Map:''' [[SI#Total Invoice]] | ||
* '''EDI spec''': B3_7, L3_5 why use these 2 segments??? can we use just B307 for all MOTs?? | * '''EDI spec''': B3_7, L3_5 why use these 2 segments??? can we use just B307 for all MOTs?? | ||
Line 225: | Line 195: | ||
=== Invoice Currency === | === Invoice Currency === | ||
- | |||
* '''Map:''' [[SI#Total Invoice Currency]] | * '''Map:''' [[SI#Total Invoice Currency]] | ||
* '''EDI spec''': C3_1 | * '''EDI spec''': C3_1 | ||
Line 232: | Line 201: | ||
=== Invoice Bill To Company Name === | === Invoice Bill To Company Name === | ||
- | |||
* '''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 239: | Line 207: | ||
=== Invoice Bill To Address === | === Invoice Bill To Address === | ||
- | |||
* '''Map:''' [[SI#Bill To Address]] | * '''Map:''' [[SI#Bill To Address]] | ||
* '''EDI spec''': N3, N4 (BT) | * '''EDI spec''': N3, N4 (BT) | ||
Line 263: | Line 230: | ||
==== Charge Code ==== | ==== Charge Code ==== | ||
- | |||
* '''Map:''' [[SI#CC]] | * '''Map:''' [[SI#CC]] | ||
* '''EDI spec''': L108 | * '''EDI spec''': L108 | ||
Line 269: | Line 235: | ||
==== Charge Amount ==== | ==== Charge Amount ==== | ||
- | |||
* '''Map:''' [[SI#CC Amount]] | * '''Map:''' [[SI#CC Amount]] | ||
* '''EDI spec''': L104 | * '''EDI spec''': L104 | ||
Line 275: | Line 240: | ||
==== Charge Currency ==== | ==== Charge Currency ==== | ||
- | |||
* '''Map:''' [[SI#CC Currency]] | * '''Map:''' [[SI#CC Currency]] | ||
* '''EDI spec''': L120 | * '''EDI spec''': L120 | ||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
=== Codes for Terms === | === Codes for Terms === |
Revision as of 06:27, 4 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.
- #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: B302
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#Actual Delivery Date and if not available then send CT#Estimated Delivery Date
- EDI: B309
Ship Date
- item# k
- map: CT#Actual Pick Up 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_4 confirmed
- notes: in kg
Billed Weight
- item# o
- map: CT#Chargeable Weight
- EDI: L3_1 confirmed w/ Brandon
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 CA(cancel bill) or CO(Correction)?
- EDI spec: B308 202 Correction Indicator O ID 2/2
- TBC w/ d2l
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:
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
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