Merchant Credit events provide all the data necessary to evaluate the effectiveness of potential credit matching logic, as well as total recoveries via merchant credits. When a possible merchant credit is automatically matched by the system, an event is created. When a merchant credit is identified by a user, an event is created. When a possible merchant credit is referred to a user by the system, and the user does not identify it as a match for the disputed transaction, an event is created.
Data Category | Event Field/Column Name | Data Type | Description | Applicability | Sample Value | Notes |
|---|---|---|---|---|---|---|
Key | TenantId | VARCHAR(32) | Unique ID associated with each Quavo client. | ALWAYS | qvo-stg |
|
Key | ClientId | VARCHAR(64) | A unique ID representing a single client. | ALWAYS | Default |
|
Key | ClaimId | VARCHAR(32) |
Unique ID associated with a claim. Format: YYMMDD<Ordinal Number>"C" Example: 2405230003C
| ALWAYS | 2306060014C |
|
Key | DisputeId | VARCHAR(32) | Unique ID associated with a disputed transaction. Format: YYMMDD#####"D" | ALWAYS | 2306050001D |
|
Potential Credit Details | TransactionDate | DATE | The date of the transaction, as provided by the system of record. This generally represents the Posting Date. | CONDITIONAL | 2023-08-16 |
|
Potential Credit Details | AUTHCODE | VARCHAR(8) | A credit card authorization or approval code is an alphanumeric string generated at the POS. Normally consisting of five to six characters, this one-time approval code is unique to each transaction. | CONDITIONAL | 85541091 |
|
Potential Credit Details | TransactionId | VARCHAR(256) | A unique ID associated with a transaction. This value is provided by the transaction system of record. | CONDITIONAL | 000002174116543800 |
|
Potential Credit Details | ARN | VARCHAR(32) | A unique number assigned to a credit card transaction as it moves through the payment flow. | CONDITIONAL | 13199982166549566629334 |
|
Potential Credit Details | PostingDate | DATE | The date the transaction posted to the customer/member account. | CONDITIONAL | 2023-08-17 |
|
Potential Credit Details | Description | VARCHAR(256) | A description of the transaction as provided by the system of record. Typically, this will match what the customer/member sees on their account statement. | CONDITIONAL | http://APPLE.COM/BILL , 866-712-7753, CAUS |
|
Potential Credit Details | MerchantName | VARCHAR(256) | Name of the business providing goods or services, as provided by the system of record. | CONDITIONAL | http://APPLE.COM/BILL , 866-712-7753, CAUS |
|
Potential Credit Details | Amount | NUMBER(92) | The amount of the potential credit transaction. | ALWAYS | 11.99 |
|
Potential Credit Details | OUTCOME | VARCHAR(16) | For merchant credit checking, this represents the result of the check or user review. | ALWAYS | "Auto", "Manual", "No Match", "Canceled" |
|
Potential Credit Details | AppliedAmount | NUMBER(92) | The amount of the credit that was applied to the dispute. | CONDITIONAL | 11.99 | (where applicable) |
Potential Credit Details | Iteration | NUMBER(20) | For matching algorithms, such as merchant credit or authorization posting, this number represents the the highest probability rule that resulted in a match. | ALWAYS | 5 |
|
Potential Credit Details | ISCREDITEXPECTED | BOOLEAN | When a credit for a dispute is promised, such as in the case of merchant collaboration, this Boolean value is set to true. | CONDITIONAL | FALSE |
|
Potential Credit Details | SEARCHSTARTDATE | DATE | Represents the start of the search range when searching for merchant credits. With each subsequent check, the start date begins on the end date of the previous check. | CONDITIONAL | 2023-08-24 |
|
Potential Credit Details | MatchResult | VARCHAR(16) | For matching algorithms, such as merchant credit or authorization posting, this represents whether a match was applied automatically or referred to a user. | CONDITIONAL | "Auto Match", "Review" |
|
Metadata | EventDateTime | TIMESTAMP_NTZ(9) | The datetime that the event was recorded. | ALWAYS | 2023-09-09 21:00:00 |
|
Metadata | EventIdentifier | VARCHAR(64) | A unique ID associated with each business event. | ALWAYS | 70b1c86d-d06f-4c93-bab2-0e938a4ef768 |
|
Metadata | EventItemId | VARCHAR(64) | An ID included with each business event that identifies the tenant and Claim ID or Dispute ID associated with the event. | ALWAYS | qvo-stg|2302030002D |
|