Asset Transaction
The Asset Transaction view object stores the main transactional actions that happens to change the state of the asset or the asset structure business objects.
Data Store Key : FscmTopModelAM.ScmExtractAM.CseBiccExtractAM.AssetTransactionExtractPVO
Primary Keys : TransactionId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| AttributeCategory | Context name for the asset transaction descriptive flexfield. |
| AttributeChar1 | Character segment for the asset transaction descriptive flexfield. |
| AttributeChar10 | Character segment for the asset transaction descriptive flexfield. |
| AttributeChar11 | Character segment for the asset transaction descriptive flexfield. |
| AttributeChar12 | Character segment for the asset transaction descriptive flexfield. |
| AttributeChar13 | Character segment for the asset transaction descriptive flexfield. |
| AttributeChar14 | Character segment for the asset transaction descriptive flexfield. |
| AttributeChar15 | Character segment for the asset transaction descriptive flexfield. |
| AttributeChar16 | Character segment for the asset transaction descriptive flexfield. |
| AttributeChar17 | Character segment for the asset transaction descriptive flexfield. |
| AttributeChar18 | Character segment for the asset transaction descriptive flexfield. |
| AttributeChar19 | Character segment for the asset transaction descriptive flexfield. |
| AttributeChar2 | Character segment for the asset transaction descriptive flexfield. |
| AttributeChar20 | Character segment for the asset transaction descriptive flexfield. |
| AttributeChar3 | Character segment for the asset transaction descriptive flexfield. |
| AttributeChar4 | Character segment for the asset transaction descriptive flexfield. |
| AttributeChar5 | Character segment for the asset transaction descriptive flexfield. |
| AttributeChar6 | Character segment for the asset transaction descriptive flexfield. |
| AttributeChar7 | Character segment for the asset transaction descriptive flexfield. |
| AttributeChar8 | Character segment for the asset transaction descriptive flexfield. |
| AttributeChar9 | Character segment for the asset transaction descriptive flexfield. |
| AttributeDate1 | Date segment for the asset transaction descriptive flexfield. |
| AttributeDate2 | Date segment for the asset transaction descriptive flexfield. |
| AttributeDate3 | Date segment for the asset transaction descriptive flexfield. |
| AttributeDate4 | Date segment for the asset transaction descriptive flexfield. |
| AttributeDate5 | Date segment for the asset transaction descriptive flexfield. |
| AttributeNumber1 | Number segment for the asset transaction descriptive flexfield. |
| AttributeNumber10 | Number segment for the asset transaction descriptive flexfield. |
| AttributeNumber2 | Number segment for the asset transaction descriptive flexfield. |
| AttributeNumber3 | Number segment for the asset transaction descriptive flexfield. |
| AttributeNumber4 | Number segment for the asset transaction descriptive flexfield. |
| AttributeNumber5 | Number segment for the asset transaction descriptive flexfield. |
| AttributeNumber6 | Number segment for the asset transaction descriptive flexfield. |
| AttributeNumber7 | Number segment for the asset transaction descriptive flexfield. |
| AttributeNumber8 | Number segment for the asset transaction descriptive flexfield. |
| AttributeNumber9 | Number segment for the asset transaction descriptive flexfield. |
| AttributeTimestamp1 | Date and Time segment for the asset transaction descriptive flexfield. |
| AttributeTimestamp2 | Date and Time segment for the asset transaction descriptive flexfield. |
| AttributeTimestamp3 | Date and Time segment for the asset transaction descriptive flexfield. |
| AttributeTimestamp4 | Date and Time segment for the asset transaction descriptive flexfield. |
| AttributeTimestamp5 | Date and Time segment for the asset transaction descriptive flexfield. |
| BusinessProcessCode | Value that identifies the business process code on which the asset transaction is captured. |
| CreatedBy | User who created the asset transaction record. |
| CreationDate | Date and time when the user created the asset transaction record. |
| CreationMode | Value that identifies the creation mode when the user created the asset transaction record. |
| ExpenditureDate | Value that identifies the date on which the project expenditure for the asset transaction is captured. |
| ExpenditureOrganizationId | Value that identifies the organization on which the project expenditure for the asset transaction is captured. |
| ExpenditureTypeId | Value that identifies the expenditure type of the project expenditure for the asset transaction. |
| ItemId | Number uniquely identifying the item that the application has enabled for the asset transaction record. |
| ItemOrganizationId | Value that uniquely identifies the inventory organization that the application has enabled for the asset transaction record. |
| ItemRevision | Number uniquely identifying the item revision that the application has enabled for the asset transaction record. |
| JobDefinitionName | Name of the job that created or most recently updated the row for the asset record. This is populated through Enterprise Service Scheduler. |
| JobDefinitionPackage | Package name of the job that created or most recently updated the row for the asset record. This is populated through Enterprise Service Scheduler. |
| LastUpdateDate | Date and time when the user most recently updated the asset transaction record. |
| LastUpdateLogin | Session login associated with the user who most recently updated the asset transaction record. |
| LastUpdatedBy | User who most recently updated the asset transaction record. |
| ObjectVersionNumber | Number of times the object row was updated. This attribute is used to implement optimistic locking. This number is incremented every time 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. |
| ProjectId | Value the identifies the foreign key reference to the project. This value is populated when the assets created from supply chain transactions that are performed in the context of a project. |
| ReferencedTransactionId | Value that identifies the upgrade or replace transaction reference. The reference transaction identifier will provide place holder for canceling transaction. The reference transaction identifier will be populated for canceled transaction only. |
| RequestId | The request Identifier of the job that created or most recently updated the row. This is populated through Enterprise Service Scheduler. |
| SecondaryQuantity | Value that identifies the secondary quantity of the transacted asset. |
| SecondaryUomCode | Value that identifies the secondary unit of measure code of the transacted asset. |
| SourceLotTxnFlag | Value that identifies the source lot transaction attribute of the transacted asset |
| SrcSystemId | Value that indicates the Source System Identifier for the transacted asset. This value is provide by the application when the source system type is Internal. |
| SrcSystemType | Value that indicates the Source System type for the transacted asset. This value is provided by the application when the source system type is Internal. |
| SrcTransactionDate | Value that identifies the source transaction date of the transacted asset. This value is populated when the transaction was performed in the source system. |
| SrcTransactionId | Value that uniquely identifies the source transaction. This value is populated for the transaction in the source system. |
| SrcTransactionQty | Value that identifies the source transaction quantity of the transacted asset. This value is populated when the transaction was performed in the source system. |
| SrcTransactionType | Value that identifies the source transaction type of the transacted asset. This value is populated when the transaction was performed in the source system. |
| SrcTransactionTypeId | Value that identifies the source transaction type of the transacted asset. This value is populated when the transaction was performed in the source system. |
| SrcTransactionUomCode | Value that identifies the source transaction unit of measure code of the transacted asset. This value is populated when the transaction was performed in the source system. |
| TaskId | Value that identifies the foreign key reference to the Project Task. This value is populated for the assets created from supply chain transactions that are performed in the context of a project task. |
| TransactionId | Value that uniquely identifies the transaction. This values is the primary key column. |
| TxnGroupId | Value that uniquely identifies the transaction group. |