invantive documentation
Invantive Support ForumsLog In / Sign Up

carrier: Odoo itgen_odoo_carrier

read only per partition

  • Catalog: Odoo
  • Schema: delivery
  • Label: itgen_odoo_carrier

Shipping Methods

Can only retrieve data.

Table Columns

The columns of the table carrier are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
active boolean Active
amount numeric Amount Amount of the order to benefit from a free shipping, expressed in the company currency
bpost_account_number varchar2 Bpost Account Number
bpost_default_package_type_id varchar2
bpost_default_package_type_id_label varchar2
bpost_delivery_nature varchar2 Bpost Delivery Nature
bpost_developer_password varchar2 Passphrase
bpost_domestic_deliver_type varchar2 Bpost Domestic Deliver Type
bpost_international_deliver_type varchar2 Bpost International Deliver Type
bpost_label_format varchar2 Bpost Label Format
bpost_label_stock_type varchar2 Bpost Label Stock Type
bpost_parcel_return_instructions varchar2 Bpost Parcel Return Instructions
bpost_saturday boolean Delivery on Saturday Allow deliveries on Saturday (extra charges apply)
bpost_shipment_type varchar2 Bpost Shipment Type
can_generate_return boolean Can Generate Return
can_publish boolean Can Publish
carrier_description varchar2 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 varchar2
company_id_label varchar2
country_ids varchar2
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
debug_logging boolean Debug logging Log requests in order to ease debugging
delivery_type varchar2 Provider
dhl_account_number varchar2 DHL Account Number
dhl_custom_data_request varchar2 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 varchar2
dhl_default_package_type_id_label varchar2
dhl_dutiable boolean Dutiable Material Check this if your package is dutiable.
dhl_duty_payment varchar2 Dhl Duty Payment
dhl_label_image_format varchar2 Label Image Format
dhl_label_template varchar2 Label Template
dhl_package_dimension_unit varchar2 Package Dimension Unit
dhl_package_weight_unit varchar2 Package Weight Unit
dhl_password varchar2 DHL Password
dhl_product_code varchar2 DHL Product
dhl_region_code varchar2 Region
dhl_SiteID varchar2 DHL SiteID
display_name varchar2 Display Name
easypost_default_package_type_id varchar2
easypost_default_package_type_id_label varchar2
easypost_default_service_id varchar2 If not set, the less expensive available service level will be chosen.
easypost_default_service_id_label varchar2 If not set, the less expensive available service level will be chosen.
easypost_delivery_type varchar2 Easypost Carrier Type
easypost_delivery_type_id varchar2 Easypost Carrier Type ID, technical for API request
easypost_insurance_fee_minimum numeric Insurance fee minimum (USD)
easypost_insurance_fee_rate numeric Insurance fee rate (USD)
easypost_label_file_type varchar2 Easypost Label File Type
easypost_production_api_key varchar2 Production API Key Enter your API production key from Easypost account
easypost_test_api_key varchar2 Test API Key Enter your API test key from Easypost account.
fedex_account_number varchar2 FedEx Account Number
fedex_default_package_type_id varchar2
fedex_default_package_type_id_label varchar2
fedex_developer_key varchar2 Developer Key
fedex_developer_password varchar2 Password
fedex_document_stock_type varchar2 Commercial Invoice Type
fedex_droppoff_type varchar2 Fedex Drop-Off Type
fedex_duty_payment varchar2 Fedex Duty Payment
fedex_extra_data_rate_request varchar2 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 varchar2 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 varchar2 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 varchar2 FEDEX Label File Type
fedex_label_stock_type varchar2 Label Type
fedex_locations_radius_unit varchar2 Locations Distance Unit
fedex_locations_radius_value int32 Locations Radius Maximum locations distance radius.
fedex_meter_number varchar2 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 varchar2 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 varchar2 Fedex Weight Unit
fixed_price numeric 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 varchar2 Integration Level Action while validating Delivery Orders
invoice_policy varchar2 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 numeric Margin This percentage will be added to the shipping price.
name varchar2 Delivery Method
price_rule_ids varchar2
prod_environment boolean Environment Set to True if your credentials are certified for production.
product_id varchar2
product_id_label varchar2
return_label_on_delivery boolean Generate Return Label The return label is automatically generated at the delivery.
sendcloud_default_package_type_id varchar2 Some carriers require package dimensions, you can define these in a package type that you set as default
sendcloud_default_package_type_id_label varchar2 Some carriers require package dimensions, you can define these in a package type that you set as default
sendcloud_public_key varchar2 Sendcloud Public Key Sendcloud API Integration Public key
sendcloud_return_id varchar2
sendcloud_return_id_label varchar2
sendcloud_secret_key varchar2 Sendcloud Secret Key Sendcloud API Integration Secret key
sendcloud_shipping_id varchar2
sendcloud_shipping_id_label varchar2
sendcloud_shipping_rules varchar2 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 varchar2
supports_shipping_insurance boolean Supports Shipping Insurance
ups_access_number varchar2 UPS Access Key
ups_bill_my_account boolean Bill My Account If checked, ecommerce users will be prompted their UPS account number and delivery fees will be charged on it.
ups_cod boolean Collect on Delivery This value added service enables UPS to collect the payment of the shipment from your customer.
ups_cod_funds_code varchar2 COD Funding Option
ups_default_package_type_id varchar2
ups_default_package_type_id_label varchar2
ups_default_service_type varchar2 UPS Service Type
ups_duty_payment varchar2 Ups Duty Payment
ups_label_file_type varchar2 UPS Label File Type
ups_package_dimension_unit varchar2 Package Size Unit
ups_package_weight_unit varchar2 Ups Package Weight Unit
ups_passwd varchar2 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 varchar2 UPS Shipper Number
ups_username varchar2 UPS Username
usps_account_validated boolean Account Validated Check this box if your account is validated by USPS
usps_container varchar2 Type of container
usps_content_type varchar2 Content Type
usps_custom_container_girth numeric Package Girth
usps_custom_container_height numeric Package Height
usps_custom_container_length numeric Package Length
usps_custom_container_width numeric Package Width
usps_delivery_nature varchar2 Delivery Nature
usps_domestic_regular_container varchar2 Type of USPS domestic regular container
usps_first_class_mail_type varchar2 USPS First Class Mail Type
usps_international_regular_container varchar2 Type of USPS International regular container
usps_intl_non_delivery_option varchar2 Non delivery option
usps_label_file_type varchar2 USPS Label File Type
usps_machinable boolean Machinable Please check on USPS website to ensure that your package is machinable.
usps_mail_type varchar2 USPS Mail Type
usps_redirect_partner_id varchar2
usps_redirect_partner_id_label varchar2
usps_service varchar2 USPS Service
usps_size_container varchar2 Usps Size Container
usps_username varchar2 USPS User ID
website_description varchar2 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 varchar2 Restrict publishing to this website.
website_id_label varchar2 Restrict publishing to this website.
website_published boolean Visible on current website
website_url varchar2 Website URL The full URL to access the document through the website.
write_date datetime Last Updated on
write_uid varchar2
write_uid_label varchar2
zip_prefix_ids varchar2 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')

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: