Inventory Number
Internal ID: inventorynumber
Search Joins
| Join ID | Join Description | Actual Join Name |
|---|
| user |
User |
Employee |
Search Filters
| Internal ID | Type | Label |
|---|
| expirationdate |
date |
Expiration Date |
| externalid |
select |
External ID |
| externalidstring |
text |
External ID (Text) |
| formuladate |
date |
Formula (Date) |
| formulanumeric |
float |
Formula (Numeric) |
| formulatext |
text |
Formula (Text) |
| internalid |
select |
Internal ID |
| internalidnumber |
integer |
Internal ID (Number) |
| inventorynumber |
text |
Number |
| isonhand |
checkbox |
Is On Hand |
| item |
select |
Item |
| location |
select |
Location |
| memo |
text |
Memo |
| quantityavailable |
float |
Availabile |
| quantityintransit |
float |
In Transit |
| quantityonhand |
float |
On Hand |
| quantityonorder |
float |
On Order |
Search Columns
| Internal ID | Type | Label |
|---|
| expirationdate |
date |
Expiration Date |
| externalid |
select |
External ID |
| formulacurrency |
currency |
Formula (Currency) |
| formuladate |
date |
Formula (Date) |
| formuladatetime |
datetime |
Formula (Date/Time) |
| formulanumeric |
float |
Formula (Numeric) |
| formulapercent |
percent |
Formula (Percent) |
| formulatext |
text |
Formula (Text) |
| internalid |
select |
Internal ID |
| inventorynumber |
select |
Number |
| isonhand |
checkbox |
Is On Hand |
| item |
select |
Item |
| location |
select |
Location |
| memo |
text |
Memo |
| quantityavailable |
float |
Available |
| quantityintransit |
float |
In Transit |
| quantityonhand |
float |
On Hand |
| quantityonorder |
float |
On Order |