Label |
ID |
Type |
UI Workbook |
SuiteScript / SuiteTalk REST Web Services |
Connect |
Accounting Books |
accountingbookdetail |
sublist |
Yes |
Yes |
Yes |
Allocation Price |
vsoeprice |
currency2 |
Yes |
Yes |
Yes |
Allocation Type |
vsoesopgroup |
select |
Yes |
Yes |
Yes |
Alternate Source Item |
alternatedemandsourceitem |
select |
Yes |
Yes |
Yes |
Amortization Period |
amortizationperiod |
integer |
Yes |
Yes |
Yes |
Amortization Template |
amortizationtemplate |
select |
Yes |
Yes |
Yes |
Asset Account |
assetaccount |
select |
Yes |
Yes |
Yes |
ATP Lead Time |
atpleadtime |
integer |
Yes |
Yes |
Yes |
ATP Method |
atpmethod |
select |
Yes |
Yes |
Yes |
Auto-Calculate |
autoleadtime |
checkbox |
Yes |
Yes |
Yes |
Auto-Calculate |
autopreferredstocklevel |
checkbox |
Yes |
Yes |
Yes |
Auto-Calculate |
autoreorderpoint |
checkbox |
Yes |
Yes |
Yes |
Auto-Expansion for Revenue Management |
autoexpandkitforrevenuemgmt |
checkbox |
Yes |
Yes |
Yes |
Available to Adv. Partners |
availabletopartners |
checkbox |
Yes |
Yes |
Yes |
Average Cost |
averagecost |
currency |
Yes |
Yes |
Yes |
Backward Consumption Days |
backwardconsumptiondays |
integer |
Yes |
Yes |
Yes |
Billing Schedule |
billingschedule |
select |
Yes |
Yes |
Yes |
Bin Numbers |
binnumbers |
sublist |
Yes |
Yes |
Yes |
Calculate Quantity Discounts |
overallquantitypricingtype |
select |
Yes |
Yes |
Yes |
Can be Fulfilled |
isfulfillable |
checkbox |
Yes |
Yes |
Yes |
Class |
class |
select |
Yes |
Yes |
Yes |
Consumption |
consumptionunit |
select |
Yes |
Yes |
Yes |
Copy from Sales Order |
copydescription |
checkbox |
Yes |
Yes |
Yes |
Correlated Items |
correlateditems |
sublist |
Yes |
Yes |
Yes |
Cost Category |
costcategory |
select |
Yes |
Yes |
Yes |
Cost Estimate Type |
costestimatetype |
select |
Yes |
Yes |
Yes |
Costing Method |
costingmethod |
select |
Yes |
Yes |
Yes |
Create Expense Plans On |
createexpenseplanson |
select |
Yes |
Yes |
Yes |
Create Job |
createjob |
checkbox |
Yes |
Yes |
Yes |
Create Revenue Plans On |
createrevenueplanson |
select |
Yes |
Yes |
Yes |
Customer Return Variance Account |
custreturnvarianceaccount |
select |
Yes |
Yes |
Yes |
Date Created |
createddate |
datetime |
Yes |
Yes |
Yes |
Days |
preferredstockleveldays |
float |
Yes |
Yes |
Yes |
Default as Delivered |
vsoedelivered |
checkbox |
Yes |
Yes |
Yes |
Deferral |
vsoedeferral |
select |
Yes |
Yes |
Yes |
Deferred Expense |
deferralaccount |
select |
Yes |
Yes |
Yes |
Deferred Revenue Account |
deferredrevenueaccount |
select |
Yes |
Yes |
Yes |
Demand Source |
demandsource |
select |
Yes |
Yes |
Yes |
Demand Time Fence |
demandtimefence |
integer |
Yes |
Yes |
Yes |
Department |
department |
select |
Yes |
Yes |
Yes |
Description |
description |
textarea |
Yes |
Yes |
Yes |
Detailed Description |
storedetaileddescription |
textarea |
Yes |
Yes |
Yes |
Direct Revenue Posting |
directrevenueposting |
checkbox |
Yes |
Yes |
Yes |
Display in Web Site |
isonline |
checkbox |
Yes |
Yes |
Yes |
Display Name/Code |
displayname |
text |
Yes |
Yes |
Yes |
Distribution Category |
distributioncategory |
select |
Yes |
Yes |
Yes |
Distribution Network |
distributionnetwork |
select |
Yes |
Yes |
Yes |
Don't Show Price |
dontshowprice |
checkbox |
Yes |
Yes |
Yes |
Dropship Expense Account |
dropshipexpenseaccount |
select |
Yes |
Yes |
Yes |
Drop Ship Item |
isdropshipitem |
checkbox |
Yes |
Yes |
Yes |
Effective BOM Control |
effectivebomcontrol |
select |
Yes |
Yes |
Yes |
Eligible For Contingent Revenue Handling |
contingentrevenuehandling |
checkbox |
Yes |
Yes |
Yes |
Enforce Minimum Internally |
enforceminqtyinternally |
checkbox |
Yes |
Yes |
Yes |
Estimated Demand Change |
demandmodifier |
percent |
Yes |
Yes |
Yes |
Exchange Rate Variance Account |
billexchratevarianceacct |
select |
Yes |
Yes |
Yes |
Exclude from Sitemap |
excludefromsitemap |
checkbox |
Yes |
Yes |
Yes |
Expense/COGS Account |
expenseaccount |
select |
Yes |
Yes |
Yes |
Expense Amortization Rule |
expenseamortizationrule |
select |
Yes |
Yes |
Yes |
External ID |
externalid |
text |
Yes |
Yes |
Yes |
Featured Description |
featureddescription |
textarea |
Yes |
Yes |
Yes |
Fixed Lot Size |
fixedlotsize |
posfloat |
Yes |
Yes |
Yes |
Foreign Currency Adjustment Account |
revreclassfxaccount |
select |
Yes |
Yes |
Yes |
Forward Consumption Days |
forwardconsumptiondays |
integer |
Yes |
Yes |
Yes |
Full Name |
fullname |
text |
Yes |
Yes |
Yes |
Gain/Loss Account |
gainlossaccount |
select |
Yes |
Yes |
Yes |
Generate Accruals |
generateaccruals |
checkbox |
Yes |
Yes |
Yes |
Google Base Product Feed |
froogleproductfeed |
checkbox |
Yes |
Yes |
Yes |
Handling Cost |
handlingcost |
currency |
Yes |
Yes |
Yes |
Hold Revenue Recognition |
deferrevrec |
checkbox |
Yes |
Yes |
Yes |
Inactive |
isinactive |
checkbox |
Yes |
Yes |
Yes |
Include Children |
includechildren |
checkbox |
Yes |
Yes |
Yes |
Income Account |
incomeaccount |
select |
Yes |
Yes |
Yes |
Intercompany Deferred Revenue Account |
intercodefrevaccount |
select |
Yes |
Yes |
Yes |
Intercompany Expense Account |
intercoexpenseaccount |
select |
Yes |
Yes |
Yes |
Intercompany Income Account |
intercoincomeaccount |
select |
Yes |
Yes |
Yes |
Internal ID |
id |
integer |
Yes |
Yes |
Yes |
Item Defined Cost |
costestimate |
currency |
Yes |
Yes |
Yes |
Item Display Image |
storedisplayimage |
select |
Yes |
Yes |
Yes |
Item Display Thumbnail |
storedisplaythumbnail |
select |
Yes |
Yes |
Yes |
Item Name/Number |
itemid |
text |
Yes |
Yes |
Yes |
Item Process Family |
itemprocessfamily |
select |
Yes |
Yes |
Yes |
Item Process Group |
itemprocessgroup |
select |
Yes |
Yes |
Yes |
Item Revenue Category |
itemrevenuecategory |
select |
Yes |
Yes |
Yes |
Item Weight |
weight |
float |
Yes |
Yes |
Yes |
Last Modified |
lastmodifieddate |
datetime |
Yes |
Yes |
Yes |
Last Purchase Price |
lastpurchaseprice |
currency |
Yes |
Yes |
Yes |
Lead Time |
leadtime |
integer |
Yes |
Yes |
Yes |
Location |
location |
select |
Yes |
Yes |
Yes |
Locations |
locations |
sublist |
Yes |
Yes |
Yes |
Lot Numbered |
islotitem |
checkbox |
Yes |
Yes |
Yes |
Lot Sizing Method |
supplylotsizingmethod |
select |
Yes |
Yes |
Yes |
Manufacturer |
manufacturer |
text |
Yes |
Yes |
Yes |
Manufacturer Country |
countryofmanufacture |
select |
Yes |
Yes |
Yes |
Manufacturer Part Number |
mpn |
text |
Yes |
Yes |
Yes |
Manufacturing Charge Item |
manufacturingchargeitem |
checkbox |
Yes |
Yes |
Yes |
Mark Sub-assemblies Phantom |
buildentireassembly |
checkbox |
Yes |
Yes |
Yes |
Match Bill To Receipt |
matchbilltoreceipt |
checkbox |
Yes |
Yes |
Yes |
Matrix Item Name Template |
matrixitemnametemplate |
textarea |
Yes |
Yes |
Yes |
Matrix Type |
matrixtype |
select |
Yes |
Yes |
Yes |
Maximum Order Qty |
maximumquantity |
posinteger |
Yes |
Yes |
Yes |
Maximum Variable Amount |
maxdonationamount |
currency2 |
Yes |
Yes |
Yes |
Members |
member |
sublist |
Yes |
Yes |
Yes |
Merchandise Hierarchy |
hierarchyversions |
sublist |
Yes |
Yes |
Yes |
Meta Tag HTML |
metataghtml |
textarea |
Yes |
Yes |
Yes |
Minimum Order Qty |
minimumquantity |
posinteger |
Yes |
Yes |
Yes |
NexTag Category |
nextagcategory |
text |
Yes |
Yes |
Yes |
NexTag Product Feed |
nextagproductfeed |
checkbox |
Yes |
Yes |
Yes |
-No label- |
preferredstocklevelunits |
text |
Yes |
Yes |
Yes |
-No label- |
reorderpointunits |
text |
Yes |
Yes |
Yes |
-No label- |
safetystocklevelunits |
text |
Yes |
Yes |
Yes |
No Price Message |
nopricemessage |
text |
Yes |
Yes |
Yes |
Out Of Stock Behavior |
outofstockbehavior |
select |
Yes |
Yes |
Yes |
Out Of Stock Message |
outofstockmessage |
textarea |
Yes |
Yes |
Yes |
Overhead Type |
overheadtype |
select |
Yes |
Yes |
Yes |
Package |
shippackage |
select |
Yes |
Yes |
Yes |
Page Title |
pagetitle |
textarea |
Yes |
Yes |
Yes |
Periods of Supply Increment |
periodiclotsizedays |
integer |
Yes |
Yes |
Yes |
Periods of Supply Type |
periodiclotsizetype |
select |
Yes |
Yes |
Yes |
Permit Discount |
vsoepermitdiscount |
select |
Yes |
Yes |
Yes |
Phantom |
isphantom |
checkbox |
Yes |
Yes |
Yes |
Planning Time Fence |
supplytimefence |
integer |
Yes |
Yes |
Yes |
Preferred Location |
preferredlocation |
select |
Yes |
Yes |
Yes |
Preferred Stock Level |
preferredstocklevel |
float |
Yes |
Yes |
Yes |
Preferred Vendor |
vendor |
select |
Yes |
Yes |
Yes |
Price |
rate |
currency2 |
Yes |
Yes |
Yes |
Price Including Tax |
rateincludingtax |
currency2 |
Yes |
Yes |
Yes |
Prices Include Tax |
pricesincludetax |
checkbox |
Yes |
Yes |
Yes |
Price Variance Account |
billpricevarianceacct |
select |
Yes |
Yes |
Yes |
Pricing |
price |
sublist |
Yes |
Yes |
Yes |
Pricing Group |
pricinggroup |
select |
Yes |
Yes |
Yes |
Print Items |
printitems |
checkbox |
Yes |
Yes |
Yes |
Production Price Variance Account |
prodpricevarianceacct |
select |
Yes |
Yes |
Yes |
Production Quantity Variance Account |
prodqtyvarianceacct |
select |
Yes |
Yes |
Yes |
Project Expense Type |
projectexpensetype |
select |
Yes |
Yes |
Yes |
Project Template |
projecttemplate |
select |
Yes |
Yes |
Yes |
Purchase Description |
purchasedescription |
textarea |
Yes |
Yes |
Yes |
Purchase Price |
cost |
currency2 |
Yes |
Yes |
Yes |
Purchase Price (Foreign Currency) |
fxcost |
currency2 |
Yes |
Yes |
Yes |
Purchase Price Variance Account |
purchasepricevarianceacct |
select |
Yes |
Yes |
Yes |
Purchase Unit |
purchaseunit |
select |
Yes |
Yes |
Yes |
Quantity Available |
quantityavailable |
float |
Yes |
Yes |
Yes |
Quantity Back Ordered |
quantitybackordered |
float |
Yes |
Yes |
Yes |
Quantity Committed |
quantitycommitted |
float |
Yes |
Yes |
Yes |
Quantity On Hand |
quantityonhand |
float |
Yes |
Yes |
Yes |
Quantity On Order |
quantityonorder |
float |
Yes |
Yes |
Yes |
Quantity Pricing Schedule |
quantitypricingschedule |
select |
Yes |
Yes |
Yes |
Quantity Variance Account |
billqtyvarianceacct |
select |
Yes |
Yes |
Yes |
Related Items |
presentationitem |
sublist |
Yes |
Yes |
Yes |
Related Items Description |
relateditemsdescription |
textarea |
Yes |
Yes |
Yes |
Reorder Multiple |
reordermultiple |
posinteger |
Yes |
Yes |
Yes |
Reorder Point |
reorderpoint |
float |
Yes |
Yes |
Yes |
Replenishment Method |
supplyreplenishmentmethod |
select |
Yes |
Yes |
Yes |
Reschedule In Days |
rescheduleindays |
integer |
Yes |
Yes |
Yes |
Reschedule Out Days |
rescheduleoutdays |
integer |
Yes |
Yes |
Yes |
Residual |
residual |
rate |
Yes |
Yes |
Yes |
Revenue Allocation Group |
revenueallocationgroup |
select |
Yes |
Yes |
Yes |
Revenue Recognition Rule |
revenuerecognitionrule |
select |
Yes |
Yes |
Yes |
Revenue Recognition Template |
revrecschedule |
select |
Yes |
Yes |
Yes |
Rev Rec Forecast Rule |
revrecforecastrule |
select |
Yes |
Yes |
Yes |
Rotation Type |
rotationtype |
select |
Yes |
Yes |
Yes |
Round Up Quantity as Component |
roundupascomponent |
checkbox |
Yes |
Yes |
Yes |
Safety Stock Level |
safetystocklevel |
float |
Yes |
Yes |
Yes |
Safety Stock Level Days |
safetystockleveldays |
integer |
Yes |
Yes |
Yes |
Sale Unit |
saleunit |
select |
Yes |
Yes |
Yes |
Scrap Account |
scrapacct |
select |
Yes |
Yes |
Yes |
Search Keywords |
searchkeywords |
textarea |
Yes |
Yes |
Yes |
Seasonal Demand |
seasonaldemand |
checkbox |
Yes |
Yes |
Yes |
Serialized |
isserialitem |
checkbox |
Yes |
Yes |
Yes |
Shipping Cost |
shippingcost |
currency |
Yes |
Yes |
Yes |
Ships Individually |
shipindividually |
checkbox |
Yes |
Yes |
Yes |
Shopping.com Category |
shoppingdotcomcategory |
text |
Yes |
Yes |
Yes |
Shopping Product Feed |
shoppingproductfeed |
checkbox |
Yes |
Yes |
Yes |
Shopzilla Category ID |
shopzillacategoryid |
integer |
Yes |
Yes |
Yes |
Shopzilla Product Feed |
shopzillaproductfeed |
checkbox |
Yes |
Yes |
Yes |
Show Default Amount |
showdefaultdonationamount |
checkbox |
Yes |
Yes |
Yes |
Site Categories |
sitecategory |
sublist |
Yes |
Yes |
Yes |
Sitemap Priority |
sitemappriority |
select |
Yes |
Yes |
Yes |
Special Order Item |
isspecialorderitem |
checkbox |
Yes |
Yes |
Yes |
Special Work Order Item |
isspecialworkorderitem |
checkbox |
Yes |
Yes |
Yes |
Stock Description |
stockdescription |
text |
Yes |
Yes |
Yes |
Stock Unit |
stockunit |
select |
Yes |
Yes |
Yes |
Store Description |
storedescription |
textarea |
Yes |
Yes |
Yes |
Store Display Name |
storedisplayname |
text |
Yes |
Yes |
Yes |
Subitem of |
parent |
select |
Yes |
Yes |
Yes |
Subsidiary |
subsidiary |
multiselect |
Yes |
Yes |
Yes |
Subtype |
subtype |
select |
Yes |
Yes |
Yes |
Supply Type |
supplytype |
select |
Yes |
Yes |
Yes |
Total Quantity On Hand |
totalquantityonhand |
float |
Yes |
Yes |
Yes |
Total Value |
totalvalue |
currency |
Yes |
Yes |
Yes |
Track Landed Cost |
tracklandedcost |
checkbox |
Yes |
Yes |
Yes |
Transfer Price |
transferprice |
currency2 |
Yes |
Yes |
Yes |
Translations |
translations |
sublist |
Yes |
Yes |
Yes |
Type |
itemtype |
select |
Yes |
Yes |
Yes |
Unbuild Variance Account |
unbuildvarianceaccount |
select |
Yes |
Yes |
Yes |
Units Type |
unitstype |
select |
Yes |
Yes |
Yes |
UPC Code |
upccode |
text |
Yes |
Yes |
Yes |
URL Component |
urlcomponent |
textarea |
Yes |
Yes |
Yes |
URL Component Alias |
urlcomponentaliases |
sublist |
Yes |
Yes |
Yes |
Use as Category Only |
parentonly |
checkbox |
Yes |
Yes |
Yes |
Use Component Yield |
usecomponentyield |
checkbox |
Yes |
Yes |
Yes |
Use Marginal Rates |
usemarginalrates |
checkbox |
Yes |
Yes |
Yes |
User Notes |
usernotes |
sublist |
Yes |
Yes |
Yes |
Variable Amount |
isdonationitem |
checkbox |
Yes |
Yes |
Yes |
Vendor Bill - Item Receipt Amount Tolerance |
receiptamount |
posfloat |
Yes |
Yes |
Yes |
Vendor Bill - Item Receipt Quantity Difference |
receiptquantitydiff |
posfloat |
Yes |
Yes |
Yes |
Vendor Bill - Item Receipt Quantity Tolerance |
receiptquantity |
posfloat |
Yes |
Yes |
Yes |
Vendor Bill - Purchase Order Amount Tolerance |
purchaseorderamount |
posfloat |
Yes |
Yes |
Yes |
Vendor Bill - Purchase Order Quantity Difference |
purchaseorderquantitydiff |
posfloat |
Yes |
Yes |
Yes |
Vendor Bill - Purchase Order Quantity Tolerance |
purchaseorderquantity |
posfloat |
Yes |
Yes |
Yes |
Vendor Name/Code |
vendorname |
text |
Yes |
Yes |
Yes |
Vendor Return Variance Account |
vendreturnvarianceaccount |
select |
Yes |
Yes |
Yes |
Vendors |
itemvendor |
sublist |
Yes |
Yes |
Yes |
Weight Unit |
weightunit |
select |
Yes |
Yes |
Yes |
Weight Units |
weightunits |
text |
Yes |
Yes |
Yes |
WIP Account |
wipacct |
select |
Yes |
Yes |
Yes |
WIP Variance Account |
wipvarianceacct |
select |
Yes |
Yes |
Yes |
Work Order Lead Time |
buildtime |
float |
Yes |
Yes |
Yes |
Yahoo Shopping Product Feed |
yahooproductfeed |
checkbox |
Yes |
Yes |
Yes |
Join |
Target Record |
UI Workbook |
SuiteScript / SuiteTalk REST Web Services |
Connect |
Members to Item Revision (itemRevision.id) |
members (itemmember, itemmember.effectiverevision) |
No |
Yes |
Yes |
Members to Item (item.id) |
members (itemmember, itemmember.item) |
No |
Yes |
Yes |
Members to Item Source (itemSource.key) |
members (itemmember, itemmember.itemsource) |
Yes |
Yes |
Yes |
Members to Item Revision (itemRevision.id) |
members (itemmember, itemmember.obsoleterevision) |
No |
Yes |
Yes |
Members to Type (vsoeDeferralType.key) |
members (itemmember, itemmember.vsoedeferral) |
Yes |
Yes |
Yes |
Members to Type (vsoeDiscountType.key) |
members (itemmember, itemmember.vsoepermitdiscount) |
Yes |
Yes |
Yes |
Related Items to Type (presentationItemType.key) |
related items (itempresentationitem, itempresentationitem.itemtype) |
Yes |
Yes |
Yes |
Item Quantity to Item (item.id) |
item quantity (itemquantity, itemquantity.item) |
No |
Yes |
Yes |
Bin Numbers to Item (item.id) |
bin numbers (itembinquantity, itembinquantity.item) |
No |
Yes |
Yes |
Correlated Items to Item (item.id) |
correlated items (itemcorrelateditem, itemcorrelateditem.item) |
No |
Yes |
Yes |
Item to Account (account.id) |
item (item, item.dropshipexpenseaccount) |
No |
Yes |
Yes |
Item to Expense Amortization Rule (expenseAmortizationRule.id) |
item (item, item.expenseamortizationrule) |
No |
Yes |
Yes |
Hierarchy Versions to Item (item.id) |
hierarchy versions (itemmerchandisehierarchynoninventorysaleitemversion, itemmerchandisehierarchynoninventorysaleitemversion.item) |
No |
Yes |
Yes |
Associated Images to Item (item.id) |
associated images (itemimage, itemimage.item) |
No |
Yes |
Yes |
Vendors to Item (item.id) |
vendors (itemvendor, itemvendor.item) |
No |
Yes |
Yes |
Members to Item (item.id) |
members (itemmember, itemmember.parentitem) |
No |
Yes |
Yes |
Item to Item (item.id) |
item (item, item.parent) |
No |
Yes |
Yes |
Related Items to Item (item.id) |
related items (itempresentationitem, itempresentationitem.superitem) |
No |
Yes |
Yes |
Levels to Item (item.id) |
levels (itemquantitypricingdiscount, itemquantitypricingdiscount.parentitem) |
No |
Yes |
Yes |
Levels to Item (item.id) |
levels (itemquantitypricinglevel, itemquantitypricinglevel.item) |
No |
Yes |
Yes |
Site Categories to Item (item.id) |
site categories (itemsitecategory, itemsitecategory.item) |
No |
Yes |
Yes |
Item to Supply Type (itemSupplyType.key) |
item (item, item.supplytype) |
Yes |
Yes |
Yes |
Translation to Item (item.id) |
translation (itemtranslation, itemtranslation.item) |
No |
Yes |
Yes |
URL Component Alias to Item (item.id) |
url component alias (itemurlcomponentaliases, itemurlcomponentaliases.item) |
No |
Yes |
Yes |