The Item Fields custom field is available for the Shipping Items table.
| Name | Type | Length | Precision | Scale | References | In | Description |
|---|---|---|---|---|---|---|---|
| by_per_item | NUMBER | 39 | 0 | Per item | |||
| by_total_amount | NUMBER | 39 | 0 | Percent of total | |||
| by_weight_amount | NUMBER | 39 | 0 | By weight amount | |||
| by_weight_unit_index | NUMBER | 39 | 0 | By weight unit index | |||
| date_last_modified | TIMESTAMP | Date last modified (GMT) | |||||
| default_unit_price | VARCHAR2 | 42 | Default unit price | ||||
| description | VARCHAR2 | 4000 | Description | ||||
| display_name | VARCHAR2 | 4000 | Display name/code | ||||
| flat_rate_amount | NUMBER | 39 | 0 | Flat rate amount | |||
| free_if_over_amount | NUMBER | 39 | 0 | Free if total order is over | |||
| free_if_overactive | VARCHAR2 | 3 | Free if overactive | ||||
| full_name | VARCHAR2 | 550 | Full name | ||||
| income_account_id | NUMBER | 39 | 0 | Income account | |||
| is_fedex_one_rate | VARCHAR2 | 3 | Whether FedEx One Rate shipping is used | ||||
| is_omit_packaging | VARCHAR2 | 3 | Whether packaging is omitted | ||||
| isinactive | VARCHAR2 | 3 | Ship item is inactive | ||||
| isonline | VARCHAR2 | 3 | Display in web site | ||||
| istaxable | VARCHAR2 | 3 | Taxable | ||||
| item_extid | VARCHAR2 | 255 | Item external ID | ||||
| item_id | NUMBER | 39 | 0 | Item ID | |||
| maximum_shipping_amount | NUMBER | 39 | 0 | Maximum shipping amount | |||
| minimum_shipping_amount | NUMBER | 39 | 0 | Minimum shipping amount | |||
| name | VARCHAR2 | 250 | Name | ||||
| parent_id | NUMBER | 39 | 0 | Subitem of | |||
| per_item_default_price | VARCHAR2 | 42 | Per item default price | ||||
| pref_purchase_tax_id | NUMBER | 39 | 0 | Preferred purchase tax ID | |||
| shipping_cost_function | VARCHAR2 | 32 | Shipping cost function | ||||
| shipping_rate | NUMBER | 39 | 0 | Shipping rate | |||
| tax_item_id | NUMBER | 39 | 0 | Tax item ID | |||
| use_maximum_ship_cost | VARCHAR2 | 3 | Use maximum shipping amount | ||||
| use_minimum_ship_cost | VARCHAR2 | 3 | Use minimum shipping amount | ||||
| vendor_id | NUMBER | 39 | 0 | Vendor ID |