| Name | Description | Type | Additional information |
|---|---|---|---|
| AssetId | integer |
None. |
|
| AssetDescription | string |
None. |
|
| AssetTypeId | integer |
None. |
|
| AssetType | string |
None. |
|
| CategoryId | integer |
None. |
|
| ItemBaseUomId | integer |
None. |
|
| BaseUomAbbreviation | string |
None. |
|
| ItemOrderUomId | integer |
None. |
|
| OrderUomAbbreviation | string |
None. |
|
| LocationId | integer |
None. |
|
| SiteId | integer |
None. |
|
| ContainerId | integer |
None. |
|
| ContainerTag | string |
None. |
|
| Cost | decimal number |
None. |
|
| UniqueRecordIdentitifier | string |
None. |
|
| ResultCode | string |
None. |
|
| OrderNumber | string |
None. |
|
| TrackbyChildContainerId |
The globally unique tag which identiies the child container. In contrast, the value specified by ImmediateParentContainerId could be duplicated since a tracked parent container (ImmediateParentContainerId) can have multiple inventory items and/or multiple nested child container identifiers. When a receive or add transaction is performed, and the total inventory quantity of a container id exceeds 1, an error will occur to indicate duplicate container identifier. |
string |
None. |
| TrackbySerialNumber | string |
None. |
|
| TrackbyLot | string |
None. |
|
| TrackbyDateCode | string |
None. |
|
| TrackbyCustom1 | string |
None. |
|
| TrackbyCustom2 | string |
None. |
|
| TrackbyCustom3 | string |
None. |
|
| TrackbyCustom4 | string |
None. |
|
| TrackbyCustom5 | string |
None. |
|
| TrackbyCustom6 | string |
None. |
|
| ItemNumber | string |
None. |
|
| ImmediateParentSiteName | string |
None. |
|
| ImmediateParentLocationCode | string |
None. |
|
| ImmediateParentContainerId | string |
None. |
|
| OrderId | integer |
None. |
|
| OrderTypeId | integer |
None. |
|
| OrderLineId | integer |
None. |
|
| LineTrackedItemSiteId | integer |
None. |
|
| LineTrackedItemLocationId | integer |
None. |
|
| LineTrackedItemContainerId | integer |
None. |
|
| OrderLineQuantityRequested |
from the order line |
decimal number |
None. |
| OrderLineQuantityCompleted |
from the order line |
decimal number |
None. |
| OrderLineOverUnderRequestQtyDelta |
(sum of trackby quantities) MINUS the order line (OrderLineQuantityRequested) if negative that means we have an under-receive potential if positive that means we have a potential over-receive potential eg: SumQuantityRequestedOLTI - OrderLineQuantityRequested eg: |
decimal number |
None. |
| RecordCountOLTI |
sum of all distinct trackby quantity value records |
integer |
None. |
| SumQuantityRequestedOLTI | decimal number |
None. |
|
| SumQuantityCompletedOLTI | decimal number |
None. |
|
| LineTrackedItemLocationQuantityRequested |
LineTrackedItemLocationQuantityRequested LineTrackedItemLocationQuantityComplete Trackby detail quantity. For example track by serial # or License Plate Number should have max qty = 1 |
decimal number |
None. |
| LineTrackedItemLocationQuantityComplete |
Trackby detail quantity. For example track by serial # or License Plate Number should have max qty = 1 Transactions will NOT allow receive of QTY more than 1 since this violates singularity enforcement rules |
decimal number |
None. |
| InternalIdentifiers | string |
None. |
|
| Hierarchy | Collection of string |
None. |