FA_TRANSACTION_HEADERS
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.
Details
-
Schema: FUSION
-
Object owner: FA
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
FA_TRANSACTION_HEADERS_PK |
TRANSACTION_HEADER_ID, BOOK_TYPE_CODE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| TRANSACTION_HEADER_ID | NUMBER | 18 | Yes | Identifier of the asset transaction. | ||
| BOOK_TYPE_CODE | VARCHAR2 | 30 | Yes | Unique book identification name. | ||
| ASSET_ID | NUMBER | 18 | Yes | Identifier of the asset number. | ||
| TRANSACTION_TYPE_CODE | VARCHAR2 | 20 | Yes | Identifier of the asset transaction type. | ||
| TRANSACTION_DATE_ENTERED | DATE | Yes | Date when the transaction occurred. | |||
| AMORTIZATION_START_DATE | DATE | Date to start amortizing the net book value for an asset if the transaction is amortized. | ||||
| DATE_EFFECTIVE | DATE | Yes | Date when the row became effective. | |||
| TRANSACTION_NAME | VARCHAR2 | 240 | Description or comments of the transaction. | |||
| INVOICE_TRANSACTION_ID | NUMBER | 18 | Unique identifier of the invoice transaction. | |||
| SOURCE_TRANSACTION_HEADER_ID | NUMBER | 18 | Identifier of the corresponding transaction in the associated corporate book for a tax transaction that was created by the Mass Copy process. | |||
| MASS_REFERENCE_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
| MASS_TRANSACTION_ID | NUMBER | 18 | Identifier of the mass transaction that invoked the transaction if it is part of a mass transaction. | |||
| TRANSACTION_SUBTYPE | VARCHAR2 | 30 | Further detail of transaction type. | |||
| TRANSACTION_KEY | VARCHAR2 | 2 | General class of transaction. Possible values are R for retirements, UA for unplanned depreciation amortized from current period, and UE for unplanned depreciation expensed. | |||
| MEMBER_TRANSACTION_HEADER_ID | NUMBER | 18 | Identifier of the member asset transaction which spawned this transaction for the group asset. | |||
| TRX_REFERENCE_ID | NUMBER | 18 | Identifier of the transaction reference which links transactions involving multiple assets. | |||
| CONVENTION_TYPE_ID | NUMBER | 18 | Prorate convention identifier. | |||
| PRORATE_DATE | DATE | The date from which the depreciation charge is effective for the asset transaction. | ||||
| CALLING_INTERFACE | VARCHAR2 | 30 | Interface that created the transaction. | |||
| EVENT_ID | NUMBER | 18 | Identifier of the transaction event which is associated with this row for accounting purposes. | |||
| BATCH_NAME | VARCHAR2 | 30 | User-defined batch name originally provided during mass transactions or interface table processing | |||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transactions (FA_TRANSACTION_HEADERS) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transactions (FA_TRANSACTION_HEADERS) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transactions (FA_TRANSACTION_HEADERS) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transactions (FA_TRANSACTION_HEADERS) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transactions (FA_TRANSACTION_HEADERS) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transactions (FA_TRANSACTION_HEADERS) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transactions (FA_TRANSACTION_HEADERS) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transactions (FA_TRANSACTION_HEADERS) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transactions (FA_TRANSACTION_HEADERS) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transactions (FA_TRANSACTION_HEADERS) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transactions (FA_TRANSACTION_HEADERS) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transactions (FA_TRANSACTION_HEADERS) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transactions (FA_TRANSACTION_HEADERS) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transactions (FA_TRANSACTION_HEADERS) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transactions (FA_TRANSACTION_HEADERS) | ||
| ATTRIBUTE_CATEGORY_CODE | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Transactions (FA_TRANSACTION_HEADERS) | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| ORIGINAL_CREATED_BY | VARCHAR2 | 64 | Indicates the user who created this transaction in the FA_MASS_ADDITIONS, FA_ADJUSTMENTS_T, FA_TRANSFERS_T, FA_RETIREMENTS_T, or FA_IMPAIRMENTS table. | |||
| ORIGINAL_CREATION_DATE | TIMESTAMP | Indicates the date and time of the creation of this transaction in the FA_MASS_ADDITIONS, FA_ADJUSTMENTS_T, FA_TRANSFERS_T, FA_RETIREMENTS_T, or FA_IMPAIRMENTS table. | ||||
| APPROVAL_ID | NUMBER | 18 | Identifier of the asset transaction approval cycle. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| FA_TRANSACTION_HEADERS | fa_additions_b | ASSET_ID |
| FA_TRANSACTION_HEADERS | fa_book_controls | BOOK_TYPE_CODE |
| FA_TRANSACTION_HEADERS | fa_transaction_headers | SOURCE_TRANSACTION_HEADER_ID, BOOK_TYPE_CODE |
| FA_TRANSACTION_HEADERS | fa_transaction_headers | MEMBER_TRANSACTION_HEADER_ID, BOOK_TYPE_CODE |
| FA_TRANSACTION_HEADERS | fa_invoice_transactions | INVOICE_TRANSACTION_ID |
| FA_TRANSACTION_HEADERS | fa_trx_references | TRX_REFERENCE_ID |
| fa_asset_history | fa_transaction_headers | TRANSACTION_HEADER_ID_IN, BOOK_TYPE_CODE |
| fa_asset_history | fa_transaction_headers | TRANSACTION_HEADER_ID_OUT, BOOK_TYPE_CODE |
| fa_transaction_headers | fa_transaction_headers | SOURCE_TRANSACTION_HEADER_ID, BOOK_TYPE_CODE |
| fa_transaction_headers | fa_transaction_headers | MEMBER_TRANSACTION_HEADER_ID, BOOK_TYPE_CODE |
| fa_deprn_override | fa_transaction_headers | TRANSACTION_HEADER_ID, BOOK_TYPE_CODE |
| fa_distribution_history | fa_transaction_headers | TRANSACTION_HEADER_ID_OUT, BOOK_TYPE_CODE |
| fa_distribution_history | fa_transaction_headers | TRANSACTION_HEADER_ID_IN, BOOK_TYPE_CODE |
| fa_mc_books | fa_transaction_headers | TRANSACTION_HEADER_ID_IN, BOOK_TYPE_CODE |
| fa_mc_books | fa_transaction_headers | TRANSACTION_HEADER_ID_OUT, BOOK_TYPE_CODE |
| fa_books | fa_transaction_headers | TRANSACTION_HEADER_ID_IN, BOOK_TYPE_CODE |
| fa_books | fa_transaction_headers | TRANSACTION_HEADER_ID_OUT, BOOK_TYPE_CODE |
| fa_books_summary | fa_transaction_headers | TRANSACTION_HEADER_ID_IN, BOOK_TYPE_CODE |
| fa_books_summary | fa_transaction_headers | TRANSACTION_HEADER_ID_OUT, BOOK_TYPE_CODE |
| fa_mc_revaluations | fa_transaction_headers | TRANSACTION_HEADER_ID, BOOK_TYPE_CODE |
| fa_adjustments | fa_transaction_headers | TRANSACTION_HEADER_ID, BOOK_TYPE_CODE |
| fa_mc_retirements | fa_transaction_headers | TRANSACTION_HEADER_ID_IN, BOOK_TYPE_CODE |
| fa_mc_retirements | fa_transaction_headers | TRANSACTION_HEADER_ID_OUT, BOOK_TYPE_CODE |
| fa_trx_references | fa_transaction_headers | SRC_TRANSACTION_HEADER_ID, BOOK_TYPE_CODE |
| fa_trx_references | fa_transaction_headers | DEST_TRANSACTION_HEADER_ID, BOOK_TYPE_CODE |
| fa_trx_references | fa_transaction_headers | MEMBER_TRANSACTION_HEADER_ID, BOOK_TYPE_CODE |
| fa_mc_books_rates | fa_transaction_headers | TRANSACTION_HEADER_ID, BOOK_TYPE_CODE |
| fa_retirements | fa_transaction_headers | TRANSACTION_HEADER_ID_IN, BOOK_TYPE_CODE |
| fa_retirements | fa_transaction_headers | TRANSACTION_HEADER_ID_OUT, BOOK_TYPE_CODE |
| fa_mc_adjustments | fa_transaction_headers | TRANSACTION_HEADER_ID, BOOK_TYPE_CODE |
| fa_mc_books_summary | fa_transaction_headers | TRANSACTION_HEADER_ID_IN, BOOK_TYPE_CODE |
| fa_mc_books_summary | fa_transaction_headers | TRANSACTION_HEADER_ID_OUT, BOOK_TYPE_CODE |
| fa_revaluations | fa_transaction_headers | TRANSACTION_HEADER_ID, BOOK_TYPE_CODE |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FA_TRANSACTION_HEADERS_N1 | Non Unique | Default | ASSET_ID, BOOK_TYPE_CODE, TRANSACTION_TYPE_CODE |
| FA_TRANSACTION_HEADERS_N2 | Non Unique | Default | TRANSACTION_TYPE_CODE, CALLING_INTERFACE |
| FA_TRANSACTION_HEADERS_N3 | Non Unique | Default | MASS_REFERENCE_ID |
| FA_TRANSACTION_HEADERS_N4 | Non Unique | Default | INVOICE_TRANSACTION_ID |
| FA_TRANSACTION_HEADERS_N5 | Non Unique | Default | BOOK_TYPE_CODE, DATE_EFFECTIVE, TRANSACTION_TYPE_CODE |
| FA_TRANSACTION_HEADERS_N6 | Non Unique | Default | BOOK_TYPE_CODE, TRANSACTION_KEY, DATE_EFFECTIVE |
| FA_TRANSACTION_HEADERS_N7 | Non Unique | Default | MEMBER_TRANSACTION_HEADER_ID |
| FA_TRANSACTION_HEADERS_N8 | Non Unique | Default | MASS_TRANSACTION_ID |
| FA_TRANSACTION_HEADERS_U1 | Unique | Default | TRANSACTION_HEADER_ID, BOOK_TYPE_CODE |