Prev
Next
Forums Financial Management Lawson S3 Financials

SQL Extract of vendor 1099 indicator and payment code

 2 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
mikekask
Basic Member
Posts: 10
Basic Member
3/11/2011 2:48 PM
    Hi,
    I am writing an SQL extract program to get this information.
    I am trying to find on what table the vendor 1099 indicator is located. I was told the INCOME_CODE can be used for this but nothing there. I am also looking for the table where the Vendor Payment Code field (from the AP10.5 form) is located.
    Mike
    JeffR
    Advanced Member
    Posts: 22
    Advanced Member
    3/14/2011 2:35 PM
      If a vendor has a default 1099 code used for any invoice charged to them then you can query on the INCOME-CODE field on APVENMAST. If you are building a query to pull every invoice that was flagged as subject to 1099 then look in APPAYMENT for invoices paid during the year where INCOME-CODE != "". This is where AP45 and AP145 pulls the information from.

      We do not use AP10.5 but I believe the information may be stored in APCPYVND.
      Vijay S
      Veteran Member
      Posts: 174
      Veteran Member
      3/22/2011 6:22 AM
        Jeff is correct !!
        I just checked it out on AP10.5.
        The exact table for VEndor Payment code is APCPYVND.
        and the field for the same in the table is APX-BANK-INST-CODE.

        Vijay