Forums
Lawson Business Intelligence/Reporting/Crystal
SQL query of AP230
Author
Messages
maharuchi
Advanced Member
Posts: 28
1/13/2016 6:59 PM
Can anybody share with me SQL query of AP230 ?
Thanks a lot
klemmyjb
Basic Member
Posts: 12
1/14/2016 6:37 PM
do you look at APINVOICE select * from APINVOICE
klemmyjb
Basic Member
Posts: 12
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