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 | Tenant | VARCHAR(64) | A tenant is a Quavo customer that uses QFD. Each tenant is assigned a unique Tenant ID. | ALWAYS | Default | |
Key | ClientId | VARCHAR(64) | A unique ID representing a single client. | ALWAYS | Default | |
Key | Client | VARCHAR(64) | A client is a Quavo customer that uses QFD through a relationship with a Quavo tenant. Each client is assigned a unique Client ID. | ALWAYS | Default | |
Claim Details | ClaimType | VARCHAR(64) | See Transaction Type. | CONDITIONAL | Card-Pinless | |
Claim Details | ClaimCategory | VARCHAR(64) | General categorization of the claim. For a more precise description, see Claim Reason. | CONDITIONAL | Fraud | |
Claim Details | ClaimReason | VARCHAR(64) | Identifies the specific reason associated with the claim. | CONDITIONAL | Stolen | |
Card Details | CardType | VARCHAR(16) | Bank Identification Number (BIN) is the first 4-8 digits of a payment card that identifies the issuing institution. | CONDITIONAL | Debit | |
Card Details | BIN | VARCHAR(8) | Bank Identification Number (BIN) is the first 4-8 digits of a payment card that identifies the issuing institution. | CONDITIONAL | 412356, 41235678 | |
Claim Details | ClaimStatusSummary | VARCHAR | A summarized version of Claim Status. Abandoned and withdrawn claims have a value of "Other". | ALWAYS | Open | |
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 | 2306060014D | |
Accounting Details | EntryCategory | VARCHAR(64) | Summarizes the type of accounting entry based on the account collection. | ALWAYS | GL Entry | |
Accounting Details | DebitCredit | VARCHAR | Specifies if the accounting entry was a debit or a credit. | ALWAYS | ||
Accounting Details | Collection | VARCHAR(64) | A group of related accounts, such as Account Holder, Merchant and Suspense. | 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) | 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 | Amount | NUMBER(9,2) | Amount of the accounting entry performed. | ALWAYS | 123.23 | |
Accounting Details | PerformedOn | TIMESTAMP_NTZ(9) | Datetime an action was performed. | ALWAYS | 2023-09-09 21:00:00 | |
Accounting Details | PerformedBy | VARCHAR | Name of the user that performed the action. | ALWAYS | D. Robertson | |
Accounting Details | ExecutedOn | TIMESTAMP_NTZ(9) | Datetime an action was executed. | ALWAYS | 2023-09-09 21:00:00 | |
Accounting Details | ExecutedBy | VARCHAR | The name associated with the operator that executed an action. | ALWAYS | D. Robertson | |
Accounting Details | Method | VARCHAR(32) | Represents the process used to complete an accounting action, such as "Auto", "Manual", or "Tracking Only". | ALWAYS | AUTO | |
Accounting Details | IsManualEntry | BOOLEAN | An accounting entry that is performed by a user in the Accounting tool. | CONDITIONAL | TRUE | Available in 24.01.03. |
Transaction Details | TransactionDate | TIMESTAMP_NTZ(9) | The date of the transaction, as provided by the system of record. This generally represents the Posting Date. | ALWAYS | 2023-09-09 21:00:00 | |
Transaction Details | TransactionPostingDate | TIMESTAMP_NTZ(9) | The date the transaction posted to the customer/member account. | ALWAYS | 2023-09-09 21:00:00 | |
Transaction Details | MCC | VARCHAR | Also referred to as "MCC", this 4-digit code represents the type of goods or services a business offers. | CONDITIONAL | 5532 | |
Transaction Details | MerchantName | VARCHAR | Name of the business providing goods or services, as provided by the system of record. | CONDITIONAL | AMAZON | |
Transaction Details | AcquirerReferenceNumber | VARCHAR | A unique number assigned to a credit card transaction as it moves through the payment flow. | CONDITIONAL | 24055233349083742325779 |
General
Content
Integrations