Here is a sql. If you look about the end you will see the fields required and file. These fields will require to have data. You will see the MAPICS field name along with alias
-- Get Vendor Master Info
-- vendor info
Select a.vndnr as VendorNumber, a.vname as VendorName,
a.fobcd as FOBCode, a.fobds as FOBDescp,
a.curid as VendorCurId,
a.vadd1 as VendorAdd1, a.vadd2 as VendorAdd2,
a.vcity as VendorCity, a.vstac as VendorStateCd, a.vzipc as VendorZipCd,
a.vcntr as VendorCountry, a.vetel as VendorTele#, a.posus as POEntrySuspd,
a.trmcd as VendorTermsCode, a.trmds as VendorTermsDescp, a.vcont as VendorContact,
a.eadr as EmailAddress, a.dayse as VendorAvgDaysEarly,
a.daysl as VendorAvgDaysLate,
a.ratel as LastVenRating, a.ratea as AvgVenRating,
a.orsze as AvgOrdSize, a.overp as AvrOvrShpPct,
a.undrp as AvgUndShpPct, a.rejcp as AvgRjctPct,
a.rewkp as AvgRewrkPct, a.ovrpr as AvgOvrPrcPct,
a.undpr as AvgUndPrcPct, a.dsytd as DisCntTknYTD,
a.dslos as DiscntLstYTD
from amfliba.vennam A
where a.vndnr = ?
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Raymond Spears
Sent: Tuesday, January 15, 2013 3:09 PM
To: mapics-l@xxxxxxxxxxxx
Subject: [MAPICS-L] Vendor Performance data
We have a need to calculate vendor performance before orders are closed.
Our Purchasing Department leave many P.O. s open all year so using the XA performance isn't working for us. If anyone is calculating vendor performance outside of XA can you give an example of which fields and or files being used to get the vendor performance data.
Thank you,
Raymond Spears
Unaka Company
423-552-4394
--
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.
midrange.com
