Installed Base Asset

The Installed Base Asset view object contains information about the asset that are used throughout the asset lifecycle management. It contains information to define the work definitions, work orders, operations, operation items, and resources needed for a maintenance program, maintenance forecast, and repair process.

Data Store Key : FscmTopModelAM.ScmExtractAM.CseBiccExtractAM.CseAssetExtractPVO

Primary Keys : AssetId, AssetTranslationAnalyticsPEOAssetId, AssetTranslationAnalyticsPEOLanguage

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name Description
ActiveEndDate Active end date and time when the user end dated the asset record.
AssetId Value that uniquely identifies the asset. This is the primary key of the Installed Base Asset Details view object.
AssetNumber Value that uniquely identifies the asset. The asset must be unique across the application.
AssetTag This is an additional way of identifying the asset.
AssetTranslationAnalyticsPEOAssetId Value that uniquely identifies the asset. This is a primary key that the application generates when it creates asset translation analytics record.
AssetTranslationAnalyticsPEOCreatedBy User who created the asset for the asset translation analytic record.
AssetTranslationAnalyticsPEOCreationDate Date and time when the user created the asset for the asset translation analytic record.
AssetTranslationAnalyticsPEODescription Asset translation analytic description associated to the asset record.
AssetTranslationAnalyticsPEOLanguage Code of the language into which the asset translation analytics record for the asset are translated.
AssetTranslationAnalyticsPEOLastUpdateLogin Session login associated with the user who most recently updated the asset translation analytics for the asset record.
AssetTranslationAnalyticsPEOLastUpdatedBy User who most recently updated the asset translation analytic record for the asset.
AssetTranslationAnalyticsPEOObjectVersionNumber 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.
AssetTranslationAnalyticsPEOSourceLang Code of the language in which the contents of the asset translation analysis columns were originally created.
AssetTranslationAnalyticsPEOTLLastUpdateDate Date and time when the user most recently updated the asset translation analytics for the asset record.
AttributeCategory Context name for the asset descriptive flexfield.
AttributeChar1 Character segment for the asset descriptive flexfield.
AttributeChar10 Character segment for the asset descriptive flexfield.
AttributeChar11 Character segment for the asset descriptive flexfield.
AttributeChar12 Character segment for the asset descriptive flexfield.
AttributeChar13 Character segment for the asset descriptive flexfield.
AttributeChar14 Character segment for the asset descriptive flexfield.
AttributeChar15 Character segment for the asset descriptive flexfield.
AttributeChar16 Character segment for the asset descriptive flexfield.
AttributeChar17 Character segment for the asset descriptive flexfield.
AttributeChar18 Character segment for the asset descriptive flexfield.
AttributeChar19 Character segment for the asset descriptive flexfield.
AttributeChar2 Character segment for the asset descriptive flexfield.
AttributeChar20 Character segment for the asset descriptive flexfield.
AttributeChar21 Character segment for the asset descriptive flexfield.
AttributeChar22 Character segment for the asset descriptive flexfield.
AttributeChar23 Character segment for the asset descriptive flexfield.
AttributeChar24 Character segment for the asset descriptive flexfield.
AttributeChar25 Character segment for the asset descriptive flexfield.
AttributeChar26 Character segment for the asset descriptive flexfield.
AttributeChar27 Character segment for the asset descriptive flexfield.
AttributeChar28 Character segment for the asset descriptive flexfield.
AttributeChar29 Character segment for the asset descriptive flexfield.
AttributeChar3 Character segment for the asset descriptive flexfield.
AttributeChar30 Character segment for the asset descriptive flexfield.
AttributeChar4 Character segment for the asset descriptive flexfield.
AttributeChar5 Character segment for the asset descriptive flexfield.
AttributeChar6 Character segment for the asset descriptive flexfield.
AttributeChar7 Character segment for the asset descriptive flexfield.
AttributeChar8 Character segment for the asset descriptive flexfield.
AttributeChar9 Character segment for the asset descriptive flexfield.
AttributeDate1 Date segment for the asset descriptive flexfield.
AttributeDate2 Date segment for the asset descriptive flexfield.
AttributeDate3 Date segment for the asset descriptive flexfield.
AttributeDate4 Date segment for the asset descriptive flexfield.
AttributeDate5 Date segment for the asset descriptive flexfield.
AttributeNumber1 Number segment for the asset descriptive flexfield.
AttributeNumber10 Number segment for the asset descriptive flexfield.
AttributeNumber2 Number segment for the asset descriptive flexfield.
AttributeNumber3 Number segment for the asset descriptive flexfield.
AttributeNumber4 Number segment for the asset descriptive flexfield.
AttributeNumber5 Number segment for the asset descriptive flexfield.
AttributeNumber6 Number segment for the asset descriptive flexfield.
AttributeNumber7 Number segment for the asset descriptive flexfield.
AttributeNumber8 Number segment for the asset descriptive flexfield.
AttributeNumber9 Number segment for the asset descriptive flexfield.
AttributeTimestamp1 Date and Time segment for the asset descriptive flexfield.
AttributeTimestamp2 Date and Time segment for the asset descriptive flexfield.
AttributeTimestamp3 Date and Time segment for the asset descriptive flexfield.
AttributeTimestamp4 Date and Time segment for the asset descriptive flexfield.
AttributeTimestamp5 Date and Time segment for the asset descriptive flexfield.
BomExplosionFlag Indicates whether or not the built of material is used to generate the asset structure. This is mostly use during asset creation step.
CompetitorAssetFlag Indicates whether or not the asset is set as competitor asset. Asset can be tagged as competitor asset either on the asset creation step or during updating the asset attributes.
ComponentSequenceId Value that identifies the component sequence identifier for the asset structure.
CorpCurrencyCode Value that uniquely identifies the corporate currency code for the Asset Number.
CreatedBy User who created the asset record.
CreationDate Date and time when the user created the asset record.
CurcyConvRateType Value that uniquely identifies the currency conversion rate type for the asset.
CurrencyCode Value that uniquely identifies the currency code for the asset.
CurrentLocationContext Value that uniquely identifies the current location context for the asset.
CurrentLocationId Value that uniquely identifies the current location identifier for the asset.
CustomerAccountId Value that uniquely identifies the customer account identifier for the customer asset.
CustomerAccountSiteId Value that uniquely identifies the customer account site identifier for the customer asset.
CustomerAccountSiteUseId Value that uniquely identifies the customer account site user identifier for the customer asset.
CustomerAssetEndDate Date and time the customer asset is end dated.
CustomerAssetStartDate Date and time the customer asset is started.
CustomerBillingPartyId Value that unique identifies the Customer Bill to Party identifier for Customer Asset Number.
CustomerBillingPartySiteId Value that uniquely identifies the customer Bill to Party Site identifier for the Customer Asset.
CustomerId This is the asset customer identifier. This is the sold to party identifier for which the asset is sold to.
CustomerSiteId Value that uniquely identifies the customer site Identifier for the customer asset.
CustomerSitePartyId Value that uniquely identifies the customer site party identifier for the customer asset.
DescriptionAssetFlag This is the description of the asset. The user defined description of the features, characteristics, and aspects of the asset.
DfltWoSubType Default work order subtype for the asset. The application uses this attribute to set the work order type when it creates a work order for the asset.
DfltWoType Default work order type for the asset. The application uses this attribute to set the work order type when it creates a work order for the asset.
ExternalLocation Value that uniquely identifies the external location context where the asset currently resides.
ExternalSystemPackingUnit Value that identifies the external system packing unit on the extended attribute fields for the asset.
ExtnAttributeChar001 Character segment for the asset extended attribute field.
ExtnAttributeChar002 Character segment for the asset extended attribute field.
ExtnAttributeChar003 Character segment for the asset extended attribute field.
ExtnAttributeChar004 Character segment for the asset extended attribute field.
ExtnAttributeChar005 Character segment for the asset extended attribute field.
ExtnAttributeChar006 Character segment for the asset extended attribute field.
ExtnAttributeChar007 Character segment for the asset extended attribute field.
ExtnAttributeChar008 Character segment for the asset extended attribute field.
ExtnAttributeChar009 Character segment for the asset extended attribute field.
ExtnAttributeChar010 Character segment for the asset extended attribute field.
ExtnAttributeChar011 Character segment for the asset extended attribute field.
ExtnAttributeChar012 Character segment for the asset extended attribute field.
ExtnAttributeChar013 Character segment for the asset extended attribute field.
ExtnAttributeChar014 Character segment for the asset extended attribute field.
ExtnAttributeChar015 Character segment for the asset extended attribute field.
ExtnAttributeChar016 Character segment for the asset extended attribute field.
ExtnAttributeChar017 Character segment for the asset extended attribute field.
ExtnAttributeChar018 Character segment for the asset extended attribute field.
ExtnAttributeChar019 Character segment for the asset extended attribute field.
ExtnAttributeChar020 Character segment for the asset extended attribute field.
ExtnAttributeChar021 Character segment for the asset extended attribute field.
ExtnAttributeChar022 Character segment for the asset extended attribute field.
ExtnAttributeChar023 Character segment for the asset extended attribute field.
ExtnAttributeChar024 Character segment for the asset extended attribute field.
ExtnAttributeChar025 Character segment for the asset extended attribute field.
ExtnAttributeChar026 Character segment for the asset extended attribute field.
ExtnAttributeChar027 Character segment for the asset extended attribute field.
ExtnAttributeChar028 Character segment for the asset extended attribute field.
ExtnAttributeChar029 Character segment for the asset extended attribute field.
ExtnAttributeChar030 Character segment for the asset extended attribute field.
ExtnAttributeChar031 Character segment for the asset extended attribute field.
ExtnAttributeChar032 Character segment for the asset extended attribute field.
ExtnAttributeChar033 Character segment for the asset extended attribute field.
ExtnAttributeChar034 Character segment for the asset extended attribute field.
ExtnAttributeChar035 Character segment for the asset extended attribute field.
ExtnAttributeChar036 Character segment for the asset extended attribute field.
ExtnAttributeChar037 Character segment for the asset extended attribute field.
ExtnAttributeChar038 Character segment for the asset extended attribute field.
ExtnAttributeChar039 Character segment for the asset extended attribute field.
ExtnAttributeChar040 Character segment for the asset extended attribute field.
ExtnAttributeChar041 Character segment for the asset extended attribute field.
ExtnAttributeChar042 Character segment for the asset extended attribute field.
ExtnAttributeChar043 Character segment for the asset extended attribute field.
ExtnAttributeChar044 Character segment for the asset extended attribute field.
ExtnAttributeChar045 Character segment for the asset extended attribute field.
ExtnAttributeChar046 Character segment for the asset extended attribute field.
ExtnAttributeChar047 Character segment for the asset extended attribute field.
ExtnAttributeChar048 Character segment for the asset extended attribute field.
ExtnAttributeChar049 Character segment for the asset extended attribute field.
ExtnAttributeChar050 Character segment for the asset extended attribute field.
ExtnAttributeChar051 Character segment for the asset extended attribute field.
ExtnAttributeChar052 Character segment for the asset extended attribute field.
ExtnAttributeChar053 Character segment for the asset extended attribute field.
ExtnAttributeChar054 Character segment for the asset extended attribute field.
ExtnAttributeChar055 Character segment for the asset extended attribute field.
ExtnAttributeChar056 Character segment for the asset extended attribute field.
ExtnAttributeChar057 Character segment for the asset extended attribute field.
ExtnAttributeChar058 Character segment for the asset extended attribute field.
ExtnAttributeChar059 Character segment for the asset extended attribute field.
ExtnAttributeChar060 Character segment for the asset extended attribute field.
ExtnAttributeChar061 Character segment for the asset extended attribute field.
ExtnAttributeChar062 Character segment for the asset extended attribute field.
ExtnAttributeChar063 Character segment for the asset extended attribute field.
ExtnAttributeChar064 Character segment for the asset extended attribute field.
ExtnAttributeChar065 Character segment for the asset extended attribute field.
ExtnAttributeChar066 Character segment for the asset extended attribute field.
ExtnAttributeChar067 Character segment for the asset extended attribute field.
ExtnAttributeChar068 Character segment for the asset extended attribute field.
ExtnAttributeChar069 Character segment for the asset extended attribute field.
ExtnAttributeChar070 Character segment for the asset extended attribute field.
ExtnAttributeChar071 Character segment for the asset extended attribute field.
ExtnAttributeChar072 Character segment for the asset extended attribute field.
ExtnAttributeChar073 Character segment for the asset extended attribute field.
ExtnAttributeChar074 Character segment for the asset extended attribute field.
ExtnAttributeChar075 Character segment for the asset extended attribute field.
ExtnAttributeChar076 Character segment for the asset extended attribute field.
ExtnAttributeChar077 Character segment for the asset extended attribute field.
ExtnAttributeChar078 Character segment for the asset extended attribute field.
ExtnAttributeChar079 Character segment for the asset extended attribute field.
ExtnAttributeChar080 Character segment for the asset extended attribute field.
ExtnAttributeChar081 Character segment for the asset extended attribute field.
ExtnAttributeChar082 Character segment for the asset extended attribute field.
ExtnAttributeChar083 Character segment for the asset extended attribute field.
ExtnAttributeChar084 Character segment for the asset extended attribute field.
ExtnAttributeChar085 Character segment for the asset extended attribute field.
ExtnAttributeChar086 Character segment for the asset extended attribute field.
ExtnAttributeChar087 Character segment for the asset extended attribute field.
ExtnAttributeChar088 Character segment for the asset extended attribute field.
ExtnAttributeChar089 Character segment for the asset extended attribute field.
ExtnAttributeChar090 Character segment for the asset extended attribute field.
ExtnAttributeChar091 Character segment for the asset extended attribute field.
ExtnAttributeChar092 Character segment for the asset extended attribute field.
ExtnAttributeChar093 Character segment for the asset extended attribute field.
ExtnAttributeChar094 Character segment for the asset extended attribute field.
ExtnAttributeChar095 Character segment for the asset extended attribute field.
ExtnAttributeChar096 Character segment for the asset extended attribute field.
ExtnAttributeChar097 Character segment for the asset extended attribute field.
ExtnAttributeChar098 Character segment for the asset extended attribute field.
ExtnAttributeChar099 Character segment for the asset extended attribute field.
ExtnAttributeChar100 Character segment for the asset extended attribute field.
ExtnAttributeClob001 CLOB segment for the asset extended attribute field.
ExtnAttributeClob002 CLOB segment for the asset extended attribute field.
ExtnAttributeClob003 CLOB segment for the asset extended attribute field.
ExtnAttributeClob004 CLOB segment for the asset extended attribute field.
ExtnAttributeClob005 CLOB segment for the asset extended attribute field.
ExtnAttributeNumber001 Number segment for the asset extended attribute field.
ExtnAttributeNumber002 Number segment for the asset extended attribute field.
ExtnAttributeNumber003 Number segment for the asset extended attribute field.
ExtnAttributeNumber004 Number segment for the asset extended attribute field.
ExtnAttributeNumber005 Number segment for the asset extended attribute field.
ExtnAttributeNumber006 Number segment for the asset extended attribute field.
ExtnAttributeNumber007 Number segment for the asset extended attribute field.
ExtnAttributeNumber008 Number segment for the asset extended attribute field.
ExtnAttributeNumber009 Number segment for the asset extended attribute field.
ExtnAttributeNumber010 Number segment for the asset extended attribute field.
ExtnAttributeNumber011 Number segment for the asset extended attribute field.
ExtnAttributeNumber012 Number segment for the asset extended attribute field.
ExtnAttributeNumber013 Number segment for the asset extended attribute field.
ExtnAttributeNumber014 Number segment for the asset extended attribute field.
ExtnAttributeNumber015 Number segment for the asset extended attribute field.
ExtnAttributeNumber016 Number segment for the asset extended attribute field.
ExtnAttributeNumber017 Number segment for the asset extended attribute field.
ExtnAttributeNumber018 Number segment for the asset extended attribute field.
ExtnAttributeNumber019 Number segment for the asset extended attribute field.
ExtnAttributeNumber020 Number segment for the asset extended attribute field.
ExtnAttributeNumber021 Number segment for the asset extended attribute field.
ExtnAttributeNumber022 Number segment for the asset extended attribute field.
ExtnAttributeNumber023 Number segment for the asset extended attribute field.
ExtnAttributeNumber024 Number segment for the asset extended attribute field.
ExtnAttributeNumber025 Number segment for the asset extended attribute field.
ExtnAttributeNumber026 Number segment for the asset extended attribute field.
ExtnAttributeNumber027 Number segment for the asset extended attribute field.
ExtnAttributeNumber028 Number segment for the asset extended attribute field.
ExtnAttributeNumber029 Number segment for the asset extended attribute field.
ExtnAttributeNumber030 Number segment for the asset extended attribute field.
ExtnAttributeNumber031 Number segment for the asset extended attribute field.
ExtnAttributeNumber032 Number segment for the asset extended attribute field.
ExtnAttributeNumber033 Number segment for the asset extended attribute field.
ExtnAttributeNumber034 Number segment for the asset extended attribute field.
ExtnAttributeNumber035 Number segment for the asset extended attribute field.
ExtnAttributeNumber036 Number segment for the asset extended attribute field.
ExtnAttributeNumber037 Number segment for the asset extended attribute field.
ExtnAttributeNumber038 Number segment for the asset extended attribute field.
ExtnAttributeNumber039 Number segment for the asset extended attribute field.
ExtnAttributeNumber040 Number segment for the asset extended attribute field.
ExtnAttributeNumber041 Number segment for the asset extended attribute field.
ExtnAttributeNumber042 Number segment for the asset extended attribute field.
ExtnAttributeNumber043 Number segment for the asset extended attribute field.
ExtnAttributeNumber044 Number segment for the asset extended attribute field.
ExtnAttributeNumber045 Number segment for the asset extended attribute field.
ExtnAttributeNumber046 Number segment for the asset extended attribute field.
ExtnAttributeNumber047 Number segment for the asset extended attribute field.
ExtnAttributeNumber048 Number segment for the asset extended attribute field.
ExtnAttributeNumber049 Number segment for the asset extended attribute field.
ExtnAttributeNumber050 Number segment for the asset extended attribute field.
ExtnAttributeTimestamp001 Date and time segment for the asset extended attribute field.
ExtnAttributeTimestamp002 Date and time segment for the asset extended attribute field.
ExtnAttributeTimestamp003 Date and time segment for the asset extended attribute field.
ExtnAttributeTimestamp004 Date and time segment for the asset extended attribute field.
ExtnAttributeTimestamp005 Date and time segment for the asset extended attribute field.
ExtnAttributeTimestamp006 Date and time segment for the asset extended attribute field.
ExtnAttributeTimestamp007 Date and time segment for the asset extended attribute field.
ExtnAttributeTimestamp008 Date and time segment for the asset extended attribute field.
ExtnAttributeTimestamp009 Date and time segment for the asset extended attribute field.
ExtnAttributeTimestamp010 Date and time segment for the asset extended attribute field.
FulfillLineId Value that uniquely identify the asset fulfillment line identifier.
GenObjectId Value that uniquely identifies the asset genealogy object identifier.
InServiceDate Date and time when the organization which put the asset in service. The in-service date must occur after the installed date.
InstalledDate Date and time when the organization which is installed the asset. The installed date must occur after the shipment date and before the in-service date.
InstalledLocationContext Value that uniquely identify the asset installed location context.
InstalledLocationId Value that uniquely identify the asset installed location identifier.
InventoryLocatorId Value that uniquely identifies the inventory locator the asset is located in.
IotEnabledFlag Indicates whether or not the Internet of Things is used to generate the asset record.
ItemId Number uniquely identifying the item that the application has enabled for the asset record.
ItemOrganizationId Value that uniquely identifies the inventory organization that the application has enabled for the asset record.
ItemRevision Number uniquely identifying the item revision that the application has enabled for the asset 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.
Language Code of the language into which the contents of the asset are translated.
LastUpdateDate Date and time when the user most recently updated the asset record.
LastUpdateLogin Session login associated with the user who most recently updated the asset record.
LastUpdatedBy User who most recently updated the asset record.
LocationOrganizationId Value that uniquely identifies the inventory organization that the application has enabled for asset.
LogicalFlag Value that uniquely identifies whether or not the asset is set as logical asset.
LotNumber Value that identifies the inventory lot number the asset is associated to.
MaintainableFlag Indicates whether or not the maintenance program can be generated for the asset record.
NewWoAllowedFlag Indicates whether or not work order can be generated for the asset 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.
OriginationDate Value that uniquely identified the original creation date of the lot number or serial number for the asset record.
OwnedBy Value that indicates who the owner of the asset is. Values could be E for Enterprise and C for Customer.
ParentFulfillLineId Value that uniquely identifies the distributed order orchestration fulfillment line reference for the asset record.
ParentOrderLineId Value that uniquely identifies the order line identifier of the parent order line. When assets are created from order management integration, the parent order line identifier is provided to be captured against the asset record.
ParentOrderLineNumber Value that uniquely identifies the order line number of the parent order line. When assets are created from order management integration, the parent order line reference is provided to be captured against the asset record.
PartiallyFinishedFlag Indicates whether the assembly serial is still a partially finished assembly for the asset record.
PurchaseDate Date and time when the customer purchased the asset. This date and time is provide along with the registration date.
Quantity Unit of measure quantity for the asset record.
QuantityPerAssembly Unit of measure quantity per assembly for the asset record.
RegisteredFlag Indicate whether or not the customer asset is registered for the asset record.
RegistrationDate Date and time when the user registered the asset record.
RequestId The request Identifier of the job that created or most recently updated the row. This is populated through Enterprise Service Scheduler.
SalesOrderId Value that uniquely identifies the sales order identifier that ordered the asset record.
SalesOrderLineId Value that uniquely identifies the sales order line identifier that ordered the asset record.
SalesOrderLineNumber Value that uniquely identifies the sales order line number that ordered the asset record.
SalesOrderNumber Value that uniquely identifies the sales order number that ordered the asset record.
SalesOrderSourceSystem Value that uniquely identifies the sales order source system that ordered the asset record.
SalesOrderSourceSystemType Value that uniquely identifies the sales order source system type that ordered the asset record.
SerialNumber Value that uniquely identifies the serial number for the asset record.
ShipmentDate Date and time when the application ships the asset record to the customer.
ShipmentId Value that uniquely identifies the shipment identifier for the asset record.
SoldByBusinessUnitId Value that uniquely identifies the of the business unit identifier that sold the asset record.
SplitFromAssetId Value that indicates the originated asset the asset record is split from.
StatusCode Value that uniquely identifies the status code for the asset record.
SubinventoryCode Value that uniquely identifies the subinventory the asset is located in.
SupplierId Value that uniquely identifies the supplier identifier for the asset record.
SupplierSiteId Value that uniquely identifies the supplier site identifier for the asset record.
UnassignedFlag Value that indicates whether the asset is unassigned.
UomCode Indicates the unit of measure code for the asset.
UsedBy Value that indicates who's the user of the asset. Values could be either E for Enterprise and C for Customer.
WorkCenterId Value that uniquely identifies the work center identifier for the asset record.
WorkOrderId Value that identifies the work order identifier for the asset record.
WorkOrderOperationId Value that identifies the work order operation identifier for the asset record.