Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - AX Tables and Views

TABLE - AX.AX_ARITHMETIC_EXPR

TABLE - AX.AX_BALANCES

TABLE - AX.AX_CLAUSES

TABLE - AX.AX_CONDITIONS

TABLE - AX.AX_DISTRIB_HEADERS

TABLE - AX.AX_DISTRIB_PLANS

TABLE - AX.AX_DOCUMENT_STATUSES

TABLE - AX.AX_EVENTS

TABLE - AX.AX_EVENT_MAPPINGS

TABLE - AX.AX_EVENT_TYPES

TABLE - AX.AX_ID_HASH_RESULTS

TABLE - AX.AX_MC_TABLES

TABLE - AX.AX_NPI_ACCOUNTS

TABLE - AX.AX_PERIOD_HISTORY

TABLE - AX.AX_PERIOD_STATUSES

TABLE - AX.AX_POSTING_CTRL

TABLE - AX.AX_PURGE_RUNS

TABLE - AX.AX_QUERY_CHAINS

TABLE - AX.AX_QUERY_TABLES

TABLE - AX.AX_REPORT_PARAMETERS

TABLE - AX.AX_RULES

TABLE - AX.AX_RULE_CATEGORY

TABLE - AX.AX_RULE_LINES

TABLE - AX.AX_SECONDARY_INVENTORY

TABLE - AX.AX_SETUP_BOOKS

TABLE - AX.AX_SETUP_GLOBAL

TABLE - AX.AX_SETUP_INV_ORG_PROCS

TABLE - AX.AX_SETUP_POSTING_BOOKS

TABLE - AX.AX_SETUP_SUBLEDGERS

TABLE - AX.AX_SLE_HEADERS

TABLE - AX.AX_SLE_HEADERS_ARCH

TABLE - AX.AX_SLE_LINES

TABLE - AX.AX_SLE_LINES_ARCH

TABLE - AX.AX_STRUCTURES

TABLE - AX.AX_SUBLEDGERS

TABLE - AX.AX_TEMP_OUT

TABLE - AX.AX_TRANS_PROGRAMS

TABLE - AX.AX_TRANS_SCHEMES

TABLE - AX.AX_VARIANCES

TABLE - AX.AX_VARIANCE_STATUSES

Table: AX_ARITHMETIC_EXPR

Primary Key: AX_ARITHMETIC_EXPR_PK

1. SET_OF_BOOKS_ID
2. APPLICATION_ID
3. TRANSLATION_SCHEME
4. PLAN_NAME
5. STRUCTURE_NUMBER
6. STRUCTURE_TYPE
7. EXPRESSION_NUMBER

Foreign Keys from this table:

Comments

This table stores information about arithmetic expressions used by
amount structures.
Each row corresponds to an elementary expression and includes the
operator (+, -, * or /), the type of the right operand (COLUMN,
CONSTANT or EVENT_DATA) and its value.

Primary Key: AX_ARITHMETIC_EXPR_PK

1. SET_OF_BOOKS_ID
2. APPLICATION_ID
3. TRANSLATION_SCHEME
4. PLAN_NAME
5. STRUCTURE_NUMBER
6. STRUCTURE_TYPE
7. EXPRESSION_NUMBER

Indexes

Columns

[top of page]

AX.AX_ARITHMETIC_EXPR does not reference any database object

AX.AX_ARITHMETIC_EXPR is referenced by following:

APPS

SYNONYM - AX_ARITHMETIC_EXPR

[top of page]

Table: AX_BALANCES

Primary Key: AX_BALANCES_PK

1. SET_OF_BOOKS_ID
2. APPLICATION_ID
3. CODE_COMBINATION_ID
4. PERIOD_NAME
5. THIRD_PARTY_ID
6. SUB_ID

Foreign Keys from this table:

Comments

This table stores accounting subledger balance information for
control accounts.
For every application and set of books, it includes a row for every
period, control account and third party suborganization.
UPDATED_FLAG is set to 'Y' to mark the balance information when the
period net amounts are modified; this means that the period end
amounts in the following periods need to be recalculated. No row in
AX_BALANCES should contain a 'Y' after the balance calculation
completes successfully.
HISTORIC_BALANCE is set to 'H' for a historic balance, 'P' for a purged
balance, and 'N' for other balances. Historic balances are balances
entered initially before using the Global Accounting Engine. Such
balances are not modified or deleted by Global Accounting Engine.
Purged balances are balances within a period for which the accounting
entries have been purged. They are marked with a 'P' so that they will
not be deleted by the Balance Synchronization program when the accounting
entries no longer exist.
BALANCE_SEGMENT and ACCOUNT_SEGMENT are a denormalization of the
column CODE_COMBINATION_ID containing respectively the balancing
and accounting segment of the key flexfield. The denormalization is
used as most of the reports group their result using these values.
For a balance calculation that includes year-end periods, a carry
forward balance is automatically created with the special period name
'NET-XXXX', where XXXX is the fiscal year. This NET balance is the
difference between the year's total debits and credits. The balance
is stored as a positive amount in either the END_BALANCE_DR or
END_BALANCE_CR column, but not both.
Note that this is not a partitioned table and that the column ORG_ID
is not used.

Primary Key: AX_BALANCES_PK

1. SET_OF_BOOKS_ID
2. APPLICATION_ID
3. CODE_COMBINATION_ID
4. PERIOD_NAME
5. THIRD_PARTY_ID
6. SUB_ID

Indexes

Columns

[top of page]

AX.AX_BALANCES does not reference any database object

AX.AX_BALANCES is referenced by following:

APPS

SYNONYM - AX_BALANCES

[top of page]

Table: AX_CLAUSES

Primary Key: AX_CLAUSES_PK

1. CLAUSE_NUMBER
2. APPLICATION_ID
3. QUERY_CHAIN_NAME
4. TABLE_NUMBER

Foreign Keys from this table:

Comments

This table stores information about the clauses used by a query chain
table. It contains a row for each clause.
Each row, except for the first row of each table, includes the
logical operator (AND or OR), the column of the table involved in the
clause, the type of the right operand and its value.
The column RIGHT_OP_COLUMN_VALUE contains either a column name or a
constant value depending on the type of operand.

Primary Key: AX_CLAUSES_PK

1. CLAUSE_NUMBER
2. APPLICATION_ID
3. QUERY_CHAIN_NAME
4. TABLE_NUMBER

Indexes

Columns

[top of page]

AX.AX_CLAUSES does not reference any database object

AX.AX_CLAUSES is referenced by following:

APPS

SYNONYM - AX_CLAUSES

[top of page]

Table: AX_CONDITIONS

Primary Key: AX_CONDITIONS_PK

1. CONDITION_ID

Foreign Keys from this table:

Comments

This table stores information about conditions used by a distribution
plan structure or distribution header. It contains a row for each
condition.
Each row includes the logical operator (AND or OR), the table and the
column involved as left operand, the type of the right operand and
its value.

Primary Key: AX_CONDITIONS_PK

1. CONDITION_ID

Indexes

Columns

[top of page]

AX.AX_CONDITIONS does not reference any database object

AX.AX_CONDITIONS is referenced by following:

APPS

SYNONYM - AX_CONDITIONS

[top of page]

Table: AX_DISTRIB_HEADERS

Primary Key: AX_DISTRIB_HEADERS_PK

1. SET_OF_BOOKS_ID
2. APPLICATION_ID
3. TRANSLATION_SCHEME
4. HEADER_NUMBER

Foreign Keys from this table:

Foreign Keys to this table:

Comments

This table stores information about the distribution headers of a
translation scheme. It contains a row for each distribution header.
Each row includes the number of the distribution header within the
translation scheme, the header column that it populates, the query
chain used and the source table and column.

Primary Key: AX_DISTRIB_HEADERS_PK

1. SET_OF_BOOKS_ID
2. APPLICATION_ID
3. TRANSLATION_SCHEME
4. HEADER_NUMBER

Indexes

Columns

[top of page]

AX.AX_DISTRIB_HEADERS does not reference any database object

AX.AX_DISTRIB_HEADERS is referenced by following:

APPS

SYNONYM - AX_DISTRIB_HEADERS

[top of page]

Table: AX_DISTRIB_PLANS

Primary Key: AX_DISTRIB_PLANS_PK

1. SET_OF_BOOKS_ID
2. APPLICATION_ID
3. TRANSLATION_SCHEME
4. PLAN_NAME

Foreign Keys from this table:

Foreign Keys to this table:

Comments

This table stores information about the distribution plans of a
translation scheme. It contains a row for each distribution plan.
Each row includes the name of the distribution plan, its type (LINE,
SINGLE or ARRAY) and the nature of the plan.

Primary Key: AX_DISTRIB_PLANS_PK

1. SET_OF_BOOKS_ID
2. APPLICATION_ID
3. TRANSLATION_SCHEME
4. PLAN_NAME

Indexes

Columns

[top of page]

AX.AX_DISTRIB_PLANS does not reference any database object

AX.AX_DISTRIB_PLANS is referenced by following:

APPS

SYNONYM - AX_DISTRIB_PLANS

[top of page]

Table: AX_DOCUMENT_STATUSES

Primary Key: AX_DOCUMENT_STATUSES_PK

1. APPLICATION_ID
2. SET_OF_BOOKS_ID
3. DOCUMENT_CODE
4. DOCUMENT_ID1
5. DOCUMENT_ID2
6. DOCUMENT_ID3
7. DOCUMENT_ID4
8. DOCUMENT_ID5

Comments

This table stores information about the status of documents.
It contains a row for every relevant document not having status
information stored on its base table.
Each row contains the type, the identifier and the status of the
document.
The status is stored in the reference columns according to the type of
document. By convention, REFERENCE19 and REFERENCE20 always contain
the DOC_SEQUENCE_ID and DOC_SEQUENCE_VALUE of the
document.

Primary Key: AX_DOCUMENT_STATUSES_PK

1. APPLICATION_ID
2. SET_OF_BOOKS_ID
3. DOCUMENT_CODE
4. DOCUMENT_ID1
5. DOCUMENT_ID2
6. DOCUMENT_ID3
7. DOCUMENT_ID4
8. DOCUMENT_ID5

Indexes

Columns

[top of page]

AX.AX_DOCUMENT_STATUSES does not reference any database object

AX.AX_DOCUMENT_STATUSES is referenced by following:

APPS

SYNONYM - AX_DOCUMENT_STATUSES

[top of page]

Table: AX_EVENTS

Primary Key: AX_EVENTS_PK

1. EVENT_ID

Foreign Keys to this table:

Comments

This table stores information about the events that occurred in the
system and that need to be translated into a subledger entry. It
includes a row for each event.
Each row includes the type of the event, the identifier of the
document (invoice, payment or other) to which the event is related
and the status of the event; the following statuses are possible:
N: not translated
P: document not ready for translation
T: successfully translated
E: recoverable error during translation
U: unrecoverable error during translation; a manual operation is
required
W: warning; translation is successful but an abnormal status has been
met
If the type is 'E', 'U', or 'W', then the message text contains an
explanation.

Primary Key: AX_EVENTS_PK

1. EVENT_ID

Indexes

Columns

[top of page]

AX.AX_EVENTS does not reference any database object

AX.AX_EVENTS is referenced by following:

APPS

SYNONYM - AX_EVENTS

[top of page]

Table: AX_EVENT_MAPPINGS

Primary Key: AX_EVENT_MAPPINGS_PK

1. SET_OF_BOOKS_ID
2. APPLICATION_ID
3. TRANSLATION_SCHEME
4. PRIMARY_KEY_COLUMN

Foreign Keys from this table:

Comments

This table stores information about the mapping of the primary key
column(s) of the base event table of a translation scheme. It
contains a row for each primary key column of the base event table.
Each row includes the name of the primary key column and its mapping
to a column of AX_EVENTS (the column to which it has to be compared).

Primary Key: AX_EVENT_MAPPINGS_PK

1. SET_OF_BOOKS_ID
2. APPLICATION_ID
3. TRANSLATION_SCHEME
4. PRIMARY_KEY_COLUMN

Indexes

Columns

[top of page]

AX.AX_EVENT_MAPPINGS does not reference any database object

AX.AX_EVENT_MAPPINGS is referenced by following:

APPS

SYNONYM - AX_EVENT_MAPPINGS

[top of page]

Table: AX_EVENT_TYPES

Primary Key: AX_EVENT_TYPES_PK

1. SET_OF_BOOKS_ID
2. APPLICATION_ID
3. POSTING_SET_OF_BOOKS_ID
4. EVENT_TYPE

Foreign Keys from this table:

Comments

This table stores the event types. There is a row for every event
type defined per main set of books and posting set of books.
Every row includes the set of books and the application in which the
event is defined, the event type, the translation scheme used to
translate the event, the direction of the event type (direct, reverse
or offset), the category used to generate the journal sequence and an
optional PL/SQL user exit that will be executed before translation.

Primary Key: AX_EVENT_TYPES_PK

1. SET_OF_BOOKS_ID
2. APPLICATION_ID
3. POSTING_SET_OF_BOOKS_ID
4. EVENT_TYPE

Indexes

Columns

[top of page]

AX.AX_EVENT_TYPES does not reference any database object

AX.AX_EVENT_TYPES is referenced by following:

APPS

SYNONYM - AX_EVENT_TYPES

[top of page]

Table: AX_ID_HASH_RESULTS

Primary Key: AX_ID_HASH_RESULTS_PK

1. IDENTIFIER_TYPE
2. IDENTIFIER

Comments

This table stores hashed values for numeric identifiers. It contains a
row for each different identifier of each type of object.
The column IDENTIFIER_TYPE identifies the type of object; valid values
are:
- APPLICATION
- SET_OF_BOOKS
The identifiers are hashed transforming them in a string of characters
having a predetermined length.
Do not access this table directly; to maintain data integrity, always
use the package AX_HASH_PKG.

Primary Key: AX_ID_HASH_RESULTS_PK

1. IDENTIFIER_TYPE
2. IDENTIFIER

Indexes

Columns

[top of page]

AX.AX_ID_HASH_RESULTS does not reference any database object

AX.AX_ID_HASH_RESULTS is referenced by following:

APPS

SYNONYM - AX_ID_HASH_RESULTS

[top of page]

Table: AX_MC_TABLES

Primary Key: AX_MC_TABLES_PK

1. MC_TABLE_NAME
2. COLUMN_NAME

Comments

This table contains information about the tables used by Multiple
Reporting Currency. It contains a row for each column in each
relevant table.
This information is used to automatically generate the accounting
rules for Multiple Reporting Currency when loading a new set of rules
for the main set of books.

Primary Key: AX_MC_TABLES_PK

1. MC_TABLE_NAME
2. COLUMN_NAME

Indexes

Columns

[top of page]

AX.AX_MC_TABLES does not reference any database object

AX.AX_MC_TABLES is referenced by following:

APPS

SYNONYM - AX_MC_TABLES

[top of page]

Table: AX_NPI_ACCOUNTS

Primary Key: AX_NPI_ACCOUNTS_PK

1. SET_OF_BOOKS_ID
2. ORGANIZATION_ID
3. CATEGORY_ID
4. SUBINVENTORY_CODE

Comments

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Primary Key: AX_NPI_ACCOUNTS_PK

1. SET_OF_BOOKS_ID
2. ORGANIZATION_ID
3. CATEGORY_ID
4. SUBINVENTORY_CODE

Indexes

Columns

[top of page]

AX.AX_NPI_ACCOUNTS does not reference any database object

AX.AX_NPI_ACCOUNTS is referenced by following:

APPS

SYNONYM - AX_NPI_ACCOUNTS

[top of page]

Table: AX_PERIOD_HISTORY

Primary Key: AX_PERIOD_HISTORY_PK

1. APPLICATION_ID
2. SET_OF_BOOKS_ID
3. PERIOD_NAME
4. PERIOD_HISTORY_NUM

Comments

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Primary Key: AX_PERIOD_HISTORY_PK

1. APPLICATION_ID
2. SET_OF_BOOKS_ID
3. PERIOD_NAME
4. PERIOD_HISTORY_NUM

Indexes

Columns

[top of page]

AX.AX_PERIOD_HISTORY does not reference any database object

AX.AX_PERIOD_HISTORY is referenced by following:

APPS

SYNONYM - AX_PERIOD_HISTORY

[top of page]

Table: AX_PERIOD_STATUSES

Primary Key: AX_PERIOD_STATUSES_PK

1. APPLICATION_ID
2. SET_OF_BOOKS_ID
3. PERIOD_NAME

Comments

This table stores the number of Inventory organizations having opened
an accounting period. The period is considered closed if it is not
open for any organization and opened if it is open for at least
one organization.
Each row contains the period identifier in GL_PERIOD_STATUSES and a
counter for the number of Inventory organizations having the period
open.

Primary Key: AX_PERIOD_STATUSES_PK

1. APPLICATION_ID
2. SET_OF_BOOKS_ID
3. PERIOD_NAME

Indexes

Columns

[top of page]

AX.AX_PERIOD_STATUSES does not reference any database object

AX.AX_PERIOD_STATUSES is referenced by following:

APPS

SYNONYM - AX_PERIOD_STATUSES

[top of page]

Table: AX_POSTING_CTRL

Primary Key: AX_POSTING_CTRL_PK

1. APPLICATION_ID
2. SET_OF_BOOKS_ID

Comments

This table stores marks used during the posting process. It includes
a row for every application and set of books.
The column STATUS may have the following values:
- S: Translate Events started
- T: Events Translated
- P: AP Posting terminated
- X: Transfer to GL terminated
This table should not be accessed directly but through the package
AX_POSTING_CTRL_PKG.

Primary Key: AX_POSTING_CTRL_PK

1. APPLICATION_ID
2. SET_OF_BOOKS_ID

Indexes

Columns

[top of page]

AX.AX_POSTING_CTRL does not reference any database object

AX.AX_POSTING_CTRL is referenced by following:

APPS

SYNONYM - AX_POSTING_CTRL

[top of page]

Table: AX_PURGE_RUNS

Primary Key: AX_PURGE_RUNS_PK

1. PURGE_ID

Comments

This table stores the status and audit information of each Subledger Archive and Purge execution.

Primary Key: AX_PURGE_RUNS_PK

1. PURGE_ID

Indexes

Columns

[top of page]

AX.AX_PURGE_RUNS does not reference any database object

AX.AX_PURGE_RUNS is referenced by following:

APPS

SYNONYM - AX_PURGE_RUNS

[top of page]

Table: AX_QUERY_CHAINS

Primary Key: AX_QUERY_CHAINS_PK

1. APPLICATION_ID
2. QUERY_CHAIN_NAME

Foreign Keys to this table:

Comments

This table stores the query chains. There is a row for every
query chain defined.
Every row includes the application in which the query chain is
defined, its name and the table from which the chain starts.

Primary Key: AX_QUERY_CHAINS_PK

1. APPLICATION_ID
2. QUERY_CHAIN_NAME

Indexes

Columns

[top of page]

AX.AX_QUERY_CHAINS does not reference any database object

AX.AX_QUERY_CHAINS is referenced by following:

APPS

SYNONYM - AX_QUERY_CHAINS

[top of page]

Table: AX_QUERY_TABLES

Primary Key: AX_QUERY_TABLES_PK

1. APPLICATION_ID
2. QUERY_CHAIN_NAME
3. TABLE_NUMBER

Primary Key: AX_QUERY_TABLES_UK

1. APPLICATION_ID
2. QUERY_CHAIN_NAME
3. TABLE_NAME

Foreign Keys from this table:

Foreign Keys to this table:

Comments

This table stores the tables used by a query chain. There is a row
for every table used by a query chain.
Every row includes the table name and the type of join that is used
(ONE, MANY or ONE AMONG MANY).

Primary Key: AX_QUERY_TABLES_PK

1. APPLICATION_ID
2. QUERY_CHAIN_NAME
3. TABLE_NUMBER

Unique Key: AX_QUERY_TABLES_UK

1. APPLICATION_ID
2. QUERY_CHAIN_NAME
3. TABLE_NAME

Indexes

Columns

[top of page]

AX.AX_QUERY_TABLES does not reference any database object

AX.AX_QUERY_TABLES is referenced by following:

APPS

SYNONYM - AX_QUERY_TABLES

[top of page]

Table: AX_REPORT_PARAMETERS

Primary Key: AX_REPORT_PARAMETERS_PK

1. REQUEST_ID

Comments

This table stores official runs of Final Daily Journal Book - Header
Descriptions per period. It contains one row for every officially
completed run.

Primary Key: AX_REPORT_PARAMETERS_PK

1. REQUEST_ID

Indexes

Columns

[top of page]

AX.AX_REPORT_PARAMETERS does not reference any database object

AX.AX_REPORT_PARAMETERS is referenced by following:

APPS

SYNONYM - AX_REPORT_PARAMETERS

[top of page]

Table: AX_RULES

Primary Key: AX_RULES_PK

1. RULE_ID

Foreign Keys to this table:

Comments

This table stores the header information for each archived rule set.
It contains a row for every archived rule set available for an
application.
Each row contains the identifier, the name of the rule set and the
identifier of the related application.

Primary Key: AX_RULES_PK

1. RULE_ID

Indexes

Columns

[top of page]

AX.AX_RULES does not reference any database object

AX.AX_RULES is referenced by following:

APPS

SYNONYM - AX_RULES

[top of page]

Table: AX_RULE_CATEGORY

Primary Key: AX_RULE_CATEGORY_PK

1. APPLICATION_ID
2. SET_OF_BOOKS_ID
3. POSTING_SET_OF_BOOKS_ID
4. EVENT_TYPE

Comments

This temporary table stores the categories used by event types. It is
populated when the Translation Programs are deleted so that the
category setup can be restored when a new version of the rules is
restored.
It includes a row for every event type for an application's main and
posting set of books.
Each row contains the event type name and the category it uses.

Primary Key: AX_RULE_CATEGORY_PK

1. APPLICATION_ID
2. SET_OF_BOOKS_ID
3. POSTING_SET_OF_BOOKS_ID
4. EVENT_TYPE

Indexes

Columns

[top of page]

AX.AX_RULE_CATEGORY does not reference any database object

AX.AX_RULE_CATEGORY is referenced by following:

APPS

SYNONYM - AX_RULE_CATEGORY

[top of page]

Table: AX_RULE_LINES

Foreign Keys from this table:

Comments

This table stores the components of a rule set.
It includes a row for every field of every row of every table used by
the rule set. The standard Row-Who fields are not stored.
Each row contains the table name, the column name and the column
value.

Indexes

Columns

[top of page]

AX.AX_RULE_LINES does not reference any database object

AX.AX_RULE_LINES is referenced by following:

APPS

SYNONYM - AX_RULE_LINES

[top of page]

Table: AX_SECONDARY_INVENTORY

Primary Key: AX_SECONDARY_INVENTORY_PK

1. SECONDARY_INVENTORY_ID

Comments

This table stores numeric identifiers for Inventory suborganizations.
It contains a row for every Inventory suborganization.
Each row contains the suborganization name and the numeric
identifier. Numeric identifiers are used to make the Inventory suborganization
identifiers consistent with those of Payables and Receivables suborganizations.

Primary Key: AX_SECONDARY_INVENTORY_PK

1. SECONDARY_INVENTORY_ID

Indexes

Columns

[top of page]

AX.AX_SECONDARY_INVENTORY does not reference any database object

AX.AX_SECONDARY_INVENTORY is referenced by following:

APPS

SYNONYM - AX_SECONDARY_INVENTORY

[top of page]

Table: AX_SETUP_BOOKS

Primary Key: AX_SETUP_BOOKS_PK

1. SET_OF_BOOKS_ID

Foreign Keys to this table:

Comments

This table stores setup parameters at the set of books level. The information is stored through the Subledger Setup screen.

Primary Key: AX_SETUP_BOOKS_PK

1. SET_OF_BOOKS_ID

Indexes

Columns

[top of page]

AX.AX_SETUP_BOOKS does not reference any database object

AX.AX_SETUP_BOOKS is referenced by following:

APPS

SYNONYM - AX_SETUP_BOOKS

[top of page]

Table: AX_SETUP_GLOBAL

Comments

This table stores the global system parameters. It is a single row
table.
The column CHAR_MODE_FLAG exists for backward compatibility purposes
and it is used to detect non-GUI installations not having used the
Setup forms. This column is pre-seeded with 'Y' and it is
updated to 'N' every time the GUI setup form performs a commit.
Users cannot use the Load program to load rules once the GUI Setup
forms are used. This is to ensure that the users continue setup using
the forms once it is initiated.
The column AX_ENABLED is set to 'Y' if at least a subledger is
defined (row in AX_SETUP_SUBLEDGER). As such, it is a
denormalization.
The column SETUP_STATUS shows the status of the AX setup. It is
initially set to 'NOT_FROZEN' and is set to 'FROZEN' when the setup
freeze process completes successfully.

Columns

[top of page]

AX.AX_SETUP_GLOBAL does not reference any database object

AX.AX_SETUP_GLOBAL is referenced by following:

APPS

SYNONYM - AX_SETUP_GLOBAL

[top of page]

Table: AX_SETUP_INV_ORG_PROCS

Primary Key: AX_SETUP_INV_ORG_PROCS_PK

1. APPLICATION_ID
2. MAIN_SET_OF_BOOKS_ID
3. ORGANIZATION_ID

Foreign Keys from this table:

Comments

This table contains setup parameters specific to the Inventory
organization. Therefore, all the rows in this table have the
APPLICATION_ID column set to 401 (Oracle Inventory); this column exists to
properly define a foreign key towards AX_SETUP_SUBLEDGERS.
It contains one row for each organization connected with the main Set
of Books.

Primary Key: AX_SETUP_INV_ORG_PROCS_PK

1. APPLICATION_ID
2. MAIN_SET_OF_BOOKS_ID
3. ORGANIZATION_ID

Indexes

Columns

[top of page]

AX.AX_SETUP_INV_ORG_PROCS does not reference any database object

AX.AX_SETUP_INV_ORG_PROCS is referenced by following:

APPS

SYNONYM - AX_SETUP_INV_ORG_PROCS

[top of page]

Table: AX_SETUP_POSTING_BOOKS

Primary Key: AX_SETUP_POSTING_BOOKS_PK

1. APPLICATION_ID
2. MAIN_SET_OF_BOOKS_ID
3. SOURCE_ORG_ID
4. POSTING_SET_OF_BOOKS_ID

Foreign Keys from this table:

Comments

This table stores information about posting set of books for each main
set of books.
For each main set of books, it contains at least one row having
posting set of books equal to main set of books. If the main set of
books is a Multiple Reporting Currency book, then it also contains a
row for each reporting set of books.
RULE_NAME contains the name of the rules used by the subledger; it
can be null in a development environment where the rules are under
construction.
RULE_NAME is used instead of RULE_ID because this is keeping
historical information while editing rules. Rules could be discarded
losing the ID but this column should always keep track of the rules
that were used at load time.
The column RULE_CHANGED_FLAG is set to 'Y' by the Setup forms when
the user changes the rule set for a posting set of books. It is used
to identify the rule sets that need to be loaded.

Primary Key: AX_SETUP_POSTING_BOOKS_PK

1. APPLICATION_ID
2. MAIN_SET_OF_BOOKS_ID
3. SOURCE_ORG_ID
4. POSTING_SET_OF_BOOKS_ID

Indexes

Columns

[top of page]

AX.AX_SETUP_POSTING_BOOKS does not reference any database object

AX.AX_SETUP_POSTING_BOOKS is referenced by following:

APPS

SYNONYM - AX_SETUP_POSTING_BOOKS

[top of page]

Table: AX_SETUP_SUBLEDGERS

Primary Key: AX_SETUP_SUBLEDGERS_PK

1. APPLICATION_ID
2. MAIN_SET_OF_BOOKS_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

This table stores the subledger dependent parameters. It contains a
row for each subledger (application and Main set of books).
The following columns are populated only if the application is Oracle
Inventory:
- IPV_AUTOMATIC_PROCESSING
- PPV_AUTOMATIC_PROCESSING

Primary Key: AX_SETUP_SUBLEDGERS_PK

1. APPLICATION_ID
2. MAIN_SET_OF_BOOKS_ID

Indexes

Columns

[top of page]

AX.AX_SETUP_SUBLEDGERS does not reference any database object

AX.AX_SETUP_SUBLEDGERS is referenced by following:

APPS

SYNONYM - AX_SETUP_SUBLEDGERS

[top of page]

Table: AX_SLE_HEADERS

Primary Key: AX_SLE_HEADERS_PK

1. JOURNAL_SEQUENCE_ID
2. SLE_HEADER_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

This table stores the subledger accounting entry headers. One header exists for each accounting entry. The accounting entry header is used to group accounting entry lines.
Each row includes the journal sequence identifier, the value of the
journal sequence associated with the entry, the application, the
posting set of books, the accounting date, the information
related to currency conversion if applicable, and the identifier of the event that
generated the entry.

Primary Key: AX_SLE_HEADERS_PK

1. SET_OF_BOOKS_ID
2. JOURNAL_SEQUENCE_ID
3. SLE_HEADER_ID

Indexes

Columns

[top of page]

AX.AX_SLE_HEADERS does not reference any database object

AX.AX_SLE_HEADERS is referenced by following:

APPS

SYNONYM - AX_SLE_HEADERS

[top of page]

Table: AX_SLE_HEADERS_ARCH

Primary Key: AX_SLE_HEADERS_ARCH_PK

1. JOURNAL_SEQUENCE_ID
2. SLE_HEADER_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

This table stores the rows purged from the AX_SLE_HEADERS table by the Subledger Archive and Purge program.

Primary Key: AX_SLE_HEADERS_ARCH_PK

1. SET_OF_BOOKS_ID
2. JOURNAL_SEQUENCE_ID
3. SLE_HEADER_ID

Indexes

Columns

[top of page]

AX.AX_SLE_HEADERS_ARCH does not reference any database object

AX.AX_SLE_HEADERS_ARCH is referenced by following:

APPS

SYNONYM - AX_SLE_HEADERS_ARCH

[top of page]

Table: AX_SLE_LINES

Primary Key: AX_SLE_LINES_PK

1. JOURNAL_SEQUENCE_ID
2. SLE_HEADER_ID
3. SLE_LINE_NUM

Foreign Keys from this table:

Comments

This table stores subledger accounting entry lines. An accounting entry line is either a
debit or a credit. Accounting entry lines are grouped together by an accounting entry header.
The combination of the header and its lines comprises an accounting entry. All lines
grouped under a header are balanced, meaning that the total debits equals the total credits for
the functional currency. Each row is one accounting entry line.
The BALANCE_FLAG is set to 'Y' when the row has contributed to a balance;
it is either NULL or N otherwise.
Only lines with the account code combination with the control account qualifier set can have the BALANCE_FLAG set to 'Y'.

Primary Key: AX_SLE_LINES_PK

1. SET_OF_BOOKS_ID
2. JOURNAL_SEQUENCE_ID
3. SLE_HEADER_ID
4. SLE_LINE_NUM

Indexes

Columns