RE: What makes a PO line item unique?

["Ali Ekinci" <Ali.Ekinci@xxxxxxxxxx>]

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.