eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: AX_MC_AP_TAXABLE_V

Product:	AX - Global Accounting Engine
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT AMD2.SET_OF_BOOKS_ID
, AMD2.INVOICE_ID
, AMD2.INVOICE_DISTRIBUTION_ID
, AID2.TAX_CODE_ID
, AID2.VAT_CODE
, SUM(AMD.AMOUNT) L_TAXABLE_AMOUNT
, SUM(NVL(AMD.BASE_AMOUNT
, AMD.AMOUNT)) L_TAXABLE_BASE_AMOUNT
FROM AP_INVOICE_DISTRIBUTIONS_ALL AID2
, AP_MC_INVOICE_DISTS AMD
, AP_CHRG_ALLOCATIONS_ALL ACA
, AP_MC_INVOICE_DISTS AMD2
WHERE AMD.INVOICE_DISTRIBUTION_ID = ACA.ITEM_DIST_ID
AND ACA.CHARGE_DIST_ID = AMD2.INVOICE_DISTRIBUTION_ID
AND AMD2.LINE_TYPE_LOOKUP_CODE IN ('TAX'
, 'AWT')
AND AMD2.SET_OF_BOOKS_ID = AMD.SET_OF_BOOKS_ID
AND AID2.INVOICE_DISTRIBUTION_ID = AMD2.INVOICE_DISTRIBUTION_ID GROUP BY AMD2.SET_OF_BOOKS_ID
, AMD2.INVOICE_ID
, AMD2.INVOICE_DISTRIBUTION_ID
, AID2.TAX_CODE_ID
, AID2.VAT_CODE

Columns

Name
SET_OF_BOOKS_ID
INVOICE_ID
INVOICE_DISTRIBUTION_ID
TAX_CODE_ID
VAT_CODE
L_TAXABLE_AMOUNT
L_TAXABLE_BASE_AMOUNT