Fields
Data Category Event Field/Column Name Data Type Description Applicability Sample Value Notes Key TenantId VARCHAR(32) Unique ID associated with each Quavo client. ALWAYS qvo-stg Key ClientId VARCHAR(64) A unique ID representing a single client. ALWAYS Default Key ClaimId VARCHAR(32) Unique ID associated with a claim. Format: YYMMDD<Ordinal Number>"C" Example: 2405230003C ALWAYS 2306060014C Key DisputeId VARCHAR(32) Unique ID associated with a disputed transaction. Format: YYMMDD#####"D" ALWAYS 2306050001D Key ENTRYIDENTIFIER VARCHAR(64) Unique ID associated with an accounting entry. ALWAYS e5199543-c6b2-4cb6-937e-b278ca95979b Key StepIdentifier VARCHAR(64) Unique ID associated with an accounting step. A step is one side of an accounting entry. 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) For accounting, this represents the purpose of the accounting entry and typically coincides with the name of the accounting rule. ALWAYS Provisional Credit Accounting Details DEBITCREDIT VARCHAR(16) Specifies if the accounting entry was a debit or a credit. ALWAYS Debit, Credit Accounting Details COLLECTIONNAME VARCHAR(64) A group of related accounts, such as Account Holder, Merchant and Suspense. ALWAYS Accountholder, Merchant, Loss, Suspense Accounting Details PERFORMEDBYOPERATORID VARCHAR(128) The unique ID of the operator that performed an action. ALWAYS Metadata PERFORMEDON TIMESTAMP_NTZ(9) Datetime an action was performed. ALWAYS 2023-09-09 21:00:00 Accounting Details EXECUTEDBYOPERATORID VARCHAR(128) Datetime an action was performed. CONDITIONAL Will be populated once accounting entry has been executed. Accounting Details EXECUTEDON TIMESTAMP_NTZ(9) Datetime an action was executed. CONDITIONAL 2023-08-16 17:48:47.709 Will be populated once accounting entry has been executed. Accounting Details ExecutionMethod VARCHAR(32) Represents the process used to complete an accounting action, such as "Auto", "Manual", or "Tracking Only". 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 123456789 Applicability depends on accounting plan configuration. Accounting Details IsManualEntry BOOLEAN An accounting entry that is performed by a user in the Accounting tool. CONDITIONAL TRUE Applicable when the accounting entry is entered by a user instead of generated by the system. Metadata EventDateTime TIMESTAMP_NTZ(9) The datetime that the event was recorded. ALWAYS 2023-09-09 21:00:00 Metadata EventIdentifier VARCHAR(64) A unique ID associated with each business event. ALWAYS 70b1c86d-d06f-4c93-bab2-0e938a4ef768 Metadata EventItemId VARCHAR(64) An ID included with each business event that identifies the tenant and Claim ID or Dispute ID associated with the event. ALWAYS qvo-stg|cb7f68e3-1fb1-49e8-a683-5232cf6992ce