This is the Enity table for Fixed asset inter-asset transactions details
Module: Assets
TRX_REFERENCE_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
TRX_REFERENCE_ID | NUMBER | 38 | 0 | True | Identifier of the transaction reference which links transactions involving multiple assets. | ||
SOURCE_RECORD_ID | VARCHAR2 | 64 | Source record identifier. Value is derived from a combination of Asset Transaction header identifiers. | ||||
SUBLEDGER_LINKAGE_HDR_ENTITY_ID | VARCHAR2 | 64 | Subledger Linkage Header Entity Identifier | ||||
TRANSACTION_TYPE | VARCHAR2 | 32 | Classification of the inter-asset transaction. | ||||
SRC_TRANSACTION_SUBTYPE | VARCHAR2 | 32 | Further detail of the transaction type for source asset. | ||||
DEST_TRANSACTION_SUBTYPE | VARCHAR2 | 32 | Further detail of the transaction type for destination asset. | ||||
BOOK_TYPE_CODE | VARCHAR2 | 32 | Unique book identification name. | ||||
SRC_ASSET_ID | NUMBER | 38 | 0 | Identifier of the source asset on which the transaction occurred. | |||
SRC_TRANSACTION_HEADER_ID | NUMBER | 38 | 0 | Identifier of the source transaction. | |||
DEST_ASSET_ID | NUMBER | 38 | 0 | Identifier of the destination asset on which the transaction occurred. | |||
DEST_TRANSACTION_HEADER_ID | NUMBER | 38 | 0 | Identifier of the destination transaction. | |||
MEMBER_ASSET_ID | NUMBER | 38 | 0 | Identification number of the member asset. | |||
MEMBER_TRANSACTION_HEADER_ID | NUMBER | 38 | 0 | Identifier of the member asset transaction which spawned this transaction for the group asset. | |||
SRC_AMORTIZATION_START_DATE | DATE | Amortization start date for the source asset transaction. | |||||
DEST_AMORTIZATION_START_DATE | DATE | Amortization start date for the destination asset transaction. | |||||
RESERVE_TRANSFER_AMOUNT | NUMBER | Reserve amount transferred between assets. | |||||
SRC_EXPENSE_AMOUNT | NUMBER | Amount entered for catch-up depreciation expense on the source asset transaction. | |||||
DEST_EXPENSE_AMOUNT | NUMBER | Amount entered for catch-up depreciation expense on the destination asset transaction. | |||||
SRC_EOFY_RESERVE | NUMBER | Amount entered for the reserve of the prior fiscal year for the source asset. | |||||
DEST_EOFY_RESERVE | NUMBER | Depreciation reserve of the destination asset at the end of the previous fiscal year. | |||||
EVENT_ID | NUMBER | 38 | 0 | Identifier of the transaction event which is associated with this row for accounting purposes. | |||
INVOICE_TRANSACTION_ID | NUMBER | 38 | 0 | Unique identifier of the invoice transaction. | |||
CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||||
CREATED_BY | VARCHAR2 | 128 | Who column: indicates the user who created the row. | ||||
LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||||
LAST_UPDATED_BY | VARCHAR2 | 128 | Who column: indicates the user who last updated the row. | ||||
LAST_UPDATE_LOGIN | VARCHAR2 | 64 | Who column: indicates the session login associated to the user who last updated the row. | ||||
OBJECT_VERSION_NUMBER | NUMBER | 38 | 0 | 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. |