Shipping Item

shipitem

Fields

Label ID Type UI Workbook SuiteScript / SuiteTalk REST Web Services Connect
Account (Handling) accounthandling select Yes Yes Yes
Account (Shipping) account select Yes Yes Yes
All items must be purchased needsallfreeshippingitems checkbox Yes Yes Yes
Countries countries multiselect Yes Yes Yes
Description description textarea Yes Yes Yes
Discount Rate discountrate float Yes Yes Yes
Display in Web Site isonline checkbox Yes Yes Yes
Display Name invt_dispname text Yes Yes Yes
Display Name/Code displayname text Yes Yes Yes
Excluded For Countries excludecountries checkbox Yes Yes Yes
Excluded For Sites excludesites checkbox Yes Yes Yes
ExternalId externalid text Yes Yes Yes
FedEx One RateĀ® fedexonerate checkbox Yes Yes Yes
Free If Total Over Amount freeifordertotalisoveramount currency Yes Yes Yes
Free Shipping Items items sublist Yes Yes Yes
Handling Flat Rate handlingflatrateamount currency Yes Yes Yes
Handling Rate handlingcost select Yes Yes Yes
Handling Rate As Percent of Total handlingaspercentageoftotal percent Yes Yes Yes
Handling Rate By Item handlingperitemamount currency Yes Yes Yes
Handling Rate By Weight handlingbyweightamount currency Yes Yes Yes
Handling Rate By Weight Bracketed ishandlingbyweightbracketed checkbox Yes Yes Yes
Handling Rate By Weight Per handlingbyweightperquantity float Yes Yes Yes
Handling Rate By Weight Unit handlingbyweightperunit select Yes Yes Yes
Handling Rate Table Type handlingtablechargeby select Yes Yes Yes
Handling Rate Table Unit handlingtableuom select Yes Yes Yes
Handling Table handlingtable sublist Yes Yes Yes
Has Maximum Shipping Cost hasmaximumshippingcost checkbox Yes Yes Yes
Has Minimum Shipping Cost hasminimumshippingcost checkbox Yes Yes Yes
Inactive isinactive checkbox Yes Yes Yes
Internal ID id integer Yes Yes Yes
Is Free If Total Over isfreeifordertotalisover checkbox Yes Yes Yes
Limit To Sites site multiselect Yes Yes Yes
Maximum Shipping Cost maximumshippingcost currency Yes Yes Yes
Minimum Shipping Cost minimumshippingcost currency Yes Yes Yes
Omit packaging omitpackaging checkbox Yes Yes Yes
Return Label Integration returnservicecode select Yes Yes Yes
Service ratingserviceselect select Yes Yes Yes
Service Group ratingservicegroupselect select Yes Yes Yes
Ship Name itemid text Yes Yes Yes
Shipper Service Code servicecode select Yes Yes Yes
Shipping Flat Rate shippingflatrateamount currency Yes Yes Yes
Shipping Items shipmethodrulerelations sublist Yes Yes Yes
Shipping Label Integration integrationservicecode select Yes Yes Yes
Shipping Partner ratingpluginselect select Yes Yes Yes
Shipping Partner Label labelpluginselect select Yes Yes Yes
Shipping Partner Label Registration labelregselect select Yes Yes Yes
Shipping Partner Label Service labelserviceselect select Yes Yes Yes
Shipping Partner Label Service Group labelservicegroupselect select Yes Yes Yes
Shipping Partner Rate Registration ratingregselect select Yes Yes Yes
Shipping Partner Return Label Registration returnlabelregselect select Yes Yes Yes
Shipping Partner Return Label Service returnlabelserviceselect select Yes Yes Yes
Shipping Rate costbasis select Yes Yes Yes
Shipping Rate As Percent of Total shippingaspercentageoftotal percent Yes Yes Yes
Shipping Rate By Item shippingperitemamount currency Yes Yes Yes
Shipping Rate By Weight shippingbyweightamount currency Yes Yes Yes
Shipping Rate By Weight Bracketed isshippingbyweightbracketed checkbox Yes Yes Yes
Shipping Rate By Weight Per shippingbyweightperquantity float Yes Yes Yes
Shipping Rate By Weight Unit shippingbyweightperunit select Yes Yes Yes
Shipping Rate Table Type shippingtablechargeby select Yes Yes Yes
Shipping Rate Table Unit shippingtableuom select Yes Yes Yes
Shipping Table shippingtable sublist Yes Yes Yes
States states multiselect Yes Yes Yes
Subsidiaries subsidiary select Yes Yes Yes
Translation translations sublist Yes Yes Yes
Web Site Visibility By Total Limit doiftotalamt currency Yes Yes Yes
Web Site Visibility By Total Type doiftotaloperator select Yes Yes Yes
Web Site Visibility By Weight Limit doifweightamt float Yes Yes Yes
Web Site Visibility By Weight Type doifweightoperator select Yes Yes Yes
Web Site Visibility By Weight Unit doifweightunit select Yes Yes Yes
Web Site Visibility Limited by Total doiftotal checkbox Yes Yes Yes
Web Site Visibility Limited by Weight doifweight checkbox Yes Yes Yes

Joins

Join Target Record UI Workbook SuiteScript / SuiteTalk REST Web Services Connect
Handling Rate to Shipping Item (ShipItem.id) handling rate (shipitemhandlingrate, shipitemhandlingrate.shipitem) No Yes Yes
Free Shipping Items to Shipping Item (ShipItem.id) free shipping items (shipitemfreeshippingitem, shipitemfreeshippingitem.shipitem) No Yes Yes
Shipping Items to Shipping Item (ShipItem.id) shipping items (shippingmethodrulerelation, shippingmethodrulerelation.parent) No Yes Yes
Shipping Rate to Shipping Item (ShipItem.id) shipping rate (shipitemshippingrate, shipitemshippingrate.shipitem) No Yes Yes
Shipping Item to Item unit (itemUnit.key) shipping item (shipitem, shipitem.shippingtableuom) Yes Yes Yes
Translation to Shipping Item (ShipItem.id) translation (shipitemtranslation, shipitemtranslation.shipitem) No Yes Yes