Internal ID | Type | nlapiSubmitField | Label | Required | Help |
---|---|---|---|---|---|
expirationdate | date | Expiration Date | false | ||
externalid | text | false | ExternalId | false | |
inventorynumber | text | false | Serial/Lot Number | false | |
memo | textarea | false | Memo | false | Optionally enter a memo. Later, you can search for the text you enter in this field. |
status | text | false | Status | false | |
units | select | Stock Unit | false |
Internal ID | Type | Label | Required | Help |
---|---|---|---|---|
location | select | Location | false | Choose a location to associate with this item. Note: If you have not enabled the Multi-Location Inventory feature, the location you select is used for role restriction purposes only. Select New to enter a new location record. Go to Lists > Locations for details about existing location records. |
quantityavailable | float | Available | false | |
quantityintranist | float | In Transit | false | |
quantityonhand | float | On Hand | false | This field shows the quantity of this item you have on hand. |
quantityonorder | float | On Order | false | This field shows the quantity of this item you currently have on order with the vendor. |
Join ID | Join Description | Actual Join Name |
---|---|---|
user | User | Employee |
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 |
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 |