NameDescriptionTypeAdditional information
OtherSiteName

string

None.

WaspInternalArchiveDate

date

None.

OtherLocationCode

string

None.

DepartmentCode

string

None.

TransactionAttachments

if the user attaches one or more binary data buffer (or file) to a transaction, then the attached binary data will be returned here

Collection of TransactionHistoryAttachmentResponseModel

None.

TransactionNotes

if the user attaches one or more notes (comments/text) to a transaction, then the user text/comments will be returned in this field

Collection of TransactionHistoryNotesResponseModel

None.

HasNotes

string

None.

HasSignature

string

None.

SalesPrice

decimal number

None.

TransTypeNo

integer

None.

AlternateCaptureUomId

integer

None.

AssetClassId

integer

None.

AssetId

integer

None.

AssetTransactionId

integer

None.

AssetTypeCategoryId

integer

None.

AssetTypeId

integer

None.

AssetTypeManufacturerId

integer

None.

AssetTypeSupplierId

integer

None.

ConditionId

integer

None.

ManufacturerId

integer

None.

RowNumber

integer

None.

SiteId

integer

None.

TrackbyId

integer

None.

TransUserRoleId

integer

None.

AssetTransactionCostKeyId

integer

None.

AssetTransactionIdRank

integer

None.

AssetTransactionLocationKeyId

integer

None.

AssetTransOtherAssetId

integer

None.

AssetTransOtherTransId

integer

None.

CustomerId

integer

None.

DepartmentId

integer

None.

DisposeReasonId

integer

None.

EmployeeId

integer

None.

EmployeeManagerId

integer

None.

LocationId

integer

None.

ContainerId

integer

None.

AtlkContainerLocationId

integer

None.

OrganizationId

integer

None.

PoId

integer

None.

OrderLineId

integer

None.

SupplierId

integer

None.

TransUserDepartmentId

integer

None.

UserManagerId

integer

None.

UserType

integer

None.

EmployeeUserId

globally unique identifier

None.

AssetApplicationId

integer

None.

TransactionApplicationId

integer

None.

TransQtyUsingAlternateUomId

decimal number

None.

TransactionUniqueIdentitifer

string

None.

IsSystemGenerated

boolean

None.

AssetTransCheckoutQtyCurrentQty

decimal number

None.

AssetTransCost

decimal number

None.

AssetTransCurrentQty

decimal number

None.

AssetTransQtyCurrentQty

decimal number

None.

AssetTransQuantity

decimal number

None.

CurrentQtyInstantaneouslyAtLocationKeyId

decimal number

None.

AssetDefaultCost

decimal number

None.

OrderNumber

string

None.

AssetTransBatchNo

string

None.

AssetDescription

string

None.

AssetModel

string

None.

AssetSerialNumber

string

None.

AssetTag

string

None.

AssetTransReceiptNum

string

None.

AssetTransRecordSource

string

None.

AssetTypeDescription

string

None.

AssetTypeModelNumber

string

None.

AssetTypeNumber

string

None.

CustomerCompanyName

string

None.

CustomerContactEmail

string

None.

CustomerContactFirstName

string

None.

CustomerContactLastName

string

None.

CustomerNumber

string

None.

EmployeeEmail

string

None.

EmployeeFirstName

string

None.

EmployeeLastName

string

None.

EmployeeNumber

string

None.

LocationCodeOrigValue

from dbo.location.location_code this is the original value without the calculated value of the location_prefix

string

None.

LocationCode

example, if location_code = ''Room 101', location_prefix is 'Parent 1', then LocationFullPath would be 'Parent 1\Room 1'

string

None.

LocationFullPath

example, if location_code = ''Room 101', location_prefix is 'Parent 1', then LocationFullPath would be 'Parent 1\Room 1'

string

None.

LocationPrefix

example, if location_code = ''Room 101', location_prefix is 'Parent 1', then LocationFullPath would be 'Parent 1\Room 1'

string

None.

ParentContainerId

string

None.

ContainerTag

Wasp-Remove-Obsolete-Field

string

None.

LocationDescription

string

None.

ReasonCode

string

None.

ReasonLangLabel

string

None.

SiteDescription

string

None.

SiteName

string

None.

SupplierContactEmail

string

None.

SupplierContactName

string

None.

SupplierEmail

string

None.

SupplierName

string

None.

SupplierNumber

string

None.

SupplierWebsite

string

None.

TransExtCustom1

string

None.

TransExtCustom10

string

None.

TransExtCustom2

string

None.

TransExtCustom3

string

None.

TransExtCustom4

string

None.

TransExtCustom5

string

None.

TransExtCustom6

string

None.

TransExtCustom7

string

None.

TransExtCustom8

string

None.

TransExtCustom9

string

None.

TransExtCustomer

string

None.

TransExtReferenceNumber

string

None.

TransExtSupplier

string

None.

TransExtSalesPrice

decimal number

None.

TransTypeDescription

string

None.

TransTypeLangLabel

string

None.

UserEmail

string

None.

UserFirstName

string

None.

UserLastName

string

None.

UserTitle

string

None.

UserId

globally unique identifier

None.

AssetTransDate

date

None.

SortingIndex

integer

None.

UserLogon

string

None.

ReasonId

integer

None.

AssetTransEntryDate

date

None.

CustomerFirstName

string

None.

CustomerLastName

string

None.

SerialNumber

string

None.

UserTransactionDate

date

None.

TransactionCost

decimal number

None.

Category

string

None.

ActionItem

string

None.

ManufacturerName

string

None.

Assignee

string

None.

CustomerNameCalculated

string

None.

VendorSupplierNameCalculated

string

None.

TransactionDueDate

UPDATE[WaspTrack].[dbo].[form_field_meta] SET ffm_visible_on_grid = 1 where ffm_field like '%due%date%' and form_id = 250

date

None.

Lot

Lot, Date Code, Trackby Serial Number, along with possible user-defined field values help to identify the object/widget.

string

None.

DateCode

string

None.

RefNumber

A reference number that the user may have entered during the capture of a transaction. Not all transactions require a reference number.

string

None.

TrackbyContainerId

This value, along with the ItemNumber, helps to uniquely identify a container being transacted. If this field has a value, its transaction quantities are 1 and cannot exceed 1 since the TrackbyContainerId is globally unique. For example, if TrackbyContainerId-A is being created or moved into TrackbyContainerId-B, then this field will have the value of TrackbyContainerId; however, the field ParentContainerId would have value of TrackbyContainerId-B.

string

None.

LicensePlateNumber

Wasp-Remove-Obsolete-Field

string

None.

BaseUomToAlternateUomDivisor

decimal number

None.

NameOfAlternateUomId

string

None.

Latitude

decimal number

None.

Longitude

decimal number

None.

Altitude

decimal number

None.

Accuracy

decimal number

None.