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. |
AssetTrackingCode | Value that uniquely identifies the tracking level of the asset. Specifies whether the asset is tracked for the full lifecycle, tracked as a customer asset only, or not tracked. |
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. |
ConfigHeaderId | Value that uniquely identifies the header identifier for the configuration for the asset. |
ConfigRevisionNumber | Value that uniquely identifies the revision number for the configuration for the asset record. |
ConfiguratorPath | Value that uniquely identifies the configurator runtime representation for the Inventory Item Identifier path to the component. |
ContactId | Value that identifies the contact of the asset. For a customer asset, the asset contact could be one of the party contacts that's defined for the customer associated with the asset. For an enterprise asset, the asset contact is an internal employee who's the custodian of the asset. |
CorpCurrencyCode | Value that uniquely identifies the corporate currency code for the Asset Number. |
CountryOfOriginCode | Value that uniquely identifies the code for the country of origin that's used to stripe the product genealogy data. |
CreatedBy | User who created the asset record. |
CreationDate | Date and time when the user created the asset record. |
CriticalityCode | Value that uniquely identifies the criticality code of the asset. |
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. |
CustomerPartyType | Value that uniquely identifies the customer's party type, which can be a person or an organization. |
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. |
GenealogyEnabledFlag | Contains one of the following values: Yes or No. If Yes, then the asset is created from an item for which genealogy is enabled at the item master. If No, then the asset isn't created from an item for which genealogy is enabled at the item master. The default value is No. |
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. |
LogicalRootAssetId | Value that uniquely identifies the logical root asset in the as-sold logical hierarchy. This is a denormalized column. |
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. |
ParentAssetId | Value that uniquely identifies the immediate parent asset in the asset hierarchy. This is a denormalized column. |
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. |
ProjectId | Value that uniquely identifies the foreign key reference to the project. Assets created from supply-chain transactions that are performed in the context of a project will have this value populated. |
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. |
ReturnOrderFulfillLineId | Value that uniquely identifies the return order fulfillment line identifier. |
ReturnOrderId | Value that uniquely identifies the return order header identifier. |
ReturnOrderLineId | Value that uniquely identifies the return order line identifier. |
RootAssetId | Value that uniquely identifies the root asset in the asset hierarchy. This is a denormalized column. |
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. |
SecondaryQuantity | Value that uniquely identifies the secondary quantity captured when the item supports dual units of measure. |
SecondaryUomCode | Value that uniquely identifies the unit of measure code for the secondary quantity. This is captured only when the item supports dual units of measure. |
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. |
ShipmentNumber | Value that uniquely identifies the shipment number that's used as the handle in the movement of products from one organization to another using an in-transit stop. |
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. |
TaskId | Value that uniquely identifies the foreign key reference to the project task. Assets created from supply-chain transactions that are performed in the context of a project task will have this value populated. |
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. |
VldOrganizationId | Value that uniquely identifies the last validation organization used from the source application transaction. |
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. |