[Home] [Help] [Dependency Information]

TABLE: FA.FA_TRANSACTION_HEADERS

Object Details

Object Name:	FA_TRANSACTION_HEADERS
Object Type:	TABLE
Owner:	FA
FND Design Data:	OFA.FA_TRANSACTION_HEADERS
Subobject Name:
Status:	VALID

Oracle Assets inserts rows to FA_TRANSACTION_HEADERS each time you enter a
transaction.
TRANSACTION_TYPE_CODE identifies the type of transaction:
ADDITION - created by the Books and QuickAdditions forms, and Mass Additions
Post when you add an asset. Also created by the Books form when changing an
asset's financial data in the period you added it. Created by the Capitalize
CIP Assets form when capitalizing a CIP asset.
ADDITION/VOID - created by the Books form when you make changes to an asset's
financial data in the period you added it. Also created by Mass Additions
Post when you add a mass addition line to an asset in the period you added it.
Oracle Assets voids the original ADDITION by changing the transaction type to
ADDITION/VOID and creating a new ADDITION transaction with the new data.
ADJUSTMENT - created by the Books and Mass Change forms when you change
an asset's financial data after the period of addition. Also created by Mass
Copy when copying adjustments to a tax book. Mass Additions Post creates this
type for add-to-assets.
CIP ADDITION - created by the Books and QuickAdditions forms, and Mass
Additions Post for CIP addition. Also created by Mass Additions Post when
adding mass additions lines to new CIP assets.
CIP ADDITION/VOID - created by the CIP Asset Adjustments form and the Transfer

Invoice Lines form when adjusting the cost of a CIP asset in the period you
added it. Mass Additions Post also creates this transaction type when you add
a mass addition line to a CIP asset in the period you added it. Oracle Assets
voids the original CIP ADDITION by changing its type to CIP ADDITION/VOID and
creating a new CIP ADDITION transaction with the new data.
CIP ADJUSTMENT - created by the Transfer Invoice Lines form when changing a
CIP asset's cost in a period after the period you added the asset. Also
created by Mass Additions Post when you add a mass additions line to a CIP
asset after the period you added it.
CIP REVERSE - created by the Capitalize CIP Assets form when you reverse
capitalize a CIP asset in the period you capitalized it.
FULL RETIREMENT and PARTIAL RETIREMENT - created by the Retirements form when
you fully and partially retire an asset respectively. Also created by Mass
Copy when copying these retirements to a tax book.
RECLASS - created by the Additions form when changing the asset category. Also
created by Mass Additions Post when you add a mass addition line and change
the asset category of the existing asset to the category you assigned to the
mass addition.
REINSTATEMENT - created by the Retirements form when you reinstate a retired
asset. Also created by Mass Copy when copying reinstatements to a tax book.
TAX - created by the Reserve Adjustments form and Mass Tax Adjustments when
you change tax reserves.
TRANSFER - created by the Assignments form and Mass Transfers for transfers.
TRANSFER IN - created by the Assignments and QuickAdditions forms, and
Mass Additions Post when assigning GL accounts, locations and employees to new
assets.
TRANSFER IN/VOID - created by the Assignments form when changing GL accounts,
locations or employees in the period of addition. The form voids the original
TRANSFER IN by changing the type to TRANSFER IN/VOID and creating a new
TRANSFER IN transaction with the updated data.
TRANSFER OUT and UNIT ADJUSTMENT - created by the Assignments form when you
partially retire by units and adjust the number of units respectively.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FA_TRANSACTION_HEADERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSACTION_HEADER_ID
FA_TRANSACTION_HEADERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSET_ID BOOK_TYPE_CODE TRANSACTION_TYPE_CODE
FA_TRANSACTION_HEADERS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_TYPE_CODE
FA_TRANSACTION_HEADERS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MASS_REFERENCE_ID
FA_TRANSACTION_HEADERS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVOICE_TRANSACTION_ID
FA_TRANSACTION_HEADERS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BOOK_TYPE_CODE DATE_EFFECTIVE TRANSACTION_TYPE_CODE
FA_TRANSACTION_HEADERS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BOOK_TYPE_CODE TRANSACTION_KEY DATE_EFFECTIVE
FA_TRANSACTION_HEADERS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MEMBER_TRANSACTION_HEADER_ID
FA_TRANSACTION_HEADERS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MASS_TRANSACTION_ID

Columns

Query Text

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

SELECT TRANSACTION_HEADER_ID
,      BOOK_TYPE_CODE
,      ASSET_ID
,      TRANSACTION_TYPE_CODE
,      TRANSACTION_DATE_ENTERED
,      DATE_EFFECTIVE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      TRANSACTION_NAME
,      INVOICE_TRANSACTION_ID
,      SOURCE_TRANSACTION_HEADER_ID
,      MASS_REFERENCE_ID
,      LAST_UPDATE_LOGIN
,      TRANSACTION_SUBTYPE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY_CODE
,      TRANSACTION_KEY
,      AMORTIZATION_START_DATE
,      CALLING_INTERFACE
,      MASS_TRANSACTION_ID
,      MEMBER_TRANSACTION_HEADER_ID
,      TRX_REFERENCE_ID
,      EVENT_ID
FROM FA.FA_TRANSACTION_HEADERS;

Dependencies

[top of page]

FA.FA_TRANSACTION_HEADERS does not reference any database object

FA.FA_TRANSACTION_HEADERS is referenced by following:

FA

FA_TRANSACTION_HEADERS#