[
{
"field": "program",
"type": "character varying(256)",
"description": "The name of the card program.",
"display": "Program",
"units": null,
"has_total": false,
"is_filter_only": false
},
{
"field": "chargeback_token",
"type": "integer",
"description": "unique token to identify a chargeback record within a program.",
"display": "Chargeback Token",
"units": null,
"has_total": false,
"is_filter_only": false
},
{
"field": "initiating_transaction_token",
"type": "character varying(256)",
"description": "The token identifying the initial transaction in a chain of transactions (usually an authorization).",
"display": "Initiating Transaction Token",
"units": null,
"has_total": false,
"is_filter_only": false
},
{
"field": "transaction_token",
"type": "character varying(256)",
"description": "The token of the transaction; unique within a program.",
"display": "Transaction Token",
"units": null,
"has_total": false,
"is_filter_only": false
},
{
"field": "transaction_date",
"type": "timestamp without time zone",
"description": "The number of transactions related to a particular grouping of transactions and date.",
"display": "Transaction Date",
"units": null,
"has_total": false,
"date_format": "YYYY-MM-DD HH:mm:ss",
"is_filter_only": false
},
{
"field": "internal_transaction_code",
"type": "character varying(60)",
"description": "A transaction code representing a type of payment or transaction.",
"display": "Internal Transaction Code",
"units": null,
"has_total": false,
"is_filter_only": false
},
{
"field": "transaction_type",
"type": "character varying(256)",
"description": "A type field that categorizes the transaction event.",
"display": "Transaction Type",
"units": null,
"has_total": false,
"is_filter_only": false
},
{
"field": "chargeback",
"type": "character varying(50)",
"description": "The identifier for the chargeback record.",
"display": "Chargeback",
"units": "USD",
"has_total": true,
"is_filter_only": false
},
{
"field": "acting_card_token",
"type": "character varying(108)",
"description": "The token identifying a card within a card program. This can be seen in the cards view and transaction level views.",
"display": "Acting Card Token",
"units": null,
"has_total": false,
"is_filter_only": false
},
{
"field": "acting_card_last_four",
"type": "character varying(12)",
"description": "The last four digits of a card used in a transaction.",
"display": "Acting Card Last Four",
"units": null,
"has_total": false,
"is_filter_only": false
},
{
"field": "acting_card_type",
"type": "character varying(201)",
"description": "The type of card: virtual, physical.",
"display": "Acting Card Type",
"units": null,
"has_total": false,
"is_filter_only": false
},
{
"field": "transaction_processing_type",
"type": "character varying(9)",
"description": "The method used to capture the card PAN (chip, magstripe, contactless, chip fallback, token). Chip fallback is used when a chip-capable terminal fails and requires the use of the magstripe.",
"display": "Transaction Processing Type",
"enum_values": [],
"units": null,
"has_total": false,
"is_filter_only": false
},
{
"field": "chargeback_state",
"type": "character varying(30)",
"description": "The current state of the chargeback.",
"display": "Chargeback State",
"units": null,
"has_total": false,
"is_filter_only": false
},
{
"field": "chargeback_previous_state",
"type": "character varying(30)",
"description": "The previous state of the chargeback if the chargeback has moved through more than one state.",
"display": "Chargeback Previous State",
"units": null,
"has_total": false,
"is_filter_only": false
},
{
"field": "chargeback_created_date",
"type": "timestamp without time zone",
"description": "The date the chargeback was created.",
"display": "Chargeback Created Date",
"units": null,
"has_total": false,
"date_format": "YYYY-MM-DD HH:mm:ss",
"is_filter_only": false
},
{
"field": "chargeback_submission_date",
"type": "timestamp without time zone",
"description": "The date the chargeback was submitted to the network.",
"display": "Chargeback Submission Date",
"units": null,
"has_total": false,
"date_format": "YYYY-MM-DD HH:mm:ss",
"is_filter_only": false
},
{
"field": "chargeback_reason_code",
"type": "character varying(40)",
"description": "The code that indicates the reason for the current state of the chargeback.",
"display": "Chargeback Reason Code",
"units": null,
"has_total": false,
"is_filter_only": false
},
{
"field": "chargeback_reason",
"type": "character varying(1024)",
"description": "The reason for the current chargeback state.",
"display": "Chargeback Reason",
"units": null,
"has_total": false,
"is_filter_only": false
},
{
"field": "network_reason_code",
"type": "character varying(30)",
"description": "A label attached to a chargeback that has been submitted to a card network, describing the type or reasoning behind the chargeback being submitted.",
"display": "Network Reason Code",
"units": null,
"has_total": false,
"is_filter_only": false
},
{
"field": "network_case_id",
"type": "character varying(60)",
"description": "An identifier assigned to a chargeback that has been submitted to a card network, unique within a program.",
"display": "Network Case Id",
"units": null,
"has_total": false,
"is_filter_only": false
},
{
"field": "network_ref_id",
"type": "character varying(100)",
"description": "Network unique identifying number for a transaction.",
"display": "Network Ref Id",
"units": null,
"has_total": false,
"is_filter_only": false
},
{
"field": "has_documentation",
"type": "character varying(1)",
"description": "Indicates whether the chargeback has documentation.",
"display": "Has Documentation",
"enum_values": [],
"units": null,
"has_total": false,
"is_filter_only": false
},
{
"field": "provisional_credit_given",
"type": "character varying(1)",
"description": "Signifies whether a provisional credit has been granted to a cardholder in relation to a chargeback submission. A \"Y\" will be present if a provisional credit has been given and a \"N\" if a provisional credit has not been given.",
"display": "Provisional Credit Given",
"units": null,
"has_total": false,
"is_filter_only": false
},
{
"field": "chargeback_transition_token",
"type": "integer",
"description": "Used in the chargebacks detail view, this id represents each state a chargeback has progresses through.",
"display": "Chargeback Transition Token",
"units": null,
"has_total": false,
"is_filter_only": false
},
{
"field": "etl_batch_id",
"type": "integer",
"description": null,
"display": "Etl Batch Id",
"units": null,
"has_total": false,
"is_filter_only": false
},
{
"field": "entry_createdate",
"type": "timestamp without time zone",
"description": "The date and time when a record has been read into the database following a replication cycle.",
"display": "Entry Createdate",
"units": null,
"has_total": false,
"date_format": "YYYY-MM-DD HH:mm:ss",
"is_filter_only": false
},
{
"field": "last_modified_time",
"type": "timestamp without time zone",
"description": "The date when the record was most recently updated.",
"display": "Last Modified Time",
"units": null,
"has_total": false,
"date_format": "YYYY-MM-DD HH:mm:ss",
"is_filter_only": false
},
{
"field": "purchases",
"type": "numeric(14,2)",
"description": "The amount of purchases and any reversals related to settled transactions.",
"display": "Purchases",
"units": "USD",
"has_total": true,
"is_filter_only": false
},
{
"field": "chargebacks",
"type": "numeric(14,2)",
"description": "The amount of chargebacks that have completed, usually accompanied by a CASE_WON status.",
"display": "Chargebacks",
"units": "USD",
"has_total": true,
"is_filter_only": false
},
{
"field": "cardholder",
"type": "numeric(14,2)",
"description": "Used in the chargebacks detail view to represent the financial impact to the account of a cardholder as it relates to a particular chargeback event",
"display": "Cardholder",
"units": null,
"has_total": false,
"is_filter_only": false
},
{
"field": "pending_chargebacks",
"type": "numeric(14,2)",
"description": "The amount of pending chargebacks–funds are put in a holding account until the chargeback is completed.",
"display": "Pending Chargebacks",
"units": "USD",
"has_total": true,
"is_filter_only": false
},
{
"field": "pending_cardholder",
"type": "numeric(14,2)",
"description": "Amount of funds run through a Cardholder Account through the 4840 (or equivalent depending on country of transaction) layer. The movement of chargebacks funds or related to chargebacks in a state as to where it does not impact the ledger but rather the funds are set in a \"holding\" account until the chargeback is completed.",
"display": "Pending Cardholder",
"units": null,
"has_total": false,
"is_filter_only": false
},
{
"field": "core_api_transaction_type",
"type": "character varying(256)",
"description": null,
"display": "Core Api Transaction Type",
"units": null,
"has_total": false,
"is_filter_only": false
},
{
"field": "network",
"type": "character varying(100)",
"description": "The card network on which a transaction took place.",
"display": "Network",
"enum_values": [],
"units": null,
"has_total": false,
"is_filter_only": false
},
{
"field": "merchant_category_code",
"type": "integer",
"description": "The merchant category code (MCC) associated with a transaction.",
"display": "Merchant Category Code",
"units": null,
"has_total": false,
"is_filter_only": false
},
{
"field": "merchant_category_code_group",
"type": "character varying(2000)",
"description": "The merchant category code (MCC) group associated with a transaction.",
"display": "Merchant Category Code Group",
"units": null,
"has_total": false,
"is_filter_only": false
},
{
"field": "merchant_category_code_description",
"type": "character varying(1000)",
"description": "The description of the merchant category code (MCC) associated with a transaction.",
"display": "Merchant Category Code Description",
"units": null,
"has_total": false,
"is_filter_only": false
},
{
"field": "token_requestor",
"type": "character varying(50)",
"description": "The name of the token requestor within the card network.",
"display": "Token Requestor",
"units": null,
"has_total": false,
"is_filter_only": false
},
{
"field": "merchant_country",
"type": "character varying(128)",
"description": "The country of a merchant location where a transaction has taken place.",
"display": "Merchant Country",
"units": null,
"has_total": false,
"is_filter_only": false
},
{
"field": "merchant_city",
"type": "character varying(128)",
"description": "The city of a merchant location where a transaction has taken place.",
"display": "Merchant City",
"units": null,
"has_total": false,
"is_filter_only": false
},
{
"field": "merchant_state",
"type": "character varying(128)",
"description": "The state or province of a merchant location where a transaction has taken place.",
"display": "Merchant State",
"units": null,
"has_total": false,
"is_filter_only": false
},
{
"field": "merchant_lat",
"type": "character varying(64)",
"description": "The latitude (measurement of distance north or south from the equator) of a merchant location where a transaction has taken place.",
"display": "Merchant Lat",
"units": null,
"has_total": false,
"is_filter_only": false
},
{
"field": "merchant_lon",
"type": "character varying(64)",
"description": "The longitude (measurement of distance east or west from the prime meridian) of a merchant location where a transaction has taken place.",
"display": "Merchant Lon",
"units": null,
"has_total": false,
"is_filter_only": false
},
{
"field": "transaction_timestamp",
"type": "timestamp without time zone",
"description": "The date and time when a transaction occurred. Displayed in UTC.",
"display": "Transaction Timestamp",
"units": null,
"has_total": false,
"date_format": "YYYY-MM-DD HH:mm:ss",
"is_filter_only": false
},
{
"field": "cardholder_firstname",
"type": "character varying(355)",
"description": null,
"display": "Cardholder Firstname",
"units": null,
"has_total": false,
"is_filter_only": false
},
{
"field": "cardholder_lastname",
"type": "character varying(355)",
"description": null,
"display": "Cardholder Lastname",
"units": null,
"has_total": false,
"is_filter_only": false
},
{
"field": "core_api_transaction_token",
"type": "character varying(36)",
"description": null,
"display": "Core Api Transaction Token",
"units": null,
"has_total": false,
"is_filter_only": false
},
{
"field": "core_api_initiating_transaction_token",
"type": "character varying(36)",
"description": null,
"display": "Core Api Initiating Transaction Token",
"units": null,
"has_total": false,
"is_filter_only": false
}
]