eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: WIP.WIP_TRANSACTION_ACCOUNTS

Object Details

Object Name:	WIP_TRANSACTION_ACCOUNTS
Object Type:	TABLE
Owner:	WIP
FND Design Data:	WIP.WIP_TRANSACTION_ACCOUNTS
Subobject Name:
Status:	VALID

WIP_TRANSACTION_ACCOUNTS stores the accounting information for each resource transaction in WIP_TRANSACTIONS. These two tables are joined by the column TRANSACTION_ID, and contain at least two account rows for every resource transaction (unless the resource is uncosted). Each
row represents a debit or a 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 (the job or repetitive schedule). The TRANSACTION_VALUE and BASE_TRANSACTION_VALUE are transferred to the GL_INTERFACE
table through the period close or GL transfer (INTCGL) process. Until this process is run, the GL_BATCH_ID is set to -1. Oracle Work in Process uses the information in this table to track the financial impact of resource transactions.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	5
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WIP_TRANSACTION_ACCOUNTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID REFERENCE_ACCOUNT
WIP_TRANSACTION_ACCOUNTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REFERENCE_ACCOUNT
WIP_TRANSACTION_ACCOUNTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	WIP_ENTITY_ID
WIP_TRANSACTION_ACCOUNTS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GL_BATCH_ID ORGANIZATION_ID TRANSACTION_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_ID	NUMBER		Yes	Transaction Identifier
REFERENCE_ACCOUNT	NUMBER		Yes	Transaction reference 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
ORGANIZATION_ID	NUMBER		Yes	Organization Identifier
TRANSACTION_DATE	DATE		Yes	Date transaction was performed
WIP_ENTITY_ID	NUMBER		Yes	Charged entity Identifier (job or schedule number)
REPETITIVE_SCHEDULE_ID	NUMBER			WIP repetitive schedule Identifier
ACCOUNTING_LINE_TYPE	NUMBER			Purpose or description for the accounting entry
TRANSACTION_VALUE	NUMBER			Accounting value in the transaction currency (NULL if the transaction is in the base currency)
BASE_TRANSACTION_VALUE	NUMBER		Yes	Accounting value in the base currency
CONTRA_SET_ID	NUMBER			Offset account Identifier
PRIMARY_QUANTITY	NUMBER			Transaction quantity for the accounting row
RATE_OR_AMOUNT	NUMBER			Resource requirement or overhead rate/amount for the transaction based on the COST_ELEMENT_ID
BASIS_TYPE	NUMBER			Basis for charging the resource requirement
RESOURCE_ID	NUMBER			Resource requirement 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			Currency conversion date for the transaction
CURRENCY_CONVERSION_TYPE	VARCHAR2	(10)		Currency conversion type for the transaction
CURRENCY_CONVERSION_RATE	NUMBER			Currency conversion rate for the transaction
OVERHEAD_BASIS_FACTOR	NUMBER			The resource requirement value or resource units the overhead is based upon
BASIS_RESOURCE_ID	NUMBER			Resource requirement Identifier for the resource overhead is based on
GL_BATCH_ID	NUMBER			Source General Ledger transaction journal entry batch
REQUEST_ID	NUMBER			Enhanced Who column
PROGRAM_APPLICATION_ID	NUMBER			Enhanced Who column
PROGRAM_ID	NUMBER			Enhanced Who column
PROGRAM_UPDATE_DATE	DATE			Enhanced Who column
GL_SL_LINK_ID	NUMBER			Identifier linking to GL_INTERFACE during GL transfer
WIP_SUB_LEDGER_ID	NUMBER			WIP accounting entry identifier
ENCUMBRANCE_TYPE_ID	NUMBER			Encumbrance type 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
,      ORGANIZATION_ID
,      TRANSACTION_DATE
,      WIP_ENTITY_ID
,      REPETITIVE_SCHEDULE_ID
,      ACCOUNTING_LINE_TYPE
,      TRANSACTION_VALUE
,      BASE_TRANSACTION_VALUE
,      CONTRA_SET_ID
,      PRIMARY_QUANTITY
,      RATE_OR_AMOUNT
,      BASIS_TYPE
,      RESOURCE_ID
,      COST_ELEMENT_ID
,      ACTIVITY_ID
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      OVERHEAD_BASIS_FACTOR
,      BASIS_RESOURCE_ID
,      GL_BATCH_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      GL_SL_LINK_ID
,      WIP_SUB_LEDGER_ID
,      ENCUMBRANCE_TYPE_ID
FROM WIP.WIP_TRANSACTION_ACCOUNTS;

Dependencies

[top of page]

WIP.WIP_TRANSACTION_ACCOUNTS does not reference any database object

WIP.WIP_TRANSACTION_ACCOUNTS is referenced by following:

WIP: WIP_TRANSACTION_ACCOUNTS#