| Name | Description | Type | Additional 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. |