Product: | AX - Global Accounting Engine |
---|---|
Description: | Replacement for the AP table, AP_ACCOUNTING_EVENTS_ALL, when the AX accounting engine is used. |
Implementation/DBA Data: | Not implemented in this database |
SELECT AXE.EVENT_ID ACCOUNTING_EVENT_ID
, AXE.EVENT_TYPE EVENT_TYPE_CODE
, AXE.EVENT_DATE ACCOUNTING_DATE
, -1 EVENT_NUMBER
, DECODE(AXE.TRANSLATION_STATUS
, 'N'
, 'CREATED'
, 'P'
, 'CREATED'
, 'T'
, 'ACCOUNTED'
, 'W'
, 'ACCOUNTED'
, 'E'
, 'ACCOUNTED WITH ERROR'
, 'U'
, 'ACCOUNTED WITH ERROR'
, 'UNDEFINED' ) EVENT_STATUS_CODE
, DECODE(AXE.EVENT_TYPE
, 'NON_CASH_APPROVED'
, 'AP_INVOICES'
, 'NON_CASH_ADJUSTED'
, 'AP_INVOICES'
, 'PREPAYMENT_APPLIED'
, 'AP_INVOICES'
, 'PREPAYMENT_UNAPPLIED'
, 'AP_INVOICES'
, 'SUPPLIER_MERGE'
, 'AP_INVOICES'
, 'CASH_APPLIED'
, 'AP_CHECKS'
, 'CASH_ADJUSTED'
, 'AP_CHECKS'
, 'CASH_CLEARED'
, 'AP_CHECKS'
, 'CASH_UNCLEARED'
, 'AP_CHECKS'
, 'FUTURE_APPLIED'
, 'AP_CHECKS'
, 'FUTURE_ADJUSTED'
, 'AP_CHECKS'
, 'FUTURE_MATURED'
, 'AP_CHECKS'
, 'FUTURE_CLEARED'
, 'AP_CHECKS'
, 'FUTURE_UNCLEARED'
, 'AP_CHECKS'
, 'UNDEFINED') SOURCE_TABLE
, AXE.EVENT_FIELD1 SOURCE_ID
, AXE.CREATION_DATE CREATION_DATE
, AXE.CREATED_BY CREATED_BY
, AXE.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AXE.LAST_UPDATED_BY LAST_UPDATED_BY
, AXE.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AXE.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, AXE.PROGRAM_ID PROGRAM_ID
, AXE.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, AXE.REQUEST_ID REQUEST_ID
, AXE.ORG_ID ORG_ID
FROM AX_EVENTS AXE
WHERE AXE.APPLICATION_ID = 200