---
title: "CJ Affiliate data warehouse table groups"
slug: "cj-affiliate-data-warehouse-table-groups"
description: "Explore the complete Supermetrics data warehouse table groups for CJ Affiliate (Commission Junction(. See all the tables and the fields included in them."
updated: 2026-05-13T07:01:08Z
published: 2026-05-13T07:01:08Z
canonical: "docs.supermetrics.com/cj-affiliate-data-warehouse-table-groups"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# CJ Affiliate data warehouse table groups

Search fields

### Table: COMMISSION

| \| account_id \| \| --- \| \| \\| Display name \\| Account ID \\| \\| --- \\| --- \\| \\| Description \\| Account ID \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Account ID \| \| Description \| Account ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| account_id |
| \| Display name \| Account ID \| \| --- \| --- \| \| Description \| Account ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Account ID |
| Description | Account ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| account_name \| \| --- \| \| \\| Display name \\| Account name \\| \\| --- \\| --- \\| \\| Description \\| Account name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Account name \| \| Description \| Account name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| account_name |
| \| Display name \| Account name \| \| --- \| --- \| \| Description \| Account name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Account name |
| Description | Account name |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| action_id \| \| --- \| \| \\| Display name \\| Action ID \\| \\| --- \\| --- \\| \\| Description \\| Unique identifier of an advertiser's defined action associated with the commission \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Action ID \| \| Description \| Unique identifier of an advertiser's defined action associated with the commission \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| action_id |
| \| Display name \| Action ID \| \| --- \| --- \| \| Description \| Unique identifier of an advertiser's defined action associated with the commission \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Action ID |
| Description | Unique identifier of an advertiser's defined action associated with the commission |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| action_name \| \| --- \| \| \\| Display name \\| Action name \\| \\| --- \\| --- \\| \\| Description \\| Name of the action (as specified by the advertiser) for the commission \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Action name \| \| Description \| Name of the action (as specified by the advertiser) for the commission \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| action_name |
| \| Display name \| Action name \| \| --- \| --- \| \| Description \| Name of the action (as specified by the advertiser) for the commission \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Action name |
| Description | Name of the action (as specified by the advertiser) for the commission |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| action_type \| \| --- \| \| \\| Display name \\| Action type \\| \\| --- \\| --- \\| \\| Description \\| Action type for the commission \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Action type \| \| Description \| Action type for the commission \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| action_type |
| \| Display name \| Action type \| \| --- \| --- \| \| Description \| Action type for the commission \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Action type |
| Description | Action type for the commission |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| advertiser_commission_adv_currency \| \| --- \| \| \\| Display name \\| Advertiser commission (advertiser currency) \\| \\| --- \\| --- \\| \\| Description \\| Advertiser commission amount in the advertiser's currency \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Advertiser commission (advertiser currency) \| \| Description \| Advertiser commission amount in the advertiser's currency \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| advertiser_commission_adv_currency |
| \| Display name \| Advertiser commission (advertiser currency) \| \| --- \| --- \| \| Description \| Advertiser commission amount in the advertiser's currency \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Advertiser commission (advertiser currency) |
| Description | Advertiser commission amount in the advertiser's currency |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| advertiser_commission_usd \| \| --- \| \| \\| Display name \\| Advertiser commission (USD) \\| \\| --- \\| --- \\| \\| Description \\| Advertiser commission amount in USD \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Advertiser commission (USD) \| \| Description \| Advertiser commission amount in USD \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| advertiser_commission_usd |
| \| Display name \| Advertiser commission (USD) \| \| --- \| --- \| \| Description \| Advertiser commission amount in USD \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Advertiser commission (USD) |
| Description | Advertiser commission amount in USD |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| advertiser_id \| \| --- \| \| \\| Display name \\| Advertiser ID \\| \\| --- \\| --- \\| \\| Description \\| CID of the advertiser for the commission \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Advertiser ID \| \| Description \| CID of the advertiser for the commission \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| advertiser_id |
| \| Display name \| Advertiser ID \| \| --- \| --- \| \| Description \| CID of the advertiser for the commission \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Advertiser ID |
| Description | CID of the advertiser for the commission |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| advertiser_name \| \| --- \| \| \\| Display name \\| Advertiser name \\| \\| --- \\| --- \\| \\| Description \\| Name of the advertiser for the commission \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Advertiser name \| \| Description \| Name of the advertiser for the commission \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| advertiser_name |
| \| Display name \| Advertiser name \| \| --- \| --- \| \| Description \| Name of the advertiser for the commission \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Advertiser name |
| Description | Name of the advertiser for the commission |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| cj_fee_adv_currency \| \| --- \| \| \\| Display name \\| CJ fee (advertiser currency) \\| \\| --- \\| --- \\| \\| Description \\| CJ fee in the advertiser's currency \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| CJ fee (advertiser currency) \| \| Description \| CJ fee in the advertiser's currency \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| cj_fee_adv_currency |
| \| Display name \| CJ fee (advertiser currency) \| \| --- \| --- \| \| Description \| CJ fee in the advertiser's currency \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | CJ fee (advertiser currency) |
| Description | CJ fee in the advertiser's currency |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| cj_fee_usd \| \| --- \| \| \\| Display name \\| CJ fee (USD) \\| \\| --- \\| --- \\| \\| Description \\| CJ fee in USD \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| CJ fee (USD) \| \| Description \| CJ fee in USD \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| cj_fee_usd |
| \| Display name \| CJ fee (USD) \| \| --- \| --- \| \| Description \| CJ fee in USD \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | CJ fee (USD) |
| Description | CJ fee in USD |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| commission_id \| \| --- \| \| \\| Display name \\| Commission ID \\| \\| --- \\| --- \\| \\| Description \\| Commission identification number \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Commission ID \| \| Description \| Commission identification number \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| commission_id |
| \| Display name \| Commission ID \| \| --- \| --- \| \| Description \| Commission identification number \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Commission ID |
| Description | Commission identification number |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| commissions \| \| --- \| \| \\| Display name \\| Commissions \\| \\| --- \\| --- \\| \\| Description \\| Total number of commissions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Commissions \| \| Description \| Total number of commissions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| commissions |
| \| Display name \| Commissions \| \| --- \| --- \| \| Description \| Total number of commissions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Commissions |
| Description | Total number of commissions |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| company_id \| \| --- \| \| \\| Display name \\| Company ID \\| \\| --- \\| --- \\| \\| Description \\| Company ID \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Company ID \| \| Description \| Company ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| company_id |
| \| Display name \| Company ID \| \| --- \| --- \| \| Description \| Company ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Company ID |
| Description | Company ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| coupon \| \| --- \| \| \\| Display name \\| Coupon \\| \\| --- \\| --- \\| \\| Description \\| The coupon/voucher used in the transaction \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Coupon \| \| Description \| The coupon/voucher used in the transaction \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| coupon |
| \| Display name \| Coupon \| \| --- \| --- \| \| Description \| The coupon/voucher used in the transaction \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Coupon |
| Description | The coupon/voucher used in the transaction |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| dataSourceName \| \| --- \| \| \\| Display name \\| Data source \\| \\| --- \\| --- \\| \\| Description \\| The name of the source for this data, as listed on supermetrics.com/docs \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Data source \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| dataSourceName |
| \| Display name \| Data source \| \| --- \| --- \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Data source |
| Description | The name of the source for this data, as listed on supermetrics.com/docs |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| date \| \| --- \| \| \\| Display name \\| Date \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Date \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| date |
| \| Display name \| Date \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Date |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| event_date \| \| --- \| \| \\| Display name \\| Event date \\| \\| --- \\| --- \\| \\| Description \\| Event date for the commission in UTC time zone \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Event date \| \| Description \| Event date for the commission in UTC time zone \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| event_date |
| \| Display name \| Event date \| \| --- \| --- \| \| Description \| Event date for the commission in UTC time zone \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Event date |
| Description | Event date for the commission in UTC time zone |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| event_datetime \| \| --- \| \| \\| Display name \\| Event datetime \\| \\| --- \\| --- \\| \\| Description \\| Event datetime for the commission in UTC time zone \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Event datetime \| \| Description \| Event datetime for the commission in UTC time zone \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| event_datetime |
| \| Display name \| Event datetime \| \| --- \| --- \| \| Description \| Event datetime for the commission in UTC time zone \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Event datetime |
| Description | Event datetime for the commission in UTC time zone |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| is_cross_device \| \| --- \| \| \\| Display name \\| Is cross-device \\| \\| --- \\| --- \\| \\| Description \\| Indicates if a transaction was attributed using cross-device tracking \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Display name \| Is cross-device \| \| Description \| Indicates if a transaction was attributed using cross-device tracking \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| is_cross_device |
| \| Display name \| Is cross-device \| \| --- \| --- \| \| Description \| Indicates if a transaction was attributed using cross-device tracking \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Display name | Is cross-device |
| Description | Indicates if a transaction was attributed using cross-device tracking |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| locking_date \| \| --- \| \| \\| Display name \\| Locking date \\| \\| --- \\| --- \\| \\| Description \\| Date on which the commission is locked for extending or correcting \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Locking date \| \| Description \| Date on which the commission is locked for extending or correcting \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| locking_date |
| \| Display name \| Locking date \| \| --- \| --- \| \| Description \| Date on which the commission is locked for extending or correcting \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Locking date |
| Description | Date on which the commission is locked for extending or correcting |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| locking_datetime \| \| --- \| \| \\| Display name \\| Locking datetime \\| \\| --- \\| --- \\| \\| Description \\| Datetime on which the commission is locked for extending or correcting \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Locking datetime \| \| Description \| Datetime on which the commission is locked for extending or correcting \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| locking_datetime |
| \| Display name \| Locking datetime \| \| --- \| --- \| \| Description \| Datetime on which the commission is locked for extending or correcting \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Locking datetime |
| Description | Datetime on which the commission is locked for extending or correcting |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| new_to_file \| \| --- \| \| \\| Display name \\| New to file \\| \\| --- \\| --- \\| \\| Description \\| Indicates if the customer is new or existing to the advertiser (advertiser defined) \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Display name \| New to file \| \| Description \| Indicates if the customer is new or existing to the advertiser (advertiser defined) \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| new_to_file |
| \| Display name \| New to file \| \| --- \| --- \| \| Description \| Indicates if the customer is new or existing to the advertiser (advertiser defined) \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Display name | New to file |
| Description | Indicates if the customer is new or existing to the advertiser (advertiser defined) |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| order_discount_adv_currency \| \| --- \| \| \\| Display name \\| Order discount (advertiser currency) \\| \\| --- \\| --- \\| \\| Description \\| Discount associated with the order in the advertiser's currency \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Order discount (advertiser currency) \| \| Description \| Discount associated with the order in the advertiser's currency \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| order_discount_adv_currency |
| \| Display name \| Order discount (advertiser currency) \| \| --- \| --- \| \| Description \| Discount associated with the order in the advertiser's currency \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Order discount (advertiser currency) |
| Description | Discount associated with the order in the advertiser's currency |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| order_discount_usd \| \| --- \| \| \\| Display name \\| Order discount (USD) \\| \\| --- \\| --- \\| \\| Description \\| Discount associated with the order in USD \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Order discount (USD) \| \| Description \| Discount associated with the order in USD \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| order_discount_usd |
| \| Display name \| Order discount (USD) \| \| --- \| --- \| \| Description \| Discount associated with the order in USD \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Order discount (USD) |
| Description | Discount associated with the order in USD |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| order_id \| \| --- \| \| \\| Display name \\| Order ID \\| \\| --- \\| --- \\| \\| Description \\| Advertiser-assigned identification number for the order \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Order ID \| \| Description \| Advertiser-assigned identification number for the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| order_id |
| \| Display name \| Order ID \| \| --- \| --- \| \| Description \| Advertiser-assigned identification number for the order \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Order ID |
| Description | Advertiser-assigned identification number for the order |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| original \| \| --- \| \| \\| Display name \\| Original \\| \\| --- \\| --- \\| \\| Description \\| Displays either a '1' indicating an original transaction or a '0' indicating a non-original or corrected transaction \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Display name \| Original \| \| Description \| Displays either a '1' indicating an original transaction or a '0' indicating a non-original or corrected transaction \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| original |
| \| Display name \| Original \| \| --- \| --- \| \| Description \| Displays either a '1' indicating an original transaction or a '0' indicating a non-original or corrected transaction \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Display name | Original |
| Description | Displays either a '1' indicating an original transaction or a '0' indicating a non-original or corrected transaction |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| posting_date \| \| --- \| \| \\| Display name \\| Posting date \\| \\| --- \\| --- \\| \\| Description \\| Date on which the commission is posted \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Posting date \| \| Description \| Date on which the commission is posted \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| posting_date |
| \| Display name \| Posting date \| \| --- \| --- \| \| Description \| Date on which the commission is posted \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Posting date |
| Description | Date on which the commission is posted |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| posting_datetime \| \| --- \| \| \\| Display name \\| Posting datetime \\| \\| --- \\| --- \\| \\| Description \\| Datetime on which the commission is posted \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Posting datetime \| \| Description \| Datetime on which the commission is posted \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| posting_datetime |
| \| Display name \| Posting datetime \| \| --- \| --- \| \| Description \| Datetime on which the commission is posted \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Posting datetime |
| Description | Datetime on which the commission is posted |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| publisher_commission_pub_currency \| \| --- \| \| \\| Display name \\| Publisher commission (publisher currency) \\| \\| --- \\| --- \\| \\| Description \\| Publisher commission amount in the publisher's currency \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Publisher commission (publisher currency) \| \| Description \| Publisher commission amount in the publisher's currency \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| publisher_commission_pub_currency |
| \| Display name \| Publisher commission (publisher currency) \| \| --- \| --- \| \| Description \| Publisher commission amount in the publisher's currency \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Publisher commission (publisher currency) |
| Description | Publisher commission amount in the publisher's currency |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| publisher_commission_usd \| \| --- \| \| \\| Display name \\| Publisher commission (USD) \\| \\| --- \\| --- \\| \\| Description \\| Publisher commission amount in USD \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Publisher commission (USD) \| \| Description \| Publisher commission amount in USD \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| publisher_commission_usd |
| \| Display name \| Publisher commission (USD) \| \| --- \| --- \| \| Description \| Publisher commission amount in USD \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Publisher commission (USD) |
| Description | Publisher commission amount in USD |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| publisher_id \| \| --- \| \| \\| Display name \\| Publisher CID \\| \\| --- \\| --- \\| \\| Description \\| CID of the publisher for the commission \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Publisher CID \| \| Description \| CID of the publisher for the commission \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| publisher_id |
| \| Display name \| Publisher CID \| \| --- \| --- \| \| Description \| CID of the publisher for the commission \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Publisher CID |
| Description | CID of the publisher for the commission |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| publisher_name \| \| --- \| \| \\| Display name \\| Publisher name \\| \\| --- \\| --- \\| \\| Description \\| Name of the publisher for the commission \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Publisher name \| \| Description \| Name of the publisher for the commission \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| publisher_name |
| \| Display name \| Publisher name \| \| --- \| --- \| \| Description \| Name of the publisher for the commission \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Publisher name |
| Description | Name of the publisher for the commission |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| reviewed_status \| \| --- \| \| \\| Display name \\| Reviewed status \\| \\| --- \\| --- \\| \\| Description \\| Indicates if an advertiser has reviewed a transaction \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Reviewed status \| \| Description \| Indicates if an advertiser has reviewed a transaction \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| reviewed_status |
| \| Display name \| Reviewed status \| \| --- \| --- \| \| Description \| Indicates if an advertiser has reviewed a transaction \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Reviewed status |
| Description | Indicates if an advertiser has reviewed a transaction |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| sale_amount_adv_currency \| \| --- \| \| \\| Display name \\| Sale amount (advertiser currency) \\| \\| --- \\| --- \\| \\| Description \\| Sale amount in the advertiser's currency \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Sale amount (advertiser currency) \| \| Description \| Sale amount in the advertiser's currency \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| sale_amount_adv_currency |
| \| Display name \| Sale amount (advertiser currency) \| \| --- \| --- \| \| Description \| Sale amount in the advertiser's currency \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Sale amount (advertiser currency) |
| Description | Sale amount in the advertiser's currency |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| sale_amount_usd \| \| --- \| \| \\| Display name \\| Sale amount (USD) \\| \\| --- \\| --- \\| \\| Description \\| Sale amount in USD \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Sale amount (USD) \| \| Description \| Sale amount in USD \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| sale_amount_usd |
| \| Display name \| Sale amount (USD) \| \| --- \| --- \| \| Description \| Sale amount in USD \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Sale amount (USD) |
| Description | Sale amount in USD |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| source \| \| --- \| \| \\| Display name \\| Source \\| \\| --- \\| --- \\| \\| Description \\| Source for the transaction \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Source \| \| Description \| Source for the transaction \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| source |
| \| Display name \| Source \| \| --- \| --- \| \| Description \| Source for the transaction \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Source |
| Description | Source for the transaction |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| status \| \| --- \| \| \\| Display name \\| Status \\| \\| --- \\| --- \\| \\| Description \\| Status of the commission \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Status \| \| Description \| Status of the commission \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| status |
| \| Display name \| Status \| \| --- \| --- \| \| Description \| Status of the commission \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Status |
| Description | Status of the commission |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| website_id \| \| --- \| \| \\| Display name \\| Website ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the publisher website \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Website ID \| \| Description \| ID of the publisher website \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| website_id |
| \| Display name \| Website ID \| \| --- \| --- \| \| Description \| ID of the publisher website \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Website ID |
| Description | ID of the publisher website |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| website_name \| \| --- \| \| \\| Display name \\| Website name \\| \\| --- \\| --- \\| \\| Description \\| Name of the publisher website \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Website name \| \| Description \| Name of the publisher website \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| website_name |
| \| Display name \| Website name \| \| --- \| --- \| \| Description \| Name of the publisher website \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Website name |
| Description | Name of the publisher website |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |