shipitem
Stores information about items that are eligible for shipping, including their attributes, classifications, and associated costs.
Columns
| Name | Type | References | Description |
| id [KEY] | Integer | Unique internal identifier for the shipping item. | |
| account | String | The account used for shipping-related transactions. | |
| accounthandling | String | The account used for handling fee transactions. | |
| costbasis | String | The base rate used for calculating shipping costs. | |
| countries | String | List of countries where this shipping item is available. | |
| description | String | Detailed information or notes about the shipping item. | |
| discountrate | Double | The rate at which a discount is applied to the shipping cost. | |
| displayname | String | The name or code used to identify the shipping item. | |
| doiftotal | Boolean | Specifies whether website visibility is limited by the total order amount. | |
| doiftotalamt | Decimal | The minimum order amount required for visibility on the website. | |
| doiftotaloperator | String | The criteria type used for website visibility based on total. | |
| doifweightamt | Double | The minimum weight required for website visibility. | |
| doifweightoperator | String | The criteria type used for website visibility based on weight. | |
| doifweightunit | String | The unit of measure (UOM) for weight visibility settings. | |
| excludecountries | Boolean | Specifies whether the shipping item is not available for specific countries. | |
| excludesites | Boolean | Specifies whether the shipping item is not available for specific sites. | |
| externalid | String | An external identifier that links to other systems or data. | |
| fedexonerate | Boolean | Specifies whether FedEx One Rate® pricing applies. | |
| freeifordertotalisoveramount | Decimal | Specifies the order total over which shipping is free. | |
| handlingaspercentageoftotal | Double | Handling fee as a percentage of the total order cost. | |
| handlingbyweightamount | Decimal | Handling fee calculated based on the total weight of the order. | |
| handlingbyweightperquantity | Double | Handling fee rate per unit weight. | |
| handlingbyweightperunit | String | UOM for the handling fee by weight. | |
| handlingcost | String | Base rate used for calculating handling costs. | |
| handlingflatrateamount | Decimal | Flat fee applied to the handling cost regardless of weight or quantity. | |
| handlingperitemamount | Decimal | Handling fee calculated per item in the order. | |
| handlingtablechargeby | String | The type of table used for calculating handling rates. | |
| handlingtableuom | String | UOM for handling rate calculations. | |
| hasmaximumshippingcost | Boolean | Specifies whether a maximum limit on shipping cost is set. | |
| hasminimumshippingcost | Boolean | Specifies whether a minimum limit on shipping cost is set. | |
| integrationservicecode | String | Code used for integrating shipping label generation. | |
| invt_dispname | String | Name displayed on the website or interface. | |
| isfreeifordertotalisover | Boolean | Specifies whether shipping is free when the order total exceeds a threshold. | |
| ishandlingbyweightbracketed | Boolean | Specifies whether the handling rate is calculated in brackets based on weight. | |
| isinactive | Boolean | Specifies whether the shipping item is currently inactive or disabled. | |
| isonline | Boolean | Specifies whether the shipping item is available on the website. | |
| isshippingbyweightbracketed | Boolean | Specifies whether the shipping rate is calculated in brackets based on weight. | |
| itemid | String | Name assigned to the shipping item for identification. | |
| maximumshippingcost | Decimal | The highest allowable shipping charge. | |
| minimumshippingcost | Decimal | The lowest allowable shipping charge. | |
| needsallfreeshippingitems | Boolean | Specifies whether all items must be ordered for the shipping item to apply. | |
| omitpackaging | Boolean | Specifies whether packaging costs are omitted. | |
| returnservicecode | String | Code used for integrating return label generation. | |
| servicecode | String | Code used to identify the shipping service provider. | |
| shippingaspercentageoftotal | Double | Shipping fee as a percentage of the total order cost. | |
| shippingbyweightamount | Decimal | Shipping fee calculated based on the total weight of the order. | |
| shippingbyweightperquantity | Double | Shipping fee rate per unit weight. | |
| shippingbyweightperunit | String | UOM for the shipping fee by weight. | |
| shippingflatrateamount | Decimal | Flat fee applied to the shipping cost regardless of weight or quantity. | |
| shippingperitemamount | Decimal | Shipping fee calculated per item in the order. | |
| shippingtablechargeby | String | The type of table used for calculating shipping rates. | |
| shippingtableuom | String | UOM for shipping rate calculations. | |
| site | String | Sites to which this shipping item is restricted. | |
| states | String | List of states where this shipping item is available. | |
| subsidiary | String | Associated subsidiaries that use this shipping item. |