Pagination Fields
The following table contains a list of fields that can be used within the inventory detail request payload. You can filter and sort the results by any of the fields listed below.
caution
Serial number, Product Attributes, and Custom Attributes all require configuration before they are able to be utilized.
| Field | Type | Filterable | Sortable | Open Search Compatible | Operators |
|---|---|---|---|---|---|
| WarehouseCode | string | ✓ | ✓ | ✓ | Equal, Contains, BeginsWith, EndsWith |
| ProductCode | string | ✓ | ✓ | ✓ | Equal, Contains |
| CommodityCode | string | ✓ | ✓ | ✓ | Equal, Contains |
| DocketReference | string | ✓ | ✓ | ✓ | Equal, Contains, BeginsWith, EndsWith |
| SourceDocketId | string | ✓ | ✓ | ✓ | Equal, Contains, BeginsWith, EndsWith |
| PrimaryReference | string | ✓ | ✓ | ✓ | Equal, Contains, BeginsWith, EndsWith |
| SourcePrimaryReference | string | ✓ | ✓ | ✓ | Equal, Contains, BeginsWith, EndsWith |
| SecondaryReference | string | ✓ | ✓ | ✓ | Equal, Contains, BeginsWith, EndsWith |
| InventoryStatus | string | ✓ | ✓ | Equal, Contains, BeginsWith, EndsWith | |
| HoldCode | string | ✓ | ✓ | Equal, NotEqual, Contains, BeginsWith, EndsWith | |
| TotalQuantity | decimal | ✓ | ✓ | Equal, GreaterThan, LessThan, GreaterThanOrEqual, LessThanOrEqual, Between, NotBetween | |
| AvailableQuantity | decimal | ✓ | ✓ | Equal, GreaterThan, LessThan, GreaterThanOrEqual, LessThanOrEqual, Between, NotBetween | |
| ArrivalDate | date | ✓ | ✓ | GreaterThan, LessThan, GreaterThanOrEqual, LessThanOrEqual, Between, NotBetween | |
| DaysOnHand | decimal | ✓ | ✓ | Equal, GreaterThan, LessThan, GreaterThanOrEqual, LessThanOrEqual, Between, NotBetween | |
| SerialNumber | string | ✓ | ✓ | ✓ | Equal, Contains, BeginsWith, EndsWith |
| ProductAttribute1 | string | ✓ | ✓ | ✓ | Equal, Contains, BeginsWith, EndsWith |
| ProductAttribute2 | string | ✓ | ✓ | ✓ | Equal, Contains, BeginsWith, EndsWith |
| ProductAttribute3 | string | ✓ | ✓ | ✓ | Equal, Contains, BeginsWith, EndsWith |
| CustomAttribute1 | string | ✓ | ✓ | ✓ | Equal, Contains, BeginsWith, EndsWith |
| CustomAttribute2 | string | ✓ | ✓ | ✓ | Equal, Contains, BeginsWith, EndsWith |
| CustomAttribute3 | string | ✓ | ✓ | ✓ | Equal, Contains, BeginsWith, EndsWith |
| CustomAttribute4 | string | ✓ | ✓ | ✓ | Equal, Contains, BeginsWith, EndsWith |
| CustomAttribute5 | string | ✓ | ✓ | ✓ | Equal, Contains, BeginsWith, EndsWith |
| CustomAttribute6 | string | ✓ | ✓ | ✓ | Equal, Contains, BeginsWith, EndsWith |