Please enable JavaScript to view this site.

Made in EU
Odoo Forums

Navigation: Schema: delivery > Tables

carrier

Shipping Methods

Catalog: Odoo

Schema: delivery

The data in this table is partitioned per value of the column.

This is a read-only table. The Odoo API may not support changing the data or the Invantive SQL driver for Odoo does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Odoo API.

Table Columns

The columns of the table carrier are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

active

boolean

Active

 

amount

decimal

Amount

Amount of the order to benefit from a free shipping, expressed in the company currency

bpost_account_number

string

Bpost Account Number

 

bpost_default_package_type_id_label

string

 

 

bpost_default_package_type_id

string

 

 

bpost_delivery_nature

string

Bpost Delivery Nature

 

bpost_developer_password

string

Passphrase

 

bpost_domestic_deliver_type

string

Bpost Domestic Deliver Type

 

bpost_international_deliver_type

string

Bpost International Deliver Type

 

bpost_label_format

string

Bpost Label Format

 

bpost_label_stock_type

string

Bpost Label Stock Type

 

bpost_parcel_return_instructions

string

Bpost Parcel Return Instructions

 

bpost_saturday

boolean

Delivery on Saturday

Allow deliveries on Saturday (extra charges apply)

bpost_shipment_type

string

Bpost Shipment Type

 

can_generate_return

boolean

Can Generate Return

 

can_publish

boolean

Can Publish

 

carrier_description

string

Carrier Description

A description of the delivery method that you want to communicate to your customers on the Sales Order and sales confirmation email.E.g. instructions for customers to follow.

company_id_label

string

 

 

company_id

string

 

 

country_ids

string

 

 

create_date

datetime

Created on

 

create_uid_label

string

 

 

create_uid

string

 

 

debug_logging

boolean

Debug logging

Log requests in order to ease debugging

delivery_type

string

Provider

 

dhl_account_number

string

DHL Account Number

 

dhl_custom_data_request

string

Custom data for DHL requests,

The custom data in DHL is organized like the inside of a json file.There are 3 possible keys: 'rate', 'ship', 'return', to which you can add your custom data.More info on https://xmlportal.dhl.com/

dhl_default_package_type_id_label

string

 

 

dhl_default_package_type_id

string

 

 

dhl_dutiable

boolean

Dutiable Material

Check this if your package is dutiable.

dhl_duty_payment

string

Dhl Duty Payment

 

dhl_label_image_format

string

Label Image Format

 

dhl_label_template

string

Label Template

 

dhl_package_dimension_unit

string

Package Dimension Unit

 

dhl_package_weight_unit

string

Package Weight Unit

 

dhl_password

string

DHL Password

 

dhl_product_code

string

DHL Product

 

dhl_region_code

string

Region

 

dhl_SiteID

string

DHL SiteID

 

display_name

string

Display Name

 

easypost_default_package_type_id_label

string

 

 

easypost_default_package_type_id

string

 

 

easypost_default_service_id_label

string

 

If not set, the less expensive available service level will be chosen.

easypost_default_service_id

string

 

If not set, the less expensive available service level will be chosen.

easypost_delivery_type_id

string

Easypost Carrier Type ID, technical for API request

 

easypost_delivery_type

string

Easypost Carrier Type

 

easypost_insurance_fee_minimum

decimal

Insurance fee minimum (USD)

 

easypost_insurance_fee_rate

decimal

Insurance fee rate (USD)

 

easypost_label_file_type

string

Easypost Label File Type

 

easypost_production_api_key

string

Production API Key

Enter your API production key from Easypost account

easypost_test_api_key

string

Test API Key

Enter your API test key from Easypost account.

fedex_account_number

string

FedEx Account Number

 

fedex_default_package_type_id_label

string

 

 

fedex_default_package_type_id

string

 

 

fedex_developer_key

string

Developer Key

 

fedex_developer_password

string

Password

 

fedex_document_stock_type

string

Commercial Invoice Type

 

fedex_droppoff_type

string

Fedex Drop-Off Type

 

fedex_duty_payment

string

Fedex Duty Payment

 

fedex_extra_data_rate_request

string

Extra data for rate

The extra data in FedEx is organized like the inside of a json file.This functionality is advanced/technical and should only be used if you know what you are doing.Example of valid value: ```"ShipmentDetails": {"Pieces": {"Piece": {"AdditionalInformation": "extra info"}}}```With the above example, the AdditionalInformation of each piece will be updated.More info on https://www.fedex.com/en-us/developer/web-services/process.html#documentation

fedex_extra_data_return_request

string

Extra data for return

The extra data in FedEx is organized like the inside of a json file.This functionality is advanced/technical and should only be used if you know what you are doing.Example of valid value: ```"ShipmentDetails": {"Pieces": {"Piece": {"AdditionalInformation": "extra info"}}}```With the above example, the AdditionalInformation of each piece will be updated.More info on https://www.fedex.com/en-us/developer/web-services/process.html#documentation

fedex_extra_data_ship_request

string

Extra data for ship

The extra data in FedEx is organized like the inside of a json file.This functionality is advanced/technical and should only be used if you know what you are doing.Example of valid value: ```"ShipmentDetails": {"Pieces": {"Piece": {"AdditionalInformation": "extra info"}}}```With the above example, the AdditionalInformation of each piece will be updated.More info on https://www.fedex.com/en-us/developer/web-services/process.html#documentation

fedex_label_file_type

string

FEDEX Label File Type

 

fedex_label_stock_type

string

Label Type

 

fedex_locations_radius_unit

string

Locations Distance Unit

 

fedex_locations_radius_value

int32

Locations Radius

Maximum locations distance radius.

fedex_meter_number

string

Meter Number

 

fedex_saturday_delivery

boolean

FedEx Saturday Delivery

Special service:Saturday Delivery, can be requested on following days.Thursday:1.FEDEX_2_DAY.Friday:1.PRIORITY_OVERNIGHT.2.FIRST_OVERNIGHT.3.INTERNATIONAL_PRIORITY.(To Select Countries)

fedex_service_type

string

Fedex Service Type

 

fedex_use_locations

boolean

Use Fedex Locations

Allows the ecommerce user to choose a pick-up point as delivery address.

fedex_weight_unit

string

Fedex Weight Unit

 

fixed_price

decimal

Fixed Price

 

free_over

boolean

Free if order amount is above

If the order total amount (shipping excluded) is above or equal to this value, the customer benefits from a free shipping

get_return_label_from_portal

boolean

Return Label Accessible from Customer Portal

The return label can be downloaded by the customer from the customer portal.

id

int32

ID

 

integration_level

string

Integration Level

Action while validating Delivery Orders

invoice_policy

string

Invoicing Policy

Estimated Cost: the customer will be invoiced the estimated cost of the shipping.Real Cost: the customer will be invoiced the real cost of the shipping, the cost of the shipping will be updated on the SO after the delivery.

is_published

boolean

Is Published

 

margin

decimal

Margin

This percentage will be added to the shipping price.

name

string

Delivery Method

 

price_rule_ids

string

 

 

prod_environment

boolean

Environment

Set to True if your credentials are certified for production.

product_id_label

string

 

 

product_id

string

 

 

return_label_on_delivery

boolean

Generate Return Label

The return label is automatically generated at the delivery.

sendcloud_default_package_type_id_label

string

 

Some carriers require package dimensions, you can define these in a package type that you set as default

sendcloud_default_package_type_id

string

 

Some carriers require package dimensions, you can define these in a package type that you set as default

sendcloud_public_key

string

Sendcloud Public Key

Sendcloud API Integration Public key

sendcloud_return_id_label

string

 

 

sendcloud_return_id

string

 

 

sendcloud_secret_key

string

Sendcloud Secret Key

Sendcloud API Integration Secret key

sendcloud_shipping_id_label

string

 

 

sendcloud_shipping_id

string

 

 

sendcloud_shipping_rules

string

Use Sendcloud shipping rules

Depending your Sendcloud account type, through rules you can define the shipping method to use depending on different conditions like destination, weight, value, etc. Rules can override shipping product selected in odoo

sequence

int32

Sequence

Determine the display order

shipping_insurance

int32

Insurance Percentage

Shipping insurance is a service which may reimburse senders whose parcels are lost, stolen, and/or damaged in transit.

state_ids

string

 

 

supports_shipping_insurance

boolean

Supports Shipping Insurance

 

ups_access_number

string

UPS Access Key

 

ups_bill_my_account

boolean

Bill My Account

If checked, ecommerce users will be prompted their UPS account numberand delivery fees will be charged on it.

ups_cod_funds_code

string

COD Funding Option

 

ups_cod

boolean

Collect on Delivery

This value added service enables UPS to collect the payment of the shipment from your customer.

ups_default_package_type_id_label

string

 

 

ups_default_package_type_id

string

 

 

ups_default_service_type

string

UPS Service Type

 

ups_duty_payment

string

Ups Duty Payment

 

ups_label_file_type

string

UPS Label File Type

 

ups_package_dimension_unit

string

Package Size Unit

 

ups_package_weight_unit

string

Ups Package Weight Unit

 

ups_passwd

string

UPS Password

 

ups_saturday_delivery

boolean

UPS Saturday Delivery

This value added service will allow you to ship the package on saturday also.

ups_shipper_number

string

UPS Shipper Number

 

ups_username

string

UPS Username

 

usps_account_validated

boolean

Account Validated

Check this box if your account is validated by USPS

usps_container

string

Type of container

 

usps_content_type

string

Content Type

 

usps_custom_container_girth

decimal

Package Girth

 

usps_custom_container_height

decimal

Package Height

 

usps_custom_container_length

decimal

Package Length

 

usps_custom_container_width

decimal

Package Width

 

usps_delivery_nature

string

Delivery Nature

 

usps_domestic_regular_container

string

Type of USPS domestic regular container

 

usps_first_class_mail_type

string

USPS First Class Mail Type

 

usps_international_regular_container

string

Type of USPS International regular container

 

usps_intl_non_delivery_option

string

Non delivery option

 

usps_label_file_type

string

USPS Label File Type

 

usps_machinable

boolean

Machinable

Please check on USPS website to ensure that your package is machinable.

usps_mail_type

string

USPS Mail Type

 

usps_redirect_partner_id_label

string

 

 

usps_redirect_partner_id

string

 

 

usps_service

string

USPS Service

 

usps_size_container

string

Usps Size Container

 

usps_username

string

USPS User ID

 

website_description

string

Description for Online Quotations

A description of the Product that you want to communicate to your customers. This description will be copied to every Sales Order, Delivery Order and Customer Invoice/Credit Note

website_id_label

string

 

Restrict publishing to this website.

website_id

string

 

Restrict publishing to this website.

website_published

boolean

Visible on current website

 

website_url

string

Website URL

The full URL to access the document through the website.

write_date

datetime

Last Updated on

 

write_uid_label

string

 

 

write_uid

string

 

 

zip_prefix_ids

string

 

Prefixes of zip codes that this carrier applies to. Note that regular expressions can be used to support countries with varying zip code lengths, i.e. '$' can be added to end of prefix to match the exact zip (e.g. '100$' will only match '100' and not '1000')

 

01-03-2023 15:29 Version 22.1.135-BETA+3826

X

Important Safety and Usage Information

Intended Use and Limitations: This software, developed by Invantive, is designed to support a variety of business and information technology data processing functions, such as accounting, financial reporting an sales reporting. It is important to note that this software is not designed, tested, or approved for use in environments where malfunction or failure could lead to life-threatening situations or severe physical or environmental damage. This includes, but is not limited to:

  • Nuclear facilities: The software should not be used for operations or functions related to the control, maintenance, or operation of nuclear facilities.
  • Defense and Military Applications: This software is not suitable for use in defense-related applications, including but not limited to weaponry control, military strategy planning, or any other aspects of national defense.
  • Aviation: The software is not intended for use in the operation, navigation, or communication systems of any aircraft or air traffic control environments.
  • Healthcare and Medicine Production: This software should not be utilized for medical device operation, patient data analysis for critical health decisions, pharmaceutical production, or medical research where its failure or malfunction could impact patient health.
  • Chemical and Hazardous Material Handling: This software is not intended for the management, control, or operational aspects of chemical plants or hazardous material handling facilities. Any malfunction in software used in these settings could result in dangerous chemical spills, explosions, or environmental disasters.
  • Transportation and Traffic Control Systems: The software should not be used for the control, operation, or management of transportation systems, including railway signal controls, subway systems, or traffic light management. Malfunctions in such critical systems could lead to severe accidents and endanger public safety.
  • Energy Grid and Utility Control Systems: This software is not designed for the control or operation of energy grid systems, including electrical substations, renewable energy control systems, or water utility control systems. The failure of software in these areas could lead to significant power outages, water supply disruptions, or other public utility failures, potentially endangering communities and causing extensive damage.
  • Other High-Risk Environments: Any other critical infrastructure and environments where a failure of the software could result in significant harm to individuals or the environment.

User Responsibility: Users must ensure that they understand the intended use of the software and refrain from deploying it in any setting that falls outside of its designed purpose. It is the responsibility of the user to assess the suitability of the software for their intended application, especially in any scenarios that might pose a risk to life, health, or the environment.

Disclaimer of Liability: Invantive disclaims any responsibility for damage, injury, or legal consequences resulting from the use or misuse of this software in prohibited or unintended applications.

  
Disclaimer