• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

SQL query of AP230

 2 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
maharuchi
New Member Send Private Message
Posts: 0
New Member
1/13/2016 6:59 PM
Can anybody share with me SQL query of AP230 ?

Thanks a lot
klemmyjb
Basic Member Send Private Message
Posts: 14
Basic Member
1/14/2016 6:37 PM
do you look at APINVOICE select * from APINVOICE
klemmyjb
Basic Member Send Private Message
Posts: 14
Basic Member
1/14/2016 6:41 PM
SELECT
APINVOICE.COMPANY,
APINVOICE.VENDOR,
APINVOICE.INVOICE,
APINVOICE.CANCEL_DATE,
APINVOICE.INVOICE_TYPE,
APINVOICE.PAY_CURRENCY,
APINVOICE.INVOICE_DTE,
APINVOICE.CHARGEBACK_FL,
APINVOICE.BASE_INV_AMT,
APINVOICE.BASE_ACT_AMT,
APINVOICE.BASE_TOT_PMT,
APINVOICE.TRAN_TOT_PMT,
APINVOICE.BASE_TOT_DIST,
APINVOICE.TRAN_TOT_DIST,
APINVOICE.REC_STATUS,
APINVOICE.CREATE_DATE,
APINVOICE.CREATION_TIME,
APINVOICE.INVOICE_GROUP,
APINVOICE.HANDLING_CODE
FROM APINVOICE