Data Category | Event Field/Column Name | Data Type | Description | Applicability | Sample Value | Notes |
---|
Key | TenantId | VARCHAR(32) | glossary_descriptionfalse | ALWAYS | qvo-stg | |
Key | ClientId | VARCHAR(64) | glossary_descriptionfalse | ALWAYS | Default | |
Key | ClaimId | VARCHAR(32) | glossary_descriptionfalse | ALWAYS | 2306060014C | |
Key | DisputeId | VARCHAR(32) | glossary_descriptionfalse | ALWAYS | 2306050001D | |
Key | ENTRYIDENTIFIER | VARCHAR(64) | glossary_descriptionfalse | ALWAYS | e5199543-c6b2-4cb6-937e-b278ca95979b | |
Key | StepIdentifier | VARCHAR(64) | glossary_descriptionfalse | ALWAYS | cb7f68e3-1fb1-49e8-a683-5232cf6992ce | |
Accounting Details | AMOUNT | NUMBER(9,2) | Amount of the accounting entry performed. | ALWAYS | 123.23 | |
Accounting Details | REASON | VARCHAR(64) | glossary_descriptionfalse | ALWAYS | Provisional Credit | |
Accounting Details | DEBITCREDIT | VARCHAR(16) | 168a5d47-cc7d-4afe-859a-d32dcfda4015glossary_descriptionfalse | ALWAYS | Debit, Credit | |
Accounting Details | COLLECTIONNAME | VARCHAR(64) | glossary_descriptionfalse | ALWAYS | Accountholder, Merchant, Loss, Suspense | |
Accounting Details | PERFORMEDBYOPERATORID | VARCHAR(128) | 12b0df20-31b4-40de-8ffd-59f2151179feglossary_descriptionfalse | ALWAYS | devan.robertson@quavo.com | |
Metadata | PERFORMEDON | TIMESTAMP_NTZ(9) | glossary_descriptionfalse | ALWAYS | 2023-09-09 21:00:00 | |
Accounting Details | EXECUTEDBYOPERATORID | VARCHAR(128) | glossary_descriptionfalse | CONDITIONAL | devan.robertson@quavo.com | Will be populated once accounting entry has been executed. |
Accounting Details | EXECUTEDON | TIMESTAMP_NTZ(9) | glossary_descriptionfalse | CONDITIONAL | 2023-08-16 17:48:47.709 | Will be populated once accounting entry has been executed. |
Accounting Details | ExecutionMethod | VARCHAR(32) | glossary_descriptionfalse | ALWAYS | AUTOCONDITIONAL | Auto, Manual, Tracking Only | Will be populated once accounting entry has been executed. |
Accounting Details | AccountNumber | 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 | 123456789Available | in 24.01.03Applicability depends on accounting plan configuration. |
Accounting Details | IsManualEntry | BOOLEAN | c683dd99-4952-42c9-8008-b9e76d7184e1glossary_descriptioneJyLjgUAARUAuQ==false | CONDITIONAL | TRUEAvailable in 24.01.03 | Applicable when the accounting entry is entered by a user instead of generated by the system. |
Metadata | EventDateTime | TIMESTAMP_NTZ(9) | glossary_descriptionfalse | ALWAYS | 2023-09-09 21:00:00 | |
Metadata | EventIdentifier | VARCHAR(64) | glossary_descriptionfalse | ALWAYS | 70b1c86d-d06f-4c93-bab2-0e938a4ef768 | |
Metadata | EventItemId | VARCHAR(64) | glossary_descriptionfalse | ALWAYS | qvo-stg|cb7f68e3-1fb1-49e8-a683-5232cf6992ce | |