Re: What makes a PO line item unique?

[MWalter@xxxxxxxxxxxxxxx]

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.