When an accounting record is created or executed in QFD, an event is generated. The event includes all important details of the accounting adjustment. This information is useful for reconciling GLs, as well as measuring compliance to regulatory requirements.
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, 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 | 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 |
|