Logically Unique Key on F4111 Table

Zoltan_Gyimesi

Legendary Poster
Hi List/Forum,

Does anybody know about at least one of the indecies of F4111 table which is LOGICALLY Unique and does NOT CONTAIN the "Unique Key ID" (UKID) field?

I know, F4111 has formally only one unique index, the primary, but it could have other unique logically.

An answer could be also a denying as: None of them, if some of you know it.

This time I am mainly interested on XE.

All answer will be greatfully appreciated,

Zoltán
P.S.: Excuse me to post this issue onto both XE Forum.

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

epost

Active Member
select count(*), count(distinct column1 || ' ' || column2 || '' || column3)
from proddta.f4111;

play around with that, when you get the same number for both columns you
have identified another key

- Ethan
- San Diego, CA
- www.FreeOCP.com
 

david_mallory

Well Known Member
Zoltan,

I can see no single field besides UKID which has a unique value for each
record in F4111. The next choice is a combination of: DOC doc number, DCT
doc type, LNID line number of doc. JELN journal entry line number could
be used in place of LNID. Multi-line transactions require LNID or JELN. I
see nothing in the 733-to-Xe documentation that would change this.

Dave Mallory Denver Water 7.332 SP15.1 Oracle 8.1634 NT 4.0 SP6
 

flyingmg

Active Member
Zoltan,

The primary key of F4111 is ILUKID. I think, however, the Key2_F4111 is u=
nique too, although JDE table definition says it's not unique.

Key2_F4111 is composed of ILDOC, ILDCT, ILKCO, ILDGL, and ILJELN. ILDGL (=
GL date) make this key highly impossibly duplicate, unless you used up ne=
xt number for DOC within one day. Therefore, realistically this is a uniq=
u key.

Hopefully this helps.

MG



----- Original Message -----
From: Zoltan_Gyimesi
Sent: Friday, May 11, 2001 4:43 PM
To: jdelistml@jdelist.com
Subject: Logically Unique Key on F4111 Table


Hi List/Forum,

Does anybody know about at least one of the indecies of F4111 table which=
is LOGICALLY Unique and does NOT CONTAIN the "Unique Key ID" (UKID) fiel=
d?

I know, F4111 has formally only one unique index, the primary, but it cou=
ld have other unique logically.

An answer could be also a denying as: None of them, if some of you know i=
t.

This time I am mainly interested on XE.

All answer will be greatfully appreciated,

Zolt=E1n
P.S.: Excuse me to post this issue onto both XE Forum.

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
--------------------------
Visit the forum to view this thread at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=3D&Board=3DOW&N=
umber=3D10686


MG
flyingMG@msn.com
 
Top