# CJ Commission Detail schema ERD

Table and field reference for the Fivetran CJ Commission Detail connector.

## Table & Field Reference

### publisher_commission_item_situation_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| publisher_commission_id | Unknown | PK, FK |
| publisher_commission_item_id | Unknown | PK, FK |
| name | Unknown |  |

### publisher_commission_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| publisher_commission_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| advertiser_commission_item_id | Unknown | PK, FK |
| name | Unknown |  |

### advertiser_commission_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| advertiser_commission_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 |  |

## Relationships

- publisher_commission_item_situation_detail(publisher_commission_item_id) → publisher_commission_item(id)
- publisher_commission_item_situation_detail(publisher_commission_id) → publisher_commission_item(publisher_commission_id)
- publisher_commission_item(publisher_commission_id) → publisher_commission(id)
- publisher_commission_situation_detail(publisher_commission_id) → publisher_commission(id)
- advertiser_commission_item_situation_detail(advertiser_commission_item_id) → advertiser_commission_item(id)
- advertiser_commission_item_situation_detail(advertiser_commission_id) → advertiser_commission_item(advertiser_commission_id)
- advertiser_commission_item(advertiser_commission_id) → advertiser_commission(id)
- advertiser_commission_situation_detail(advertiser_commission_id) → advertiser_commission(id)