Recipe 5 - CdxVehicleExchange Flatfile Definitions

The CDXVEHICLE file is a flatfile. Fields are comma separated. and "," used to protect comma. Line are CR/LF terminated

File Format

CDXVEHICLES
SHIPMENT
VEHICLES (1 or more)
CDXEND

CDX VEHICLE EXHANGE
FIELD NAME	LENGTH	DEFAULT / OPTIONS
CDXVEHICLES	Header
EventDateTime Time the sender sent the inventory	20	YYYY-MM-DD HH:MM:SS UTC
SenderInventoryId Senders Inventory reference	40
ExchangeId CDX Unique Excahnge Id, Use this Id for keeping track of a Shipment request from CDX.	20
SHIPMENT	Header
SenderScac Scac of Sender	10
ReceiverScac Scac of recipient	10
SenderJobNumber A to B Job Number of Sender in senders system	20
SenderLoadId A to B Load Number from Senders system	40
SenderTripId Trip Number, Should be used to keep the inventory together on a truck	20
Price Price for the full shipment	10
Notes Notes for driver ? logistics	300
TruckId	30	obsolete
DriverId	30	obsolete
SenderOriginCode Code the location is known as by Shipper / OEM	30
SenderInternalOriginCode Code the location is known as by the sender	30
SenderLocationCode Locatiuon code used by the sender	30
RequestedPickupDate Date the vehicles are required to be picked up by	20
OrganizationName Name of the location	100
AddressLine1 First Address line	300
AddressLine2 Second Address line	100
City Location city	50
State Location State	2
ZipCode Location Zip Code	10
Contact Contact at Location	100
Email Email for location	300
Phone Phone number at location	30
Notes Notes particular to the location	300
Country Country of Location	2
VEHICLE	Header
ShipperScac Shipper Scac code	10
Vin VIN of vehicle	17
Make Make of vehicle	50
Model Vehicle Model	50
Year Vehicle year of registration	50
Variant Vehicle model variant	50
Color Color of vehicle	30
VehicleType Type of vehicle	20
Weight Weight of vehicle in lbs	6
Location Location vehicle is parked	50
MovementNumber Unique movement number in sender system	50
ReferenceNumber PO or order refernce for reciever	50
PerVehiclePrice Price paid for vehicle	10
VehicleNote Notes particular to vehicle	300
SenderDestinationCode Location of destination known by Shipper or OEM eg Dealer code	30
SenderInternalDestinationCode Code the destination is know by the sender	30
SenderLocationCode Code the location is known by the sender	30
RequestedDropDate Date vehicles should be dropped by	20
OrganizationNameName of location	100
AddressLine1 Addres at location	100
AddressLine2 Address at location	100
City City of location	50
StateRegion State of location	2
ZipPostCode ZipCode of location	10
Contact Contact at location	100
Email Email at location	300
Phone Phone at Location	30
Notes Notes at Location	300
Country Country of location	2
CDXEND	Header