Extracting data from vendor master

Use this report to extract data from the vendor master.

  1. Access Vendor Extract (AP590).
  2. Specify the Job Name and Description.
  3. Select a Vendor Group.
  4. On the Vendor Records Option tab, users can select up to 10 valid Vendor Class.
  5. 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.
  6. Submit report.
  7. 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