• Search Forums
    Advanced Search Topics Posts
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 Send Private Message
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 Send Private Message
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 Send Private Message
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