Magento API Reference
The public API procedures may call the internal procedures which should not be used directly as they can be changed without any explicit notification in the newer versions of the connector. Internal procedures can be recognized by the prefix internal_
in their names. Public API procedures do not have such prefix in their names.
Customers
Customers
Parameter
<customer_id> (optional): Return single customer, rather than list
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
<label> (optional): Multi-tenancy label
Attribute | Type | Description |
---|---|---|
id | integer | Customer Id |
group_id | integer | Group Id |
default_billing | string | Default billing |
default_shipping | string | Default shipping |
confirmation | string | Confirmation |
created_at | timestamp | Created at |
updated_at | timestamp | Updated at |
created_in | string | Created in |
dob | string | Date of birth |
string | ||
firstname | string | Firstname |
lastname | string | Lastname |
middlename | string | Middlename |
prefix | string | Prefix |
suffix | string | Suffix |
gender | integer | Gender |
store_id | integer | Store Id |
taxvat | string | Taxvat |
website_id | integer | Website Id |
Example
CREATE VIEW magento_examples.example_Customers
AS
SELECT * FROM magento.Customers (
preview => TRUE
)
Invoices
Invoices
Parameter
<invoice_id> (optional): Return single invoice, rather than list
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
<label> (optional): Multi-tenancy label
Attribute | Type | Description |
---|---|---|
base_currency_code | string | Base Currency Code |
base_discount_amount | bigdecimal | Base Discount Amount |
base_grand_total | bigdecimal | Base Grand Total |
base_discount_tax_compensation_amount | bigdecimal | Base Discount Tax Compensation Amount |
base_shipping_amount | bigdecimal | Base Shipping Amount |
base_shipping_discount_tax_compensation_amnt | bigdecimal | Base Shipping Discount Tax Compensation Amnt |
base_shipping_incl_tax | bigdecimal | Base Shipping Incl Tax |
base_shipping_tax_amount | bigdecimal | Base Shipping Tax Amount |
base_subtotal | bigdecimal | Base Subtotal |
base_subtotal_incl_tax | bigdecimal | Base Subtotal Incl Tax |
base_tax_amount | bigdecimal | Base Tax Amount |
base_total_refunded | bigdecimal | Base Total Refunded |
base_to_global_rate | bigdecimal | Base To Global Rate |
base_to_order_rate | bigdecimal | Base To Order Rate |
billing_address_id | integer | Billing Address Id |
can_void_flag | bigdecimal | Can Void Flag |
created_at | timestamp | Created At |
discount_amount | bigdecimal | Discount Amount |
discount_description | string | Discount Description |
email_sent | bigdecimal | Email Sent |
entity_id | integer | Entity Id |
global_currency_code | string | Global Currency Code |
grand_total | bigdecimal | Grand Total |
discount_tax_compensation_amount | bigdecimal | Discount Tax Compensation Amount |
increment_id | string | Increment Id |
is_used_for_refund | bigdecimal | Is Used For Refund |
order_currency_code | string | Order Currency Code |
order_id | integer | Order Id |
shipping_address_id | integer | Shipping Address Id |
shipping_amount | bigdecimal | Shipping Amount |
shipping_discount_tax_compensation_amount | bigdecimal | Shipping Discount Tax Compensation Amount |
shipping_incl_tax | bigdecimal | Shipping Incl Tax |
shipping_tax_amount | bigdecimal | Shipping Tax Amount |
state | bigdecimal | State |
store_currency_code | string | Store Currency Code |
store_id | integer | Store Id |
store_to_base_rate | bigdecimal | Store To Base Rate |
store_to_order_rate | bigdecimal | Store To Order Rate |
subtotal | bigdecimal | Subtotal |
subtotal_incl_tax | bigdecimal | Subtotal Incl Tax |
tax_amount | bigdecimal | Tax Amount |
total_qty | bigdecimal | Total Qty |
transaction_id | string | Transaction Id |
updated_at | timestamp | Updated At |
extension_attributes_base_customer_balance_amount | bigdecimal | Extension Attributes Base Customer Balance Amount |
extension_attributes_customer_balance_amount | bigdecimal | Extension Attributes Customer Balance Amount |
extension_attributes_base_gift_cards_amount | bigdecimal | Extension Attributes Base Gift Cards Amount |
extension_attributes_gift_cards_amount | bigdecimal | Extension Attributes Gift Cards Amount |
extension_attributes_gw_price | string | Extension Attributes Gw Price |
extension_attributes_gw_items_base_price | string | Extension Attributes Gw Items Base Price |
extension_attributes_gw_items_price | string | Extension Attributes Gw Items Price |
extension_attributes_gw_card_base_price | string | Extension Attributes Gw Card Base Price |
extension_attributes_gw_card_price | string | Extension Attributes Gw Card Price |
extension_attributes_gw_base_tax_amount | string | Extension Attributes Gw Base Tax Amount |
extension_attributes_gw_tax_amount | string | Extension Attributes Gw Tax Amount |
extension_attributes_gw_items_base_tax_amount | string | Extension Attributes Gw Items Base Tax Amount |
extension_attributes_gw_items_tax_amount | string | Extension Attributes Gw Items Tax Amount |
extension_attributes_gw_card_base_tax_amount | string | Extension Attributes Gw Card Base Tax Amount |
extension_attributes_gw_card_tax_amount | string | Extension Attributes Gw Card Tax Amount |
extension_attributes_vertex_tax_calculation_shipping_address_address_type | string | Extension Attributes Vertex Tax Calculation Shipping Address Address Type |
extension_attributes_vertex_tax_calculation_shipping_address_city | string | Extension Attributes Vertex Tax Calculation Shipping Address City |
extension_attributes_vertex_tax_calculation_shipping_address_company | string | Extension Attributes Vertex Tax Calculation Shipping Address Company |
extension_attributes_vertex_tax_calculation_shipping_address_country_id | string | Extension Attributes Vertex Tax Calculation Shipping Address Country Id |
extension_attributes_vertex_tax_calculation_shipping_address_customer_address_id | integer | Extension Attributes Vertex Tax Calculation Shipping Address Customer Address Id |
extension_attributes_vertex_tax_calculation_shipping_address_customer_id | integer | Extension Attributes Vertex Tax Calculation Shipping Address Customer Id |
extension_attributes_vertex_tax_calculation_shipping_address_email | string | Extension Attributes Vertex Tax Calculation Shipping Address Email |
extension_attributes_vertex_tax_calculation_shipping_address_entity_id | integer | Extension Attributes Vertex Tax Calculation Shipping Address Entity Id |
extension_attributes_vertex_tax_calculation_shipping_address_fax | string | Extension Attributes Vertex Tax Calculation Shipping Address Fax |
extension_attributes_vertex_tax_calculation_shipping_address_firstname | string | Extension Attributes Vertex Tax Calculation Shipping Address First Name |
extension_attributes_vertex_tax_calculation_shipping_address_lastname | string | Extension Attributes Vertex Tax Calculation Shipping Address Last Name |
extension_attributes_vertex_tax_calculation_shipping_address_middlename | string | Extension Attributes Vertex Tax Calculation Shipping Address Middle Name |
extension_attributes_vertex_tax_calculation_shipping_address_parent_id | integer | Extension Attributes Vertex Tax Calculation Shipping Address Parent Id |
extension_attributes_vertex_tax_calculation_shipping_address_postcode | string | Extension Attributes Vertex Tax Calculation Shipping Address Postcode |
extension_attributes_vertex_tax_calculation_shipping_address_prefix | string | Extension Attributes Vertex Tax Calculation Shipping Address Prefix |
extension_attributes_vertex_tax_calculation_shipping_address_region | string | Extension Attributes Vertex Tax Calculation Shipping Address Region |
extension_attributes_vertex_tax_calculation_shipping_address_region_code | string | Extension Attributes Vertex Tax Calculation Shipping Address Region Code |
extension_attributes_vertex_tax_calculation_shipping_address_region_id | string | Extension Attributes Vertex Tax Calculation Shipping Address Region Id |
extension_attributes_vertex_tax_calculation_shipping_address_street | string | Extension Attributes Vertex Tax Calculation Shipping Address Street |
extension_attributes_vertex_tax_calculation_shipping_address_suffix | string | Extension Attributes Vertex Tax Calculation Shipping Address Suffix |
extension_attributes_vertex_tax_calculation_shipping_address_telephone | string | Extension Attributes Vertex Tax Calculation Shipping Address Telephone |
extension_attributes_vertex_tax_calculation_shipping_address_vat_id | string | Extension Attributes Vertex Tax Calculation Shipping Address Vat Id |
extension_attributes_vertex_tax_calculation_shipping_address_vat_is_valid | string | Extension Attributes Vertex Tax Calculation Shipping Address Vat Is Valid |
extension_attributes_vertex_tax_calculation_shipping_address_vat_request_date | string | Extension Attributes Vertex Tax Calculation Shipping Address Vat Request Date |
extension_attributes_vertex_tax_calculation_shipping_address_vat_request_id | string | Extension Attributes Vertex Tax Calculation Shipping Address Vat Request Id |
extension_attributes_vertex_tax_calculation_shipping_address_vat_request_success | bigdecimal | Extension Attributes Vertex Tax Calculation Shipping Address Vat Request Success |
extension_attributes_vertex_tax_calculation_billing_address_city | string | Extension Attributes Vertex Tax Calculation Billing Address City |
extension_attributes_vertex_tax_calculation_billing_address_company | string | Extension Attributes Vertex Tax Calculation Billing Address Company |
extension_attributes_vertex_tax_calculation_billing_address_country_id | string | Extension Attributes Vertex Tax Calculation Billing Address Country Id |
extension_attributes_vertex_tax_calculation_billing_address_customer_address_id | integer | Extension Attributes Vertex Tax Calculation Billing Address Customer Address Id |
extension_attributes_vertex_tax_calculation_billing_address_customer_id | integer | Extension Attributes Vertex Tax Calculation Billing Address Customer Id |
extension_attributes_vertex_tax_calculation_billing_address_email | string | Extension Attributes Vertex Tax Calculation Billing Address Email |
extension_attributes_vertex_tax_calculation_billing_address_entity_id | integer | Extension Attributes Vertex Tax Calculation Billing Address Entity Id |
extension_attributes_vertex_tax_calculation_billing_address_fax | string | Extension Attributes Vertex Tax Calculation Billing Address Fax |
extension_attributes_vertex_tax_calculation_billing_address_firstname | string | Extension Attributes Vertex Tax Calculation Billing Address First Name |
extension_attributes_vertex_tax_calculation_billing_address_lastname | string | Extension Attributes Vertex Tax Calculation Billing Address Last Name |
extension_attributes_vertex_tax_calculation_billing_address_middlename | string | Extension Attributes Vertex Tax Calculation Billing Address Middle Name |
extension_attributes_vertex_tax_calculation_billing_address_parent_id | integer | Extension Attributes Vertex Tax Calculation Billing Address Parent Id |
extension_attributes_vertex_tax_calculation_billing_address_postcode | string | Extension Attributes Vertex Tax Calculation Billing Address Postcode |
extension_attributes_vertex_tax_calculation_billing_address_prefix | string | Extension Attributes Vertex Tax Calculation Billing Address Prefix |
extension_attributes_vertex_tax_calculation_billing_address_region | string | Extension Attributes Vertex Tax Calculation Billing Address Region |
extension_attributes_vertex_tax_calculation_billing_address_region_code | string | Extension Attributes Vertex Tax Calculation Billing Address Region Code |
extension_attributes_vertex_tax_calculation_billing_address_region_id | string | Extension Attributes Vertex Tax Calculation Billing Address Region Id |
extension_attributes_vertex_tax_calculation_billing_address_street | string | Extension Attributes Vertex Tax Calculation Billing Address Street |
extension_attributes_vertex_tax_calculation_billing_address_suffix | string | Extension Attributes Vertex Tax Calculation Billing Address Suffix |
extension_attributes_vertex_tax_calculation_billing_address_telephone | string | Extension Attributes Vertex Tax Calculation Billing Address Telephone |
extension_attributes_vertex_tax_calculation_billing_address_vat_id | string | Extension Attributes Vertex Tax Calculation Billing Address Vat Id |
extension_attributes_vertex_tax_calculation_billing_address_vat_is_valid | string | Extension Attributes Vertex Tax Calculation Billing Address Vat Is Valid |
extension_attributes_vertex_tax_calculation_billing_address_vat_request_date | string | Extension Attributes Vertex Tax Calculation Billing Address Vat Request Date |
extension_attributes_vertex_tax_calculation_billing_address_vat_request_id | string | Extension Attributes Vertex Tax Calculation Billing Address Vat Request Id |
extension_attributes_vertex_tax_calculation_billing_address_vat_request_success | bigdecimal | Extension Attributes Vertex Tax Calculation Billing Address Vat Request Success |
extension_attributes_vertex_tax_calculation_order_adjustment_negative | bigdecimal | Extension Attributes Vertex Tax Calculation Order Adjustment Negative |
extension_attributes_vertex_tax_calculation_order_adjustment_positive | bigdecimal | Extension Attributes Vertex Tax Calculation Order Adjustment Positive |
extension_attributes_vertex_tax_calculation_order_applied_rule_ids | string | Extension Attributes Vertex Tax Calculation Order Applied Rule Ids |
extension_attributes_vertex_tax_calculation_order_base_adjustment_negative | bigdecimal | Extension Attributes Vertex Tax Calculation Order Base Adjustment Negative |
extension_attributes_vertex_tax_calculation_order_base_adjustment_positive | bigdecimal | Extension Attributes Vertex Tax Calculation Order Base Adjustment Positive |
extension_attributes_vertex_tax_calculation_order_base_currency_code | string | Extension Attributes Vertex Tax Calculation Order Base Currency Code |
extension_attributes_vertex_tax_calculation_order_base_discount_amount | bigdecimal | Extension Attributes Vertex Tax Calculation Order Base Discount Amount |
extension_attributes_vertex_tax_calculation_order_base_discount_canceled | bigdecimal | Extension Attributes Vertex Tax Calculation Order Base Discount Canceled |
extension_attributes_vertex_tax_calculation_order_base_discount_invoiced | bigdecimal | Extension Attributes Vertex Tax Calculation Order Base Discount Invoiced |
extension_attributes_vertex_tax_calculation_order_base_discount_refunded | bigdecimal | Extension Attributes Vertex Tax Calculation Order Base Discount Refunded |
extension_attributes_vertex_tax_calculation_order_base_grand_total | bigdecimal | Extension Attributes Vertex Tax Calculation Order Base Grand Total |
extension_attributes_vertex_tax_calculation_order_base_discount_tax_compensation_amount | bigdecimal | Extension Attributes Vertex Tax Calculation Order Base Discount Tax Compensation Amount |
extension_attributes_vertex_tax_calculation_order_base_discount_tax_compensation_invoiced | bigdecimal | Extension Attributes Vertex Tax Calculation Order Base Discount Tax Compensation Invoiced |
extension_attributes_vertex_tax_calculation_order_base_discount_tax_compensation_refunded | bigdecimal | Extension Attributes Vertex Tax Calculation Order Base Discount Tax Compensation Refunded |
extension_attributes_vertex_tax_calculation_order_base_shipping_amount | bigdecimal | Extension Attributes Vertex Tax Calculation Order Base Shipping Amount |
extension_attributes_vertex_tax_calculation_order_base_shipping_canceled | bigdecimal | Extension Attributes Vertex Tax Calculation Order Base Shipping Canceled |
extension_attributes_vertex_tax_calculation_order_base_shipping_discount_amount | bigdecimal | Extension Attributes Vertex Tax Calculation Order Base Shipping Discount Amount |
extension_attributes_vertex_tax_calculation_order_base_shipping_discount_tax_compensation_amnt | bigdecimal | Extension Attributes Vertex Tax Calculation Order Base Shipping Discount Tax Compensation Amnt |
extension_attributes_vertex_tax_calculation_order_base_shipping_incl_tax | bigdecimal | Extension Attributes Vertex Tax Calculation Order Base Shipping Incl Tax |
extension_attributes_vertex_tax_calculation_order_base_shipping_invoiced | bigdecimal | Extension Attributes Vertex Tax Calculation Order Base Shipping Invoiced |
extension_attributes_vertex_tax_calculation_order_base_shipping_refunded | bigdecimal | Extension Attributes Vertex Tax Calculation Order Base Shipping Refunded |
extension_attributes_vertex_tax_calculation_order_base_shipping_tax_amount | bigdecimal | Extension Attributes Vertex Tax Calculation Order Base Shipping Tax Amount |
extension_attributes_vertex_tax_calculation_order_base_shipping_tax_refunded | bigdecimal | Extension Attributes Vertex Tax Calculation Order Base Shipping Tax Refunded |
extension_attributes_vertex_tax_calculation_order_base_subtotal | bigdecimal | Extension Attributes Vertex Tax Calculation Order Base Subtotal |
extension_attributes_vertex_tax_calculation_order_base_subtotal_canceled | bigdecimal | Extension Attributes Vertex Tax Calculation Order Base Subtotal Canceled |
extension_attributes_vertex_tax_calculation_order_base_subtotal_incl_tax | bigdecimal | Extension Attributes Vertex Tax Calculation Order Base Subtotal Incl Tax |
extension_attributes_vertex_tax_calculation_order_base_subtotal_invoiced | bigdecimal | Extension Attributes Vertex Tax Calculation Order Base Subtotal Invoiced |
extension_attributes_vertex_tax_calculation_order_base_subtotal_refunded | bigdecimal | Extension Attributes Vertex Tax Calculation Order Base Subtotal Refunded |
extension_attributes_vertex_tax_calculation_order_base_tax_amount | bigdecimal | Extension Attributes Vertex Tax Calculation Order Base Tax Amount |
extension_attributes_vertex_tax_calculation_order_base_tax_canceled | bigdecimal | Extension Attributes Vertex Tax Calculation Order Base Tax Canceled |
extension_attributes_vertex_tax_calculation_order_base_tax_invoiced | bigdecimal | Extension Attributes Vertex Tax Calculation Order Base Tax Invoiced |
extension_attributes_vertex_tax_calculation_order_base_tax_refunded | bigdecimal | Extension Attributes Vertex Tax Calculation Order Base Tax Refunded |
extension_attributes_vertex_tax_calculation_order_base_total_canceled | bigdecimal | Extension Attributes Vertex Tax Calculation Order Base Total Canceled |
extension_attributes_vertex_tax_calculation_order_base_total_due | bigdecimal | Extension Attributes Vertex Tax Calculation Order Base Total Due |
extension_attributes_vertex_tax_calculation_order_base_total_invoiced | bigdecimal | Extension Attributes Vertex Tax Calculation Order Base Total Invoiced |
extension_attributes_vertex_tax_calculation_order_base_total_invoiced_cost | bigdecimal | Extension Attributes Vertex Tax Calculation Order Base Total Invoiced Cost |
extension_attributes_vertex_tax_calculation_order_base_total_offline_refunded | bigdecimal | Extension Attributes Vertex Tax Calculation Order Base Total Offline Refunded |
extension_attributes_vertex_tax_calculation_order_base_total_online_refunded | bigdecimal | Extension Attributes Vertex Tax Calculation Order Base Total Online Refunded |
extension_attributes_vertex_tax_calculation_order_base_total_paid | bigdecimal | Extension Attributes Vertex Tax Calculation Order Base Total Paid |
extension_attributes_vertex_tax_calculation_order_base_total_qty_ordered | bigdecimal | Extension Attributes Vertex Tax Calculation Order Base Total Qty Ordered |
extension_attributes_vertex_tax_calculation_order_base_total_refunded | bigdecimal | Extension Attributes Vertex Tax Calculation Order Base Total Refunded |
extension_attributes_vertex_tax_calculation_order_base_to_global_rate | bigdecimal | Extension Attributes Vertex Tax Calculation Order Base To Global Rate |
extension_attributes_vertex_tax_calculation_order_base_to_order_rate | bigdecimal | Extension Attributes Vertex Tax Calculation Order Base To Order Rate |
extension_attributes_vertex_tax_calculation_order_billing_address_id | integer | Extension Attributes Vertex Tax Calculation Order Billing Address Id |
extension_attributes_vertex_tax_calculation_order_can_ship_partially | bigdecimal | Extension Attributes Vertex Tax Calculation Order Can Ship Partially |
extension_attributes_vertex_tax_calculation_order_can_ship_partially_item | bigdecimal | Extension Attributes Vertex Tax Calculation Order Can Ship Partially Item |
extension_attributes_vertex_tax_calculation_order_coupon_code | string | Extension Attributes Vertex Tax Calculation Order Coupon Code |
extension_attributes_vertex_tax_calculation_order_created_at | string | Extension Attributes Vertex Tax Calculation Order Created At |
extension_attributes_vertex_tax_calculation_order_customer_dob | string | Extension Attributes Vertex Tax Calculation Order Customer DOB |
extension_attributes_vertex_tax_calculation_order_customer_email | string | Extension Attributes Vertex Tax Calculation Order Customer Email |
extension_attributes_vertex_tax_calculation_order_customer_firstname | string | Extension Attributes Vertex Tax Calculation Order Customer First Name |
extension_attributes_vertex_tax_calculation_order_customer_gender | bigdecimal | Extension Attributes Vertex Tax Calculation Order Customer Gender |
extension_attributes_vertex_tax_calculation_order_customer_group_id | integer | Extension Attributes Vertex Tax Calculation Order Customer Group Id |
extension_attributes_vertex_tax_calculation_order_customer_id | integer | Extension Attributes Vertex Tax Calculation Order Customer Id |
extension_attributes_vertex_tax_calculation_order_customer_is_guest | bigdecimal | Extension Attributes Vertex Tax Calculation Order Customer Is Guest |
extension_attributes_vertex_tax_calculation_order_customer_lastname | string | Extension Attributes Vertex Tax Calculation Order Customer Last Name |
extension_attributes_vertex_tax_calculation_order_customer_middlename | string | Extension Attributes Vertex Tax Calculation Order Customer Middle Name |
extension_attributes_vertex_tax_calculation_order_customer_note | string | Extension Attributes Vertex Tax Calculation Order Customer Note |
extension_attributes_vertex_tax_calculation_order_customer_note_notify | bigdecimal | Extension Attributes Vertex Tax Calculation Order Customer Note Notify |
extension_attributes_vertex_tax_calculation_order_customer_prefix | string | Extension Attributes Vertex Tax Calculation Order Customer Prefix |
extension_attributes_vertex_tax_calculation_order_customer_suffix | string | Extension Attributes Vertex Tax Calculation Order Customer Suffix |
extension_attributes_vertex_tax_calculation_order_customer_taxvat | string | Extension Attributes Vertex Tax Calculation Order Customer Tax Vat |
extension_attributes_vertex_tax_calculation_order_discount_amount | bigdecimal | Extension Attributes Vertex Tax Calculation Order Discount Amount |
extension_attributes_vertex_tax_calculation_order_discount_canceled | bigdecimal | Extension Attributes Vertex Tax Calculation Order Discount Canceled |
extension_attributes_vertex_tax_calculation_order_discount_description | string | Extension Attributes Vertex Tax Calculation Order Discount Description |
extension_attributes_vertex_tax_calculation_order_discount_invoiced | bigdecimal | Extension Attributes Vertex Tax Calculation Order Discount Invoiced |
extension_attributes_vertex_tax_calculation_order_discount_refunded | bigdecimal | Extension Attributes Vertex Tax Calculation Order Discount Refunded |
extension_attributes_vertex_tax_calculation_order_edit_increment | bigdecimal | Extension Attributes Vertex Tax Calculation Order Edit Increment |
extension_attributes_vertex_tax_calculation_order_email_sent | bigdecimal | Extension Attributes Vertex Tax Calculation Order Email Sent |
extension_attributes_vertex_tax_calculation_order_entity_id | integer | Extension Attributes Vertex Tax Calculation Order Entity Id |
extension_attributes_vertex_tax_calculation_order_ext_customer_id | string | Extension Attributes Vertex Tax Calculation Order Ext Customer Id |
extension_attributes_vertex_tax_calculation_order_ext_order_id | string | Extension Attributes Vertex Tax Calculation Order Ext Order Id |
extension_attributes_vertex_tax_calculation_order_forced_shipment_with_invoice | bigdecimal | Extension Attributes Vertex Tax Calculation Order Forced Shipment With Invoice |
extension_attributes_vertex_tax_calculation_order_global_currency_code | string | Extension Attributes Vertex Tax Calculation Order Global Currency Code |
extension_attributes_vertex_tax_calculation_order_grand_total | bigdecimal | Extension Attributes Vertex Tax Calculation Order Grand Total |
extension_attributes_vertex_tax_calculation_order_discount_tax_compensation_amount | bigdecimal | Extension Attributes Vertex Tax Calculation Order Discount Tax Compensation Amount |
extension_attributes_vertex_tax_calculation_order_discount_tax_compensation_invoiced | bigdecimal | Extension Attributes Vertex Tax Calculation Order Discount Tax Compensation Invoiced |
extension_attributes_vertex_tax_calculation_order_discount_tax_compensation_refunded | bigdecimal | Extension Attributes Vertex Tax Calculation Order Discount Tax Compensation Refunded |
extension_attributes_vertex_tax_calculation_order_hold_before_state | string | Extension Attributes Vertex Tax Calculation Order Hold Before State |
extension_attributes_vertex_tax_calculation_order_hold_before_status | string | Extension Attributes Vertex Tax Calculation Order Hold Before Status |
extension_attributes_vertex_tax_calculation_order_increment_id | string | Extension Attributes Vertex Tax Calculation Order Increment Id |
extension_attributes_vertex_tax_calculation_order_is_virtual | bigdecimal | Extension Attributes Vertex Tax Calculation Order Is Virtual |
extension_attributes_vertex_tax_calculation_order_order_currency_code | string | Extension Attributes Vertex Tax Calculation Order Currency Code |
extension_attributes_vertex_tax_calculation_order_original_increment_id | string | Extension Attributes Vertex Tax Calculation Order Original Increment Id |
extension_attributes_vertex_tax_calculation_order_payment_authorization_amount | bigdecimal | Extension Attributes Vertex Tax Calculation Order Payment Authorization Amount |
extension_attributes_vertex_tax_calculation_order_payment_auth_expiration | bigdecimal | Extension Attributes Vertex Tax Calculation Order Payment Auth Expiration |
extension_attributes_vertex_tax_calculation_order_protect_code | string | Extension Attributes Vertex Tax Calculation Order Protect Code |
extension_attributes_vertex_tax_calculation_order_quote_address_id | integer | Extension Attributes Vertex Tax Calculation Order Quote Address Id |
extension_attributes_vertex_tax_calculation_order_quote_id | integer | Extension Attributes Vertex Tax Calculation Order Quote Id |
extension_attributes_vertex_tax_calculation_order_relation_child_id | string | Extension Attributes Vertex Tax Calculation Order Relation Child Id |
extension_attributes_vertex_tax_calculation_order_relation_child_real_id | string | Extension Attributes Vertex Tax Calculation Order Relation Child Real Id |
extension_attributes_vertex_tax_calculation_order_relation_parent_id | string | Extension Attributes Vertex Tax Calculation Order Relation Parent Id |
extension_attributes_vertex_tax_calculation_order_relation_parent_real_id | string | Extension Attributes Vertex Tax Calculation Order Relation Parent Real Id |
extension_attributes_vertex_tax_calculation_order_remote_ip | string | Extension Attributes Vertex Tax Calculation Order Remote Ip |
extension_attributes_vertex_tax_calculation_order_shipping_amount | bigdecimal | Extension Attributes Vertex Tax Calculation Order Shipping Amount |
extension_attributes_vertex_tax_calculation_order_shipping_canceled | bigdecimal | Extension Attributes Vertex Tax Calculation Order Shipping Canceled |
extension_attributes_vertex_tax_calculation_order_shipping_description | string | Extension Attributes Vertex Tax Calculation Order Shipping Description |
extension_attributes_vertex_tax_calculation_order_shipping_discount_amount | bigdecimal | Extension Attributes Vertex Tax Calculation Order Shipping Discount Amount |
extension_attributes_vertex_tax_calculation_order_shipping_discount_tax_compensation_amount | bigdecimal | Extension Attributes Vertex Tax Calculation Order Shipping Discount Tax Compensation Amount |
extension_attributes_vertex_tax_calculation_order_shipping_incl_tax | bigdecimal | Extension Attributes Vertex Tax Calculation Order Shipping Incl Tax |
extension_attributes_vertex_tax_calculation_order_shipping_invoiced | bigdecimal | Extension Attributes Vertex Tax Calculation Order Shipping Invoiced |
extension_attributes_vertex_tax_calculation_order_shipping_refunded | bigdecimal | Extension Attributes Vertex Tax Calculation Order Shipping Refunded |
extension_attributes_vertex_tax_calculation_order_shipping_tax_amount | bigdecimal | Extension Attributes Vertex Tax Calculation Order Shipping Tax Amount |
extension_attributes_vertex_tax_calculation_order_shipping_tax_refunded | bigdecimal | Extension Attributes Vertex Tax Calculation Order Shipping Tax Refunded |
extension_attributes_vertex_tax_calculation_order_state | string | Extension Attributes Vertex Tax Calculation Order State |
extension_attributes_vertex_tax_calculation_order_status | string | Extension Attributes Vertex Tax Calculation Order Status |
extension_attributes_vertex_tax_calculation_order_store_currency_code | string | Extension Attributes Vertex Tax Calculation Order Store Currency Code |
extension_attributes_vertex_tax_calculation_order_store_id | integer | Extension Attributes Vertex Tax Calculation Order Store Id |
extension_attributes_vertex_tax_calculation_order_store_name | string | Extension Attributes Vertex Tax Calculation Order Store Name |
extension_attributes_vertex_tax_calculation_order_store_to_base_rate | bigdecimal | Extension Attributes Vertex Tax Calculation Order Store To Base Rate |
extension_attributes_vertex_tax_calculation_order_store_to_order_rate | bigdecimal | Extension Attributes Vertex Tax Calculation Order Store To Order Rate |
extension_attributes_vertex_tax_calculation_order_subtotal | bigdecimal | Extension Attributes Vertex Tax Calculation Order Subtotal |
extension_attributes_vertex_tax_calculation_order_subtotal_canceled | bigdecimal | Extension Attributes Vertex Tax Calculation Order Subtotal Canceled |
extension_attributes_vertex_tax_calculation_order_subtotal_incl_tax | bigdecimal | Extension Attributes Vertex Tax Calculation Order Subtotal Incl Tax |
extension_attributes_vertex_tax_calculation_order_subtotal_invoiced | bigdecimal | Extension Attributes Vertex Tax Calculation Order Subtotal Invoiced |
extension_attributes_vertex_tax_calculation_order_subtotal_refunded | bigdecimal | Extension Attributes Vertex Tax Calculation Order Subtotal Refunded |
extension_attributes_vertex_tax_calculation_order_tax_amount | bigdecimal | Extension Attributes Vertex Tax Calculation Order Tax Amount |
extension_attributes_vertex_tax_calculation_order_tax_canceled | bigdecimal | Extension Attributes Vertex Tax Calculation Order Tax Canceled |
extension_attributes_vertex_tax_calculation_order_tax_invoiced | bigdecimal | Extension Attributes Vertex Tax Calculation Order Tax Invoiced |
extension_attributes_vertex_tax_calculation_order_tax_refunded | bigdecimal | Extension Attributes Vertex Tax Calculation Order Tax Refunded |
extension_attributes_vertex_tax_calculation_order_total_canceled | bigdecimal | Extension Attributes Vertex Tax Calculation Order Total Canceled |
extension_attributes_vertex_tax_calculation_order_total_due | bigdecimal | Extension Attributes Vertex Tax Calculation Order Total Due |
extension_attributes_vertex_tax_calculation_order_total_invoiced | bigdecimal | Extension Attributes Vertex Tax Calculation Order Total Invoiced |
extension_attributes_vertex_tax_calculation_order_total_item_count | bigdecimal | Extension Attributes Vertex Tax Calculation Order Total Item Count |
extension_attributes_vertex_tax_calculation_order_total_offline_refunded | bigdecimal | Extension Attributes Vertex Tax Calculation Order Total Offline Refunded |
extension_attributes_vertex_tax_calculation_order_total_online_refunded | bigdecimal | Extension Attributes Vertex Tax Calculation Order Total Online Refunded |
extension_attributes_vertex_tax_calculation_order_total_paid | bigdecimal | Extension Attributes Vertex Tax Calculation Order Total Paid |
extension_attributes_vertex_tax_calculation_order_total_qty_ordered | bigdecimal | Extension Attributes Vertex Tax Calculation Order Total Qty Ordered |
extension_attributes_vertex_tax_calculation_order_total_refunded | bigdecimal | Extension Attributes Vertex Tax Calculation Order Total Refunded |
extension_attributes_vertex_tax_calculation_order_updated_at | string | Extension Attributes Vertex Tax Calculation Order Updated At |
extension_attributes_vertex_tax_calculation_order_weight | bigdecimal | Extension Attributes Vertex Tax Calculation Order Weight |
extension_attributes_vertex_tax_calculation_order_x_forwarded_for | string | Extension Attributes Vertex Tax Calculation Order X Forwarded For |
Example
CREATE VIEW magento_examples.example_Invoices
AS
SELECT * FROM magento.Invoices (
preview => TRUE
)
Orders
Orders
Parameter
<order_id> (optional): Return single order, rather than list
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
<label> (optional): Multi-tenancy label
Attribute | Type | Description |
---|---|---|
adjustment_negative | bigdecimal | Adjustment Negative |
adjustment_positive | bigdecimal | Adjustment Positive |
applied_rule_ids | string | Applied Rule Ids |
base_adjustment_negative | bigdecimal | Base Adjustment Negative |
base_adjustment_positive | bigdecimal | Base Adjustment Positive |
base_currency_code | string | Base Currency Code |
base_discount_amount | bigdecimal | Base Discount Amount |
base_discount_canceled | bigdecimal | Base Discount Canceled |
base_discount_invoiced | bigdecimal | Base Discount Invoiced |
base_discount_refunded | bigdecimal | Base Discount Refunded |
base_grand_total | bigdecimal | Base Grand Total |
base_discount_tax_compensation_amount | bigdecimal | Base Discount Tax Compensation Amount |
base_discount_tax_compensation_invoiced | bigdecimal | Base discount tax compensation invoiced |
base_discount_tax_compensation_refunded | bigdecimal | Base Discount Tax Compensation Refunded |
base_shipping_amount | bigdecimal | Base Shipping Amount |
base_shipping_canceled | bigdecimal | Base Shipping Canceled |
base_shipping_discount_amount | bigdecimal | Base Shipping Discount Amount |
base_shipping_discount_tax_compensation_amnt | bigdecimal | Base Shipping Discount Tax Compensation Amnt |
base_shipping_incl_tax | bigdecimal | Base Shipping Incl Tax |
base_shipping_invoiced | bigdecimal | Base Shipping Invoiced |
base_shipping_refunded | bigdecimal | Base Shipping Refunded |
base_shipping_tax_amount | bigdecimal | Base Shipping Tax Amount |
base_shipping_tax_refunded | bigdecimal | Base Shipping Tax Refunded |
base_subtotal | bigdecimal | Base Subtotal |
base_subtotal_canceled | bigdecimal | Base Subtotal Canceled |
base_subtotal_incl_tax | bigdecimal | Base Subtotal Incl Tax |
base_subtotal_invoiced | bigdecimal | Base Subtotal Invoiced |
base_subtotal_refunded | bigdecimal | Base Subtotal Refunded |
base_tax_amount | bigdecimal | Base Tax Amount |
base_tax_canceled | bigdecimal | Base Tax Canceled |
base_tax_invoiced | bigdecimal | Base Tax Invoiced |
base_tax_refunded | bigdecimal | Base Tax Refunded |
base_total_canceled | bigdecimal | Base Total Canceled |
base_total_due | bigdecimal | Base Total Due |
base_total_invoiced | bigdecimal | Base Total Invoiced |
base_total_invoiced_cost | bigdecimal | Base Total Invoiced Cost |
base_total_offline_refunded | bigdecimal | Base Total Offline Refunded |
base_total_online_refunded | bigdecimal | Base Total Online Refunded |
base_total_paid | bigdecimal | Base Total Paid |
base_total_qty_ordered | bigdecimal | Base Total Qty Ordered |
base_total_refunded | bigdecimal | Base Total Refunded |
base_to_global_rate | bigdecimal | Base To Global Rate |
base_to_order_rate | bigdecimal | Base To Order Rate |
billing_address_id | bigdecimal | Billing Address Id |
can_ship_partially | bigdecimal | Can Ship Partially |
can_ship_partially_item | bigdecimal | Can Ship Partially Item |
coupon_code | string | Coupon Code |
created_at | timestamp | Created At |
customer_dob | string | Customer DOB |
customer_email | string | Customer Email |
customer_firstname | string | Customer First Name |
customer_gender | bigdecimal | Customer Gender |
customer_group_id | bigdecimal | Customer Group Id |
customer_id | bigdecimal | Customer Id |
customer_is_guest | bigdecimal | Customer Is Guest |
customer_lastname | string | Customer Last Name |
customer_middlename | string | Customer Middle Name |
customer_note | string | Customer Note |
customer_note_notify | bigdecimal | Customer Note Notify |
customer_prefix | string | Customer Prefix |
customer_suffix | string | Customer Suffix |
customer_taxvat | string | Customer Tax Vat |
discount_amount | bigdecimal | Discount Amount |
discount_canceled | bigdecimal | Discount Canceled |
discount_description | string | Discount Description |
discount_invoiced | bigdecimal | Discount Invoiced |
discount_refunded | bigdecimal | Discount Refunded |
edit_increment | bigdecimal | Edit Increment |
email_sent | bigdecimal | Email Sent |
entity_id | integer | Entity Id |
ext_customer_id | string | Ext Customer Id |
ext_order_id | string | Ext Order Id |
forced_shipment_with_invoice | bigdecimal | Forced Shipment With Invoice |
global_currency_code | string | Global Currency Code |
grand_total | bigdecimal | Grand Total |
discount_tax_compensation_amount | bigdecimal | Discount Tax Compensation Amount |
discount_tax_compensation_invoiced | bigdecimal | Discount Tax Compensation Invoiced |
discount_tax_compensation_refunded | bigdecimal | Discount Tax Compensation Refunded |
hold_before_state | string | Hold Before State |
hold_before_status | string | Hold Before Status |
increment_id | string | Increment Id |
is_virtual | bigdecimal | Is Virtual |
order_currency_code | string | Order Currency Code |
original_increment_id | string | Original Increment Id |
payment_authorization_amount | bigdecimal | Payment Authorization Amount |
payment_auth_expiration | bigdecimal | Payment Auth Expiration |
protect_code | string | Protect Code |
quote_address_id | bigdecimal | Quote Address Id |
quote_id | bigdecimal | Quote Id |
relation_child_id | string | Relation Child Id |
relation_child_real_id | string | Relation Child Real Id |
relation_parent_id | string | Relation Parent Id |
relation_parent_real_id | string | Relation Parent Real Id |
remote_ip | string | Remote Ip |
shipping_amount | bigdecimal | Shipping Amount |
shipping_canceled | bigdecimal | Shipping Canceled |
shipping_description | string | Shipping Description |
shipping_discount_amount | bigdecimal | Shipping Discount Amount |
shipping_discount_tax_compensation_amount | bigdecimal | Shipping Discount Tax Compensation Amount |
shipping_incl_tax | bigdecimal | Shipping Incl Tax |
shipping_invoiced | bigdecimal | Shipping Invoiced |
shipping_refunded | bigdecimal | Shipping Refunded |
shipping_tax_amount | bigdecimal | Shipping Tax Amount |
shipping_tax_refunded | bigdecimal | Shipping Tax Refunded |
state | string | State |
status | string | Status |
store_currency_code | string | Store Currency Code |
store_id | bigdecimal | Store Id |
store_name | string | Store Name |
store_to_base_rate | bigdecimal | Store To Base Rate |
store_to_order_rate | bigdecimal | Store To Order Rate |
subtotal | bigdecimal | Subtotal |
subtotal_canceled | bigdecimal | Subtotal Canceled |
subtotal_incl_tax | bigdecimal | Subtotal Incl Tax |
subtotal_invoiced | bigdecimal | Subtotal Invoiced |
subtotal_refunded | bigdecimal | Subtotal Refunded |
tax_amount | bigdecimal | Tax Amount |
tax_canceled | bigdecimal | Tax Canceled |
tax_invoiced | bigdecimal | Tax Invoiced |
tax_refunded | bigdecimal | Tax Refunded |
total_canceled | bigdecimal | Total Canceled |
total_due | bigdecimal | Total Due |
total_invoiced | bigdecimal | Total Invoiced |
total_item_count | bigdecimal | Total Item Count |
total_offline_refunded | bigdecimal | Total Offline Refunded |
total_online_refunded | bigdecimal | Total Online Refunded |
total_paid | bigdecimal | Total Paid |
total_qty_ordered | bigdecimal | Total Qty Ordered |
total_refunded | bigdecimal | Total Refunded |
updated_at | timestamp | Updated At |
weight | bigdecimal | Weight |
x_forwarded_for | string | X Forwarded For |
billing_address_address_type | string | Billing Address Type |
billing_address_city | string | Billing Address City |
billing_address_company | string | Billing Address Company |
billing_address_country_id | string | Billing Address Country Id |
billing_address_customer_address_id | bigdecimal | Billing Address Customer Address Id |
billing_address_customer_id | integer | Billing Address Customer Id |
billing_address_email | string | Billing Address Email |
billing_address_entity_id | integer | Billing Address Entity Id |
billing_address_fax | string | Billing Address Fax |
billing_address_firstname | string | Billing Address First Name |
billing_address_lastname | string | Billing Address Last Name |
billing_address_middlename | string | Billing Address Middle Name |
billing_address_parent_id | integer | Billing Address Parent Id |
billing_address_postcode | string | Billing Address Postcode |
billing_address_prefix | string | Billing Address Prefix |
billing_address_region | string | Billing Address Region |
billing_address_region_code | string | Billing Address Region Code |
billing_address_region_id | integer | Billing Address Region Id |
billing_address_street | string | Billing Address Street |
billing_address_suffix | string | Billing Address Suffix |
billing_address_telephone | string | Billing Address Telephone |
billing_address_vat_id | string | Billing Address Vat Id |
billing_address_vat_is_valid | bigdecimal | Billing Address Vat Is Valid |
billing_address_vat_request_date | string | Billing Address Vat Request Date |
billing_address_vat_request_id | string | Billing Address Vat Request Id |
billing_address_vat_request_success | bigdecimal | Billing Address Vat Request Success |
billing_address_extension_attributes_vertex_vat_country_code | string | Billing Address Extension Attributes Vertex Vat Country Code |
payment_account_status | string | Payment Account Status |
payment_additional_data | string | Payment Additional Data |
payment_additional_information | string | Payment Additional Information |
payment_address_status | string | Payment Address Status |
payment_amount_authorized | bigdecimal | Payment Amount Authorized |
payment_amount_canceled | bigdecimal | Payment Amount Canceled |
payment_amount_ordered | bigdecimal | Payment Amount Ordered |
payment_amount_paid | bigdecimal | Payment Amount Paid |
payment_amount_refunded | bigdecimal | Payment Amount Refunded |
payment_anet_trans_method | string | Payment Anet Trans Method |
payment_base_amount_authorized | bigdecimal | Payment Base Amount Authorized |
payment_base_amount_canceled | bigdecimal | Payment Base Amount Canceled |
payment_base_amount_ordered | bigdecimal | Payment Base Amount Ordered |
payment_base_amount_paid | bigdecimal | Payment Base Amount Paid |
payment_base_amount_paid_online | bigdecimal | Payment Base Amount Paid Online |
payment_base_amount_refunded | bigdecimal | Payment Base Amount Refunded |
payment_base_amount_refunded_online | bigdecimal | Payment Base Amount Refunded Online |
payment_base_shipping_amount | bigdecimal | Payment Base Shipping Amount |
payment_base_shipping_captured | bigdecimal | Payment Base Shipping Captured |
payment_base_shipping_refunded | bigdecimal | Payment Base Shipping Refunded |
payment_cc_approval | string | Payment Cc Approval |
payment_cc_avs_status | string | Payment Cc Avs Status |
payment_cc_cid_status | string | Payment Cc Cid Status |
payment_cc_debug_request_body | string | Payment Cc Debug Request Body |
payment_cc_debug_response_body | string | Payment Cc Debug Response Body |
payment_cc_debug_response_serialized | string | Payment Cc Debug Response Serialized |
payment_cc_exp_month | string | Payment Cc Exp Month |
payment_cc_exp_year | string | Payment Cc Exp Year |
payment_cc_last4 | string | Payment Cc Last4 |
payment_cc_number_enc | string | Payment Cc Number Enc |
payment_cc_owner | string | Payment Cc Owner |
payment_cc_secure_verify | string | Payment Cc Secure Verify |
payment_cc_ss_issue | string | Payment Cc Ss Issue |
payment_cc_ss_start_month | string | Payment Cc Ss Start Month |
payment_cc_ss_start_year | string | Payment Cc Ss Start Year |
payment_cc_status | string | Payment Cc Status |
payment_cc_status_description | string | Payment Cc Status Description |
payment_cc_trans_id | string | Payment Cc Trans Id |
payment_cc_type | string | Payment Cc Type |
payment_echeck_account_name | string | Payment Echeck Account Name |
payment_echeck_account_type | string | Payment Echeck Account Type |
payment_echeck_bank_name | string | Payment Echeck Bank Name |
payment_echeck_routing_number | string | Payment Echeck Routing Number |
payment_echeck_type | string | Payment Echeck Type |
payment_entity_id | integer | Payment Entity Id |
payment_last_trans_id | string | Payment Last Trans Id |
payment_method | string | Payment Method |
payment_parent_id | integer | Payment Parent Id |
payment_po_number | string | Payment Po Number |
payment_protection_eligibility | string | Payment Protection Eligibility |
payment_quote_payment_id | bigdecimal | Payment Quote Payment Id |
payment_shipping_amount | bigdecimal | Payment Shipping Amount |
payment_shipping_captured | bigdecimal | Payment Shipping Captured |
payment_shipping_refunded | bigdecimal | Payment Shipping Refunded |
payment_extension_attributes_notification_message | string | Payment Extension Attributes Notification Message |
payment_extension_attributes_vault_payment_token_entity_id | integer | Payment Extension Attributes Vault Payment Token Entity Id |
payment_extension_attributes_vault_payment_token_customer_id | bigdecimal | Payment Extension Attributes Vault Payment Token Customer Id |
payment_extension_attributes_vault_payment_token_public_hash | string | Payment Extension Attributes Vault Payment Token Public Hash |
payment_extension_attributes_vault_payment_token_payment_method_code | string | Payment Extension Attributes Vault Payment Token Payment Method Code |
payment_extension_attributes_vault_payment_token_type | string | Payment Extension Attributes Vault Payment Token Type |
payment_extension_attributes_vault_payment_token_created_at | timestamp | Payment Extension Attributes Vault Payment Token Created At |
payment_extension_attributes_vault_payment_token_expires_at | string | Payment Extension Attributes Vault Payment Token Expires At |
payment_extension_attributes_vault_payment_token_gateway_token | string | Payment Extension Attributes Vault Payment Token Gateway Token |
payment_extension_attributes_vault_payment_token_token_details | string | Payment Extension Attributes Vault Payment Token Token Details |
payment_extension_attributes_vault_payment_token_is_active | boolean | Payment Extension Attributes Vault Payment Token Is Active |
payment_extension_attributes_vault_payment_token_is_visible | boolean | Payment Extension Attributes Vault Payment Token Is Visible |
Example
CREATE VIEW magento_examples.example_Orders
AS
SELECT * FROM magento.Orders (
preview => TRUE
)
OrdersItems
OrdersItems
Parameter
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
<label> (optional): Multi-tenancy label
Attribute | Type | Description |
---|---|---|
additional_data | string | Additional Data |
amount_refunded | bigdecimal | Amount Refunded |
applied_rule_ids | string | Applied Rule Ids |
base_amount_refunded | bigdecimal | Base Amount Refunded |
base_cost | bigdecimal | Base Cost |
base_discount_amount | bigdecimal | Base Discount Amount |
base_discount_invoiced | bigdecimal | Base Discount Invoiced |
base_discount_refunded | bigdecimal | Base Discount Refunded |
base_discount_tax_compensation_amount | bigdecimal | Base Discount Tax Compensation Amount |
base_discount_tax_compensation_invoiced | bigdecimal | Base Discount Tax Compensation Invoiced |
base_discount_tax_compensation_refunded | bigdecimal | Base Discount Tax Compensation Refunded |
base_original_price | bigdecimal | Base Original Price |
base_price | bigdecimal | Base Price |
base_price_incl_tax | bigdecimal | Base Price Incl Tax |
base_row_invoiced | bigdecimal | Base Row Invoiced |
base_row_total | bigdecimal | Base Row Total |
base_row_total_incl_tax | bigdecimal | Base Row Total Incl Tax |
base_tax_amount | bigdecimal | Base Tax Amount |
base_tax_before_discount | bigdecimal | Base Tax Before Discount |
base_tax_invoiced | bigdecimal | Base Tax Invoiced |
base_tax_refunded | bigdecimal | Base Tax Refunded |
base_weee_tax_applied_amount | bigdecimal | Base Weee Tax Applied Amount |
base_weee_tax_applied_row_amnt | bigdecimal | Base Weee Tax Applied Row Amnt |
base_weee_tax_disposition | bigdecimal | Base Weee Tax Disposition |
base_weee_tax_row_disposition | bigdecimal | Base Weee Tax Row Disposition |
created_at | timestamp | Created At |
description | string | Description |
discount_amount | bigdecimal | Discount Amount |
discount_invoiced | bigdecimal | Discount Invoiced |
discount_percent | bigdecimal | Discount Percent |
discount_refunded | bigdecimal | Discount Refunded |
discount_tax_compensation_amount | bigdecimal | Discount Tax Compensation Amount |
discount_tax_compensation_canceled | bigdecimal | Discount Tax Compensation Canceled |
discount_tax_compensation_invoiced | bigdecimal | Discount Tax Compensation Invoiced |
discount_tax_compensation_refunded | bigdecimal | Discount Tax Compensation Refunded |
event_id | bigdecimal | Event Id |
ext_order_item_id | string | Ext Order Item Id |
gift_message_customer_id | bigdecimal | Gift Message Customer Id |
extension_attributes_entity_id | string | Extension Attributes Entity Id |
extension_attributes_entity_type | string | Extension Attributes Entity Type |
extension_attributes_wrapping_add_printed_card | boolean | Extension Attributes Wrapping Add Printed Card |
extension_attributes_wrapping_allow_gift_receipt | boolean | Extension Attributes Wrapping Allow Gift Receipt |
extension_attributes_wrapping_id | bigdecimal | Extension Attributes Wrapping Id |
gift_message_gift_message_id | bigdecimal | Gift Message Gift Message Id |
gift_message_message | string | Gift Message Message |
gift_message_recipient | string | Gift Message Recipient |
gift_message_sender | string | Gift Message Sender |
extension_attributes_gw_base_price | string | Extension Attributes Gw Base Price |
extension_attributes_gw_base_price_invoiced | string | Extension Attributes Gw Base Price Invoiced |
extension_attributes_gw_base_price_refunded | string | Extension Attributes Gw Base Price Refunded |
extension_attributes_gw_base_tax_amount | string | Extension Attributes Gw Base Tax Amount |
extension_attributes_gw_base_tax_amount_invoiced | string | Extension Attributes Gw Base Tax Amount Invoiced |
extension_attributes_gw_base_tax_amount_refunded | string | Extension Attributes Gw Base Tax Amount Refunded |
extension_attributes_gw_id | string | Extension Attributes Gw Id |
extension_attributes_gw_price | string | Extension Attributes Gw Price |
extension_attributes_gw_price_invoiced | string | Extension Attributes Gw Price Invoiced |
extension_attributes_gw_price_refunded | string | Extension Attributes Gw Price Refunded |
extension_attributes_gw_tax_amount | string | Extension Attributes Gw Tax Amount |
extension_attributes_gw_tax_amount_invoiced | string | Extension Attributes Gw Tax Amount Invoiced |
extension_attributes_gw_tax_amount_refunded | string | Extension Attributes Gw Tax Amount Refunded |
free_shipping | bigdecimal | Free Shipping |
gw_base_price | bigdecimal | Gw Base Price |
gw_base_price_invoiced | bigdecimal | Gw Base Price Invoiced |
gw_base_price_refunded | bigdecimal | Gw Base Price Refunded |
gw_base_tax_amount | bigdecimal | Gw Base Tax Amount |
gw_base_tax_amount_invoiced | bigdecimal | Gw Base Tax Amount Invoiced |
gw_base_tax_amount_refunded | bigdecimal | Gw Base Tax Amount Refunded |
gw_id | bigdecimal | Gw Id |
gw_price | bigdecimal | Gw Price |
gw_price_invoiced | bigdecimal | Gw Price Invoiced |
gw_price_refunded | bigdecimal | Gw PRICE REFUNDED |
gw_tax_amount | bigdecimal | Gw Tax Amount |
gw_tax_amount_invoiced | bigdecimal | Gw Tax Amount Invoiced |
gw_tax_amount_refunded | bigdecimal | Gw Tax Amount Refunded |
is_qty_decimal | bigdecimal | Is Qty Decimal |
is_virtual | bigdecimal | Is Virtual |
item_id | integer | Item Id |
locked_do_invoice | bigdecimal | Locked Do Invoice |
locked_do_ship | bigdecimal | Locked Do Ship |
name | string | Name |
no_discount | bigdecimal | No Discount |
order_id | bigdecimal | Order Id |
original_price | bigdecimal | Original Price |
parent_item | clob | Parent Item |
parent_item_id | bigdecimal | Parent Item Id |
price | bigdecimal | Price |
price_incl_tax | bigdecimal | Price Incl Tax |
product_id | bigdecimal | Product Id |
product_option | clob | Product Option |
product_type | string | Product Type |
qty_backordered | bigdecimal | Qty Backordered |
qty_canceled | bigdecimal | Qty Canceled |
qty_invoiced | bigdecimal | Qty Invoiced |
qty_ordered | bigdecimal | Qty Ordered |
qty_refunded | bigdecimal | Qty Refunded |
qty_returned | bigdecimal | Qty Returned |
qty_shipped | bigdecimal | Qty Shipped |
quote_item_id | bigdecimal | Quote Item Id |
row_invoiced | bigdecimal | Row Invoiced |
row_total | bigdecimal | Row Total |
row_total_incl_tax | bigdecimal | Row Total Incl Tax |
row_weight | bigdecimal | Row Weight |
sku | string | Sku |
store_id | bigdecimal | Store Id |
tax_amount | bigdecimal | Tax Amount |
tax_before_discount | bigdecimal | Tax Before Discount |
tax_canceled | bigdecimal | Tax Canceled |
tax_invoiced | bigdecimal | Tax Invoiced |
tax_percent | bigdecimal | Tax Percent |
tax_refunded | bigdecimal | Tax Refunded |
updated_at | timestamp | Updated At |
weee_tax_applied | string | Weee Tax Applied |
weee_tax_applied_amount | bigdecimal | Weee Tax Applied Amount |
weee_tax_applied_row_amount | bigdecimal | Weee Tax Applied Row Amount |
weee_tax_disposition | bigdecimal | Weee Tax Disposition |
weee_tax_row_disposition | bigdecimal | Weee Tax Row Disposition |
weight | bigdecimal | Weight |
Example
CREATE VIEW magento_examples.example_OrdersItems
AS
SELECT * FROM magento.OrdersItems (
preview => TRUE
)
Products
Products
Parameter
<sku> (optional): Return single product, rather than list
<target_table> (optional): Table name to save the data to
<preview> (optional): Preview only, don't write into table
<label> (optional): Multi-tenancy label
Attribute | Type | Description |
---|---|---|
id | integer | Product Id |
sku | string | SKU |
name | string | Name |
attribute_set_id | integer | Attribute Set Id |
price | bigdecimal | Price |
status | integer | Status |
visibility | boolean | Visibility |
type_id | string | Type Id |
created_at | timestamp | Created At |
updated_at | timestamp | Updated At |
weight | bigdecimal | Weight |
Example
CREATE VIEW magento_examples.example_Products
AS
SELECT * FROM magento.Products (
preview => TRUE
)