AssetLogService
First available in SystemsLink 2019.1. Successor to the deprecated AssetService.
Use AssetLogService 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]/AssetLogService.svc
Methods
| Method Name | Parameters | C# return type | Description | |
|---|---|---|---|---|
Name |
Data type |
|||
GetAssetLog() |
assetType |
List <AssetLog> |
Get an AssetLog list defined by assetType and AssetId. |
|
assetId |
string |
|||
NewAssetLogItem() |
assetType |
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 |
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? |
lastupdatedon |
datetime |
Read only. Not mapped to database. |
UpdatedBy |
string |
lastmodifiedby |
Varcar(50) |
Read only. Not mapped to database. |
Value |
string |
lbl_value |
varchar(50) |
Property to the value of an asset. |