NameDescriptionTypeAdditional information
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.