Extracting data from vendor agreement master

Use this report to extract data from the vendor agreement master.

Extract vendor agreement master file

  1. Access Vendor Agreement Extract (PO525).
  2. Specify Job Name and Description.
  3. Select a Procurement Group.
  4. When you run this report, the Vendor Agreement extract is exported. You can select whether to also extract data from each of the other three files on this report. All three default to Yes.
  5. Submit report.
  6. 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
    Vendor Agreement Name PO525PVH POVAGRMTHD
    Agreement Line Name PO525PVN POVAGRMTLN
    Agreement Pricing Name PO525PRI POAGMTPRIC
    Agreement Participant Name PO525PRK POAGMTPART