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