FA_TRANSFER_DISTS_T
FA_TRANSFERS_DISTS_T contains temporary storage data of asset distribution for transfer transactions.
Details
-
Schema: FUSION
-
Object owner: FA
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
FA_TRANSFER_DISTS_T_PK |
TRANSFER_INTERFACE_ID, LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRANSFER_INTERFACE_ID | NUMBER | 18 | Yes | Identifier of the asset transfer interface row. | |
| LINE_ID | NUMBER | 18 | Yes | Line identifier for transferring a distribution. | |
| SRC_LINE_ID | NUMBER | 18 | Line identifier of the source asset for transferring a distribution. | ||
| DISTRIBUTION_ID | NUMBER | 18 | Identifier of the asset distribution. | ||
| DEST_BOOK_TYPE_CODE | VARCHAR2 | 30 | Unique destination book identification name. | ||
| SRC_DISTRIBUTION_ID | NUMBER | 18 | Source book asset distribution identifier. | ||
| LOCATION_ID | NUMBER | 18 | Location flexfield identification number. | ||
| CODE_COMBINATION_ID | NUMBER | 18 | Identifier of the account code combination for the depreciation expense account. | ||
| ASSIGNED_TO | NUMBER | 18 | Identifier of the employee to whom the asset is assigned. | ||
| TRANSACTION_UNITS | NUMBER | Yes | Number of units involved in the transaction. Negative value for the row from which the units were transferred away or retired. Positive value for the row to which the units were transferred to or added. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the loader job that created or last updated the row. | ||
| 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. | |
| DEPRN_EXPENSE_SEGMENT1 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| DEPRN_EXPENSE_SEGMENT2 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| DEPRN_EXPENSE_SEGMENT3 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| DEPRN_EXPENSE_SEGMENT4 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| DEPRN_EXPENSE_SEGMENT5 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| DEPRN_EXPENSE_SEGMENT6 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| DEPRN_EXPENSE_SEGMENT7 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| DEPRN_EXPENSE_SEGMENT8 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| DEPRN_EXPENSE_SEGMENT9 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| DEPRN_EXPENSE_SEGMENT10 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| DEPRN_EXPENSE_SEGMENT11 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| DEPRN_EXPENSE_SEGMENT12 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| DEPRN_EXPENSE_SEGMENT13 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| DEPRN_EXPENSE_SEGMENT14 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| DEPRN_EXPENSE_SEGMENT15 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| DEPRN_EXPENSE_SEGMENT16 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| DEPRN_EXPENSE_SEGMENT17 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| DEPRN_EXPENSE_SEGMENT18 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| DEPRN_EXPENSE_SEGMENT19 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| DEPRN_EXPENSE_SEGMENT20 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| DEPRN_EXPENSE_SEGMENT21 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| DEPRN_EXPENSE_SEGMENT22 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| DEPRN_EXPENSE_SEGMENT23 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| DEPRN_EXPENSE_SEGMENT24 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| DEPRN_EXPENSE_SEGMENT25 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| DEPRN_EXPENSE_SEGMENT26 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| DEPRN_EXPENSE_SEGMENT27 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| DEPRN_EXPENSE_SEGMENT28 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| DEPRN_EXPENSE_SEGMENT29 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| DEPRN_EXPENSE_SEGMENT30 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| LOCATION_SEGMENT1 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| LOCATION_SEGMENT2 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| LOCATION_SEGMENT3 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| LOCATION_SEGMENT4 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| LOCATION_SEGMENT5 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| LOCATION_SEGMENT6 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| LOCATION_SEGMENT7 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| ASSIGNEE_EMAIL_ADDRESS | VARCHAR2 | 240 | Email address of the person to whom the asset is assigned. | ||
| INTERFACE_LINE_NUMBER | NUMBER | 18 | Optional number used to link parent and child records when more than one transactions exists on an asset in a given load. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| FA_TRANSFER_DISTS_T | fa_transfers_t | TRANSFER_INTERFACE_ID |
| FA_TRANSFER_DISTS_T | fa_locations | LOCATION_ID |
| FA_TRANSFER_DISTS_T | gl_code_combinations | CODE_COMBINATION_ID |
| FA_TRANSFER_DISTS_T | per_persons | ASSIGNED_TO |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FA_TRANSFER_DISTS_T_N1 | Non Unique | Default | LINE_ID |
| FA_TRANSFER_DISTS_T_U1 | Unique | Default | TRANSFER_INTERFACE_ID, LINE_ID |