def columns(self):
return [
('order_processor', 'STRING'),
('user_id', 'INT'),
('order_id', 'INT'),
('line_item_id', 'INT'),
('line_item_product_id', 'INT'),
('line_item_price', hive_decimal_type(12, 2)),
('line_item_unit_price', hive_decimal_type(12, 2)),
('line_item_quantity', 'INT'),
('product_class', 'STRING'),
('course_key', 'STRING'),
('product_detail', 'STRING'),
('username', 'STRING'),
('user_email', 'STRING'),
('date_placed', 'TIMESTAMP'),
('iso_currency_code', 'STRING'),
('coupon_id', 'INT'),
('discount_amount', hive_decimal_type(12, 2)), # Total discount in currency amount, i.e. unit_discount * qty
('voucher_id', 'INT'),
('voucher_code', 'STRING'),
('status', 'STRING'),
('refunded_amount', hive_decimal_type(12, 2)),
('refunded_quantity', 'INT'),
('payment_ref_id', 'STRING'),
('partner_short_code', 'STRING'),
]
def columns(self):
return [
('id', 'INT'),
('partner_name', 'STRING'),
('partner_sku', 'STRING'),
('partner_line_reference', 'STRING'),
('partner_line_notes', 'STRING'),
('title', 'STRING'),
('upc', 'STRING'),
('quantity', 'INT'),
('line_price_incl_tax', hive_decimal_type(12, 2)),
('line_price_excl_tax', hive_decimal_type(12, 2)),
('line_price_before_discounts_incl_tax', hive_decimal_type(12, 2)),
('line_price_before_discounts_excl_tax', hive_decimal_type(12, 2)),
('unit_cost_price', hive_decimal_type(12, 2)),
('unit_price_incl_tax', hive_decimal_type(12, 2)),
('unit_price_excl_tax', hive_decimal_type(12, 2)),
('unit_retail_price', hive_decimal_type(12, 2)),
('status', 'STRING'),
('est_dispatch_date', 'TIMESTAMP'),
('order_id', 'INT'),
('partner_id', 'INT'),
('product_id', 'INT'),
('stockrecord_id', 'INT'),
]
def columns(self):
return [
('id', 'INT'),
('order_id', 'INT'),
('user_id', 'INT'),
('status', 'STRING'),
('qty', 'int'),
('unit_cost', hive_decimal_type(12, 2)),
('line_desc', 'STRING'),
('currency', 'STRING'),
('fulfilled_time', 'TIMESTAMP'),
('report_comments', 'STRING'),
('refund_requested_time', 'TIMESTAMP'),
('service_fee', hive_decimal_type(12, 2)),
('list_price', hive_decimal_type(12, 2)),
('created', 'TIMESTAMP'),
('modified', 'TIMESTAMP'),
]
def columns(self):
return [
('id', 'INT'),
('order_id', 'INT'),
('user_id', 'INT'),
('status', 'STRING'),
('qty', 'int'),
('unit_cost', hive_decimal_type(12, 2)),
('line_desc', 'STRING'),
('currency', 'STRING'),
('fulfilled_time', 'TIMESTAMP'),
('report_comments', 'STRING'),
('refund_requested_time', 'TIMESTAMP'),
('service_fee', hive_decimal_type(12, 2)),
('list_price', hive_decimal_type(12, 2)),
('created', 'TIMESTAMP'),
('modified', 'TIMESTAMP'),
]
def columns(self):
return [
('id', 'INT'),
('number', 'STRING'),
('currency', 'STRING'),
('total_incl_tax', hive_decimal_type(12, 2)),
('total_excl_tax', hive_decimal_type(12, 2)),
('shipping_incl_tax', hive_decimal_type(12, 2)),
('shipping_excl_tax', hive_decimal_type(12, 2)),
('shipping_method', 'STRING'),
('shipping_code', 'STRING'),
('status', 'STRING'),
('guest_email', 'STRING'),
('date_placed', 'TIMESTAMP'),
('basket_id', 'INT'),
('billing_address_id', 'INT'),
('shipping_address_id', 'INT'),
('site_id', 'INT'),
('user_id', 'INT'),
]
def columns(self):
return [
('id', 'INT'),
('line_credit_excl_tax', hive_decimal_type(12, 2)),
('quantity', 'INT'),
('status', 'STRING'),
('order_line_id', 'INT'),
('refund_id', 'INT'),
('created', 'TIMESTAMP'),
('modified', 'TIMESTAMP'),
]
def columns(self):
return [
('course_id', 'STRING'),
('mode_slug', 'STRING'),
('suggested_prices', 'STRING'),
('min_price', 'INT'),
('expiration_datetime', 'STRING'),
('total_currently_enrolled', 'INT'),
('audit_currently_enrolled', 'INT'),
('honor_currently_enrolled', 'INT'),
('verified_currently_enrolled', 'INT'),
('professional_currently_enrolled', 'INT'),
('no_id_professional_currently_enrolled', 'INT'),
('refunded_seat_count', 'INT'),
('refunded_amount', hive_decimal_type(12, 2)),
('net_seat_revenue', hive_decimal_type(12, 2)),
('net_seat_count', 'INT'),
('donation_count', 'INT'),
('net_donation_revenue', hive_decimal_type(12, 2)),
]
def columns(self):
return [
('id', 'INT'),
('number', 'STRING'),
('currency', 'STRING'),
('total_incl_tax', hive_decimal_type(12, 2)),
('total_excl_tax', hive_decimal_type(12, 2)),
('shipping_incl_tax', hive_decimal_type(12, 2)),
('shipping_excl_tax', hive_decimal_type(12, 2)),
('shipping_method', 'STRING'),
('shipping_code', 'STRING'),
('status', 'STRING'),
('guest_email', 'STRING'),
('date_placed', 'TIMESTAMP'),
('basket_id', 'INT'),
('billing_address_id', 'INT'),
('shipping_address_id', 'INT'),
('site_id', 'INT'),
('user_id', 'INT'),
]
def columns(self):
return [
('id', 'INT'),
('line_credit_excl_tax', hive_decimal_type(12, 2)),
('quantity', 'INT'),
('status', 'STRING'),
('order_line_id', 'INT'),
('refund_id', 'INT'),
('created', 'TIMESTAMP'),
('modified', 'TIMESTAMP'),
]
def columns(self):
return [
('course_id', 'STRING'),
('mode_slug', 'STRING'),
('suggested_prices', 'STRING'),
('min_price', 'INT'),
('expiration_datetime', 'STRING'),
('total_currently_enrolled', 'INT'),
('audit_currently_enrolled', 'INT'),
('honor_currently_enrolled', 'INT'),
('verified_currently_enrolled', 'INT'),
('professional_currently_enrolled', 'INT'),
('no_id_professional_currently_enrolled', 'INT'),
('refunded_seat_count', 'INT'),
('refunded_amount', hive_decimal_type(12, 2)),
('net_seat_revenue', hive_decimal_type(12, 2)),
('net_seat_count', 'INT'),
('donation_count', 'INT'),
('net_donation_revenue', hive_decimal_type(12, 2)),
]
def columns(self):
return [
('id', 'INT'),
('category', 'STRING'),
('offer_id', 'INT'),
('offer_name', 'STRING'),
('voucher_id', 'INT'),
('voucher_code', 'STRING'),
('frequency', 'INT'),
('amount', hive_decimal_type(12, 2)),
('message', 'STRING'),
('order_id', 'INT'),
]
def columns(self):
return [
('id', 'INT'),
('category', 'STRING'),
('offer_id', 'INT'),
('offer_name', 'STRING'),
('voucher_id', 'INT'),
('voucher_code', 'STRING'),
('frequency', 'INT'),
('amount', hive_decimal_type(12, 2)),
('message', 'STRING'),
('order_id', 'INT'),
]
def columns(self):
return [
('id', 'INT'),
('user_id', 'INT'),
('course_id', 'STRING'),
('course_edited_timestamp', 'TIMESTAMP'),
('course_version', 'STRING'),
('grading_policy_hash', 'STRING'),
('percent_grade', hive_decimal_type(12, 2)),
('letter_grade', 'STRING'),
('passed_timestamp', 'TIMESTAMP'),
('created', 'TIMESTAMP'),
('modified', 'TIMESTAMP'),
]
def columns(self):
return [
('order_audit_code', 'STRING'),
('orderitem_audit_code', 'STRING'),
('transaction_audit_code', 'STRING'),
('partner_short_code', 'STRING'),
('payment_ref_id', 'STRING'),
('order_id', 'INT'),
('unique_order_id', 'STRING'),
('order_timestamp', 'TIMESTAMP'),
('transaction_date', 'STRING'),
('transaction_id', 'STRING'),
('unique_transaction_id', 'STRING'),
('transaction_payment_gateway_id', 'STRING'),
('transaction_payment_gateway_account_id', 'STRING'),
('transaction_type', 'STRING'),
('transaction_payment_method', 'STRING'),
('transaction_amount', hive_decimal_type(12, 2)),
('transaction_iso_currency_code', 'STRING'),
('transaction_fee', hive_decimal_type(12, 2)),
('transaction_amount_per_item', hive_decimal_type(12, 2)),
('transaction_fee_per_item', hive_decimal_type(12, 2)),
('order_line_item_id', 'INT'),
('unique_order_line_item_id', 'STRING'),
('order_line_item_product_id', 'INT'),
('order_line_item_price', hive_decimal_type(12, 2)),
('order_line_item_unit_price', hive_decimal_type(12, 2)),
('order_line_item_quantity', 'INT'),
('order_coupon_id', 'INT'),
('order_discount_amount', hive_decimal_type(12, 2)),
('order_voucher_id', 'INT'),
('order_voucher_code', 'STRING'),
('order_refunded_amount', hive_decimal_type(12, 2)),
('order_refunded_quantity', 'INT'),
('order_user_id', 'INT'),
('order_username', 'STRING'),
('order_user_email', 'STRING'),
('order_product_class', 'STRING'),
('order_product_detail', 'STRING'),
('order_course_id', 'STRING'),
('order_org_id', 'STRING'),
('order_processor', 'STRING'),
('course_uuid', 'STRING'),
('expiration_date', 'TIMESTAMP'),
]
def columns(self):
return [
('order_audit_code', 'STRING'),
('orderitem_audit_code', 'STRING'),
('transaction_audit_code', 'STRING'),
('partner_short_code', 'STRING'),
('payment_ref_id', 'STRING'),
('order_id', 'INT'),
('unique_order_id', 'STRING'),
('order_timestamp', 'TIMESTAMP'),
('transaction_date', 'STRING'),
('transaction_id', 'STRING'),
('unique_transaction_id', 'STRING'),
('transaction_payment_gateway_id', 'STRING'),
('transaction_payment_gateway_account_id', 'STRING'),
('transaction_type', 'STRING'),
('transaction_payment_method', 'STRING'),
('transaction_amount', hive_decimal_type(12, 2)),
('transaction_iso_currency_code', 'STRING'),
('transaction_fee', hive_decimal_type(12, 2)),
('transaction_amount_per_item', hive_decimal_type(12, 2)),
('transaction_fee_per_item', hive_decimal_type(12, 2)),
('order_line_item_id', 'INT'),
('unique_order_line_item_id', 'STRING'),
('order_line_item_product_id', 'INT'),
('order_line_item_price', hive_decimal_type(12, 2)),
('order_line_item_unit_price', hive_decimal_type(12, 2)),
('order_line_item_quantity', 'INT'),
('order_coupon_id', 'INT'),
('order_discount_amount', hive_decimal_type(12, 2)),
('order_voucher_id', 'INT'),
('order_voucher_code', 'STRING'),
('order_refunded_amount', hive_decimal_type(12, 2)),
('order_refunded_quantity', 'INT'),
('order_user_id', 'INT'),
('order_username', 'STRING'),
('order_user_email', 'STRING'),
('order_product_class', 'STRING'),
('order_product_detail', 'STRING'),
('order_course_id', 'STRING'),
('order_org_id', 'STRING'),
('order_processor', 'STRING'),
('course_uuid', 'STRING'),
('expiration_date', 'TIMESTAMP'),
]
