AX Tables (40)

AX - Global Accounting Engine — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

TableColumnsDescription
AX_ARITHMETIC_EXPR 16 Arithmetic expressions used by amount structures.
AX_BALANCES 25 Subledger accounting balance information for control accounts
AX_CLAUSES 15 Clauses used by query chains.
AX_CONDITIONS 21 Conditions used by distribution plan structures or distribution headers
AX_DISTRIB_HEADERS 13 Distribution headers of translation schemes
AX_DISTRIB_PLANS 11 Distribution plans of translation schemes
AX_DOCUMENT_STATUSES 54 Document statuses
AX_EVENTS 48 Accounting events information
AX_EVENT_MAPPINGS 10 Mappings of primary key columns of the base event tables of translation schemes.
AX_EVENT_TYPES 16 Event types information
AX_ID_HASH_RESULTS 12 Hash values for numeric identifiers
AX_MC_TABLES 10 Information about tables and columns used by Multiple Reporting Currency
AX_NPI_ACCOUNTS 30 Non-Permanent inventory accounts information
AX_PERIOD_HISTORY 14 Obsolete. For compatibility with previous Release
AX_PERIOD_STATUSES 13 Number of inventory organizations with the accounting period opened
AX_POSTING_CTRL 12 Status of the posting process
AX_PURGE_RUNS 17 Audit information of each Subledger Archive and Purge execution
AX_QUERY_CHAINS 12 Query chains information
AX_QUERY_TABLES 11 Tables used by a query chain
AX_REPORT_PARAMETERS 20 Official runs of Final Daily Journal Book - Header Descriptions
AX_RULES 12 Archived rule sets for an application
AX_RULE_CATEGORY 10 Temporarily stores categories used by event types
AX_RULE_LINES 10 Components of a rule set
AX_SECONDARY_INVENTORY 8 Numeric identifiers for Inventory sub-organizations
AX_SETUP_BOOKS 11
AX_SETUP_GLOBAL 18 Global setup parameters
AX_SETUP_INV_ORG_PROCS 16 Setup parameters specific to Oracle Inventory organizations
AX_SETUP_POSTING_BOOKS 28 Posting sets of books information per main set of books
AX_SETUP_SUBLEDGERS 23 Subledger dependent parameters
AX_SLE_HEADERS 47 Journal entry headers information
AX_SLE_HEADERS_ARCH 47 Accounting rows purged from the AX_SLE_HEADERS table
AX_SLE_LINES 127 Journal entry lines information
AX_SLE_LINES_ARCH 127 Accounting rows purged from the AX_SLE_LINES table
AX_STRUCTURES 20 Structures used by distribution plans to retrieve information
AX_SUBLEDGERS 8 Application dependent information
AX_TEMP_OUT 8 Temporary table used by the AX Compiler
AX_TRANS_PROGRAMS 18 Translator programs information
AX_TRANS_SCHEMES 12 Translation schemes information
AX_VARIANCES 20 Information used to adjust inventory values at the end of an accounting period
AX_VARIANCE_STATUSES 11 Absorption information