|
midrange.com
The reason the keys are not specified as unique at the file level is because
this check is performed by the application and not by the system. At one point
(many moons ago), this could be a significant difference in performance for
jobs (IFL, Conversions) that added alot of records to a table.
Robert Russell
Paragon SI
-----Original Message-----
From: Chris Neely [mailto:Chris.Neely@xxxxxxxxxx]
Sent: Fri 12/10/2004 4:41 PM
To: MAPICS ERP System Discussion
Cc:
Subject: RE: What makes a PO line item unique?
Thanks
I suppose that MAPICS has some reason why they did not specify the key
as
unique for logical POITEML3 which uses the fields order number and po
item
sequence number for its key.
"Ali Ekinci" <Ali.Ekinci@xxxxxxxxxx>
Sent by: mapics-l-bounces@xxxxxxxxxxxx
12/10/2004 03:15 PM
Please respond to MAPICS ERP System Discussion
To: "MAPICS ERP System Discussion" <mapics-l@xxxxxxxxxxxx>
cc:
Subject: RE: What makes a PO line item unique?
You are right. PO item seq. no is unique within PO. It is even a
non-maintainable automatically generated value.
-----Original Message-----
From: Chris Neely [mailto:Chris.Neely@xxxxxxxxxx]
Sent: Friday, December 10, 2004 4:10 PM
To: MAPICS ERP System Discussion
Subject: Re: What makes a PO line item unique?
I'm not really trying to accomplish anything except to understand why
the
combination of order number and po item sequence does not make the
record
unique. Is the po item sequence not equivalent to a 'line' number which
tells you basically what line number this record is on the po?
Thanks
MWalter@xxxxxxxxxxxxxxx
Sent by: mapics-l-bounces@xxxxxxxxxxxx
12/10/2004 03:05 PM
Please respond to MAPICS ERP System Discussion
To: MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
cc:
Subject: Re: What makes a PO line item unique?
Right, That's part of the primary key. What are you trying to accomplish
here. I'm thinking maybe you need a blanket order.
Thanks,
Mark
Mark D. Walter
Senior Programmer/Analyst
CCX, Inc.
mwalter@xxxxxxxxxx
http://www.ccxinc.com
"Chris Neely"
<Chris.Neely@mats
ci.com>
To
Sent by: MAPICS ERP System Discussion
mapics-l-bounces@ <mapics-l@xxxxxxxxxxxx>
midrange.com
cc
Subject
12/10/2004 04:03 Re: What makes a PO line item
PM unique?
Please respond to
MAPICS ERP System
Discussion
<mapics-l@midrang
e.com>
Are we all talking about the same fields here? I am not referring to
field
LINSQ in poitem. I am referring to field POISQ in poitem when I say po
item sequence.
Thanks
"Peter Vidal" <Peter_Vidal@xxxxxxxx>
Sent by: mapics-l-bounces@xxxxxxxxxxxx
12/10/2004 02:56 PM
Please respond to MAPICS ERP System Discussion
To: MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
cc:
Subject: Re: What makes a PO line item unique?
"So, we are saying that the combination of order number and po item
sequence does not make it unique. So, it is possible to create two line
items for the same
purchase order that have the same po item sequence."
Yes. You could have:
Order #: P123456
Item: ABC123
Warehouse: 1
Line Seq: 1
... and...
Order #: P123456
Item: ABC444
Warehouse: 1
Line Seq: 1
Peter Vidal
PALL Corporation
SR Programmer Analyst
5775 Rio Vista Drive, Clearwater, FL 33760-3137
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
