Item Revision
Internal ID: itemrevision
Fields
| Internal ID | Type | nlapiSubmitField | Label | Required | Help |
| effectivedate |
date
|
false |
Effective Date |
true |
|
| externalid |
text
|
false |
ExternalId |
false |
|
| inactive |
checkbox
|
false |
Inactive |
false |
|
| item |
select
|
false |
Item |
true |
|
| memo |
textarea
|
false |
Memo |
false |
|
| name |
text
|
false |
Name |
true |
|
| obsoletedate |
date
|
false |
Obsolete Date |
false |
|
Search Filters
| Internal ID | Type | Label |
| effectivedate |
date |
Effective 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) |
| item |
select |
Item |
| name |
text |
Name |
| obsoletedate |
date |
Obsolete Date |
Search Columns
| Internal ID | Type | Label |
| effectivedate |
date |
Effective 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 |
| isinactive |
checkbox |
inactive |
| item |
select |
Item |
| memo |
text |
Memo |
| name |
text |
Name |
| obsoletedate |
date |
Obsolete Date |