Inventory Items Technical Fields

When an order is submitted from Salesforce to AWS, Apex code analyses what fields need to be sent to AWS. Not all fields are sent. The processing logic is:

  1. OM takes some default mandatory set of fields. Very few fields are required by core OM

  2. OM takes all fields and attributes that are indicated in decomposition relationships, in mapping rules and in conditions from source products.

  3. OM checks orchestration scenarios linked to source products, checks their conditions, and takes these fields and attributes as well. OM does not check decomposed products because decomposition does not happen at this stage.

Inventory Items Technical Details

The decomposition rules define a source and target for decomposition. The source is typically a commercial product and the destination is a technical specification (CFS/RFS, etc.). When multi-stage decomposition is used, the source can be a technical specification. Instances of a decomposition rule are saved as entries in the Inventory Item Decomposition Relationship (vlocity_cmt__InventoryItemDecompositionRelationship__c) table. This table is where Inventory Items are linked to the Asset/Inventory Item.

Field API Name

Label

Relates To

Value Description

CreatedById

Created By ID

Salesforce

ID of the user who created the item, which is useful for queries and reporting.

CreatedDate

Created Date

Salesforce

Date when the Item was created. Useful for queries and reporting.

Id

Record ID

Salesforce

Salesforce ID of the Item, starting with a6a

IsDeleted

Deleted

Salesforce

Identifies whether the item was deleted. Set to false

LastModifiedById

Last Modified By ID

Salesforce

ID of the user who last modified the Item.

LastModifiedDate

Last Modified Date

Salesforce

Date when the Item was last modified.

Name

InventoryItemDecompositionRelationship Name

Salesforce, OM

The name of the relationship is a generated string with the format [Id].[lineItemNo]. For example: a6P260000004jYAEAY.0001

OwnerId

Owner ID

 

User that owns the Item. This can often be the same as the user that created the item. Suggested implementation: set to the same value as CreatedById.

SystemModstamp

System Modstamp

Salesforce

Salesforce field for querying and reporting.

vlocity_cmt__DestinationInventoryItemId__c

Destination Inventory Item

OM

ID of the Inventory Item as a destination in the decomposition rule.

vlocity_cmt__SourceAssetId__c

Source Asset

OM

ID of the Asset that was the source in the decomposition rule. Mutually exclusive with vlocity_cmt__SourceInventoryItemId__c

vlocity_cmt__SourceInventoryItemId__c

Source Inventory Item

OM

ID of the Inventory Item that was the source for the decomposition rule. Mutually exclusive with vlocity_cmt__SourceAssetId__c

The Inventory Items are objects found in the vlocity_cmt__InventoryItem__c table. The table describes the fields for one Inventory Item:

Field API Name

Label

Relates To

Value Description

CreatedById

Created By ID

Salesforce

ID of the user who created the Item. Useful for queries and reporting.

CreatedDate

Created Date

Salesforce

Date when the Item was created. Useful for queries and reporting.

Id

Record ID

Salesforce

Salesforce ID of the Item. Starts with a6b

IsDeleted

Deleted

Salesforce

Identifies whether the item was deleted. Suggested implementation: set to false

LastModifiedById

Last Modified By ID

Salesforce

ID of the user who last modified the Item.

LastModifiedDate

Last Modified Date

Salesforce

Date when the Item was last modified.

LastReferencedDate

 

Salesforce

Date when the item was last referenced.

LastViewedDate

 

Salesforce

Date when the Item was last viewed.

Name

 

Salesforce, OM

Name of the item. This is required by OM. The name is generated by OM code and is a string with a pattern of [Id].[lineItemNo]. For example: a6P260000004jYAEAY.0001

OwnerId

 

Salesforce

User that owns the Item. This can often be the same as the user that created the item. Suggested implementation: set to the same value as CreatedById.

RecordTypeId

 

Salesforce

ID of the Item record type. Suggested implementation: leave blank.

SystemModstamp

 

Salesforce

Salesforce field for querying and reporting

vlocity_cmt__AccountId__c

Account

OM

ID of the account that owns the item. Set to the same ID used for the assets.

vlocity_cmt__Address__c

Address

OM

The address where the Item is deployed. Suggested implementation: leave blank.

vlocity_cmt__BillingAccountId__c

BillingAccountId

OM

ID of the billing account used for the item. Set to the billing account used for the assets.

vlocity_cmt__JSONAttribute__c

JSONAttribute

OM

Holds the item attributes in JSON format. The JSON structure follows the same rules/format as the same field defined for Assets. It is advisable to set the “value” property of the attributeRunTimeInfo section of each attribute.

vlocity_cmt__LineNumber__c

Line Number

OM

 

vlocity_cmt__PremiseId__c

Installed Premise

OM

ID of the premise where the item was installed/deployed. If not used, leave blank.

vlocity_cmt__ProductId__c

Product

OM

ID of the product, such as a technical specification, that defines the Item.

vlocity_cmt__QualificationExpirationDate__c

Qualification Expiration Date

OM

Used for service qualification. If not used, leave blank.

vlocity_cmt__SerialNumber__c

Serial Number

OM

Serial number of the Item. If not used, leave blank.

vlocity_cmt__ServiceAccountId__c

ServiceAcountId

OM

ID of the service account used for the Item.

vlocity_cmt__ServicePointId__c

Installed Service Point

OM

ID of the service point where the Item was installed/deployed. If not used, leave blank.