-----Original Message-----
From: Debbie Shaver <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Tuesday, May 02, 2000 6:29 PM
Subject: EDI System Design Question
>...I understand FAs (997s) can be used to
>indicate the transaction made it to the "receiving" translator,
but how do
>I make sure it gets into the receiving business application??
How do I make
>sure the custom code that moves the data from the GENTRAN output
into the
>business application doesn't have a coding mistake in it that
might cause
>records to be dropped/inserted incorrectly??
I assume that the GENTRAN product you are using is GENTRAN for
Windows NT
(that's what I'm familiar with). If it's the Unix or AS/400
GENTRAN, ignore
everything I write.
Each inbound document translated by GENTRAN creates a record in
GENTRAN's
database. There are fields in this record which link to the EDI
control
numbers, and fields which can be filled with application
information from
the document. Other fields contain the translation status of the
document
(it may fail translation because of custom checks in your map).
Suppose it is an 850. You can have your inbound map fill the
app-data fields
with the PO number, version, and customer ID, and a status flag
that says
"New inbound document here."
When translations are all done, some application of yours comes
along to
move the information extracted from the document by translation
into your
application's database. That same application should be able to
examine
the appropriate tables in the _GENTRAN_ database, compile a list
of the
PO Numbers of all new documents, and compare this list to the PO
numbers
found in the file of translated data. Your application can at the
same
time locate documents which failed translation, by their GENTRAN
status.
(The GENTRAN database is a standard SQL database, and the layout
of all
tables is given in the GENTRAN Administrator manual.)
If a PO number mysteriously goes missing - you have a bug.
Otherwise, you
know what's going on, and can report as necessary to your trading
partners.
=======================================================================
To signoff the EDI-L list, mailto:[EMAIL PROTECTED]
To subscribe, mailto:[EMAIL PROTECTED]
To contact the list owner: mailto:[EMAIL PROTECTED]
Archives at http://www.mail-archive.com/edi-l%40listserv.ucop.edu/
