Shipment Financials Invoice Outbound File Definition - Shipwell Format - Customer Facing SFTP Documentation.xlsx

	A	B	C	D
1	Shipwell Shipment Financials Invoice Outbound File Definition
2
3	The sheet includes details on the structure and format of the Shipwell Shipment Financials Outbound Invoice CSV file produced by the Shipwell system.
4	Files produced by Shipwell will have UTF-8 encoding and will be a comma-delimited CSV with double quote encapsulation for the cells (i.e. enables values in the cells may contain commas themselves like "abc,123").
5	Below are the column definitions and additional examples of valid data.
6
7	Column	Description	Example	Notes

8	carrier_scac	Standard Carrier Alpha Code (usually 4 chars) of the carrier	ABCD
9	carrier_name	Name of the carrier	ABCD Express
10	invoice_number	Carrier Invoice Number	INV456789
11	invoice_date	The data that the carrier invoiced the shipment, formatted as YYYYMMDD	20170501
12	invoice_type	The payment type of the shipment: PP - prepaid, CC - collect	PP
13	reference_id	Shipment reference identifier	SWL123
14	po_list	Purchase order (PO) number or list of PO numbers separated by comma	ponum1,ponum2
15	order_number_list	List of related order numbers separated by comma	ORD-1,ORD-2
16	pro_number	PRO Number of the shipment	987654321
17	bol_number	BOL Number of the shipment - reference number the carrier uses	246813790
18	pickup_date	The date at which the shipment will be picked up	20170428
19	delivery_date	The date at which the shipment will be delivered	20170501
20	origin_company	Origin Company	ABC Origin Co
21	origin_address1	Origin Address	45 Washington Meadow
22	origin_address2	Origin Address2	Suite 123
23	origin_city	Origin City	Waltham
24	origin_state_province	Origin State Province	MA
25	origin_postal_code	Origin Postal Code	2453
26	destination_company	Destination Company	XYZ Dest Co
27	destination_address1	Destination Address	1 Dest St
28	destination_address2	Destination Address2	Suite 456
29	destination_city	Destination City	Beverly Hills
30	destination_state_province	Destination State Province	LA
31	destination_postal_code	Destination Postal Code	90210	String and not numeric
32	total_weight	Total weight of the shipment	2500	Weight in LBs. Can be decimal value.
33	total_units	Total number of units on the shipment	15
34	freight_charge	Linehaul charge owed to the carrier	1200	Can be decimal value.
35	fuel_surcharge	Fuel charge owed to the carrier	150	Can be decimal value.
36	accessorial_surcharge	Accessorial charge owed to the carrier	10	Can be decimal value.
37	other_surcharge	Other Surcharge charge owed to the carrier	5	Can be decimal value.
38	invoice_total	Total Accounts Payables Amount that is owed to the carrier (Linehaul + Fuel+ Accessorial+Surcharge)	1715	Can be decimal value.
39	currency	Three-character ISO-4217 currency code of invoice, e.g. "USD"	USD
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100