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