SQL Extract of vendor 1099 indicator and payment code

Sort:
You are not authorized to post a reply.
Author
Messages
mikekask
Basic Member
Posts: 10
Basic Member
    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
      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
        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
        You are not authorized to post a reply.