Data Category | Event Field/Column Name | Data Type | Description | Applicability | Sample Value | Notes |
|---|
Key | TenantId | VARCHAR(32) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Tenant ID |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | qvo-stg | |
Key | ClientId | VARCHAR(64) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Client ID |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | Default | |
Key | ClaimId | VARCHAR(32) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Claim ID |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | 2306060014C | |
Key | DisputeId | VARCHAR(32) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Dispute ID |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | 2306050001D | |
Rejection Details | TransactionDate | DATE | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Transaction Date |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | 2023-06-24 | |
Rejection Details | PostingDate | DATE | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Posting Date |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | 2023-06-25 | |
Rejection Details | Description | VARCHAR(256) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Transaction Description |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | CASH APP*VISA MONEY TRANS | |
Rejection Details | Amount | NUMBER(9,2) | The amount of the transaction. | ALWAYS | 11.00 | |
Rejection Details | RecoveryAmount | NUMBER(9,2) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Chargeback Amount |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | 11.00 | |
Rejection Details | Network | VARCHAR(32) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Network |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | VISA | |
Rejection Details | RejectReasonCodeList[].Key/REASONCODEKEY | VARCHAR(64) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Reject Code |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | Mastercard: ReasonCode (e.g. "INVALID_REQUEST") Visa: Code (e.g. "E-200100002")
| |
Rejection Details | RejectReasonCodeList[].Value/REASONCODEVALUE | VARCHAR(128) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Reject Message |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | Mastercard: (e.g. "First Chargeback failed: Chargeback Amount should not be less than OT Amount") Visa: (e.g. "One or more required fields are missing. Please correct the following errors:ChipOnCard")
| (where applicable) |
Rejection Details | PerformedById | VARCHAR(128) | User that recorded the reject. | ALWAYS | devan.robertson@quavo.com | |
Rejection Details | RejectCode | VARCHAR(64) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Reject Code |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | Mastercard: ReasonCode (e.g. "INVALID_REQUEST") Visa: Code (e.g. "E-200100002")
| |
Rejection Details | RejectMessage | VARCHAR(256) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Reject Message |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | Mastercard: (e.g. "First Chargeback failed: Chargeback Amount should not be less than OT Amount") Visa: (e.g. "One or more required fields are missing. Please correct the following errors:ChipOnCard")
| |
Rejection Details | RejectType | VARCHAR(16) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Reject Type |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | "Service Failure", "Reject" | For Visa, rejects are handled via service failure message ("Service Failure"). For Mastercard, a queue item is generated ("Reject"). |
Metadata | EventDateTime | TIMESTAMP_NTZ(9) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | EVENTDATETIME |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | 2023-09-09 21:00:00 | |
Metadata | EventIdentifier | VARCHAR(64) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | EVENTIDENTIFIER |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | 70b1c86d-d06f-4c93-bab2-0e938a4ef768 | |
Metadata | EventItemId | VARCHAR(64) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | EVENTITEMID |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | qvo-stg|2302030002D | |