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 | |
Dispute Details | Status | VARCHAR(32) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Status Work |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | Open-ProcessLiability | |
Dispute Details | StatusChangeDateTime | TIMESTAMP_NTZ(9) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | STATUSCHANGEDATETIME |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | 2023-09-09 21:00:00 | |
Dispute Details | DisputeAmount | NUMBER(9,2) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Dispute Amount |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | 185.00 | |
Transaction Details | TransactionId | VARCHAR(128) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Transaction ID |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | ABC123456789 | |
Transaction Details | Amount | NUMBER(9,2) | Amount of the transaction. | ALWAYS | 185.00 | |
Transaction Details | AmountPosted | NUMBER(9,2) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Posted Amount |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | 185.00 | |
Transaction Details | AuthCode | VARCHAR(32) | | Multiexcerpt include |
|---|
| macro_uuid | de23ee9f-1394-4295-aa2b-12a094417afa |
|---|
| templateData | eJyLjgUAARUAuQ== |
|---|
| MultiExcerptName | glossary_description |
|---|
| addpanel | false |
|---|
| PageWithExcerpt | Authorization Code |
|---|
|
| CONDITIONAL | 855410 | Available in 24.01.03. |
Transaction Details | IsManualTransaction | BOOLEAN | Indicates whether the transaction information was entered manually by the intake user. | CONDITIONAL | TRUE | Available in 24.01.03. |
Transaction Details | TransactionDate | DATE | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Transaction Date |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | 2023-11-11 | |
Transaction Details | PostingDate | DATE | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Posting Date |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | 2023-11-12 | |
Transaction Details | AcquirerNetwork | VARCHAR(64) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Network |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | VISA | |
Transaction Details | AcquirerReferenceNumber | VARCHAR(32) | | CONDITIONAL | | |
Transaction Details | TransactionType | VARCHAR(64) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Transaction Type |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | Card - Pinless | |
Transaction Details | AuthorizationStatus | VARCHAR(32) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Authorization Status |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | Posted | |
Transaction Details | Description | VARCHAR(256) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Transaction Description |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | GOOGLE *YouTube g.co/helppay#CAUS | |
Transaction Details | MerchantCategoryCode | VARCHAR(6) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Merchant Category Code |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | 4829 | |
Transaction Details | MerchantName | VARCHAR(256) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Merchant Name |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | GOOGLE *YouTube | |
Transaction Details | POSEntryMode | VARCHAR(32) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | POS Entry Mode |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | 05 | |
Dispute Details | HasChargebackRights | BOOLEAN | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | HASCHARGEBACKRIGHTS |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | FALSE | |
Dispute Details | IsChargebackSubmitted | BOOLEAN | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | ISCHARGEBACKSUBMITTED |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | FALSE | |
Dispute Details | OriginalDisputeAmount | NUMBER(9,2) | | Multiexcerpt include |
|---|
| macro_uuid | 3f845230-765d-4312-9e52-3e4b70cc0e1f |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | NEXTRECOVERYDATETIME |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | 185.00 | Available in 24.01.03. |
Dispute Details | NextRecoveryDateTime | TIMESTAMP_NTZ(9) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | NEXTRECOVERYDATETIME |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | 2023-09-09 21:00:00 | |
Accounting Details | AccountHolderTotal | NUMBER(9,2) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Accountholder Balance |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | 185.00 | |
Accounting Details | MerchantTotal | NUMBER(9,2) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Merchant Balance |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | 185.00 | |
Accounting Details | LossTotal | NUMBER(9,2) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Loss Balance |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | 185.00 | |
Dispute Details | Decision | VARCHAR(64) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Decision |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | Deny | |
Dispute Details | DenyReason | VARCHAR(64) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Deny Reason |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | No Error | |
Dispute Details | DenySubReason | VARCHAR(64) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Deny Sub Reason |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | Out of Timeframe | |
Dispute Details | DenyDebitDate | DATE | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Deny Debit Date |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | 2023-12-06 | |
Dispute Details | InvestigationCompleteDateTime | TIMESTAMP_NTZ(9) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | INVESTIGATIONCOMPLETEDATETIMEInvestigation Completed Date |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | 2023-11-28 17:32:46.625 | |
Dispute Details | CustomerFinalProcessingDateTime | TIMESTAMP_NTZ(9) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Customer Final Processing Date |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | 2023-11-28 17:32:46.625 | |
Dispute Details | ResolvedDateTime | TIMESTAMP_NTZ(9) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Resolution Date |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | 2023-11-28 17:32:46.625 | |
Dispute Details | LastReopenDateTime | TIMESTAMP_NTZ(9) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | LASTREOPENDATETIME |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | 2023-11-28 17:32:46.625 | |
Dispute Details | DisputeStatusDateTime | TIMESTAMP_NTZ(9) | | CONDITIONAL | 2023-11-28 17:32:46.625 | |
Dispute Details | IsAutoDenyLetterSuppressed | BOOLEAN | | CONDITIONAL | TRUE | |
Dispute Details | IsAutoPaidLetterSuppressed | BOOLEAN | | CONDITIONAL | TRUE | |
Dispute Details | IsAutoPCLetterSuppressed | BOOLEAN | | CONDITIONAL | TRUE | |
Dispute Details | IsReopened | BOOLEAN | | CONDITIONAL | FALSE | |
Metadata | CreateDateTime | TIMESTAMP_NTZ(9) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | CREATEDATETIME |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | 2023-09-09 21:00:00 | |
Metadata | SaveDateTime | TIMESTAMP_NTZ(9) | | ALWAYS | 2023-09-09 21:00:00 | |
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 | |
