• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Address book numbers and interfaces

tom_brown

Active Member
Hi List,

I'm looking for some ideas...

I have an A/R interface to write, which will need to know the Address Book
number of the client to write records to the F03B11Z1 table, based on the
account number in the old system. The obvious thing to do then is use the
ALKY field on the address book. Except that I have many interfaces, with
many different foreign account numbers refering to the same client within
OW.

So how can I hold the equivilent of many values in one ALKY field?

Is there another/better way than creating a tag file allowing many records
per address number, based on the foriegn system name? Since this method
would not allow searches by old account number without lots of other mods...

I guess someone else must have already solved this one??

Cheers

Tom Brown



This email is intended for the addressee only. Internet communications
are not secure and therefore Clear Channel International Ltd, its parent and subsidiaries (which include More Group UK Ltd and More Group Ireland) do not accept legal responsibility for the contents of this message. Any views or opinions represented are solely those of the author and do not necessarily represent those of Clear Channel International Ltd, its parent and subsidiaries (which include More Group UK Ltd and More Group Ireland). If this email is not intended for you, please notify the author by replying to this email.
 

Zoltan_Gyimesi

Legendary Poster
Tom,
At first excuse me, this post won't be a help for your original issue but just one oppinion from me.

IMHO, there isn't better and more adequate solution than creating tag file(s). It is the most adequate, flexible solution and most easy to maintain solution.
I don't think so that it needs "lots of other mods".
What have you meant "lots of other mods"?

It was just an oppinion and I am also curious to that will anybody have a better or tricky solution for you.
(... we can never know on the List/Forum :)

Good luck,
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 
Hi Tom,

Using the ALKY key is the best way....

I have done the following which may be possible for you in the past.

1. If the old number is 8 bytes numeric, use this field as the JDE address
book number...

This may have problems though with next numbering etc...

2. Create a custom UDC table, which holds the old address book number to the
new JDE address book number...

This will allow you to do many to one relationships (per address book
number) along with many foreign databases to jde interfaces...

Let me know how you get on....

Marco Riccomini

OneWorld XE SP14.2 SQL 7.0
 
You can use Address Book Supplemental Data (P00091/P00092) to set up the
cross reference.

If you want word search capabilities across these external names as well,
you can consider putting it into Who's Who with different type code.

You may need to create new indexes to access the x-ref information.

Regards
Yeo KH

----- Original Message -----
From: tom brown <tom.brown@morecomm.com>
To: <jdeowdevml@jdelist.com>
Sent: Wednesday, March 21, 2001 10:41 PM
Subject: Address book numbers and interfaces


> Hi List,
>
> I'm looking for some ideas...
>
> I have an A/R interface to write, which will need to know the Address Book
> number of the client to write records to the F03B11Z1 table, based on the
> account number in the old system. The obvious thing to do then is use the
> ALKY field on the address book. Except that I have many interfaces, with
> many different foreign account numbers refering to the same client within
> OW.
>
> So how can I hold the equivilent of many values in one ALKY field?
>
> Is there another/better way than creating a tag file allowing many records
> per address number, based on the foriegn system name? Since this method
> would not allow searches by old account number without lots of other
mods...
>
> I guess someone else must have already solved this one??
>
> Cheers
>
> Tom Brown
>
>
>
> This email is intended for the addressee only. Internet communications
> are not secure and therefore Clear Channel International Ltd, its parent
and subsidiaries (which include More Group UK Ltd and More Group Ireland) do
not accept legal responsibility for the contents of this message. Any views
or opinions represented are solely those of the author and do not
necessarily represent those of Clear Channel International Ltd, its parent
and subsidiaries (which include More Group UK Ltd and More Group Ireland).
If this email is not intended for you, please notify the author by replying
to this email.
>
>
>
>
>
> --------------------------
> To view this thread, visit the JDEList forum at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OWDEV&Numb
er=7652
> + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +
> This is the JDEList One World / XE Developers Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
> + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +
>
 

bioriz

Member
Instead of creating tag along files, I always thought the CIF or supplemental databases work real well. They also have one for the item master. The maintenance and/or inquiry programs are already there for you to use, and these files can be configure to serve most simple needs. I've used the supplemental data base files for links to outside systems, and for conversions similar to what you're talking about.
 
Top