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 | Tenant | VARCHAR(64) | | Multiexcerpt include macro |
|---|
| macro_uuid | 92aefef2-6d9d-4064-a29c-4aff6b6b5512 |
|---|
| name | glossary_description |
|---|
| templateData | eJyLjgUAARUAuQ== |
|---|
| page | Tenant |
|---|
| addpanel | false |
|---|
|
| ALWAYS | Default | |
Key | ClientId | VARCHAR(64) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Client ID |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | Default | |
Key | Client | VARCHAR(64) | | Multiexcerpt include macro |
|---|
| macro_uuid | 92aefef2-6d9d-4064-a29c-4aff6b6b5512 |
|---|
| name | glossary_description |
|---|
| templateData | eJyLjgUAARUAuQ== |
|---|
| page | Client |
|---|
| addpanel | false |
|---|
|
| ALWAYS | Default | |
Claim Details | ClaimType | VARCHAR(64) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Claim Type |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | Card-Pinless | |
Claim Details | ClaimCategory | VARCHAR(64) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Claim Category |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | Fraud | |
Claim Details | ClaimReason | VARCHAR(64) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Claim Reason |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | Stolen | |
Card Details | CardType | VARCHAR(16) | | Multiexcerpt include |
|---|
| macro_uuid | 97e89f13-1c2e-41c7-925f-3c97f32515db |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | BIN |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | Debit | |
Card Details | BIN | VARCHAR(8) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | BIN |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | 412356, 41235678 | |
Claim Details | ClaimStatusSummary | VARCHAR | | Multiexcerpt include macro |
|---|
| macro_uuid | 42e8928e-91ea-4e36-ab6b-14f321420321 |
|---|
| name | glossary_description |
|---|
| templateData | eJyLjgUAARUAuQ== |
|---|
| page | Claim Status SummaryType |
|---|
| addpanel | false |
|---|
|
| ALWAYS | Open | |
Key | ClaimId | VARCHAR(32) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Claim ID |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | 2306060014C | |
Key | DisputeId | VARCHAR(32) | | Multiexcerpt include macro |
|---|
| macro_uuid | a3e31307-8cb9-40d8-8eef-f74f27879680 |
|---|
| name | glossary_description |
|---|
| templateData | eJyLjgUAARUAuQ== |
|---|
| page | Dispute ID |
|---|
| addpanel | false |
|---|
|
| ALWAYS | 2306060014D | |
Accounting Details | EntryCategory | VARCHAR(64) | | Multiexcerpt include macro |
|---|
| macro_uuid | 52af465a-208b-4348-b39e-0a5905e62de1 |
|---|
| name | glossary_description |
|---|
| templateData | eJyLjgUAARUAuQ== |
|---|
| page | Entry Category |
|---|
| addpanel | false |
|---|
|
| ALWAYS | GL Entry | |
Accounting Details | DebitCredit | VARCHAR | | Multiexcerpt include macro |
|---|
| macro_uuid | 8d5be858-6e38-4369-85ea-632a2e17aba0 |
|---|
| name | glossary_description |
|---|
| templateData | eJyLjgUAARUAuQ== |
|---|
| page | Entry Type |
|---|
| addpanel | false |
|---|
|
| ALWAYS | | |
Accounting Details | Collection | VARCHAR(64) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Collection |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | Accountholder, Merchant, Loss, Suspense | |
Accounting Details | Account | VARCHAR(128) | Account number associated with the account being debited or credited. Will be obfuscated it the account number is a full card number. | CONDITIONAL | 123456789 | Available in 24.01.03. |
Accounting Details | Reason | VARCHAR(64) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Reason |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | Provisional Credit | |
Accounting Details | Amount | NUMBER(9,2) | Amount of the accounting entry performed. | ALWAYS | 123.23 | |
Accounting Details | PerformedOn | TIMESTAMP_NTZ(9) | | Multiexcerpt include macro |
|---|
| macro_uuid | 08ffa65b-3984-48fd-8b68-f9ad10086a67 |
|---|
| name | glossary_description |
|---|
| templateData | eJyLjgUAARUAuQ== |
|---|
| page | Performed On |
|---|
| addpanel | false |
|---|
|
| ALWAYS | 2023-09-09 21:00:00 | |
Accounting Details | PerformedBy | VARCHAR | | Multiexcerpt include macro |
|---|
| macro_uuid | eb66bbb2-df4a-4134-b366-9bb3364f77a4 |
|---|
| name | Glossary Definition |
|---|
| templateData | eJyLjgUAARUAuQ== |
|---|
| page | Performed By |
|---|
| addpanel | false |
|---|
|
| ALWAYS | D. Robertson | |
Accounting Details | ExecutedOn | TIMESTAMP_NTZ(9) | | Multiexcerpt include macro |
|---|
| macro_uuid | 2edc5ab3-925d-4e83-a1f1-07c8103607e3 |
|---|
| name | glossary_description |
|---|
| templateData | eJyLjgUAARUAuQ== |
|---|
| page | Executed On |
|---|
| addpanel | false |
|---|
|
| ALWAYS | 2023-09-09 21:00:00 | |
Accounting Details | ExecutedBy | VARCHAR | | Multiexcerpt include macro |
|---|
| macro_uuid | f4a1e63c-bf44-40f8-a9d2-23384f572eac |
|---|
| name | glossary_description |
|---|
| templateData | eJyLjgUAARUAuQ== |
|---|
| page | Executed By |
|---|
| addpanel | false |
|---|
|
| ALWAYS | D. Robertson | |
Accounting Details | Method | VARCHAR(32) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Execution Method |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | AUTO | |
Accounting Details | IsManualEntry | BOOLEAN | | Multiexcerpt include macro |
|---|
| macro_uuid | c683dd99-4952-42c9-8008-b9e76d7184e1 |
|---|
| name | glossary_description |
|---|
| templateData | eJyLjgUAARUAuQ== |
|---|
| page | Manual Accounting Entry |
|---|
| addpanel | false |
|---|
|
| CONDITIONAL | TRUE | Available in 24.01.03. |
Transaction Details | TransactionDate | TIMESTAMP_NTZ(9) | | Multiexcerpt include macro |
|---|
| macro_uuid | 4066f080-3658-49c9-a4a5-cdf10a8a03bd |
|---|
| name | glossary_description |
|---|
| templateData | eJyLjgUAARUAuQ== |
|---|
| page | Transaction Date |
|---|
| addpanel | false |
|---|
|
| ALWAYS | 2023-09-09 21:00:00 | |
Transaction Details | TransactionPostingDate | TIMESTAMP_NTZ(9) | | Multiexcerpt include macro |
|---|
| macro_uuid | b4365c15-9144-4265-85e5-510317188c26 |
|---|
| name | glossary_description |
|---|
| templateData | eJyLjgUAARUAuQ== |
|---|
| page | Posting Date |
|---|
| addpanel | false |
|---|
|
| ALWAYS | 2023-09-09 21:00:00 | |
Transaction Details | MCC | VARCHAR | | Multiexcerpt include macro |
|---|
| macro_uuid | 94a581c9-d2a9-4b55-be05-89bac2e9ed2f |
|---|
| name | glossary_description |
|---|
| templateData | eJyLjgUAARUAuQ== |
|---|
| page | Merchant Category Code |
|---|
| addpanel | false |
|---|
|
| CONDITIONAL | 5532 | |
Transaction Details | MerchantName | VARCHAR | | Multiexcerpt include macro |
|---|
| macro_uuid | 2212bf12-3696-4c1f-a2f1-b16847602071 |
|---|
| name | glossary_description |
|---|
| templateData | eJyLjgUAARUAuQ== |
|---|
| page | Merchant Name |
|---|
| addpanel | false |
|---|
|
| CONDITIONAL | AMAZON | |
Transaction Details | AcquirerReferenceNumber | VARCHAR | | Multiexcerpt include macro |
|---|
| macro_uuid | 77a74eda-6297-45e5-ae03-d8fd9171b510 |
|---|
| name | glossary_description |
|---|
| templateData | eJyLjgUAARUAuQ== |
|---|
| page | Acquirer Reference Number |
|---|
| addpanel | false |
|---|
|
| CONDITIONAL | 24055233349083742325779 | |
