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.
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.