Data Category
Event Field/Column Name
Data Type
Description
Applicability
Sample Value
Notes
Key
TenantId
VARCHAR(32)
glossary_description false
ALWAYS
qvo-stg
Key
ClientId
VARCHAR(64)
glossary_description false
ALWAYS
Default
Key
ClaimId
VARCHAR(32)
glossary_description false
ALWAYS
2306060014C
Key
DisputeId
VARCHAR(32)
glossary_description false
ALWAYS
2306050001D
Key
ENTRYIDENTIFIER
VARCHAR(64)
glossary_description false
ALWAYS
e5199543-c6b2-4cb6-937e-b278ca95979b
Key
StepIdentifier
VARCHAR(64)
glossary_description false
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_description false
ALWAYS
Provisional Credit
Accounting Details
DEBITCREDIT
VARCHAR(16)
168a5d47-cc7d-4afe-859a-d32dcfda4015glossary_description false
ALWAYS
Debit, Credit
Accounting Details
COLLECTIONNAME
VARCHAR(64)
glossary_description false
ALWAYS
Accountholder, Merchant, Loss, Suspense
Accounting Details
PERFORMEDBYOPERATORID
VARCHAR(128)
12b0df20-31b4-40de-8ffd-59f2151179feglossary_description false
ALWAYS
devan.robertson@quavo.com
Metadata
PERFORMEDON
TIMESTAMP_NTZ(9)
glossary_description false
ALWAYS
2023-09-09 21:00:00
Accounting Details
EXECUTEDBYOPERATORID
VARCHAR(128)
glossary_description false
CONDITIONAL
devan.robertson@quavo.com
Will be populated once accounting entry has been executed.
Accounting Details
EXECUTEDON
TIMESTAMP_NTZ(9)
glossary_description false
CONDITIONAL
2023-08-16 17:48:47.709
Will be populated once accounting entry has been executed.
Accounting Details
ExecutionMethod
VARCHAR(32)
glossary_description false
ALWAYS CONDITIONAL
AUTO, BATCH, MANUAL, TrackingOnly
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.03. Applicability 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_description false
ALWAYS
2023-09-09 21:00:00
Metadata
EventIdentifier
VARCHAR(64)
glossary_description false
ALWAYS
70b1c86d-d06f-4c93-bab2-0e938a4ef768
Metadata
EventItemId
VARCHAR(64)
glossary_description false
ALWAYS
qvo-stg|cb7f68e3-1fb1-49e8-a683-5232cf6992ce