AssetService

Deprecated in SystemsLink 2019.1. See AssetLogService.

Use AssetService to create and get detailed log information about an asset (or resource). In TMWSuite, an asset is typically a carrier (third-party trucking company), driver, tractor, trailer, or other resource assigned to move freight.

Endpoint Address: [SystemsLinkRootUrl]/AssetService.svc

Methods

Method Name Parameters C# return type Description

Name

Data type

GetAssetLog()

assetType

assetTypeEnum

List <AssetLog>

Get an AssetLog list defined by assetType and AssetId.

assetId

string

NewAssetLogItem()

assetType

assetTypeEnum

AssetLog

Create a new Asset Log with the specified assetType and assetId.

assetId

string

SaveAssetLog()

data

AssetLog

AssetLog

Save the AssetLog to the database.

Search()

filter

FilterObjectOfAssetLog

PagedResultOfAssetLog

Return a paged result of the given asset log.

Properties and column mapping

Columns in Database column Name are from the AssetProfileLog database table.
Property Database column Comments

Name

C# data type

Name

Data type

AppliedBySqlJob

bool?

appliedbysqljob

char(1)

Property to flag if the asset log is a SQL job.

AppliedOnDate

DateTime?

appliedon

datetime

Property to record when the SQL was a applied.

AssetId

string

res_id

varchar(13)

Unique identifier for an asset.

AssetLogId

int

Unique Identifier for an asset log. Not mapped to database.

AssetType

assetTypeEnum?

res_type

varchar(50)

Enumeration for driver, tractor, trailer, and carrier.

Category

string

lbl_catergory

varchar(50)

Property to record a category.

ControlData

string

Do not set. Read only. Not mapped to database.

CreatedBy

string

createdby

VARCHAR(50)

Read only. Not mapped to database.

CreatedDateTime

DateTime?

created

datetime

Read only. Not mapped to database.

EffectiveDate

DateTime?

effective

datetime

Property to record the effective date.

Name

string

lbl_name

varchar(50)

Property to record a name.

OriginalName

string

lbl_original_name

varchar(50)

Property to record the original name.

OrignalValue

string

lbl_original_value

varchar(50)

Property to record the original value.

RuleData

Read only. Not mapped to database.

UpdateDateTime

DateTime?

lastupdateon

datetime

Read only. Not mapped to database.

UpdatedBy

string

lastmodifiedby

Varchar(50)

Read only. Not mapped to database.

Value

string

lbl_value

varchar(50)

Property to the value of an asset.