CJ Commission Detail

Explore the interactive ERD

Table & Field Reference

publisher_commission_item_situation_detail

Column	Type	Keys
`id`	Unknown	PK
`publisher_commission_id`	Unknown	PKFK
`publisher_commission_item_id`	Unknown	PKFK
`name`	Unknown

publisher_commission_item

Column	Type	Keys
`id`	Unknown	PK
`publisher_commission_id`	Unknown	PKFK
`discount_adv_currency`	Unknown
`discount_pub_currency`	Unknown
`discount_usd`	Unknown
`item_list_id`	Unknown
`per_item_sale_amount_adv_currency`	Unknown
`per_item_sale_amount_pub_currency`	Unknown
`per_item_sale_amount_usd`	Unknown
`quantity`	Unknown
`sku`	Unknown
`total_commission_adv_currency`	Unknown
`total_commission_pub_currency`	Unknown
`total_commission_usd`	Unknown

publisher_commission_situation_detail

Column	Type	Keys
`id`	Unknown	PK
`publisher_commission_id`	Unknown	PKFK
`name`	Unknown

publisher_commission

Column	Type	Keys
`id`	Unknown	PK
`action_status`	Unknown
`action_tracker_id`	Unknown
`action_tracker_name`	Unknown
`action_type`	Unknown
`advertiser_id`	Unknown
`advertiser_name`	Unknown
`aid`	Unknown
`click_date`	Unknown
`click_referring_url`	Unknown
`concluding_browser`	Unknown
`concluding_device_name`	Unknown
`concluding_device_type`	Unknown
`correction_reason`	Unknown
`country`	Unknown
`coupon`	Unknown
`event_date`	Unknown
`initiating_browser`	Unknown
`initiating_device_name`	Unknown
`initiating_device_type`	Unknown
`is_cross_device`	Unknown
`locking_date`	Unknown
`locking_method`	Unknown
`order_discount_adv_currency`	Unknown
`order_discount_orig_currency`	Unknown
`order_discount_pub_currency`	Unknown
`order_discount_usd`	Unknown
`order_id`	Unknown
`original`	Unknown
`original_action_id`	Unknown
`posting_date`	Unknown
`pub_commission_amount_currency`	Unknown
`pub_commission_amount_usd`	Unknown
`publisher_id`	Unknown
`publisher_name`	Unknown
`reviewed_status`	Unknown
`sale_amount_pub_currency`	Unknown
`sale_amount_usd`	Unknown
`shopper_id`	Unknown
`site_to_store_offer`	Unknown
`source`	Unknown
`validation_status`	Unknown
`vertical_attribute_annual_fee`	Unknown
`vertical_attribute_application_status`	Unknown
`vertical_attribute_apr`	Unknown
`vertical_attribute_apr_transfer`	Unknown
`vertical_attribute_apr_transfer_time`	Unknown
`vertical_attribute_booking_date`	Unknown
`vertical_attribute_booking_status`	Unknown
`vertical_attribute_booking_value_post_tax`	Unknown
`vertical_attribute_booking_value_pre_tax`	Unknown
`vertical_attribute_brand`	Unknown
`vertical_attribute_brand_id`	Unknown
`vertical_attribute_business_unit`	Unknown
`vertical_attribute_campaign_id`	Unknown
`vertical_attribute_campaign_name`	Unknown
`vertical_attribute_car_options`	Unknown
`vertical_attribute_card_category`	Unknown
`vertical_attribute_cash_advance_fee`	Unknown
`vertical_attribute_category`	Unknown
`vertical_attribute_city`	Unknown
`vertical_attribute_class`	Unknown
`vertical_attribute_confirmation_number`	Unknown
`vertical_attribute_contract_length`	Unknown
`vertical_attribute_contract_type`	Unknown
`vertical_attribute_country_code`	Unknown
`vertical_attribute_coupon_discount`	Unknown
`vertical_attribute_coupon_type`	Unknown
`vertical_attribute_credit_line`	Unknown
`vertical_attribute_credit_quality`	Unknown
`vertical_attribute_credit_report`	Unknown
`vertical_attribute_cruise_type`	Unknown
`vertical_attribute_cust_country`	Unknown
`vertical_attribute_cust_segment`	Unknown
`vertical_attribute_cust_status`	Unknown
`vertical_attribute_cust_type`	Unknown
`vertical_attribute_customer_location`	Unknown
`vertical_attribute_delivery`	Unknown
`vertical_attribute_description`	Unknown
`vertical_attribute_dest_city`	Unknown
`vertical_attribute_dest_country`	Unknown
`vertical_attribute_dest_state`	Unknown
`vertical_attribute_destination_id`	Unknown
`vertical_attribute_domestic`	Unknown
`vertical_attribute_dropoff_iata`	Unknown
`vertical_attribute_dropoff_id`	Unknown
`vertical_attribute_duration`	Unknown
`vertical_attribute_end_date_time`	Unknown
`vertical_attribute_flight_fare_type`	Unknown
`vertical_attribute_flight_options`	Unknown
`vertical_attribute_flight_type`	Unknown
`vertical_attribute_flyer_miles`	Unknown
`vertical_attribute_funded_amount`	Unknown
`vertical_attribute_funded_currency`	Unknown
`vertical_attribute_genre`	Unknown
`vertical_attribute_guests`	Unknown
`vertical_attribute_iata`	Unknown
`vertical_attribute_introductory_apr`	Unknown
`vertical_attribute_introductory_apr_time`	Unknown
`vertical_attribute_item_id`	Unknown
`vertical_attribute_item_name`	Unknown
`vertical_attribute_item_type`	Unknown
`vertical_attribute_itinerary_id`	Unknown
`vertical_attribute_lifestage`	Unknown
`vertical_attribute_location`	Unknown
`vertical_attribute_loyalty_earned`	Unknown
`vertical_attribute_loyalty_first_time_signup`	Unknown
`vertical_attribute_loyalty_level`	Unknown
`vertical_attribute_loyalty_redeemed`	Unknown
`vertical_attribute_loyalty_status`	Unknown
`vertical_attribute_min_balance`	Unknown
`vertical_attribute_min_deposit`	Unknown
`vertical_attribute_min_stay_duration`	Unknown
`vertical_attribute_no_cancellation`	Unknown
`vertical_attribute_or_country`	Unknown
`vertical_attribute_or_state`	Unknown
`vertical_attribute_paid_at_booking_post_tax`	Unknown
`vertical_attribute_paid_at_booking_pre_tax`	Unknown
`vertical_attribute_payment_method`	Unknown
`vertical_attribute_payment_model`	Unknown
`vertical_attribute_pickup_iata`	Unknown
`vertical_attribute_pickup_id`	Unknown
`vertical_attribute_platform_id`	Unknown
`vertical_attribute_point_of_sale`	Unknown
`vertical_attribute_port`	Unknown
`vertical_attribute_preorder`	Unknown
`vertical_attribute_prepaid`	Unknown
`vertical_attribute_prequalify`	Unknown
`vertical_attribute_promotion`	Unknown
`vertical_attribute_promotion_amount`	Unknown
`vertical_attribute_promotion_condition_threshold`	Unknown
`vertical_attribute_promotion_condition_type`	Unknown
`vertical_attribute_promotion_ends`	Unknown
`vertical_attribute_promotion_starts`	Unknown
`vertical_attribute_promotion_type`	Unknown
`vertical_attribute_quantity`	Unknown
`vertical_attribute_rating`	Unknown
`vertical_attribute_room_type`	Unknown
`vertical_attribute_rooms`	Unknown
`vertical_attribute_service_type`	Unknown
`vertical_attribute_ship_name`	Unknown
`vertical_attribute_start_date_time`	Unknown
`vertical_attribute_state`	Unknown
`vertical_attribute_subscription_fee`	Unknown
`vertical_attribute_subscription_length`	Unknown
`vertical_attribute_tax_amount`	Unknown
`vertical_attribute_tax_type`	Unknown
`vertical_attribute_transfer_fee`	Unknown
`vertical_attribute_travel_type`	Unknown
`vertical_attribute_trip_type`	Unknown
`vertical_attribute_upsell`	Unknown
`website_id`	Unknown
`website_name`	Unknown

advertiser_commission_item_situation_detail

Column	Type	Keys
`id`	Unknown	PK
`advertiser_commission_id`	Unknown	PKFK
`advertiser_commission_item_id`	Unknown	PKFK
`name`	Unknown

advertiser_commission_item

Column	Type	Keys
`id`	Unknown	PK
`advertiser_commission_id`	Unknown	PKFK
`discount_adv_currency`	Unknown
`discount_pub_currency`	Unknown
`discount_usd`	Unknown
`item_list_id`	Unknown
`per_item_sale_amount_adv_currency`	Unknown
`per_item_sale_amount_pub_currency`	Unknown
`per_item_sale_amount_usd`	Unknown
`quantity`	Unknown
`sku`	Unknown
`total_commission_adv_currency`	Unknown
`total_commission_pub_currency`	Unknown

advertiser_commission_situation_detail

Column	Type	Keys
`id`	Unknown	PK
`advertiser_commission_id`	Unknown	PKFK
`name`	Unknown

advertiser_commission

Column	Type	Keys
`id`	Unknown	PK
`action_status`	Unknown
`action_tracker_id`	Unknown
`action_tracker_name`	Unknown
`action_type`	Unknown
`ad_owner`	Unknown
`adv_commission_amount_adv_currency`	Unknown
`adv_commission_amount_usd`	Unknown
`advertiser_id`	Unknown
`advertiser_name`	Unknown
`aid`	Unknown
`cj_fee_adv_currency`	Unknown
`cj_fee_usd`	Unknown
`click_date`	Unknown
`click_referring_url`	Unknown
`concluding_browser`	Unknown
`concluding_device_name`	Unknown
`concluding_device_type`	Unknown
`correction_reason`	Unknown
`country`	Unknown
`coupon`	Unknown
`event_date`	Unknown
`initiating_browser`	Unknown
`initiating_device_name`	Unknown
`initiating_device_type`	Unknown
`is_cross_device`	Unknown
`locking_date`	Unknown
`locking_method`	Unknown
`new_to_file`	Unknown
`order_discount_adv_currency`	Unknown
`order_discount_orig_currency`	Unknown
`order_discount_pub_currency`	Unknown
`order_discount_usd`	Unknown
`order_id`	Unknown
`original`	Unknown
`original_action_id`	Unknown
`posting_date`	Unknown
`pub_commission_amount_pub_currency`	Unknown
`pub_commission_amount_usd`	Unknown
`publisher_id`	Unknown
`publisher_name`	Unknown
`reviewed_status`	Unknown
`sale_amount_adv_currency`	Unknown
`sale_amount_pub_currency`	Unknown
`sale_amount_usd`	Unknown
`site_to_store_offer`	Unknown
`source`	Unknown
`validation_status`	Unknown
`vertical_attribute_ancillary_spend`	Unknown
`vertical_attribute_annual_fee`	Unknown
`vertical_attribute_application_status`	Unknown
`vertical_attribute_apr`	Unknown
`vertical_attribute_apr_transfer`	Unknown
`vertical_attribute_apr_transfer_time`	Unknown
`vertical_attribute_booking_date`	Unknown
`vertical_attribute_booking_status`	Unknown
`vertical_attribute_booking_value_post_tax`	Unknown
`vertical_attribute_booking_value_pre_tax`	Unknown
`vertical_attribute_brand`	Unknown
`vertical_attribute_brand_id`	Unknown
`vertical_attribute_business_unit`	Unknown
`vertical_attribute_campaign_id`	Unknown
`vertical_attribute_campaign_name`	Unknown
`vertical_attribute_car_options`	Unknown
`vertical_attribute_card_category`	Unknown
`vertical_attribute_cash_advance_fee`	Unknown
`vertical_attribute_category`	Unknown
`vertical_attribute_city`	Unknown
`vertical_attribute_class`	Unknown
`vertical_attribute_confirmation_number`	Unknown
`vertical_attribute_contract_length`	Unknown
`vertical_attribute_contract_type`	Unknown
`vertical_attribute_country_code`	Unknown
`vertical_attribute_coupon_discount`	Unknown
`vertical_attribute_coupon_type`	Unknown
`vertical_attribute_credit_line`	Unknown
`vertical_attribute_credit_quality`	Unknown
`vertical_attribute_credit_report`	Unknown
`vertical_attribute_cruise_type`	Unknown
`vertical_attribute_cust_country`	Unknown
`vertical_attribute_cust_segment`	Unknown
`vertical_attribute_cust_status`	Unknown
`vertical_attribute_cust_type`	Unknown
`vertical_attribute_customer_location`	Unknown
`vertical_attribute_delivery`	Unknown
`vertical_attribute_description`	Unknown
`vertical_attribute_dest_city`	Unknown
`vertical_attribute_dest_country`	Unknown
`vertical_attribute_dest_state`	Unknown
`vertical_attribute_destination_id`	Unknown
`vertical_attribute_domestic`	Unknown
`vertical_attribute_dropoff_iata`	Unknown
`vertical_attribute_dropoff_id`	Unknown
`vertical_attribute_duration`	Unknown
`vertical_attribute_end_date_time`	Unknown
`vertical_attribute_flight_fare_type`	Unknown
`vertical_attribute_flight_option`	Unknown
`vertical_attribute_flight_type`	Unknown
`vertical_attribute_flyer_miles`	Unknown
`vertical_attribute_funded_amount`	Unknown
`vertical_attribute_funded_currency`	Unknown
`vertical_attribute_genre`	Unknown
`vertical_attribute_guest`	Unknown
`vertical_attribute_iata`	Unknown
`vertical_attribute_introductory_apr`	Unknown
`vertical_attribute_introductory_apr_time`	Unknown
`vertical_attribute_item_id`	Unknown
`vertical_attribute_item_name`	Unknown
`vertical_attribute_item_type`	Unknown
`vertical_attribute_itinerary_id`	Unknown
`vertical_attribute_lifestage`	Unknown
`vertical_attribute_location`	Unknown
`vertical_attribute_loyalty_earned`	Unknown
`vertical_attribute_loyalty_first_time_signup`	Unknown
`vertical_attribute_loyalty_level`	Unknown
`vertical_attribute_loyalty_redeemed`	Unknown
`vertical_attribute_loyalty_status`	Unknown
`vertical_attribute_margin`	Unknown
`vertical_attribute_marketing_channel`	Unknown
`vertical_attribute_min_balance`	Unknown
`vertical_attribute_min_deposit`	Unknown
`vertical_attribute_min_stay_duration`	Unknown
`vertical_attribute_no_cancellation`	Unknown
`vertical_attribute_or_city`	Unknown
`vertical_attribute_or_country`	Unknown
`vertical_attribute_or_state`	Unknown
`vertical_attribute_paid_at_booking_post_tax`	Unknown
`vertical_attribute_paid_at_booking_pre_tax`	Unknown
`vertical_attribute_payment_method`	Unknown
`vertical_attribute_payment_model`	Unknown
`vertical_attribute_pickup_iata`	Unknown
`vertical_attribute_pickup_id`	Unknown
`vertical_attribute_platform_id`	Unknown
`vertical_attribute_point_of_sale`	Unknown
`vertical_attribute_port`	Unknown
`vertical_attribute_preorder`	Unknown
`vertical_attribute_prepaid`	Unknown
`vertical_attribute_prequalify`	Unknown
`vertical_attribute_promotion`	Unknown
`vertical_attribute_promotion_amount`	Unknown
`vertical_attribute_promotion_condition_threshold`	Unknown
`vertical_attribute_promotion_condition_type`	Unknown
`vertical_attribute_promotion_ends`	Unknown
`vertical_attribute_promotion_starts`	Unknown
`vertical_attribute_promotion_type`	Unknown
`vertical_attribute_quantity`	Unknown
`vertical_attribute_rating`	Unknown
`vertical_attribute_room_type`	Unknown
`vertical_attribute_rooms`	Unknown
`vertical_attribute_service_type`	Unknown
`vertical_attribute_ship_name`	Unknown
`vertical_attribute_start_date_time`	Unknown
`vertical_attribute_state`	Unknown
`vertical_attribute_subscription_fee`	Unknown
`vertical_attribute_subscription_length`	Unknown
`vertical_attribute_tax_amount`	Unknown
`vertical_attribute_tax_type`	Unknown
`vertical_attribute_transfer_fee`	Unknown
`vertical_attribute_travel_type`	Unknown
`vertical_attribute_trip_type`	Unknown
`vertical_attribute_upsell`	Unknown
`website_id`	Unknown
`website_name`	Unknown