RE: Buyer/Planner Number

["Thomas, Lisa (Hayssen)" <lisa.thomas@xxxxxxxxxxx>]

Are you going to change historical records also?  If I look in Mapics
Integrator I see references to the following objects:
Object Name                             File Name               Field
Quote/Contract                  QUOHDFL0                BUYRQZ
IFM User (for the approver)     YAACREL1                ACANCD (related by
the User ID not the Buyer Number)
Item Purchase                   ITMPURL0                BUYRI2
MRP Recommendation              ORDREVL2                BYNORV
Purchase Order History Item     POHSTDl1                BUYRPK
Purchase Order Item             POITEML3                BUYRPT
Purchase Order History          POHSTMl2                BUYRPI
Purchase Order                  POMASTL0                BUYRPM
Purchasing Activity             PURACTL0                BUYRW2
Reorder Recommendation          ORDPNTL0                BUYRHQ
Requisition                             REQHDFL0                BUYRQF
Scheduled Purchase Receipt      SCHRCTL0                BUYRHY
Item Revision Purchase          ITMRCVL0                BUYRAW

Not sure if this is all but it should help.
Lisa



-----Original Message-----
From: LDegnon@xxxxxxxxx [mailto:LDegnon@xxxxxxxxx]
Sent: Tuesday, July 15, 2003 12:07 PM
To: MAPICS ERP System Discussion
Subject: RE: Buyer/Planner Number






Guess I should be more to the point.  What I'm thinking of doing is use a
SQL Statement to change a group of records from Buyer 3 to Buyer 5, and
don't want to mess anything up...



Lloyd H. Degnon
I.S. Manager
AmPro Computers, Inc.
5215 Hellyer Ave.
San Jose, CA 95138
408.360.4365
http://www.ampro.com


                                                                           


-----Original Message-----
From: LDegnon@xxxxxxxxx [mailto:LDegnon@xxxxxxxxx]
Sent: Tuesday, July 15, 2003 11:37 AM
To: Mapics-l@xxxxxxxxxxxx
Subject: Buyer/Planner Number






Dumb question, but have to ask...

Does the Buyer/Planner number live anywhere else besides the Itemasc file?
Mapics version 6.02...


Thanks!



Lloyd H. Degnon
I.S. Manager
AmPro Computers, Inc.
5215 Hellyer Ave.
San Jose, CA 95138
408.360.4365
http://www.ampro.com