Kirk,
I am a little confused with your example. Do you mean you receive the same
status message for the same load multiple times? I am envisioning an X3
(arrived at pickup) or would this be like an X6 status (enroute to delivery
location)? Are all the reason codes associated with the status message the
same or blank? If the status code is the same but the reason code is
different you could use that. Do you receive a time along with the date that
is associated with the status code? This could be another way of tying the
messages together with the tracking number or whatever number you are using
to identify your loads.
The trucking companies I work with use a load number assigned from their
dispatch systems. This could be a billing number, a schedule number or
invoice number. Again it would not be unique for the same load with the
same status messages unless you used a time associated with the status
message. You should never get the same status message sent multiple times
with the same time maybe the same date.
Hope this was what you were looking for.
Pat Bowe
EDI Specialist
Data Communication Solutions
(952) 941-5466 office
[EMAIL PROTECTED]
-----Original Message-----
From: Electronic Data Interchange Issues
[mailto:[EMAIL PROTECTED]]On Behalf Of Kenneway, Kirk
Sent: Wednesday, August 29, 2001 4:11 PM
To: [EMAIL PROTECTED]
Subject: 214
Greetings all,
I was hoping someone could help me out.
We're building a process to load 214 status messages from carriers. The
problem (well, one of the problems) we are having is that it is very
difficult to uniquely identify each status message. I'm wondering how you've
done it.
For example:
I contract with a carrier to deliver my freight across the country. It's a 5
day trip. The carrier sends me at least one 214 each day. I want to link the
214 to the 856 and the original 850.
What have you used as the primary key on the 214 to uniquely identify it?
They all have the same BOL, the same tracking number, the same PO, etc. The
date might change, but I could get two or more on the same day, with the
same status message. The envelope control numbers are unique, but my
database guys don't want to use it.
Any suggestions would be appreciated.
Thanks
Kirk Kenneway.
=======================================================================
To contact the list owner: mailto:[EMAIL PROTECTED]
Archives at http://www.mail-archive.com/edi-l%40listserv.ucop.edu/
=======================================================================
To contact the list owner: mailto:[EMAIL PROTECTED]
Archives at http://www.mail-archive.com/edi-l%40listserv.ucop.edu/
