DBA Data[Home] [Help] [Dependency Information]

TABLE: INV.MTL_TRANSACTION_ACCOUNTS

Object Details
Object Name: MTL_TRANSACTION_ACCOUNTS
Object Type: TABLE
Owner: INV
FND Design Data: TableINV.MTL_TRANSACTION_ACCOUNTS
Subobject Name:
Status: VALID


MTL_TRANSACTION_ACCOUNTS holds the accounting information for each
material transaction in MTL_MATERIAL_TRANSACTIONS. Oracle Inventory
uses this information to track the financial impact of your quantity
moves.
.
The two tables are joined by the TRANSACTION_ID, and in most
instances, there are at least two account rows for every material
transaction. For some transactions, such as expense items or expense
subinventories, you may not have any accounting. You should not join
these two tables by ORGANIZATION_ID because inter-organizations
transfers occur across organizations.
.
Each row in this table represents a debit or credit accounting entry,
and the sum of all rows for a given transaction identifier should be
zero. Each row includes the account, transaction date, transaction
value, purpose (ACCOUNTING_LINE_TYPE), and the source of the charges
(TRANSACTION_SOURCE_TYPE_ID).
.
The TRANSACTION_VALUES and BASE_TRANSACTION_VALUES are transferred to
the GL_INTERFACE_TABLE through the period close or GL transfer
process, and until this process is run, the GL_BATCH_ID is -1.
.
The index MTL_TRANSACTION_ACCOUNTS_N2 is used only during install
and upgrade, and will be dropped during the course thereof, but is
included here for completeness. The index is named such to coincide
with the equivalent index in R9.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MTL_TRANSACTION_ACCOUNTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_ID
MTL_TRANSACTION_ACCOUNTS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_DATE
MTL_TRANSACTION_ACCOUNTS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREFERENCE_ACCOUNT
ColumnTRANSACTION_DATE
MTL_TRANSACTION_ACCOUNTS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnGL_BATCH_ID
ColumnORGANIZATION_ID
ColumnTRANSACTION_DATE
MTL_TRANSACTION_ACCOUNTS_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_SOURCE_TYPE_ID
ColumnTRANSACTION_DATE
MTL_TRANSACTION_ACCOUNTS_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnTRANSACTION_DATE
ColumnTRANSACTION_SOURCE_TYPE_ID
MTL_TRANSACTION_ACCOUNTS_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_SOURCE_ID
ColumnORGANIZATION_ID
ColumnTRANSACTION_DATE
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER

Transaction identifier
REFERENCE_ACCOUNT NUMBER
Yes Transaction distribution account
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
TRANSACTION_DATE DATE
Yes Transaction date
TRANSACTION_SOURCE_ID NUMBER
Yes Transaction source identifier
TRANSACTION_SOURCE_TYPE_ID NUMBER

Transaction source type identifier
TRANSACTION_VALUE NUMBER

Accounting value in the transaction currency (null for base currency transactions)
PRIMARY_QUANTITY NUMBER

Transaction quantity in primary UOM of the item
GL_BATCH_ID NUMBER

Batch identifier for all downloaded transaction journal entries (set to -1 if not yet transferred)
ACCOUNTING_LINE_TYPE NUMBER
Yes Purpose or description for the accounting entry
BASE_TRANSACTION_VALUE NUMBER
Yes Accounting value in the base currency
CONTRA_SET_ID NUMBER
Yes Offset account identifier
RATE_OR_AMOUNT NUMBER

Material or material overhead rate/amount (depending on cost element identifier)
BASIS_TYPE NUMBER

Basis for charging the material or material overhead value
RESOURCE_ID NUMBER

Resource or sub-element identifier
COST_ELEMENT_ID NUMBER

Cost element identifier
ACTIVITY_ID NUMBER

Activity identifier
CURRENCY_CODE VARCHAR2 (15)
Currency code used in the transaction
CURRENCY_CONVERSION_DATE DATE

Date of the currency conversion
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Currency conversion type used for the transaction
CURRENCY_CONVERSION_RATE NUMBER

Currency conversion rate used for the transaction
REQUEST_ID NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
PROGRAM_ID NUMBER

Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
ENCUMBRANCE_TYPE_ID NUMBER

Encumbrance type identifier
REPETITIVE_SCHEDULE_ID NUMBER

Repetitive schedule identifier
GL_SL_LINK_ID NUMBER

Identifier linking to GL_INTERFACE during GL transfer
USSGL_TRANSACTION_CODE VARCHAR2 (30)
United States standard general ledger transaction code
INV_SUB_LEDGER_ID NUMBER

INV accounting entry identifier
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TRANSACTION_ID
,      REFERENCE_ACCOUNT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      TRANSACTION_DATE
,      TRANSACTION_SOURCE_ID
,      TRANSACTION_SOURCE_TYPE_ID
,      TRANSACTION_VALUE
,      PRIMARY_QUANTITY
,      GL_BATCH_ID
,      ACCOUNTING_LINE_TYPE
,      BASE_TRANSACTION_VALUE
,      CONTRA_SET_ID
,      RATE_OR_AMOUNT
,      BASIS_TYPE
,      RESOURCE_ID
,      COST_ELEMENT_ID
,      ACTIVITY_ID
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ENCUMBRANCE_TYPE_ID
,      REPETITIVE_SCHEDULE_ID
,      GL_SL_LINK_ID
,      USSGL_TRANSACTION_CODE
,      INV_SUB_LEDGER_ID
FROM INV.MTL_TRANSACTION_ACCOUNTS;

Dependencies

[top of page]

INV.MTL_TRANSACTION_ACCOUNTS does not reference any database object

INV.MTL_TRANSACTION_ACCOUNTS is referenced by following:

SchemaINV
ViewMTL_TRANSACTION_ACCOUNTS#