[Home] [Help]
View: AX_AP_TAXABLE_V
Product: | AX - Global Accounting Engine |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT AID2.INVOICE_ID
, AID2.INVOICE_DISTRIBUTION_ID
, AID2.TAX_CODE_ID
, AID2.VAT_CODE
, SUM(AID.AMOUNT) L_TAXABLE_AMOUNT
, SUM(NVL(AID.BASE_AMOUNT
, AID.AMOUNT)) L_TAXABLE_BASE_AMOUNT
FROM AP_INVOICE_DISTRIBUTIONS_ALL AID
, AP_CHRG_ALLOCATIONS_ALL ACA
, AP_INVOICE_DISTRIBUTIONS_ALL AID2
WHERE AID.INVOICE_DISTRIBUTION_ID = ACA.ITEM_DIST_ID
AND ACA.CHARGE_DIST_ID = AID2.INVOICE_DISTRIBUTION_ID
AND AID2.LINE_TYPE_LOOKUP_CODE IN ('TAX'
, 'AWT') GROUP BY AID2.INVOICE_ID
, AID2.INVOICE_DISTRIBUTION_ID
, AID2.TAX_CODE_ID
, AID2.VAT_CODE
Columns
Name |
INVOICE_ID |
INVOICE_DISTRIBUTION_ID |
TAX_CODE_ID |
VAT_CODE |
L_TAXABLE_AMOUNT |
L_TAXABLE_BASE_AMOUNT |