Arden 110 Air

From UG

Revision as of 00:07, 2 September 2013 (edit) Alex (Talk | contribs) (→Original Ardens List) ← Older edit		Revision as of 00:23, 2 September 2013 (edit) (undo) Alex (Talk | contribs) Newer edit →
Line 104:		Line 104:
	* '''item#''' l		* '''item#''' l
-	* '''map:'''	+	* '''map:''' [[SI#Issuing Date]]
	* '''EDI:'''		* '''EDI:'''
	* '''notes:'''		* '''notes:'''
Line 185:		Line 185:
	* '''notes:'''		* '''notes:'''
-	== Jaguars List ==	+	== Additional Fields ==
-	== Future List ==	+	=== Invoice Amount ===
-	=== Invoice Number ===	+	*  '''Map:''' [[SI#Total Invoice]]
		+	* '''EDI spec''':
		+	* '''Notes''':
		+
		+	=== Invoice Currency ===
-	* '''Map:''' [[SI#Invoice Number]]	+	* '''Map:''' [[SI#Total Invoice Currency]]
-	* '''EDI spec''': B302	+	* '''EDI spec''':
	* '''Notes''':		* '''Notes''':
-
-	=== Invoice Issuing Date ===
-
-	* '''Map:'''  [[SI#Issuing Date]]
-	* '''EDI spec''': B302
-	* '''Notes''':
	=== Invoice Bill To Company Name ===		=== Invoice Bill To Company Name ===
Line 213:		Line 211:
	* '''Notes''':		* '''Notes''':
-	=== Invoice Amount ===	+	=== Table Of Charges Fields ===
-	*  '''Map:''' [[SI#Total Invoice]]	+	For every line in TOC we are sending this set of fields - see below.
-	* '''EDI spec''':	+
-	* '''Notes''':	+
-	=== Invoice Currency ===	+	Number of sets differ and depends on various factors.
-	*  '''Map:''' [[SI#Total Invoice Currency]]	+	This corresponds to the following two Items on [[Original Fields]] List
-	* '''EDI spec''':	+
-	* '''Notes''':	+
-		+
-	== Table Of Charges ==	+
-		+
-	A-List:	+
-	- v. Freight Cost;	+
-	- w. Accessorial costs	+
-		+
-	For every line in TOC we are sending this set of fields:	+
	=== Charge Code ===		=== Charge Code ===
Line 239:		Line 225:
	=== Charge Currency ===		=== Charge Currency ===
-	== Other Shipment Fields ==	+	== Future Fields ==
		+
		+	=== Invoice Comments ===
		+
		+	=== Shipment Info ===
	* CT# // c. Bill of Lading number //		* CT# // c. Bill of Lading number //
Line 252:		Line 242:
	* GRP# // d. LOAD NUMBER		* GRP# // d. LOAD NUMBER
-	== Shipment Commodity Info ==	+	=== Shipment Commodity Info ===
	* ?? // m. Total # of pieces //		* ?? // m. Total # of pieces //
	* TTl GW // n. Total Weight and o. Billed Weight //		* TTl GW // n. Total Weight and o. Billed Weight //
-	== Shipment Locations ==	+	=== Shipment Locations ===
	* Port of Loading // h. Port of Entry		* Port of Loading // h. Port of Entry
	* Port Of Discharge // i. Port of Departure		* Port Of Discharge // i. Port of Departure
-	== Shipment Dates ==	+	=== Shipment Dates ===
	* Actual for Destination Door // j. Delivery Date		* Actual for Destination Door // j. Delivery Date
	* Actual for Origin Door // k. Ship Date		* Actual for Origin Door // k. Ship Date
-
-	===== Additional Ardens List fields =====
-
-	* na? // e. Shipper Acct # (only required for small package carriers) //
-	* optional // u. Pro#
-	* optional // p. Mileage
-
-	* same as Consignee // a. Ultimate Consignee //
-
-	===== Data2Log fields =====
-
-	* ISA Qualifier: *ZZ*
-	* ISA Receiver ID: ELARUS
-	* GS Receiver ID: ELARUS
-
-	== Future options ==
-
-	=== Invoice Comments ===

---

Revision as of 00:23, 2 September 2013

Contents 1 About 1.1 Credit Notes 2 Original Fields 2.1 Ultimate Consignee 2.2 Invoice Number 2.3 Bill Of Lading Number 2.4 Load Number 2.5 Shipper Acct Number 2.6 Shipper Info 2.7 Consignee Info 2.8 Port of Entry 2.9 Port of Departure 2.10 Delivery Date 2.11 Ship Date 2.12 Invoice Date 2.13 Total # of pieces 2.14 Total Weight 2.15 Billed Weight 2.16 Mileage 2.17 Movement Type 3 Additional Fields 3.1 Invoice Amount 3.2 Invoice Currency 3.3 Invoice Bill To Company Name 3.4 Invoice Bill To Address 3.5 Table Of Charges Fields 3.6 Charge Code 3.7 Charge Amount 3.8 Charge Currency 4 Future Fields 4.1 Invoice Comments 4.2 Shipment Info 4.3 Shipment Commodity Info 4.4 Shipment Locations 4.5 Shipment Dates

About

This wiki defines fields required for EDI transmission of Air (110) Sales Invoices from JaguarFreight to Elizabeth Arden through Data2Logistics.

Credit Notes

Credit Notes will be transmitted with the same set of fields as invoices. Special EDI element will be passed to distinguish between Invoice and Credit Note.

Original Fields

Each section below corresponds to one field from Required List Of Fields we received from Arden through Data2Logistics at the beginning of the project.

For each field below 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.

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

• item # b
• map: SI#Invoice Number
• EDI: B302

Bill Of Lading Number

• item # c
• map: CT#HAWB
• EDI:
• notes: per Jaguar - for Air we pass HAWB, which in most cases will be a CT#

Load Number

• item# d
• map: CT#Smallest CT
• EDI:
• 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#).

Shipper Acct Number

• item# e
• map:
• EDI:
• notes: Per Arden - only required for small package carriers. Per Jaguar - this seems irrelevant to this project

Shipper Info

• item# f
• map:
• EDI:
• notes:

info including address (city, state, zip and county code)

Consignee Info

• item# g
• map:
• EDI:
• notes: Per Arden - includes address (city, state, zip and county code)

Port of Entry

• item# h
• map:
• EDI:
• notes: Per Arden - only required air / ocean int. shipments.

Port of Departure

• item# i
• map:
• EDI:
• notes: Per Arden - only required air / ocean int. shipments.

Delivery Date

• item# j
• map:
• EDI:
• notes:

Ship Date

• item# k
• map:
• EDI:
• notes:

Invoice Date

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

Total # of pieces

• item# m
• map:
• EDI:
• notes:

Total Weight

• item# n
• map:
• EDI:
• notes:

Billed Weight

• item# o
• map:
• EDI:
• notes:

Mileage

• item# p
• map:
• EDI:
• notes:

Movement Type

• item# q
• map:
• EDI:
• notes: Per Arden this is mode and any expedited options

• r. Container Size (20, 40, 40HC, LCL) (only required air / ocean int. shipments)

• item#
• map:
• EDI:
• notes:

• s. Terms / Incoterms

• item#
• map:
• EDI:
• notes:

• t. Carrier Name

• item#
• map:
• EDI:
• notes:

• u. Pro#

• item#
• map:
• EDI:
• notes:

• v. Freight Cost

• item#
• map:
• EDI:
• notes:

• w. Accessorial costs

• item#
• map:
• EDI:
• notes:

Additional Fields

Invoice Amount

• Map: SI#Total Invoice
• EDI spec:
• Notes:

Invoice Currency

• Map: SI#Total Invoice Currency
• EDI spec:
• Notes:

Invoice Bill To Company Name

• Map: SI#Bill To
• EDI spec: N102; AN; 1/60; use with N101=BT
• Notes:

Invoice Bill To Address

• Map: SI#Bill To Address
• EDI spec:
• Notes:

Table Of Charges Fields

For every line in TOC we are sending this set of fields - see below.

Number of sets differ and depends on various factors.

This corresponds to the following two Items on Original Fields List

Charge Code

Charge Amount

Charge Currency

Future Fields

Invoice Comments

Shipment Info

• CT# // c. Bill of Lading number //
• Shipper Company and Address // f. Shipper info //
• Consignee Company and Address // g. Consignee Info //

• MOT // q. Movement Type //
• 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

Shipment Commodity Info

•  ?? // m. Total # of pieces //
• TTl GW // n. Total Weight and o. Billed Weight //

Shipment Locations

• Port of Loading // h. Port of Entry
• Port Of Discharge // i. Port of Departure

Shipment Dates

• Actual for Destination Door // j. Delivery Date
• Actual for Origin Door // k. Ship Date