JDBC Driver for NetSuite

Build 22.0.8462

shipitem

The shipitem table.

Columns

Name Type References Description
id [KEY] Integer Internal ID
account String Account (Shipping)
accounthandling String Account (Handling)
costbasis String Shipping Rate
countries String Countries
description String Description
discountrate Double Discount Rate
displayname String Display Name/Code
doiftotal Boolean Web Site Visibility Limited by Total
doiftotalamt Decimal Web Site Visibility By Total Limit
doiftotaloperator String Web Site Visibility By Total Type
doifweightamt Double Web Site Visibility By Weight Limit
doifweightoperator String Web Site Visibility By Weight Type
doifweightunit String Web Site Visibility By Weight Unit
excludecountries Boolean Excluded For Countries
excludesites Boolean Excluded For Sites
externalid String ExternalId
fedexonerate Boolean FedEx One RateĀ®
freeifordertotalisoveramount Decimal Free If Total Over Amount
handlingaspercentageoftotal Double Handling Rate As Percent of Total
handlingbyweightamount Decimal Handling Rate By Weight
handlingbyweightperquantity Double Handling Rate By Weight Per
handlingbyweightperunit String Handling Rate By Weight Unit
handlingcost String Handling Rate
handlingflatrateamount Decimal Handling Flat Rate
handlingperitemamount Decimal Handling Rate By Item
handlingtablechargeby String Handling Rate Table Type
handlingtableuom String Handling Rate Table Unit
hasmaximumshippingcost Boolean Has Maximum Shipping Cost
hasminimumshippingcost Boolean Has Minimum Shipping Cost
integrationservicecode String Shipping Label Integration
invt_dispname String Display Name
isfreeifordertotalisover Boolean Is Free If Total Over
ishandlingbyweightbracketed Boolean Handling Rate By Weight Bracketed
isinactive Boolean Inactive
isonline Boolean Display in Web Site
isshippingbyweightbracketed Boolean Shipping Rate By Weight Bracketed
itemid String Ship Name
maximumshippingcost Decimal Maximum Shipping Cost
minimumshippingcost Decimal Minimum Shipping Cost
needsallfreeshippingitems Boolean All items must be purchased
omitpackaging Boolean Omit packaging
returnservicecode String Return Label Integration
servicecode String Shipper Service Code
shippingaspercentageoftotal Double Shipping Rate As Percent of Total
shippingbyweightamount Decimal Shipping Rate By Weight
shippingbyweightperquantity Double Shipping Rate By Weight Per
shippingbyweightperunit String Shipping Rate By Weight Unit
shippingflatrateamount Decimal Shipping Flat Rate
shippingperitemamount Decimal Shipping Rate By Item
shippingtablechargeby String Shipping Rate Table Type
shippingtableuom String Shipping Rate Table Unit
site String Limit To Sites
states String States
subsidiary String Subsidiaries

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462