Extracting data from vendor master
Use this report to extract data from the vendor master.
- Access Vendor Extract (AP590).
- Specify the Job Name and Description.
- Select a Vendor Group.
- On the Vendor Records Option tab, users can select up to 10 valid Vendor Class.
- Set the Extract Protected Health Information flag to Y to limit the extracted fields to Vendor Group, Vendor, and Vendor Name only on the Vendor Master extract file. The default value is N.
- Submit report.
-
These CSV files are created in the $LAWDIR/productline/interface folder from the data files specified. File names and path can be renamed if desired.
Extracts data from CSV Default File Name Datafile extracted AP Vendor Master Name AP590VEN APVENMAST PO Vendor Name AP590POV POVENDOR AP Vendor Location Name AP590VLO APVENLOC PO Vendor Location Name AP590PVL POVENDLOC AP Vendor Balance Name AP590VBA APVENBAL AP Vendor Contact AP590VCT APCONTACT AP Vendor Cert Code AP590AVT APVENCERT AP Vendor Address Name AP590VDR APVENADDR